Ejemplo n.º 1
0
        public override string GenerateReport()
        {
            if (this.ReportType == XEnum.ReportType.C_XZDKMX_D)
            {
                this.ReportFileName = string.Format("各支行新增风险贷款明细表({0}-{1}).xls", this.AsOfDate.ToString("yyyy.M.d"), this.AsOfDate2.ToString("yyyy.M.d"));
                this.SPName         = "spC_XZDKMX_D";
            }
            else if (this.ReportType == XEnum.ReportType.C_JQDKMX_D)
            {
                this.ReportFileName = string.Format("各支行化解及清息贷款明细表({0}-{1}).xls", this.AsOfDate.ToString("yyyy.M.d"), this.AsOfDate2.ToString("yyyy.M.d"));
                this.SPName         = "spC_JQDKMX_D";
            }
            else
            {
                var msg = "Unknown Import loan daily report type: " + this.ReportType.ToString();
                Logger.Error(msg);
                return(msg);
            }

            var fileName = this.ReportFileName;

            Logger.Debug("Generating " + fileName);
            Logger.Debug("Selected columns Loan: " + string.Join(", ", this.DbColumnNames));

            var report   = TargetTable.GetById(this.ReportType);
            var filePath = CreateReportFile(report.TemplateName, fileName, this.AsOfDate2);

            foreach (var sheet in report.Sheets)
            {
                PopulateSheet(filePath, sheet);
            }
            ExcelHelper.ActivateSheet(filePath);

            return(string.Empty);
        }
Ejemplo n.º 2
0
        public override string GenerateReport()
        {
            var import = Import.GetByDate(this.AsOfDate);

            if (import == null)
            {
                var msg = string.Format("{0}的数据还没导入系统", this.AsOfDate.ToString("yyyy年M月d日"));
                Logger.Debug(msg);
                return(msg);
            }
            var fileName = string.Format("榆林分行{0}月末风险贷款情况表 - {1}.xls", this.AsOfDate.Month, import.WJFLDate == null ? "初" : "终");

            Logger.Debug("Generating " + fileName);

            var report   = TargetTable.GetById(XEnum.ReportType.X_WJFL_M);
            var filePath = CreateReportFile(report.TemplateName, fileName);

            foreach (var sheet in report.Sheets)
            {
                if (sheet.Name.Equals("累收累增"))
                {
                    PopulateSheetVS(filePath, sheet);
                }
                else
                {
                    PopulateSheet(filePath, sheet);
                }
            }

            ExcelHelper.ActivateSheet(filePath);

            return(string.Empty);
        }
Ejemplo n.º 3
0
        public override string GenerateReport()
        {
            var fileName = string.Format("城商行榆林地区{0}月授信情况统计表.xls", this.AsOfDate.Month);

            Logger.Debug("Generating " + fileName);
            var report   = TargetTable.GetById(XEnum.ReportType.X_CSHSX_M);
            var filePath = CreateReportFile(report.TemplateName, fileName);

            var result = string.Empty;

            foreach (var sheet in report.Sheets)
            {
                switch (sheet.Index)
                {
                case 1:
                    result = PopulateSheet1(filePath, sheet);
                    break;

                case 2:
                    result = PopulateSheet2(filePath, sheet);
                    break;

                case 3:
                    PopulateSheet3(filePath, sheet);
                    break;

                case 4:
                    result = PopulateSheet4(filePath, sheet);
                    break;

                default:
                    break;
                }

                if (!string.IsNullOrEmpty(result))
                {
                    break;
                }
            }

            ExcelHelper.ActivateSheet(filePath);

            return(result);
        }
Ejemplo n.º 4
0
        public override string GenerateReport()
        {
            var fileName = string.Format("{0}月到期贷款情况.xls", this.AsOfDate.ToString("MM").TrimStart('0'));

            Logger.Debug("Generating " + fileName);
            Logger.Debug("Selected columns Public: " + string.Join(", ", this.PublicColumns));
            Logger.Debug("Selected columns Private: " + string.Join(", ", this.PrivateColumns));

            var report   = TargetTable.GetById(XEnum.ReportType.C_DQDKQK_M);
            var filePath = CreateReportFile(report.TemplateName, fileName);

            foreach (var sheet in report.Sheets)
            {
                PopulateSheet(filePath, sheet);
            }
            ExcelHelper.ActivateSheet(filePath);

            return(string.Empty);
        }
Ejemplo n.º 5
0
        public override string GenerateReport()
        {
            var fileName = string.Format("{0}新榆林地区不良贷款监测旬报(旬报).xls", this.AsOfDate.ToString("M.dd"));

            Logger.Debug("Generating " + fileName);

            var report   = TargetTable.GetById(XEnum.ReportType.X_BLDKJC_X);
            var filePath = CreateReportFile(report.TemplateName, fileName);

            var result = string.Empty;

            foreach (var sheet in report.Sheets)
            {
                if (sheet.Name.Equals("附表1"))
                {
                    result = PopulateSheet1(filePath, sheet);
                }
                else if (sheet.Name.Equals("附表2"))
                {
                    result = PopulateSheet2(filePath, sheet);
                }
                else if (sheet.Name.Equals("附表3"))
                {
                    result = PopulateSheet3(filePath, sheet);
                }
                else if (sheet.Name.Equals("附表4"))
                {
                    result = PopulateSheet4(filePath, sheet);
                }

                if (!string.IsNullOrEmpty(result))
                {
                    break;
                }
            }

            ExcelHelper.ActivateSheet(filePath);

            return(result);
        }