public object GetCashflowDetailDataTable(string projectGuid, DateTime paymentDate) { var project = m_dbAdapter.Project.GetProjectByGuid(projectGuid); var projectLogicModel = new ProjectLogicModel(CurrentUserName, project); var datasetSchedule = projectLogicModel.DealSchedule.GetByPaymentDay(paymentDate); CommUtils.AssertNotNull(datasetSchedule.Dataset.Instance, "第{0}期模型未生成", Toolkit.DateToString(datasetSchedule.PaymentDate)); var dataset = m_dbAdapter.Dataset.GetDatasetByDurationPeriod(project.ProjectId, paymentDate); //同步数据库中参数到模型文件 var variableDateset = m_dbAdapter.CashflowVariable.GetByPaymentDay(project.ProjectId, paymentDate); UpdateVariablesFromCurrPeriodDBToModel(datasetSchedule.Dataset, variableDateset, project.ProjectId, paymentDate); var cashflowTableViewModel = new CashflowDetailTableViewModel(); cashflowTableViewModel.CurrentPaymentDate = Toolkit.DateToString(datasetSchedule.PaymentDate); //获取预测的资产池当期本金与利息 var acfTable = datasetSchedule.Dataset.DealModel.AssetCashflowDt; for (int i = acfTable.Columns.Count - 1; i >= 0; i--) { var c = acfTable.Columns[i]; DateTime date; if (DateTime.TryParse(c.ColumnName, out date)) { if (date < paymentDate) { acfTable.Columns.Remove(c); } } } var assetViewModel = Toolkit.GetAssetCashflow(acfTable, paymentDate); //判断本金与利息是否被覆盖 var assetCashflowVariable = m_dbAdapter.AssetCashflowVariable.GetByProjectIdPaymentDay(project.ProjectId, paymentDate); var cashflowViewModel = new CashflowViewModel(); cashflowViewModel.PredictInterestCollection = double.Parse(assetViewModel.TotalCurrentInterestCollection.ToString("n2")); cashflowViewModel.PredictPricipalCollection = double.Parse(assetViewModel.TotalCurrentPrinCollection.ToString("n2")); cashflowViewModel.OverridableVariables = SelectOverridableVariables(datasetSchedule.Dataset); var cashflowDt = ABSDealUtils.GetCashflowDt(datasetSchedule, assetCashflowVariable, cashflowViewModel.PredictInterestCollection, cashflowViewModel.PredictPricipalCollection, out double currInterest, out double currPrincipal); cashflowViewModel.CurrentInterestCollection = currInterest; cashflowViewModel.CurrentPricipalCollection = currPrincipal; cashflowDt = Toolkit.CleanCashflowTable(cashflowDt); var revertTable = cashflowDt.Transpose(); var notes = m_dbAdapter.Dataset.GetNotes(project.ProjectId); var noteDatas = m_dbAdapter.Dataset.GetNoteDatas(dataset.DatasetId); Toolkit.GetCashflowDetailData(cashflowTableViewModel, revertTable, notes, noteDatas); var result = new { ProjectCashflowHeader = cashflowTableViewModel.ProjectCashflowHeader, SecurityCashflowHeader = cashflowTableViewModel.SecurityCashflowHeader, AssetPoolHeader = cashflowTableViewModel.AssetPoolHeader, CostHeader = cashflowTableViewModel.CostHeader, AccountHeader = cashflowTableViewModel.AccountHeader, TriggerEventHeader = cashflowTableViewModel.TriggerEventHeader, HomePageHeader = cashflowTableViewModel.HomePageHeader, ProjectCashflowList = cashflowTableViewModel.ProjectCashflowList, SecurityCashflowList = cashflowTableViewModel.SecurityCashflowList.Keys.ToList().ConvertAll(x => new { TableName = x, DataList = cashflowTableViewModel.SecurityCashflowList[x] }), AssetPoolList = cashflowTableViewModel.AssetPoolList, CostList = cashflowTableViewModel.CostList, AccountList = cashflowTableViewModel.AccountList, TriggerEventList = cashflowTableViewModel.TriggerEventList, CurrPeriodCashflowInfoList = cashflowTableViewModel.CurrPeriodCashflowInfoList, CashflowEventList = cashflowTableViewModel.CashflowEventList, FeePayable = cashflowTableViewModel.FeePayable, CurrentPaymentDate = cashflowTableViewModel.CurrentPaymentDate, PredictInterestCollection = cashflowViewModel.PredictInterestCollection, PredictPricipalCollection = cashflowViewModel.PredictPricipalCollection, CurrentInterestCollection = cashflowViewModel.CurrentInterestCollection, CurrentPricipalCollection = cashflowViewModel.CurrentPricipalCollection, OverridableVariables = cashflowViewModel.OverridableVariables, TestFailRemind = cashflowTableViewModel.TestFailRemind }; return(result); }
private object GetCFTableByProject(CashflowViewModel viewModel, string projectGuid, DateTime paymentDate) { var project = m_dbAdapter.Project.GetProjectByGuid(projectGuid); var projectLogicModel = Platform.GetProject(projectGuid); var datasetSchedule = projectLogicModel.DealSchedule.GetByPaymentDay(paymentDate); CommUtils.AssertNotNull(datasetSchedule.Dataset.Instance, "第{0}期模型未生成", Toolkit.DateToString(datasetSchedule.PaymentDate)); //同步数据库中参数到模型文件 var variableDateset = m_dbAdapter.CashflowVariable.GetByPaymentDay(project.ProjectId, paymentDate); UpdateVariablesFromCurrPeriodDBToModel(datasetSchedule.Dataset, variableDateset, project.ProjectId, paymentDate); var cashflowTableViewModel = new CashflowDetailTableViewModel(); cashflowTableViewModel.CurrentPaymentDate = Toolkit.DateToString(datasetSchedule.PaymentDate); //获取预测的资产池当期本金与利息 var acfTable = datasetSchedule.Dataset.DealModel.AssetCashflowDt; for (int i = acfTable.Columns.Count - 1; i >= 0; i--) { var c = acfTable.Columns[i]; DateTime date; if (DateTime.TryParse(c.ColumnName, out date)) { if (date < paymentDate) { acfTable.Columns.Remove(c); } } } var assetViewModel = Toolkit.GetAssetCashflow(acfTable, paymentDate); //判断本金与利息是否被覆盖 var assetCashflowVariable = m_dbAdapter.AssetCashflowVariable.GetByProjectIdPaymentDay(project.ProjectId, paymentDate); var cashflowViewModel = new CashflowViewModel(); cashflowViewModel.PredictInterestCollection = double.Parse(assetViewModel.TotalCurrentInterestCollection.ToString("n2")); cashflowViewModel.PredictPricipalCollection = double.Parse(assetViewModel.TotalCurrentPrinCollection.ToString("n2")); cashflowViewModel.OverridableVariables = SelectOverridableVariables(datasetSchedule.Dataset); var cashflowDt = ABSDealUtils.GetCashflowDt(datasetSchedule, assetCashflowVariable, cashflowViewModel.PredictInterestCollection, cashflowViewModel.PredictPricipalCollection, out double currInterest, out double currPrincipal); cashflowViewModel.CurrentInterestCollection = currInterest; cashflowViewModel.CurrentPricipalCollection = currPrincipal; cashflowDt = ABSDealUtils.CleanAndTranslateCashflowTable(cashflowDt); var columnNames = new List <string>(); for (int i = 0; i < cashflowDt.Columns.Count; ++i) { var columnName = cashflowDt.Columns[i].ColumnName.ToString(); columnNames.Add(columnName); } viewModel.ColHeader = columnNames; string testFailRemind = null; var rowsNum = cashflowDt.Rows.Count; if (cashflowDt != null && rowsNum > 0) { var equalRowsNumber = 0; var prevAsset = cashflowDt.Rows[0][0].ToString(); for (int i = 0; i < rowsNum; i++) { DataRow dr = cashflowDt.Rows[i]; var row = dr.ItemArray.ToList().ConvertAll(x => x.ToString()); viewModel.CashflowDataResult.Add(row); if (testFailRemind == null) { if (row.Any(x => x.ToString() == "FAIL")) { testFailRemind = "预测将发生违约,启动差额支付"; } } var element = dr["类型"] != null ? dr["类型"].ToString() : ""; var description = dr["项目描述"] != null ? dr["项目描述"].ToString() : ""; if (prevAsset == element) { equalRowsNumber++; if (i == rowsNum - 1) { var info = new Tuple <int, int, int, int>(rowsNum - equalRowsNumber, 0, equalRowsNumber, 1); viewModel.MergeCellsInfo.Add(info); } } else { var info = new Tuple <int, int, int, int>(i - equalRowsNumber, 0, equalRowsNumber, 1); viewModel.MergeCellsInfo.Add(info); equalRowsNumber = 1; prevAsset = cashflowDt.Rows[i][0].ToString(); } } } var result = new { colHeader = viewModel.ColHeader, paymentDate = Toolkit.DateToString(paymentDate), dataResult = viewModel.CashflowDataResult, mergeCellsInfo = viewModel.MergeCellsInfo.ConvertAll(x => new { row = x.Item1, col = x.Item2, rowspan = x.Item3, colspan = x.Item4 }), isError = false, PredictInterestCollection = cashflowViewModel.PredictInterestCollection, PredictPricipalCollection = cashflowViewModel.PredictPricipalCollection, CurrentInterestCollection = cashflowViewModel.CurrentInterestCollection, CurrentPricipalCollection = cashflowViewModel.CurrentPricipalCollection, OverridableVariables = cashflowViewModel.OverridableVariables, TestFailRemind = testFailRemind }; return(result); }