static void InitXmlConfig()
{
csDBToExcel e2o = new csDBToExcel();
e2o.Sheets = new List <Sheet>();
e2o.ConnStr = "connection string";
e2o.DBType = "oracle";
Sheet sm = new Sheet();
sm.SheetName = "sheetname";
sm.Sql = "sql sentence";
sm.Fileds = new List <Filed>();
Filed fm = new Filed();
fm.FldName = "fieldname";
fm.RowName = "rowname";
sm.Fileds.Add(fm);
e2o.Sheets.Add(sm);
e2o.toXmlFile();
}
static void Main(string[] args)
{
var startMsg = $"开始执行 {DateTime.Now:F}\n";
Console.WriteLine(startMsg);
logger.Info("开始执行");
var eo = new csDBToExcel().fromXmlFile();
//check config
var checkConfig = Exec.CheckConfig(eo);
if (!checkConfig.success)
{
Console.WriteLine(checkConfig.errMsg);
logger.Info(checkConfig.errMsg);
goto end;
}
//to execl
var toExcel = Exec.ToExcel(eo);
if (!toExcel.success)
{
Console.WriteLine(toExcel.errMsg);
logger.Info(toExcel.errMsg);
goto end;
}
Console.WriteLine($"本次执行成功\n");
logger.Info($"本次执行成功\n");
end : Console.WriteLine("Please enter any key to colse..");
Console.ReadKey(true);
}
