//删除 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; } }