C# (CSharp) ChartRowsModel示例

示例#1

 private void FillNonNHSBridgeCountPercentSection(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears,
                                                  int dataStartRow, ChartRowsModel chartRowsModel)
 {
     bridgeWorkSummaryCommon.AddBridgeHeaders(worksheet, currentCell, simulationYears, "Non-NHS Bridge Count Percentage", true);
     chartRowsModel.NonNHSBridgeCountPercentSectionYearsRow = currentCell.Row;
     AddDetailsForNonNHSPercentSection(worksheet, currentCell, simulationYears, dataStartRow);
 }

示例#2

        /// <summary>
        /// Fill work summary bridge poor on off rate and deck area sections
        /// </summary>
        /// <param name="worksheet"></param>
        /// <param name="currentCell"></param>
        /// <param name="simulationYears"></param>
        /// <param name="simulationDataModels"></param>
        /// <returns>ChartRowsModel object for usage in other tab reports.</returns>
        public ChartRowsModel FillBridgeRateDeckAreaWorkSummarySections(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, List <SimulationDataModel> simulationDataModels)
        {
            var chartRowsModel = new ChartRowsModel();

            FillPoorBridgeOnOffRateSection(worksheet, currentCell, simulationYears, simulationDataModels);
            chartRowsModel.TotalPoorBridgesCountSectionYearsRow    = FillTotalPoorBridgesCountSection(worksheet, currentCell, simulationYears, simulationDataModels);
            chartRowsModel.TotalPoorBridgesDeckAreaSectionYearsRow = FillTotalPoorBridgesDeckAreaSection(worksheet, currentCell, simulationYears, simulationDataModels);
            chartRowsModel.TotalBridgeCountSectionYearsRow         = FillTotalBridgeCountSection(worksheet, currentCell, simulationYears, simulationDataModels);
            chartRowsModel.TotalDeckAreaSectionYearsRow            = FillTotalDeckAreaSection(worksheet, currentCell, simulationYears, simulationDataModels);
            return(chartRowsModel);
        }

示例#3

 internal ChartRowsModel FillPoorDeckArea(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears,
                                          List <SimulationDataModel> simulationDataModels, List <BridgeDataModel> bridgeDataModels, ChartRowsModel chartRowsModel)
 {
     //excelHelper.ApplyColor(worksheet.Cells[currentCell.Row, 1, currentCell.Row, worksheet.Dimension.Columns], Color.LightGray);
     bridgeWorkSummaryCommon.AddBridgeHeaders(worksheet, currentCell, simulationYears, "Poor Deck Area", true);
     chartRowsModel.TotalPoorDeckAreaByBPNSectionYearsRow = currentCell.Row;
     AddDetailsForPoorDeckArea(worksheet, currentCell, simulationYears, simulationDataModels, bridgeDataModels);
     return(chartRowsModel);
 }

示例#4

文件： PostedClosedBridgeWorkSummary.cs 项目： Tubbz-alt/iAM

 internal ChartRowsModel FillMoneyNeededByBPN(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears,
                                              List <SimulationDataModel> simulationDataModels, List <BridgeDataModel> bridgeDataModels, ChartRowsModel chartRowsModel)
 {
     //excelHelper.ApplyColor(worksheet.Cells[currentCell.Row, 1, currentCell.Row, worksheet.Dimension.Columns], Color.LightGray);
     bridgeWorkSummaryCommon.AddBridgeHeaders(worksheet, currentCell, simulationYears, "Dollar Needs By BPN", false);
     chartRowsModel.TotalCashNeededByBPNYearsRow = currentCell.Row;
     AddDetailsForMoneyNeededByBPN(worksheet, currentCell, simulationYears, simulationDataModels, bridgeDataModels);
     return(chartRowsModel);
 }

示例#5

        /// <summary>
        /// Fill NHS sections.
        /// </summary>
        /// <param name="worksheet"></param>
        /// <param name="currentCell"></param>
        /// <param name="simulationYears"></param>
        /// <param name="simulationDataModels"></param>
        /// <param name="bridgeDataModels"></param>
        /// <param name="chartRowsModel"></param>
        public void FillNHSBridgeDeckAreaWorkSummarySections(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, List <SimulationDataModel> simulationDataModels, List <BridgeDataModel> bridgeDataModels, ChartRowsModel chartRowsModel)
        {
            var dataStartRow = FillNHSBridgeCountSection(worksheet, currentCell, simulationYears, simulationDataModels, bridgeDataModels);

            FillNHSBridgeCountPercentSection(worksheet, currentCell, simulationYears, dataStartRow, chartRowsModel);
            dataStartRow = FillNHSBridgeDeckAreaSection(worksheet, currentCell, simulationYears, simulationDataModels, bridgeDataModels);
            FillNHSBridgeDeckAreaPercentSection(worksheet, currentCell, simulationYears, dataStartRow, chartRowsModel);
        }

示例#6

        private int FillNonNHSBridgeCountSection(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, int totalBridgeCountSectionStartRow, int nHSBridgeCountSectionStartRow, ChartRowsModel chartRowsModel)
        {
            bridgeWorkSummaryCommon.AddBridgeHeaders(worksheet, currentCell, simulationYears, "Non-NHS Bridge Count", true);
            var dataStartRow = currentCell.Row + 1;

            AddDetailsForNonNHSCountAndArea(worksheet, currentCell, simulationYears, totalBridgeCountSectionStartRow, nHSBridgeCountSectionStartRow, false);
            return(dataStartRow);
        }