public static void Update(Resource resource)
{
using (pm2Entities entities = new pm2Entities())
{
Res_Resource resource2 = (from r in entities.Res_Resource
where r.ResourceId == resource.Id
select r).FirstOrDefault <Res_Resource>();
if (resource2 == null)
{
throw new ArgumentException("找不到需要需要的资源");
}
resource2.ResourceCode = resource.Code;
resource2.ResourceCode = resource.Code;
resource2.ResourceName = resource.Name;
resource2.Brand = resource.Brand;
resource2.TaxRate = resource.TaxRate;
resource2.Specification = resource.Specification;
resource2.TechnicalParameter = resource.TechnicalParameter;
resource2.Series = resource.Series;
resource2.InputUser = resource.InputUser;
resource2.InputDate = resource.InputDate;
resource2.Res_ResourceType = (from rt in entities.Res_ResourceType
where rt.ResourceTypeId == resource.ResourceType.Id
select rt).FirstOrDefault <Res_ResourceType>();
resource2.Res_Attribute = (from a in entities.Res_Attribute
where a.AttributeId == resource.TypeAttribute.Id
select a).FirstOrDefault <Res_Attribute>();
resource2.Res_Unit = (from u in entities.Res_Unit
where u.UnitId == resource.ResourceUnit.Id
select u).FirstOrDefault <Res_Unit>();
foreach (Res_Price price in from p in entities.Res_Price
where p.Res_Resource.ResourceId == resource.Id
select p)
{
entities.DeleteObject(price);
}
using (IEnumerator <ResPriceType> enumerator2 = resource.Prices.Keys.GetEnumerator())
{
ResPriceType resPriceType;
while (enumerator2.MoveNext())
{
resPriceType = enumerator2.Current;
Res_Price price2 = new Res_Price {
Res_Resource = (from r in entities.Res_Resource
where r.ResourceId == resource.Id
select r).FirstOrDefault <Res_Resource>(),
Res_PriceType = (from pt in entities.Res_PriceType
where pt.PriceTypeId == resPriceType.Id
select pt).FirstOrDefault <Res_PriceType>()
};
decimal?nullable = resource.Prices[resPriceType];
price2.PriceValue = nullable.HasValue ? nullable.GetValueOrDefault() : 0M;
price2.InputUser = resource.InputUser;
price2.InputDate = resource.InputDate;
entities.AddToRes_Price(price2);
}
}
entities.SaveChanges();
}
}
public static void Add(ResourceTemp resTemp)
{
using (pm2Entities entities = new pm2Entities())
{
Res_Resource resource = (from m in entities.Res_Resource
where m.ResourceId == resTemp.ResourceId
select m).FirstOrDefault <Res_Resource>();
Bud_Task task = null;
if (resTemp.BudTask != null)
{
task = (from m in entities.Bud_Task
where m.TaskId == resTemp.BudTask.Id
select m).FirstOrDefault <Bud_Task>();
}
Res_ResourceTemp temp = new Res_ResourceTemp {
Id = Guid.NewGuid().ToString(),
Amount = resTemp.Amount,
PrjId = resTemp.PrjId,
Quantity = resTemp.Quantity,
UnitPrice = resTemp.UnitPrice,
ResourceCode = resTemp.ResourceCode,
ResourceName = resTemp.ResourceName,
Bud_Task = task,
Res_Resource = resource
};
entities.AddToRes_ResourceTemp(temp);
entities.SaveChanges();
}
}
public void AddPrice()
{
string id = this.hdGuid.Value;
if (!string.IsNullOrEmpty(this.resourceId))
{
id = this.resourceId;
}
using (pm2Entities pm2Entities = new pm2Entities())
{
IQueryable <Res_Price> queryable =
from m in pm2Entities.Res_Price
where m.ResourceId == id
select m;
foreach (Res_Price current in queryable)
{
pm2Entities.DeleteObject(current);
}
pm2Entities.SaveChanges();
}
System.Collections.IEnumerator enumerator2 = this.gvwPriceType.Rows.GetEnumerator();
try
{
while (enumerator2.MoveNext())
{
GridViewRow gridViewRow = (GridViewRow)enumerator2.Current;
TextBox tb = gridViewRow.FindControl("txtPrice") as TextBox;
using (pm2Entities pm2Entities2 = new pm2Entities())
{
Res_Price res_Price = new Res_Price();
if (!string.IsNullOrEmpty(tb.Text))
{
res_Price.PriceValue = System.Convert.ToDecimal(tb.Text);
}
Res_PriceType res_PriceType = (
from m in pm2Entities2.Res_PriceType
where m.PriceTypeId == tb.ToolTip
select m).First <Res_PriceType>();
res_PriceType.Res_Price.Add(res_Price);
Res_Resource res_Resource = (
from m in pm2Entities2.Res_Resource
where m.ResourceId == id
select m).First <Res_Resource>();
res_Resource.Res_Price.Add(res_Price);
pm2Entities2.AddToRes_Price(res_Price);
pm2Entities2.SaveChanges();
}
}
}
finally
{
System.IDisposable disposable = enumerator2 as System.IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
}
protected bool IsExistResourceCode(string resCode)
{
bool result = false;
using (pm2Entities pm2Entities = new pm2Entities())
{
Res_Resource res_Resource = (
from m in pm2Entities.Res_Resource
where m.ResourceCode == resCode
select m).FirstOrDefault <Res_Resource>();
if (res_Resource != null)
{
result = true;
}
}
return(result);
}
private Res_Resource CreateResource(pm2Entities pm2)
{
Res_Resource res_Resource = new Res_Resource();
res_Resource.ResourceId = this.hdGuid.Value.Trim();
this.UpdateResource(res_Resource, pm2);
res_Resource.InputUser = PageHelper.QueryUser(this, base.UserCode);
res_Resource.InputDate = new System.DateTime?(System.DateTime.Now);
string parentId = base.Request["parentId"];
Res_ResourceType res_ResourceType = (
from m in pm2.Res_ResourceType
where m.ResourceTypeId == parentId
select m).First <Res_ResourceType>();
res_ResourceType.Res_Resource.Add(res_Resource);
return(res_Resource);
}
protected void btnDel_Click(object sender, System.EventArgs e)
{
new EquEquipmentService();
System.Collections.Generic.List <string> list = new System.Collections.Generic.List <string>();
if (this.hfldPurchaseChecked.Value.Contains("["))
{
list = JsonHelper.GetListFromJson(this.hfldPurchaseChecked.Value);
}
else
{
list.Add(this.hfldPurchaseChecked.Value);
}
using (pm2Entities pm2Entities = new pm2Entities())
{
foreach (string id in list)
{
try
{
IQueryable <Res_Price> queryable =
from p in pm2Entities.Res_Price
where p.ResourceId == id
select p;
foreach (Res_Price current in queryable)
{
pm2Entities.DeleteObject(current);
}
Res_Resource res_Resource = (
from r in pm2Entities.Res_Resource
where r.ResourceId == id
select r).FirstOrDefault <Res_Resource>();
if (res_Resource != null)
{
pm2Entities.DeleteObject(res_Resource);
}
pm2Entities.SaveChanges();
base.RegisterScriptRefresh();
}
catch
{
base.RegisterScript("alert('系统提示：\\n\\n该资源已经使用，不能删除！');");
}
}
}
}
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 void Delete(string id)
{
using (pm2Entities entities = new pm2Entities())
{
foreach (Res_Price price in from p in entities.Res_Price
where p.Res_Resource.ResourceId == id
select p)
{
entities.DeleteObject(price);
}
Res_Resource entity = (from r in entities.Res_Resource
where r.ResourceId == id
select r).FirstOrDefault <Res_Resource>();
if (entity == null)
{
throw new ArgumentException("找不到需要删除的资源");
}
entities.DeleteObject(entity);
entities.SaveChanges();
}
}
public static void Add(BudContractResource conRes)
{
using (pm2Entities entities = new pm2Entities())
{
Bud_ContractTask task = (from m in entities.Bud_ContractTask
where m.TaskId == conRes.TaskId
select m).FirstOrDefault <Bud_ContractTask>();
Res_Resource resource = (from m in entities.Res_Resource
where m.ResourceId == conRes.ResourceId
select m).FirstOrDefault <Res_Resource>();
Bud_ContractResource resource2 = new Bud_ContractResource {
TaskResourceId = conRes.Id,
ResourcePrice = new decimal?(conRes.ResPrice),
ResourceQuantity = new decimal?(conRes.ResQuantity),
InputDate = conRes.InputDate,
InputUser = conRes.InputUser,
Bud_ContractTask = task,
Res_Resource = resource
};
entities.AddToBud_ContractResource(resource2);
entities.SaveChanges();
}
}
public void Add(ConstructResource consRes)
{
using (pm2Entities entities = new pm2Entities())
{
Res_Resource resource = (from m in entities.Res_Resource
where m.ResourceId == consRes.ResourceId
select m).FirstOrDefault <Res_Resource>();
Bud_ConsTask task = (from m in entities.Bud_ConsTask
where m.ConsTaskId == consRes.ConsTaskId
select m).FirstOrDefault <Bud_ConsTask>();
if ((resource != null) && (task != null))
{
Bud_ConsTaskRes res = new Bud_ConsTaskRes {
ConsTaskResId = consRes.Id,
Quantity = consRes.Quantity,
Bud_ConsTask = task,
Res_Resource = resource,
UnitPrice = consRes.UnitPrice
};
entities.AddToBud_ConsTaskRes(res);
entities.SaveChanges();
}
}
}
public static void Add(ResourceTemp resTemp)
{
using (pm2Entities entities = new pm2Entities())
{
Res_Resource resource = (from m in entities.Res_Resource
where m.ResourceId == resTemp.ResourceId
select m).FirstOrDefault <Res_Resource>();
Bud_Task task = null;
if (resTemp.BudTask != null)
{
task = (from m in entities.Bud_Task
where m.TaskId == resTemp.BudTask.Id
select m).FirstOrDefault <Bud_Task>();
}
//null, resTemp.ResourceCode,
// ,[ResourceId]
//,[TaskId]
//,[ResourceCode]
// ,'{1}'-- < ResourceId, nvarchar(500),>
//,'{2}'-- < TaskId, nvarchar(500),>
//,'{3}'-- < ResourceCode, nvarchar(500),>
string strs = string.Format(@"INSERT INTO [Res_ResourceTemp]
([Id]
,[ResourceName]
,[UnitPrice]
,[Quantity]
,[Amount]
,[PrjId]
,[Brand]
,[Specification]
,[ModelNumber])
VALUES
('{0}'--<Id, nvarchar(500),>
,'{1}'--<ResourceName, nvarchar(1000),>
,{2}--<UnitPrice, decimal(18,3),>
,{3}--<Quantity, decimal(18,3),>
,{4}--<Amount, decimal(18,3),>
,'{5}'--<PrjId, nvarchar(500),>
,'{6}'--<Brand, nvarchar(500),>
,'{7}'--<Specification, nvarchar(500),>
,'{8}'--<ModelNumber, nvarchar(500),>
)" , Guid.NewGuid().ToString(), resTemp.ResourceName, resTemp.UnitPrice, resTemp.Quantity, resTemp.Amount, resTemp.PrjId, resTemp.Brand, resTemp.Specification, resTemp.ModelNumber);
//Res_ResourceTemp temp = new Res_ResourceTemp {
// Id = Guid.NewGuid().ToString(),
// Amount = resTemp.Amount,
// PrjId = resTemp.PrjId,
// Quantity = resTemp.Quantity,
// UnitPrice = resTemp.UnitPrice,
// ResourceCode = resTemp.ResourceCode,
// ResourceName = resTemp.ResourceName,
// Bud_Task = task,
// Res_Resource = resource,
// Brand = resTemp.Brand,
// Specification = resTemp.Specification,
// ModelNumber = resTemp.ModelNumber
//};
//entities.AddToRes_ResourceTemp(temp);
//entities.SaveChanges();
publicDbOpClass.ExecSqlString(strs);
}
}
public static void Add(Resource resource)
{
using (pm2Entities entities = new pm2Entities())
{
Res_Resource resource2 = new Res_Resource {
ResourceId = resource.Id,
ResourceCode = resource.Code,
ResourceName = resource.Name,
Brand = resource.Brand,
TaxRate = resource.TaxRate,
Specification = resource.Specification,
ModelNumber = resource.ModelNumber,
TechnicalParameter = resource.TechnicalParameter,
Series = resource.Series,
InputUser = resource.InputUser,
InputDate = resource.InputDate,
SupplierId = resource.SupplierId,
Res_ResourceType = (from rt in entities.Res_ResourceType
where rt.ResourceTypeId == resource.ResourceType.Id
select rt).FirstOrDefault <Res_ResourceType>()
};
if (resource.TypeAttribute != null)
{
resource2.Res_Attribute = (from a in entities.Res_Attribute
where a.AttributeId == resource.TypeAttribute.Id
select a).FirstOrDefault <Res_Attribute>();
}
if (resource.ResourceUnit != null)
{
resource2.Res_Unit = (from u in entities.Res_Unit
where u.UnitId == resource.ResourceUnit.Id
select u).FirstOrDefault <Res_Unit>();
}
entities.AddToRes_Resource(resource2);
entities.SaveChanges();
if (resource.Prices != null)
{
using (IEnumerator <ResPriceType> enumerator = resource.Prices.Keys.GetEnumerator())
{
ResPriceType resPriceType;
while (enumerator.MoveNext())
{
resPriceType = enumerator.Current;
Res_Price price = new Res_Price {
Res_Resource = (from r in entities.Res_Resource
where r.ResourceId == resource.Id
select r).FirstOrDefault <Res_Resource>(),
Res_PriceType = (from pt in entities.Res_PriceType
where pt.PriceTypeId == resPriceType.Id
select pt).FirstOrDefault <Res_PriceType>()
};
decimal?nullable = resource.Prices[resPriceType];
price.PriceValue = nullable.HasValue ? nullable.GetValueOrDefault() : 0M;
price.InputUser = resource.InputUser;
price.InputDate = resource.InputDate;
entities.AddToRes_Price(price);
}
}
entities.SaveChanges();
}
}
}
private void Save(string type)
{
string strSQL = string.Empty;
if (!string.IsNullOrEmpty(this.resourceId))
{
strSQL = @"select * from Res_Resource r where r.ResourceName='" + txtResourceName.Text.ToString().Trim() + "' and r.Brand='" + txtBrand.Text.ToString().Trim() + "'and r.Specification='" + txtSpecification.Text.ToString().Trim() + "'and r.ModelNumber='" + txtModelNumber.Text.ToString().Trim() + "' and r.ResourceId !='" + this.resourceId.ToString().Trim() + "'";
}
else
{
strSQL = @"select * from Res_Resource r where r.ResourceName='" + txtResourceName.Text.ToString().Trim() + "' and r.Brand='" + txtBrand.Text.ToString().Trim() + "'and r.Specification='" + txtSpecification.Text.ToString().Trim() + "'and r.ModelNumber='" + txtModelNumber.Text.ToString().Trim() + "' ";
}
DataTable dt = publicDbOpClass.DataTableQuary(strSQL);
if (dt.Rows.Count > 0)
{
base.RegisterScript("top.ui.alert('" + this.SetMsg() + "失败，资源库中已经存在相同资源名称、品牌、规格、型号的资源！');");
}
else
{
int num = 0;
using (pm2Entities pm2Entities = new pm2Entities())
{
IQueryable <Res_Resource> source =
from m in pm2Entities.Res_Resource
where m.ResourceCode == this.txtResourceCode.Text.Trim()
select m;
if (!string.IsNullOrEmpty(this.resourceId))
{
Res_Resource res_Resource = (
from m in pm2Entities.Res_Resource
where m.ResourceId == this.resourceId
select m).First <Res_Resource>();
if (res_Resource.ResourceCode != this.txtResourceCode.Text.Trim() && source.Count <Res_Resource>() > 0)
{
base.RegisterScript("top.ui.alert('资源编号已存在!!请重新定义!!')");
return;
}
this.UpdateResource(res_Resource, pm2Entities);
num = pm2Entities.SaveChanges();
}
else
{
if (source.Count <Res_Resource>() > 0)
{
base.RegisterScript("top.ui.alert('资源编号已存在!!请重新定义!!')");
return;
}
Res_Resource res_Resource2 = this.CreateResource(pm2Entities);
pm2Entities.AddToRes_Resource(res_Resource2);
num = pm2Entities.SaveChanges();
}
}
this.AddPrice();
if (num > 0)
{
if (type == "one")
{
string.Concat(new string[]
{
"/BudgetManage/Resource/ResourceDetail.aspx?id=",
base.Request["parentId"],
"&nodeId=",
base.Request["parentId"],
"&parentId=",
base.Request["nodeId"]
});
base.RegisterScript("top.ui.show('" + this.SetMsg() + "成功！'); top.ui.closeTab({ refresh: '1', parent: 'resource' });");
return;
}
if (type == "more")
{
string str = string.Concat(new string[]
{
"/BudgetManage/Resource/ResourceEdit.aspx?parentId=",
base.Request["parentId"],
"&nodeId=",
base.Request["nodeId"]
});
//window.location='"+ str + "';metion();
base.RegisterScript("top.ui.show('" + this.SetMsg() + "成功！');self.location.href = '" + str + "';");
return;
}
}
base.RegisterScript("top.ui.alert('" + this.SetMsg() + "失败！');");
}
}
