温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:仿新浪投票系统源码
当前文件:
SinaVote/Dal/Vote_Items.cs[8K,2009-6-12 11:54:10],打开代码结构图
SinaVote/Dal/Vote_Items.cs[8K,2009-6-12 11:54:10],打开代码结构图1using System; 2
using System.Data; 3
using System.Text; 4
using System.Data.SqlClient; 5
using Maticsoft.DBUtility;//请先添加引用 6
//该源码首发自www.51aspx.com(51aspx.com) 7
8
namespace 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






}