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();
}
}
