public static IList <Resource> GetAll()
{
List <Resource> list = new List <Resource>();
using (pm2Entities entities = new pm2Entities())
{
foreach (var typef in from r in entities.Res_Resource select new { Id = r.ResourceId, TypeId = r.Res_ResourceType.ResourceTypeId, Code = r.ResourceCode, Name = r.ResourceName, Brand = r.Brand, TaxRate = r.TaxRate, Specification = r.Specification, TechnicalParam = r.TechnicalParameter, UnitId = r.Res_Unit.UnitId, TypeAttributeId = r.Res_Attribute.AttributeId, Series = r.Series, User = r.InputUser, Date = r.InputDate })
{
Resource item = new Resource {
Id = typef.Id,
ResourceType = ResType.GetById(typef.TypeId),
Code = typef.Code,
Name = typef.Name,
Brand = typef.Brand,
TaxRate = typef.TaxRate,
Specification = typef.Specification,
TechnicalParameter = typef.TechnicalParam,
ResourceUnit = ResUnit.GetById(typef.UnitId),
TypeAttribute = ResTypeAttribute.GetById(typef.TypeAttributeId),
Series = typef.Series,
Prices = GetPrices(typef.Id),
InputUser = typef.User,
InputDate = typef.Date
};
list.Add(item);
}
}
return(list);
}
public static string GetFirstResourceTypeId(string resourceTypeId)
{
ResType byId = ResType.GetById(resourceTypeId);
string parentId = byId.ParentId;
if (string.IsNullOrEmpty(parentId))
{
return(byId.Id);
}
return(GetFirstResourceTypeId(parentId));
}
public static IList <ResTypeAttribute> GetAll()
{
IList <ResTypeAttribute> list = new List <ResTypeAttribute>();
using (pm2Entities entities = new pm2Entities())
{
foreach (var type in (from a in entities.Res_Attribute select new { AttributeId = a.AttributeId, AttributeName = a.AttributeName, InputUser = a.InputUser, InputDate = a.InputDate, ResourceTypeId = a.Res_ResourceType.ResourceTypeId }).ToList())
{
ResTypeAttribute item = new ResTypeAttribute {
Id = type.AttributeId,
Name = type.AttributeName,
InputUser = type.InputUser,
ResourceType = ResType.GetById(type.ResourceTypeId)
};
list.Add(item);
}
}
return(list);
}
public static ResTypeAttribute GetById(string id)
{
ResTypeAttribute attribute = new ResTypeAttribute();
using (pm2Entities entities = new pm2Entities())
{
var type = (from a in entities.Res_Attribute
where a.AttributeId == id
select new { AttributeId = a.AttributeId, AttributeName = a.AttributeName, InputUser = a.InputUser, InputDate = a.InputDate, ResourceTypeId = a.Res_ResourceType.ResourceTypeId }).FirstOrDefault();
if (type != null)
{
attribute.Id = id;
attribute.Name = type.AttributeName;
attribute.InputUser = type.InputUser;
attribute.InputDate = type.InputDate;
ResType byId = ResType.GetById(type.ResourceTypeId);
attribute.ResourceType = byId;
return(attribute);
}
return(null);
}
}
public static List <ConstructResource> GetByConsTask(string consTaskId, string TaskId)
{
List <ConstructResource> list = new List <ConstructResource>();
using (pm2Entities entities = new pm2Entities())
{
using (var enumerator = (from m in entities.Bud_ConsTaskRes
where m.Bud_ConsTask.ConsTaskId == consTaskId
select new { ConsTaskResId = m.ConsTaskResId, ResourceId = m.Res_Resource.ResourceId, Quantity = m.Quantity, UnitPrice = m.UnitPrice, AccountingQuantity = m.AccountingQuantity, ResourceTypeId = m.Res_Resource.Res_ResourceType.ResourceTypeId, CBSCode = m.CBSCode }).ToList().GetEnumerator())
{
var bud_consRes;
while (enumerator.MoveNext())
{
bud_consRes = enumerator.Current;
ConstructResource item = null;
if (bud_consRes != null)
{
item = new ConstructResource {
Id = bud_consRes.ConsTaskResId,
ResourceId = bud_consRes.ResourceId,
Quantity = bud_consRes.Quantity,
UnitPrice = bud_consRes.UnitPrice,
ConsTaskId = consTaskId,
AccountingQuantity = bud_consRes.AccountingQuantity
};
}
Bud_TaskResource resource3 = (from btr in entities.Bud_TaskResource
where (btr.Bud_Task.TaskId == TaskId) && (btr.Res_Resource.ResourceId == bud_consRes.ResourceId)
select btr).FirstOrDefault <Bud_TaskResource>();
if (resource3 != null)
{
item.BudQuantity = Convert.ToDecimal(resource3.ResourceQuantity);
}
else
{
item.BudQuantity = 0M;
}
if (bud_consRes.CBSCode != null)
{
item.CBScode = bud_consRes.CBSCode;
}
else
{
ResType byId = ResType.GetById(cn.justwin.Domain.Resource.GetFirstResourceTypeId(bud_consRes.ResourceTypeId));
if (byId != null)
{
if (!string.IsNullOrEmpty(byId.CBSCode))
{
item.CBScode = byId.CBSCode;
}
else
{
item.CBScode = string.Empty;
}
}
else
{
item.CBScode = string.Empty;
}
}
list.Add(item);
}
}
}
return(list);
}