当前文件路径：MyShop/BLL/Admin.cs

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