/// <summary>
/// 字段名是否重复
/// </summary>
/// <returns></returns>
internal bool FieldNameDuplicated(out string duplicatedString)
{
m_Set.Clear();
duplicatedString = null;
foreach (var h in header)
{
if (TableHelper.IgnoreHeader(h))
{
continue;
}
if (m_Set.Contains(h.fieldName))
{
duplicatedString = h.fieldName;
return(true);
}
m_Set.Add(h.fieldName);
}
return(false);
}
static async Task Load(string[] args)
{
int processorCount = System.Environment.ProcessorCount;
ThreadPool.SetMinThreads(Math.Max(4, processorCount), 5);
ThreadPool.SetMaxThreads(Math.Max(16, processorCount * 4), 10);
string clientOutDir = null, serverOutDir = null, csOutDir = null, excelDir = null;
CmdlineHelper cmder = new CmdlineHelper(args);
if (cmder.Has("--out_client"))
{
clientOutDir = cmder.Get("--out_client");
}
else
{
Console.WriteLine("out_client missing"); return;
}
////if (cmder.Has("--out_server")) { serverOutDir = cmder.Get("--out_server"); } else { return; }
if (cmder.Has("--in_excel"))
{
excelDir = cmder.Get("--in_excel");
}
else
{
Console.WriteLine("in_excel missing"); return;
}
//Console.WriteLine(clientOutDir);
//Console.WriteLine(excelDir);
//创建导出目录
if (!Directory.Exists(clientOutDir))
{
Directory.CreateDirectory(clientOutDir);
}
//if (!Directory.Exists(serverOutDir)) Directory.CreateDirectory(serverOutDir);
bool gen_client_cs = false;
if (cmder.Has("--out_cs"))
{
csOutDir = cmder.Get("--out_cs");
if (!Directory.Exists(csOutDir))
{
Directory.CreateDirectory(csOutDir);
}
gen_client_cs = true;
}
string[] files = Directory.GetFiles(excelDir, "*.xlsx", SearchOption.TopDirectoryOnly);
var tasks = new List <Task>(files.Length * 4);
var time = new Stopwatch();
time.Start();
foreach (string filepath in files)
{
var fileName = Path.GetFileName(filepath);
if (fileName.StartsWith("~"))
{
continue;
}
//Console.WriteLine($"[program] load excel {filepath}");
var excelDatas = TableHelper.LoadExcel(filepath);
tasks.Add(Task.Run(() =>
{
foreach (var excelData in excelDatas)
{
string clientPath = clientOutDir + excelData.tablName + ".txt";
//string serverPath = serverOutDir + sheets[i].SheetName + ".txt";
TableHelper.WriteByteAsset(excelData, clientPath);
if (gen_client_cs)
{
var codepath = csOutDir + "/t" + excelData.tablName + ".cs";
CodeGen.MakeCsharpFile(excelData, codepath);
}
}
}));
}
await Task.WhenAll(tasks);
Console.WriteLine();
Console.WriteLine("export success!");
time.Stop();
Console.WriteLine($"process finish: {time.ElapsedMilliseconds} ms");
}
/// <summary> /// key的个数 /// </summary> /// <returns></returns> internal int GetKeyCount() => header.Count(h => TableHelper.IsKey(h));
internal static void MakeCsharpFile(ExcelData excelData, string codepath)
{
//const string k_CsFileName = "CsvData.cs";
//string csfile = codepath + k_CsFileName;
var csfile = codepath;
var sb = new StringBuilder(2048);
var unit = new CodeCompileUnit();
var tableNamespace = new CodeNamespace("Saro.Table");
unit.Namespaces.Add(tableNamespace);
tableNamespace.Imports.Add(new CodeNamespaceImport("System.Collections"));
tableNamespace.Imports.Add(new CodeNamespaceImport("System.Collections.Generic"));
tableNamespace.Imports.Add(new CodeNamespaceImport("System.IO"));
tableNamespace.Imports.Add(new CodeNamespaceImport("System.Text"));
var enumDefineList = new List <int>();
#region item class
var itemClass = new CodeTypeDeclaration(excelData.GetEntityClassName());
itemClass.TypeAttributes = System.Reflection.TypeAttributes.Public | System.Reflection.TypeAttributes.Sealed;
tableNamespace.Types.Add(itemClass);
int index = -1;
enumDefineList.Clear();
foreach (var header in excelData.header)
{
index++;
if (header.define == TableHelper.HeaderFilter.k_ENUM_KEY)
{
enumDefineList.Add(index);
}
if (TableHelper.IgnoreHeader(header))
{
continue;
}
if (!TableHelper.s_TypeLut.TryGetValue(header.fieldTypeName, out Type t))
{
throw new Exception("type is not support: " + header.fieldTypeName);
}
var memberFiled = new CodeMemberField(t, header.fieldName);
memberFiled.Attributes = MemberAttributes.Public;
memberFiled.Comments.Add(new CodeCommentStatement("<summary>", true));
memberFiled.Comments.Add(new CodeCommentStatement(header.fieldComment, true));
memberFiled.Comments.Add(new CodeCommentStatement("</summary>", true));
itemClass.Members.Add(memberFiled);
}
#endregion
#region table class
var tableClass = new CodeTypeDeclaration(excelData.GetWrapperClassName());
tableClass.TypeAttributes = System.Reflection.TypeAttributes.Public | System.Reflection.TypeAttributes.Sealed;
tableClass.BaseTypes.Add(new CodeTypeReference("BaseTable", new CodeTypeReference[] { new CodeTypeReference(excelData.GetEntityClassName()), new CodeTypeReference(excelData.GetWrapperClassName()) }));
tableNamespace.Types.Add(tableClass);
#region load method
{
var loadMethod = new CodeMemberMethod();
tableClass.Members.Add(loadMethod);
loadMethod.Name = "Load";
loadMethod.ReturnType = new CodeTypeReference(typeof(bool));
loadMethod.Attributes = MemberAttributes.Override | MemberAttributes.Public;
sb.AppendLine("\t\t\tif (m_Loaded) return true;");
sb.AppendLine($"\t\t\tvar bytes = GetBytes(\"{excelData.tablName}.txt\");");
sb.AppendLine();
sb.AppendLine("\t\t\tusing (var ms = new MemoryStream(bytes, false))");
sb.AppendLine("\t\t\t{");
sb.AppendLine("\t\t\t\tusing (var br = new BinaryReader(ms))");
sb.AppendLine("\t\t\t\t{");
sb.AppendLine("\t\t\t\t\tvar version = br.ReadInt32();//version");
sb.AppendLine("\t\t\t\t\tif (version != TableLoader.k_DataVersion)\n\t\t\t\t\t\tthrow new System.Exception($\"table error version. file:{version} exe:{TableLoader.k_DataVersion}\");\n");
sb.AppendLine("\t\t\t\t\tvar dataLen = br.ReadInt32();");
sb.AppendLine("\t\t\t\t\tfor (int i = 0; i < dataLen; i++)");
sb.AppendLine("\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\tvar data = new {excelData.GetEntityClassName()}();");
bool first = true;
foreach (var header in excelData.header)
{
if (TableHelper.IgnoreHeader(header))
{
continue;
}
if (!TableHelper.s_TypeLut.TryGetValue(header.fieldTypeName, out Type t))
{
throw new Exception("type is not support: " + header.fieldTypeName);
}
if (t == typeof(byte))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadByte();");
}
else if (t == typeof(int))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadInt32();");
}
else if (t == typeof(long))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadInt64();");
}
else if (t == typeof(float))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadSingle();");
}
else if (t == typeof(bool))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadBoolean();");
}
else if (t == typeof(string))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadString();");
}
else if (t == typeof(byte[]))
{
if (first)
{
sb.AppendLine($"\t\t\t\t\t\tvar len = br.ReadByte();");
first = false;
}
else
{
sb.AppendLine($"\t\t\t\t\t\tlen = br.ReadByte();");
}
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = new byte[len];");
sb.AppendLine($"\t\t\t\t\t\tfor (int j = 0; j < len; j++)");
sb.AppendLine("\t\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\t\tdata.{header.fieldName}[j] = br.ReadByte();");
sb.AppendLine("\t\t\t\t\t\t}");
}
else if (t == typeof(int[]))
{
if (first)
{
sb.AppendLine($"\t\t\t\t\t\tvar len = br.ReadByte();");
first = false;
}
else
{
sb.AppendLine($"\t\t\t\t\t\tlen = br.ReadByte();");
}
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = new int[len];");
sb.AppendLine($"\t\t\t\t\t\tfor (int j = 0; j < len; j++)");
sb.AppendLine("\t\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\t\tdata.{header.fieldName}[j] = br.ReadInt32();");
sb.AppendLine("\t\t\t\t\t\t}");
}
else if (t == typeof(long[]))
{
if (first)
{
sb.AppendLine($"\t\t\t\t\t\tvar len = br.ReadByte();");
first = false;
}
else
{
sb.AppendLine($"\t\t\t\t\t\tlen = br.ReadByte();");
}
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = new long[len];");
sb.AppendLine("\t\t\t\t\t\tfor (int j = 0; j < len; j++)");
sb.AppendLine("\t\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\t\tdata.{header.fieldName}[j] = br.ReadInt64();");
sb.AppendLine("\t\t\t\t\t\t}");
}
else if (t == typeof(float[]))
{
if (first)
{
sb.AppendLine($"\t\t\t\t\t\tvar len = br.ReadByte();");
first = false;
}
else
{
sb.AppendLine($"\t\t\t\t\t\tlen = br.ReadByte();");
}
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = new float[len];");
sb.AppendLine("\t\t\t\t\t\tfor (int j = 0; j < len; j++)");
sb.AppendLine("\t\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\t\tdata.{header.fieldName}[j] = br.ReadSingle();");
sb.AppendLine("\t\t\t\t\t\t}");
}
else if (t == typeof(Dictionary <int, int>))
{
if (first)
{
sb.AppendLine($"\t\t\t\t\t\tvar len = br.ReadByte();");
first = false;
}
else
{
sb.AppendLine($"\t\t\t\t\t\tlen = br.ReadByte();");
}
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = new Dictionary<int, int>(len);");
sb.AppendLine("\t\t\t\t\t\tfor (int j = 0; j < len; j++)");
sb.AppendLine("\t\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\t\tvar key = br.ReadInt32();");
sb.AppendLine($"\t\t\t\t\t\t\tvar val = br.ReadInt32();");
sb.AppendLine($"\t\t\t\t\t\t\tdata.{header.fieldName}.Add(key, val);");
sb.AppendLine("\t\t\t\t\t\t}");
}
}
sb.AppendLine("\t\t\t\t\t\tvar _key = br.ReadUInt64();");
sb.AppendLine("\t\t\t\t\t\tm_Datas[_key] = data;");
sb.AppendLine("\t\t\t\t\t}");
sb.AppendLine("\t\t\t\t}");
sb.AppendLine("\t\t\t}");
sb.AppendLine("\t\t\tm_Loaded = true;");
loadMethod.Statements.Add(new CodeSnippetStatement(sb.ToString()));
loadMethod.Statements.Add(new CodeMethodReturnStatement(
new CodeSnippetExpression("true")));
sb.Clear();
}
#endregion
#region loadasync method
{
var loadAsyncMethod = new CodeMemberMethod();
tableClass.Members.Add(loadAsyncMethod);
loadAsyncMethod.Name = "LoadAsync";
loadAsyncMethod.ReturnType = new CodeTypeReference("async System.Threading.Tasks.ValueTask<bool>");
loadAsyncMethod.Attributes = MemberAttributes.Override | MemberAttributes.Public;
sb.AppendLine("\t\t\tif (m_Loaded) return true;");
sb.AppendLine($"\t\t\tvar bytes = await GetBytesAsync(\"{excelData.tablName}.txt\");");
sb.AppendLine();
sb.AppendLine("\t\t\tusing (var ms = new MemoryStream(bytes, false))");
sb.AppendLine("\t\t\t{");
sb.AppendLine("\t\t\t\tusing (var br = new BinaryReader(ms))");
sb.AppendLine("\t\t\t\t{");
sb.AppendLine("\t\t\t\t\tvar version = br.ReadInt32();//version");
sb.AppendLine("\t\t\t\t\tif (version != TableLoader.k_DataVersion)\n\t\t\t\t\t\tthrow new System.Exception($\"table error version. file:{version} exe:{TableLoader.k_DataVersion}\");\n");
sb.AppendLine("\t\t\t\t\tvar dataLen = br.ReadInt32();");
sb.AppendLine("\t\t\t\t\tfor (int i = 0; i < dataLen; i++)");
sb.AppendLine("\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\tvar data = new {excelData.GetEntityClassName()}();");
bool first = true;
foreach (var header in excelData.header)
{
if (TableHelper.IgnoreHeader(header))
{
continue;
}
if (!TableHelper.s_TypeLut.TryGetValue(header.fieldTypeName, out Type t))
{
throw new Exception("type is not support: " + header.fieldTypeName);
}
if (t == typeof(byte))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadByte();");
}
else if (t == typeof(int))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadInt32();");
}
else if (t == typeof(long))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadInt64();");
}
else if (t == typeof(float))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadSingle();");
}
else if (t == typeof(bool))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadBoolean();");
}
else if (t == typeof(string))
{
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = br.ReadString();");
}
else if (t == typeof(byte[]))
{
if (first)
{
sb.AppendLine($"\t\t\t\t\t\tvar len = br.ReadByte();");
first = false;
}
else
{
sb.AppendLine($"\t\t\t\t\t\tlen = br.ReadByte();");
}
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = new byte[len];");
sb.AppendLine($"\t\t\t\t\t\tfor (int j = 0; j < len; j++)");
sb.AppendLine("\t\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\t\tdata.{header.fieldName}[j] = br.ReadByte();");
sb.AppendLine("\t\t\t\t\t\t}");
}
else if (t == typeof(int[]))
{
if (first)
{
sb.AppendLine($"\t\t\t\t\t\tvar len = br.ReadByte();");
first = false;
}
else
{
sb.AppendLine($"\t\t\t\t\t\tlen = br.ReadByte();");
}
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = new int[len];");
sb.AppendLine($"\t\t\t\t\t\tfor (int j = 0; j < len; j++)");
sb.AppendLine("\t\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\t\tdata.{header.fieldName}[j] = br.ReadInt32();");
sb.AppendLine("\t\t\t\t\t\t}");
}
else if (t == typeof(long[]))
{
if (first)
{
sb.AppendLine($"\t\t\t\t\t\tvar len = br.ReadByte();");
first = false;
}
else
{
sb.AppendLine($"\t\t\t\t\t\tlen = br.ReadByte();");
}
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = new long[len];");
sb.AppendLine("\t\t\t\t\t\tfor (int j = 0; j < len; j++)");
sb.AppendLine("\t\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\t\tdata.{header.fieldName}[j] = br.ReadInt64();");
sb.AppendLine("\t\t\t\t\t\t}");
}
else if (t == typeof(float[]))
{
if (first)
{
sb.AppendLine($"\t\t\t\t\t\tvar len = br.ReadByte();");
first = false;
}
else
{
sb.AppendLine($"\t\t\t\t\t\tlen = br.ReadByte();");
}
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = new float[len];");
sb.AppendLine("\t\t\t\t\t\tfor (int j = 0; j < len; j++)");
sb.AppendLine("\t\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\t\tdata.{header.fieldName}[j] = br.ReadSingle();");
sb.AppendLine("\t\t\t\t\t\t}");
}
else if (t == typeof(Dictionary <int, int>))
{
if (first)
{
sb.AppendLine($"\t\t\t\t\t\tvar len = br.ReadByte();");
first = false;
}
else
{
sb.AppendLine($"\t\t\t\t\t\tlen = br.ReadByte();");
}
sb.AppendLine($"\t\t\t\t\t\tdata.{header.fieldName} = new Dictionary<int, int>(len);");
sb.AppendLine("\t\t\t\t\t\tfor (int j = 0; j < len; j++)");
sb.AppendLine("\t\t\t\t\t\t{");
sb.AppendLine($"\t\t\t\t\t\t\tvar key = br.ReadInt32();");
sb.AppendLine($"\t\t\t\t\t\t\tvar val = br.ReadInt32();");
sb.AppendLine($"\t\t\t\t\t\t\tdata.{header.fieldName}.Add(key, val);");
sb.AppendLine("\t\t\t\t\t\t}");
}
}
sb.AppendLine("\t\t\t\t\t\tvar _key = br.ReadUInt64();");
sb.AppendLine("\t\t\t\t\t\tm_Datas[_key] = data;");
sb.AppendLine("\t\t\t\t\t}");
sb.AppendLine("\t\t\t\t}");
sb.AppendLine("\t\t\t}");
sb.AppendLine("\t\t\tm_Loaded = true;");
loadAsyncMethod.Statements.Add(new CodeSnippetStatement(sb.ToString()));
loadAsyncMethod.Statements.Add(new CodeMethodReturnStatement(
new CodeSnippetExpression("true")));
sb.Clear();
}
#endregion
#region query method
{
var keyCount = excelData.GetKeyCount();
var keyNames = excelData.GetKeyNames();
var combinedKeyName = "__combinedkey";
if (keyCount == 1)
{
sb.AppendLine($"\t\tpublic static {excelData.GetEntityClassName()} Query(int {keyNames[0]})");
sb.AppendLine("\t\t{");
sb.AppendLine($"\t\t\tvar {combinedKeyName} = KeyHelper.GetKey({keyNames[0]});");
}
else if (keyCount == 2)
{
sb.AppendLine($"\t\tpublic static {excelData.GetEntityClassName()} Query(int {keyNames[0]}, int {keyNames[1]})");
sb.AppendLine("\t\t{");
sb.AppendLine($"\t\t\tvar {combinedKeyName} = KeyHelper.GetKey({keyNames[0]}, {keyNames[1]});");
}
else if (keyCount == 3)
{
sb.AppendLine($"\t\tpublic static {excelData.GetEntityClassName()} Query(int {keyNames[0]}, int {keyNames[1]}, int {keyNames[2]})");
sb.AppendLine("\t\t{");
sb.AppendLine($"\t\t\tvar {combinedKeyName} = KeyHelper.GetKey({keyNames[0]}, {keyNames[1]}, {keyNames[2]});");
}
else if (keyCount == 4)
{
sb.AppendLine($"\t\tpublic static {excelData.GetEntityClassName()} Query(int {keyNames[0]}, int {keyNames[1]}, int {keyNames[2]}, int {keyNames[3]})");
sb.AppendLine("\t\t{");
sb.AppendLine($"\t\t\tvar {combinedKeyName} = KeyHelper.GetKey({keyNames[0]}, {keyNames[1]}, {keyNames[2]}, {keyNames[3]});");
}
sb.AppendLine($"\t\t\tif (!Get().Load()) throw new System.Exception(\"load table failed.type: \" + nameof({excelData.GetEntityClassName()}));");
sb.AppendLine($"\t\t\tif (Get().m_Datas.TryGetValue({combinedKeyName}, out {excelData.GetEntityClassName()} t))");
sb.AppendLine("\t\t\t{");
sb.AppendLine("\t\t\t\treturn t;");
sb.AppendLine("\t\t\t}");
sb.AppendLine($"\t\t\tthrow new System.Exception(\"null table. type: \" + nameof({excelData.GetEntityClassName()}));");
sb.AppendLine("\t\t}");
var queryMethod = new CodeSnippetTypeMember(sb.ToString());
tableClass.Members.Add(queryMethod);
sb.Clear();
}
#endregion
#region queryasync method
{
var keyCount = excelData.GetKeyCount();
var keyNames = excelData.GetKeyNames();
var combinedKeyName = "__combinedkey";
if (keyCount == 1)
{
sb.AppendLine($"\t\tpublic static async System.Threading.Tasks.ValueTask<{excelData.GetEntityClassName()}> QueryAsync(int {keyNames[0]})");
sb.AppendLine("\t\t{");
sb.AppendLine($"\t\t\tvar {combinedKeyName} = KeyHelper.GetKey({keyNames[0]});");
}
else if (keyCount == 2)
{
sb.AppendLine($"\t\tpublic static async System.Threading.Tasks.ValueTask<{excelData.GetEntityClassName()}> QueryAsync(int {keyNames[0]}, int {keyNames[1]})");
sb.AppendLine("\t\t{");
sb.AppendLine($"\t\t\tvar {combinedKeyName} = KeyHelper.GetKey({keyNames[0]}, {keyNames[1]});");
}
else if (keyCount == 3)
{
sb.AppendLine($"\t\tpublic static async System.Threading.Tasks.ValueTask<{excelData.GetEntityClassName()}> QueryAsync(int {keyNames[0]}, int {keyNames[1]}, int {keyNames[2]})");
sb.AppendLine("\t\t{");
sb.AppendLine($"\t\t\tvar {combinedKeyName} = KeyHelper.GetKey({keyNames[0]}, {keyNames[1]}, {keyNames[2]});");
}
else if (keyCount == 4)
{
sb.AppendLine($"\t\tpublic static async System.Threading.Tasks.ValueTask<{excelData.GetEntityClassName()}> QueryAsync(int {keyNames[0]}, int {keyNames[1]}, int {keyNames[2]}, int {keyNames[3]})");
sb.AppendLine("\t\t{");
sb.AppendLine($"\t\t\tvar {combinedKeyName} = KeyHelper.GetKey({keyNames[0]}, {keyNames[1]}, {keyNames[2]}, {keyNames[3]});");
}
sb.AppendLine($"\t\t\tvar result = await Get().LoadAsync();");
sb.AppendLine($"\t\t\tif (!result) throw new System.Exception(\"load table failed.type: \" + nameof({excelData.GetEntityClassName()}));");
sb.AppendLine($"\t\t\tif (Get().m_Datas.TryGetValue({combinedKeyName}, out {excelData.GetEntityClassName()} t))");
sb.AppendLine("\t\t\t{");
sb.AppendLine("\t\t\t\treturn t;");
sb.AppendLine("\t\t\t}");
sb.AppendLine($"\t\t\tthrow new System.Exception(\"null table. type: \" + nameof({excelData.GetEntityClassName()}));");
sb.AppendLine("\t\t}");
var queryMethod = new CodeSnippetTypeMember(sb.ToString());
tableClass.Members.Add(queryMethod);
sb.Clear();
}
#endregion
#region PrintTable method
var printTableMethod = new CodeMemberMethod();
tableClass.Members.Add(printTableMethod);
printTableMethod.Name = "PrintTable";
printTableMethod.ReturnType = new CodeTypeReference(typeof(string));
printTableMethod.Attributes = MemberAttributes.Final | MemberAttributes.Public;
sb.AppendLine("\t\t\tStringBuilder sb = null;");
sb.AppendLine("#if ENABLE_TABLE_LOG");
sb.AppendLine("\t\t\tsb = new StringBuilder(2048);");
sb.AppendLine("\t\t\tforeach (var data in m_Datas.Values)");
sb.AppendLine("\t\t\t{");
foreach (var header in excelData.header)
{
if (TableHelper.IgnoreHeader(header))
{
continue;
}
if (!TableHelper.s_TypeLut.TryGetValue(header.fieldTypeName, out Type t))
{
throw new Exception("type is not support: " + header.fieldTypeName);
}
if (t.IsValueType ||
t == typeof(string))
{
sb.AppendLine($"\t\t\t\tsb.Append(data.{header.fieldName}).Append(\"\\t\");");
}
else if (t == typeof(byte[]) ||
t == typeof(int[]) ||
t == typeof(long[]) ||
t == typeof(float[]))
{
sb.AppendLine($"\t\t\t\tsb.Append(string.Join(\",\", data.{header.fieldName})).Append(\"\\t\");");
}
else if (t == typeof(Dictionary <int, int>))
{
sb.AppendLine($"\t\t\t\tsb.Append(string.Join(\",\", data.{header.fieldName})).Append(\"\\t\");");
}
}
sb.AppendLine("\t\t\t\tsb.AppendLine();");
sb.AppendLine("\t\t\t}");
sb.AppendLine("#endif");
printTableMethod.Statements.Add(new CodeSnippetStatement(sb.ToString()));
printTableMethod.Statements.Add(new CodeMethodReturnStatement(new CodeSnippetExpression("sb?.ToString()")));
sb.Clear();
#endregion
#endregion
#region enum define
if (enumDefineList.Count > 0)
{
var enumType = new CodeTypeDeclaration(excelData.GetEnumName());
enumType.IsEnum = true;
tableNamespace.Types.Add(enumType);
for (int j = 0; j < excelData.rowValues.Count; j++)
{
for (int k = 0; k < enumDefineList.Count; k++)
{
sb.Append(excelData.rowValues[j][enumDefineList[k]]);
if (k != enumDefineList.Count - 1)
{
sb.Append("_");
}
}
enumType.Members.Add(new CodeMemberField()
{
Name = sb.ToString(), InitExpression = new CodePrimitiveExpression(int.Parse(excelData.rowValues[j][0]))
});
sb.Clear();
}
}
#endregion
var options = new FileStreamOptions {
Mode = FileMode.Create, Access = FileAccess.Write, Share = FileShare.ReadWrite
};
var tw = new IndentedTextWriter(new StreamWriter(csfile, options), "\t");
{
var provider = new CSharpCodeProvider();
tw.WriteLine("//------------------------------------------------------------------------------");
tw.WriteLine("// File : {0}", Path.GetFileName(codepath));
tw.WriteLine("// Author : Saro");
tw.WriteLine("// Time : {0}", DateTime.Now.ToString());
tw.WriteLine("//------------------------------------------------------------------------------");
provider.GenerateCodeFromCompileUnit(unit, tw, new CodeGeneratorOptions()
{
BracingStyle = "C"
});
tw.Close();
}
}