private void ParseRecordEnd(StringBuilder itemBuilder, MessageReader reader, List <DataRow> queue, int depth, int recordNum, string[] keyNames)
{
MessageReader msgReader = reader;
string keyValue = string.Empty;
string keyName = keyNames.Length > depth ? keyNames[depth] : string.Empty;
List <LuaConfig> builderList = new List <LuaConfig>();
int recordCount = 0;
try
{
recordCount = msgReader.RecordCount();
}
catch { }
for (int i = 0; i < recordCount; i++)
{
try
{
msgReader.RecordStart();
int loopDepth = 0; //循环深度
StringBuilder recordBuilder = new StringBuilder();
List <DataRow> recordQueue = new List <DataRow>();
int columnNum = 0;
int childNum = 0;
#region 遍历列取数据
for (int r = 1; r < queue.Count - 1; r++)
{
DataRow record = queue[r];
string fieldName = record["Field"].ToString();
FieldType fieldType = (FieldType)Enum.Parse(typeof(FieldType), record["FieldType"].ToString());
string fieldValue = "";
try
{
if (loopDepth > 0 && fieldType == FieldType.End)
{
loopDepth--;
recordQueue.Add(record);
}
if (loopDepth == 0 && recordQueue.Count > 0)
{
//处理循环记录
childNum++;
var childBuilder = new StringBuilder();
ParseRecordEnd(childBuilder, msgReader, recordQueue, depth + 1, childNum, keyNames);
//
recordQueue.Clear();
//选择输出格式
FormatChildToLua(recordBuilder, childBuilder, columnNum);
}
if (loopDepth == 0)
{
if (msgReader.GetFieldValue(fieldType, ref fieldValue))
{
if (columnNum > 0)
{
recordBuilder.Append(",");
}
if (fieldName.Trim().ToLower() == keyName.Trim().ToLower())
{
keyValue = fieldValue;
}
if (fieldType == FieldType.Byte || fieldType == FieldType.Short || fieldType == FieldType.Int)
{
recordBuilder.AppendFormat("{0}={1}", fieldName, fieldValue);
}
else
{
recordBuilder.AppendFormat("{0}=\"{1}\"", fieldName, fieldValue);
}
columnNum++;
}
if (fieldType == FieldType.Record)
{
loopDepth++;
recordQueue.Add(record);
}
}
else if (fieldType != FieldType.End)
{
if (fieldType == FieldType.Record)
{
loopDepth++;
}
recordQueue.Add(record);
}
}
catch (Exception ex)
{
throw new Exception(string.Format("recordindex:{0},fieldName:{1} error:", i, fieldName), ex);
}
}
#endregion
//读取行结束
msgReader.RecordEnd();
builderList.Add(new LuaConfig {
Key = keyValue, Builder = recordBuilder
});
}
catch (Exception ex)
{
throw new Exception(string.Format("recordindex:{0}error:", i), ex);
}
}
FormatListToLua(itemBuilder, builderList, keyName, depth, recordNum);
}
/// <summary>
/// 处理循环记录
/// </summary>
/// <param name="respContent"></param>
/// <param name="recordQueue"></param>
/// <param name="msgReader"></param>
private static void ProcessLoopRocord(StringBuilder respContent, List<DataRow> queue, MessageReader reader)
{
StringBuilder headContent = new StringBuilder();
StringBuilder builderContent = new StringBuilder();
int recordCount = 0;
try
{
recordCount = reader.RecordCount();
}
catch (Exception ex)
{
}
respContent.Append("<tr>");
respContent.Append("<td style=\"width:25%;\" align=\"left\">Record(N)</td>");
respContent.Append("<td style=\"width:20%;\" align=\"left\">Record</td>");
respContent.AppendFormat("<td style=\"width:50%;\" align=\"left\">{0}</td>", recordCount);
respContent.Append("</tr>");
respContent.Append("<tr><td colspan=\"3\" align=\"center\">");
respContent.Append("<!--子表开始--><table style=\"width:98%; border-color:#999\" border=\"1\" cellpadding=\"2\" cellspacing=\"0\">");
if (recordCount == 0)
{
builderContent.Append("<tr><td align=\"center\">空数据</td></tr>");
}
for (int i = 0; i < recordCount; i++)
{
try
{
reader.RecordStart();
MessageReader msgReader = reader;
int loopDepth = 0; //循环深度
List<DataRow> recordQueue = new List<DataRow>();
headContent.Append("<tr><!--头开始tr-->");
builderContent.Append("<tr><!--内容开始tr-->");
int columnNum = 0;
#region
for (int r = 1; r < queue.Count - 1; r++)
{
DataRow record = queue[r];
string fieldName = record["Field"].ToString();
FieldType fieldType = (FieldType)Enum.Parse(typeof(FieldType), record["FieldType"].ToString());
string fieldValue = "";
try
{
if (loopDepth > 0 && fieldType == FieldType.End)
{
loopDepth--;
recordQueue.Add(record);
}
if (loopDepth == 0 && recordQueue.Count > 0)
{
builderContent.Append("</tr><tr>");
builderContent.AppendFormat("<td colspan=\"{0}\" align=\"right\">", columnNum);
builderContent.Append(
"<!--子表开始--><table style=\"width:95%; border-color:#999\" border=\"1\" cellpadding=\"2\" cellspacing=\"0\">");
//处理循环记录
ProcessLoopRocord(builderContent, recordQueue, msgReader);
builderContent.Append("</table><!--子表结束-->");
builderContent.Append("</td>");
recordQueue.Clear();
}
if (loopDepth == 0)
{
if (msgReader.GetFieldValue(fieldType, ref fieldValue))
{
if (i == 0)
headContent.AppendFormat("<td align=\"center\"><strong>{0}</strong>({1})</td>",
fieldName, fieldType);
builderContent.AppendFormat("<td align=\"center\"> {0}</td>", fieldValue);
columnNum++;
}
if (fieldType == FieldType.Record)
{
loopDepth++;
recordQueue.Add(record);
}
}
else if (fieldType != FieldType.End)
{
if (fieldType == FieldType.Record)
{
loopDepth++;
}
recordQueue.Add(record);
}
}
catch (Exception ex)
{
builderContent.AppendFormat("<td align=\"center\">{0}列出错{1}</td>", fieldName, ex.Message);
}
}
#endregion
headContent.Append("</tr><!--头结束tr-->");
builderContent.Append("</tr><!--内容结束tr-->");
//读取行结束
reader.RecordEnd();
}
catch (Exception ex)
{
builderContent.AppendFormat("<tr><td align=\"left\">{0}行出错{1}</td></tr>", (i + 1), ex.Message);
}
}
respContent.Append(headContent.ToString());
respContent.Append(builderContent.ToString());
respContent.Append("</table><!--子表结束-->");
respContent.Append("</td></tr>");
respContent.Append("<tr>");
respContent.Append("<td colspan=\"3\" align=\"left\">End</td>");
respContent.Append("</tr>");
}
