温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:MyShop网络商城080617源码
当前文件:
MyShop080617/BLL/Admin.cs,打开代码结构图
MyShop080617/BLL/Admin.cs,打开代码结构图1using System; 2
using System.Collections.Generic; 3
4
using System.Data; 5
6
7
using MyShop.DALFactory; 8
using MyShop.IDAL; 9
using MyShop.Model; 10
using MyShop.Enumerations; 11
using MyShop.Common; 12
13
namespace MyShop.BLL 14
...{ 15
public class Admin 16
...{ 17
private IAdmin dal = DataAccess.CreateAdmin(); 18
19
IAdmin#region IAdmin 20
21
/**//// <summary> 22
/// 密码未md5加密 23
/// </summary> 24
/// <param name="model"></param> 25
/// <returns></returns> 26
protected int Add(AdminInfo model) 27
...{ 28
if (model == null) 29
...{ 30
return 0; 31
} 32
return dal.Add(model); 33
} 34
35
protected int Delete(string filter) 36
...{ 37
if (string.IsNullOrEmpty(filter)) 38
return 0; 39
return dal.Delete(filter); 40
} 41
42
public bool Exist(string filter) 43
...{ 44
filter = filter.Trim(); 45
if (string.IsNullOrEmpty(filter)) 46
return false; 47
return dal.Exist(filter); 48
} 49
public DataSet GetDataSet() 50
...{ 51
return dal.GetDataSet(); 52
} 53
54
public DataSet GetDataSet(string filter) 55
...{ 56
filter = filter.Trim(); 57
if (string.IsNullOrEmpty(filter)) 58
return null; 59
return dal.GetDataSet(filter); 60
} 61
62
public AdminInfo GetModel(DataRow dr) 63
...{ 64
if (dr == null) 65
return null; 66
return dal.GetModel(dr); 67
} 68
69
private DataSet Query(string sql) 70
...{ 71
sql = sql.Trim(); 72
if (string.IsNullOrEmpty(sql)) 73
return null; 74
return dal.Query(sql); 75
} 76
77
public int Update(AdminInfo model, string filter) 78
...{ 79
if (model == null) 80
return 0; 81
filter = filter.Trim(); 82
if (string.IsNullOrEmpty(filter)) 83
return 0; 84
return dal.Update(model, filter); 85
} 86
87
#endregion 88
89
common#region common 90
91
/**//// <summary> 92
/// 加入管理员,password应为已MD5加密 93
/// </summary> 94
/// <param name="model"></param> 95
/// <param name="msg"></param> 96
/// <returns></returns> 97
public int Add(AdminInfo model, out string msg) 98
...{ 99
msg = ""; 100
if (model == null) 101
...{ 102
msg = msg + "<li>数据不能为空</li>"; 103
return 0; 104
} 105
bool isErr = false; 106
107
if (isErr) 108
return 0; 109
110
int count = 0; 111
count = Add(model); 112
if (count == 0) 113
msg = "<li>系统发生错误,请重新添加!</li>"; 114
if (count == 1) 115
msg = "<li>添加成功!</li>"; 116
return count; 117
} 118
119
/**//// <summary> 120
/// 不能删除Admin管理员和ID ==1的管理员 121
/// </summary> 122
/// <param name="adminId"></param> 123
/// <returns></returns> 124
public int Delete(int adminId) 125
...{ 126
if (string.IsNullOrEmpty(adminId.ToString()) || adminId == 1) 127
return 0; 128
AdminInfo model = new AdminInfo(); 129
model = GetModel(adminId); 130
if (model == null) 131
return 0; 132
if (model.AdminName == "admin") 133
return 0; 134
135
string filer; 136
filer = " Id =" + adminId; 137
return Delete(filer); 138
} 139
140
/**//// <summary> 141
/// 删除自己以外的管理员(不能删除Admin管理员和ID ==1的管理员) 142
/// </summary> 143
/// <param name="adminId">当前管理员ID</param> 144
/// <returns></returns> 145
public int DeleteAll(int adminId) 146
...{ 147
if (adminId == 0) 148
return 0; 149
return Delete( " Id <> 1 and adminName <> 'admin' and Id <> " + adminId ); 150
} 151
152
public int Update(AdminInfo model) 153
...{ 154
155
if (model == null) 156
...{ 157
return 0; 158
} 159
string filter; 160
filter = " Id=" + model.ID; 161
return Update(model, filter); 162
} 163
164
public AdminInfo GetModel(int adminId) 165
...{ 166
DataSet dataset = new DataSet(); 167
dataset = GetDataSet(" Id=" + adminId); 168
if (dataset != null && dataset.Tables[0].Rows.Count > 0) 169
return GetModel(dataset.Tables[0].Rows[0]); 170
return null; 171
} 172
public AdminInfo GetModel(string adminName) 173
...{ 174
adminName = DataSecurity.ReplaceBadSQL(adminName.Trim()); 175
if (string.IsNullOrEmpty(adminName.ToString())) 176
return null; 177
DataSet dataset = new DataSet(); 178
dataset = GetDataSet(" adminName='" + adminName + "'"); 179
if (dataset != null && dataset.Tables[0].Rows.Count > 0) 180
return GetModel(dataset.Tables[0].Rows[0]); 181
return null; 182
} 183
184
185
/**//// <summary> 186
/// 管理员名是否已被注册 187
/// </summary> 188
/// <param name="adminName"></param> 189
/// <returns></returns> 190
public bool ExistAdminName(string adminName) 191
...{ 192
if (string.IsNullOrEmpty(adminName)) 193
return true; 194
return Exist(" adminname ='" + DataSecurity.ReplaceBadSQL(adminName.Trim()) + "'"); 195
} 196
197
/**//// <summary> 198
/// 管理员是否存在 199
/// </summary> 200
/// <param name="adminName"></param> 201
/// <param name="password">未加密的明码</param> 202
/// <returns></returns> 203
public bool Exist(string adminName, string password) 204
...{ 205
if (Exist("adminname = '" + DataSecurity.ReplaceBadSQL( adminName.Trim() )+ "' and password = '" + StringHelper.MD5( DataSecurity.ReplaceBadSQL(password)) + "'")) 206
...{ 207
return true; 208
} 209
else 210
return false; 211
} 212
213
/**//// <summary> 214
/// 管理员是否存在 215
/// </summary> 216
/// <param name="adminName"></param> 217
/// <param name="password">管理员密码</param> 218
/// <param name="MD5">管理员密码是否已MD5加密</param> 219
/// <returns></returns> 220
public bool Exist(string adminName, string password, bool MD5) 221
...{ 222
password = DataSecurity.ReplaceBadSQL(password); 223
if (MD5) 224
...{ 225
if (Exist("adminname = '" + adminName + "' and password = '" + password + "'")) 226
...{ 227
return true; 228
} 229
else 230
return false; 231
232
} 233
else 234
...{ 235
if (Exist("adminname = '" + adminName + "' and password = '" + StringHelper.MD5(password) + "'")) 236
...{ 237
return true; 238
} 239
else 240
return false; 241
} 242
} 243
244
#endregion 245
246
247
248
} 249
} 250





}