Ejemplo n.º 1
0
 public void Add(CostAccounting budCost, string inputUser)
 {
     using (pm2Entities entities = new pm2Entities())
     {
         Bud_CostAccounting accounting = new Bud_CostAccounting {
             Id      = budCost.Id,
             CBSCode = budCost.Code,
             Name    = budCost.Name,
             Type    = budCost.Type,
             Note    = budCost.Note
         };
         entities.AddToBud_CostAccounting(accounting);
         entities.SaveChanges();
     }
 }
Ejemplo n.º 2
0
 public void Update(CostAccounting budCost)
 {
     using (pm2Entities entities = new pm2Entities())
     {
         Bud_CostAccounting accounting = (from m in entities.Bud_CostAccounting
                                          where m.Id == budCost.Id
                                          orderby m.CBSCode
                                          select m).FirstOrDefault <Bud_CostAccounting>();
         if (accounting == null)
         {
             throw new Exception("核算成本,不能找到要修改的项!");
         }
         accounting.Name = budCost.Name;
         accounting.Note = budCost.Note;
         accounting.Type = budCost.Type;
         entities.SaveChanges();
     }
 }
Ejemplo n.º 3
0
        public static CostAccounting GetByCode(string code)
        {
            CostAccounting accounting = new CostAccounting();

            using (pm2Entities entities = new pm2Entities())
            {
                Bud_CostAccounting accounting2 = (from m in entities.Bud_CostAccounting
                                                  where m.CBSCode == code
                                                  select m).FirstOrDefault <Bud_CostAccounting>();
                if (accounting2 != null)
                {
                    return(new CostAccounting {
                        Id = accounting2.Id, Name = accounting2.Name, Code = accounting2.CBSCode, Note = accounting2.Note, Type = accounting2.Type
                    });
                }
                return(null);
            }
        }
Ejemplo n.º 4
0
        public static bool Del(List <string> ids)
        {
            bool           flag       = false;
            CostAccounting accounting = new CostAccounting();

            if (accounting.IsDelAll(ids))
            {
                using (pm2Entities entities = new pm2Entities())
                {
                    using (List <string> .Enumerator enumerator = ids.GetEnumerator())
                    {
                        string id;
                        while (enumerator.MoveNext())
                        {
                            id = enumerator.Current;
                            Bud_CostAccounting entity = (from m in entities.Bud_CostAccounting
                                                         where (m.Id == id) && (m.CBSCode.Length >= 6)
                                                         select m).FirstOrDefault <Bud_CostAccounting>();
                            if (entity != null)
                            {
                                bool   flag3   = true;
                                string cBSCode = entity.CBSCode;
                                if (entity.Type == "D")
                                {
                                    flag3 = ConstructResource.IsExistCBSCode(cBSCode);
                                }
                                else
                                {
                                    flag3 = IndirectBudget.IsExistCBSCode(cBSCode) || OrganizationBudget.IsExistCBSCode(cBSCode);
                                }
                                if (!flag3)
                                {
                                    entities.DeleteObject(entity);
                                    entities.SaveChanges();
                                    flag = true;
                                }
                            }
                        }
                    }
                }
            }
            return(flag);
        }