public static void Del(string id) { if (!string.IsNullOrEmpty(id)) { using (pm2Entities entities = new pm2Entities()) { Bud_IndirectDiaryCost entity = (from m in entities.Bud_IndirectDiaryCost where m.InDiaryId == id select m).FirstOrDefault <Bud_IndirectDiaryCost>(); 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_IndirectDiaryCost cost = (from m in entities.Bud_IndirectDiaryCost where m.InDiaryId == id select m).FirstOrDefault <Bud_IndirectDiaryCost>(); if (cost == null) { throw new Exception("找不到间接成本对象,无法进行修改流程状态!!!"); } cost.FlowState = state; entities.SaveChanges(); } } }
public void Add(CostDiary costDiary) { if (costDiary != null) { using (pm2Entities entities = new pm2Entities()) { Bud_IndirectDiaryCost cost = new Bud_IndirectDiaryCost { InDiaryId = costDiary.Id, Name = costDiary.Name, IndireCode = costDiary.Code, ProjectId = costDiary.PrjId, Department = costDiary.Department, IssuedBy = costDiary.IssuedBy, InputUser = costDiary.InputUser, InputDate = costDiary.InputDate, FlowState = costDiary.FlowState }; entities.AddToBud_IndirectDiaryCost(cost); entities.SaveChanges(); } } }
public void Add(CostDiaryDetails costDDetails) { if (costDDetails != null) { using (pm2Entities entities = new pm2Entities()) { Bud_IndirectDiaryCost cost = (from m in entities.Bud_IndirectDiaryCost where m.InDiaryId == costDDetails.InDiaryId select m).FirstOrDefault <Bud_IndirectDiaryCost>(); Bud_IndirectDiaryDetails details = new Bud_IndirectDiaryDetails { InDiaryDetailsId = costDDetails.Id, IndetailsCode = costDDetails.Code, Name = costDDetails.Name, CBSCode = costDDetails.CBSCode, Bud_IndirectDiaryCost = cost, Amount = costDDetails.Amount, Note = costDDetails.Note }; entities.AddToBud_IndirectDiaryDetails(details); entities.SaveChanges(); } } }
public void Update(CostDiary costDiary) { if (costDiary != null) { using (pm2Entities entities = new pm2Entities()) { Bud_IndirectDiaryCost cost = (from m in entities.Bud_IndirectDiaryCost where m.InDiaryId == costDiary.Id select m).FirstOrDefault <Bud_IndirectDiaryCost>(); if (cost == null) { throw new Exception("找不到要修改的间接成本日记对象!!!"); } cost.Name = costDiary.Name; cost.IndireCode = costDiary.Code; cost.Department = costDiary.Department; cost.IssuedBy = costDiary.IssuedBy; cost.InputDate = costDiary.InputDate; cost.InputUser = costDiary.InputUser; entities.SaveChanges(); } } }