//更新IsPass状态 public void UpdateIsPass(int id, bool Ispass) { AchieveAward newach = dbcontext.AchieveAwardContext.Find(id); if (newach == null) { return; } newach.IsPass = Ispass; dbcontext.SaveChanges(); }
//录入成果报奖信息 public void Insert(AchieveAward achieveAward) { try { dbcontext.AchieveAwardContext.Add(achieveAward); dbcontext.SaveChanges(); } catch { throw; } }
//删除成果报奖信息 public bool Delete(int achieveAwardID) { try { AchieveAward AchieveAward = dbcontext.AchieveAwardContext.Where(u => u.AchieveAwardID == achieveAwardID).FirstOrDefault(); if (AchieveAward == null) { return(true); } dbcontext.AchieveAwardContext.Attach(AchieveAward); dbcontext.AchieveAwardContext.Remove(AchieveAward); dbcontext.SaveChanges(); return(true); } catch { throw; } }
public bool Delete(int[] achieveAwardID) { try { int count = achieveAwardID.Count(); for (int i = 0; i < count; i++) { AchieveAward AchieveAward = new AchieveAward { AchieveAwardID = achieveAwardID[i] }; dbcontext.AchieveAwardContext.Attach(AchieveAward); dbcontext.AchieveAwardContext.Remove(AchieveAward); } dbcontext.SaveChanges(); return(true); } catch { throw; } }
//修改成果报奖信息 public void Update(AchieveAward achieveAward) { try { //AchieveAward AchieveAward = new AchieveAward { AchieveAwardID = AchieveAwardID }; AchieveAward AchieveAward = dbcontext.AchieveAwardContext.Find(achieveAward.AchieveAwardID); AchieveAward.AchievementID = achieveAward.AchievementID; AchieveAward.AwardType = achieveAward.AwardType; AchieveAward.AwardGrade = achieveAward.AwardGrade; AchieveAward.AwardName = achieveAward.AwardName; AchieveAward.AwardPeople = achieveAward.AwardPeople; AchieveAward.AwardUnit = achieveAward.AwardUnit; AchieveAward.SecrecyLevel = achieveAward.SecrecyLevel; AchieveAward.EntryPerson = achieveAward.EntryPerson; AchieveAward.IsPass = achieveAward.IsPass; AchieveAward.Member = achieveAward.Member; dbcontext.SaveChanges(); } catch { throw; } }