public Userrelation ShowDetail(int?uid)
{
Userrelation relation = new Userrelation();
using (var dbContext = new CasemanaContext())
{
relation = dbContext.Userrelation.FirstOrDefault(x => x.Uid == uid);
}
return(relation);
}
public List <Userrelation> Query(Userrelation relation)
{
List <Userrelation> relations = null;
using (var dbContext = new CasemanaContext())
{
relations = dbContext.Userrelation.Where(x => x.Name.Contains(relation.Name)).ToList();
}
return(relations);
}
public int Create(Userrelation relation)
{
int count = 0;
using (var dbContext = new CasemanaContext())
{
dbContext.Userrelation.Add(relation);
count = dbContext.SaveChanges();
}
return(count);
}
public IActionResult Detail(Userrelation relation)
{
User user = new User
{
relation = relatonService.ShowDetail(relation.Uid),
detail = userService.ShowDetail(relation.Uid),
};
var projects = projectService.GetAll();
ViewData["projects"] = projects;
return(View(user));
}
//更新
public IActionResult Update(Userrelation relation)
{
relation.Ename = employService.ShowDetail(relation.Eid).Ename;
relation.Proname = projectService.ShowDetail((int)relation.Proid).Proname;
if (relatonService.ShowDetail(relation.Uid).Name != relation.Name)
{
var userService = new UserService();
var user = userService.ShowDetail(relation.Uid);
user.Uname = relation.Name;
userService.Update(user);
}
var id = relatonService.Update(relation);
return(Redirect(Url.Action("Detail", "_Userrelation") + $"?uid={id}"));
}
public IActionResult Del(Userrelation relation)
{
var count = userService.Del((int)relation.Uid);
if (count > 0)
{
count = relatonService.Del((int)relation.Uid);
}
if (count == 0)
{
string errormsg = "删除失败";
return(View(errormsg));
}
return(Redirect(Url.Action("Index", "_Userrelation")));
}
public IActionResult Create(Userdetail detail, Userrelation relation)
{
int count = 0;
count = userService.Create(detail);
if (count > 0)
{
relation.Uid = count;
relation.Name = detail.Uname;
relation.Ename = employService.ShowDetail(relation.Eid).Ename;
relation.Proname = projectService.ShowDetail((int)relation.Proid).Proname;
relatonService.Create(relation);
}
return(Redirect(Url.Action("Index", "_Userrelation")));
//else
}
//更新
public int Update(Userrelation relation)
{
using (var dbContext = new CasemanaContext())
{
var x = dbContext.Userrelation.FirstOrDefault(u => u.Uid == relation.Uid);
foreach (PropertyInfo info in typeof(Userrelation).GetProperties())
{
PropertyInfo pro = typeof(Userrelation).GetProperty(info.Name);
if (pro != null)
{
info.SetValue(x, pro.GetValue(relation));
}
}
dbContext.Userrelation.Update(x);
}
return((int)relation.Uid);
}
public IActionResult Index(Userrelation relation)
{
List <Userrelation> relations = null;
if (relation.Name == null)
{
relations = relatonService.GetAll();
}
else
{
relations = relatonService.Query(relation);
}
var projects = projectService.GetAll();
ViewData["projects"] = projects;
ViewData["relations"] = relations;
return(View());
}
public int Del(int uid)
{
int count = 0;
using (var dbContext = new CasemanaContext())
{
var relation = new Userrelation()
{
Uid = uid
};
relation = dbContext.Userrelation.FirstOrDefault(x => x.Uid == uid);
dbContext.Userrelation.Remove(relation);
//将要删除的对象附加到EF容器中
//context.Users.Attach(user);
////Remove()起到了标记当前对象为删除状态，可以删除
//context.Users.Remove(user);
//context.SaveChanges();
//Console.WriteLine("删除成功");
count = dbContext.SaveChanges();
}
return(count);
}
