protected override void selectSmoFomsReportData(Worksheet ws, AccountCorrectParams args, List<FomsReportRowData> formReportData, string smoCode, FomsReportRowType rowType) { var data = formReportData.FirstOrDefault(x => x.SmoCode == smoCode && x.RowType == rowType); if (data == null) { data = new FomsReportRowData() { SmoCode = smoCode, RowType = rowType }; formReportData.Add(data); } var row = (Range)ws.Rows[totalOmsRowIndex]; var colIndex = 0; if (rowType == FomsReportRowType.Plan) colIndex = 9; if (rowType == FomsReportRowType.Fact) colIndex = 15; data.ProfilacticCount = row.GetCellValue<int>(1, colIndex) + row.GetCellValue<int>(1, colIndex + 1); colIndex += 2; data.VisitCount = row.GetCellValue<int>(1, colIndex) + row.GetCellValue<int>(1, colIndex + 1); colIndex += 2; data.TreatmentCount = row.GetCellValue<int>(1, colIndex) + row.GetCellValue<int>(1, colIndex + 1); colIndex += 2; row = (Range)ws.Rows[emergencyRowIndex]; if (rowType == FomsReportRowType.Plan) colIndex = 11; if (rowType == FomsReportRowType.Fact) colIndex = 17; data.EmergencyCount = row.GetCellValue<int>(1, colIndex) + row.GetCellValue<int>(1, colIndex + 1); }
public void SelectFomsReportData(Worksheet ws, AccountCorrectParams args, List<FomsReportRowData> fomsReportData, string smoCode, FomsReportRowType rowType) { var data = fomsReportData.FirstOrDefault(x => x.SmoCode == smoCode && x.RowType == rowType); if (data == null) { data = new FomsReportRowData() {SmoCode = smoCode, RowType = rowType}; fomsReportData.Add(data); } var row = (Range) ws.Rows[maxRowIndex + 1]; var colIndex = 0; if (rowType == FomsReportRowType.Plan) colIndex = 7; if (rowType == FomsReportRowType.Fact) colIndex = 11; var sumValue = row.GetCellValue<int>(1, colIndex) + row.GetCellValue<int>(1, colIndex + 1) + row.GetCellValue<int>(1, colIndex + 2) + row.GetCellValue<int>(1, colIndex + 3); switch (stacionarType) { case StacionarType.Apu: data.StacApuCount = sumValue; break; case StacionarType.Full: data.StacFullCount = sumValue; break; case StacionarType.Day: data.StacDayCount = sumValue; break; } }
protected override void selectSmoFomsReportData(Worksheet ws, AccountCorrectParams args, List<FomsReportRowData> formReportData, string smoCode, FomsReportRowType rowType) { var data = formReportData.FirstOrDefault(x => x.SmoCode == smoCode && x.RowType == rowType); if (data == null) { data = new FomsReportRowData() { SmoCode = smoCode, RowType = rowType }; formReportData.Add(data); } var doctorRow = (Range)ws.Rows[doctorEventsRowIndex]; var feldRow = (Range)ws.Rows[feldEventsRowIndex]; var colIndex = 0; if (rowType == FomsReportRowType.Plan) colIndex = 4; if (rowType == FomsReportRowType.Fact) colIndex = 5; data.AmbulanceCount = doctorRow.GetCellValue<int>(1, colIndex) + feldRow.GetCellValue<int>(1, colIndex); }