private DataTable CallSelectService(string name, string fname, long treeno, long mode, string cursystem) { DataSet inBlock = new DataSet(); inBlock.Tables.Add(); inBlock.Tables[0].Columns.Add("name"); inBlock.Tables[0].Columns.Add("fname"); inBlock.Tables[0].Columns.Add("treeno"); inBlock.Tables[0].Columns.Add("mode"); inBlock.Tables[0].Columns.Add("cursystem"); inBlock.Tables[0].Rows.Add(name, fname, treeno, mode, cursystem); DataTable outBlock = DbTreeInfo.QueryTreeNode(inBlock, CConstString.ConnectName); return(outBlock); }
//节点排序 private void OrderNodes(TreeListNode parent) { DataSet inBlock = new DataSet(); inBlock.Tables.Add(); inBlock.Tables[0].Columns.Add("name"); inBlock.Tables[0].Columns.Add("treeseq"); for (int i = 0; i < parent.Nodes.Count; i++) { inBlock.Tables[0].Rows.Add(parent.Nodes[i].Tag, i.ToString("d3")); } int flag = DbTreeInfo.UpdateTreeNode(inBlock, CConstString.ConnectName);// EI.EITuxedo.CallService("epestree_upds", inBlock); if (flag == 0) { queryChildNodes(parent); } }
private void treeList_DragDrop(object sender, DragEventArgs e) { if (!isManageMode) { e.Effect = DragDropEffects.None; EF.EFMessageBox.Show(EP.EPES.EPESC0000071 /*操作失败!请进入维护模式进行排序操作!*/, EP.EPES.EPESC0000024 /*提示*/, MessageBoxButtons.OK, MessageBoxIcon.Error); TreeListNode parent = treeList.FocusedNode.ParentNode; queryChildNodes(parent); return; } DevExpress.XtraTreeList.TreeListHitInfo hi = treeList.CalcHitInfo(treeList.PointToClient(new Point(e.X, e.Y))); string[] format = e.Data.GetFormats(); //拖拽的是菜单树中的节点——节点排序 if (format[0] == "DevExpress.XtraTreeList.Nodes.TreeListNode") { if (hi != null) { if (hi.Node != null) { TreeListNode dragnode = e.Data.GetData(typeof(TreeListNode)) as TreeListNode; TreeListNode targetnode = hi.Node; treeList.SetNodeIndex(dragnode, treeList.GetNodeIndex(targetnode)); OrderNodes(hi.Node.ParentNode); } } e.Effect = DragDropEffects.None; } //拖拽的是画面信息列表框中的行——新增画面 else { TreeListNode parentNode = null; int treeseq = 0; //拖拽至画面节点 if (hi.Node.ImageIndex == FORMICON) { parentNode = hi.Node.ParentNode; } //拖拽至目录节点 else { parentNode = hi.Node; } treeseq = parentNode.Nodes.Count; //新增画面 DataSet inBlock = new DataSet(); inBlock.Tables.Add(); inBlock.Tables[0].Columns.Add("fname"); inBlock.Tables[0].Columns.Add("name"); inBlock.Tables[0].Columns.Add("resname"); inBlock.Tables[0].Columns.Add("description"); inBlock.Tables[0].Columns.Add("shortcut"); inBlock.Tables[0].Columns.Add("treeno"); inBlock.Tables[0].Columns.Add("treeseq"); inBlock.Tables[0].Columns.Add("userid"); for (int i = 0, j = 1; i < this.gridViewFormInfo.RowCount; i++) { //取出选中行 if (fgDevGridFormInfo.GetSelectedColumnChecked(i)) { if (treeseq > 999) { EFMessageBox.Show(EP.EPES.EPESC0000072 /*新增失败*/, EP.EPES.EPESC0000024 /*提示*/, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } DataRow dr = inBlock.Tables[0].NewRow(); dr["name"] = parentNode.Tag + gridViewFormInfo.GetRowCellValue(i, "NAME").ToString(); dr["description"] = parentNode.Tag + gridViewFormInfo.GetRowCellValue(i, "DESCRIPTION").ToString(); dr["resname"] = parentNode.Tag + gridViewFormInfo.GetRowCellValue(i, "NAME").ToString(); dr["fname"] = parentNode.Tag; dr["shortcut"] = " "; dr["treeno"] = 0; dr["treeseq"] = treeseq.ToString("d3"); treeseq++; j++; } } int flag = DbTreeInfo.AddTreeNode(inBlock, CConstString.ConnectName); if (flag == 0) { queryChildNodes(parentNode); //取消列表框中所有checkbox选中状态 for (int k = 0; k < gridViewFormInfo.DataRowCount; k++) { fgDevGridFormInfo.SetSelectedColumnChecked(k, false);// gridViewFormInfo..SetRowCellValue(k, gridColumnFormCheck, false); } this.gridViewFormInfo.Invalidate(); } } }