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; } } } } }