public static void UpdateState(string CBSCode, string organizationBudgetId, string state) { using (pm2Entities entities = new pm2Entities()) { Bud_OrganizationBudget budget = (from m in entities.Bud_OrganizationBudget where (m.CBSCode == CBSCode) && (m.OrganizationBudgetId == organizationBudgetId) select m).FirstOrDefault <Bud_OrganizationBudget>(); if (budget != null) { budget.State = state; entities.SaveChanges(); } } }
public static void UpdateState(string CBSCode, string organizationBudgetId, string state) { using (pm2Entities context = new pm2Entities()) { Bud_OrganizationBudget organBudget = ( from m in context.Bud_OrganizationBudget where m.CBSCode == CBSCode && m.OrganizationBudgetId == organizationBudgetId select m).FirstOrDefault <Bud_OrganizationBudget>(); if (organBudget != null) { organBudget.State = state; context.SaveChanges(); } } }
public void Update(OrganizationBudget organBudget) { using (pm2Entities entities = new pm2Entities()) { Bud_OrganizationBudget budget = (from m in entities.Bud_OrganizationBudget where (m.OrganizationBudgetId == organBudget.OrganizationBudgetId) && (m.CBSCode == organBudget.CBSCode) select m).FirstOrDefault <Bud_OrganizationBudget>(); if (budget == null) { throw new Exception("此项目的间接成本预算不存在!"); } budget.BudgetAmount = new decimal?(organBudget.BudgetAmount); budget.AccountingAmount = new decimal?(organBudget.AccountAmount); budget.State = organBudget.State; entities.SaveChanges(); } }
public static bool IsExistCBSCode(string cbsCode) { bool exist = false; using (pm2Entities context = new pm2Entities()) { Bud_OrganizationBudget query = ( from m in context.Bud_OrganizationBudget where m.CBSCode == cbsCode && (m.State == "1" || m.State == "2" || m.State == "4") select m).FirstOrDefault <Bud_OrganizationBudget>(); if (query != null) { exist = true; } } return(exist); }
public static bool IsExistOrgan(string organizationBudgetId) { bool exist = false; using (pm2Entities context = new pm2Entities()) { Bud_OrganizationBudget query = ( from m in context.Bud_OrganizationBudget where m.OrganizationBudgetId == organizationBudgetId select m).FirstOrDefault <Bud_OrganizationBudget>(); if (query != null) { exist = true; } } return(exist); }
public void Add(OrganizationMonthBudget indirMonthBudget) { using (pm2Entities entities = new pm2Entities()) { Bud_OrganizationBudget budget = (from m in entities.Bud_OrganizationBudget where m.Id == indirMonthBudget.IndirectBudgetId select m).FirstOrDefault <Bud_OrganizationBudget>(); Bud_OrganizationMonthBudget budget2 = new Bud_OrganizationMonthBudget { Id = indirMonthBudget.Id, Amount = new decimal?(indirMonthBudget.Amount), Month = indirMonthBudget.Month, Year = indirMonthBudget.Year, Bud_OrganizationBudget = budget }; entities.AddToBud_OrganizationMonthBudget(budget2); entities.SaveChanges(); } }
public void Add(OrganizationBudget organBudget) { using (pm2Entities entities = new pm2Entities()) { Bud_OrganizationBudget budget = new Bud_OrganizationBudget { Id = organBudget.Id, BudgetAmount = new decimal?(organBudget.BudgetAmount), AccountingAmount = new decimal?(organBudget.AccountAmount), CBSCode = organBudget.CBSCode, OrganizationBudgetId = organBudget.OrganizationBudgetId, State = organBudget.State, Note = organBudget.Note, InputUser = organBudget.InputUser, InputDate = this.InputDate }; entities.AddToBud_OrganizationBudget(budget); entities.SaveChanges(); } }