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();
}
}
