public static bool ExportTableToLua(TableInfo tableInfo, out string errorString)
{
StringBuilder content = new StringBuilder();
// 生成数据内容开头
if (LuaStruct.IsTableNameStart)
{
content.Append(tableInfo.TableName).AppendLine(" = {");
}
else
{
content.AppendLine("return {");
}
// 当前缩进量
int currentLevel = 1;
// 判断是否设置要将主键列的值作为导出的table中的元素
bool isAddKeyToLuaTable = tableInfo.TableConfigData2 != null && tableInfo.TableConfigData2.ContainsKey(LuaStruct.Excel_Config_AddKeyToLuaTable) && tableInfo.TableConfigData2[LuaStruct.Excel_Config_AddKeyToLuaTable].Count > 0 && "true".Equals(tableInfo.TableConfigData2[LuaStruct.Excel_Config_AddKeyToLuaTable][0], StringComparison.CurrentCultureIgnoreCase);
// 逐行读取表格内容生成lua table
List <FieldInfo> allField = tableInfo.GetAllClientFieldInfo();
int dataCount = tableInfo.GetKeyColumnFieldInfo().Data.Count;
for (int row = 0; row < dataCount; ++row)
{
// 将主键列作为key生成
content.Append(_GetLuaIndentation(currentLevel));
FieldInfo keyColumnField = allField[0];
if (keyColumnField.DataType == DataType.Int || keyColumnField.DataType == DataType.Long)
{
content.AppendFormat("[{0}]", keyColumnField.Data[row]);
}
// 注意：像“1_2”这样的字符串作为table的key必须加[""]否则lua认为是语法错误
else if (keyColumnField.DataType == DataType.String)
{
content.AppendFormat("[\"{0}\"]", keyColumnField.Data[row]);
}
else
{
errorString = "用ExportTableToLua导出不支持的主键列数据类型";
AppLog.LogErrorAndExit(errorString);
return(false);
}
content.AppendLine(" = {");
++currentLevel;
// 如果设置了要将主键列的值作为导出的table中的元素
if (isAddKeyToLuaTable == true)
{
content.Append(_GetLuaIndentation(currentLevel));
content.Append(keyColumnField.FieldName);
content.Append(" = ");
if (keyColumnField.DataType == DataType.Int || keyColumnField.DataType == DataType.Long)
{
content.Append(keyColumnField.Data[row]);
}
else if (keyColumnField.DataType == DataType.String)
{
content.AppendFormat("\"{0}\"", keyColumnField.Data[row]);
}
content.AppendLine(",");
}
// 将其他列依次作为value生成
for (int column = 1; column < allField.Count; ++column)
{
string oneFieldString = _GetOneField(allField[column], row, currentLevel, out errorString);
if (errorString != null)
{
errorString = string.Format("导出表格{0}失败，", tableInfo.TableName) + errorString;
return(false);
}
else
{
content.Append(oneFieldString);
}
}
// 一行数据生成完毕后添加右括号结尾等
--currentLevel;
content.Append(_GetLuaIndentation(currentLevel));
content.AppendLine("},");
}
// 生成数据内容结尾
content.AppendLine("}");
if (LuaStruct.IsTableNameStart)
{
content.Append("return ").Append(tableInfo.TableName);
}
string exportString = content.ToString();
if (LuaStruct.ExportLuaIsFormat == false)
{
StringBuilder stringBuilder2 = new StringBuilder();
for (int i = 0; i < exportString.Length; ++i)
{
char c = exportString[i];
if (c == '\n' || c == '\r' || c.ToString() == " ")
{
}
else
{
stringBuilder2.Append(c);
}
}
exportString = stringBuilder2.ToString();
}
if (LuaStruct.IsNeedColumnInfo == true)
{
exportString = _GetColumnInfo(tableInfo) + exportString;
}
// 保存为lua文件
if (SaveLua.SaveLuaFile(tableInfo.ExcelName, ExcelMethods.GetSaveTableName(tableInfo.TableName), exportString) == true)
{
errorString = null;
return(true);
}
else
{
errorString = "保存为lua文件失败\n";
return(false);
}
}
/// <summary>
/// 按配置的特殊索引导出方式输出lua文件（如果声明了在生成的lua文件开头以注释形式展示列信息，将生成更直观的嵌套字段信息，而不同于普通导出规则的列信息展示）
/// </summary>
public static bool SpecialExportTableToLua(TableInfo tableInfo, string exportRule, out string errorString)
{
exportRule = exportRule.Trim();
// 解析按这种方式导出后的lua文件名
int colonIndex = exportRule.IndexOf(':');
if (colonIndex == -1)
{
errorString = string.Format("导出配置\"{0}\"定义错误，必须在开头声明导出lua文件名\n", exportRule);
return(false);
}
string fileName = exportRule.Substring(0, colonIndex).Trim();
// 判断是否在最后的花括号内声明table value中包含的字段
int leftBraceIndex = exportRule.LastIndexOf('{');
int rightBraceIndex = exportRule.LastIndexOf('}');
// 解析依次作为索引的字段名
string indexFieldNameString = null;
// 注意分析花括号时要考虑到未声明table value中的字段而在某索引字段完整性检查规则中用花括号声明了有效值的情况
if (exportRule.EndsWith("}") && leftBraceIndex != -1)
{
indexFieldNameString = exportRule.Substring(colonIndex + 1, leftBraceIndex - colonIndex - 1);
}
else
{
indexFieldNameString = exportRule.Substring(colonIndex + 1, exportRule.Length - colonIndex - 1);
}
string[] indexFieldDefine = indexFieldNameString.Split(new char[] { '-' }, System.StringSplitOptions.RemoveEmptyEntries);
// 用于索引的字段列表
List <FieldInfo> indexField = new List <FieldInfo>();
// 索引字段对应的完整性检查规则
List <string> integrityCheckRules = new List <string>();
if (indexFieldDefine.Length < 1)
{
errorString = string.Format("导出配置\"{0}\"定义错误，用于索引的字段不能为空，请按fileName:indexFieldName1-indexFieldName2{otherFieldName1,otherFieldName2}的格式配置\n", exportRule);
return(false);
}
// 检查字段是否存在且为int、float、string或lang型
foreach (string fieldDefine in indexFieldDefine)
{
string fieldName = null;
// 判断是否在字段名后用小括号声明了该字段的完整性检查规则
int leftBracketIndex = fieldDefine.IndexOf('(');
int rightBracketIndex = fieldDefine.IndexOf(')');
if (leftBracketIndex > 0 && rightBracketIndex > leftBracketIndex)
{
fieldName = fieldDefine.Substring(0, leftBracketIndex);
string integrityCheckRule = fieldDefine.Substring(leftBracketIndex + 1, rightBracketIndex - leftBracketIndex - 1).Trim();
if (string.IsNullOrEmpty(integrityCheckRule))
{
errorString = string.Format("导出配置\"{0}\"定义错误，用于索引的字段\"{1}\"若要声明完整性检查规则就必须在括号中填写否则不要加括号\n", exportRule, fieldName);
return(false);
}
integrityCheckRules.Add(integrityCheckRule);
}
else
{
fieldName = fieldDefine.Trim();
integrityCheckRules.Add(null);
}
FieldInfo fieldInfo = tableInfo.GetFieldInfoByFieldName(fieldName);
if (fieldInfo == null)
{
errorString = string.Format("导出配置\"{0}\"定义错误，声明的索引字段\"{1}\"不存在\n", exportRule, fieldName);
return(false);
}
if (fieldInfo.DataType != DataType.Int && fieldInfo.DataType != DataType.Long && fieldInfo.DataType != DataType.Float && fieldInfo.DataType != DataType.String && fieldInfo.DataType != DataType.Lang)
{
errorString = string.Format("导出配置\"{0}\"定义错误，声明的索引字段\"{1}\"为{2}型，但只允许为int、long、float、string或lang型\n", exportRule, fieldName, fieldInfo.DataType);
return(false);
}
// 对索引字段进行非空检查
if (fieldInfo.DataType == DataType.String)
{
FieldCheckRule stringNotEmptyCheckRule = new FieldCheckRule();
stringNotEmptyCheckRule.CheckType = TableCheckType.NotEmpty;
stringNotEmptyCheckRule.CheckRuleString = "notEmpty[trim]";
TableCheckHelper.CheckNotEmpty(fieldInfo, stringNotEmptyCheckRule, out errorString);
if (errorString != null)
{
errorString = string.Format("按配置\"{0}\"进行自定义导出错误，string型索引字段\"{1}\"中存在以下空值，而作为索引的key不允许为空\n{2}\n", exportRule, fieldName, errorString);
return(false);
}
}
else if (fieldInfo.DataType == DataType.Lang)
{
FieldCheckRule langNotEmptyCheckRule = new FieldCheckRule();
langNotEmptyCheckRule.CheckType = TableCheckType.NotEmpty;
langNotEmptyCheckRule.CheckRuleString = "notEmpty[key|value]";
TableCheckHelper.CheckNotEmpty(fieldInfo, langNotEmptyCheckRule, out errorString);
if (errorString != null)
{
errorString = string.Format("按配置\"{0}\"进行自定义导出错误，lang型索引字段\"{1}\"中存在以下空值，而作为索引的key不允许为空\n{2}\n", exportRule, fieldName, errorString);
return(false);
}
}
else if (ExcelFolder.IsAllowedNullNumber == true)
{
FieldCheckRule numberNotEmptyCheckRule = new FieldCheckRule();
numberNotEmptyCheckRule.CheckType = TableCheckType.NotEmpty;
numberNotEmptyCheckRule.CheckRuleString = "notEmpty";
TableCheckHelper.CheckNotEmpty(fieldInfo, numberNotEmptyCheckRule, out errorString);
if (errorString != null)
{
errorString = string.Format("按配置\"{0}\"进行自定义导出错误，{1}型索引字段\"{2}\"中存在以下空值，而作为索引的key不允许为空\n{3}\n", exportRule, fieldInfo.DataType.ToString(), fieldName, errorString);
return(false);
}
}
indexField.Add(fieldInfo);
}
// 解析table value中要输出的字段名
List <FieldInfo> tableValueField = new List <FieldInfo>();
// 如果在花括号内配置了table value中要输出的字段名
if (exportRule.EndsWith("}") && leftBraceIndex != -1 && leftBraceIndex < rightBraceIndex)
{
string tableValueFieldName = exportRule.Substring(leftBraceIndex + 1, rightBraceIndex - leftBraceIndex - 1);
string[] fieldNames = tableValueFieldName.Split(new char[] { ',' }, System.StringSplitOptions.RemoveEmptyEntries);
if (fieldNames.Length < 1)
{
errorString = string.Format("导出配置\"{0}\"定义错误，花括号中声明的table value中的字段不能为空，请按fileName:indexFieldName1-indexFieldName2{otherFieldName1,otherFieldName2}的格式配置\n", exportRule);
return(false);
}
// 检查字段是否存在
foreach (string fieldName in fieldNames)
{
FieldInfo fieldInfo = tableInfo.GetFieldInfoByFieldName(fieldName);
if (fieldInfo == null)
{
errorString = string.Format("导出配置\"{0}\"定义错误，声明的table value中的字段\"{1}\"不存在\n", exportRule, fieldName);
return(false);
}
if (tableValueField.Contains(fieldInfo))
{
AppLog.LogWarning(string.Format("警告：导出配置\"{0}\"定义中，声明的table value中的字段存在重复，字段名为{1}（列号{2}），本工具只生成一次，请修正错误\n", exportRule, fieldName, ExcelMethods.GetExcelColumnName(fieldInfo.ColumnSeq + 1)));
}
else
{
tableValueField.Add(fieldInfo);
}
}
}
else if (exportRule.EndsWith("}") && leftBraceIndex == -1)
{
errorString = string.Format("导出配置\"{0}\"定义错误，声明的table value中花括号不匹配\n", exportRule);
return(false);
}
// 如果未在花括号内声明，则默认将索引字段之外的所有字段进行填充
else
{
List <string> indexFieldNameList = new List <string>(indexFieldDefine);
foreach (FieldInfo fieldInfo in tableInfo.GetAllClientFieldInfo())
{
if (!indexFieldNameList.Contains(fieldInfo.FieldName))
{
tableValueField.Add(fieldInfo);
}
}
}
// 解析完依次作为索引的字段以及table value中包含的字段后，按索引要求组成相应的嵌套数据结构
Dictionary <object, object> data = new Dictionary <object, object>();
int rowCount = tableInfo.GetKeyColumnFieldInfo().Data.Count;
for (int i = 0; i < rowCount; ++i)
{
Dictionary <object, object> temp = data;
// 生成除最内层的数据结构
for (int j = 0; j < indexField.Count - 1; ++j)
{
FieldInfo oneIndexField = indexField[j];
var tempData = oneIndexField.Data[i];
if (!temp.ContainsKey(tempData))
{
temp.Add(tempData, new Dictionary <object, object>());
}
temp = (Dictionary <object, object>)temp[tempData];
}
// 最内层的value存数据的int型行号（从0开始计）
FieldInfo lastIndexField = indexField[indexField.Count - 1];
var lastIndexFieldData = lastIndexField.Data[i];
if (!temp.ContainsKey(lastIndexFieldData))
{
temp.Add(lastIndexFieldData, i);
}
else
{
errorString = string.Format("错误：对表格{0}按\"{1}\"规则进行特殊索引导出时发现第{2}行与第{3}行在各个索引字段的值完全相同，导出被迫停止，请修正错误后重试\n", tableInfo.TableName, exportRule, i + ExcelTableSetting.DataFieldDataStartRowIndex + 1, temp[lastIndexFieldData]);
AppLog.LogErrorAndExit(errorString);
return(false);
}
}
// 进行数据完整性检查
if (ExcelFolder.IsNeedCheck == true)
{
TableCheckHelper.CheckTableIntegrity(indexField, data, integrityCheckRules, out errorString);
if (errorString != null)
{
errorString = string.Format("错误：对表格{0}按\"{1}\"规则进行特殊索引导时未通过数据完整性检查，导出被迫停止，请修正错误后重试：\n{2}\n", tableInfo.TableName, exportRule, errorString);
return(false);
}
}
// 生成导出的文件内容
StringBuilder content = new StringBuilder();
// 生成数据内容开头
content.AppendLine("return {");
// 当前缩进量
int currentLevel = 1;
// 逐层按嵌套结构输出数据
_GetIndexFieldData(content, data, tableValueField, ref currentLevel, out errorString);
if (errorString != null)
{
errorString = string.Format("错误：对表格{0}按\"{1}\"规则进行特殊索引导出时发现以下错误，导出被迫停止，请修正错误后重试：\n{2}\n", tableInfo.TableName, exportRule, errorString);
return(false);
}
// 生成数据内容结尾
content.AppendLine("}");
string exportString = content.ToString();
if (LuaStruct.ExportLuaIsFormat == false)
{
StringBuilder stringBuilder2 = new StringBuilder();
for (int i = 0; i < exportString.Length; ++i)
{
char c = exportString[i];
if (c == '\n' || c == '\r' || c.ToString() == " ")
{
}
else
{
stringBuilder2.Append(c);
}
}
exportString = stringBuilder2.ToString();
}
if (LuaStruct.IsNeedColumnInfo == true)
{
StringBuilder columnInfo = new StringBuilder();
// 变量名前的缩进量
int level = 0;
// 按层次结构通过缩进形式生成索引列信息
foreach (FieldInfo fieldInfo in indexField)
{
columnInfo.Append(_GetOneFieldColumnInfo(fieldInfo, level));
++level;
}
// 生成table value中包含字段的信息（首尾用花括号包裹）
columnInfo.AppendLine(string.Concat(_COMMENT_OUT_STRING, _GetFieldNameIndentation(level), "{"));
++level;
foreach (FieldInfo fieldInfo in tableValueField)
{
columnInfo.Append(_GetOneFieldColumnInfo(fieldInfo, level));
}
--level;
columnInfo.AppendLine(string.Concat(_COMMENT_OUT_STRING, _GetFieldNameIndentation(level), "}"));
exportString = string.Concat(columnInfo, System.Environment.NewLine, exportString);
}
// 保存为lua文件
if (SaveLua.SaveLuaFile(tableInfo.ExcelName, fileName, exportString) == true)
{
errorString = null;
return(true);
}
else
{
errorString = "保存为lua文件失败\n";
return(false);
}
}
