protected void BindRole() { BLL.BASE_USER bll = new BLL.BASE_USER(); RoleList.Items.Clear(); ArrayList rid = bll.GetUserRoleArray(int.Parse(UID.Text)); string strwhere = ""; for (int i = 0; i < rid.Count; i++) { string[] r = rid[i].ToString().Split(','); RoleList.Items.Add(new ListItem(r[1], r[0])); strwhere += r[0] + ","; } if (strwhere != "") { OldRoleList.Text = strwhere.Substring(0, strwhere.Length - 1); strwhere = "not RoleID in(" + OldRoleList.Text + ")"; } BLL.BASE_ROLE bll2 = new BLL.BASE_ROLE(); FromRoleList.DataSource = bll2.GetRoleList(strwhere, ""); FromRoleList.DataTextField = "RoleName"; FromRoleList.DataValueField = "RoleID"; FromRoleList.DataBind(); }
protected void GetUser(int id) { BLL.BASE_USERGROUP ugbll = new BLL.BASE_USERGROUP(); DataView dvList = new DataView(ugbll.GetUserGroupList("").Tables[0]); LoadGroupList("0", 0, dvList); BLL.BASE_USER bll = new BLL.BASE_USER(); Entity.BASE_USER model = new Entity.BASE_USER(); model = bll.GetUserModel(id); uid.Text = id.ToString(); txt_name.Text = model.UserName; GroupList.SelectedValue = model.UserGroup.ToString(); txt_email.Text = model.Email; StateList.SelectedValue = model.Status.ToString(); Lab_time1.Text = model.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"); ArrayList rid = model.RoleID; for (int i = 0; i < rid.Count; i++) { string[] r = rid[i].ToString().Split(','); RoleList.Items.Add(new ListItem(r[1], r[0])); } //string stime = model.LastLoginTime.ToString("yyyy-MM-dd HH:mm:ss"); //if (stime != "0001-01-01 00:00:00") //{ // Lab_time2.Text = stime; //} }
protected void btn_saverole_Click(object sender, EventArgs e) { string s = Request.Form["TRoleList"].ToString(); BLL.BASE_USER bll = new BLL.BASE_USER(); ArrayList ar = new ArrayList(); //加加表 ArrayList dr = new ArrayList(); //删除表 if (s != "") { string[] str = s.Substring(0, s.Length - 1).Split(','); string[] ostr = OldRoleList.Text.ToString().Split(','); for (int i = 0; i < str.Length; i++) { if (!Smart.Utility.TypeParse.IsStringArray(str[i], ostr)) { //不存在则添加到插入记录列表 ar.Add(UID.Text + "," + str[i]); } } for (int i = 0; i < ostr.Length; i++) { if (!Smart.Utility.TypeParse.IsStringArray(ostr[i], str)) { //不存在则添加到删除记录列表 dr.Add(UID.Text + "," + ostr[i]); } } } else { //如果提交角色为空则删除该用户的所有角色 string[] ostr = OldRoleList.Text.ToString().Split(','); for (int i = 0; i < ostr.Length; i++) { //不存在则添加到删除记录列表 dr.Add(UID.Text + "," + ostr[i]); } } try { if (ar.Count != 0) { bll.addUserRole(ar); } if (dr.Count != 0) { bll.DeleteUserRole(dr); } BindRole(); } catch { } }
protected void Btn_ok_Click(object sender, EventArgs e) { BLL.BASE_USER bll = new BLL.BASE_USER(); Entity.BASE_USER model = new Entity.BASE_USER(); model.UserID = int.Parse(uid.Text); model.UserName = txt_name.Text; model.UserGroup = int.Parse(GroupList.SelectedItem.Value); model.Email = txt_email.Text; model.Status = int.Parse(StateList.SelectedItem.Value); if (bll.UpdateUser(model) >= 1) { strinfo.InnerHtml = Smart.Utility.JScript.errinfo("用户信息更新成功!"); strinfo.Visible = true; } else { strinfo.InnerHtml = Smart.Utility.JScript.errinfo("用户信息更新失败!"); strinfo.Visible = true; } }
/// <summary> /// 使用数据源初始化树节点 /// </summary> /// <param name="node">树节点</param> /// <param name="dt">数据源</param> private void InitTreeView(TreeNode node, DataTable dt) { /* * Text属性存储Name值 * Value存储Id值 * ToolTipText属性存储描述信息 * * Session["treetype"]存放TreeEnum枚举值 * Session["treetext"]存放当前选定节点Name值 * Session["treevalue"]存放当前当定节点Id值 */ foreach (DataRow dr in dt.Rows) { TreeNode subNode = new TreeNode(); //subNode.ShowCheckBox = true; //显示CheckBox subNode.Expanded = false; //节点折叠起来 switch (_TreeEnum) { //部门树 case Utility.TreeEnum.Department: if (dr["PARENTID"].ToString().Equals(node.Value)) { subNode.Text = dr["DPTNAME"].ToString(); subNode.Value = dr["DEPTID"].ToString(); subNode.ToolTip = dr["DPTINFO"].ToString(); //加入节点,继续递归循环 node.ChildNodes.Add(subNode); InitTreeView(subNode, dt); } break; //部门员工树 case Utility.TreeEnum.DepartmentAndEmployees: if (dr["PARENTID"].ToString().Equals(node.Value)) { subNode.Text = dr["DPTNAME"].ToString(); subNode.Value = dr["DEPTID"].ToString(); subNode.ToolTip = dr["DPTINFO"].ToString(); //获取部门DEPTID下员工并加入节点树(循环加入当前节点) DataTable empdt = new DataTable(); BLL.BASE_USER user = new BLL.BASE_USER(); empdt = user.GetList(string.Format("DEPTID={0}", subNode.Value)); foreach (DataRow userdr in empdt.Rows) { TreeNode userNode = new TreeNode(); userNode.Text = userdr["USERNAME"].ToString(); userNode.Value = userdr["USERID"].ToString(); userNode.ToolTip = userdr["PHONE"].ToString(); //用户加入部门节点 subNode.ChildNodes.Add(userNode); } //加入节点,继续递归循环 InitTreeView(subNode, dt); node.ChildNodes.Add(subNode); } break; //档案分类树 case Utility.TreeEnum.DocuemntClass: if (dr["PARENT"].ToString().Equals(node.Value)) { subNode.Text = dr["TYPENAME"].ToString(); subNode.Value = dr["ID"].ToString(); subNode.ToolTip = dr["SUMMARY"].ToString(); //加入节点,继续递归循环 InitTreeView(subNode, dt); node.ChildNodes.Add(subNode); } break; //菜单树 case Utility.TreeEnum.Menu: if (dr["PARENTID"].ToString().Equals(node.Value)) { subNode.Text = dr["MENUNAME"].ToString(); subNode.Value = dr["MENUID"].ToString(); subNode.ToolTip = dr["MENUINFO"].ToString(); //加入节点,继续递归循环 InitTreeView(subNode, dt); node.ChildNodes.Add(subNode); } break; } } }
/// <summary> /// 绑定用户信息 /// </summary> /// <param name="userId">用户ID</param> private void BindingUserInfo(int userId) { BLL.BASE_USER_ROLE userRoleBLL = new BLL.BASE_USER_ROLE(); var dt = userRoleBLL.GetList(userId); //获取用户权限集合 #region 绑定用户基本信息 BLL.BASE_USER userBLL = new BLL.BASE_USER(); Entity.BASE_USER userModel = new Entity.BASE_USER(); userModel = userBLL.GetUser(userId); this.BIRTHDAY = userModel.BIRTHDAY; this.DEGREE = userModel.DEGREE; this.DEPTID = userModel.DEPTID; this.FACE = userModel.FACE; this.IDNUMBER = userModel.IDNUMBER; this.JOBNUMBER = userModel.JOBNUMBER; this.PARENTID = userModel.PARENTID; this.PHONE = userModel.PHONE; this.PHOTO = userModel.PHONE; this.PROF = userModel.PROF; this.REMARK = userModel.REMARK; this.SEX = userModel.SEX; this.STSTUS = userModel.STSTUS; this.USERID = userModel.USERID; this.USERNAME = userModel.USERNAME; this.USERPWD = userModel.USERPWD; #endregion //绑定部门 BLL.BASE_DEPT deptBLL = new BLL.BASE_DEPT(); _Department = deptBLL.GetEntity(userModel.DEPTID); /* #region 绑定角色信息 * var roles = userRoleBLL.Query( * string.Format("SELECT distinct ROLEID FROM base_user_role WHERE userid = {0}", * userId.ToString())); * BLL.BASE_ROLE roleBll = new BLL.BASE_ROLE(); * foreach (DataRow dr in roles.Rows) { * Entity.BASE_ROLE roleModel = new Entity.BASE_ROLE(); * roleModel = roleBll.GetEntity(Convert.ToInt32(dr["ROLEID"])); * * Utility.UserRole role = new UserRole(); * role.ROLEID = roleModel.ROLEID; * role.ROLEINFO = roleModel.ROLEINFO; * role.ROLENAME = roleModel.ROLENAME; * #region 绑定菜单 * var menus = userRoleBLL.GetList(string.Format("USERID={0} AND ROLEID={1}", * userId.ToString(), * roleModel.ROLEID.ToString())); * BLL.BASE_MENU bllMenu = new BLL.BASE_MENU(); * foreach (DataRow menuDr in menus.Rows) { * Entity.BASE_MENU menuModel = new Entity.BASE_MENU(); * menuModel = bllMenu.GetEntity(Convert.ToInt32(menuDr["MENUID"])); * * Utility.UserMenu menu = new UserMenu(); * menu.ICON = menuModel.ICON; * menu.MENUID = menuModel.MENUID; * menu.MENUINFO = menuModel.MENUINFO; * menu.MENUNAME = menuModel.MENUNAME; * menu.MENUURL = menuModel.MENUURL; * menu.PARENTID = menuModel.PARENTID; * menu.STATUS = menuModel.STATUS; * #region 绑定菜单的Action * var actions = userRoleBLL.GetList(string.Format("USERID={0} AND ROLEID={1} AND MENUID={2}", * userId.ToString(), * roleModel.ROLEID.ToString(), * menu.MENUID.ToString())); * BLL.BASE_ACTION actionBLL = new BLL.BASE_ACTION(); * foreach (DataRow actionDr in actions.Rows) { * Entity.BASE_ACTION actionModel = new Entity.BASE_ACTION(); * actionModel = actionBLL.GetEntity(Convert.ToInt32(actionDr["ACTIONID"].ToString())); * * menu.UserAction.Add(actionModel); //动作信息加载菜单中 * } #endregion * * role.UserMenu.Add(menu); //菜单加入角色组中 * } #endregion * * UserRole.Add(role); //角色组加入集合中 * } #endregion */ }