/// <summary> /// 删除文章分区表中的数据 /// </summary> /// <param name="whereLambda"></param> /// <returns></returns> public static Boolean deleteResourceAreaInfo(Expression <Func <resourceArea, bool> > whereLambda) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <resourceArea> infoList = db.resourceArea.Where(whereLambda) as DbQuery <resourceArea>; List <resourceArea> listResourceInfoAreaId = infoList.ToList(); db.resourceArea.RemoveRange(listResourceInfoAreaId); db.SaveChanges(); return(true); } } catch { return(false); } }
public void QuestionReply(int quesId, string reply, int userId) { quesAnswReply qarInfo = new quesAnswReply { quesAnswId = quesId, userId = userId, replyTime = DateTime.Now, replyContent = reply, isAgree = 0 }; using (LazyfitnessEntities db = new LazyfitnessEntities()) { db.quesAnswReply.Add(qarInfo); db.SaveChanges(); Response.Redirect(Url.Action("QuestionDetail", "Home", new { num = quesId })); } }
/// <summary> /// 删除用户安全表中符合的数据 /// </summary> /// <param name="whereLambda"></param> /// <returns></returns> public static Boolean deleteUserSecurity(Expression <Func <userSecurity, bool> > whereLambda) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userSecurity> dbDelete = db.userSecurity.Where(whereLambda) as DbQuery <userSecurity>; List <userSecurity> obDelete = dbDelete.ToList(); db.userSecurity.RemoveRange(obDelete); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// 往文章分区表修改数据 /// </summary> /// <param name="whereLambda"></param> /// <param name="info"></param> /// <returns></returns> public static Boolean updateResourceArea(Expression <Func <resourceArea, bool> > whereLambda, resourceArea info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <resourceArea> dataObject = db.resourceArea.Where(whereLambda) as DbQuery <resourceArea>; resourceArea oldInfo = dataObject.FirstOrDefault(); oldInfo.areaName = info.areaName; oldInfo.areaBrief = info.areaBrief; db.SaveChanges(); return(true); } } catch { return(false); } }
/// <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 void QuestionSubmit(int areaId, int userId, string title, string editor, int money) { userInfo info = Tools.GetUserInfo(userId); if (info.userAccount == null) { info.userAccount = 0; } if (info.userAccount < money) { money = (int)info.userAccount; } else { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userInfo> dbsearch = db.userInfo.Where(u => u.userId == userId) as DbQuery <userInfo>; userInfo _userinfo = dbsearch.FirstOrDefault(); _userinfo.userAccount -= money; db.SaveChanges(); } } quesAnswInfo qaInfo = new quesAnswInfo { areaId = areaId, quesAnswTitle = title, userId = userId, quesAnswTime = DateTime.Now, pageView = 0, isPost = 0, quesAnswStatus = 1, amount = money, quesAnswContent = editor }; using (LazyfitnessEntities db = new LazyfitnessEntities()) { db.quesAnswInfo.Add(qaInfo); db.SaveChanges(); Response.Redirect(Url.Action("QuestionPart", "Home", new { partId = areaId })); } }
public void ArticleSubmit(string title, string editor, int userId, int areaId) { resourceInfo rInfo = new resourceInfo { areaId = 1, resourceTime = DateTime.Now, pageView = 0, isTop = 0, resourceName = title, resourceContent = editor, userId = 1 }; using (LazyfitnessEntities db = new LazyfitnessEntities()) { db.resourceInfo.Add(rInfo); db.SaveChanges(); Response.Redirect(Url.Action("ArticlePart", "Home", new { partId = areaId })); } }
/// <summary> /// 往充值卡表修改数据 /// </summary> /// <param name="whereLambda"></param> /// <param name="info"></param> /// <returns></returns> public static Boolean updateRecharge(Expression <Func <recharge, bool> > whereLambda, recharge info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <recharge> dataObject = db.recharge.Where(whereLambda) as DbQuery <recharge>; recharge oldInfo = dataObject.FirstOrDefault(); oldInfo.rechargePwd = info.rechargePwd; oldInfo.amount = info.amount; oldInfo.isAvailable = info.isAvailable; db.SaveChanges(); return(true); } } catch { return(false); } }
public void forumSubmit(int areaId, int userId, string title, string editor) { postInfo pInfo = new postInfo { areaId = areaId, postTitle = title, userId = userId, postTime = DateTime.Now, pageView = 0, isPost = 0, postStatus = 1, postContent = editor }; using (LazyfitnessEntities db = new LazyfitnessEntities()) { db.postInfo.Add(pInfo); db.SaveChanges(); Response.Redirect(Url.Action("forumPart", "Home", new { partId = areaId })); } }
/// <summary> /// 往展示表修改数据 /// </summary> /// <param name="whereLambda"></param> /// <param name="info"></param> /// <returns></returns> public static Boolean updateServerShowInfo(Expression <Func <serverShowInfo, bool> > whereLambda, serverShowInfo info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <serverShowInfo> dataObject = db.serverShowInfo.Where(whereLambda) as DbQuery <serverShowInfo>; serverShowInfo oldInfo = dataObject.FirstOrDefault(); oldInfo.title = info.title; oldInfo.pictureAdr = info.pictureAdr; oldInfo.url = info.url; oldInfo.Infostatus = info.Infostatus; db.SaveChanges(); return(true); } } catch { return(false); } }
public ActionResult SaveImage(int userId) { HttpPostedFileBase imageName = Request.Files["image"];// 从前台获取文件 if (imageName == null) { return(Content("(error)未获取到文件")); } string file = imageName.FileName; string fileFormat = file.Split('.')[file.Split('.').Length - 1]; // 以“.”截取,获取“.”后面的文件后缀 Regex imageFormat = new Regex(@"^(bmp)|(png)|(gif)|(jpg)|(jpeg)"); // 验证文件后缀的表达式(自己写的,不规范别介意哈) if (string.IsNullOrEmpty(file) || !imageFormat.IsMatch(fileFormat)) // 验证后缀,判断文件是否是所要上传的格式 { return(Content("(error)文件格式支持(bmp)|(png)|(gif)|(jpg)|(jpeg)")); } else { string timeStamp = DateTime.Now.Ticks.ToString(); // 获取当前时间的string类型 string firstFileName = timeStamp.Substring(0, timeStamp.Length - 4); // 通过截取获得文件名 string imageStr = "/upload/"; // 获取保存图片的项目文件夹 string uploadPath = Server.MapPath("~/" + imageStr); // 将项目路径与文件夹合并 string pictureFormat = file.Split('.')[file.Split('.').Length - 1]; // 设置文件格式 string fileName = firstFileName + "." + fileFormat; // 设置完整(文件名+文件格式) string saveFile = uploadPath + fileName; //文件路径 imageName.SaveAs(saveFile); // 保存文件 // 如果单单是上传,不用保存路径的话,下面这行代码就不需要写了! string image = imageStr + fileName; // 设置数据库保存的路径 using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <userInfo> dbsearch = db.userInfo.Where(u => u.userId == userId) as DbQuery <userInfo>; userInfo _userInfo = dbsearch.FirstOrDefault(); _userInfo.userHeaderPic = image; db.SaveChanges(); } } Response.Redirect("/Home/PersonalData"); return(Content("sueccess")); }
/// <summary> /// 删除充值卡表中符合的数据 /// </summary> /// <param name="whereLambda"></param> /// <returns></returns> public static Boolean deleteRecharge(Expression <Func <recharge, bool> > whereLambda) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <recharge> dbDelete = db.recharge.Where(whereLambda) as DbQuery <recharge>; List <recharge> obDelete = dbDelete.ToList(); if (obDelete.Count == 0) { return(false); } db.recharge.RemoveRange(obDelete); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// 修改文章表中的数据 /// </summary> /// <param name="whereLambda"></param> /// <param name="info"></param> /// <returns></returns> public static Boolean updateResourceInfo(Expression <Func <resourceInfo, bool> > whereLambda, resourceInfo info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <resourceInfo> dataObject = db.resourceInfo.Where(whereLambda) as DbQuery <resourceInfo>; resourceInfo oldInfo = dataObject.FirstOrDefault(); oldInfo.areaId = info.areaId; oldInfo.resourceName = info.resourceName; oldInfo.pageView = info.pageView; oldInfo.isTop = info.isTop; oldInfo.resourceContent = info.resourceContent; db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// 删除展示表中符合的数据 /// </summary> /// <param name="whereLambda"></param> /// <returns></returns> public static Boolean deleteServerShowInfo(Expression <Func <serverShowInfo, bool> > whereLambda) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <serverShowInfo> dbDelete = db.serverShowInfo.Where(whereLambda) as DbQuery <serverShowInfo>; List <serverShowInfo> obDelete = dbDelete.ToList(); if (obDelete.Count == 0) { return(false); } db.serverShowInfo.RemoveRange(obDelete); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> ///删除帖子回复表中符合的数据 /// </summary> /// <param name="whereLambda"></param> /// <returns></returns> public static Boolean deletePostReply(Expression <Func <postReply, bool> > whereLambda) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <postReply> dbDelete = db.postReply.Where(whereLambda) as DbQuery <postReply>; List <postReply> obDelete = dbDelete.ToList(); if (obDelete.Count == 0) { return(true); } db.postReply.RemoveRange(obDelete); db.SaveChanges(); return(true); } } catch { return(false); } }
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("验证失败"); } }
/// <summary> /// 修改问答帖子表中的数据 /// </summary> /// <param name="whereLambda"></param> /// <param name="info"></param> /// <returns></returns> public static Boolean updateQuesAnswInfo(Expression <Func <quesAnswInfo, bool> > whereLambda, quesAnswInfo info) { try { using (LazyfitnessEntities db = new LazyfitnessEntities()) { DbQuery <quesAnswInfo> dataObject = db.quesAnswInfo.Where(whereLambda) as DbQuery <quesAnswInfo>; quesAnswInfo oldInfo = dataObject.FirstOrDefault(); oldInfo.areaId = info.areaId; oldInfo.quesAnswTitle = info.quesAnswTitle; oldInfo.pageView = info.pageView; oldInfo.isPost = info.isPost; oldInfo.amount = info.amount; oldInfo.quesAnswStatus = info.quesAnswStatus; oldInfo.quesAnswContent = info.quesAnswContent; db.SaveChanges(); return(true); } } catch { return(false); } }