public static int GetNewItemCode(string typeCode) { using (pm2Entities entities = new pm2Entities()) { Basic_CodeList list = (from m in entities.Basic_CodeList where m.TypeCode == typeCode orderby m.ItemCode descending select m).FirstOrDefault <Basic_CodeList>(); if (list != null) { return(list.ItemCode + 1); } return(1); } }
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(); } }
private static void Delete(string typeCode, int itemCode, pm2Entities context) { Basic_CodeList entity = (from m in context.Basic_CodeList where (m.TypeCode == typeCode) && (m.ItemCode == itemCode) select m).FirstOrDefault <Basic_CodeList>(); if (entity == null) { throw new Exception("没有找到要删除的工程类型"); } if (GetUsedCount(typeCode, itemCode, context) > 0) { throw new Exception("此工程类型已被项目使用,不能被删除!"); } context.DeleteObject(entity); }
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(); } }