public static void Del(string id) { if (!string.IsNullOrEmpty(id)) { using (pm2Entities entities = new pm2Entities()) { Bud_OrgDiaryCost entity = (from m in entities.Bud_OrgDiaryCost where m.OrgDiaryId == id select m).FirstOrDefault <Bud_OrgDiaryCost>(); if (entity == null) { throw new Exception("找不到要删除的组织机构日记对象!"); } entities.DeleteObject(entity); entities.SaveChanges(); } } }
public static void UpdateFlowState(string id, int state) { if (!string.IsNullOrEmpty(id)) { using (pm2Entities entities = new pm2Entities()) { Bud_OrgDiaryCost cost = (from m in entities.Bud_OrgDiaryCost where m.OrgDiaryId == id select m).FirstOrDefault <Bud_OrgDiaryCost>(); if (cost == null) { throw new Exception("找不到间组织机构日记对象,无法进行修改流程状态!"); } cost.FlowState = state; entities.SaveChanges(); } } }
public void Add(OrganizationDiary orgDiary) { if (orgDiary != null) { using (pm2Entities entities = new pm2Entities()) { int num = Convert.ToInt32(orgDiary.PrjId); Bud_OrgDiaryCost cost = new Bud_OrgDiaryCost { OrgDiaryId = orgDiary.Id, Name = orgDiary.Name, OrgdiaryCode = orgDiary.Code, OrgId = new int?(num), Department = orgDiary.Department, IssuedBy = orgDiary.IssuedBy, InputUser = orgDiary.InputUser, InputDate = orgDiary.InputDate, FlowState = orgDiary.FlowState }; entities.AddToBud_OrgDiaryCost(cost); entities.SaveChanges(); } } }
public void Update(OrganizationDiary orgDiary) { if (orgDiary != null) { using (pm2Entities entities = new pm2Entities()) { Bud_OrgDiaryCost cost = (from m in entities.Bud_OrgDiaryCost where m.OrgDiaryId == orgDiary.Id select m).FirstOrDefault <Bud_OrgDiaryCost>(); if (cost == null) { throw new Exception("找不到要修改的组织机构日记对象!"); } cost.Name = orgDiary.Name; cost.Department = orgDiary.Department; cost.OrgdiaryCode = orgDiary.Code; cost.IssuedBy = orgDiary.IssuedBy; cost.InputDate = orgDiary.InputDate; cost.InputUser = orgDiary.InputUser; 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(); } } }