Пример #1
0
 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();
         }
     }
 }
Пример #2
0
 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();
         }
     }
 }
Пример #3
0
 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();
         }
     }
 }
Пример #4
0
 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();
         }
     }
 }
Пример #5
0
 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();
         }
     }
 }