protected void btnDel_Click(object sender, System.EventArgs e) { System.Collections.IEnumerator enumerator = this.gvResource.Rows.GetEnumerator(); try { while (enumerator.MoveNext()) { GridViewRow gridViewRow = (GridViewRow)enumerator.Current; CheckBox cb = gridViewRow.FindControl("cbBox") as CheckBox; if (cb != null && cb.Checked) { using (pm2Entities pm2Entities = new pm2Entities()) { if (base.Request["num"] == "1") { Res_Template res_Template = ( from m in pm2Entities.Res_Template where m.TemplateId == cb.ToolTip select m).FirstOrDefault <Res_Template>(); if (res_Template != null) { res_Template.IsValid = new bool?(false); pm2Entities.SaveChanges(); } } else { IQueryable <Res_TemplateItem> queryable = from m in pm2Entities.Res_TemplateItem where m.Res_Template.TemplateId == cb.ToolTip select m; foreach (Res_TemplateItem current in queryable) { pm2Entities.DeleteObject(current); } Res_Template res_Template2 = ( from m in pm2Entities.Res_Template where m.TemplateId == cb.ToolTip select m).FirstOrDefault <Res_Template>(); if (res_Template2 != null) { pm2Entities.DeleteObject(res_Template2); pm2Entities.SaveChanges(); } } } } } } finally { System.IDisposable disposable = enumerator as System.IDisposable; if (disposable != null) { disposable.Dispose(); } } base.RegisterScript("location.href=location.href;"); }
public static void Add(ResTemplate restemplate) { using (pm2Entities entities = new pm2Entities()) { Res_Template template = bindEntity(restemplate, true); entities.AddToRes_Template(template); entities.SaveChanges(); } }
public static void Add(ResTemplateItem restemplateitem) { using (pm2Entities entities = new pm2Entities()) { Res_TemplateItem entity = bindEntity(restemplateitem); Res_Template template = (from m in entities.Res_Template where m.TemplateId == restemplateitem.Template.Id select m).FirstOrDefault <Res_Template>(); entity.Res_Template = template; template.Res_TemplateItem.Add(entity); entities.SaveChanges(); } }
public static void Update(ResTemplate restemplate) { using (pm2Entities entities = new pm2Entities()) { if ((from m in entities.Res_Template where m.TemplateId == restemplate.Id select m).FirstOrDefault <Res_Template>() == null) { throw new Exception("找不到需要修改的模板"); } Res_Template template = bindEntity(restemplate, false); entities.SaveChanges(); } }
public static void Delete(string id) { using (pm2Entities entities = new pm2Entities()) { Res_Template entity = (from m in entities.Res_Template where m.TemplateId == id select m).FirstOrDefault <Res_Template>(); if (entity == null) { throw new Exception("找不到需要删除的模板"); } entities.DeleteObject(entity); entities.SaveChanges(); } }
private static Res_Template bindEntity(ResTemplate restemplate, bool isAdd) { Res_Template template = new Res_Template(); if (isAdd) { template.TemplateId = restemplate.Id; template.TemplateName = restemplate.Name; template.StartRowIndex = restemplate.StartRowIndex; template.InputDate = restemplate.InputDate; template.InputUser = restemplate.InputUser; } template.IsValid = restemplate.IsValid; return(template); }
public static ResTemplate GetById(string id) { ResTemplate template = null; using (pm2Entities entities = new pm2Entities()) { Res_Template template2 = (from m in entities.Res_Template where m.TemplateId == id select m).FirstOrDefault <Res_Template>(); if (template2 != null) { template = new ResTemplate { Id = template2.TemplateId, Name = template2.TemplateName, IsValid = template2.IsValid, InputDate = template2.InputDate, InputUser = template2.InputUser, StartRowIndex = template2.StartRowIndex }; } } return(template); }
protected void btnReturn_Click(object sender, System.EventArgs e) { System.Collections.IEnumerator enumerator = this.gvResource.Rows.GetEnumerator(); try { while (enumerator.MoveNext()) { GridViewRow gridViewRow = (GridViewRow)enumerator.Current; CheckBox cb = gridViewRow.FindControl("cbBox") as CheckBox; if (cb != null && cb.Checked) { using (pm2Entities pm2Entities = new pm2Entities()) { Res_Template res_Template = ( from m in pm2Entities.Res_Template where m.TemplateId == cb.ToolTip select m).FirstOrDefault <Res_Template>(); if (res_Template != null) { res_Template.IsValid = new bool?(true); pm2Entities.SaveChanges(); } } } } } finally { System.IDisposable disposable = enumerator as System.IDisposable; if (disposable != null) { disposable.Dispose(); } } base.RegisterScript("location.href=location.href;"); }