public static void Delete(string id, pm2Entities context) { Bud_Template entity = context.Bud_Template.FirstOrDefault <Bud_Template>(c => c.TemplateId == id); if (entity == null) { throw new Exception("找不到需要删除的模板"); } BudTemplateItem.Delete(id); context.DeleteObject(entity); }
public static void Update(BudTemplate budTemplate) { using (pm2Entities entities = new pm2Entities()) { Bud_Template template = entities.Bud_Template.FirstOrDefault <Bud_Template>(c => c.TemplateId == budTemplate.Id); template.TemplateCode = budTemplate.Code; template.TemplateName = budTemplate.Name; template.Bud_TemplateType = entities.Bud_TemplateType.FirstOrDefault <Bud_TemplateType>(c => c.TypeId == budTemplate.BudTempType.Id); entities.SaveChanges(); } }
public static void Add(BudTemplate budTemplate) { using (pm2Entities entities = new pm2Entities()) { Bud_Template entity = new Bud_Template { TemplateId = budTemplate.Id, TemplateCode = budTemplate.Code, TemplateName = budTemplate.Name, InputUser = budTemplate.InputUser }; if (budTemplate.InputDate.HasValue) { entity.InputDate = Convert.ToDateTime(budTemplate.InputDate); } entities.Bud_TemplateType.FirstOrDefault <Bud_TemplateType>(c => (c.TypeId == budTemplate.BudTempType.Id)).Bud_Template.Add(entity); entities.AddToBud_Template(entity); entities.SaveChanges(); } }
public static List <Bud_Template> GetBud_Template(List <string> idList, pm2Entities contxt) { List <Bud_Template> list = new List <Bud_Template>(); using (List <string> .Enumerator enumerator = idList.GetEnumerator()) { string id; while (enumerator.MoveNext()) { id = enumerator.Current; Bud_Template item = contxt.Bud_Template.FirstOrDefault <Bud_Template>(c => c.TemplateId == id); if (item != null) { list.Add(item); } } } return(list); }