private void AddAttribute() { if (this.IsExists()) { base.RegisterScript("top.ui.alert('此名称已经存在')"); return; } try { using (pm2Entities pm2Entities = new pm2Entities()) { Res_ResourceType res_ResourceType = ( from rt in pm2Entities.Res_ResourceType where rt.ResourceTypeId == this.resourceTypeId select rt).FirstOrDefault <Res_ResourceType>(); Res_Attribute res_Attribute = new Res_Attribute(); res_Attribute.AttributeId = System.Guid.NewGuid().ToString(); res_Attribute.AttributeName = this.txtAttributeName.Text.Trim(); if (res_ResourceType != null) { res_ResourceType.Res_Attribute.Add(res_Attribute); } pm2Entities.SaveChanges(); } System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder(); stringBuilder.Append("top.ui.closeWin(); \n"); stringBuilder.Append("top.ui.reloadTab(); \n"); stringBuilder.Append("top.ui.alert('添加成功'); \n"); base.RegisterScript(stringBuilder.ToString()); } catch { base.RegisterScript("top.ui.alert('添加失败')"); } }
private void UpdateAttribute() { if (this.IsExists()) { base.RegisterScript("top.ui.alert('此名称已经存在')"); return; } try { using (pm2Entities pm2Entities = new pm2Entities()) { Res_Attribute res_Attribute = ( from a in pm2Entities.Res_Attribute where a.AttributeId == this.attributeId select a).FirstOrDefault <Res_Attribute>(); if (res_Attribute != null) { res_Attribute.AttributeName = this.txtAttributeName.Text.Trim(); } pm2Entities.SaveChanges(); } System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder(); stringBuilder.Append("top.ui.closeWin(); \n"); stringBuilder.Append("top.ui.reloadTab(); \n"); stringBuilder.Append("top.ui.alert('修改成功'); \n"); base.RegisterScript(stringBuilder.ToString()); } catch { base.RegisterScript("top.ui.alert('修改失败')"); } }
private void InitUpdate() { using (pm2Entities pm2Entities = new pm2Entities()) { Res_Attribute res_Attribute = ( from a in pm2Entities.Res_Attribute where a.AttributeId == this.attributeId select a).FirstOrDefault <Res_Attribute>(); if (res_Attribute != null) { this.txtAttributeName.Text = res_Attribute.AttributeName; } } }
public static void Delete(string id) { using (pm2Entities entities = new pm2Entities()) { Res_Attribute entity = (from attr in entities.Res_Attribute where attr.AttributeId == id select attr).FirstOrDefault <Res_Attribute>(); if (entity == null) { throw new Exception("找不到需要删除的类别属性"); } entities.DeleteObject(entity); entities.SaveChanges(); } }
public static void Update(ResTypeAttribute typeAttr) { using (pm2Entities entities = new pm2Entities()) { Res_Attribute attribute = (from attr in entities.Res_Attribute where attr.AttributeId == typeAttr.Id select attr).FirstOrDefault <Res_Attribute>(); if (attribute == null) { throw new Exception("找不到需要修改的类别属性"); } attribute.AttributeName = typeAttr.Name; entities.SaveChanges(); } }
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; }
protected void btnDelete_Click(object sender, System.EventArgs e) { System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>(); if (this.hfldAttributeId.Value.Contains("[")) { list = JsonHelper.GetListFromJson(this.hfldAttributeId.Value); } else { list.Add(this.hfldAttributeId.Value); } if (!this.DeleteValidate(list)) { base.RegisterScript("alert('系统提示:\\n\\n系统属性不能删除!');"); return; } using (pm2Entities pm2Entities = new pm2Entities()) { try { foreach (string id in list) { Res_Attribute res_Attribute = ( from a in pm2Entities.Res_Attribute where a.AttributeId == id select a).FirstOrDefault <Res_Attribute>(); if (res_Attribute != null) { pm2Entities.DeleteObject(res_Attribute); } } pm2Entities.SaveChanges(); } catch { base.RegisterScript("alert('系统提示:\\n\\n该属性正在使用不能删除!');"); } } this.DataBindTypeAttribute(); this.InitAspNetPager(); }
public static void Add(ResTypeAttribute typeAttr) { using (pm2Entities entities = new pm2Entities()) { Res_Attribute attribute = new Res_Attribute { AttributeId = typeAttr.Id, AttributeName = typeAttr.Name, InputUser = typeAttr.InputUser, InputDate = typeAttr.InputDate }; Res_ResourceType type = (from rt in entities.Res_ResourceType where rt.ResourceTypeId == typeAttr.ResourceType.Id select rt).FirstOrDefault <Res_ResourceType>(); if (type == null) { throw new Exception("不能确定其所属类别"); } attribute.Res_ResourceType = type; entities.SaveChanges(); } }