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