protected static void AddTotalIndirect(List <OrganizationBudget> indirectBudgets)
{
OrganizationBudget item = new OrganizationBudget {
Id = Guid.NewGuid().ToString(),
CBSCode = "001002",
AccountAmount = 0M,
BudgetAmount = 0M,
State = "2"
};
indirectBudgets.Insert(0, item);
}
private void AddToOrganBudget(string cbsCode, string inputUser)
{
using (pm2Entities entities = new pm2Entities())
{
foreach (System.Linq.IGrouping <string, string> grouping in (from m in entities.Bud_OrganizationBudget
select m.OrganizationBudgetId into id
group id by id).ToList <System.Linq.IGrouping <string, string> >())
{
string key = grouping.Key;
OrganizationBudget organBudget = OrganizationBudget.Create(Guid.NewGuid().ToString(), key, cbsCode, 0M, 0M, inputUser, DateTime.Now, string.Empty);
organBudget.Add(organBudget);
}
}
}
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 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();
}
}
public static OrganizationBudget GetByOrganAndCBSCode(string organizationBudgetId, string cbsCode)
{
OrganizationBudget organBudget = null;
using (pm2Entities context = new pm2Entities())
{
organBudget = (
from m in context.Bud_OrganizationBudget
where m.OrganizationBudgetId == organizationBudgetId && m.CBSCode == cbsCode
select new OrganizationBudget
{
State = m.State,
AccountAmount = m.AccountingAmount ?? 0m,
CBSCode = m.CBSCode,
OrganizationBudgetId = m.OrganizationBudgetId,
BudgetAmount = m.BudgetAmount ?? 0m
}).FirstOrDefault <OrganizationBudget>();
}
return(organBudget);
}
public static OrganizationBudget GetById(string id)
{
OrganizationBudget organBudget = null;
using (pm2Entities context = new pm2Entities())
{
organBudget = (
from m in context.Bud_OrganizationBudget
where m.Id == id
select new OrganizationBudget
{
Id = m.Id,
State = m.State,
InputDate = m.InputDate,
AccountAmount = m.AccountingAmount ?? 0m,
CBSCode = m.CBSCode,
OrganizationBudgetId = m.OrganizationBudgetId,
BudgetAmount = m.BudgetAmount ?? 0m
}).FirstOrDefault <OrganizationBudget>();
}
return(organBudget);
}
public static System.Collections.Generic.List <OrganizationBudget> GetAllPass(string organizationBudgetId)
{
System.Collections.Generic.List <OrganizationBudget> organBudgets = new System.Collections.Generic.List <OrganizationBudget>();
using (pm2Entities context = new pm2Entities())
{
organBudgets = (
from m in context.Bud_OrganizationBudget
where m.OrganizationBudgetId == organizationBudgetId && m.State == "2"
orderby m.CBSCode
select new OrganizationBudget
{
Id = m.Id,
AccountAmount = (decimal)m.AccountingAmount,
BudgetAmount = (decimal)m.BudgetAmount,
CBSCode = m.CBSCode
}).ToList <OrganizationBudget>();
if (organBudgets.Count > 0)
{
OrganizationBudget.AddTotalIndirect(organBudgets);
}
}
return(organBudgets);
}
protected bool IsDelAll(List <string> ids)
{
bool flag = true;
using (pm2Entities entities = new pm2Entities())
{
using (List <string> .Enumerator enumerator = ids.GetEnumerator())
{
string id;
while (enumerator.MoveNext())
{
id = enumerator.Current;
Bud_CostAccounting accounting = (from m in entities.Bud_CostAccounting
where (m.Id == id) && (m.CBSCode.Length >= 6)
select m).FirstOrDefault <Bud_CostAccounting>();
if (accounting != null)
{
bool flag2 = true;
string cBSCode = accounting.CBSCode;
if (accounting.Type == "D")
{
flag2 = ConstructResource.IsExistCBSCode(cBSCode);
}
else
{
flag2 = IndirectBudget.IsExistCBSCode(cBSCode) || OrganizationBudget.IsExistCBSCode(cBSCode);
}
if (flag2)
{
return(false);
}
}
}
return(flag);
}
}
}
public static void AddOrDelDesktopNotifications(string id, bool isEReport)
{
string zzjgName = OrganizationBudget.GetZZJGName(id);
System.Text.StringBuilder sqlYHMC = new System.Text.StringBuilder();
sqlYHMC.Append("SELECT v_yhdm FROM PT_yhmc");
sqlYHMC.AppendLine();
sqlYHMC.AppendFormat("WHERE i_bmdm='{0}' AND State='1' AND c_sfyx='y'", id);
SqlDataReader sdrYHBM = SqlHelper.ExecuteReader(CommandType.Text, sqlYHMC.ToString(), new SqlParameter[0]);
PTDbsjBll pTDbsjBll = new PTDbsjBll();
pTDbsjBll.DelPastDueData(id);
while (sdrYHBM.Read())
{
if (isEReport)
{
string people = sdrYHBM["v_yhdm"].ToString();
if (people != "")
{
System.Text.StringBuilder content = new System.Text.StringBuilder();
content.Append("组织机构:" + zzjgName);
content.Append("的间接成本预算已经上报,请审核!");
pTDbsjBll.Add(new PTDbsjModel
{
C_OpenFlag = "0",
DTM_DBSJ = System.DateTime.Now,
I_XGID = id,
V_Content = content.ToString(),
V_DBLJ = "BudgetManage/Cost/IndirectBudgetQuery.aspx?id=" + id,
V_LXBM = "021",
V_TPLJ = "new_Mail.gif",
V_YHDM = people
});
}
}
}
}
public static bool Del(List <string> ids)
{
bool flag = false;
CostAccounting accounting = new CostAccounting();
if (accounting.IsDelAll(ids))
{
using (pm2Entities entities = new pm2Entities())
{
using (List <string> .Enumerator enumerator = ids.GetEnumerator())
{
string id;
while (enumerator.MoveNext())
{
id = enumerator.Current;
Bud_CostAccounting entity = (from m in entities.Bud_CostAccounting
where (m.Id == id) && (m.CBSCode.Length >= 6)
select m).FirstOrDefault <Bud_CostAccounting>();
if (entity != null)
{
bool flag3 = true;
string cBSCode = entity.CBSCode;
if (entity.Type == "D")
{
flag3 = ConstructResource.IsExistCBSCode(cBSCode);
}
else
{
flag3 = IndirectBudget.IsExistCBSCode(cBSCode) || OrganizationBudget.IsExistCBSCode(cBSCode);
}
if (!flag3)
{
entities.DeleteObject(entity);
entities.SaveChanges();
flag = true;
}
}
}
}
}
}
return(flag);
}