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





}