static void ProcWorkSheet(string tableName, string excelFile, ExcelWorksheet sheet, string md5)
{
var sheetName = sheet.Name.ToLower();
Console.WriteLine("{0}, {1}", tableName + " " + sheetName, sheet.Cells.Count());
StringBuilder vars = null;
StringBuilder load_funcs = null;
TableType tableType = TableType.Common;
var destPaths = new List <string>();
if (sheetName == "client")
{
tableType = TableType.Client;
vars = manager_vars_c;
load_funcs = manager_load_funcs_c;
destPaths.Add(clientCodePath);
}
else if (sheetName == "server")
{
tableType = TableType.Server;
vars = manager_vars_s;
load_funcs = manager_load_funcs_s;
destPaths.Add(serverCodePath);
}
else
{
vars = manager_vars;
load_funcs = manager_load_funcs;
destPaths.Add(clientCodePath);
destPaths.Add(serverCodePath);
}
var varName = FirstCharToLower(tableName);
vars.AppendLine(" public " + tableName + " " + varName + ";");
load_funcs.AppendLine(" " + varName + " = LoadData<" + tableName + ">(\"Tables/" + tableName + ".bytes\");");
load_funcs.AppendLine(" " + varName + ".Initialize();");
if (IsNewOrUpdateTable(tableName, md5))
{
var tableCode = string.Empty;
foreach (var path in destPaths)
{
string destDir = path + "/Tables";
tableCode = CreateTableWithItemFile(tableName, excelFile, destDir, sheet); //创建TABLE
}
var compileInfo = new TableCompileInfo();
compileInfo.tableName = tableName;
compileInfo.tablePath = excelFile;
compileInfo.tableType = tableType;
compileInfo.sheetName = sheetName;
compileInfo.tableCode = tableCode;
compileInfos.Add(compileInfo);
}
}
static void HandleCSharpWorkSheet(string tableName, string sheetName, string excelFile, ExcelWorksheet sheet, string md5, TableType tableType, string destPath)
{
var varName = tableName.FirstCharToLower();
vars.AppendLine(" public "+ tableName + " " + varName + ";");
load_funcs.AppendLine(" " + varName + " = LoadData<" + tableName + ">(\"Tables/" + tableName + ".bytes\");");
load_funcs.AppendLine(" " + varName + ".Initialize();");
if (IsNewOrUpdateTable(tableName, md5))
{
string destDir = destPath + "/Tables";
var tableCode = CreateCSharpTableWithItem(tableName, excelFile, destDir, sheet); //创建TABLE
var compileInfo = new TableCompileInfo();
compileInfo.tableName = tableName;
compileInfo.tablePath = excelFile;
compileInfo.tableType = tableType;
compileInfo.sheetName = sheetName;
compileInfo.tableCode = tableCode;
compileInfos.Add(compileInfo);
}
}