/// <summary> /// 根据菜单添加结构到功能普通树 /// </summary> private void AddFunctionTreeViewNodes() { //string strSql = "SELECT FBH,GNBH,replace(GNMC,'&','') as GNMC FROM SYS_FUNCTION where GNMC<>'-' order by GNBH"; //string strSql = "SELECT sParentFunctionID,sFunctionID,replace(sFunctionName,'&','') as sFunctionName FROM SYS_MainFunctions where sFunctionName<>'-' order by sFunctionID"; string strSql = "SELECT sMenuGroupID,sFunctionID,sFunctionName FROM SYS_Menu order by sSortBy"; DataTable DT = ZX.ZXSystem.DBUtility.DbHelperSQL.Query(strSql).Tables[0]; ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); TV.ReadNodesFromDataTable(this.treeViewFunction, DT, false, 0, 1, 2); DT.Clear(); GC.Collect(); }
private void LoadData() { string strSql = "select * from Bas_Area"; //DT = ZX.ZXSystem.DBUtility.DbHelperSQL.Query(strSql).Tables[0]; //this.gc_Customer.DataSource = DT; DT= ZX.ZXSystem.DBUtility.DbHelperSQL.Query(strSql).Tables[0]; //BindRoot(); //treeList1.DataSource = DT; //treeList1.KeyFieldName = "sAreaID";//设置主键 //treeList1.ParentFieldName = "sParentAreaID";//设置父级主键 //treeList1.RootValue = "";//顶级树结点的值 //TreeListFillInfo(); ZX.Controls.TreeViewC tv = new ZX.Controls.TreeViewC(); tv.ReadNodesFromDataTable(this.treeView1, DT, false, 1, 0, 2); }
/// <summary> /// 根据菜单添加结构到功能普通树 /// </summary> private void AddTreeViewHelpNodes() { string strSql = "SELECT sMenugroupID,sFunctionID,replace(sFunctionName,'&','') as sFunctionName FROM SYS_Menu where sFunctionName<>'-' order by smenugroupid,ssortby"; DataTable DT = ZX.ZXSystem.DBUtility.DbHelperSQL.Query(strSql).Tables[0]; #region"用普通的树TreeView控件" ZX.Controls.TreeViewC TV = new ZX.Controls.TreeViewC(); TV.ReadNodesFromDataTable(this.treeViewHelp, DT, false, 0, 1, 2); #endregion #region"用HR的树控件" //FromMenuAddNodeToTreeView(); #endregion DT.Clear(); GC.Collect(); }