public int Create(Userdetail detail)
{
using (var dbContext = new CasemanaContext())
{
dbContext.Userdetail.Add(detail);
dbContext.SaveChanges();
}
return(detail.Uid);
}
public int Create(Project project)
{
int count = 0;
using (var dbContext = new CasemanaContext()) {
dbContext.Project.Add(project);
count = dbContext.SaveChanges();
}
return(count);
}
public int Create(Casedetail casedetail)
{
int count = 0;
using (var dbContext = new CasemanaContext())
{
dbContext.Casedetail.Add(casedetail);
count = dbContext.SaveChanges();
}
return(casedetail.Cid);
}
public int Create(Unit unit)
{
int count = 0;
using (var dbContext = new CasemanaContext())
{
dbContext.Unit.Add(unit);
count = dbContext.SaveChanges();
}
return(count);
}
/// <summary>
/// 添加计划
/// </summary>
/// <param name="pname"></param>
/// <param name="pstorage"></param>
/// <returns></returns>
public int Create(Plan plan)
{
int count = 0;
using (var dbContext = new CasemanaContext())
{
dbContext.Plan.Add(plan);
count = dbContext.SaveChanges();
}
return(count);
}
public int Create(Userrelation relation)
{
int count = 0;
using (var dbContext = new CasemanaContext())
{
dbContext.Userrelation.Add(relation);
count = dbContext.SaveChanges();
}
return(count);
}
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 Update(Casedetail casedetail)
{
int count = 0;
using (var dbContext = new CasemanaContext())
{
var x = dbContext.Casedetail.FirstOrDefault(u => u.Cid == casedetail.Cid);
foreach (PropertyInfo info in typeof(Casedetail).GetProperties())
{
PropertyInfo pro = typeof(Casedetail).GetProperty(info.Name);
if (pro != null)
{
info.SetValue(x, pro.GetValue(casedetail));
}
}
dbContext.Casedetail.Update(x);
count = dbContext.SaveChanges();
}
return(casedetail.Cid);
}
//更新
public int Update(Project project)
{
int count = 0;
using (var dbContext = new CasemanaContext())
{
var x = dbContext.Project.FirstOrDefault(u => u.Proid == project.Proid);
foreach (PropertyInfo info in typeof(Project).GetProperties())
{
PropertyInfo pro = typeof(Project).GetProperty(info.Name);
if (pro != null)
{
info.SetValue(x, pro.GetValue(project));
}
}
dbContext.Project.Update(x);
count = dbContext.SaveChanges();
}
return(project.Proid);
}
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 int Update(Userdetail detail)
{
int count = 0;
using (var dbContext = new CasemanaContext())
{
var x = dbContext.Userdetail.FirstOrDefault(u => u.Uid == detail.Uid);
var password = x.Passwod;
foreach (PropertyInfo info in typeof(Userdetail).GetProperties())
{
PropertyInfo pro = typeof(Userdetail).GetProperty(info.Name);
if (pro != null)
{
info.SetValue(x, pro.GetValue(detail));
}
}
x.Passwod = password;
dbContext.Userdetail.Update(x);
count = dbContext.SaveChanges();
}
return(detail.Uid);
}
public int Del(int uid)
{
int count = 0;
using (var dbContext = new CasemanaContext())
{
var user = new Userdetail()
{
Uid = uid
};
dbContext.Userdetail.Attach(user);
dbContext.Userdetail.Remove(user);
//将要删除的对象附加到EF容器中
//context.Users.Attach(user);
////Remove()起到了标记当前对象为删除状态，可以删除
//context.Users.Remove(user);
//context.SaveChanges();
//Console.WriteLine("删除成功");
count = dbContext.SaveChanges();
}
return(count);
}
public int Del(int proid)
{
int count = 0;
using (var dbContext = new CasemanaContext())
{
var project = new Project()
{
Proid = proid
};
dbContext.Project.Attach(project);
dbContext.Project.Remove(project);
//将要删除的对象附加到EF容器中
//context.Users.Attach(user);
////Remove()起到了标记当前对象为删除状态，可以删除
//context.Users.Remove(user);
//context.SaveChanges();
//Console.WriteLine("删除成功");
count = dbContext.SaveChanges();
}
return(count);
}
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);
}
