private void queryGroup()
{
DataSet inBlock = new DataSet();
inBlock.Tables.Add();
DataRow dr = inBlock.Tables[0].NewRow();
inBlock.Tables[0].Columns.Add("groupname");
inBlock.Tables[0].Columns.Add("adminuser");
inBlock.Tables[0].Columns.Add("userid");
inBlock.Tables[0].Columns.Add("appname");
inBlock.Tables[0].Columns.Add("grouptype");
dr["groupname"] = eftGroupName.Text;
dr["adminuser"] = "";// eftGroupAdmin.Text;
dr["userid"] = CConstString.UserId;
dr["appname"] = CConstString.AppName;
dr["grouptype"] = 1;
inBlock.Tables[0].Rows.Add(dr);
//调用SERVICE
DataTable outBlock = DbUserInfo.QueryGroupInfo(inBlock, CConstString.ConnectName);
outBlock.AcceptChanges();
efDevGridGroupInfo.DataSource = outBlock;
gridViewGroupInfo.BestFitColumns();
}
private void treeListUser_DoubleClick(object sender, EventArgs e)
{
TreeListNode node = treeListUser.FocusedNode;
if (node == null)
{
return;
}
node.Nodes.Clear();
string memberid = "";
if (node.Tag != null)
{
memberid = node.Tag.ToString();
}
else
{
memberid = node.GetValue("ID").ToString();
}
// if (node.ImageIndex == USERICON)
// else if (node.ImageIndex == GROUPICON)
DataSet inblk = new DataSet();
inblk.Tables.Add();
inblk.Tables[0].Columns.Add("memberid");
inblk.Tables[0].Columns.Add("appname");
inblk.Tables[0].Rows.Add(memberid, CConstString.AppName);
//查询用户所属/所管理的群组
DataTable outblk = DbUserInfo.QueryGroupByMember(inblk, CConstString.ConnectName);
for (int i = 0; i < outblk.Rows.Count; i++)
{
string groupId = outblk.Rows[i]["id"].ToString();
string groupName = outblk.Rows[i]["name"].ToString();
string groupDesc = outblk.Rows[i]["groupdescription"].ToString();
TreeListNode treeNode;
treeNode = this.treeListUser.AppendNode(new object[3], node);
node.Nodes[i].SetValue(0, groupId);
node.Nodes[i].SetValue(1, groupName);
node.Nodes[i].SetValue(2, groupDesc);
treeNode.Tag = groupId;
treeNode.ImageIndex = treeNode.SelectImageIndex = GROUPICON;
}
treeListUser.FocusedNode.ExpandAll();
}
//查询群组的子组和子用户
private void queryMember(TreeListNode parentNode)
{
parentNode.Nodes.Clear();
DataSet inBlock = new DataSet();
inBlock.Tables.Add();
inBlock.Tables[0].Columns.Add("groupid");
inBlock.Tables[0].Rows.Add(((List <string>)parentNode.Tag)[1]);
//调用SERVICE
DataSet outBlock = DbUserInfo.QueryGroupChild(inBlock, CConstString.ConnectName);
//返回子组
string groupName = "";
string groupDesc = "";
string groupID = "";
for (int i = 0; i < outBlock.Tables[0].Rows.Count; i++)
{
groupName = outBlock.Tables[0].Rows[i]["name"].ToString();
groupDesc = outBlock.Tables[0].Rows[i]["groupdescription"].ToString();
groupID = outBlock.Tables[0].Rows[i]["id"].ToString();
TreeListNode treeNode = this.treeListMain.AppendNode(new object[] { groupName + "(" + groupDesc + ")", " " }, parentNode);
treeNode.Tag = new List <string>();
((List <string>)treeNode.Tag).Add(groupName);
((List <string>)treeNode.Tag).Add(groupID);
treeNode.SelectImageIndex = treeNode.ImageIndex = GROUPICON;
}
////返回子用户
string ename = "";
string cname = "";
string userid = "";
string dept = "";
for (int i = 0; i < outBlock.Tables[1].Rows.Count; i++)
{
ename = outBlock.Tables[1].Rows[i]["ename"].ToString();
cname = outBlock.Tables[1].Rows[i]["cname"].ToString();
userid = outBlock.Tables[1].Rows[i]["id"].ToString();
TreeListNode treeNode = this.treeListMain.AppendNode(new object[] { ename + "(" + cname + ")", dept }, parentNode);
treeNode.Tag = new List <string>();
((List <string>)treeNode.Tag).Add(ename);
((List <string>)treeNode.Tag).Add(userid);
treeNode.SelectImageIndex = treeNode.ImageIndex = USERICON;
}
}
private void QryUser_Click(object sender, EventArgs e)
{
this.treeListUser.Nodes.Clear();
DataTable outblk = DbUserInfo.QueryUserInfo(new DataSet(), CConstString.ConnectName);;
treeListUser.DataSource = outblk;
for (int i = 0; i < treeListUser.Nodes.Count; i++)
{
treeListUser.Nodes[i].SelectImageIndex = treeListUser.Nodes[i].ImageIndex = USERICON;
}
}
private void itemDeleteFromGroup_Click(object sender, EventArgs e)
{
if (this.treeListMain.FocusedNode == null || this.treeListMain.FocusedNode.ParentNode == null)
{
return;
}
if (this.treeListMain.FocusedNode.Tag == null || this.treeListMain.FocusedNode.ParentNode.Tag == null)
{
return;
}
if (treeListMain.Selection.Count == 0)
{
return;
}
DataSet inBlock = new DataSet();
inBlock.Tables.Add();
inBlock.Tables[0].Columns.Add("groupid");
inBlock.Tables[0].Columns.Add("user");
inBlock.Tables[0].Rows.Add(((List <string>)parent.Tag)[1], CConstString.UserId);
//子组
inBlock.Tables.Add("childgroup");
inBlock.Tables[1].Columns.Add("id");
for (int i = 0; i < this.treeListMain.Selection.Count; i++)
{
//子组节点
if (this.treeListMain.Selection[i].ImageIndex == GROUPICON)
{
inBlock.Tables[1].Rows.Add(((List <string>) this.treeListMain.Selection[i].Tag)[1]);
}
}
//子用户
inBlock.Tables.Add("childuser");
inBlock.Tables[2].Columns.Add("id");
for (int i = 0, j = 1; i < this.treeListMain.Selection.Count; i++)
{
//子用户节点
if (this.treeListMain.Selection[i].ImageIndex == USERICON)
{
inBlock.Tables[2].Rows.Add(((List <string>) this.treeListMain.Selection[i].Tag)[1]);
}
}
DbUserInfo.DeleteGroupMember(inBlock, CConstString.ConnectName);
queryMember(parent);
parent = null;
}
//查询群组的子组和子用户
private void queryMember(TreeListNode parentNode)
{
parentNode.Nodes.Clear();
DataSet inBlock = new DataSet();
inBlock.Tables.Add();
inBlock.Tables[0].Columns.Add("groupname");
inBlock.Tables[0].Rows.Add(((List <string>)parentNode.Tag)[0]);
//调用SERVICE
DataSet outBlock = DbUserInfo.QueryGroupChild(inBlock, CConstString.ConnectName);
}
private void efDevGridUserInfo_DoubleClick(object sender, EventArgs e)
{
try
{
if (this.gridViewUserInfo.RowCount == 0 || this.gridViewUserInfo.FocusedRowHandle < 0)
{
return;
}
string userid = "";
string userDesc = "";
if (this.gridViewUserInfo.GetRowCellValue(gridViewUserInfo.FocusedRowHandle, "ID") != null)
{
userid = gridViewUserInfo.GetRowCellValue(gridViewUserInfo.FocusedRowHandle, "ID").ToString();
}
if (gridViewUserInfo.GetRowCellValue(gridViewUserInfo.FocusedRowHandle, "CNAME") != null)
{
userDesc = gridViewUserInfo.GetRowCellValue(gridViewUserInfo.FocusedRowHandle, "CNAME").ToString();
}
layoutControlGroup4.Text = "用户[" + userDesc + "]所在群组";
this.treeListMain.Nodes.Clear();
DataSet blk = new DataSet();
blk.Tables.Add();
blk.Tables[0].Columns.Add("memberid");
blk.Tables[0].Rows.Add(userid);
DataTable dt = DbUserInfo.QueryGroupByMember(blk, CConstString.ConnectName);
if (dt != null && dt.Rows.Count > 0)
{
string groupDesc = "";
string groupName = "";
List <string> tag = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
groupName = dt.Rows[i]["NAME"].ToString();
groupDesc = dt.Rows[i]["GROUPDESCRIPTION"].ToString();
tag.Add(groupName);
tag.Add(dt.Rows[i]["ID"].ToString());
this.treeListMain.AppendNode(new object[] { groupName + "(" + groupDesc + ")" }, null, tag);
}
this.treeListMain.ExpandAll();
}
}
catch (Exception ex)
{
EFMessageBox.Show(ex.Message);
}
}
private DataTable QueryUser()
{
DataSet inblk = new DataSet();
inblk.Tables.Add();
inblk.Tables[0].Columns.Add("CNAME");
inblk.Tables[0].Rows.Add(txtCName.Text.Trim());
DataTable outblk = DbUserInfo.QueryUserInfo(inblk, CConstString.ConnectName);
efDevGridUserInfo.DataSource = outblk;
outblk.AcceptChanges();
//gridViewUserInfo_FocusedRowChanged(null, null);
return(outblk);
}
private DataTable queryGroup()
{
DataSet inBlock = new DataSet();
inBlock.Tables.Add();
DataRow dr = inBlock.Tables[0].NewRow();
inBlock.Tables[0].Columns.Add("groupname");
inBlock.Tables[0].Columns.Add("adminuser");
inBlock.Tables[0].Columns.Add("userid");
inBlock.Tables[0].Columns.Add("appname");
inBlock.Tables[0].Columns.Add("grouptype");
dr["groupname"] = "";
dr["adminuser"] = "";
dr["userid"] = CConstString.UserId;
dr["appname"] = CConstString.AppName;
dr["grouptype"] = 1;
inBlock.Tables[0].Rows.Add(dr);
//调用SERVICE
DataTable outBlock = DbUserInfo.QueryGroupInfo(inBlock, CConstString.ConnectName);
return(outBlock);
}
private void treeListGroup_DoubleClick(object sender, EventArgs e)
{
TreeListNode node = treeListGroup.FocusedNode;
if (node == null || node.ImageIndex == USERICON)
{
return;
}
node.Nodes.Clear();
treeListGroup.ClearSorting();
DataSet inBlock = new DataSet();
inBlock.Tables.Add();
inBlock.Tables[0].Columns.Add("groupid");
inBlock.Tables[0].Rows.Add(node.GetValue("ID"));
//调用SERVICE
DataSet outBlock = DbUserInfo.QueryGroupChild(inBlock, CConstString.ConnectName);
string groupName = "";
string groupDesc = "";
string groupId = "";
int i = 0;
for (i = 0; i < outBlock.Tables[0].Rows.Count; i++)
{
groupId = outBlock.Tables[0].Rows[i]["id"].ToString();
groupName = outBlock.Tables[0].Rows[i]["name"].ToString();
groupDesc = outBlock.Tables[0].Rows[i]["groupdescription"].ToString();
TreeListNode treeNode;
treeNode = this.treeListGroup.AppendNode(new object[3], node, CheckState.Checked);
node.Nodes[i].SetValue(0, groupId);
node.Nodes[i].SetValue(1, groupName);
node.Nodes[i].SetValue(2, groupDesc);
treeNode.Tag = groupId;
treeNode.ImageIndex = treeNode.SelectImageIndex = GROUPICON;
}
string ename = "";
string cname = "";
string id = "";
for (int j = 0; j < outBlock.Tables[1].Rows.Count; j++)
{
id = outBlock.Tables[1].Rows[j]["id"].ToString();
ename = outBlock.Tables[1].Rows[j]["ename"].ToString();
cname = outBlock.Tables[1].Rows[j]["cname"].ToString();
TreeListNode treeNode = this.treeListGroup.AppendNode(new object[3], node, CheckState.Indeterminate);
node.Nodes[i + j].SetValue(0, id);
node.Nodes[i + j].SetValue(1, ename);
node.Nodes[i + j].SetValue(2, cname);
treeNode.Tag = id;
treeNode.SelectImageIndex = treeNode.ImageIndex = USERICON;
}
treeListGroup.FocusedNode.ExpandAll();
}
private void treeListMain_DragDrop(object sender, DragEventArgs e)
{
try
{
DevExpress.XtraTreeList.TreeListHitInfo hi = treeListMain.CalcHitInfo(treeListMain.PointToClient(new Point(e.X, e.Y)));
TreeListNode parentNode = null;
//拖拽至用户节点
if (hi.Node.ImageIndex == USERICON)
{
parentNode = hi.Node.ParentNode;
}
//拖拽至群组节点
else if (hi.Node.ImageIndex == GROUPICON)
{
parentNode = hi.Node;
}
DataSet inBlock = new DataSet();
inBlock.Tables.Add();
//为群组新增子组
if (tabbedControlGroup1.SelectedTabPage == layoutControlGroup3)
{
string parentGroup = ((List <string>)parentNode.Tag)[0];
if (parentGroup == "admingroup" ||
parentGroup == "formgroup" ||
parentGroup == "usermanager" ||
parentGroup == "groupmanager" ||
parentGroup == "resourcemanager")
{
EFMessageBox.Show(EP.EPES.EPESC0000193 /*系统群组下不可挂子组，请将角色用户直接添加到该组下！*/, EP.EPES.EPESC0000024 /*提示*/, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
inBlock.Tables[0].Columns.Add("ID");
inBlock.Tables[0].Columns.Add("userid");
string groupid = ((List <string>)parentNode.Tag)[1];
inBlock.Tables[0].Rows.Add(groupid, CConstString.UserId);
inBlock.Tables.Add();
inBlock.Tables[1].Columns.Add("ID");
for (int i = 0; i < this.gridViewGroupInfo.RowCount; i++)
{
if (efDevGridGroupInfo.GetSelectedColumnChecked(i))
{
string tmp = this.gridViewGroupInfo.GetRowCellValue(i, "ID").ToString();
if (groupid == tmp)
{
throw new Exception("拖动的组与父组一样.");
}
inBlock.Tables[1].Rows.Add(tmp);
}
}
string msg = DbUserInfo.InsertGroupChildGroup(inBlock, CConstString.ConnectName);
if (msg == "ok")
{
queryMember(parentNode);
//取消列表框中所有checkbox选中状态
UnCheckAll(efDevGridGroupInfo, gridViewGroupInfo);
}
}
//为群组新增子用户
else if (tabbedControlGroup1.SelectedTabPage == layoutControlGroup2)
{
inBlock.Tables[0].Columns.Add("groupid");
inBlock.Tables[0].Columns.Add("groupname");
inBlock.Tables[0].Columns.Add("user");
inBlock.Tables[0].Columns.Add("authmode");
inBlock.Tables[0].Rows.Add(((List <string>)parentNode.Tag)[1], ((List <string>)parentNode.Tag)[0], CConstString.UserId, 0);
inBlock.Tables.Add();
inBlock.Tables[1].Columns.Add("userid");
inBlock.Tables[1].Columns.Add("username");
for (int i = 0; i < this.gridViewUserInfo.RowCount; i++)
{
if (efDevGridUserInfo.GetSelectedColumnChecked(i))
{
inBlock.Tables[1].Rows.Add(this.gridViewUserInfo.GetRowCellValue(i, "ID"), this.gridViewUserInfo.GetRowCellValue(i, "ENAME"));
}
}
DbUserInfo.InsertGroupChildUser(inBlock, CConstString.ConnectName);
queryMember(parentNode);
// 取消列表框中所有checkbox选中状态
UnCheckAll(efDevGridUserInfo, gridViewUserInfo);
}
treeListMain.OptionsBehavior.DragNodes = false;
}
catch (Exception ex)
{
EFMessageBox.Show(ex.Message + ex.StackTrace);
}
}
//保存
private bool SaveUserInfo()
{
DataTable dt = efDevGridUserInfo.DataSource as DataTable;
if (dt == null || dt.Rows.Count < 1)
{
return(false);
}
DataTable instable = dt.Clone();
DataTable deltable = dt.GetChanges(DataRowState.Deleted);
DataTable updtable = dt.Clone();
DataRow dr = null;
for (int rowIndex = 0; rowIndex < gridViewUserInfo.RowCount; ++rowIndex)
{
if (efDevGridUserInfo.GetSelectedColumnChecked(rowIndex))
{
dr = gridViewUserInfo.GetDataRow(rowIndex);
if (dr.RowState == DataRowState.Added)
{
instable.Rows.Add(dr.ItemArray);
}
else if (dr.RowState == DataRowState.Modified)
{
updtable.Rows.Add(dr.ItemArray);
}
}
}
CheckSameValue(instable, "ename");
deltable = dt.GetChanges(DataRowState.Deleted);
DataSet inBlock = new DataSet();
inBlock.Tables.Add();
inBlock.Tables[0].Columns.Add("userid");
inBlock.Tables[0].Columns.Add("appname");
inBlock.Tables[0].Rows.Add(CConstString.UserId, CConstString.AppName);
if (instable != null && instable.Rows.Count > 0)
{
instable.TableName = "INSERT_BLOCK";
inBlock.Tables.Add(instable);
}
if (deltable != null && deltable.Rows.Count > 0)
{
deltable.RejectChanges();
deltable.TableName = "DELETE_BLOCK";
inBlock.Tables.Add(deltable);
}
if (updtable != null && updtable.Rows.Count > 0)
{
updtable.TableName = "UPDATE_BLOCK";
inBlock.Tables.Add(updtable);
}
if (inBlock.Tables.Count > 1)
{
DbUserInfo.SaveUserInfo(inBlock, CConstString.ConnectName);
}
return(true);
}
