当前文件： DadaEbookDownload/Pn163.com_DAL/DAL_View.cs[9K，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;
  8using Wuqi.Webdiyer;
  9
 10namespace Pn163.com_DAL
 11...{
 12    public class DAL_View
 13    ...{
 14        public static int view_insert(Model_View User)
 15        ...{
 16            SqlParameter[] para = new SqlParameter[11];
 17            para[0] = new SqlParameter("@Name", User.Name);
 18            para[1] = new SqlParameter("@Language", User.Language);
 19            para[2] = new SqlParameter("@Size", User.Size);
 20            para[3] = new SqlParameter("@Content", User.Content);
 21            para[4] = new SqlParameter("@DownUrl", User.DownUrl);
 22            para[5] = new SqlParameter("@Tong", User.Tong);
 23            para[6] = new SqlParameter("@Cls1_id", User.Cls1_id);
 24            para[7] = new SqlParameter("@Cls2_id", User.Cls2_id);
 25            para[8] = new SqlParameter("@SizeNum", User.SizeNum);
 26            para[9] = new SqlParameter("@uptime", User.UpTime);
 27            para[10] = new SqlParameter("@Format", User.Format);
 28            return SqlParamsHelper.ExecuteCmd("view_insert", para);
 29        }
 30
 31
 32        public static List<Model_View> get_list()
 33        ...{
 34            List<Model_View> list = new List<Model_View>();
 35            DataTable Dt = SqlParamsHelper.GetDataSet("view_show").Tables[0];
 36            foreach (DataRow Dr in Dt.Rows)
 37            ...{
 38                Model_View info = new Model_View();
 39                info.id = Convert.ToInt32(Dr["id"].ToString());
 40                list.Add(info);
 41            }
 42            return list;
 43        }
 44
 45        //强类型List集合
 46        public static List<Model_View> get_list(AspNetPager page,string Table)
 47        ...{
 48            List<Model_View> list = new List<Model_View>();
 49            DataTable Dt = SqlParamsHelper.Pager(page,"view_show",Table).Tables[0];
 50            foreach (DataRow Dr in Dt.Rows)
 51            ...{
 52                Model_View info = new Model_View();
 53                info.Name = Dr["Name"].ToString();
 54                info.id = Convert.ToInt32(Dr["id"].ToString());
 55                info.UpTime = Dr["UpTime"].ToString();
 56                list.Add(info);
 57            }
 58            return list;
 59        }
 60
 61        //按一级分类ID获取文章数据 用于前台生成
 62        public static List<Model_View> get_list(int Cls1_id)
 63        ...{
 64            List<Model_View> list = new List<Model_View>();
 65            SqlParameter[] para = new SqlParameter[1];
 66            para[0] = new SqlParameter("Cls1_id", Cls1_id);
 67            DataTable Dt = SqlParamsHelper.GetDataSet("view_cls1_id", para).Tables[0];
 68            foreach (DataRow Dr in Dt.Rows)
 69            ...{
 70                Model_View info = new Model_View();
 71                info.id = Convert.ToInt32(Dr["id"].ToString());
 72                info.Cls1_id = Convert.ToInt32(Dr["Cls1_id"].ToString());
 73                info.Name = Dr["Name"].ToString();
 74                info.UpTime = Dr["UpTime"].ToString();
 75                info.Format = Dr["Format"].ToString();
 76                list.Add(info);
 77            }
 78            return list;
 79        }
 80
 81        //按一级和二级分类ID获取文章数据 用于前台生成
 82        public static List<Model_View> cls2_list(int Cls1_id, int Cls2_id)
 83        ...{
 84            SqlParameter[] para = new SqlParameter[2];
 85            para[0] = new SqlParameter("@Cls1_id", Cls1_id);
 86            para[1] = new SqlParameter("@Cls2_id", Cls2_id);
 87            DataTable Dt = SqlParamsHelper.GetDataSet("view_cls2_id", para).Tables[0];
 88            List<Model_View> list = new List<Model_View>();
 89            foreach (DataRow Dr in Dt.Rows)
 90            ...{
 91                Pn163.com_Model.Model_View info = new Model_View();
 92                info.id = Convert.ToInt32(Dr["id"].ToString());
 93                info.Name = Dr["Name"].ToString();
 94                info.Cls1_id = Convert.ToInt32(Dr["Cls1_id"].ToString());
 95                info.Cls2_id = Convert.ToInt32(Dr["Cls2_id"].ToString());
 96                info.UpTime = Dr["UpTime"].ToString();
 97                list.Add(info);
 98            }
 99            return list;
100        }
101
102        //按二级分类的Cls_id来获取文章数据 用于前台生成
103        public static List<Model_View> cls2_list(int Cls2_id)
104        ...{
105            List<Model_View> list = new List<Model_View>();
106            SqlParameter[] para = new SqlParameter[1];
107            para[0] = new SqlParameter("Cls2_id", Cls2_id);
108            DataTable Dt = SqlParamsHelper.GetDataSet("view_select2", para).Tables[0];
109            foreach (DataRow Dr in Dt.Rows)
110            ...{
111                Model_View info = new Model_View();
112                info.id = Convert.ToInt32(Dr["id"].ToString());
113                info.Name = Dr["Name"].ToString();
114                info.Cls1_id = Convert.ToInt32(Dr["Cls1_id"].ToString());
115                info.Size = Dr["Size"].ToString();
116                info.SizeNum = Dr["SizeNum"].ToString();
117                info.UpTime = Dr["UpTime"].ToString();
118                info.Format = Dr["Format"].ToString();
119                list.Add(info);
120            }
121            return list;
122        }
123
124        public static Model_View view_select(int id)
125        ...{
126            SqlParameter[] para = new SqlParameter[1];
127            para[0] = new SqlParameter("@id",id);
128            DataTable Dt = SqlParamsHelper.GetDataTable("view_select", para);
129            Model_View info = new Model_View();
130            if (Dt.Rows.Count > 0)
131            ...{
132                info.Name = Dt.Rows[0]["Name"].ToString();
133                info.Language = Dt.Rows[0]["Language"].ToString();
134                info.Size = Dt.Rows[0]["Size"].ToString();
135                info.DownUrl = Dt.Rows[0]["DownUrl"].ToString();
136                info.Content = Dt.Rows[0]["Content"].ToString();
137                info.Tong = Dt.Rows[0]["Tong"].ToString();
138                info.Cls1_id = Convert.ToInt32(Dt.Rows[0]["Cls1_id"]);
139                info.Cls2_id = Convert.ToInt32(Dt.Rows[0]["Cls2_id"]);
140                info.SizeNum = Dt.Rows[0]["SizeNum"].ToString();
141                info.Format = Dt.Rows[0]["Format"].ToString();
142                info.UpTime = Dt.Rows[0]["UpTime"].ToString();
143            }
144            return info;
145        }
146
147        public static int view_update(Model_View User)
148        ...{
149            SqlParameter[] para = new SqlParameter[12];
150            para[0] = new SqlParameter("@Name", User.Name);
151            para[1] = new SqlParameter("@Language", User.Language);
152            para[2] = new SqlParameter("@Size", User.Size);
153            para[3] = new SqlParameter("@Content", User.Content);
154            para[4] = new SqlParameter("@DownUrl", User.DownUrl);
155            para[5] = new SqlParameter("@Tong", User.Tong);
156            para[6] = new SqlParameter("@Cls1_id", User.Cls1_id);
157            para[7] = new SqlParameter("@Cls2_id", User.Cls2_id);
158            para[8] = new SqlParameter("@SizeNum", User.SizeNum);
159            para[9] = new SqlParameter("@id", User.id);
160            para[10] = new SqlParameter("@uptime", User.UpTime);
161            para[11] = new SqlParameter("@format", User.Format);
162            return SqlParamsHelper.ExecuteCmd("view_update", para);
163        }
164
165        public static int view_delete(int id)
166        ...{
167            SqlParameter[] para = new SqlParameter[1];
168            para[0] = new SqlParameter("@id", id);
169            return SqlParamsHelper.ExecuteCmd("view_delete", para);
170        }
171
172        public static int view_count()
173        ...{
174            return SqlParamsHelper.ExecuteScalar("view_count");
175        }
176
177        public static List<Model_View> like_list(string like)
178        ...{
179            List<Model_View> list = new List<Model_View>();
180            SqlParameter[] para = new SqlParameter[1];
181            para[0] = new SqlParameter("@tong", like);
182            DataTable Dt = SqlParamsHelper.GetDataSet("view_like", para).Tables[0];
183            
184            foreach (DataRow Dr in Dt.Rows)
185            ...{
186                Pn163.com_Model.Model_View info = new Pn163.com_Model.Model_View();
187                info.id = Convert.ToInt32(Dr["id"].ToString());
188                info.Name = Dr["Name"].ToString();
189                info.UpTime = Dr["UpTime"].ToString();
190                list.Add(info);
191            }
192            return list;
193        }
194
195        public static List<Model_View> admin_search(string name)
196        ...{
197            SqlParameter[] para = new SqlParameter[1];
198            para[0] = new SqlParameter("@name", name);
199            List<Model_View> list = new List<Model_View>();
200            DataTable Dt = SqlParamsHelper.GetDataSet("admin_search", para).Tables[0];
201            foreach (DataRow Dr in Dt.Rows)
202            ...{
203                Model_View info = new Model_View();
204                info.id = Convert.ToInt32(Dr["id"].ToString());
205                info.Name = Dr["Name"].ToString();
206                info.UpTime = Dr["UpTime"].ToString();
207                list.Add(info);
208            }
209            return list;
210        }
211
212        public static DataTable nameChkdsk(string name)
213        ...{
214            SqlParameter[] para = new SqlParameter[1];
215            para[0] = new SqlParameter("@name", name);
216            return SqlParamsHelper.GetDataTable("view_select3", para);
217        }
218
219        public static Model_View _nameChkdsk(string name)
220        ...{
221            SqlParameter[] para = new SqlParameter[1];
222            para[0] = new SqlParameter("@name", name);
223            DataTable Dt = SqlParamsHelper.GetDataTable("view_select3", para);
224            Model_View info = new Model_View();
225            if (Dt.Rows.Count > 0)
226            ...{
227                info.id = Convert.ToInt32(Dt.Rows[0]["id"].ToString());
228            }
229            return info;
230        }
231    }
232}
233