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();
}
}
