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

		            
  1using System.Data;
  2
  3
  4using MyShop.DALFactory;
  5using MyShop.IDAL;
  6using MyShop.Model;
  7
  8namespace MyShop.BLL
  9...{
 10    public class ProductKinds
 11    ...{
 12        private IProductKinds dal = DataAccess.CreateProductKinds();
 13        private int _id;
 14        public ProductKinds()
 15        ...{
 16        }
 17
 18        public ProductKinds(int id)
 19        ...{
 20            this._id = id;
 21
 22        }
 23
 24        ICategory member#region ICategory member
 25
 26       public int Add(ProductKindsInfo model)
 27        ...{
 28            if (model == null)
 29                return 0;
 30            return dal.Add(model);
 31        }
 32        public int Delete(string filter)
 33        ...{
 34            if (string.IsNullOrEmpty(filter))
 35                return 0;
 36            return dal.Delete(filter);
 37        }
 38
 39        public bool Exist(string filter)
 40        ...{
 41            filter = filter.Trim();
 42            if (string.IsNullOrEmpty(filter))
 43                return false;
 44            return dal.Exist(filter);
 45        }
 46
 47        public DataSet GetDataSet()
 48        ...{
 49            return dal.GetDataSet();
 50        }
 51        public DataSet GetDataSet(string filter)
 52        ...{
 53            filter = filter.Trim();
 54            if (string.IsNullOrEmpty(filter))
 55                return null;
 56            return dal.GetDataSet(filter);
 57        }
 58        public DataSet GetDataSet(int ProductKindId)
 59        ...{
 60            if (ProductKindId <= 0)
 61                return null;
 62            string filter = " ProductKindId=" + ProductKindId;
 63            return GetDataSet(filter);
 64        }
 65
 66
 67        public DataSet GetDataSetEnabledOrderByOrderId()
 68        ...{
 69            string filter = " [IsDisabled] = 0   Order by  OrderId  ";
 70            return GetDataSet(filter);
 71        }
 72
 73        public ProductKindsInfo GetModel(DataRow dr)
 74        ...{
 75            if (dr == null)
 76                return null;
 77            return dal.GetModel(dr);
 78        }
 79
 80        private DataSet Query(string sql)
 81        ...{
 82            sql = sql.Trim();
 83            if (string.IsNullOrEmpty(sql))
 84                return null;
 85            return dal.Query(sql);
 86        }
 87
 88        protected int Update(ProductKindsInfo model, string filter)
 89        ...{
 90            if (model == null)
 91                return 0;
 92            filter = filter.Trim();
 93            if (string.IsNullOrEmpty(filter))
 94                return 0;
 95            return dal.Update(model, filter);
 96        }
 97        //-------------------------
 98        #endregion
 99
100        common#region common
101
102        public int Add(ProductKindsInfo model, out string msg)
103        ...{
104            msg = "";
105            if (model == null)
106            ...{
107                msg = msg + "<li>数据不能为空</li>";
108                return 0;
109            }
110
111            bool isErr = false;
112
113            if (string.IsNullOrEmpty(model.ProductKindName.Trim()))
114            ...{
115                msg = msg + "请输入商品种类名称";
116                isErr = true;
117            }
118
119            if (isErr)
120                return 0;
121
122            int count = 0;
123            count = Add(model);
124            if (count == 0)
125                msg = "<li>系统发生错误,请重新添加!</li>";
126            if (count == 1)
127                msg = "<li>添加成功!</li>";
128            return count;
129        }
130
131        public int Delete(int ProductKindId)
132        ...{
133            if (string.IsNullOrEmpty(ProductKindId.ToString()))
134                return 0;
135            string filer;
136            filer = " ProductKindId =" + ProductKindId;
137            return Delete(filer);
138        }
139        public int Update(ProductKindsInfo model)
140        ...{
141
142            if (model == null)
143            ...{
144                return 0;
145            }
146            string filter;
147            filter = " ProductKindId=" + model.ProductKindId;
148            return Update(model, filter);
149        }
150
151        public ProductKindsInfo GetModel(int ProductKindId)
152        ...{
153            DataSet dataset = new DataSet();
154            dataset = GetDataSet(" ProductKindId=" + ProductKindId);
155            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
156                return GetModel(dataset.Tables[0].Rows[0]);
157            return null;
158
159        }
160
161        #endregion
162
163        以下过程要用ProductKinds product = new ProductKinds(id)实例化后才能进行调用#region 以下过程要用ProductKinds product = new ProductKinds(id)实例化后才能进行调用
164
165
166        property#region property
167
168        /**//// <summary>
169        /// 获取当前项目ID
170        /// </summary>
171        public int ID
172        ...{
173            get
174            ...{
175                return this._id;
176            }
177        }
178
179        /**//// <summary>
180        ///  获取调查项目的实体
181        /// </summary>
182        public ProductKindsInfo Model
183        ...{
184            get
185            ...{
186                return GetModel(this._id);
187            }
188            set
189            ...{
190                Update(value);
191            }
192        }
193
194        /**//// <summary>
195        /// 获取当前对象是否存在(数据库中有没有这条记录)
196        /// </summary>
197        public bool isExist
198        ...{
199            get
200            ...{
201                return Model == null ? false : true;
202            }
203        }
204
205        #endregion
206
207        #endregion
208
209        后台管理#region 后台管理
210        public DataSet GetDataSetOrderByOrderId()
211        ...{
212            return GetDataSet(" productKindId > 0 Order by  OrderId  ");
213        }
214
215
216
217        /**//// <summary>
218        /// 检查名称是否存在
219        /// </summary>
220        /// <param name="typeName"></param>
221        /// <returns></returns>
222        public bool IsExist(string productKindName)
223        ...{
224            productKindName = Utils.ReplaceBadSQL(productKindName.Trim());
225            if (string.IsNullOrEmpty(productKindName))
226                return false;
227            string filter = " productKindName='" + productKindName + "'";
228
229            return Exist(filter);
230        }
231
232
233        #endregion
234
235
236    }
237}
238