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

		            
  1using System;
  2using System.Collections.Generic;
  3using System.Text.RegularExpressions;
  4using System.Data;
  5
  6
  7using MyShop.DALFactory;
  8using MyShop.IDAL;
  9using MyShop.Model;
 10
 11namespace MyShop.BLL
 12...{
 13    public class User
 14    ...{
 15        public ConfigInfo configInfo = new ConfigInfo();
 16        private IUser dal = DataAccess.CreateUser();
 17
 18        public User() 
 19        ...{
 20            Config config = new Config();
 21            configInfo = config.GetModel();        
 22        }
 23
 24
 25        IUser member#region IUser member
 26
 27        protected int Add(UserInfo model)
 28        ...{
 29            if (model == null)
 30                return 0;
 31            return dal.Add(model);
 32        }
 33        public 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
 48        public DataSet GetDataSet()
 49        ...{
 50            return dal.GetDataSet();
 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 UserInfo 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
 76        /**//// <summary>
 77        /// 密码必须是已经加密的
 78        /// </summary>
 79        /// <param name="model"></param>
 80        /// <param name="filter"></param>
 81        /// <returns></returns>
 82        public int Update(UserInfo model, string filter)
 83        ...{
 84            if (model == null)
 85                return 0;
 86            filter = filter.Trim();
 87            if (string.IsNullOrEmpty(filter))
 88                return 0;
 89            return dal.Update(model, filter);
 90        }
 91        //-------------------------
 92        #endregion 
 93
 94        common#region common
 95
 96        /**//// <summary>
 97        /// 添加会员
 98        /// </summary>
 99        /// <param name="model"></param>
100        /// <returns>返回值１表示成功，0表示发生错误，－１表示数据为空</returns>
101        public int Add(UserInfo model, out string msg)
102        ...{
103            msg = "";
104            if (1 != configInfo.EnableUserReg)
105            ...{
106                msg = "<li> 本站暂时不能注册</li>";
107                return -1;
108            }
109            if (model == null)
110            ...{
111                msg = "<li> 数据不用为空</li>";
112               
113            }
114            if (Utils.FoundStringInArr(configInfo.UserName_RegDisabled,model.UserName,'|') )
115            ...{
116                msg = msg + "<li> 该用户名被禁止注册</li>";
117                return -1;
118            }
119
120            bool isErr = false;
121
122
123            if (this.Exist(" username='" + model.UserName + "'"))
124            ...{
125                msg = msg + "<li> 用户名已经被注册</li>";
126                isErr = true;
127            }
128            if (Utils.GetStringLength(model.UserName) < 4)
129            ...{
130                msg = msg + "<li> 用户名长度不得小于4(汉字不小于2个)</li>";
131                isErr = true;
132            }
133            if (string.IsNullOrEmpty(model.UserName))
134            ...{
135                msg = msg + "<li>用户名不能为空</li>";
136                isErr = true;
137
138            }
139            if (model.UserName.IndexOf(" ") != -1)
140            ...{
141                msg = msg + "<li>用户名中不允许包含空格</li>";
142                isErr = true;
143            }
144            if (model.UserName.IndexOf("　") != -1)
145            ...{
146                msg = msg + "<li>用户名中不允许包含空格</li>";
147                isErr = true;
148            }
149            if (Utils.ChkBadChar(model.UserName))
150            ...{
151                msg = msg + "<li>用户名中含有非法字符</li>";
152                isErr = true;
153            }
154
155            if (model.UserPassword == "")
156            ...{
157                msg = msg + "<li>密码不能为空</li>";
158                isErr = true;
159            }
160            if ( model.UserPassword.IndexOf(" ") != -1)
161            ...{
162                msg = msg + "<li>用户名中不允许包含空格</li>";
163                isErr = true;
164            }
165
166            if (string.IsNullOrEmpty(model.UserPassword))
167            ...{
168                msg = msg + "<li>用户密码不能为空</li>";
169                isErr = true;
170            }
171            if (Utils.GetStringLength(model.UserPassword) < 6)
172            ...{
173                msg = msg + "<li>用户密码长度不得小于6</li>";
174                isErr = true;
175            }
176            if (model.Answer == "")
177            ...{
178                msg = msg + "<li>问题答案不能为空</li>";
179                isErr = true;
180            }
181            if (this.Exist(" email='" + model.Email + "'") && ( 0 == configInfo.EnableMultiRegPerEmail))
182            ...{
183                msg = msg + "<li> 邮箱已经被其它用户注册使用</li>";
184                isErr = true;
185            }
186            if (!Utils.IsValidEmail(model.Email))
187            ...{
188                msg = msg + "<li> 用户电子邮箱格式不对</li>";
189                isErr = true;
190            }
191            if (model.Email == string.Empty)
192            ...{
193                msg = msg + "<li>用户电子邮件不能为空</li>";
194                isErr = true;
195            }
196
197            if (isErr)
198                return 0;
199
200            if (configInfo.EmailCheckReg == 0)
201                model.GroupId = 1;
202            model.UserPassword = Utils.MD5(  model.UserPassword );
203            model.Answer = Utils.MD5( model.Answer );
204            int count = 0;
205            count = Add(model);
206            if (count == 0)
207                msg = "<li>系统发生错误,请重新注册!</li>";
208            if (count == 1)
209                msg = "<li>注册成功!欢迎 " + model.UserName + " 的加入</li>";
210            return count;
211        }
212
213        public int Delete(int userId)
214        ...{
215            
216            return dal.Delete(userId);
217        }
218
219
220        public int DelteUserByName( string userName )
221        ...{
222            if (string.IsNullOrEmpty(userName.ToString()))
223                return 0;
224            string filer;
225            filer = " userName ='" + userName + "'";
226            return Delete(filer);
227        }
228
229        /**//// <summary>
230        /// 修改会员资料
231        /// </summary>
232        /// <param name="model"></param>
233        /// <returns></returns>
234        public int Update(UserInfo model)
235        ...{
236            if (string.IsNullOrEmpty(model.UserId.ToString()))
237                return 0;
238            string filter = "userid = " + model.UserId;
239            return Update(model, filter);
240        }
241
242        public UserInfo GetModel(int userId)
243        ...{
244            if ( userId == -1)
245                return null;
246            DataSet dataset = new DataSet();
247            dataset = GetDataSet(" userId=" + userId);
248            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
249                return GetModel(dataset.Tables[0].Rows[0]);
250            return null;
251        }
252        
253        #endregion
254
255        public UserInfo GetModel(string username)
256        ...{
257            username = Utils.ReplaceBadChar(username);
258            if (string.IsNullOrEmpty(username))
259                return null;
260            DataSet dataset = new DataSet();
261            dataset = GetDataSet(" username='" + username + "'");
262            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
263                return GetModel(dataset.Tables[0].Rows[0]);
264            return null;
265        }
266
267        /**//// <summary>
268        /// 用户名是否已被注册
269        /// </summary>
270        /// <param name="userName"></param>
271        /// <returns></returns>
272        public bool ExistUserName(string userName)
273        ...{
274            if(string.IsNullOrEmpty(userName))
275                return true;
276            return Exist(" username ='" + Utils.ReplaceBadSQL(userName.Trim()) + "'");
277        }
278
279        /**//// <summary>
280        /// 用户是否存在
281        /// </summary>
282        /// <param name="userName"></param>
283        /// <param name="password">未加密的明码</param>
284        /// <returns></returns>
285        public bool Exist(string userName, string password)
286        ...{
287            if (Exist("username = '" + userName +