public void updateUser(User user) { executeNonQuery("UPDATE [User] SET UserName='******', Password='******' WHERE Id=" + user.Id); }
public void insertUser(User user) { executeNonQuery("INSERT INTO [User] (UserName, Password, RegisterTime, IsAdmin) VALUES ('" + user.UserName + "', '" + user.Password + "', '" + user.RegisterTime + "',"+user.IsAdmin+")"); }
public User toUser(DataRow data) { if (data == null) return null; User user = new User(); user.Id = (int)data["Id"]; user.Password = (string)data["Password"]; user.UserName = (string)data["UserName"]; user.RegisterTime = (DateTime)data["RegisterTime"]; user.IsAdmin = (bool)data["IsAdmin"]; return user; }
public ActionResult register(RegisterViewModel m) { if (m.UserName==null || m.Password1 == null || m.Password2 == null) { ViewData["error"] = "没填的input伤不起"; return View(); } m.Password1 = Global.md5(m.Password1); m.Password2 = Global.md5(m.Password2); Provider db = new Provider(); User user = db.getUser(m.UserName); if (user != null) { ViewData["error"] = "哎呀,此用户名已经被注册了"; return View(); } if (m.Password1 != m.Password2) { ViewData["error"] = "两次密码不一样"; return View(); } Regex emailExp = new Regex(@"^\w+@\w+(\.\w+)+(\,\w+@\w+(\.\w+)+)*$"); if (!string.IsNullOrEmpty(m.Email) && !emailExp.Match(m.Email).Success) { ViewData["error"] = "邮箱格式不正确"; return View(); } User u = new User(); u.UserName = m.UserName; u.Password = m.Password1; u.RegisterTime = DateTime.Now; db.insertUser(u); int uid = (int)db.getDataRow("SELECT Id FROM [User] ORDER BY Id DESC")["Id"]; Global.addDefaultTag(uid); UserInfo userinfo = new UserInfo(); userinfo.Id = uid; userinfo.Address = m.Address; userinfo.Email = m.Email; userinfo.Phone = m.Phone; userinfo.Info = ""; db.insertUserInfo(userinfo); return View("msg", new MsgViewModel() { msg = "注册成功", url = "/auth/login" }); }