当前文件： DadaEbookDownload/Pn163.com_DAL/DAL_Class.cs[5K，2009-6-12 11:38:29]，打开代码结构图

		            
  1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using Pn163.com_Model;
  5using Pn163.com_DbHelper;
  6using System.Data;
  7using System.Data.SqlClient;
  8
  9namespace Pn163.com_DAL
 10...{
 11    public class DAL_Class
 12    ...{
 13        //添加一级分类
 14        public static int cls1_insert(Model_Class User)
 15        ...{
 16            SqlParameter[] para = new SqlParameter[2];
 17            para[0] = new SqlParameter("@class", User.ClassName);
 18            para[1] = new SqlParameter("@sort", User.Sort);
 19            return SqlParamsHelper.ExecuteCmd("cls1_insert", para);
 20        }
 21
 22        //获取一级分类
 23        public static Model_Class cls1_select(int id)
 24        ...{
 25            SqlParameter[] para = new SqlParameter[1];
 26            para[0] = new SqlParameter("@id",id);
 27            DataTable Dt = SqlParamsHelper.GetDataTable("cls1_select", para);
 28            Model_Class info = new Model_Class();
 29            if (Dt.Rows.Count > 0)
 30            ...{
 31                info.ClassName = Dt.Rows[0]["ClassName"].ToString();
 32                info.Sort = Convert.ToInt32(Dt.Rows[0]["Sort"]).ToString();
 33            }
 34            return info;
 35        }
 36
 37        //修改一级分类
 38        public static int cls1_update(Model_Class User)
 39        ...{
 40            SqlParameter[] para = new SqlParameter[3];
 41            para[0] = new SqlParameter("@id", User.id);
 42            para[1] = new SqlParameter("@class", User.ClassName);
 43            para[2] = new SqlParameter("@sort", User.Sort);
 44            return SqlParamsHelper.ExecuteCmd("cls1_update", para);
 45        }
 46
 47        //删除一级分类
 48        public static int cls1_delete(Model_Class User)
 49        ...{
 50            SqlParameter[] para = new SqlParameter[1];
 51            para[0] = new SqlParameter("@id", User.id);
 52            return SqlParamsHelper.ExecuteCmd("cls1_delete", para);
 53        }
 54
 55        //添加二级分类
 56        public static int cls2_insert(Model_Class User)
 57        ...{
 58            SqlParameter[] para = new SqlParameter[3];
 59            para[0] = new SqlParameter("@class", User.ClassName);
 60            para[1] = new SqlParameter("@sort", User.Sort);
 61            para[2] = new SqlParameter("@cls_id", User.Cls_id);
 62            return SqlParamsHelper.ExecuteCmd("cls2_insert", para);
 63        }
 64
 65        //一级分类的数据表
 66        public static DataSet cls1_dataset(string table)
 67        ...{
 68            return SqlParamsHelper.GetDataSet("cls1_show", table);
 69        }
 70
 71        //强类型集合 用于前台生成HTML
 72        public static List<Model_Class> get_list()
 73        ...{
 74            List<Model_Class> list = new List<Model_Class>();
 75            DataTable Dt = SqlParamsHelper.GetDataSet("cls1_show").Tables[0];
 76            foreach (DataRow Dr in Dt.Rows)
 77            ...{
 78                Model_Class info = new Model_Class();
 79                info.ClassName = Dr["ClassName"].ToString();
 80                info.id = Convert.ToInt32(Dr["id"].ToString());
 81                list.Add(info);
 82            }
 83            return list;
 84        }
 85
 86        //二级分类的数据表
 87        public static DataSet cls2_dataset(string table)
 88        ...{
 89            return SqlParamsHelper.GetDataSet("cls2_show", table);
 90        }
 91
 92        //获取二级分类
 93        public static Model_Class cls2_select(int id,int cls_id)
 94        ...{
 95            SqlParameter[] para = new SqlParameter[2];
 96            para[0] = new SqlParameter("@id", id);
 97            para[1] = new SqlParameter("@cls_id", cls_id);
 98            DataTable Dt = SqlParamsHelper.GetDataTable("cls2_select", para);
 99            Model_Class info = new Model_Class();
100            if (Dt.Rows.Count > 0)
101            ...{
102                info.ClassName = Dt.Rows[0]["ClassName"].ToString();
103                info.Sort = Convert.ToInt32(Dt.Rows[0]["Sort"]).ToString();
104            }
105            return info;
106        }
107
108        //修改二级分类
109        public static int cls2_update(Model_Class User)
110        ...{
111            SqlParameter[] para = new SqlParameter[4];
112            para[0] = new SqlParameter("@id", User.id);
113            para[1] = new SqlParameter("@cls_id", User.Cls_id);
114            para[2] = new SqlParameter("@class", User.ClassName);
115            para[3] = new SqlParameter("@sort", User.Sort);
116            return SqlParamsHelper.ExecuteCmd("cls2_update", para);
117        }
118
119        //删除二级分类
120        public static int cls2_delete(Model_Class User)
121        ...{
122            SqlParameter[] para = new SqlParameter[1];
123            para[0] = new SqlParameter("@id", User.id);
124            return SqlParamsHelper.ExecuteCmd("cls2_delete", para);
125        }
126
127        //
128        public static DataSet cls2_drodownlist(string Cls_id)
129        ...{
130            SqlParameter[] para = new SqlParameter[1];
131            para[0] = new SqlParameter("@cls_id", Cls_id);
132            return SqlParamsHelper.GetDataSet("cls2_drodownlist", para);
133        }
134
135        public static List<Model_Class> get_list(int Cls_id)
136        ...{
137            SqlParameter[] para = new SqlParameter[1];
138            para[0] = new SqlParameter("@cls_id", Cls_id);
139            List<Pn163.com_Model.Model_Class> list = new List<Model_Class>();
140            DataTable Dt = SqlParamsHelper.GetDataSet("cls2_where", para).Tables[0];
141            foreach (DataRow Dr in Dt.Rows)
142            ...{
143                Pn163.com_Model.Model_Class info = new Pn163.com_Model.Model_Class();
144                info.ClassName = Dr["ClassName"].ToString();
145                info.id = Convert.ToInt32(Dr["id"].ToString());
146                list.Add(info);
147            }
148            return list;
149        }
150    }
151}
152