public ActionResult UploadQuests(UploadQuestsViewModel model, int?tId) { //获取当前用户的Id int usrId = (int)HttpContext.Session["usrId"]; int qId = 0; if (ModelState.IsValid) { //新建Quests Quests q = new Quests(); q.ReceiverId = usrId; q.Name = model.qName; q.Type = model.qType; q.Detail = model.qDetail; q.ReleaseTime = DateTime.Now; q.Status = tId != null ? "已接受受助" : "正在审核中"; //向数据库新建元组,并获取新Quests的id using (SSDBEntities db = new SSDBEntities()) { db.Quests.Add(q); db.SaveChanges(); qId = q.Id; } //如果当前有匹配捐赠物品,再新建一条匹配元组 if (tId != null) { //新建ThingsQuests ThingsQuests tq = new ThingsQuests(); tq.ThingId = tId.Value; tq.QuestId = qId; tq.Time = DateTime.Now; //向数据库新建元组 using (SSDBEntities db = new SSDBEntities()) { db.ThingsQuests.Add(tq); Things t = db.Things.Where(x => x.Id == tId.Value).FirstOrDefault(); t.Status = "已接受捐赠"; db.Entry(t).State = EntityState.Modified; db.SaveChanges(); } } //提交成功,跳转至用户主页 return(RedirectToAction("MyQuestsList")); } //模型报错,返回当前页面 return(RedirectToAction("UploadQuests", new { id = tId })); }
int numPerPage = 12;//每页显示条目 // GET: 显示发布请求的表单 // 修改时间: 2019年5月8日 16点09分 public ActionResult UploadQuests(int?id) { if (id != null) { using (SSDBEntities db = new SSDBEntities()) { //查找id对应的捐赠物品 Things t = db.Things.Where(x => x.Id == id.Value).FirstOrDefault(); //查找捐赠者 Users tu = db.Users.Where(x => x.UserId == t.DonatorId).FirstOrDefault(); //新建视图模型 UploadQuestsViewModel res = new UploadQuestsViewModel(); //给视图模型赋值 res.Thing = t; res.Donator = tu; res.qName = t.Name; res.qType = t.Type; return(View(res)); } } return(View()); }