public static IList <ResTemplateItem> GetAll() { List <ResTemplateItem> list = new List <ResTemplateItem>(); using (pm2Entities entities = new pm2Entities()) { var list2 = (from m in entities.Res_TemplateItem select new { ItemId = m.ItemId, ExcelColumn = m.ExcelColumn, ExcelRealCoumn = m.ExcelRealCoumn, DbColumn = m.DbColumn, TemplateId = m.Res_Template.TemplateId }).ToList(); if (list2.Count == 0) { return(list); } foreach (var type in list2) { ResTemplateItem item = new ResTemplateItem { ItemId = type.ItemId, ExcelColumn = type.ExcelColumn, ExcelRealCoumn = type.ExcelRealCoumn, DbColumn = type.DbColumn, Template = ResTemplate.GetById(type.TemplateId) }; list.Add(item); } } return(list); }
public static ResTemplateItem GetById(string id) { ResTemplateItem item = new ResTemplateItem(); using (pm2Entities entities = new pm2Entities()) { var type = (from m in entities.Res_TemplateItem where m.ItemId == id select new { ItemId = m.ItemId, ExcelColumn = m.ExcelColumn, ExcelRealCoumn = m.ExcelRealCoumn, DbColumn = m.DbColumn, TemplateId = m.Res_Template.TemplateId }).FirstOrDefault(); if (type != null) { item.ItemId = type.ItemId; item.ExcelColumn = type.ExcelColumn; item.ExcelRealCoumn = type.ExcelRealCoumn; item.DbColumn = type.DbColumn; item.Template = ResTemplate.GetById(type.TemplateId); return(item); } return(null); } }