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());
}
