public void Export(string businessDate,
         string conditionREPDZABM,
         string conditionMonFee,
         string conditionNoMaster,
         string conditionQQJY,
         string conditionPresent,
         string conditionAgio,
         string exportFilePath)
        {
            System.Data.DataTable dt = GetByCondition(businessDate,
                conditionREPDZABM, conditionMonFee, conditionNoMaster,
                conditionQQJY, conditionPresent, conditionAgio
                );

            string[,] arrayExport = Tools.DataTableToArray(dt, false);

            using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath))
            {
                Worksheet sheet = excelProcess.GetSheet(1);

                Range range = excelProcess.GetRange(sheet, 7, 1, 9, 7);
                range.Value2 = arrayExport;
                range.Value2 = range.Value2;

                excelProcess.SetCells(sheet, 3, 2, businessDate);
                excelProcess.SetCells(sheet, 15, 7, DateTime.Now.ToString("yyyyMMdd"));

                excelProcess.Save();
            }
        }
        public void Export(string businessDate, 
                           string conditionOffset,
                           string conditionLowestConsumption,
                           string conditionGroupPrepay,
                           string conditionUser1,
                           string conditionUser2,
                           string exportFilePath)
        {
            DataSet ds = GetByCondition(businessDate, conditionOffset, conditionLowestConsumption, conditionGroupPrepay, conditionUser1, conditionUser2);
            System.Data.DataTable dt1 = ds.Tables[0];
            System.Data.DataTable dt2 = ds.Tables[1];

            string[,] arrayExport1 = Tools.DataTableToArray(dt1, false);
            string[,] arrayExport2 = Tools.DataTableToArray(dt2, false);

            using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath))
            {
                Worksheet sheet = excelProcess.GetSheet(1);

                Range range1 = excelProcess.GetRange(sheet, 8, 1, 8, 7);
                range1.Value2 = arrayExport1;
                range1.Value2 = range1.Value2;

                Range range2 = excelProcess.GetRange(sheet, 16, 1, 16, 3);
                range2.Value2 = arrayExport2;
                range2.Value2 = range2.Value2;

                excelProcess.SetCells(sheet, 3, 2, businessDate);
                excelProcess.SetCells(sheet, 20, 7, DateTime.Now.ToString("yyyyMMdd"));

                excelProcess.Save();
            }
        }
        public void Export(string businessDate, string exportFilePath)
        {
            System.Data.DataTable dt = GetByBusinessDate(businessDate);

            string[,] arrayExport = Tools.DataTableToArray(dt, false);

            using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath))
            {
                Worksheet sheet = excelProcess.GetSheet(1);

                Range range = excelProcess.GetRange(sheet, 2, 1, 13, 10);
                range.Value2 = arrayExport;
                range.Value2 = range.Value2;

                Range rangeBusinessDate = excelProcess.GetRange(sheet, 2, 1, 3, 1);
                rangeBusinessDate.Merge(rangeBusinessDate.MergeCells);

                Range rangeMoneyTotal = excelProcess.GetRange(sheet, 2, 2, 3, 2);
                rangeMoneyTotal.Merge(rangeMoneyTotal.MergeCells);

                excelProcess.SetCells(sheet, 4, 2, string.Empty);

                rangeBusinessDate = excelProcess.GetRange(sheet, 5, 1, 6, 1);
                rangeBusinessDate.Merge(rangeBusinessDate.MergeCells);

                rangeMoneyTotal = excelProcess.GetRange(sheet, 5, 2, 6, 2);
                rangeMoneyTotal.Merge(rangeMoneyTotal.MergeCells);

                excelProcess.SetCells(sheet, 7, 2, string.Empty);

                rangeBusinessDate = excelProcess.GetRange(sheet, 8, 1, 9, 1);
                rangeBusinessDate.Merge(rangeBusinessDate.MergeCells);

                rangeMoneyTotal = excelProcess.GetRange(sheet, 8, 2, 9, 2);
                rangeMoneyTotal.Merge(rangeMoneyTotal.MergeCells);

                excelProcess.SetCells(sheet, 10, 2, string.Empty);

                rangeBusinessDate = excelProcess.GetRange(sheet, 11, 1, 12, 1);
                rangeBusinessDate.Merge(rangeBusinessDate.MergeCells);

                rangeMoneyTotal = excelProcess.GetRange(sheet, 11, 2, 12, 2);
                rangeMoneyTotal.Merge(rangeMoneyTotal.MergeCells);

                excelProcess.SetCells(sheet, 13, 2, string.Empty);

                excelProcess.Save();
            }
        }
        public void Export(string businessDate, string exportFilePath)
        {
            System.Data.DataTable dt = GetByBusinessDate(businessDate);

            string[,] arrayExport = Tools.DataTableToArray(dt, false);

            using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath))
            {
                Worksheet sheet = excelProcess.GetSheet(1);

                Range range = excelProcess.GetRange(sheet, 9, 1, 11, 10);
                range.Value2 = arrayExport;
                range.Value2 = range.Value2;

                excelProcess.SetCells(sheet, 3, 2, businessDate);
                excelProcess.SetCells(sheet, 18, 6, DateTime.Now.ToString("yyyyMMdd"));

                excelProcess.Save();
            }
        }
        public void Export(string businessDate, string exportFilePath)
        {
            System.Data.DataTable dt = GetByBusinessDate(businessDate);

            string[,] arrayExport = Tools.DataTableToArray(dt, false);

            using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath))
            {
                Worksheet sheet = excelProcess.GetSheet(1);

                excelProcess.CopyRowInsert(sheet, 7, 8, 6 + arrayExport.GetLength(0));

                Range range = excelProcess.GetRange(sheet, 7, 1, 6 + arrayExport.GetLength(0), arrayExport.GetLength(1));
                range.Value2 = arrayExport;
                range.Value2 = range.Value2;

                excelProcess.SetCells(sheet, 3, 2, businessDate);

                excelProcess.Save();
            }
        }
        public string Export(string businessDateStart, string businessDateEnd, byte businessType, string businessTypeValue, string exportFilePath)
        {
            System.Data.DataTable dt = GetAllByBusinessType(businessDateStart, businessDateEnd, businessType, businessTypeValue);

            string[,] arrayExport = Tools.DataTableToArray(dt, true);

            if (businessDateStart == businessDateEnd)
            {
                using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath))
                {
                    Worksheet sheet = excelProcess.GetSheet(1);

                    Range range = excelProcess.GetRange(sheet, 1, 1, arrayExport.GetLength(0), arrayExport.GetLength(1));
                    range.Value2 = arrayExport;
                    range.Value2 = range.Value2;
                    excelProcess.Save();
                }
            }
            else
            {
                int fixedColumnCount = 4;

                using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath))
                {
                    Worksheet sheet = excelProcess.GetSheet(1);

                    Range range = excelProcess.GetRange(sheet, 1, 1, arrayExport.GetLength(0), arrayExport.GetLength(1));
                    range.Value2 = arrayExport;
                    range.Value2 = range.Value2;

                    excelProcess.CopyRowInsert(sheet, 1, 2, 2);

                    excelProcess.GetRange(sheet, 1, 1, 2, 1).Merge();
                    excelProcess.GetRange(sheet, 1, 2, 2, 2).Merge();
                    excelProcess.GetRange(sheet, 1, 3, 2, 3).Merge();
                    excelProcess.GetRange(sheet, 1, 4, 2, 4).Merge();

                    for (int colIndex = 0; colIndex < arrayExport.GetLength(1) - fixedColumnCount; colIndex++)
                    {
                        excelProcess.SetCells(sheet, 1, colIndex + fixedColumnCount + 1, "金额");
                    }

                    excelProcess.GetRange(sheet, 1, fixedColumnCount + 1, 1, arrayExport.GetLength(1)).Merge();

                    excelProcess.Save();
                }
            }//end else (businessDateStart != businessDateEnd)

            string businessTypeName = string.Empty;
            switch (businessType)
            {
                case (byte)SynthesizeAnalyBusinessType.VoiceClass:
                    {
                        businessTypeName = "语单类";
                        break;
                    }
                case (byte)SynthesizeAnalyBusinessType.DreamClass:
                    {
                        businessTypeName = "梦网类";
                        break;
                    }
                case (byte)SynthesizeAnalyBusinessType.DataClass:
                    {
                        businessTypeName = "数据类";
                        break;
                    }
                case (byte)SynthesizeAnalyBusinessType.GroupClass:
                    {
                        businessTypeName = "集团类";
                        break;
                    }
            }

            string saveFileName = string.Empty;
            if (businessDateStart != businessDateEnd)
            {
                saveFileName = string.Format("{0}-{1}无主{2}.xls", businessDateStart, businessDateEnd, businessTypeName);
            }
            else
            {
                saveFileName = string.Format("{0}无主{1}.xls", businessDateStart, businessTypeName);
            }

            return saveFileName;
        }