void buildChild(xl line) { IList<PS_gt> gtlist= Client.ClientHelper.PlatformSqlMap.GetList<PS_gt>("where linecode='" + line.xlValue.LineCode + "' order by gtcode"); line.addGt(gtlist); line.initgtsb(); IList<PS_xl> xlList= Client.ClientHelper.PlatformSqlMap.GetList<PS_xl>(" where parentgt in (select gtcode from ps_gt where linecode='" + line.xlValue.LineCode + "')"); line.addXl(xlList); foreach (xl xl in line.lines) { if (strList.Contains(xl.xlValue.LineCode)) continue; strList.Add(xl.xlValue.LineCode); buildChild(xl); } }
private void aa() { string tqcode = pid; IList<PS_xl> list = Ebada.Client.ClientHelper.PlatformSqlMap.GetList<PS_xl>("where linecode like '" + tqcode + "%' and linevol='0.4' order by linecode"); DataTable xltable = Ebada.Core.ConvertHelper.ToDataTable((IList)list,typeof(PS_xl)); List<xl> xllist = new List<xl>(); foreach (PS_xl line in list) { xl xl = new xl(line); xl.initgtsb(); xllist.Add(xl); } if (xllist.Count > 0) createxl(xllist[0],0); }