当前文件路径：MyShop/BLL/DeliverType.cs

		            
  1using System;
  2using System.Collections.Generic;
  3
  4using System.Data;
  5
  6
  7using MyShop.DALFactory;
  8using MyShop.IDAL;
  9using MyShop.Model;
 10namespace MyShop.BLL
 11...{
 12    public  class DeliverType 
 13    ...{
 14        private IDeliverType dal = DataAccess.CreateDeliverType();
 15
 16        public DeliverType() ...{ }
 17
 18
 19
 20        IDeliverType member#region IDeliverType member
 21
 22        public int Add(DeliverTypeInfo model)
 23        ...{
 24            if (model == null)
 25                return 0;
 26            return dal.Add(model);
 27        }
 28        public int Delete(string filter)
 29        ...{
 30            if (string.IsNullOrEmpty(filter))
 31                return 0;
 32            return dal.Delete(filter);
 33        }
 34
 35        public bool Exist(string filter)
 36        ...{
 37            filter = filter.Trim();
 38            if (string.IsNullOrEmpty(filter))
 39                return false;
 40            return dal.Exist(filter);
 41        }
 42
 43        public DataSet GetDataSet()
 44        ...{
 45            return dal.GetDataSet();
 46        }
 47        public DataSet GetDataSet(string filter)
 48        ...{
 49            filter = filter.Trim();
 50            if (string.IsNullOrEmpty(filter))
 51                return null;
 52            return dal.GetDataSet(filter);
 53        }
 54
 55        public DeliverTypeInfo GetModel(DataRow dr)
 56        ...{
 57            if (dr == null)
 58                return null;
 59            return dal.GetModel(dr);
 60        }
 61
 62        private DataSet Query(string sql)
 63        ...{
 64            sql = sql.Trim();
 65            if (string.IsNullOrEmpty(sql))
 66                return null;
 67            return dal.Query(sql);
 68        }
 69
 70        public int Update(DeliverTypeInfo model, string filter)
 71        ...{
 72            if (model == null)
 73                return 0;
 74            filter = filter.Trim();
 75            if (string.IsNullOrEmpty(filter))
 76                return 0;
 77            return dal.Update(model, filter);
 78        }
 79        //-------------------------
 80        #endregion
 81
 82        common#region common
 83
 84        public int Add(DeliverTypeInfo model, out string msg)
 85        ...{
 86            msg = "";
 87            if (model == null)
 88            ...{
 89                msg = "<li>数据不能为空</li>";
 90                return 0;
 91            }
 92
 93            bool isErr = false;
 94
 95            if (string.IsNullOrEmpty(model.TypeName.Trim()))
 96            ...{
 97                msg = msg + "请输入送货方式名称";
 98                isErr = true;
 99            }
100
101            if (isErr)
102                return 0;
103
104            int count = 0;
105            count = Add(model);
106            if (count == 0)
107                msg = "<li>系统发生错误,请重新添加!</li>";
108            if (count == 1)
109                msg = "<li>添加成功!</li>";
110            return count;
111        }
112
113
114        public int Delete(int typeId)
115        ...{
116            if (string.IsNullOrEmpty(typeId.ToString()))
117                return 0;
118            string filer;
119            filer = " typeId =" + typeId;
120            return Delete(filer);
121        }
122
123        /**//// <summary>
124        /// 修改会员资料
125        /// </summary>
126        /// <param name="model"></param>
127        /// <returns></returns>
128        public int Update(DeliverTypeInfo model)
129        ...{
130            if (string.IsNullOrEmpty(model.TypeId.ToString()))
131                return 0;
132            string filter = "typeId = " + model.TypeId;
133            return Update(model, filter);
134        }
135
136        public DeliverTypeInfo GetModel(int typeId)
137        ...{
138            DataSet dataset = new DataSet();
139            dataset = GetDataSet(" typeId=" + typeId);
140            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
141                return GetModel(dataset.Tables[0].Rows[0]);
142            return null;
143        }
144
145        public DeliverTypeInfo GetModel(string typeName)
146        ...{
147            if (string.IsNullOrEmpty(typeName))
148                return null;
149            DataSet dataset = new DataSet();
150            dataset = GetDataSet(" typeName='" + typeName + "'");
151            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
152                return GetModel(dataset.Tables[0].Rows[0]);
153            return null;
154        }
155        #endregion
156
157        后台管理#region 后台管理
158        public DataSet GetDataSetOrderByOrderId()
159        ...{
160            return GetDataSet(" typeId > 0 Order by  OrderId  ");
161        }
162
163
164        /**//// <summary>
165        /// 把为typeId的记录改为默认,同时将其它记录改为不是默认
166        /// </summary>
167        /// <param name="typeId"></param>
168        /// <returns></returns>
169        public int MakeDefault(int typeId)
170        ...{
171            string filter = " [Isdefault] = 1 ";
172            DataSet dataset = new DataSet();
173            DeliverTypeInfo model = new DeliverTypeInfo();
174
175            dataset = GetDataSet(filter);
176            //把其它的改为不是默认
177            if (dataset.Tables[0].Rows.Count > 0)
178            ...{
179                for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
180                ...{
181                    model = GetModel(dataset.Tables[0].Rows[i]);
182                    model.IsDefault = 0;
183                    Update(model);
184                }
185            }
186
187            model = GetModel(typeId);
188            model.IsDefault = 1;
189            return Update(model);
190        }
191
192        /**//// <summary>
193        /// 检查送货方式名称是否存在
194        /// </summary>
195        /// <param name="typeName"></param>
196        /// <returns></returns>
197        public bool IsExist(string typeName)
198        ...{
199            typeName = Utils.ReplaceBadSQL(typeName.Trim());
200            if (string.IsNullOrEmpty(typeName))
201                return false;
202            string filter = " typeName='" + typeName + "'";
203
204            return Exist(filter);
205        }
206
207
208        #endregion
209
210    }
211}
212