public void CreateJavaResContainer(ExcelData excelSheetData, CJavaDataConfig javaDataConfig)
{
string[,] data = Global.GetSheetFromExcel(excelSheetData.ExcelName, excelSheetData.SheetName);
string name = Global.FirstCharToUpper(excelSheetData.SheetName.Replace("'", "").Replace("$", ""));
string filePath = javaDataConfig.folder + @"\src\com\game\data\mapsql\" + name + "Container.java";
string templatePath = @".\Templates\Java\temp_java_res_container.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("PackageString");
needReplace.Add("Name");
needReplace.Add("TimeNow");
replace.Add(javaDataConfig.package);
replace.Add(name);
replace.Add(DateTime.Now.ToString("yy-MM-dd HH:mm:ss"));
for (int i = 0; i < data.GetLength(1); i++)
{
if (!string.IsNullOrEmpty(data[0, i]) && data[0, i] == "1")
{
needReplace.Add("ID");
replace.Add(Global.FirstCharToUpper(data[1, i]));
break;
}
}
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
Debug.Log(name + "Container.java文件生成完毕");
}
public void CreateAsContainer(ExcelData sheet, CAsDataConfig dataConfig)
{
string name = Global.FirstCharToUpper(sheet.SheetName.Replace("'", "").Replace("$", ""));
string filePath = dataConfig.folder + @"\com\game\data\container\" + name + "Container.as";
string templatePath = @".\Templates\AS\temp_as_res_container.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("PackageString");
needReplace.Add("importList");
needReplace.Add("Name");
needReplace.Add("ContainerName");
replace.Add(dataConfig.package);
List <string> import = new List <string>();
if (dataConfig.containerImport.Length > 0)
{
foreach (var container in dataConfig.containerImport)
{
import.Add(container);
}
}
replace.Add(import);
replace.Add(name);
replace.Add(name + "Container");
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
Debug.Log(name + "Container.as文件生成完毕");
}
public void CreateJavaResMapSql(ExcelData excelSheetData, CJavaDataConfig javaDataConfig)
{
string[,] data = Global.GetSheetFromExcel(excelSheetData.ExcelName, excelSheetData.SheetName);
string name = excelSheetData.SheetName.Replace("'", "").Replace("$", "");
string filePath = javaDataConfig.folder + @"\src\com\game\data\sqlmap\" + name + ".xml";
string templatePath = @".\Templates\Java\temp_java_res_sqlmap.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("Name");
replace.Add(name);
if (data.GetLength(1) > 0)
{
needReplace.Add("fieldList");
List <BeanVar> beanVars = new List <BeanVar>();
for (int i = 0; i < data.GetLength(1); i++)
{
BeanVar bean = new BeanVar();
bean.name = data[1, i];
bean.className = data[2, i];
beanVars.Add(bean);
}
replace.Add(beanVars);
}
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
Debug.Log(name + ".xml文件生成完毕");
}
public void CreateJavaResBean(ExcelData excelSheetData, CJavaDataConfig javaDataConfig)
{
string[,] data = Global.GetSheetFromExcel(excelSheetData.ExcelName, excelSheetData.SheetName);
string name = Global.FirstCharToUpper(excelSheetData.SheetName.Replace("'", "").Replace("$", ""));
string filePath = javaDataConfig.folder + @"\src\com\game\data\bean\" + name + "Bean.java";
string templatePath = @".\Templates\Java\temp_java_res_bean.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("PackageString");
needReplace.Add("BeanName");
replace.Add(javaDataConfig.package);
replace.Add(name);
if (data.GetLength(1) > 0)
{
needReplace.Add("fieldList");
List <BeanVar> beanList = new List <BeanVar>();
for (int i = 0; i < data.GetLength(1); i++)
{
BeanVar beanVar = new BeanVar();
beanVar.name = data[1, i];
beanVar.className = data[2, i];
beanVar.explain = data[4, i];
beanList.Add(beanVar);
}
replace.Add(beanList);
}
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
Debug.Log(name + "Bean.java文件生成完毕");
}
/// <summary>
/// 生成CS表格资源
/// </summary>
/// <param name="checkedListBox1"></param>
/// <param name="excelDatas"></param>
/// <param name="label1"></param>
public void CreateCsResBean(ExcelData sheet, CAsDataConfig dataConfig, bool isSet = true)
{
string[,] data = Global.GetSheetFromExcel(sheet.ExcelName, sheet.SheetName);
string name = Global.FirstCharToUpper(sheet.SheetName.Replace("'", "").Replace("$", ""));
string filePath = dataConfig.folder + @"\" + name + ".cs";
string templatePath = @".\Templates\CS\temp_cs_res_bean.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("DateTime");
replace.Add(DateTime.Now.ToString("yyyy-M-d HH:mm:ss"));
needReplace.Add("PackageString");
replace.Add(dataConfig.package);
needReplace.Add("BeanName");
replace.Add(name);
List <string> import = new List <string>();
if (dataConfig.beanImport != null && dataConfig.beanImport.Length > 0)
{
needReplace.Add("importList");
foreach (var bean in dataConfig.beanImport)
{
import.Add(bean);
}
replace.Add(import);
}
needReplace.Add("fieldList");
List <BeanVar> fieldList = new List <BeanVar>();
for (int i = 0; i < data.GetLength(1); i++)
{
if (!string.IsNullOrWhiteSpace(data[1, i]) && !data[0, i].Contains("备注") && !data[1, i].Contains("备注") && !data[2, i].Contains("备注") && !data[3, i].Contains("备注") && !data[4, i].Contains("备注"))
{
BeanVar field = new BeanVar();
field.name = data[1, i];
field.className = data[2, i];
field.explain = data[4, i].Replace("\n", "").Replace("\r", "");
fieldList.Add(field);
}
}
replace.Add(fieldList);
if (isSet)
{
needReplace.Add("getFieldList");
replace.Add(fieldList);
}
if (File.Exists(templatePath))
{
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
Debug.Log(name + ".cs文件生成完毕");
}
else
{
Debug.Log("模板文件不存在请检查." + templatePath);
}
}
private void WriteToDataConfig(ExcelData excelSheetData, string dataConfigPath, CJavaDataConfig javaDataConfig, MapperNode[] mapperNodes)
{
string name = excelSheetData.SheetName.Replace("'", "").Replace("$", "");
string filePath = dataConfigPath;
string templatePath = @".\Templates\Java\temp_java_res_dataconfig.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("SqlType");
replace.Add(javaDataConfig.dbType);
needReplace.Add("SqlIP");
replace.Add(javaDataConfig.dbIp);
needReplace.Add("SqlPort");
replace.Add(javaDataConfig.dbport);
needReplace.Add("DBName");
replace.Add(javaDataConfig.dbName);
needReplace.Add("UserName");
replace.Add(javaDataConfig.dbUser);
needReplace.Add("Psw");
replace.Add(javaDataConfig.dbPsw);
needReplace.Add("sheetList");
List <MapperSheet> sheetList = new List <MapperSheet>();
MapperSheet sheet = new MapperSheet(name, DateTime.Now.ToString("yyyy-M-d HH:mm:ss"));
if (mapperNodes != null)
{
foreach (var mn in mapperNodes)
{
MapperSheet ms = new MapperSheet(mn.name, mn.time);
sheetList.Add(ms);
}
bool sampFlag = false;
for (int i = 0; i < sheetList.Count; i++)
{
if (sheet.sheetName == sheetList[i].sheetName)
{
sampFlag = true;
sheetList[i].nowTime = sheet.nowTime;
break;
}
}
if (!sampFlag)
{
sheetList.Add(sheet);
}
}
else
{
sheetList.Add(sheet);
}
replace.Add(sheetList);
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
}
private void CreateJavaMsMessage(CMessages messages, string path)
{
foreach (var cMes in messages.messages)
{
string msgMane = cMes.name + "Message";
string filePath = path + @"\message\" + msgMane + ".java";
string templatePath = @".\Templates\Java\temp_java_message_message.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("PackageString");
replace.Add(messages.import);
needReplace.Add("BeanSuper");
replace.Add(messages.beanSuper);
needReplace.Add("MessageName");
replace.Add(msgMane);
needReplace.Add("Explain");
replace.Add(cMes.explain);
if (cMes.fields != null && cMes.fields.Length > 0)
{
needReplace.Add("fieldList");
List <BeanVar> beanList = new List <BeanVar>();
foreach (var cField in cMes.fields)
{
BeanVar bean = new BeanVar();
bean.name = cField.name;
bean.className = cField.fieldType;
bean.explain = cField.explain;
beanList.Add(bean);
}
replace.Add(beanList);
}
if (cMes.lists != null && cMes.lists.Length > 0)
{
needReplace.Add("beanList");
List <BeanVar> beanList = new List <BeanVar>();
foreach (var cList in cMes.lists)
{
BeanVar bean = new BeanVar();
bean.name = cList.name;
bean.className = cList.listType;
bean.explain = cList.explain;
beanList.Add(bean);
}
replace.Add(beanList);
}
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
Debug.Log(msgMane + ".java文件生成完毕");
}
}
public void CreateAsResBean(ExcelData sheet, CAsDataConfig dataConfig, bool isSet = true)
{
string[,] data = Global.GetSheetFromExcel(sheet.ExcelName, sheet.SheetName);
string name = Global.FirstCharToUpper(sheet.SheetName.Replace("'", "").Replace("$", ""));
string filePath = dataConfig.folder + @"\com\game\data\bean\" + name + ".as";
string templatePath = @".\Templates\AS\temp_as_res_bean.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("PackageString");
needReplace.Add("importList");
needReplace.Add("BeanName");
needReplace.Add("fieldList");
replace.Add(dataConfig.package);
List <string> import = new List <string>();
if (dataConfig.beanImport.Length > 0)
{
foreach (var bean in dataConfig.beanImport)
{
import.Add(bean);
}
}
replace.Add(import);
replace.Add(name);
List <BeanVar> fieldList = new List <BeanVar>();
for (int i = 0; i < data.GetLength(1); i++)
{
if (!string.IsNullOrWhiteSpace(data[1, i]))
{
BeanVar field = new BeanVar();
field.name = data[1, i];
field.className = data[2, i];
field.explain = data[4, i];
fieldList.Add(field);
}
}
replace.Add(fieldList);
if (isSet)
{
needReplace.Add("getFieldList");
replace.Add(fieldList);
}
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
Debug.Log(name + ".as文件生成完毕");
}
private void WriteToMsgPool(CMessages messages, string filePath, List <MessgaeField> fieldList)
{
string templatePath = @".\Templates\Java\temp_java_message_messagepool.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("MessageList");
List <MessgaeField> mf = new List <MessgaeField>();
if (fieldList != null)
{
foreach (var messgaeField in fieldList)
{
mf.Add(messgaeField);
}
}
foreach (var cMessage in messages.messages)
{
MessgaeField mft = new MessgaeField();
mft.name = cMessage.name;
mft.id = messages.ID + cMessage.ID;
if (fieldList != null)
{
bool flag = false;
foreach (var messgaeField in fieldList)
{
if (messgaeField.id == mft.id)
{
flag = true;
break;
}
}
if (!flag)
{
mf.Add(mft);
}
}
else
{
mf.Add(mft);
}
}
replace.Add(mf);
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
}
private void WriteToDataManager(string sheetDataName, string dataManagerPath, string packageString, List <BeanVar> sheetNameList)
{
string name = sheetDataName.Replace("'", "").Replace("$", "");
string filePath = dataManagerPath;
string templatePath = @".\Templates\Java\temp_java_res_datamanager.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("PackageString");
replace.Add(packageString);
needReplace.Add("TimeNow");
replace.Add(DateTime.Now.ToString("yyyy-M-d HH:mm:ss"));
needReplace.Add("containerList");
BeanVar beanVar = new BeanVar();
beanVar.name = name;
List <BeanVar> beanVarLiseList = new List <BeanVar>();
if (sheetNameList != null)
{
foreach (var sheetName in sheetNameList)
{
beanVarLiseList.Add(sheetName);
}
bool sampFlag = false;
for (int i = 0; i < sheetNameList.Count; i++)
{
if (beanVar.UpperName == sheetNameList[i].UpperName)
{
sampFlag = true;
break;
}
}
if (!sampFlag)
{
beanVarLiseList.Add(beanVar);
}
}
else
{
beanVarLiseList.Add(beanVar);
}
replace.Add(beanVarLiseList);
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
}
public void CreateJavaResDao(ExcelData excelSheetData, CJavaDataConfig javaDataConfig)
{
string name = Global.FirstCharToUpper(excelSheetData.SheetName.Replace("'", "").Replace("$", ""));
string filePath = javaDataConfig.folder + @"\src\com\game\data\dao\" + name + "Dao.java";
string templatePath = @".\Templates\Java\temp_java_res_dao.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("PackageString");
needReplace.Add("Name");
needReplace.Add("TimeNow");
needReplace.Add("BaseDao");
replace.Add(javaDataConfig.package);
replace.Add(name);
replace.Add(DateTime.Now.ToString("yy-MM-dd HH:mm:ss"));
replace.Add(javaDataConfig.baseDao);
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
Debug.Log(name + "Dao.java文件生成完毕");
}
private void CreateJavaMsHandler(CMessages messages, string path)
{
foreach (var cMes in messages.messages)
{
string msgMane = cMes.name + "Handler";
string filePath = path + @"\handler\" + msgMane + ".java";
string templatePath = @".\Templates\Java\temp_java_message_handler.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("PackageString");
replace.Add(messages.import);
needReplace.Add("Handler");
replace.Add(messages.handler);
needReplace.Add("MessageName");
replace.Add(cMes.name);
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
Debug.Log(msgMane + ".java文件生成完毕");
}
}
public void CreateCsContainer(ExcelData sheet, CAsDataConfig dataConfig)
{
string name = Global.FirstCharToUpper(sheet.SheetName.Replace("'", "").Replace("$", ""));
string filePath = dataConfig.folder + @"\" + name + "Container.cs";
string templatePath = @".\Templates\CS\temp_cs_res_container.vm";
List <string> needReplace = new List <string>();
ArrayList replace = new ArrayList();
needReplace.Add("DateTime");
replace.Add(DateTime.Now.ToString("yyyy-M-d HH:mm:ss"));
if (dataConfig.package != null)
{
needReplace.Add("PackageString");
replace.Add(dataConfig.package);
needReplace.Add("BeanPackage");
replace.Add(dataConfig.package);
}
needReplace.Add("Name");
replace.Add(name);
needReplace.Add("ContainerName");
replace.Add(name + "Container");
List <string> import = new List <string>();
if (dataConfig.containerImport != null && dataConfig.containerImport.Length > 0)
{
needReplace.Add("importList");
foreach (var bean in dataConfig.containerImport)
{
import.Add(bean);
}
replace.Add(import);
}
string[,] sheetdata = Global.GetSheetFromExcel(sheet.ExcelName, sheet.SheetName);
if (sheetdata != null && sheetdata.GetLength(1) > 0)
{
string Id = "";
Dictionary <int, string> KeyDict = new Dictionary <int, string>();
for (int i = 0; i < sheetdata.GetLength(1); i++)
{
if (sheetdata[0, i] != "" && sheetdata[0, i] != " ")
{
int index = int.Parse(sheetdata[0, i]);
KeyDict.Add(index, sheetdata[1, i]);
}
}
if (KeyDict.Count > 0)
{
Id += string.Format("bean.{0}.ToString()", KeyDict[1]);;
for (int i = 0; i < KeyDict.Count - 1; i++)
{
Id += string.Format("+\"_\"+bean.{0}.ToString()", KeyDict[2 + i]);
}
}
needReplace.Add("ID");
if (Id == "")
{
replace.Add("IAMNULL");
}
else
{
replace.Add(Id);
}
}
CNVelociryHelp.CreateFileByTemplate(filePath, templatePath, needReplace, replace);
Debug.Log(name + "Container.cs文件生成完毕");
}
