private void databind()
{
int listN = 0;
//生成群组list
using (DbDataReader reader = GroupManage.Groupinfo())
{
while (reader.Read())
{
cblUsergroup.Items.Add(new ListItem(reader["name"].ToString(), reader["id"].ToString()));
//cblUsergroup.Items[listN++].Selected = true;
}
}
//userinfo
//DataTable dt = Userdata.GetUserinfo(Request.QueryString["id"].ToString());
//if (dt.Rows.Count > 0)
//{
// foreach (DataRow dr in dt.Rows)
// {
// txtID.Text =
// dr["id"].ToString();
// txtName.Text = dr["name"].ToString();
// txtStation.Text = dr["station"].ToString();
// txtWorkShop.Text = dr["workshop"].ToString();
// txtClass.Text = dr["class"].ToString();
// }
//}
//int a = cblUsergroup.Items.Count;
//usergroup
//dt = Userdata.GetUserGroup(Request.QueryString["id"].ToString());
//if (dt.Rows.Count > 0)
//{
// foreach (DataRow dr1 in dt.Rows)
// {
// for (int i = 0; i < cblUsergroup.Items.Count; i++)
// {
// if (dr1["name"].ToString() == cblUsergroup.Items[i].ToString())
// {
// cblUsergroup.Items[i].Selected = true;
// }
// }
// }
//}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
//设置user群组
GroupManage.delPermission(Groupid);//Userdata.deleteUsergroup(userID);
for (int i = 0; i < cblPermission.Items.Count; i++)
{
if (cblPermission.Items[i].Selected == true)
{
GroupManage.addPermission(Groupid, cblPermission.Items[i].Value);
//Userdata.addUsergroup(Groupid, cblPermission.Items[i].Value);
}
}
}
private void databind()
{
string sql = "select * from tgroup where 1=1 ";
if (txtGroup.Text != string.Empty)
{
sql = sql + "and name = '" + txtGroup.Text + "';";
}
DataTable dt = GroupManage.Query(sql);
this.GroupGrd.DataSource = dt;
this.GroupGrd.DataBind();
}
private void databind()
{
//生成权限list
using (DbDataReader reader = GroupManage.Premissioninfo())
{
while (reader.Read())
{
this.cblPermission.Items.Add(new ListItem(reader["powername"].ToString(), reader["id"].ToString()));
}
}
//显示群组信息
using (DbDataReader readerGroup = GroupManage.getGroupinfo(Groupid))
{
if (readerGroup.Read())
{
txtGroup.Text = readerGroup["name"].ToString();
}
}
//显示群组成员
this.Usergrd.DataSource = GroupManage.getGroupUser(Groupid);
this.Usergrd.DataBind();
//群组权限
DataTable dt = GroupManage.getGroupPermission(Groupid);//Userdata.GetUserGroup(userID);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr1 in dt.Rows)
{
for (int i = 0; i < cblPermission.Items.Count; i++)
{
if (dr1["powername"].ToString() == cblPermission.Items[i].ToString())
{
cblPermission.Items[i].Selected = true;
}
}
}
}
}
