private static void DeleteResource(string tempResId, pm2Entities context)
{
Bud_TemplateResource entity = context.Bud_TemplateResource.FirstOrDefault <Bud_TemplateResource>(c => c.TemplateResourceId == tempResId);
if (entity == null)
{
throw new Exception("找不到要删除的资源！");
}
context.DeleteObject(entity);
}
public static void AddResource(BudTemplateItem budTempItem)
{
if ((budTempItem.Resources != null) && (budTempItem.Resources.Count > 0))
{
IList <TaskResource> resources = new List <TaskResource>();
resources = budTempItem.Resources;
using (pm2Entities entities = new pm2Entities())
{
DeleteResource(budTempItem, entities);
using (IEnumerator <TaskResource> enumerator = resources.GetEnumerator())
{
TaskResource tempResource;
while (enumerator.MoveNext())
{
tempResource = enumerator.Current;
Bud_TemplateResource resource = new Bud_TemplateResource {
TemplateResourceId = Guid.NewGuid().ToString(),
Bud_TemplateItem = (from t in entities.Bud_TemplateItem
where t.TemplateItemId == budTempItem.Id
select t).FirstOrDefault <Bud_TemplateItem>(),
Res_Resource = (from r in entities.Res_Resource
where r.ResourceId == tempResource.Resource.Id
select r).FirstOrDefault <Res_Resource>(),
ResourceQuantity = new decimal?(tempResource.Quantity),
ResourcePrice = new decimal?(tempResource.Price),
InputUser = tempResource.InputUser,
LossCoefficient = tempResource.LossCoefficient
};
if (tempResource.InputDate.HasValue)
{
resource.InputDate = Convert.ToDateTime(tempResource.InputDate);
}
entities.AddToBud_TemplateResource(resource);
}
}
entities.SaveChanges();
return;
}
}
using (pm2Entities entities2 = new pm2Entities())
{
DeleteResource(budTempItem, entities2);
entities2.SaveChanges();
}
}
private static void DeleteResource(BudTemplateItem budTempItem, pm2Entities context)
{
budTempItem = GetById(budTempItem.Id, budTempItem.BudTemplate.Id);
using (IEnumerator <TaskResource> enumerator = budTempItem.Resources.GetEnumerator())
{
TaskResource tempResource;
while (enumerator.MoveNext())
{
tempResource = enumerator.Current;
Bud_TemplateResource entity = (from tr in context.Bud_TemplateResource
where (tr.Res_Resource.ResourceId == tempResource.Resource.Id) && (tr.Bud_TemplateItem.TemplateItemId == budTempItem.Id)
select tr).FirstOrDefault <Bud_TemplateResource>();
if (entity != null)
{
context.DeleteObject(entity);
}
}
}
}
private static void DeleteResource(List <string> tempResIds, pm2Entities context)
{
try
{
using (List <string> .Enumerator enumerator = tempResIds.GetEnumerator())
{
string tempResId;
while (enumerator.MoveNext())
{
tempResId = enumerator.Current;
Bud_TemplateResource entity = context.Bud_TemplateResource.FirstOrDefault <Bud_TemplateResource>(c => c.TemplateResourceId == tempResId);
if (entity == null)
{
throw new Exception("找不到要删除的资源！");
}
context.DeleteObject(entity);
}
}
}
catch (Exception)
{
throw new Exception("找不到要删除的资源！");
}
}
