当前文件路径：ClothesShop/IDAL/Iproduct.cs

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