public static void UpdateResQuantity(string taskId, string resId, decimal quantity) { using (pm2Entities entities = new pm2Entities()) { Bud_ContractResource resource = (from m in entities.Bud_ContractResource where (m.Res_Resource.ResourceId == resId) && (m.Bud_ContractTask.TaskId == taskId) select m).FirstOrDefault <Bud_ContractResource>(); if (resource != null) { resource.ResourceQuantity = new decimal?(quantity); 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(); } }