public ActionResult Recharge(recharge card) { //充值代码 using (LazyfitnessEntities db = new LazyfitnessEntities()) { recharge searchCard = db.recharge.Where(c => c.rechargeId == card.rechargeId).FirstOrDefault(); if (searchCard == null) { Tools.AlertAndRedirect("卡号或卡密错误", Url.Action("Recharge", "Home")); return(View()); } if (searchCard.rechargePwd != card.rechargePwd) { Tools.AlertAndRedirect("卡号或卡密错误", Url.Action("Recharge", "Home")); return(View()); } if (searchCard.isAvailable == 0) { Tools.AlertAndRedirect("该卡已被使用", Url.Action("Recharge", "Home")); return(View()); } int userId = Int32.Parse(ViewBag.UserId); userInfo user = db.userInfo.Where(u => u.userId == userId).FirstOrDefault(); user.userAccount += searchCard.amount; searchCard.isAvailable = 0; ViewBag.UserInfo = user; db.SaveChanges(); } Tools.AlertAndRedirect("充值成功", Url.Action("Recharge", "Home")); return(View()); }
public string adoptAnswer(int quesAnswId, int userId) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { var dbQuesAnswReply = db.quesAnswReply.Where(u => u.quesAnswId == quesAnswId && u.userId == userId); var obQuesAnswReply = dbQuesAnswReply.FirstOrDefault(); //将此对象的isAgree 改为1 表示采纳 obQuesAnswReply.isAgree = 1; //修改此问答帖子的状态 var dbQuesAnsw = db.quesAnswInfo.Where(u => u.quesAnswId == quesAnswId); var obQuesAnsw = dbQuesAnsw.FirstOrDefault(); //增加回答者的钱 //提问者的钱在提问时就扣除了 int getPayId = userId; var dbInfo = db.userInfo.Where(u => u.userId == getPayId); var obInfo = dbInfo.FirstOrDefault(); obInfo.userAccount += obQuesAnsw.amount; obQuesAnsw.quesAnswStatus = 1; db.SaveChanges(); return("true"); } } catch { return("false"); } }
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 ActionResult PersonalData() { if (Request.Cookies["loginId"] != null) { //获取Cookies的值 HttpCookie cookieName = Request.Cookies["loginId"]; var cookieText = Server.HtmlEncode(cookieName.Value); var loginId = cookieText.ToString(); HttpCookie cookieNameUserId = Request.Cookies["userId"]; var cookieTextUserId = Server.HtmlEncode(cookieNameUserId.Value); var userId = Convert.ToInt32(cookieTextUserId.ToString()); using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userInfo> dbsearch = db.userInfo.Where(u => u.userId == userId) as DbQuery <userInfo>; userInfo _userInfo = dbsearch.FirstOrDefault(); if (_userInfo != null) { ViewBag.userId = _userInfo.userId; ViewBag.userName = _userInfo.userName; ViewBag.userAge = _userInfo.userAge; ViewBag.userSex = _userInfo.userSex; ViewBag.userEmail = _userInfo.userEmail; ViewBag.userStatus = _userInfo.userStatus; ViewBag.userAccount = _userInfo.userAccount; ViewBag.userIntroduce = _userInfo.userIntroduce; ViewBag.userHeaderPic = _userInfo.userHeaderPic; } } } return(View()); }
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 ActionResult findUsername(userInfo info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { userInfo[] user = toolsHelpers.selectToolsController.selectUserInfo(u => u.userEmail == info.userEmail.Trim(), u => u.userId); if (user.Length == 0 || user == null) { Tools.AlertAndRedirect("没有此用户", Url.Action("findUserName", "passwordManager", new { area = "account" })); return(Content("此邮箱没有注册!")); } int userId = user[0].userId; userSecurity[] securityInfo = toolsHelpers.selectToolsController.selectUserSecurity(u => u.userId == userId, u => u.userId); string rightLoginName = securityInfo[0].loginId; Tools.AlertAndRedirect("您的登录名:" + rightLoginName, Url.Action("Index", "Home", new { area = "" })); return(Content(rightLoginName)); } } catch { Tools.AlertAndRedirect("寻找用户名出错,请联系管理员", Url.Action("findUserName", "passwordManager", new { area = "account" })); return(Content("找用户名出错!")); } }
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 addArea(resourceArea area) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { //先检查分区名存不存在 resourceArea[] isExistArea = toolsHelpers.selectToolsController.selectResourceArea(u => u.areaName == area.areaName, u => u.areaId); if (isExistArea.Length != 0) { return("存在相同的名字"); } resourceArea obResourceArea = new resourceArea { areaName = area.areaName.Trim(), areaBrief = area.areaBrief.Trim(), }; if (toolsHelpers.insertToolsController.insertResourceArea(obResourceArea) == true) { Response.Redirect("/backStage/articleManagement/areaManagement"); return("success"); } return("增加分区失败"); } } catch { return("增加分区出错"); } }
/// <summary> /// 修改userInfo表的数据 /// </summary> /// <param name="whereLambda"></param> /// <param name="info"></param> /// <returns></returns> public static Boolean updateUserInfo(Expression <Func <userInfo, bool> > whereLambda, userInfo info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userInfo> dataObject = db.userInfo.Where(whereLambda) as DbQuery <userInfo>; userInfo oldInfo = dataObject.FirstOrDefault(); oldInfo.userName = info.userName; oldInfo.userAge = info.userAge; oldInfo.userSex = info.userSex; oldInfo.userEmail = info.userEmail; oldInfo.userStatus = info.userStatus; oldInfo.userAccount = info.userAccount; oldInfo.userIntroduce = info.userIntroduce; oldInfo.userHeaderPic = info.userHeaderPic; db.SaveChanges(); return(true); } } catch { return(false); } }
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 delete(userInfo info) { try { //此处判断有没有这个userId using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userSecurity> dataObject = db.userSecurity.Where(u => u.userId == info.userId) as DbQuery <userSecurity>; int dataNum = dataObject.ToList().Count; if (dataNum == 0) { return("没有此用户!"); } } if (toolsHelpers.deleteToolsController.deleteUserUserId(info.userId)) { Response.Redirect("/backStage/userManagement/Index"); return("success"); } else { return("false"); } } 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 string login(backManager manager) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <backManager> dbManager = db.backManager.Where(u => u.managerId == manager.managerId) as DbQuery <backManager>; backManager obManager = dbManager.FirstOrDefault(); string MD5Pwd = MD5Helper.MD5Helper.encrypt(manager.managerPwd.Trim()); if (obManager == null) { return("无效用户名"); } DbQuery <backManager> dbManagerPwd = db.backManager.Where(u => u.managerId == manager.managerId).Where(u => u.managerPwd == MD5Pwd) as DbQuery <backManager>; backManager obSurePwd = dbManagerPwd.FirstOrDefault(); if (obSurePwd != null) { HttpCookie cookieName = new HttpCookie("managerId"); cookieName.Value = manager.managerId.ToString(); cookieName.Expires = DateTime.Now.AddHours(1); Response.Cookies.Add(cookieName); return("登录成功"); } else { return("密码错误"); } } } catch { return("登录失败"); } }
//问答帖子分区 public quesAnswInfo[] GetPagedListquesAnsw <TKey>(int pageIndex, int pageSize, Expression <Func <quesAnswInfo, bool> > whereLambda, Expression <Func <quesAnswInfo, TKey> > orderBy) { using (LazyfitnessEntities db = new LazyfitnessEntities()) { //分页时一定注意:Skip之前一定要OrderBy return(db.quesAnswInfo.Where(whereLambda).OrderBy(orderBy).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToArray()); } }
/// <summary> /// 分页查询 /// </summary> /// <typeparam name="TKey"></typeparam> /// <param name="pageIndex">页码</param> /// <param name="pageSize">页容量</param> /// <param name="whereLambda">条件 lambda表达式</param> /// <param name="orderBy">排列 lambda表达式</param> /// <returns></returns> public resourceArea[] GetPagedListArea <TKey>(int pageIndex, int pageSize, Expression <Func <resourceArea, bool> > whereLambda, Expression <Func <resourceArea, TKey> > orderBy) { using (LazyfitnessEntities db = new LazyfitnessEntities()) { //分页时一定注意:Skip之前一定要OrderBy return(db.resourceArea.Where(whereLambda).OrderBy(orderBy).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToArray()); } }
// GET: backStage/articleManagement public ActionResult Index() { using (LazyfitnessEntities db = new LazyfitnessEntities()) { ViewBag.Model = db.resourceArea.ToList(); return(View(ViewBag.Model)); } }
public int GetSumPageCard(int pageSize) { using (LazyfitnessEntities db = new LazyfitnessEntities()) { int listSum = db.recharge.ToList().Count; return((listSum / pageSize) + 1); } }
/// <summary> /// 分页查询 /// </summary> /// <typeparam name="TKey"></typeparam> /// <param name="pageIndex">页码</param> /// <param name="pageSize">页容量</param> /// <param name="whereLambda">条件 lambda表达式</param> /// <param name="orderBy">排列 lambda表达式</param> /// <returns></returns> public List <recharge> GetPagedListCard <TKey>(int pageIndex, int pageSize, Expression <Func <recharge, bool> > whereLambda, Expression <Func <recharge, TKey> > orderBy) { using (LazyfitnessEntities db = new LazyfitnessEntities()) { //分页时一定注意:Skip之前一定要OrderBy return(db.recharge.Where(whereLambda).OrderBy(orderBy).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList()); } }
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 int GetSumPageArea(int pageSize) { using (LazyfitnessEntities db = new LazyfitnessEntities()) { int listSum = db.resourceArea.ToList().Count; if ((listSum != 0) && listSum % pageSize == 0) { return(listSum / pageSize); } return((listSum / pageSize) + 1); } }
public int GetSumPagequesAnsw(int pageSize) { using (LazyfitnessEntities db = new LazyfitnessEntities()) { int listSum = db.quesAnswInfo.ToList().Count; if ((listSum != 0) && listSum % pageSize == 0) { return(listSum / pageSize); } return((listSum / pageSize) + 1); } }
public int GetSumPage(int pageSize, Expression <Func <serverShowInfo, bool> > whereLambda) { using (LazyfitnessEntities db = new LazyfitnessEntities()) { int listSum = db.serverShowInfo.Where(whereLambda).ToList().Count; if ((listSum != 0) && listSum % pageSize == 0) { return(listSum / pageSize); } return((listSum / pageSize) + 1); } }
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 checkEmail(string emailAddress) { using (LazyfitnessEntities db = new LazyfitnessEntities()) { var isExistEmail = db.userInfo.Where(u => u.userEmail == emailAddress.Trim()); if (isExistEmail.ToList().Count != 0) { //邮箱注册过了 return("EF"); } } return("T"); }
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()); } }
public ActionResult PersonalDataUpdate(userInfo info) { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userInfo> dbsearch = db.userInfo.Where(u => u.userId == info.userId) as DbQuery <userInfo>; userInfo _userInfo = dbsearch.FirstOrDefault(); if (_userInfo != null) { if (info.userHeaderPic == null) { _userInfo.userHeaderPic = "/Resource/picture/DefaultHeadPic1.png"; } else { _userInfo.userHeaderPic = info.userHeaderPic; } if (info.userName == null) { _userInfo.userName = "******"; } else { _userInfo.userName = info.userName; } if (info.userAge == null) { _userInfo.userAge = 0; } else { _userInfo.userAge = info.userAge; } _userInfo.userSex = info.userSex; _userInfo.userEmail = info.userEmail; if (info.userIntroduce == null) { _userInfo.userIntroduce = "这个人很懒,没有写简介"; } else { _userInfo.userIntroduce = info.userIntroduce; } db.SaveChanges(); } } Response.Redirect("/Home/PersonalData"); return(Content("sueccess")); }
/// <summary> /// 向论坛回复表中插入信息 /// </summary> /// <param name="info"></param> /// <returns></returns> public static Boolean insertPostReply(postReply info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { db.postReply.Add(info); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// 问答分区表增加数据 /// </summary> /// <param name="info"></param> /// <returns></returns> public static Boolean insertQuesArea(quesArea info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { db.quesArea.Add(info); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// 向文章表中插入信息 /// </summary> /// <param name="info"></param> /// <returns></returns> public static Boolean insertResourceInfo(resourceInfo info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { db.resourceInfo.Add(info); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// 查找文章分区表中的数据 /// </summary> /// <typeparam name="TKey"></typeparam> /// <param name="whereLambda"></param> /// <param name="orderBy"></param> /// <returns></returns> public static resourceArea[] selectResourceArea <TKey>(Expression <Func <resourceArea, bool> > whereLambda, Expression <Func <resourceArea, TKey> > orderBy) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <resourceArea> dataObject = db.resourceArea.Where(whereLambda).OrderBy(orderBy) as DbQuery <resourceArea>; resourceArea[] infoList = dataObject.ToArray(); return(infoList); } } catch { resourceArea[] nullInfo = new resourceArea[0]; return(nullInfo); } }