private void BindData() { ASPxTreeList1.ClearNodes(); string pline = ASPxComboBoxPline.Value as string; //List<DetectBarCodeEntity> entity = db.Fetch<DetectBarCodeEntity>("where PLINE_CODE=@0 order by SEQ_LEVEL,SEQ_VALUE", pline); //ASPxTreeList1.DataSource = entity; //ASPxTreeList1.DataBind(); //ASPxTreeList1.CellEditorInitialize += new DevExpress.Web.ASPxTreeList.TreeListColumnEditorEventHandler(ASPxTreeList1_CellEditorInitialize); //ASPxTreeList1.NodeValidating += new DevExpress.Web.ASPxTreeList.TreeListNodeValidationEventHandler(ASPxTreeList1_NodeValidating); //ASPxTreeList1.NodeInserting += new DevExpress.Web.Data.ASPxDataInsertingEventHandler(ASPxTreeList1_NodeInserting); //ASPxTreeList1.NodeUpdating += new DevExpress.Web.Data.ASPxDataUpdatingEventHandler(ASPxTreeList1_NodeUpdating); //ASPxTreeList1.NodeDeleting += new DevExpress.Web.Data.ASPxDataDeletingEventHandler(ASPxTreeList1_NodeDeleting); //ASPxTreeList1.HtmlRowPrepared += new DevExpress.Web.ASPxTreeList.TreeListHtmlRowEventHandler(ASPxTreeList1_HtmlRowPrepared); //手动加载节点 解决第一层老是按1,10,2,20,3,4。。。。。。的排序问题 List <DetectBarCodeEntity> entity = db.Fetch <DetectBarCodeEntity>("where PLINE_CODE=@0 and SEQ_LEVEL=1 order by to_number(seq_value,'99')", pline); foreach (var d in entity) { TreeListNode tln = ASPxTreeList1.AppendNode(d.RMES_ID); tln["RMES_ID"] = d.RMES_ID; tln["PLINE_CODE"] = d.PLINE_CODE; tln["SEQ_NAME"] = d.SEQ_NAME; tln["SEQ_VALUE"] = d.SEQ_VALUE; tln["SEQ_FATHER"] = d.SEQ_FATHER; tln["SEQ_LEVEL"] = d.SEQ_LEVEL; List <DetectBarCodeEntity> child = db.Fetch <DetectBarCodeEntity>("where PLINE_CODE=@0 and SEQ_LEVEL=2 and SEQ_FATHER=@1 order by SEQ_VALUE", pline, d.RMES_ID); for (int i = 0; i < child.Count; i++) { TreeListNode ctln = ASPxTreeList1.AppendNode(child[i].RMES_ID, tln); ctln["RMES_ID"] = child[i].RMES_ID; ctln["PLINE_CODE"] = child[i].PLINE_CODE; ctln["SEQ_NAME"] = child[i].SEQ_NAME; ctln["SEQ_VALUE"] = child[i].SEQ_VALUE; ctln["SEQ_FATHER"] = child[i].SEQ_FATHER; ctln["SEQ_LEVEL"] = child[i].SEQ_LEVEL; } } }