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

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