public static IList <EngineeringType> GetByPrjGuid(string prjGuid)
{
IList <EngineeringType> list = new List <EngineeringType>();
using (pm2Entities entities = new pm2Entities())
{
Guid guid = new Guid(prjGuid);
foreach (var type in from et in entities.PT_PrjInfo_EngineeringType
join ct in entities.Basic_CodeType on et.EngineeringType equals ct.TypeCode into ct
join cl in entities.Basic_CodeList on et.EngineeringSubType equals(int?) cl.ItemCode into cl
where (et.PrjGuid == guid) && (et.EngineeringType == cl.TypeCode)
select new { ID = et.ID, PrjGuid = et.PrjGuid, EngineeringType = et.EngineeringType, TypeName = ct.TypeName, EngineeringSubType = et.EngineeringSubType, ItemName = cl.ItemName, Grade = et.Grade })
{
EngineeringType item = new EngineeringType {
ID = type.ID,
PrjGuid = type.PrjGuid.Value.ToString(),
EngineeringTypeID = type.EngineeringType,
EngineeringTypeName = type.TypeName,
EngineeringSubTypeID = type.EngineeringSubType.Value.ToString(),
EngineeringSubTypeName = type.ItemName,
Grade = type.Grade
};
list.Add(item);
}
}
return(list);
}
public static void Add(EngineeringType engType, pm2Entities pm2)
{
PT_PrjInfo_EngineeringType type = new PT_PrjInfo_EngineeringType {
ID = engType.ID,
PrjGuid = new Guid(engType.PrjGuid),
EngineeringType = engType.EngineeringTypeID,
EngineeringSubType = new int?(Convert.ToInt32(engType.EngineeringSubTypeID)),
Grade = engType.Grade
};
pm2.AddToPT_PrjInfo_EngineeringType(type);
}