예제 #1
0
        public void Analyze()
        {
            MainTool maintool = new MainTool(MdbFilePath);

            maintool.Doing();
            Console.WriteLine("完成GYYD表数据合并生成....................");
            MergeTool mergetool = new MergeTool(MdbFilePath);

            mergetool.Working();
            Console.WriteLine("完成GYYD_YDDW表数据合并生成...............");
            ITool tool = null;

            foreach (SheetEnum sheet in Enum.GetValues(typeof(SheetEnum)))
            {
                switch (sheet)
                {
                case SheetEnum.one:
                    tool = new ToolOne(MdbFilePath);
                    break;

                case SheetEnum.two:
                    tool = new ToolTwo(MdbFilePath);
                    break;

                case SheetEnum.three:
                    tool = new ToolThree(MdbFilePath);
                    break;

                case SheetEnum.four:
                    tool = new ToolFour(MdbFilePath);
                    break;

                case SheetEnum.five:
                    tool = new ToolFive(MdbFilePath);
                    break;

                case SheetEnum.six:
                    tool = new ToolSix(MdbFilePath);
                    break;
                }
                Console.WriteLine(string.Format("开始对{0}数据生成工作", tool.GetSheetName()));
                ISheet Bsheet = WorkBook.GetSheet(tool.GetSheetName());
                if (Bsheet != null)
                {
                    tool.Doing();
                    Console.WriteLine(string.Format("完成对{0}数据的采集", tool.GetSheetName()));
                    tool.Write(ref Bsheet);
                    Console.WriteLine(string.Format("成功保存{0}的数据到Sheet中", tool.GetSheetName()));
                }
            }
            Save();
            Console.WriteLine("完成结果表格的生成");
        }
예제 #2
0
        public void Analyze2(string SaveFolder)
        {
            MainTool maintool = new MainTool(MdbFilePath);

            maintool.Doing();
            Console.WriteLine("完成GYYD表数据合并生成....................");
            MergeTool mergetool = new MergeTool(MdbFilePath);

            mergetool.Working();
            Console.WriteLine("完成GYYD_YDDW表数据合并生成...............");
            ITool tool = null;

            foreach (SheetEnum sheet in Enum.GetValues(typeof(SheetEnum)))
            {
                switch (sheet)
                {
                case SheetEnum.one:
                    tool = new ToolOne(MdbFilePath);
                    break;

                case SheetEnum.two:
                    tool = new ToolTwo(MdbFilePath);
                    break;

                case SheetEnum.three:
                    tool = new ToolThree(MdbFilePath);
                    break;

                case SheetEnum.four:
                    tool = new ToolFour(MdbFilePath);
                    break;

                case SheetEnum.five:
                    tool = new ToolFive(MdbFilePath);
                    break;

                case SheetEnum.six:
                    tool = new ToolSix(MdbFilePath);
                    break;
                }
                Console.WriteLine(string.Format("开始对{0}数据生成工作", tool.GetSheetName()));
                IWorkbook ModelWorkbook = tool.GetCurrentName().GetSourcesPath().OperWorkbook();
                if (ModelWorkbook != null)
                {
                    ISheet Asheet = ModelWorkbook.GetSheet(tool.GetSheetName());
                    if (Asheet != null)
                    {
                        tool.Doing();
                        Console.WriteLine(string.Format("完成对{0}数据的采集", tool.GetSheetName()));
                        tool.Write(ref Asheet);
                        Console.WriteLine(string.Format("成功保存{0}的数据到Sheet中", tool.GetSheetName()));
                        string excelFilepath = System.IO.Path.Combine(SaveFolder, tool.GetCurrentName());
                        Save(excelFilepath, ModelWorkbook);
                        Console.WriteLine(string.Format("成功保存文件:{0}", excelFilepath));
                    }
                    else
                    {
                        Console.WriteLine("未找到Sheet");
                    }
                }
            }
            Console.WriteLine("完成结果表格的生成");
        }