public string delete(string userName) { try { //根据不可重复的用户名找到userSecurity里面的userId,将其删除 using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userInfo> dbInfo = db.userInfo.Where(u => u.userName == userName.Trim()) as DbQuery <userInfo>; userInfo obInfo = dbInfo.FirstOrDefault(); //创建一个要删除的对象 userSecurity deleSecurity = new userSecurity { userId = obInfo.userId, }; //附加到ef中 db.userSecurity.Attach(deleSecurity); //标记为删除--标记当前对象为删除状态 db.userSecurity.Remove(deleSecurity); db.SaveChanges(); return("删除成功"); } } catch { return("删除失败"); } }
public string update(userInfo info, userSecurity security) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userInfo> dbInfosearch = db.userInfo.Where(u => u.userName == info.userName) as DbQuery <userInfo>; userInfo _userInfo = dbInfosearch.FirstOrDefault(); DbQuery <userSecurity> dbSecuritysearch = db.userSecurity.Where(u => u.userId == _userInfo.userId) as DbQuery <userSecurity>; userSecurity _userSecurity = dbSecuritysearch.FirstOrDefault(); //将要修改的值,放到数据上下文中 _userSecurity.userId = security.userId; _userSecurity.loginId = security.loginId; _userSecurity.userPwd = security.userPwd; _userInfo.userId = info.userId; _userInfo.userName = info.userName; _userInfo.userAge = info.userAge; _userInfo.userSex = info.userSex; _userInfo.userTel = info.userTel; _userInfo.userStatus = info.userStatus; _userInfo.userAccount = info.userAccount; db.SaveChanges(); //将修改之后的值保存到数据库中 } return("修改成功"); } catch { return("修改失败"); } }
public string add(userSecurity security) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { //先判断登录Id是否可用 var isLoginId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()); if (isLoginId.ToList().Count != 0) { return("用户已存在"); } userSecurity user = new userSecurity { loginId = security.loginId, userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd) }; db.userSecurity.Add(user); db.SaveChanges(); } return("增加成功"); } catch { return("增加失败"); } }
public string login(userSecurity security) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userSecurity> dbSecuritySureId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()) as DbQuery <userSecurity>; userSecurity obSureId = dbSecuritySureId.FirstOrDefault(); string MD5Pwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim()); if (obSureId == null) { return("未注册"); } DbQuery <userSecurity> dbSecuritySurePwd = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()).Where(u => u.userPwd == MD5Pwd) as DbQuery <userSecurity>; userSecurity obSurePwd = dbSecuritySurePwd.FirstOrDefault(); if (obSurePwd != null) { HttpCookie cookieName = new HttpCookie("loginId"); cookieName.Value = security.loginId.Trim(); cookieName.Expires = DateTime.Now.AddHours(1); Response.Cookies.Add(cookieName); return("登录成功"); } else { return("密码错误"); } } } catch (Exception ex) { return(ex.ToString()); } }
public string changePassword(string loginId, string userOldPwd, string userPwd) { try { string MD5Pwd = MD5Helper.MD5Helper.encrypt(userOldPwd.Trim()); string MD5NewPwd = MD5Helper.MD5Helper.encrypt(userPwd.Trim()); using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userSecurity> dbSecurity = db.userSecurity.Where(u => u.loginId == loginId.Trim()).Where(u => u.userPwd == MD5Pwd) as DbQuery <userSecurity>; userSecurity obSecurity = dbSecurity.FirstOrDefault(); if (obSecurity == null) { Tools.AlertAndRedirect("用户名或密码错误", Url.Action("changePassword", "passwordManager", new { area = "account" })); return("用户名或密码错误"); } obSecurity.userPwd = MD5NewPwd; db.SaveChanges(); Tools.AlertAndRedirect("修改成功", Url.Action("Logout", "userManagement")); return("修改成功"); } } catch { Tools.AlertAndRedirect("修改失败,请与管理员联系", Url.Action("changePassword", "passwordManager", new { area = "account" })); return("修改失败"); } }
public ActionResult VerifyInfo(userSecurity security, userInfo info, string code) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { userSecurity[] securityInfo = toolsHelpers.selectToolsController.selectUserSecurity(u => u.loginId == security.loginId, u => u.userId); if (securityInfo == null || securityInfo.Length == 0) { Tools.AlertAndRedirect("没有此用户", Url.Action("VerifyInfo", "passwordManager", new { area = "account" })); return(Content("没有此用户")); } int userId = securityInfo[0].userId; userInfo[] user = toolsHelpers.selectToolsController.selectUserInfo(u => u.userId == userId, u => u.userId); if (user == null || user.Length == 0) { Tools.AlertAndRedirect("登录名与邮箱不匹配", Url.Action("VerifyInfo", "passwordManager", new { area = "account" })); return(Content("登录名与邮箱不匹配")); } //获取邮箱 string Email = user[0].userEmail; //把用户输入的验证码 和邮箱地址进行加密验证 string encryptCode = certificateTools.encryptContent(Email); string encryptemailAddress = certificateTools.encryptContent(code); //获取Cookies的值 HttpCookie cookieName = Request.Cookies["emailCodePassword"]; var rightCode = Server.HtmlEncode(cookieName.Value); HttpCookie cookieAddress = Request.Cookies["emailAddressPassword"]; var rightEmail = Server.HtmlEncode(cookieAddress.Value); if (rightEmail != encryptCode || rightCode != encryptemailAddress) { //验证码错误 Tools.AlertAndRedirect("验证失败!", Url.Action("VerifyInfo", "passwordManager", new { area = "account" })); return(Content("验证失败!")); } userSecurity obSecurity = db.userSecurity.Where(u => u.userId == userId).FirstOrDefault(); obSecurity.userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim()); db.SaveChanges(); //清空找回密码相关的cookies Response.Cookies.Add(CookiesHelper.CookiesHelper.clearCookie("emailCodePassword")); Response.Cookies.Add(CookiesHelper.CookiesHelper.clearCookie("emailAddressPassword")); Tools.AlertAndRedirect("修改成功", Url.Action("login", "userManagement", new { area = "account" })); return(Content("修改成功!")); } } catch { Tools.AlertAndRedirect("验证出错,请与管理员联系", Url.Action("VerifyInfo", "passwordManager", new { area = "account" })); return(Content("验证出错")); } }
public JsonResult AjaxTest() { userSecurity obj = new userSecurity { userId = 10086, loginId = "CY", userPwd = "123" }; return(Json(obj, JsonRequestBehavior.AllowGet)); }
public string add(userSecurity security) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { //先判断登录Id是否可用 var isLoginId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()); if (isLoginId.ToList().Count != 0) { return("用户已存在"); } userSecurity user = new userSecurity { loginId = security.loginId, userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd) }; //得到插入成功的数据对象以获得userId userSecurity successUser = toolsHelpers.insertToolsController.insertUserSecurity(user); if (successUser == null) { return("false"); } //把这个userId写入userInfo表中 userInfo newUserInfo = new userInfo { userId = successUser.userId, userName = successUser.loginId, userAge = 0, userSex = 2, userEmail = null, userStatus = 1, userAccount = 0, userIntroduce = "这个人很懒,没有说什么", userHeaderPic = "/Resource/picture/DefaultHeadPic1.png", }; if (toolsHelpers.insertToolsController.insertUserInfo(newUserInfo) == true) { Response.Redirect("/backStage/userManagement/Index"); return("success"); } else { return("false"); } } } catch { return("false"); } }
public string registerUser(userSecurity security, userInfo info, string code) { //使用entity framework 进行数据的插入 try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { //先把用户写入userSecurity表 var isLoginID = db.userSecurity.Where <userSecurity>(u => u.loginId == security.loginId.Trim()); if (isLoginID.ToList().Count != 0) { return("已经有账户"); } userSecurity obSecurity = new userSecurity { loginId = security.loginId.Trim(), userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim()), }; db.userSecurity.Add(obSecurity); db.SaveChanges(); //把userInfo表写入默认数据 int uniformId; DbQuery <userSecurity> dbSecuritySureUserId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()) as DbQuery <userSecurity>; userSecurity dbSecurity = dbSecuritySureUserId.FirstOrDefault(); uniformId = dbSecurity.userId; userInfo obInfo = new userInfo { userId = uniformId, userName = security.loginId.Trim(), userAge = info.userAge, userSex = info.userSex, userEmail = info.userEmail, userStatus = 1, userAccount = 0, userIntroduce = "这个人很懒,没有说什么", userHeaderPic = "/Resource/picture/DefaultHeadPic1.png" }; db.userInfo.Add(obInfo); db.SaveChanges(); } Response.Redirect(Url.Action("Index", "Home", new { area = "" })); return("Ok"); } catch (Exception EX) { return(EX.ToString()); } }
/// <summary> /// 查找用户安全表中符合条件的信息 /// </summary> /// <param name="whereLambda"></param> /// <returns></returns> public static userSecurity[] selectUserSecurity <TKey>(Expression <Func <userSecurity, bool> > whereLambda, Expression <Func <userSecurity, TKey> > orderBy) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userSecurity> dataObject = db.userSecurity.Where(whereLambda).OrderBy(orderBy) as DbQuery <userSecurity>; userSecurity[] infoList = dataObject.ToArray(); return(infoList); } } catch { userSecurity[] nullInfo = new userSecurity[0]; return(nullInfo); } }
/// <summary> /// 往用户安全表中插入数据 /// </summary> /// <param name="info"></param> /// <returns>插入数据后的对象</returns> public static userSecurity insertUserSecurity(userSecurity info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { db.userSecurity.Add(info); db.SaveChanges(); DbQuery <userSecurity> data = db.userSecurity.Where(u => u.loginId == info.loginId) as DbQuery <userSecurity>; userSecurity objectUser = data.FirstOrDefault(); return(objectUser); } } catch { return(null); } }
public string register(userSecurity security, userInfo info) { //使用entity framework 进行数据的插入 try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { var isLoginID = db.userSecurity.Where <userSecurity>(u => u.loginId == info.userName.Trim()); if (isLoginID.ToList().Count != 0) { return("已经有账户"); } userSecurity obSecurity = new userSecurity { loginId = info.userName.Trim(), userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim()), }; db.userSecurity.Add(obSecurity); db.SaveChanges(); int uniformId; DbQuery <userSecurity> dbSecuritySureUserId = db.userSecurity.Where(u => u.loginId == info.userName.Trim()) as DbQuery <userSecurity>; userSecurity dbSecurity = dbSecuritySureUserId.FirstOrDefault(); uniformId = dbSecurity.userId; userInfo obInfo = new userInfo { userId = uniformId, userName = info.userName.Trim(), userAge = info.userAge, userSex = info.userSex, userTel = info.userTel.Trim(), }; db.userInfo.Add(obInfo); db.SaveChanges(); } return("T"); } catch (Exception ex) { return(ex.ToString()); } }
public string login(userSecurity security) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userSecurity> dbSecuritySureId = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()) as DbQuery <userSecurity>; userSecurity obSureId = dbSecuritySureId.FirstOrDefault(); string MD5Pwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim()); if (obSureId == null) { return("未注册"); } DbQuery <userSecurity> dbSecuritySurePwd = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()).Where(u => u.userPwd == MD5Pwd) as DbQuery <userSecurity>; userSecurity obSurePwd = dbSecuritySurePwd.FirstOrDefault(); if (obSurePwd != null) { HttpCookie cookieName = new HttpCookie("loginId"); cookieName.Value = security.loginId.Trim(); cookieName.Expires = DateTime.Now.AddHours(1); System.Web.HttpContext.Current.Response.Cookies.Add(CookiesHelper.CookiesHelper.creatCookieHours("userId", obSurePwd.userId.ToString(), 1)); string encryptCertification = certificateTools.makeCertification(obSureId.userId.ToString()); System.Web.HttpContext.Current.Response.Cookies.Add(CookiesHelper.CookiesHelper.creatCookieHours("certification", encryptCertification, 1)); System.Web.HttpContext.Current.Response.Cookies.Add(cookieName); Response.Redirect(Url.Action("Index", "Home", new { area = "" })); return("登录成功"); } else { return("密码错误"); } } } catch (Exception ex) { return(ex.ToString()); } }
public ActionResult search(userInfo info) { try { ViewBag.IsSearchSuccess = false; using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userInfo> dbInfosearch = db.userInfo.Where(u => u.userName == info.userName) as DbQuery <userInfo>; userInfo _userInfo = dbInfosearch.FirstOrDefault(); DbQuery <userSecurity> dbSecuritysearch = db.userSecurity.Where(u => u.userId == _userInfo.userId) as DbQuery <userSecurity>; userSecurity _userSecurity = dbSecuritysearch.FirstOrDefault(); if (_userInfo != null) { ViewBag.userId = _userSecurity.userId; ViewBag.loginId = _userSecurity.loginId; ViewBag.userPwd = _userSecurity.userPwd; ViewBag.userName = _userInfo.userName; ViewBag.userAge = _userInfo.userAge; ViewBag.userSex = _userInfo.userSex; ViewBag.userTel = _userInfo.userTel; ViewBag.userStatus = _userInfo.userStatus; ViewBag.userAccount = _userInfo.userAccount; } else { return(View("update")); } } ViewBag.IsSearchSuccess = true; return(View("update")); } catch { return(View("update")); } }
public string chagePassword(userSecurity security, string userNewPwd) { try { string MD5Pwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim()); string MD5NewPwd = MD5Helper.MD5Helper.encrypt(userNewPwd.Trim()); using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userSecurity> dbSecurity = db.userSecurity.Where(u => u.loginId == security.loginId.Trim()).Where(u => u.userPwd == MD5Pwd) as DbQuery <userSecurity>; userSecurity obSecurity = dbSecurity.FirstOrDefault(); if (obSecurity == null) { return("用户名或密码错误"); } obSecurity.userPwd = MD5NewPwd; db.SaveChanges(); return("修改成功"); } } catch { return("修改失败"); } }
public string findPassword(userSecurity security, userInfo info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userInfo> dbInfo = db.userInfo.Where(u => u.userName == info.userName.Trim()).Where(u => u.userTel == info.userTel.Trim()) as DbQuery <userInfo>; userInfo obInfo = dbInfo.FirstOrDefault(); if (obInfo == null) { return("用户名或电话不正确"); } //实例化一个要修改的对象 userSecurity obSecurity = db.userSecurity.Where(u => u.loginId == info.userName.Trim()).FirstOrDefault(); obSecurity.userPwd = MD5Helper.MD5Helper.encrypt(security.userPwd.Trim()); db.SaveChanges(); return("修改成功"); } } catch { return("验证失败"); } }