当前文件：
SinaVote/Dal/Vote_Items.cs[8K，2009-6-12 11:54:10]，
打开代码结构图
1
using System;
2using System.Data;
3using System.Text;
4using System.Data.SqlClient;
5using Maticsoft.DBUtility;//请先添加引用
6//该源码首发自www.51aspx.com(５１ａsｐｘ．ｃｏｍ)
7
8namespace Charmmax.DAL
9
...{
10
/**//// <summary>
11
/// 数据访问类Vote_Items。
12
/// </summary>
13 public class Vote_Items
14 ...{
15 public Vote_Items()
16 ...{ }
17 成员方法#region 成员方法
18
19 /**//// <summary>
20 /// 是否存在该记录
21 /// </summary>
22 public bool Exists(string I_Title)
23 ...{
24 StringBuilder strSql = new StringBuilder();
25 strSql.Append("select count(1) from Vote_Items");
26 strSql.Append(" where I_Title=@I_Title ");
27 SqlParameter[] parameters = ...{
28 new SqlParameter("@I_Title", SqlDbType.VarChar,50)};
29 parameters[0].Value = I_Title;
30
31 return DbHelperSQL.Exists(strSql.ToString(), parameters);
32 }
33
34
35 /**//// <summary>
36 /// 增加一条数据
37 /// </summary>
38 public int Add(Charmmax.Model.Vote_Items model)
39 ...{
40 StringBuilder strSql = new StringBuilder();
41 strSql.Append("insert into Vote_Items(");
42 strSql.Append("I_Title,I_Memo,I_NavUrl,I_Images)");
43 strSql.Append(" values (");
44 strSql.Append("@I_Title,@I_Memo,@I_NavUrl,@I_Images)");
45 strSql.Append(";select @@IDENTITY");
46 SqlParameter[] parameters = ...{
47 new SqlParameter("@I_Title", SqlDbType.VarChar,50),
48 new SqlParameter("@I_Memo", SqlDbType.VarChar,255),
49 new SqlParameter("@I_NavUrl", SqlDbType.VarChar,255),
50 new SqlParameter("@I_Images", SqlDbType.VarChar,255)};
51 parameters[0].Value = model.I_Title;
52 parameters[1].Value = model.I_Memo;
53 parameters[2].Value = model.I_NavUrl;
54 parameters[3].Value = model.I_Images;
55
56 object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
57 if (obj == null)
58 ...{
59 return 1;
60 }
61 else
62 ...{
63 return Convert.ToInt32(obj);
64 }
65 }
66 /**//// <summary>
67 /// 更新一条数据
68 /// </summary>
69 public void Update(Charmmax.Model.Vote_Items model)
70 ...{
71 StringBuilder strSql = new StringBuilder();
72 strSql.Append("update Vote_Items set ");
73 strSql.Append("I_Title=@I_Title,");
74 strSql.Append("I_Memo=@I_Memo,");
75 strSql.Append("I_NavUrl=@I_NavUrl,");
76 strSql.Append("I_Images=@I_Images");
77 strSql.Append(" where I_ID=@I_ID ");
78 SqlParameter[] parameters = ...{
79 new SqlParameter("@I_ID", SqlDbType.Int,4),
80 new SqlParameter("@I_Title", SqlDbType.VarChar,50),
81 new SqlParameter("@I_Memo", SqlDbType.VarChar,255),
82 new SqlParameter("@I_NavUrl", SqlDbType.VarChar,255),
83 new SqlParameter("@I_Images", SqlDbType.VarChar,255)};
84 parameters[0].Value = model.I_ID;
85 parameters[1].Value = model.I_Title;
86 parameters[2].Value = model.I_Memo;
87 parameters[3].Value = model.I_NavUrl;
88 parameters[4].Value = model.I_Images;
89
90 DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
91 }
92
93 /**//// <summary>
94 /// 删除一条数据
95 /// </summary>
96 public void Delete(int I_ID)
97 ...{
98
99 StringBuilder strSql = new StringBuilder();
100 strSql.Append("delete Vote_Items ");
101 strSql.Append(" where I_ID=@I_ID ");
102 SqlParameter[] parameters = ...{
103 new SqlParameter("@I_ID", SqlDbType.Int,4)};
104 parameters[0].Value = I_ID;
105
106 DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
107 }
108
109
110 /**//// <summary>
111 /// 得到一个对象实体
112 /// </summary>
113 public Charmmax.Model.Vote_Items GetModel(int I_ID)
114 ...{
115
116 StringBuilder strSql = new StringBuilder();
117 strSql.Append("select top 1 I_ID,I_Title,I_Memo,I_NavUrl,I_Images from Vote_Items ");
118 strSql.Append(" where I_ID=@I_ID ");
119 SqlParameter[] parameters = ...{
120 new SqlParameter("@I_ID", SqlDbType.Int,4)};
121 parameters[0].Value = I_ID;
122
123 Charmmax.Model.Vote_Items model = new Charmmax.Model.Vote_Items();
124 DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
125 if (ds.Tables[0].Rows.Count > 0)
126 ...{
127 if (ds.Tables[0].Rows[0]["I_ID"].ToString() != "")
128 ...{
129 model.I_ID = int.Parse(ds.Tables[0].Rows[0]["I_ID"].ToString());
130 }
131 model.I_Title = ds.Tables[0].Rows[0]["I_Title"].ToString();
132 model.I_Memo = ds.Tables[0].Rows[0]["I_Memo"].ToString();
133 model.I_NavUrl = ds.Tables[0].Rows[0]["I_NavUrl"].ToString();
134 model.I_Images = ds.Tables[0].Rows[0]["I_Images"].ToString();
135 return model;
136 }
137 else
138 ...{
139 return null;
140 }
141 }
142 /**//// <summary>
143 /// 得到一个对象实体
144 /// </summary>
145 public Charmmax.Model.Vote_Items GetModelString(string I_Title)
146 ...{
147
148 StringBuilder strSql = new StringBuilder();
149 strSql.Append("select top 1 I_ID,I_Title,I_Memo,I_NavUrl,I_Images from Vote_Items ");
150 strSql.Append(" where I_Title=@I_Title ");
151 SqlParameter[] parameters = ...{
152 new SqlParameter("@I_Title", SqlDbType.VarChar,50)};
153 parameters[0].Value = I_Title;
154
155 Charmmax.Model.Vote_Items model = new Charmmax.Model.Vote_Items();
156 DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
157 if (ds.Tables[0].Rows.Count > 0)
158 ...{
159 if (ds.Tables[0].Rows[0]["I_ID"].ToString() != "")
160 ...{
161 model.I_ID = int.Parse(ds.Tables[0].Rows[0]["I_ID"].ToString());
162 }
163 model.I_Title = ds.Tables[0].Rows[0]["I_Title"].ToString();
164 model.I_Memo = ds.Tables[0].Rows[0]["I_Memo"].ToString();
165 model.I_NavUrl = ds.Tables[0].Rows[0]["I_NavUrl"].ToString();
166 model.I_Images = ds.Tables[0].Rows[0]["I_Images"].ToString();
167 return model;
168 }
169 else
170 ...{
171 return null;
172 }
173 }
174
175
176 /**//// <summary>
177 /// 获得数据列表
178 /// </summary>
179 public DataSet GetList(string strWhere)
180 ...{
181 StringBuilder strSql = new StringBuilder();
182 strSql.Append("select I_ID,I_Title,I_Memo,I_NavUrl,I_Images ");
183 strSql.Append(" FROM Vote_Items ");
184 if (strWhere.Trim() != "")
185 ...{
186 strSql.Append(" where " + strWhere);
187 }
188 return DbHelperSQL.Query(strSql.ToString());
189 }
190
191 /**//*
192 /// <summary>
193 /// 分页获取数据列表
194 /// </summary>
195 public DataSet GetList(int PageSize,int PageIndex,string strWhere)
196 {
197 SqlParameter[] parameters = {
198 new SqlParameter("@tblName", SqlDbType.VarChar, 255),
199 new SqlParameter("@fldName", SqlDbType.VarChar, 255),
200 new SqlParameter("@PageSize", SqlDbType.Int),
201 new SqlParameter("@PageIndex", SqlDbType.Int),
202 new SqlParameter("@IsReCount", SqlDbType.Bit),
203 new SqlParameter("@OrderType", SqlDbType.Bit),
204 new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
205 };
206 parameters[0].Value = "Vote_Items";
207 parameters[1].Value = "ID";
208 parameters[2].Value = PageSize;
209 parameters[3].Value = PageIndex;
210 parameters[4].Value = 0;
211 parameters[5].Value = 0;
212 parameters[6].Value = strWhere;
213 return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
214 }*/
215
216 #endregion 成员方法
217 }
218
}
219
220
打包下载该项目完整源码：仿新浪投票系统源码