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

		            
  1using System;
  2using System.Collections.Generic;
  3
  4using System.Data;
  5
  6
  7using MyShop.DALFactory;
  8using MyShop.IDAL;
  9using MyShop.Model;
 10
 11namespace MyShop.BLL
 12...{
 13    public class Category
 14    ...{
 15        private ICategory dal = DataAccess.CreateCategory();
 16        private int _id;
 17
 18        public Category()
 19        ...{
 20
 21        }
 22
 23        public Category(int id)
 24        ...{
 25            this._id = id;
 26        }
 27
 28        ICategory member#region ICategory member
 29
 30        protected int Add(CategoryInfo model)
 31        ...{
 32            if (model == null)
 33                return 0;
 34            return dal.Add(model);
 35        }
 36        public int Delete(string filter)
 37        ...{
 38            if (string.IsNullOrEmpty(filter))
 39                return 0;
 40            return dal.Delete(filter);
 41        }
 42
 43        public bool Exist(string filter)
 44        ...{
 45            filter = filter.Trim();
 46            if (string.IsNullOrEmpty(filter))
 47                return false;
 48            return dal.Exist(filter);
 49        }
 50
 51        public DataSet GetDataSet()
 52        ...{
 53            return dal.GetDataSet();
 54        }
 55        public DataSet GetDataSet(string filter)
 56        ...{
 57            filter = filter.Trim();
 58            if (string.IsNullOrEmpty(filter))
 59                return null;
 60            return dal.GetDataSet(filter);
 61        }
 62        public DataSet GetDataSet(int categoryId)
 63        ...{
 64            if (categoryId <= 0)
 65                return null;
 66            string filter = " categoryId=" + categoryId;
 67            return GetDataSet(filter);
 68        }
 69        public CategoryInfo GetModel(DataRow dr)
 70        ...{
 71            if (dr == null)
 72                return null;
 73            return dal.GetModel(dr);
 74        }
 75
 76        private DataSet Query(string sql)
 77        ...{
 78            sql = sql.Trim();
 79            if (string.IsNullOrEmpty(sql))
 80                return null;
 81            return dal.Query(sql);
 82        }
 83
 84        protected int Update(CategoryInfo model, string filter)
 85        ...{
 86            if (model == null)
 87                return 0;
 88            filter = filter.Trim();
 89            if (string.IsNullOrEmpty(filter))
 90                return 0;
 91            return dal.Update(model, filter);
 92        }
 93        //-------------------------
 94        #endregion
 95
 96        common#region common
 97
 98        public int Add(CategoryInfo model, out string msg)
 99        ...{
100            msg = "";
101            if (model == null)
102            ...{
103                msg = msg + "<li>数据不能为空</li>";
104                return 0;
105            }
106
107            bool isErr = false;
108
109            if (string.IsNullOrEmpty(model.CategoryName.Trim()))
110            ...{
111                msg = msg + "请输入商品小类名称";
112                isErr = true;
113            }
114
115            if (isErr)
116                return 0;
117
118            int count = 0;
119            count = Add(model);
120            if (count == 0)
121                msg = "<li>系统发生错误,请重新添加!</li>";
122            if (count == 1)
123                msg = "<li>添加成功!</li>";
124            return count;
125        }
126
127        /**//// <summary>
128        /// 所有类型，不区分isDisabled
129        /// </summary>
130        /// <param name="productKindId"></param>
131        /// <returns></returns>
132        public DataSet GetDataSetByProductKindId( int productKindId)
133        ...{
134            if (productKindId == 0 || string.IsNullOrEmpty(productKindId.ToString()))
135                return null;
136            string filter = "";
137            filter = " productKindId=" + productKindId;
138            return GetDataSet(filter);
139        }
140
141        /**//// <summary>
142        /// 所有类型，筛选掉禁用的isDisabled = 1的类别,order by OrderId
143        /// </summary>
144        /// <param name="productKindId"></param>
145        /// <returns></returns>
146        public DataSet GetDataSetByProductKindIdEnabled(int productKindId)
147        ...{
148            string filter = "";
149            filter = " [isDisabled] = 0 and productKindId=" + productKindId + " order by OrderId ";
150            return GetDataSet(filter);
151        }
152
153        public int Delete(int categoryId)
154        ...{
155            if (string.IsNullOrEmpty(categoryId.ToString()))
156                return 0;
157            string filer;
158            filer = " categoryId =" + categoryId;
159            return Delete(filer);
160        }
161        public int Update(CategoryInfo model)
162        ...{
163
164            if (model == null)
165            ...{
166                return 0;
167            }
168            string filter;
169            filter = " categoryId=" + model.CategoryId;
170            return Update(model, filter);
171        }
172
173        public CategoryInfo GetModel(int categoryId)
174        ...{
175            
176            DataSet dataset = new DataSet();
177            dataset = GetDataSet(" categoryId=" + categoryId);
178            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
179                return GetModel(dataset.Tables[0].Rows[0]);
180           return null;
181
182        }
183        #endregion    
184
185        以下过程要用Category category = new Category(id)实例化后才能进行调用#region 以下过程要用Category category = new Category(id)实例化后才能进行调用
186
187
188        property#region property
189
190        /**//// <summary>
191        /// 获取当前项目ID
192        /// </summary>
193        public int ID
194        ...{
195            get
196            ...{
197                return this._id;
198            }
199        }
200
201        /**//// <summary>
202        ///  获取调查项目的实体
203        /// </summary>
204        public CategoryInfo Model
205        ...{
206            get
207            ...{
208                return GetModel(this._id);
209            }
210            set
211            ...{
212                Update(value);
213            }
214        }
215
216        /**//// <summary>
217        /// 获取当前对象是否存在(数据库中有没有这条记录)
218        /// </summary>
219        public bool isExist
220        ...{
221            get 
222            ...{
223                return Model == null ? false : true;
224            }
225        }
226
227        #endregion
228
229        #endregion
230
231
232        后台管理#region 后台管理
233        public DataSet GetDataSetOrderByOrderId()
234        ...{
235            return GetDataSet(" [categoryId] > 0 Order by  OrderId  ");
236        }
237
238        /**//// <summary>
239        /// 启用或禁用
240        /// </summary>
241        /// <param name="productId"></param>
242        /// <param name="action">true  为设置禁用 false 为设置启用</param>
243        /// <returns></returns>
244        public int Disable(int categoryId, bool action)
245        ...{
246            CategoryInfo model = new  CategoryInfo();
247            model = GetModel(categoryId);
248            if (model == null)
249                return 0;
250
251            model.IsDisabled = (action == true) ? 1 : 0;
252            return Update(model);
253        }
254
255
256        /**//// <summary>
257        /// 检查名称是否存在
258        /// </summary>
259        /// <param name="typeName"></param>
260        /// <returns></returns>
261        public bool IsExist(string categoryName)
262        ...{
263            categoryName = Utils.ReplaceBadSQL(categoryName.Trim());
264            if (string.IsNullOrEmpty(categoryName))
265                return false;
266            string filter = " [categoryName]='" + categoryName + "'";
267
268            return Exist(filter);
269        }
270
271        /**//// <summary>
272        /// 快速搜索
273        /// </summary>
274        /// <param name="productKindId"></param>
275        /// <returns></returns>
276        public DataSet QuickSearch(int productKindId)
277        ...{
278            DataSet ds = new DataSet();
279            string filter = " [productkindId] =" + productKindId;
280            return GetDataSet(filter);
281        }
282
283        /**//// <summary>
284        /// 高级查询
285        /// </summary>
286        /// <param name="field"></param>
287        /// <param name="keywords"></param>
288        /// <returns></returns>
289        public DataSet KeywordsSearch(string field, string keywords)
290        ...{
291            field = Utils.ReplaceBadSQL(field.Trim().ToLower());
292            keywords = Utils.ReplaceBadSQL(keywords.ToLower().Trim());
293            if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords))
294                return null;
295            return dal.KeywordsSearch(field, keywords);
296        }
297
298
299        #endregion