public static void Del(string id) { if (!string.IsNullOrEmpty(id)) { using (pm2Entities entities = new pm2Entities()) { Bud_OrgDiaryDetails entity = (from m in entities.Bud_OrgDiaryDetails where m.OrgDiaryDetailsId == id select m).FirstOrDefault <Bud_OrgDiaryDetails>(); if (entity == null) { throw new Exception("找不到要删除的组织机构明细对象!!!"); } entities.DeleteObject(entity); entities.SaveChanges(); } } }
public void Update(CostDiaryDetails orgDetails) { if (orgDetails != null) { using (pm2Entities entities = new pm2Entities()) { Bud_OrgDiaryDetails details = (from m in entities.Bud_OrgDiaryDetails where m.OrgDiaryDetailsId == orgDetails.Id select m).FirstOrDefault <Bud_OrgDiaryDetails>(); if (details == null) { throw new Exception("找不到要修改的组织机构明细对象!"); } details.Name = orgDetails.Name; details.OrgdetailsCode = orgDetails.Code; details.Note = orgDetails.Note; details.Amount = orgDetails.Amount; details.CBSCode = orgDetails.CBSCode; entities.SaveChanges(); } } }
public void Add(OrganizationDiaryDetails orgDetails) { if (orgDetails != null) { using (pm2Entities entities = new pm2Entities()) { Bud_OrgDiaryCost cost = (from m in entities.Bud_OrgDiaryCost where m.OrgDiaryId == orgDetails.InDiaryId select m).FirstOrDefault <Bud_OrgDiaryCost>(); Bud_OrgDiaryDetails details = new Bud_OrgDiaryDetails { OrgDiaryDetailsId = orgDetails.Id, OrgdetailsCode = orgDetails.Code, Name = orgDetails.Name, CBSCode = orgDetails.CBSCode, Bud_OrgDiaryCost = cost, Amount = orgDetails.Amount, Note = orgDetails.Note }; entities.AddToBud_OrgDiaryDetails(details); entities.SaveChanges(); } } }