protected void btnDel_Click(object sender, System.EventArgs e) { System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>(); bool flag = false; 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()) { IQueryable <Res_Resource> source = from m in pm2Entities.Res_Resource where m.Res_Unit.UnitId == cb.ToolTip select m; if (source.Count <Res_Resource>() > 0) { flag = true; break; } list.Add(cb.ToolTip); } } } } finally { System.IDisposable disposable = enumerator as System.IDisposable; if (disposable != null) { disposable.Dispose(); } } if (flag) { base.RegisterScript("alert('系统提示:\\n\\n请先删除子项!')"); return; } foreach (string item in list) { using (pm2Entities pm2Entities2 = new pm2Entities()) { Res_Unit entity = ( from m in pm2Entities2.Res_Unit where m.UnitId == item select m).First <Res_Unit>(); pm2Entities2.DeleteObject(entity); pm2Entities2.SaveChanges(); } } base.RegisterScript("location.href=location.href;"); }
public static void Update(ResUnit resUnit) { using (pm2Entities entities = new pm2Entities()) { Res_Unit unit = entities.Res_Unit.FirstOrDefault <Res_Unit>(c => c.UnitId == resUnit.Id); unit.Code = resUnit.Code; unit.Name = resUnit.Name; unit.InputUser = resUnit.InputUser; unit.InputDate = resUnit.InputDate; entities.SaveChanges(); } }
protected void btnSave_Click(object sender, System.EventArgs e) { if (!this.Page.IsValid) { return; } if (this.txtName.Text.Trim().Length > 30) { base.RegisterScript("top.ui.alert('请输入少于30的字符!!')"); return; } int num = 0; using (pm2Entities pm2Entities = new pm2Entities()) { IQueryable <Res_Unit> source = from m in pm2Entities.Res_Unit where m.Name == this.txtName.Text.Trim() select m; if (base.Request["id"] != null) { string id = base.Request["id"]; Res_Unit res_Unit = ( from m in pm2Entities.Res_Unit where m.UnitId == id select m).First <Res_Unit>(); if (res_Unit.Name != this.txtName.Text.Trim() && source.Count <Res_Unit>() > 0) { base.RegisterScript("top.ui.alert('此名称已存在!!请重新定义!!')"); return; } this.UpdateModel(res_Unit); num = pm2Entities.SaveChanges(); } else { if (source.Count <Res_Unit>() > 0) { base.RegisterScript("top.ui.alert('此名称已存在!!请重新定义!!')"); return; } pm2Entities.AddToRes_Unit(this.AddModel()); num = pm2Entities.SaveChanges(); } } if (num > 0) { base.RegisterScript("top.ui.show( '" + this.SetMsg() + "成功!'); top.ui.closeWin(); top.ui.reloadTab();"); return; } base.RegisterScript("top.ui.alert('" + this.SetMsg() + "失败!');"); }
public static void Add(ResUnit resUnit) { Res_Unit unit = new Res_Unit(); using (pm2Entities entities = new pm2Entities()) { unit.UnitId = resUnit.Id; unit.Code = resUnit.Code; unit.Name = resUnit.Name; unit.InputUser = resUnit.InputUser; unit.InputDate = resUnit.InputDate; entities.AddToRes_Unit(unit); entities.SaveChanges(); } }
public void InitPage() { if (base.Request.QueryString["id"] != null) { using (pm2Entities pm2Entities = new pm2Entities()) { string id = base.Request["id"]; Res_Unit res_Unit = ( from m in pm2Entities.Res_Unit where m.UnitId == id select m).First <Res_Unit>(); this.txtName.Text = res_Unit.Name; return; } } this.hdGuid.Value = System.Guid.NewGuid().ToString(); }
public void UpdateResource(Res_Resource resource, pm2Entities pm2) { resource.ResourceCode = this.txtResourceCode.Text.Trim(); resource.ResourceName = this.txtResourceName.Text.Trim(); resource.Series = this.txtSeries.Text; resource.ModelNumber = this.txtModelNumber.Text; if (!string.IsNullOrEmpty(this.hfldSupplier.Value)) { resource.SupplierId = new int?(System.Convert.ToInt32(this.hfldSupplier.Value)); } else { resource.SupplierId = null; } resource.Brand = this.txtBrand.Text; if (!string.IsNullOrEmpty(this.txtTaxRate.Text)) { resource.TaxRate = new decimal?(System.Convert.ToDecimal(this.txtTaxRate.Text)); } else { resource.TaxRate = null; } resource.Specification = this.txtSpecification.Text; resource.TechnicalParameter = this.txtTechnicalParameter.Text; resource.Note = this.txtNote.Text; Res_Unit res_Unit = ( from m in pm2.Res_Unit where m.UnitId == this.ddlUnit.SelectedValue select m).First <Res_Unit>(); res_Unit.Res_Resource.Add(resource); if (!string.IsNullOrEmpty(this.ddlAttribute.SelectedValue)) { Res_Attribute res_Attribute = ( from m in pm2.Res_Attribute where m.AttributeId == this.ddlAttribute.SelectedValue select m).First <Res_Attribute>(); res_Attribute.Res_Resource.Add(resource); return; } resource.Res_Attribute = null; }
public static ResUnit GetById(string id) { ResUnit unit = new ResUnit(); using (pm2Entities entities = new pm2Entities()) { Res_Unit unit2 = (from u in entities.Res_Unit where u.UnitId == id select u).FirstOrDefault <Res_Unit>(); if (unit2 != null) { unit.Id = id; unit.Code = unit2.Code; unit.Name = unit2.Name; unit.InputUser = unit2.InputUser; unit.InputDate = unit2.InputDate; return(unit); } return(null); } }
public Res_Unit UpdateModel(Res_Unit model) { model.Name = this.txtName.Text.Trim(); return(model); }