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); } } } }