//删除
public bool Delete(int id)
{
try
{
StaffAchieve staffAchieve = dbcontext.StaffAchieveContext.Where(u => u.StaffAchieveID == id).FirstOrDefault();
dbcontext.StaffAchieveContext.Attach(staffAchieve);
dbcontext.StaffAchieveContext.Remove(staffAchieve);
dbcontext.SaveChanges();
return(true);
}
catch (System.Data.SqlClient.SqlException e)
{
throw e;
}
}
//更新IsPass状态
public void UpdateIsPass(int ID, bool isPass)
{
try
{
StaffAchieve NewStaffAchieve = dbcontext.StaffAchieveContext.Find(ID);
if (NewStaffAchieve == null)
{
return;
}
NewStaffAchieve.IsPass = isPass;
dbcontext.SaveChanges();
}
catch
{
throw;
}
}
//添加
public bool Insert(StaffAchieve sa)
{
try
{
if (sa != null)
{
dbcontext.StaffAchieveContext.Add(sa);
dbcontext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (System.Data.SqlClient.SqlException e)
{
throw e;
}
}
