public void GetOrganizationStructure(int ExpandedRoot = 1, int ExpandedFilials = 1, int ExpandedGroups = 0, int ExpandedRoleJob = 0, string OnlyCurentFillial = "NULL") { if (sender.Nodes.Count != 0) { Filling_ndList(); } mdVariables.EventChangedControl = false; ImageCol.Clear(); ImageCol.AddImage(global::My.Resources.Resources.company_16x16); ImageCol.AddImage(global::My.Resources.Resources.organization_16x16); ImageCol.AddImage(global::My.Resources.Resources.group_people_16x16); ImageCol.AddImage(global::My.Resources.Resources.performer_16x16); ImageCol.AddImage(global::My.Resources.Resources.current_16x16); sender.ClearNodes(); sender.DataSource = mdQuery.iDataSet.Tables[TableName]; sender.KeyFieldName = "Id"; sender.ParentFieldName = "ParentId"; sender.StateImageList = ImageCol; sender.PopulateColumns(); mdHidenAllColumns.HidenAllColumns_TreeList(sender); sender.Columns["Name"].Visible = sender.Columns.Count != 0; }
/// <summary> /// 得到树状结构 /// </summary> /// <param name="treeList1"></param> /// <param name="TableID"></param> /// <param name="TopName"></param> public static void GetTree(DevExpress.XtraTreeList.TreeList treeList1, string TableID, string FieldName, string TopName) { try { treeList1.ClearNodes(); } catch { } string sSQL = "select * from SerialNumber where TableID='" + TableID + "' and Code='" + FieldName + "'"; DataTable dts = clsSQLCommond.ExecQuery(sSQL); string Code = dts.Rows[0]["Code"].ToString(); string Name = dts.Rows[0]["Name"].ToString(); sSQL = "select * from " + TableID + " order by " + Code; DataTable dt = clsSQLCommond.ExecQuery(sSQL); string 序列号规则 = 系统服务.序号.GetSerialNumberRules(TableID, FieldName); string[] 序列号规则数组 = 序列号规则.Split('-'); int top = 序列号规则数组[0].Length; object[] obj1 = new object[2]; obj1[0] = TopName; obj1[1] = ""; DevExpress.XtraTreeList.Nodes.TreeListNode tn1 = treeList1.AppendNode(obj1, null); tn1.Tag = ""; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i][Code].ToString().Length == top) { object[] obj = new object[2]; obj[0] = dt.Rows[i][Code].ToString().Trim(); obj[1] = dt.Rows[i][Name].ToString().Trim(); DevExpress.XtraTreeList.Nodes.TreeListNode tn = treeList1.AppendNode(obj, tn1); tn.Tag = dt.Rows[i][Code].ToString(); GetTreeNode(treeList1, tn, dt, Code, Name, 序列号规则数组, 1, top + 序列号规则数组[1].Length); tn.Expanded = true; } } tn1.Expanded = true; //if (treeList1.FocusedNode != null) //{ // try // { // treeList1.FocusedNode = null; // } // catch // { // } //} }
void FillItemTree() { treeList1.BeginUnboundLoad(); treeList1.ClearNodes(); try { foreach (Bar bar in barManager1.Bars) { FillItemBranch(treeList1.AppendNode(new object[] { bar.Text }, -1), bar.ItemLinks); } } finally { treeList1.EndUnboundLoad(); } }