private string GetNormalJsonStr(Data.TableNode tableNode)
{
string returnStr;
bool isGlobal = code.Data.Setting.getInstance().getSettingClassByType(GlobalData.OUTPUT_TYPE.JSON).globalSetting;
List <string> strList = new List <string>();
JsonRowNodeWriter rowNodeWrite = new JsonRowNodeWriter();
returnStr = "{\r\n";
for (int i = 0; i < tableNode.getRowNodeList().Count; i++)
{
string str = rowNodeWrite.ObjectString(tableNode.getRowNodeList()[i]);
if (str == null)
{
continue;
}
strList.Add(str);
}
for (int i = 0; i < strList.Count; i++)
{
returnStr = returnStr + " " + strList[i] + ((i == strList.Count - 1) ? "" : ",");
returnStr = returnStr + "\r\n";
}
returnStr = returnStr + GlobalData.getJsonTableBlock() + "}";
return(returnStr);
}
public Data.TableNode getTableNode()
{
Data.TableNode tableNode = new Data.TableNode(_sheetName, _fileName);
int count = 0;
foreach (XmlElement rowElement in _tableElement.GetElementsByTagName("Row"))
{
if (rowElement.GetElementsByTagName("Cell").Count <= 0)
{
Console.WriteLine(_sheetName + "表格中存在空的Row节点");
return(null);
}
if (count == 1)
{
_rowNodeReader = new XmlRowNodeReader(true, rowElement, tableNode);
tableNode.setKeyRowNode(_rowNodeReader.getRowNode());
}
else if (count > 1)
{
_rowNodeReader = new XmlRowNodeReader(false, rowElement, tableNode);
tableNode.addDataRowNode(_rowNodeReader.getRowNode());
}
count++;
}
return(tableNode);
}
public string getClientString(Data.TableNode tableNode)
{
string returnStr;
bool isGlobal = code.Data.Setting.getInstance().getSettingClassByType(GlobalData.OUTPUT_TYPE.JSON).globalSetting;
List <string> strList = new List <string>();
LuaRowNodeWriter rowNodeWrite = new LuaRowNodeWriter();
Data.Setting.SettingClass luaSetting = Data.Setting.getInstance().getSettingClassByType(GlobalData.OUTPUT_TYPE.LUA);
if (luaSetting.globalSetting)
{
returnStr = "{\r\n";
}
else
{
returnStr = "return {\r\n";
}
for (int i = 0; i < tableNode.getRowNodeList().Count; i++)
{
string str = rowNodeWrite.ObjectString(tableNode.getRowNodeList()[i]);
if (str == null)
{
continue;
}
strList.Add(str);
}
for (int i = 0; i < strList.Count; i++)
{
returnStr = returnStr + " " + strList[i] + ((i == strList.Count - 1) ? "" : ",");
returnStr = returnStr + " " + "\r\n";
}
returnStr = returnStr + GlobalData.getLuaTableBlock() + "}";
return(returnStr);
}
private string GetUnityJsonStr(Data.TableNode tableNode)
{
string returnStr;
returnStr = "{\r\n";
//输出keys
returnStr = returnStr + GetUnityJsonKeysStr(tableNode);
//输出values
returnStr = returnStr + GetUnityJsonValuesStr(tableNode);
returnStr = returnStr + GlobalData.getJsonTableBlock() + "}";
return(returnStr);
}
public string GetClientString(Data.TableNode tableNode, string jsonFileName)
{
//读取输出配置
code.Data.Setting setting = code.Data.Setting.getInstance();
//初始化
code.Data.Setting.SettingClass jsonSetting = setting.getSettingClassByType(GlobalData.OUTPUT_TYPE.JSON);
if (jsonSetting.useInUnity && jsonFileName != null)
{
if (jsonSetting.buildCS)
{
//新建一个CS读取类
new UnityCSWrite.UnityCSWrite().WriteCSJsonClass(tableNode.getTranslateData(), jsonFileName);
}
return(GetUnityJsonStr(tableNode));
}
return(GetNormalJsonStr(tableNode));
}
public Data.TableNode getTableNode()
{
Data.TableNode tableNode = new Data.TableNode(_sheetName, _fileName);
for (int i = _workSheet.FirstRowNum + 1; i <= _workSheet.LastRowNum; i++)
{
ExcelRowNodeReader rowNodeReader =
new ExcelRowNodeReader(i == _workSheet.FirstRowNum + 1, _workSheet.GetRow(i), tableNode);
if (i == _workSheet.FirstRowNum + 1)
{
tableNode.setKeyRowNode(rowNodeReader.getRowNode());
}
else if (i > _workSheet.FirstRowNum + 1)
{
tableNode.addDataRowNode(rowNodeReader.getRowNode());
}
}
return(tableNode);
}
//输出values
private string GetUnityJsonValuesStr(Data.TableNode tableNode)
{
JsonRowNodeWriter rowNodeWrite = new JsonRowNodeWriter();
List <string> strList = new List <string>();
string returnStr = " " + "\"values\": [\r\n";
for (int i = 0; i < tableNode.getRowNodeList().Count; i++)
{
string str = rowNodeWrite.UnityGetValueString(tableNode.getRowNodeList()[i]);
if (str == null)
{
continue;
}
strList.Add(str);
}
for (int i = 0; i < strList.Count; i++)
{
returnStr = returnStr + " " + strList[i] + ((i == strList.Count - 1) ? "" : ",");
returnStr = returnStr + "\r\n";
}
returnStr = returnStr + " " + "]\r\n";
return(returnStr);
}
public XmlRowNodeReader(Boolean isKeyRow, XmlElement rowElement, Data.TableNode tableNode)
{
_isKeyRow = isKeyRow;
_rowElement = rowElement;
_tableNode = tableNode;
}
public ExcelRowNodeReader(Boolean isKeyRow, IRow row, Data.TableNode tableNode)
{
_isKeyRow = isKeyRow;
_row = row;
_tableNode = tableNode;
}
