Ejemplo n.º 1
0
        public string ExportData(XEnum.ReportType report, DateTime asOfDate, DateTime asOfDate2, List <string> columnNames, List <string> columnNames2)
        {
            this.AsOfDate = asOfDate;

            if (report != XEnum.ReportType.C_DQDKQK_M)
            {
                var dao    = new SqlDbHelper();
                var import = dao.ExecuteScalar(string.Format("SELECT 1 FROM Import WHERE ImportDate = '{0}'", asOfDate.ToString("yyyyMMdd")));
                if (import == null)
                {
                    return(string.Format("{0}的数据还没导入系统", asOfDate.ToString("M月d日")));
                }
            }

            var result = string.Empty;

            switch (report)
            {
            case XEnum.ReportType.X_WJFL_M:
                result = new LoanRiskPerMonth(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_HYB_M:
                result = new LoanRiskPerMonthHYB(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF0102_081_M:
                result = new GF0102_081(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF0102_161_M:
                result = new GF0102_161(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF0107_141_M:
                result = new GF0107_141(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_SF6301_141_M:
                result = new SF6301_141(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_SF6401_141_M:
                result = new SF6401_141(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.X_FXDKTB_D:
                result = new X_FXDKTB_D(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.X_FXDKBH_D:
                result = new X_FXDKBH_D(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.C_DQDKQK_M:
                result = new C_DQDKQK_M(asOfDate, columnNames, columnNames2).GenerateReport();
                break;

            case XEnum.ReportType.C_XZDKMX_D:
                result = new C_XZDKMX_D(this.AsOfDate, this.AsOfDate2, Columns).GenerateReport();
                break;

            case XEnum.ReportType.C_JQDKMX_D:
                result = new C_JQDKMX_D(this.AsOfDate, this.AsOfDate2, Columns).GenerateReport();
                break;

            case XEnum.ReportType.X_ZXQYZJXQ_S:
                result = new X_ZXQYZJXQ_S(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.X_DKZLFL_M:
                result = new X_DKZLFL_M(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF1101_121_S:
                result = new GF1101_121(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF1103_121_S:
                result = new GF1103_121(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF1200_101_S:
                result = new GF1200_101(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF1301_081_S:
                result = new GF1301_081(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF1302_081_S:
                result = new GF1302_081(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF1303_081_S:
                result = new GF1303_081(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF1304_081_S:
                result = new GF1304_081(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF1403_111_S:
                result = new GF1403_111(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_GF1900_151_S:
                result = new GF1900_151(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_SF6302_131_S:
                result = new SF6302_131(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.F_SF6402_131_S:
                result = new SF6402_131(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.X_BLDKJC_X:
                result = new X_BLDKJC_X(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.X_CSHSX_M:
                result = new X_CSHSX_M(asOfDate).GenerateReport();
                break;

            case XEnum.ReportType.X_WJFLPRD_D:
                result = new X_WJFLPRD_D(asOfDate).GenerateReport();
                break;

            default:
                result = "Unknown report type: " + report;
                break;
            }
            return(result);
        }
Ejemplo n.º 2
0
        public string ExportData(XEnum.ReportType report, DateTime asOfDate, DateTime asOfDate2, List<string> columnNames, List<string> columnNames2)
        {
            this.AsOfDate = asOfDate;

            if (report != XEnum.ReportType.C_DQDKQK_M) {
                var dao = new SqlDbHelper();
                var import = dao.ExecuteScalar(string.Format("SELECT 1 FROM Import WHERE ImportDate = '{0}'", asOfDate.ToString("yyyyMMdd")));
                if (import == null) {
                    return string.Format("{0}的数据还没导入系统", asOfDate.ToString("M月d日"));
                }
            }

            var result = string.Empty;
            switch (report) {
                case XEnum.ReportType.X_WJFL_M:
                    result = new LoanRiskPerMonth(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_HYB_M:
                    result = new LoanRiskPerMonthHYB(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF0102_081_M:
                    result = new GF0102_081(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF0102_161_M:
                    result = new GF0102_161(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF0107_141_M:
                    result = new GF0107_141(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_SF6301_141_M:
                    result = new SF6301_141(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_SF6401_141_M:
                    result = new SF6401_141(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.X_FXDKTB_D:
                    result = new X_FXDKTB_D(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.X_FXDKBH_D:
                    result = new X_FXDKBH_D(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.C_DQDKQK_M:
                    result = new C_DQDKQK_M(asOfDate, columnNames, columnNames2).GenerateReport();
                    break;
                case XEnum.ReportType.C_XZDKMX_D:
                    result = new C_XZDKMX_D(this.AsOfDate, this.AsOfDate2, Columns).GenerateReport();
                    break;
                case XEnum.ReportType.C_JQDKMX_D:
                    result = new C_JQDKMX_D(this.AsOfDate, this.AsOfDate2, Columns).GenerateReport();
                    break;
                case XEnum.ReportType.X_ZXQYZJXQ_S:
                    result = new X_ZXQYZJXQ_S(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.X_DKZLFL_M:
                    result = new X_DKZLFL_M(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF1101_121_S:
                    result = new GF1101_121(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF1103_121_S:
                    result = new GF1103_121(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF1200_101_S:
                    result = new GF1200_101(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF1301_081_S:
                    result = new GF1301_081(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF1302_081_S:
                    result = new GF1302_081(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF1303_081_S:
                    result = new GF1303_081(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF1304_081_S:
                    result = new GF1304_081(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF1403_111_S:
                    result = new GF1403_111(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_GF1900_151_S:
                    result = new GF1900_151(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_SF6302_131_S:
                    result = new SF6302_131(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.F_SF6402_131_S:
                    result = new SF6402_131(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.X_BLDKJC_X:
                    result = new X_BLDKJC_X(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.X_CSHSX_M:
                    result = new X_CSHSX_M(asOfDate).GenerateReport();
                    break;
                case XEnum.ReportType.X_WJFLPRD_D:
                    result = new X_WJFLPRD_D(asOfDate).GenerateReport();
                    break;
                default:
                    result = "Unknown report type: " + report;
                    break;
            } return result;
        }