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文件生成完毕"); }