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 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();
}
}
}
public static decimal GetPriceValue(string resourceId, string priceTypeId)
{
decimal priceValue = 0M;
using (pm2Entities entities = new pm2Entities())
{
Res_Price price = (from rp in entities.Res_Price
where (rp.Res_Resource.ResourceId == resourceId) && (rp.Res_PriceType.PriceTypeId == priceTypeId)
select rp).FirstOrDefault <Res_Price>();
if (price != null)
{
priceValue = price.PriceValue;
}
}
return(priceValue);
}
public string GetPrice(string typeId)
{
using (pm2Entities pm2Entities = new pm2Entities())
{
IQueryable <Res_Price> source =
from m in pm2Entities.Res_Price
where m.PriceTypeId == typeId && m.ResourceId == this.resourceId
select m;
if (source.Count <Res_Price>() > 0)
{
Res_Price res_Price = source.First <Res_Price>();
string result;
if (res_Price != null)
{
result = res_Price.PriceValue.ToString();
return(result);
}
result = "";
return(result);
}
}
return("");
}
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();
}
}
}
