/// <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();
}
