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

		            
 1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data;
 5using System.Data.SqlClient;
 6using Pn163.com_Model;
 7using Pn163.com_DbHelper;
 8using Wuqi.Webdiyer;
 9
10namespace Pn163.com_DAL
11...{
12    public class DAL_Link
13    ...{
14        public static int link_insert(Model_Link User)
15        ...{
16            SqlParameter[] para = new SqlParameter[4];
17            para[0] = new SqlParameter("@linkname", User.LinkName);
18            para[1] = new SqlParameter("@linkurl", User.LinkUrl);
19            para[2] = new SqlParameter("@linklogo", User.LinkLogo);
20            para[3] = new SqlParameter("@linktype", User.LinkType);
21            return SqlParamsHelper.ExecuteCmd("link_insert", para);
22        }
23
24        public static List<Model_Link> get_list()
25        ...{
26            List<Model_Link> list = new List<Model_Link>();
27            DataTable Dt = SqlParamsHelper.GetDataSet("link_show").Tables[0];
28            foreach (DataRow Dr in Dt.Rows)
29            ...{
30                Model_Link info = new Model_Link();
31                info.LinkName = Dr["LinkName"].ToString();
32                info.LinkUrl = Dr["LinkUrl"].ToString();
33                info.LinkLogo = Dr["LinkLogo"].ToString();
34                info.LinkType = Convert.ToInt32(Dr["Linktype"].ToString());
35                info.id = Convert.ToInt32(Dr["id"].ToString());
36                list.Add(info);
37            }
38            return list;
39        }
40
41        public static int link_delete(int id)
42        ...{
43            SqlParameter[] para = new SqlParameter[1];
44            para[0] = new SqlParameter("@id", id);
45            return SqlParamsHelper.ExecuteCmd("link_delete", para);
46        }
47
48        public static Model_Link link_select(int id)
49        ...{
50            SqlParameter[] para = new SqlParameter[1];
51            para[0] = new SqlParameter("@id", id);
52            DataTable Dt = SqlParamsHelper.GetDataTable("link_select", para);
53            Model_Link info = new Model_Link();
54            if (Dt.Rows.Count > 0)
55            ...{
56                info.id = Convert.ToInt32(Dt.Rows[0]["id"]);
57                info.LinkName = Dt.Rows[0]["LinkName"].ToString();
58                info.LinkUrl = Dt.Rows[0]["LinkUrl"].ToString();
59                info.LinkLogo = Dt.Rows[0]["LinkLogo"].ToString();
60                info.LinkType = Convert.ToInt32(Dt.Rows[0]["LinkType"]);
61            }
62            return info;
63        }
64
65        public static int link_update(Model_Link User)
66        ...{
67            SqlParameter[] para = new SqlParameter[5];
68            para[0] = new SqlParameter("@linkname", User.LinkName);
69            para[1] = new SqlParameter("@linkurl", User.LinkUrl);
70            para[2] = new SqlParameter("@linklogo", User.LinkLogo);
71            para[3] = new SqlParameter("@linktype", User.LinkType);
72            para[4] = new SqlParameter("@id", User.id);
73            return SqlParamsHelper.ExecuteCmd("link_update", para); 
74        }
75
76        public static List<Model_Link> get_list(int linktype)
77        ...{
78            SqlParameter[] para = new SqlParameter[1];
79            para[0] = new SqlParameter("@linktype", linktype);
80            DataTable Dt = SqlParamsHelper.GetDataSet("link_where_1", para).Tables[0];
81            List<Model_Link> list = new List<Model_Link>();
82            foreach (DataRow Dr in Dt.Rows)
83            ...{
84                Model_Link info = new Model_Link();
85                info.id = Convert.ToInt32(Dr["id"].ToString());
86                info.LinkName = Dr["LinkName"].ToString();
87                info.LinkLogo = Dr["LinkLogo"].ToString();
88                info.LinkUrl = Dr["LinkUrl"].ToString();
89                list.Add(info);
90            }
91            return list;
92        }
93    }
94}
95