当前文件路径：ClothesShop/BLL/product.cs

		            
  1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using ClothesShop.DALFactory;
  5using ClothesShop.IDAL;
  6using System.Data;
  7using System.Data.OleDb;
  8
  9namespace ClothesShop.BLL
 10...{
 11    public class product
 12    ...{
 13        private static readonly Iproduct pro = DataAccess.Createproduct();
 14
 15        /**//// <summary>
 16        /// 创建一个商品
 17        /// </summary>
 18        /// <param name="productname">商品名称</param>
 19        /// <param name="typeid_1">商品一级分类</param>
 20        /// <param name="typeid_2">商品二级分类</param>
 21        /// <param name="recommended">是否推荐</param>
 22        /// <param name="specials">是否特价</param>
 23        /// <param name="price">商品原价</param>
 24        /// <param name="userprice">会员价格</param>
 25        /// <param name="specialsprice">推荐价格</param>
 26        /// <param name="pointcount">点击数量</param>
 27        /// <param name="imagepath">图片路径</param>
 28        /// <param name="count">商品库存数量</param>
 29        /// <param name="count">销售数量</param>
 30        /// <param name="description">商品描述</param>
 31        /// <returns></returns>
 32        public int createproduct(string productname, int typeid_1, int typeid_2, bool recommended, bool specials, Double price,
 33            Double userprice, Double specialsprice, int pointcount, string imagepath, int count, int sellcount, string description)
 34        ...{
 35            return pro.createproduct(productname,typeid_1,typeid_2,recommended,specials,price,
 36                 userprice,specialsprice,pointcount, imagepath,count,sellcount,description);
 37        }
 38
 39        /**//// <summary>
 40        /// 删除一个商品
 41        /// </summary>
 42        /// <param name="productid"></param>
 43        /// <returns></returns>
 44        public int deleteproduct(int productid)
 45        ...{
 46            return pro.deleteproduct(productid);
 47        }
 48
 49        /**//// <summary>
 50        /// 更新一个商品
 51        /// </summary>
 52        /// <param name="productid">商品编号</param>
 53        /// <param name="productname">商品名称</param>
 54        /// <param name="typeid_1">商品一级分类</param>
 55        /// <param name="typeid_2">商品二级分类</param>
 56        /// <param name="recommended">是否推荐</param>
 57        /// <param name="specials">是否特价</param>
 58        /// <param name="price">商品原价</param>
 59        /// <param name="userprice">会员价格</param>
 60        /// <param name="specialsprice">推荐价格</param>
 61        /// <param name="pointcount">点击数量</param>
 62        /// <param name="imagepath">图片路径</param>
 63        /// <param name="count">商品库存数量</param>
 64        /// <param name="count">销售数量</param>
 65        /// <param name="description">商品描述</param>
 66        /// <returns></returns>
 67        public int updateproduct(int productid, string productname, int typeid_1, int typeid_2, bool recommended, bool specials, Double price,
 68            Double userprice, Double specialsprice, int pointcount, string imagepath, int count, int sellcount, string description)
 69        ...{
 70            return pro.updateproduct(productid, productname, typeid_1, typeid_2, recommended, specials, price,
 71                 userprice, specialsprice, pointcount, imagepath, count,sellcount, description);
 72        }
 73
 74        /**//// <summary>
 75        /// 根据参数查询商品
 76        /// </summary>
 77        /// <param name="typeid_1"></param>
 78        /// <param name="typeid_2"></param>
 79        /// <param name="productname"></param>
 80        /// <returns></returns>
 81        public DataTable productlist(int typeid_1, int typeid_2, string productname)
 82        ...{
 83            return pro.productlist(typeid_1,typeid_2,productname);
 84        }
 85
 86         /**//// <summary>
 87        /// 根据参数查询商品
 88        /// </summary>
 89        /// <param name="typeid_1"></param>
 90        /// <param name="typeid_2"></param>
 91        /// <param name="productname"></param>
 92        /// <param name="recommended"></param>
 93        /// <param name="specials"></param>
 94        /// <returns></returns>
 95        public DataTable selectproduct(int typeid_1, int typeid_2, string productname, int recommended, int specials)
 96        ...{
 97
 98            return pro.selectproduct(typeid_1,typeid_2,productname,recommended,specials);
 99        }
100
101        /**//// <summary>
102        ///获得一条商品纪录 
103        /// </summary>
104        /// <param name="productid"></param>
105        /// <returns></returns>
106        public DataRow getoneproduct(int productid)
107        ...{
108            return pro.getoneproduct(productid);
109        }
110
111        /**//// <summary>
112        /// 获得若干数量的新商品
113        /// </summary>
114        /// <returns></returns>
115        public DataTable getnewproductlist(int num)
116        ...{
117            return pro.getnewproductlist(num);
118        }
119
120        /**//// <summary>
121        /// 获得若干数量的特价商品
122        /// </summary>
123        /// <param name="num"></param>
124        /// <returns></returns>
125        public DataTable getspecialproductlist(int num)
126        ...{
127            return pro.getspecialproductlist(num);
128        }
129
130        /**//// <summary>
131        /// 获得若干数量的推荐商品
132        /// </summary>
133        /// <param name="num"></param>
134        /// <returns></returns>
135        public DataTable getrecommendedproductlist(int num)
136        ...{
137            return pro.getrecommendedproductlist(num);
138        }
139
140        /**//// <summary>
141        /// 获得若干数量的热卖商品
142        /// </summary>
143        /// <param name="num"></param>
144        /// <returns></returns>
145        public DataTable gethotsellproductlist(ref int num)
146        ...{
147            return pro.gethotsellproductlist(ref num);
148        }
149
150        /**//// <summary>
151        /// 获得若干数量的热门商品
152        /// </summary>
153        /// <param name="num"></param>
154        /// <returns></returns>
155        public DataTable getpointproductlist(ref int num)
156        ...{
157            return pro.getpointproductlist(ref num);
158        }
159
160        /**//// <summary>
161        ///更新商品的浏览数量 
162        /// </summary>
163        /// <param name="productid"></param>
164        public void updatepointnum(int productid)
165        ...{
166            pro.updatepointnum(productid);
167        }
168
169        /**//// <summary>
170        /// 获得新商品
171        /// </summary>
172        /// <returns></returns>
173        public DataTable getnewproduct()
174        ...{
175            return pro.getnewproduct();
176        }
177
178        /**//// <summary>
179        /// 获得特价商品
180        /// </summary>
181        /// <returns></returns>
182        public DataTable getspecialproduct()
183        ...{
184            return pro.getspecialproduct();
185        }
186
187        /**//// <summary>
188        /// 获得推荐商品
189        /// </summary>
190        /// <returns></returns>
191        public DataTable getrecommendedproduct()
192        ...{
193            return pro.getrecommendedproduct();
194        }
195
196        /**//// <summary>
197        /// 更新图片路径
198        /// </summary>
199        /// <param name="path"></param>
200        public int updatepic(string imagepath, int productid)
201        ...{
202            return pro.updatepic(imagepath,productid);
203        }
204
205        public DataTable searchproductlist(int type_1, int type_2, string productname, string price_1, string price_2)
206        ...{
207            return pro.searchproductlist(type_1,type_2,productname,price_1,price_2);
208        }
209    }
210}
211