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





}
}