/// <summary>
/// Update into CWStaffSpending
/// </summary>
/// <param name="cwstaffspending">CWStaffSpending</param>
public void UpdateCWStaffSpending(CWStaffSpending cwstaffspending)
{
if (cwstaffspending == null)
{
return;
}
if (this._context.IsAttached(cwstaffspending))
{
this._context.CWStaffSpendings.Attach(cwstaffspending);
}
this._context.SaveChanges();
}
/// <summary>
/// Insert into CWStaffSpending
/// </summary>
/// <param name="cwstaffspending">CWStaffSpending</param>
public void InsertCWStaffSpending(CWStaffSpending cwstaffspending)
{
if (cwstaffspending == null)
{
return;
}
if (!this._context.IsAttached(cwstaffspending))
{
this._context.CWStaffSpendings.AddObject(cwstaffspending);
}
this._context.SaveChanges();
}
public List <CWStaffSpending> GetAllResult(List <int> FinancialFieldList, string year, string month, int ProjectId, int DepartmentType, int NickId)
{
DateTime Begin = DateTime.Parse(year + "/" + month + "/01");
DateTime End = Begin.AddMonths(1);
List <CWStaffSpending> list = new List <CWStaffSpending>();
List <int?> financialFieldList = new List <int?>();
foreach (int a in FinancialFieldList)
{
int?b = a;
financialFieldList.Add(b);
}
var StaffSpendingList = IoC.Resolve <ICWStaffSpendingService>().GetCWStaffSpendingListbyData(financialFieldList, year, month, ProjectId, DepartmentType, NickId);
var FinancialCapitalFlowList = IoC.Resolve <IXMFinancialCapitalFlowService>().GetListByFinancialFieldList(Begin.ToString(), End.ToString(), DepartmentType, ProjectId, financialFieldList);
foreach (int FinancialFieldId in FinancialFieldList)
{
var staffSpendingList = StaffSpendingList.Where(x => x.FinancialFieldId == FinancialFieldId);
if (staffSpendingList.Count() > 0)
{
CWStaffSpending item = new CWStaffSpending();
item.FinancialFieldId = FinancialFieldId;
item.CountMoney = staffSpendingList.Sum(x => x.CountMoney);
list.Add(item);
}
else
{
var financialCapitalFlowList = FinancialCapitalFlowList.Where(x => x.BudgetType == FinancialFieldId);
if (financialCapitalFlowList.Count() > 0)
{
CWStaffSpending item = new CWStaffSpending();
item.FinancialFieldId = FinancialFieldId;
item.CountMoney = financialCapitalFlowList.Sum(x => x.Amount);
list.Add(item);
}
}
}
return(list);
}
