当前文件路径：ClothesShop/OleDbDAL/type_2.cs

		            
  1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using System.Data;
  5using System.Data.OleDb;
  6using ClothesShop;
  7using ClothesShop.DBUtility;
  8
  9namespace ClothesShop.OleDbDAL
 10...{
 11    public class type_2: IDAL.Itype_2
 12    ...{
 13        /**//// <summary>
 14        /// 创建一个商品二级分类
 15        /// </summary>
 16        /// <param name="typeid_1"></param>
 17        /// <param name="typename"></param>
 18        /// <returns></returns>
 19        public int createtype_2(int typeid_1, string typename)
 20        ...{
 21            StringBuilder sb = new StringBuilder();
 22            sb.Append("insert into type_2 (typeid_1,typename) values (@typeid_1,@typename)");
 23            OleDbParameter[] param = 
 24                                    ...{
 25                                        OleDbHelper.GetParameter("@typeid_1",OleDbType.Integer,4,"typeid_1",typeid_1),
 26                                        OleDbHelper.GetParameter("@typename",OleDbType.Char,50,"typename",typename)
 27                                    };
 28            return OleDbHelper.ExecuteSql(sb.ToString(), param);
 29        }
 30
 31        /**//// <summary>
 32        /// 删除一个商品二级分类
 33        /// </summary>
 34        /// <param name="typeid_2"></param>
 35        /// <returns></returns>
 36        public int deletetype_2(int typeid_2)
 37        ...{
 38            StringBuilder sb = new StringBuilder();
 39            sb.Append("delete from type_2 where typeid_2=@typeid_2");
 40            OleDbParameter[] param = ...{ OleDbHelper.GetParameter("@typeid_2", OleDbType.Integer, 4, "typeid_2", typeid_2) };
 41            return OleDbHelper.ExecuteSql(sb.ToString(), param);
 42        }
 43
 44        /**//// <summary>
 45        /// 修改一个商品二级分类
 46        /// </summary>
 47        /// <param name="typeid_1"></param>
 48        /// <param name="typename"></param>
 49        /// <returns></returns>
 50        public int updatetype_2(int typeid_2 ,int typeid_1,string typename)
 51        ...{
 52            StringBuilder sb = new StringBuilder();
 53            sb.Append("update type_2 set typeid_1=@typeid_1,typename=@typename where typeid_2=@typeid_2");
 54            OleDbParameter[] param = 
 55                                   ...{ 
 56                                        OleDbHelper.GetParameter("@typeid_1",OleDbType.Integer,4,"typeid_1",typeid_1),
 57                                        OleDbHelper.GetParameter("@typename",OleDbType.Char,50,"typename",typename),
 58                                       OleDbHelper.GetParameter("@typeid_2",OleDbType.Integer,4,"typeid_2",typeid_2)
 59                                   };
 60            return OleDbHelper.ExecuteSql(sb.ToString(), param);
 61        }
 62
 63        /**//// <summary>
 64        /// 查询商品二级分类
 65        /// </summary>
 66        /// <param name="typeid_1"></param>
 67        /// <param name="typename"></param>
 68        /// <returns></returns>
 69        public DataTable type_2list(int typeid_1, string typename)
 70        ...{
 71            StringBuilder sb = new StringBuilder();
 72            sb.Append("SELECT type_1.typename as type_1name, type_2.typeid_1, type_2.typeid_2, type_2.typename as type_2name ");
 73            sb.Append("FROM type_1 INNER JOIN type_2 ON type_1.typeid_1 = type_2.typeid_1 where 1 = @index");
 74            List<OleDbParameter> list = new List<OleDbParameter>();
 75            list.Add(OleDbHelper.GetParameter("@index", OleDbType.Integer, 1));
 76            if (typeid_1 != 0)
 77            ...{
 78                list.Add(OleDbHelper.GetParameter("@typeid_1", OleDbType.Integer, 4, "typeid_1", typeid_1));
 79                sb.Append(" and type_2.typeid_1=@typeid_1");
 80            }
 81            if (typename != "")
 82            ...{
 83                list.Add(OleDbHelper.GetParameter("@typename", OleDbType.Char, 50, "typename", typename));
 84                sb.Append(" and type_2.typename like '%' + typename + '%'");
 85            }
 86            return OleDbHelper.ExecuteDt(sb.ToString(), list.ToArray());
 87        }
 88
 89        /**//// <summary>
 90        /// 分类是否存在
 91        /// </summary>
 92        /// <param name="typename"></param>
 93        /// <returns></returns>
 94        public bool IsExite(string typename)
 95        ...{
 96            StringBuilder sb = new StringBuilder();
 97            sb.Append("select typename from type_2 where typename=@typename");
 98            OleDbParameter[] param = 
 99                                   ...{ OleDbHelper.GetParameter("@typename",OleDbType.Char,50,"typename",typename)};
100            DataTable table = OleDbHelper.ExecuteDt(sb.ToString(), param);
101            return table.Rows.Count > 0 ? true : false;
102        }
103
104        /**//// <summary>
105        /// 根据类型ID获得类型名称
106        /// </summary>
107        /// <param name="typeid"></param>
108        /// <returns></returns>
109        public string gettypename(int typeid)
110        ...{
111            StringBuilder sb = new StringBuilder();
112            sb.Append("select typename from type_2 where typeid_2=@typeid_1");
113            OleDbParameter[] param = ...{ OleDbHelper.GetParameter("@typeid_1", OleDbType.Integer, 4, "typeid_1", typeid) };
114            DataTable table = OleDbHelper.ExecuteDt(sb.ToString(), param);
115            return table.Rows.Count > 0 ? table.Rows[0]["typename"].ToString() : "";
116        }
117    }
118}
119