示例#1
0
        public static PrjType GetByItemCode(string typeCode, int itemCode)
        {
            PrjType type = new PrjType();

            using (pm2Entities entities = new pm2Entities())
            {
                return((from m in entities.Basic_CodeList
                        where (m.TypeCode == typeCode) && (m.ItemCode == itemCode)
                        select new PrjType {
                    TypeCode = m.TypeCode, ItemCode = m.ItemCode, ItemName = m.ItemName
                }).FirstOrDefault <PrjType>());
            }
        }
示例#2
0
 public static void Update(PrjType prjType)
 {
     using (pm2Entities entities = new pm2Entities())
     {
         Basic_CodeList list = (from m in entities.Basic_CodeList
                                where (m.ItemCode == prjType.ItemCode) && (m.TypeCode == prjType.TypeCode)
                                select m).FirstOrDefault <Basic_CodeList>();
         if (list == null)
         {
             throw new Exception("没有找到要修改的工程类型");
         }
         list.ItemName = prjType.ItemName;
         entities.SaveChanges();
     }
 }
示例#3
0
 public static void Add(PrjType prjType)
 {
     using (pm2Entities entities = new pm2Entities())
     {
         Basic_CodeList list = new Basic_CodeList {
             TypeCode = prjType.TypeCode,
             ItemCode = prjType.ItemCode,
             ItemName = prjType.ItemName
         };
         Basic_CodeType type = (from c in entities.Basic_CodeType
                                where c.TypeCode == prjType.TypeCode
                                select c).FirstOrDefault <Basic_CodeType>();
         if (type != null)
         {
             list.Basic_CodeType = type;
         }
         entities.AddToBasic_CodeList(list);
         entities.SaveChanges();
     }
 }