在递归中增加樹狀排序-水寒冰居.专注于.NET

在递归中增加樹狀排序

public DataTable GetChildDataTable(int parentMaterialD, string sequenceString)
{
DataTable dataTable = new DataTable();
StringBuilder strSql = new StringBuilder();

strSql.Append(@"select SEQUENCE...");//SQL語句省略
DataTable BOMdataTable = DbHelperSQL.QueryTable(strSql.ToString());

//自定義增加的排序列
DataColumn dataColumn = new DataColumn("SEQUENCE_STRING", typeof(string));
BOMdataTable.Columns.Add(dataColumn);

if (dataTable.Rows.Count <= 0)
{
dataTable = BOMdataTable.Clone();
}
int rowCount = BOMdataTable.Rows.Count;
for (int i = 0; i < rowCount; i++)
{
//構建排序的結構(如:1.2.1)
String newSequenceString = sequenceString + "." + BOMdataTable.Rows[i].ItemArray[BOMdataTable.Columns.IndexOf("SEQUENCE")];
BOMdataTable.Rows[i].BeginEdit();
BOMdataTable.Rows[i][BOMdataTable.Columns.IndexOf("SEQUENCE_STRING")] = newSequenceString;
BOMdataTable.Rows[i].EndEdit();

dataTable.ImportRow(BOMdataTable.Rows[i]);

dataTable.Merge(GetChildDataTable(Int32.Parse(BOMdataTable.Rows[i].ItemArray[BOMdataTable.Columns.IndexOf("MATERIAL_ID")].ToString()), newSequenceString));
}

return dataTable;
}