public List <Thecase> Query(int proid, Thecase thecase) { List <Thecase> thecases = null; using (var dbContext = new CasemanaContext()) { //if (thecase.Proid != null) //{ // thecases = dbContext.Thecase.Where(x => x.Proid == thecase.Proid).ToList(); //} //else if (thecase.Pid != null) //{ // thecases = dbContext.Thecase.Where(x => x.Pid == thecase.Pid).ToList(); //} //else if (thecase.Unid != null) //{ // thecases = dbContext.Thecase.Where(x => x.Unid == thecase.Unid).ToList(); //} //else if (proid == 0) { thecases = dbContext.Thecase.Where(x => x.Ctitle.Contains(thecase.Ctitle)).ToList(); } else { thecases = dbContext.Thecase.Where(x => x.Ctitle.Contains(thecase.Ctitle) && x.Proid == proid).ToList(); } } return(thecases); }
//更新 public IActionResult Update(ForCase forCase) { var casedetail = new Casedetail(); var thecase = new Thecase(); foreach (PropertyInfo info in typeof(Thecase).GetProperties()) { PropertyInfo pro = typeof(ForCase).GetProperty(info.Name); if (pro != null) { info.SetValue(thecase, pro.GetValue(forCase)); } } foreach (PropertyInfo info in typeof(Casedetail).GetProperties()) { PropertyInfo pro = typeof(ForCase).GetProperty(info.Name); if (pro != null) { info.SetValue(casedetail, pro.GetValue(forCase)); } } thecase.Uid = caseService.ShowDetail(forCase.Cid).Uid; thecase.Toname = relationService.ShowDetail(forCase.Uid2).Name; casedetail.Uid = forCase.Uid2; caseService.Update(thecase); detailservice.Update(casedetail); return(Redirect(Url.Action("Detail", "_Case") + $"?cid={forCase.Cid}")); }
public Thecase ShowDetail(int cid) { Thecase thecase = null; using (var dbContext = new CasemanaContext()) { thecase = dbContext.Thecase.FirstOrDefault(x => x.Cid == cid); } return(thecase); }
public int Create(Thecase thecase) { int count = 0; using (var dbContext = new CasemanaContext()) { dbContext.Thecase.Add(thecase); count = dbContext.SaveChanges(); } if (count == 0) { } return(thecase.Cid); }
//更新 public int Update(Thecase thecase) { int count = 0; using (var dbContext = new CasemanaContext()) { var x = dbContext.Thecase.FirstOrDefault(u => u.Cid == thecase.Cid); foreach (PropertyInfo info in typeof(Thecase).GetProperties()) { PropertyInfo pro = typeof(Thecase).GetProperty(info.Name); if (pro != null) { info.SetValue(x, pro.GetValue(thecase)); } } dbContext.Thecase.Update(x); dbContext.SaveChanges(); } return(thecase.Cid); }
public int Del(int cid) { int count = 0; using (var dbContext = new CasemanaContext()) { var thecase = new Thecase() { Cid = cid }; dbContext.Thecase.Attach(thecase); dbContext.Thecase.Remove(thecase); //将要删除的对象附加到EF容器中 //context.Users.Attach(user); ////Remove()起到了标记当前对象为删除状态,可以删除 //context.Users.Remove(user); //context.SaveChanges(); //Console.WriteLine("删除成功"); count = dbContext.SaveChanges(); } return(count); }
public IActionResult Create(ForCase forCase) { int count = 0; var casedetail = new Casedetail() { Uid = forCase.Uid2, ModifyDate = DateTime.Now, Prior = forCase.Prior, Detail = forCase.Detail, Previous = forCase.Previous, }; var cid = detailservice.Create(casedetail); if (cid > 0) { var json = HttpContext.Request.Cookies["user"]; User loginuser = JsonConvert.DeserializeObject <User>(json); var thecase = new Thecase() { Cid = cid, Uid = loginuser.detail.Uid, Pid = forCase.Pid, Unid = forCase.Unid, Proid = loginuser.relation.Proid, Ctitle = forCase.Ctitle, Name = loginuser.detail.Uname, State = "enable", Toname = relationService.ShowDetail(forCase.Uid2).Name, }; count = caseService.Create(thecase); if (count == 0) { detailservice.Del(cid); } } return(Redirect(Url.Action("Index", "_Case"))); //else }
public IActionResult Index(Thecase caselist) { var json = HttpContext.Request.Cookies["user"]; User loginuser = JsonConvert.DeserializeObject <User>(json); List <Plan> plans = null; List <Unit> units = null; List <Project> projects = null; List <Userrelation> relations = null; List <Thecase> cases = null; if (loginuser.relation.Eid == 1) { plans = planService.GetAll(); projects = projectService.GetAll(); units = unitService.GetAll(); relations = relationService.GetAll(); if (caselist.Proid > 0) { cases = caseService.QueryByProid((int)caselist.Proid); } else if (caselist.Pid > 0) { cases = caseService.QueryByPid((int)caselist.Pid); } else if (caselist.Unid > 0) { cases = caseService.QueryByUnid((int)caselist.Unid); } else if (caselist.State != null) { cases = caseService.QueryByState(caselist.State); } else if (caselist.Name != null) { cases = caseService.QueryByName(loginuser.relation.Name); } else if (caselist.Toname != null) { cases = caseService.QueryByToName(loginuser.relation.Name); } else if (caselist.State != null) { cases = caseService.QueryByState(caselist.State); } else if (caselist.Ctitle == null) { cases = caseService.GetAll(); } else { cases = caseService.Query(0, caselist); } } else { int proid = (int)loginuser.relation.Proid; projects = projectService.QueryById(proid); plans = planService.QueryByProid(proid); units = unitService.QueryByProid(proid); relations = relationService.QueryByProid(proid); if (caselist.Pid > 0) { cases = caseService.QueryByPid((int)caselist.Pid); } else if (caselist.Unid > 0) { cases = caseService.QueryByUnid((int)caselist.Unid); } else if (caselist.State != null) { cases = caseService.QueryByState(caselist.State); } else if (caselist.Name != null) { cases = caseService.QueryByName(loginuser.relation.Name); } else if (caselist.Toname != null) { cases = caseService.QueryByToName(loginuser.relation.Name); } else if (caselist.Ctitle == null) { cases = caseService.QueryByProid(proid); } else { cases = caseService.Query(proid, caselist); } } ViewData["projects"] = projects; ViewData["plans"] = plans; ViewData["units"] = units; ViewData["relations"] = relations; ViewData["cases"] = cases; return(View()); }