public void GetGrade(HttpContext context) { try { int uid = Convert.ToInt32(context.Request.Params["UserID"]); //int uid = 1; int SpotScore = Convert.ToInt32(context.Request.Params["SpotScore"]); int DormitorySel = Convert.ToInt32(context.Request.Params["DormitorySel"]); using (IFMPDBContext db = new IFMPDBContext()) { var user = db.User.FirstOrDefault(x => x.ID == uid); SpotCheck SpotCheck = new SpotCheck(); SpotCheck.SpotScore = SpotScore; SpotCheck.DormitoryId = DormitorySel; SpotCheck.CreateUser = user.RealName; SpotCheck.CreateDate = Convert.ToDateTime(DateTime.Now.ToShortDateString()); db.SpotCheck.Add(SpotCheck); db.SaveChanges(); var name = "{\"id\":\"" + SpotCheck.SpotId + "\",\"dormitoryid\":\"" + DormitorySel + "\"}"; sb.Append("{\"result\":\"true\",\"data\":["); sb.Append(name.TrimEnd(',')); sb.Append("]}"); } } catch { sb.Append("{\"result\":\"false\"}"); } context.Response.Clear(); context.Response.Write(sb.ToString().TrimEnd(',')); context.Response.End(); }
public void BindInfo() { using (IFMPDBContext db = new IFMPDBContext()) { SpotProblem spotproblem = db.SpotProblem.FirstOrDefault(x => x.SpId == SpID); if (spotproblem != null) { SpotCheck spotcheck = db.SpotCheck.FirstOrDefault(x => x.SpotId == spotproblem.SpotId); Dormitory dormitory = db.Dormitory.FirstOrDefault(x => x.ID == spotcheck.DormitoryId); this.ltl_DorName.Text = dormitory.DormiName.ToString(); this.ltl_ProDesc.Text = spotproblem.ProDesc.ToString(); this.ltl_DutyUser.Text = spotproblem.DutyUser == null ? "" : db.User.FirstOrDefault(t => t.ID.ToString() == spotproblem.DutyUser).RealName; this.ltl_SState.Text = (spotproblem.IsreView == true ? "是" : "否"); this.ltl_CreateUser.Text = spotproblem.CreateUser == null ? "" : db.User.FirstOrDefault(t => t.ID.ToString() == spotproblem.CreateUser).RealName; this.ltl_CreateDate.Text = spotproblem.CreateDate == null ? "" : spotproblem.CreateDate.Value.ToString("yyyy-MM-dd"); this.ltl_ReviewUser.Text = spotproblem.ReviewUser == null ? "" : db.User.FirstOrDefault(t => t.ID.ToString() == spotproblem.ReviewUser).RealName; this.ltl_ReviewDate.Text = spotproblem.ReviewDate == null ? "" : spotproblem.ReviewDate.Value.ToString("yyyy-MM-dd"); this.ltl_ReviewMemo.Text = spotproblem.ReviewMemo == null ? "" : spotproblem.ReviewMemo.ToString(); if (string.IsNullOrEmpty(spotproblem.SImage)) { this.img.ImageUrl = ""; this.img.Visible = false; } else { this.img.ImageUrl = spotproblem.SImage.Length < 8 ? spotproblem.SImage : (spotproblem.SImage.ToString().Substring(0, 8) == "Templete" ? "../../DormitoryAPP/" + spotproblem.SImage : spotproblem.SImage); } } } }
public void SpotProblemAdd(HttpContext context) { try { int uid = Convert.ToInt32(context.Request.Params["UserID"]); //int uid = 1; int SpotScore = Convert.ToInt32(context.Request.Params["SpotScore"]); int DormitorySel = Convert.ToInt32(context.Request.Params["DormitorySel"]); var ProDesc = context.Request.Params["ProDesc"].TrimEnd(',').Split(','); var DutyUser = context.Request.Params["DutyUser"].TrimEnd(',').Split(','); using (IFMPDBContext db = new IFMPDBContext()) { var user = db.User.FirstOrDefault(x => x.ID == uid); SpotCheck SpotCheck = new SpotCheck(); SpotCheck.SpotScore = SpotScore; SpotCheck.DormitoryId = DormitorySel; SpotCheck.CreateUser = user.RealName; SpotCheck.CreateDate = Convert.ToDateTime(DateTime.Now.ToShortDateString()); db.SpotCheck.Add(SpotCheck); db.SaveChanges(); for (int i = 0; i < ProDesc.Length; i++) { int dutyuderid = int.Parse(DutyUser[i]); SpotProblem SpotProblem = new SpotProblem(); SpotProblem.SpotId = SpotCheck.SpotId; SpotProblem.ProDesc = ProDesc[i]; SpotProblem.DutyUser = db.User.FirstOrDefault(x => x.ID == dutyuderid).RealName; SpotProblem.CreateUser = db.User.FirstOrDefault(x => x.ID == uid).RealName; SpotProblem.CreateDate = Convert.ToDateTime(DateTime.Now.ToShortDateString()); SpotProblem.IsreView = false; db.SpotProblem.Add(SpotProblem); db.SaveChanges(); } sb.Append("{\"result\":\"true\"}"); } } catch { sb.Append("{\"result\":\"false\"}"); } context.Response.Clear(); context.Response.Write(sb.ToString().TrimEnd(',')); context.Response.End(); }