public void GetValue(TableInfo tableInfo, ExcelConfigSetting excel, BatExportSetting bat, BatExportPublicSetting bPubilc)
{
IsExport = GetBoolValue(tableInfo, excel.IsExportParam, excel.IsExport, bat.IsExport, bPubilc.IsExport);
ExportPath = GetExportPath(GetStringValue(excel.ExportPath, bat.ExportPath, bPubilc.ExportPath));
IsExportKeepDirectoryStructure = GetBoolValue(tableInfo, excel.IsExportKeepDirectoryStructureParam, excel.IsExportKeepDirectoryStructure, bat.IsExportKeepDirectoryStructure, bPubilc.IsExportKeepDirectoryStructure);
ExcelOldPath = tableInfo.ExcelFilePath;// GetStringValue(excel.ExcelOldPath, bat.ExcelOldPath, bPubilc.ExcelOldPath);
ExportName = GetExportName(tableInfo, excel.ExportName);
ExcelNameSplitString = GetStringValue(excel.ExcelNameSplitString, bat.ExcelNameSplitString, bPubilc.ExcelNameSplitString);
ExportExtension = GetStringValue(excel.ExportExtension, bat.ExportExtension, bPubilc.ExportExtension);
ExportNameBeforeAdd = GetStringValue(excel.ExportNameBeforeAdd, bat.ExportNameBeforeAdd, bPubilc.ExportNameBeforeAdd);
ExportNameAfterLanguageMark = GetStringValue(excel.ExportNameAfterLanguageMark, bat.ExportNameAfterLanguageMark, bPubilc.ExportNameAfterLanguageMark);
//ExportContent =
IsExportNullNumber = GetBoolValue(tableInfo, excel.IsExportNullNumberParam, excel.IsExportNullNumber, bat.IsExportNullNumber, bPubilc.IsExportNullNumber);
IsExportNullString = GetBoolValue(tableInfo, excel.IsExportNullStringParam, excel.IsExportNullString, bat.IsExportNullString, bPubilc.IsExportNullString);
IsExportNullJson = GetBoolValue(tableInfo, excel.IsExportNullJsonParam, excel.IsExportNullJson, bat.IsExportNullJson, bPubilc.IsExportNullJson);
IsExportNullArray = GetBoolValue(tableInfo, excel.IsExportNullArrayParam, excel.IsExportNullArray, bat.IsExportNullArray, bPubilc.IsExportNullArray);
IsExportNullDict = GetBoolValue(tableInfo, excel.IsExportNullDictParam, excel.IsExportNullDict, bat.IsExportNullDict, bPubilc.IsExportNullDict);
IsExportNullBool = GetBoolValue(tableInfo, excel.IsExportNullBoolParam, excel.IsExportNullBool, bat.IsExportNullBool, bPubilc.IsExportNullBool);
IsExportNullDate = GetBoolValue(tableInfo, excel.IsExportNullDateParam, excel.IsExportNullDate, bat.IsExportNullDate, bPubilc.IsExportNullDate);
IsExportNullTime = GetBoolValue(tableInfo, excel.IsExportNullTimeParam, excel.IsExportNullTime, bat.IsExportNullTime, bPubilc.IsExportNullTime);
IsExportNullLang = GetBoolValue(tableInfo, excel.IsExportNullLangParam, excel.IsExportNullLang, bat.IsExportNullLang, bPubilc.IsExportNullLang);
IsExportFormat = GetBoolValue(tableInfo, excel.IsExportFormatParam, excel.IsExportFormat, bat.IsExportFormat, bPubilc.IsExportFormat);
IsExportFieldComment = GetBoolValue(tableInfo, excel.IsExportFieldCommentParam, excel.IsExportFieldComment, bat.IsExportFieldComment, bPubilc.IsExportFieldComment);
ExportTopWords = GetStringValue(excel.ExportTopWords, bat.ExportTopWords, bPubilc.ExportTopWords);
ExportIndentationString = GetStringValue(excel.ExportIndentationString, bat.ExportIndentationString, bPubilc.ExportIndentationString);
ExportSpaceString = GetStringValue(excel.ExportSpaceString, bat.ExportSpaceString, bPubilc.ExportSpaceString);
ExportLineString = GetStringValue(excel.ExportLineString, bat.ExportLineString, bPubilc.ExportLineString);
IsExportJsonArrayFormat = GetBoolValue(tableInfo, excel.IsExportJsonArrayFormatParam, excel.IsExportJsonArrayFormat, bat.IsExportJsonArrayFormat, bPubilc.IsExportJsonArrayFormat);
IsExportJsonMapIncludeKeyColumnValue = GetBoolValue(tableInfo, excel.IsExportJsonMapIncludeKeyColumnValueParam, excel.IsExportJsonMapIncludeKeyColumnValue, bat.IsExportJsonMapIncludeKeyColumnValue, bPubilc.IsExportJsonMapIncludeKeyColumnValue);
IsArrayFieldName = GetBoolValue(tableInfo, excel.IsArrayFieldNameParam, excel.IsArrayFieldName, bat.IsArrayFieldName, bPubilc.IsArrayFieldName);
IsTableNameStart = GetBoolValue(tableInfo, excel.IsTableNameStartParam, excel.IsTableNameStart, bat.IsTableNameStart, bPubilc.IsTableNameStart);
IsAddKeyToLuaTable = GetBoolValue(tableInfo, excel.IsAddKeyToLuaTableParam, excel.IsAddKeyToLuaTable, bat.IsAddKeyToLuaTable, bPubilc.IsAddKeyToLuaTable);
DateToExportFormat = GetStringValue(excel.DateToExportFormat, bat.DateToExportFormat, bPubilc.DateToExportFormat);
TimeToExportFormat = GetStringValue(excel.TimeToExportFormat, bat.TimeToExportFormat, bPubilc.TimeToExportFormat);
SpecialExport = GetStringValue(excel.SpecialExport, bat.SpecialExport, bPubilc.SpecialExport);
}
public static void ExportToMySQL()
{
string ExportType = "MySQL";
if (AppValues.ConfigData.ContainsKey("AllExport" + ExportType))
{
if (string.Equals("false", AppValues.ConfigData["AllExport" + ExportType].Trim().ToLower()))
{
return;
}
}
else
{
return;
}
string errorString = null;
BatExportPublicSetting batExportPublicSetting = new BatExportPublicSetting();
batExportPublicSetting.IsExport = false;
batExportPublicSetting.ExcelNameSplitString = "-";
batExportPublicSetting.ExportNameAfterLanguageMark = "";
batExportPublicSetting.GetParamValue();
BatExportSetting batExportSetting = new BatExportSetting();
batExportSetting.ExportTypeParam = "ExportMySQL";
batExportSetting.ExportPath = "";
batExportSetting.IsExport = false;
batExportSetting.IsExportKeepDirectoryStructure = false;
batExportSetting.ExportExtension = "";
batExportSetting.ExportNameBeforeAdd = "";
batExportSetting.IsExportNullNumber = false;
batExportSetting.IsExportNullString = false;//用于配置将表格导出到 MySQL 数据库时string 型字段中的空白单元格导出为数据库中的 NULL 而不是空字符串
batExportSetting.IsExportNullJson = false;
batExportSetting.IsExportNullArray = false;
batExportSetting.IsExportNullDict = false;
batExportSetting.IsExportNullBool = false;
batExportSetting.IsExportNullDate = false;
batExportSetting.IsExportNullTime = false;
batExportSetting.IsExportNullLang = false;
batExportSetting.IsExportFormat = false;
batExportSetting.IsExportFieldComment = false;
batExportSetting.ExportTopWords = "";
batExportSetting.ExportIndentationString = "";
batExportSetting.ExportSpaceString = "";
batExportSetting.IsExportJsonArrayFormat = false;
batExportSetting.IsExportJsonMapIncludeKeyColumnValue = false;
batExportSetting.IsArrayFieldName = false;
batExportSetting.IsTableNameStart = false;
batExportSetting.IsAddKeyToLuaTable = false;
batExportSetting.GetParamValue();
ConnectToDatabase(out errorString);
if (!string.IsNullOrEmpty(errorString))
{
AppLog.LogErrorAndExit(string.Format("无法连接至{0}数据库：{1}\n导出至{2}数据库被迫中止，请修正错误后重试\n", ExportType, errorString, ExportType));
}
foreach (KeyValuePair <string, TableInfo> kvp in AppValues.TableInfo)
{
TableInfo tableInfo = kvp.Value;
errorString = null;
ExcelConfigSetting excelConfigSetting = new ExcelConfigSetting();
excelConfigSetting.IsExportParam = "Export" + ExportType;
excelConfigSetting.ExportPathParam = ExportType + "ExportPath";
excelConfigSetting.IsExportKeepDirectoryStructureParam = ExportType + "IsExportKeepDirectoryStructure";
excelConfigSetting.ExportNameParam = ExportType + "ExportName";//用于配置当需要将表格导出到 MySQL 数据库时的表名
excelConfigSetting.ExcelNameSplitStringParam = ExportType + "ExcelNameSplitString";
excelConfigSetting.ExportExtensionParam = ExportType + "ExportExtension";
excelConfigSetting.ExportNameBeforeAddParam = ExportType + "ExportNameBeforeAdd";
excelConfigSetting.ExportNameAfterLanguageMarkParam = ExportType + "ExportNameAfterLanguageMark";
excelConfigSetting.IsExportNullNumberParam = ExportType + "IsExportNullNumber";
excelConfigSetting.IsExportNullStringParam = ExportType + "IsExportNullString";
excelConfigSetting.IsExportNullJsonParam = ExportType + "IsExportNullJson";
excelConfigSetting.IsExportNullArrayParam = ExportType + "IsExportNullArray";
excelConfigSetting.IsExportNullDictParam = ExportType + "IsExportNullDict";
excelConfigSetting.IsExportNullBoolParam = ExportType + "IsExportNullBool";
excelConfigSetting.IsExportNullDateParam = ExportType + "IsExportNullDate";
excelConfigSetting.IsExportNullTimeParam = ExportType + "IsExportNullTime";
excelConfigSetting.IsExportNullLangParam = ExportType + "IsExportNullLang";
excelConfigSetting.IsExportFormatParam = ExportType + "IsExportFormat";
excelConfigSetting.IsExportFieldCommentParam = ExportType + "ExportFieldComment";
excelConfigSetting.ExportTopWordsParam = ExportType + "ExportTopWords";//exportMySQLTableComment中声明某张表格导出到数据库中的说明信息
excelConfigSetting.ExportIndentationStringParam = ExportType + "ExportIndentationString";
excelConfigSetting.ExportSpaceStringParam = ExportType + "ExportSpaceString";
excelConfigSetting.IsExportJsonArrayFormatParam = ExportType + "IsExportJsonArrayFormat";
excelConfigSetting.IsExportJsonMapIncludeKeyColumnValueParam = ExportType + "IsExportJsonMapIncludeKeyColumnValue";
excelConfigSetting.IsArrayFieldNameParam = ExportType + "IsArrayFieldName";
excelConfigSetting.IsTableNameStartParam = ExportType + "IsTableNameStart";
excelConfigSetting.IsAddKeyToLuaTableParam = ExportType + "IsAddKeyToLuaTable";
excelConfigSetting.DateToExportFormatParam = ExportType + "DateToExportFormat";//日期导出的格式
excelConfigSetting.TimeToExportFormatParam = ExportType + "TimeToExportFormat";
excelConfigSetting.SpecialExportParam = "SpecialExport" + ExportType;
if (AppValues.ConfigData.ContainsKey("Export" + ExportType))
{
excelConfigSetting.IsExportParam = AppValues.ConfigData["Export" + ExportType].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportPath"))
{
excelConfigSetting.ExportPathParam = AppValues.ConfigData[ExportType + "ExportPath"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportKeepDirectoryStructure"))
{
excelConfigSetting.IsExportKeepDirectoryStructureParam = AppValues.ConfigData[ExportType + "IsExportKeepDirectoryStructure"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportName"))
{
excelConfigSetting.ExportNameParam = AppValues.ConfigData[ExportType + "ExportName"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExcelNameSplitString"))
{
excelConfigSetting.ExcelNameSplitStringParam = AppValues.ConfigData[ExportType + "ExcelNameSplitString"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportExtension"))
{
excelConfigSetting.ExportExtensionParam = AppValues.ConfigData[ExportType + "ExportExtension"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportNameBeforeAdd"))
{
excelConfigSetting.ExportNameBeforeAddParam = AppValues.ConfigData[ExportType + "ExportNameBeforeAdd"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportNameAfterLanguageMark"))
{
excelConfigSetting.ExportNameAfterLanguageMarkParam = AppValues.ConfigData[ExportType + "ExportNameAfterLanguageMark"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullNumber"))
{
excelConfigSetting.IsExportNullNumberParam = AppValues.ConfigData[ExportType + "IsExportNullNumber"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullString"))
{
excelConfigSetting.IsExportNullStringParam = AppValues.ConfigData[ExportType + "IsExportNullString"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullJson"))
{
excelConfigSetting.IsExportNullJsonParam = AppValues.ConfigData[ExportType + "IsExportNullJson"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullArray"))
{
excelConfigSetting.IsExportNullArrayParam = AppValues.ConfigData[ExportType + "IsExportNullArray"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullDict"))
{
excelConfigSetting.IsExportNullDictParam = AppValues.ConfigData[ExportType + "IsExportNullDict"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullBool"))
{
excelConfigSetting.IsExportNullBoolParam = AppValues.ConfigData[ExportType + "IsExportNullBool"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullDate"))
{
excelConfigSetting.IsExportNullDateParam = AppValues.ConfigData[ExportType + "IsExportNullDate"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullTime"))
{
excelConfigSetting.IsExportNullTimeParam = AppValues.ConfigData[ExportType + "IsExportNullTime"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullLang"))
{
excelConfigSetting.IsExportNullLangParam = AppValues.ConfigData[ExportType + "IsExportNullLang"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportFormat"))
{
excelConfigSetting.IsExportFormatParam = AppValues.ConfigData[ExportType + "IsExportFormat"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportFieldComment"))
{
excelConfigSetting.IsExportFieldCommentParam = AppValues.ConfigData[ExportType + "ExportFieldComment"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportTopWords"))
{
excelConfigSetting.ExportTopWordsParam = AppValues.ConfigData[ExportType + "ExportTopWords"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportIndentationString"))
{
excelConfigSetting.ExportIndentationStringParam = AppValues.ConfigData[ExportType + "ExportIndentationString"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportSpaceString"))
{
excelConfigSetting.ExportSpaceStringParam = AppValues.ConfigData[ExportType + "ExportSpaceString"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportLineString"))
{
excelConfigSetting.ExportLineStringParam = AppValues.ConfigData[ExportType + "ExportLineString"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportJsonArrayFormat"))
{
excelConfigSetting.IsExportJsonArrayFormatParam = AppValues.ConfigData[ExportType + "IsExportJsonArrayFormat"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportJsonMapIncludeKeyColumnValue"))
{
excelConfigSetting.IsExportJsonMapIncludeKeyColumnValueParam = AppValues.ConfigData[ExportType + "IsExportJsonMapIncludeKeyColumnValue"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsArrayFieldName"))
{
excelConfigSetting.IsArrayFieldNameParam = AppValues.ConfigData[ExportType + "IsArrayFieldName"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsTableNameStart"))
{
excelConfigSetting.IsTableNameStartParam = AppValues.ConfigData[ExportType + "IsTableNameStart"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsAddKeyToLuaTable"))
{
excelConfigSetting.IsAddKeyToLuaTableParam = AppValues.ConfigData[ExportType + "IsAddKeyToLuaTable"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "DateToExportFormat"))
{
excelConfigSetting.DateToExportFormatParam = AppValues.ConfigData[ExportType + "DateToExportFormat"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "TimeToExportFormat"))
{
excelConfigSetting.TimeToExportFormatParam = AppValues.ConfigData[ExportType + "TimeToExportFormat"].Trim();
}
excelConfigSetting.GetParamValue(tableInfo);
Export export = new Export();
export.GetValue(tableInfo, excelConfigSetting, batExportSetting, batExportPublicSetting);
// export.GetExportName(excelConfigSetting.ExportName, tableInfo.ExcelName, export.ExcelNameSplitString);
string m = "";
if (AppValues.MergeTableList != null && AppValues.MergeTableList.ContainsKey(kvp.Key) && batExportSetting.IsExport == true)
{
export.IsExport = true;
export.ExportName = kvp.Key;
m = "[合并]";
}
if (export.IsExport == true)
{
AppLog.Log(string.Format("\n开始{0}导入{1}：数据库", m, ExportType), ConsoleColor.Green, false);
AppLog.Log(string.Format("{0}并命名为{1}", tableInfo.ExcelNameTips, export.ExportName), ConsoleColor.Green);
ExportTableToDatabase(tableInfo, export, out errorString);
if (!string.IsNullOrEmpty(errorString))
{
AppLog.LogErrorAndExit(string.Format("导出失败：{0}\n导出至{1}数据库被迫中止，请修正错误后重试\n", errorString, ExportType));
}
}
}
}
public static void ExportToTxt()
{
string ExportType = "Txt";
if (AppValues.ConfigData.ContainsKey("AllExport" + ExportType))
{
if (string.Equals("false", AppValues.ConfigData["AllExport" + ExportType].Trim().ToLower()))
{
return;
}
}
else
{
return;
}
string errorString = null;
BatExportPublicSetting batExportPublicSetting = new BatExportPublicSetting();
batExportPublicSetting.IsExport = true;
batExportPublicSetting.ExcelNameSplitString = "-";
batExportPublicSetting.ExportNameAfterLanguageMark = "";
BatExportSetting batExportSetting = new BatExportSetting();
batExportSetting.ExportTypeParam = "ExportTxt";
batExportSetting.ExportPath = ExcelFolder.ExcelPath;// FileModule.CombinePath(AppDomain.CurrentDomain.SetupInformation.ApplicationBase, "ExportTxt");
batExportSetting.IsExport = true;
batExportSetting.IsExportKeepDirectoryStructure = true;
batExportSetting.ExportExtension = "txt";
batExportSetting.ExportNameBeforeAdd = "";
batExportPublicSetting.ExportNameAfterLanguageMark = "-data";
batExportSetting.IsExportNullNumber = true;
batExportSetting.IsExportNullString = true;
batExportSetting.IsExportNullJson = false;
batExportSetting.IsExportNullArray = true;
batExportSetting.IsExportNullDict = true;
batExportSetting.IsExportNullBool = false;
batExportSetting.IsExportNullDate = false;
batExportSetting.IsExportNullTime = false;
batExportSetting.IsExportNullLang = false;
batExportSetting.IsExportFormat = true;
batExportSetting.IsExportFieldComment = false;
batExportSetting.ExportTopWords = "";
batExportSetting.ExportIndentationString = ""; //缩进符
batExportSetting.ExportSpaceString = "\t"; //间隔符
batExportSetting.ExportLineString = "\n"; //换行符
batExportSetting.IsExportJsonArrayFormat = false;
batExportSetting.IsExportJsonMapIncludeKeyColumnValue = false;
batExportSetting.IsArrayFieldName = false;
batExportSetting.IsTableNameStart = false;
batExportSetting.IsAddKeyToLuaTable = false;
batExportSetting.GetParamValue();
foreach (KeyValuePair <string, TableInfo> kvp in AppValues.TableInfo)
{
TableInfo tableInfo = kvp.Value;
errorString = null;
ExcelConfigSetting excelConfigSetting = new ExcelConfigSetting();
excelConfigSetting.IsExportParam = "Export" + ExportType;// ExportType + "IsExport";
excelConfigSetting.ExportPathParam = ExportType + "ExportPath";
excelConfigSetting.IsExportKeepDirectoryStructureParam = ExportType + "ExportPath";
excelConfigSetting.ExportNameParam = ExportType + "ExportName";
excelConfigSetting.ExcelNameSplitStringParam = ExportType + "ExcelNameSplitString";
excelConfigSetting.ExportExtensionParam = ExportType + "ExportExtension";
excelConfigSetting.ExportNameBeforeAddParam = ExportType + "ExportNameBeforeAdd";
excelConfigSetting.ExportNameAfterLanguageMarkParam = ExportType + "ExportNameAfterLanguageMark";
excelConfigSetting.IsExportNullNumberParam = ExportType + "IsExportNullNumber";
excelConfigSetting.IsExportNullStringParam = ExportType + "IsExportNullString";
excelConfigSetting.IsExportNullJsonParam = ExportType + "IsExportNullJson";
excelConfigSetting.IsExportNullArrayParam = ExportType + "IsExportNullArray";
excelConfigSetting.IsExportNullDictParam = ExportType + "IsExportNullDict";
excelConfigSetting.IsExportNullBoolParam = ExportType + "IsExportNullBool";
excelConfigSetting.IsExportNullDateParam = ExportType + "IsExportNullDate";
excelConfigSetting.IsExportNullTimeParam = ExportType + "IsExportNullTime";
excelConfigSetting.IsExportNullLangParam = ExportType + "IsExportNullLang";
excelConfigSetting.IsExportFormatParam = ExportType + "IsExportFormat";
excelConfigSetting.IsExportFieldCommentParam = ExportType + "ExportFieldComment";
excelConfigSetting.ExportTopWordsParam = ExportType + "ExportTopWords";
excelConfigSetting.ExportIndentationStringParam = ExportType + "ExportIndentationString";
excelConfigSetting.ExportSpaceStringParam = ExportType + "ExportSpaceString";
excelConfigSetting.IsExportJsonArrayFormatParam = ExportType + "IsExportJsonArrayFormat";
excelConfigSetting.IsExportJsonMapIncludeKeyColumnValueParam = ExportType + "IsExportJsonMapIncludeKeyColumnValue";
excelConfigSetting.IsArrayFieldNameParam = ExportType + "IsArrayFieldName";
excelConfigSetting.IsTableNameStartParam = ExportType + "IsTableNameStart";
excelConfigSetting.IsAddKeyToLuaTableParam = ExportType + "IsAddKeyToLuaTable";
excelConfigSetting.DateToExportFormatParam = ExportType + "DateToExportFormat";
excelConfigSetting.TimeToExportFormatParam = ExportType + "TimeToExportFormat";
if (AppValues.ConfigData.ContainsKey("Export" + ExportType))
{
excelConfigSetting.IsExportParam = AppValues.ConfigData["Export" + ExportType].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportPath"))
{
excelConfigSetting.ExportPathParam = AppValues.ConfigData[ExportType + "ExportPath"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportKeepDirectoryStructure"))
{
excelConfigSetting.IsExportKeepDirectoryStructureParam = AppValues.ConfigData[ExportType + "IsExportKeepDirectoryStructure"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportName"))
{
excelConfigSetting.ExportNameParam = AppValues.ConfigData[ExportType + "ExportName"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExcelNameSplitString"))
{
excelConfigSetting.ExcelNameSplitStringParam = AppValues.ConfigData[ExportType + "ExcelNameSplitString"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportExtension"))
{
excelConfigSetting.ExportExtensionParam = AppValues.ConfigData[ExportType + "ExportExtension"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportNameBeforeAdd"))
{
excelConfigSetting.ExportNameBeforeAddParam = AppValues.ConfigData[ExportType + "ExportNameBeforeAdd"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportNameAfterLanguageMark"))
{
excelConfigSetting.ExportNameAfterLanguageMarkParam = AppValues.ConfigData[ExportType + "ExportNameAfterLanguageMark"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullNumber"))
{
excelConfigSetting.IsExportNullNumberParam = AppValues.ConfigData[ExportType + "IsExportNullNumber"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullString"))
{
excelConfigSetting.IsExportNullStringParam = AppValues.ConfigData[ExportType + "IsExportNullString"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullJson"))
{
excelConfigSetting.IsExportNullJsonParam = AppValues.ConfigData[ExportType + "IsExportNullJson"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullArray"))
{
excelConfigSetting.IsExportNullArrayParam = AppValues.ConfigData[ExportType + "IsExportNullArray"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullDict"))
{
excelConfigSetting.IsExportNullDictParam = AppValues.ConfigData[ExportType + "IsExportNullDict"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullBool"))
{
excelConfigSetting.IsExportNullBoolParam = AppValues.ConfigData[ExportType + "IsExportNullBool"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullDate"))
{
excelConfigSetting.IsExportNullDateParam = AppValues.ConfigData[ExportType + "IsExportNullDate"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullTime"))
{
excelConfigSetting.IsExportNullTimeParam = AppValues.ConfigData[ExportType + "IsExportNullTime"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportNullLang"))
{
excelConfigSetting.IsExportNullLangParam = AppValues.ConfigData[ExportType + "IsExportNullLang"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportFormat"))
{
excelConfigSetting.IsExportFormatParam = AppValues.ConfigData[ExportType + "IsExportFormat"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportFieldComment"))
{
excelConfigSetting.IsExportFieldCommentParam = AppValues.ConfigData[ExportType + "ExportFieldComment"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportTopWords"))
{
excelConfigSetting.ExportTopWordsParam = AppValues.ConfigData[ExportType + "ExportTopWords"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportIndentationString"))
{
excelConfigSetting.ExportIndentationStringParam = AppValues.ConfigData[ExportType + "ExportIndentationString"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportSpaceString"))
{
excelConfigSetting.ExportSpaceStringParam = AppValues.ConfigData[ExportType + "ExportSpaceString"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "ExportLineString"))
{
excelConfigSetting.ExportLineStringParam = AppValues.ConfigData[ExportType + "ExportLineString"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportJsonArrayFormat"))
{
excelConfigSetting.IsExportJsonArrayFormatParam = AppValues.ConfigData[ExportType + "IsExportJsonArrayFormat"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsExportJsonMapIncludeKeyColumnValue"))
{
excelConfigSetting.IsExportJsonMapIncludeKeyColumnValueParam = AppValues.ConfigData[ExportType + "IsExportJsonMapIncludeKeyColumnValue"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsArrayFieldName"))
{
excelConfigSetting.IsArrayFieldNameParam = AppValues.ConfigData[ExportType + "IsArrayFieldName"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsTableNameStart"))
{
excelConfigSetting.IsTableNameStartParam = AppValues.ConfigData[ExportType + "IsTableNameStart"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "IsAddKeyToLuaTable"))
{
excelConfigSetting.IsAddKeyToLuaTableParam = AppValues.ConfigData[ExportType + "IsAddKeyToLuaTable"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "DateToExportFormat"))
{
excelConfigSetting.DateToExportFormatParam = AppValues.ConfigData[ExportType + "DateToExportFormat"].Trim();
}
if (AppValues.ConfigData.ContainsKey(ExportType + "TimeToExportFormat"))
{
excelConfigSetting.TimeToExportFormatParam = AppValues.ConfigData[ExportType + "TimeToExportFormat"].Trim();
}
if (AppValues.ConfigData.ContainsKey("SpecialExport" + ExportType))
{
excelConfigSetting.TimeToExportFormatParam = AppValues.ConfigData["SpecialExport" + ExportType].Trim();
}
excelConfigSetting.GetParamValue(tableInfo);
Export export = new Export();
export.GetValue(tableInfo, excelConfigSetting, batExportSetting, batExportPublicSetting);
if (export.IsExport == false)
{
continue;
}
if (AppValues.MergeTableList != null && AppValues.MergeTableList.ContainsKey(tableInfo.TableName))
{
AppLog.Log(string.Format("\n开始导出{0}：", ExportType), ConsoleColor.Green, false);
AppLog.Log(string.Format("{0}", tableInfo.TableName), ConsoleColor.Green);
ExportOneMergeTable(tableInfo, export, out errorString);
if (errorString != null)
{
AppLog.LogErrorAndExit(errorString);
}
}
else
{
AppLog.Log(string.Format("\n开始导出{0}：", ExportType), ConsoleColor.Green, false);
AppLog.Log(string.Format("{0}", tableInfo.ExcelNameTips), ConsoleColor.Green);
ExportOneTable(tableInfo, export, out errorString);
if (errorString != null)
{
AppLog.LogErrorAndExit(errorString);
}
}
}
}
