public void FeedbackUpdate(TBL_FEEDBACK info) { try { HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } DateTime dt = DateTime.Now; info.feedbackTime = dt; if (InsertTools.InsertFeedbackInfo(info) == true) { Response.Write("<script>alert('删除成功!');</script>"); Response.Redirect("/Feedback/Index"); } else { Response.Write("<script>alert('不存在删除内容!');</script>"); Response.Redirect("/Feedback/Index"); } } catch { Response.Write("<script>alert('删除失败!');</script>"); Response.Redirect("/Feedback/Index"); } }
/// <summary> /// 往问题反馈表中插入数据 /// </summary> /// <param name="info">新上传的反馈信息</param> /// <returns></returns> public static Boolean InsertFeedbackInfo(TBL_FEEDBACK info) { try { using (LampNetEntities db = new LampNetEntities()) { db.TBL_FEEDBACK.Add(info); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// 查找问题反馈表中符合条件的信息 /// </summary> /// <param name="whereLambda">u => u.userId == info.userId, u => u.userId</param> /// <returns>问题反馈数组</returns> public static TBL_FEEDBACK[] SelectFeedbackInfo <TKey>(Expression <Func <TBL_FEEDBACK, bool> > whereLambda, Expression <Func <TBL_FEEDBACK, TKey> > orderBy) { try { using (LampNetEntities db = new LampNetEntities()) { DbQuery <TBL_FEEDBACK> dataObject = db.TBL_FEEDBACK.Where(whereLambda).OrderBy(orderBy) as DbQuery <TBL_FEEDBACK>; TBL_FEEDBACK[] infoList = dataObject.ToArray(); return(infoList); } } catch { TBL_FEEDBACK[] nullInfo = new TBL_FEEDBACK[0]; return(nullInfo); } }
/// <summary> /// 修改TBL_FEEDBACK表的数据 /// </summary> /// <param name="whereLambda"> (u=>u.userId == info.userId, info) == true </param> /// 判断有无userId /// <param name="info"> info是需要修改的信息 </param> /// <notice></notice> public static Boolean UpdateFeedbackInfo(Expression <Func <TBL_FEEDBACK, bool> > whereLambda, TBL_FEEDBACK info) { try { using (LampNetEntities db = new LampNetEntities()) { DbQuery <TBL_FEEDBACK> dataObject = db.TBL_FEEDBACK.Where(whereLambda) as DbQuery <TBL_FEEDBACK>; TBL_FEEDBACK oldInfo = dataObject.FirstOrDefault(); oldInfo.userId = info.userId; oldInfo.feedbackTime = info.feedbackTime; oldInfo.feedbackNote = info.feedbackNote; db.SaveChanges(); return(true); } } catch { return(false); } }