1using System;
  2using System.Collections.Generic;
  3
  4using System.Data;
  5
  6
  7using MyShop.DALFactory;
  8using MyShop.IDAL;
  9using MyShop.Model;
 10using MyShop.Enumerations;
 11using MyShop.Common;
 12
 13namespace 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