温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:MyShop网络商城080617源码
当前文件:
MyShop080617/AccessDAL/Vote.cs,打开代码结构图
MyShop080617/AccessDAL/Vote.cs,打开代码结构图1using System; 2
using System.Collections.Generic; 3
using System.Data; 4
using System.Data.OleDb; 5
using MyShop.IDAL; 6
using MyShop.Model; 7
8
namespace MyShop.AccessDAL 9
...{ 10
public class Vote : IVote 11
...{ 12
13
private ConfigInfo configInfo = new ConfigInfo(); 14
private string tableName = "Ljh_Vote"; 15
16
public Vote() 17
...{ 18
if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim())) 19
tableName = configInfo.TablePrefix + "Vote"; 20
} 21
22
IVote member#region IVote member 23
24
25
/**//// <summary> 26
/// add 27
/// </summary> 28
/// <param name="model"></param> 29
/// <returns>返回ID, 如果发生错误则返回-1</returns> 30
public int Add(VoteInfo model) 31
...{ 32
if (model == null) 33
...{ 34
return -1; 35
} 36
string commandText = "insert into " + this.tableName + "(Title,Content,Number,VoteTime,EndTime,VoteType,IsSelected) values(@Title,@Content,@Number,@VoteTime,@EndTime,@VoteType,@IsSelected) "; 37
OleDbParameter[] commandParameters = 38
...{ 39
Database.MakeInParam("@Title", OleDbType.VarWChar , 0 ,model.Title ), 40
Database.MakeInParam("@Content", OleDbType.VarWChar , 0 ,model.Content ), 41
Database.MakeInParam("@Number", OleDbType.VarWChar , 0 ,model.Number ), 42
Database.MakeInParam("@VoteTime", OleDbType.Date , 8 ,model.VoteTime ), 43
Database.MakeInParam("@EndTime", OleDbType.Date , 8 ,model.EndTime ), 44
Database.MakeInParam("@VoteType", OleDbType.UnsignedTinyInt , 1 ,model.VoteType ), 45
Database.MakeInParam("@IsSelected", OleDbType.UnsignedTinyInt , 1 ,model.IsSelected ) 46
}; 47
48
int intIdentity = -1; 49
try 50
...{ 51
Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters); 52
} 53
catch (Exception exception) 54
...{ 55
throw exception; 56
} 57
return intIdentity; 58
} 59
60
61
62
63
/**//// <summary> 64
/// 删除 65
/// </summary> 66
/// <param name="filter">where后面的条件语句,不加where</param> 67
/// <returns>返回影响行数</returns> 68
public int Delete(string filter) 69
...{ 70
int count = -1; 71
string sql = @"delete from " + tableName; 72
if (!string.IsNullOrEmpty(filter.Trim())) 73
...{ 74
sql = sql + " where " + filter; 75
} 76
try 77
...{ 78
79
count = Database.ExecuteNonQuery(sql); 80
} 81
catch (Exception ex) 82
...{ 83
throw ex; 84
} 85
return count; 86
} 87
88
/**//// <summary> 89
/// 90
/// </summary> 91
/// <param name="filter"></param> 92
/// <returns></returns> 93
public bool Exist(string filter) 94
...{ 95
bool result = false; 96
string sql = @"select * from " + tableName; 97
if (!string.IsNullOrEmpty(filter)) 98
...{ 99
sql = sql + " where " + filter; 100
} 101
try 102
...{ 103
104
105
DataSet dataset = new DataSet(); 106
dataset = Database.ExecuteDataSet(sql); 107
if (dataset.Tables[0].Rows.Count > 0) 108
...{ 109
result = true; 110
} 111
} 112
catch (Exception ex) 113
...{ 114
throw ex; 115
} 116
return result; 117
} 118
119
/**//// <summary> 120
/// 返回所有 121
/// </summary> 122
/// <returns>返回所有</returns> 123
public DataSet GetDataSet() 124
...{ 125
string sql = "select * from " + tableName; 126
DataSet dataset = new DataSet(); 127
try 128
...{ 129
130
dataset = Database.ExecuteDataSet(sql); 131
132
} 133
catch (Exception ex) 134
...{ 135
throw ex; 136
} 137
return dataset; 138
} 139
140
public DataSet GetDataSet(string filter) 141
...{ 142
if (string.IsNullOrEmpty(filter)) 143
return null; 144
145
string sql = "select * from " + tableName + " where " + filter; 146
DataSet dataset = new DataSet(); 147
try 148
...{ 149
150
dataset = Database.ExecuteDataSet(sql); 151
} 152
catch (Exception ex) 153
...{ 154
throw ex; 155
} 156
return dataset; 157
} 158
159
/**//// <summary> 160
/// 161
/// </summary> 162
/// <param name="dr"></param> 163
/// <returns></returns> 164
public VoteInfo GetModel(DataRow dr) 165
...{ 166
if (dr == null) 167
return null; 168
VoteInfo model = new VoteInfo(); 169
170
if (dr["ID"].ToString() != "") model.ID = Convert.ToInt32( dr["ID"]); 171
if (dr["Title"].ToString() != "") model.Title = dr["Title"].ToString(); 172
if (dr["Content"].ToString() != "") model.Content = dr["Content"].ToString(); 173
if (dr["Number"].ToString() != "") model.Number = dr["Number"].ToString(); 174
if (dr["VoteTime"].ToString() != "") model.VoteTime = dr["VoteTime"].ToString(); 175
if (dr["EndTime"].ToString() != "") model.EndTime = dr["EndTime"].ToString(); 176
if (dr["VoteType"].ToString() != "") model.VoteType =Convert.ToInt32( dr["VoteType"]); 177
if (dr["IsSelected"].ToString() != "") model.IsSelected = Convert.ToInt32( dr["IsSelected"]); 178
179
180
return model; 181
} 182
183
/**//// <summary> 184
/// 185
/// </summary> 186
/// <param name="sql"></param> 187
/// <returns></returns> 188
public DataSet Query(string sql) 189
...{ 190
if (string.IsNullOrEmpty(sql)) 191
return null; 192
193
DataSet dataset = new DataSet(); 194
try 195
...{ 196
197
dataset = Database.ExecuteDataSet(sql); 198
} 199
catch (Exception ex) 200
...{ 201
throw ex; 202
} 203
return dataset; 204
} 205
206
207
/**//// <summary> 208
/// update 209
/// </summary> 210
/// <param name="model"></param> 211
/// <param name="filter"></param> 212
/// <returns></returns> 213
public int Update(VoteInfo model, string filter) 214
...{ 215
int result; 216
if (string.IsNullOrEmpty(filter)) 217
...{ 218
throw new Exception("The 'filter' can not be null!"); 219
} 220
string sql = @"update " + tableName + " set Title=@Title,Content=@Content,[Number]=@Number,VoteTime=@VoteTime,EndTime=@EndTime,VoteType=@VoteType,IsSelected=@IsSelected " + " where " + filter; 221
222
OleDbParameter[] prams = ...{ 223
Database.MakeInParam("@Title", OleDbType.VarWChar , 0 ,model.Title ), 224
Database.MakeInParam("@Content", OleDbType.VarWChar , 0 ,model.Content ), 225
Database.MakeInParam("@Number", OleDbType.VarWChar , 0 ,model.Number ), 226
Database.MakeInParam("@VoteTime", OleDbType.Date , 8 ,model.VoteTime ), 227
Database.MakeInParam("@EndTime", OleDbType.Date , 8 ,model.EndTime ), 228
Database.MakeInParam("@VoteType", OleDbType.UnsignedTinyInt , 1 ,model.VoteType ), 229
Database.MakeInParam("@IsSelected", OleDbType.UnsignedTinyInt , 1 ,model.IsSelected ), 230
}; 231
232
try 233
...{ 234
235
result = Database.ExecuteNonQuery(sql, prams); 236
} 237
catch (Exception ex) 238
...{ 239
throw ex; 240
} 241
return result; 242
} 243
244
245
#endregion 246
} 247
} 248





}
}