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 static void Update(ResourceTemp resTemp, string id)
{
using (pm2Entities entities = new pm2Entities())
{
Res_ResourceTemp temp = entities.Res_ResourceTemp.FirstOrDefault <Res_ResourceTemp>(c => c.Id == id);
if (temp == null)
{
throw new ApplicationException("找不到需要修改的模板项");
}
temp.Res_Resource = entities.Res_Resource.FirstOrDefault <Res_Resource>(c => c.ResourceId == resTemp.ResourceId);
temp.Bud_Task = entities.Bud_Task.FirstOrDefault <Bud_Task>(c => c.TaskId == resTemp.BudTask.Id);
entities.SaveChanges();
}
}
public static void DelResMapping(List <string> ids)
{
using (pm2Entities entities = new pm2Entities())
{
using (List <string> .Enumerator enumerator = ids.GetEnumerator())
{
string id;
while (enumerator.MoveNext())
{
id = enumerator.Current;
Res_ResourceTemp entity = (from m in entities.Res_ResourceTemp
where m.Id == id
select m).FirstOrDefault <Res_ResourceTemp>();
if (entity != null)
{
entities.DeleteObject(entity);
}
}
}
entities.SaveChanges();
}
}
public static void Delete(ResourceTemp resTemp, string InputUser, string isWBSRelevance)
{
using (pm2Entities entities = new pm2Entities())
{
if (isWBSRelevance == "1")
{
Bud_TaskResource resource = (from tr in entities.Bud_TaskResource
where (tr.Res_Resource.ResourceId == resTemp.ResourceId) && (tr.Bud_Task.TaskId == resTemp.BudTask.Id)
select tr).FirstOrDefault <Bud_TaskResource>();
if (resource == null)
{
Bud_TaskResource resource2 = new Bud_TaskResource {
TaskResourceId = Guid.NewGuid().ToString(),
Bud_Task = (from t in entities.Bud_Task
where t.TaskId == resTemp.BudTask.Id
select t).FirstOrDefault <Bud_Task>(),
Res_Resource = (from r in entities.Res_Resource
where r.ResourceId == resTemp.ResourceId
select r).FirstOrDefault <Res_Resource>(),
ResourceQuantity = resTemp.Quantity,
ResourcePrice = resTemp.UnitPrice,
InputUser = InputUser,
InputDate = DateTime.Now,
PrjGuid = resTemp.PrjId,
Versions = 1,
LossCoefficient = 1
};
entities.AddToBud_TaskResource(resource2);
}
else
{
resource.ResourceQuantity += resTemp.Quantity;
}
}
else
{
Bud_TaskResource resource3 = (from tr in entities.Bud_TaskResource
where (tr.Res_Resource.ResourceId == resTemp.ResourceId) && (tr.PrjGuid == resTemp.PrjId)
select tr).FirstOrDefault <Bud_TaskResource>();
if (resource3 == null)
{
int?nullable = (from m in entities.Bud_Task
where m.PrjId == resTemp.PrjId
select m.Version).Max <int?>();
if (!nullable.HasValue)
{
nullable = 1;
}
Bud_TaskResource resource4 = new Bud_TaskResource {
TaskResourceId = Guid.NewGuid().ToString(),
Bud_Task = null,
Res_Resource = (from r in entities.Res_Resource
where r.ResourceId == resTemp.ResourceId
select r).FirstOrDefault <Res_Resource>(),
ResourceQuantity = resTemp.Quantity,
ResourcePrice = resTemp.UnitPrice,
InputUser = InputUser,
InputDate = DateTime.Now,
PrjGuid = resTemp.PrjId,
Versions = nullable
};
entities.AddToBud_TaskResource(resource4);
}
else
{
resource3.ResourceQuantity += resTemp.Quantity;
}
}
Res_ResourceTemp entity = (from rt in entities.Res_ResourceTemp
where rt.Id == resTemp.Id
select rt).FirstOrDefault <Res_ResourceTemp>();
entities.DeleteObject(entity);
entities.SaveChanges();
}
}
