Пример #1
0
 protected void Button3_Click(object sender, EventArgs e)
 {
     int UserID = (int)Common.sink(DropDownList1.UniqueID, MethodType.Post, 255, 1, DataType.Int);
     UserData.Move_UserPermissionCache(UserID);
     sys_UserRolesTable su = new sys_UserRolesTable();
     su.DB_Option_Action_ = "Insert";
     su.R_RoleID = RoleID;
     su.R_UserID = UserID;
     BusinessFacade.sys_UserRolesInsertUpdate(su);
     EventMessage.MessageBox(1, "操作成功", string.Format("从角色ID:{0}中增加用户ID:{1}成功!", RoleID, UserID), Icon_Type.OK, Common.GetHomeBaseUrl(string.Format("RoleManager.aspx?RoleID={0}&CMD=Look", RoleID)));
 }
Пример #2
0
 /// <summary>
 /// 新增/删除/修改 sys_UserRoles
 /// </summary>
 /// <param name="fam">sys_UserRolesTable实体类</param>
 /// <returns>返回0操正常</returns>
 public override int sys_UserRolesInsertUpdate(sys_UserRolesTable fam)
 {
     int rInt = 0;
     using (SqlConnection Conn = GetSqlConnection())
     {
         SqlCommand cmd = new SqlCommand("sys_UserRolesInsertUpdateDelete", Conn);
         cmd.CommandType = CommandType.StoredProcedure;
         //设置参数
         cmd.Parameters.Add("@DB_Option_Action_", SqlDbType.NVarChar).Value = fam.DB_Option_Action_; //操作方法 Insert:增加 Update:修改 Delete:删除 Disp:显示单笔记录
         cmd.Parameters.Add("@R_UserID", SqlDbType.Int).Value = fam.R_UserID;  //用户ID与sys_User表中UserID相关
         cmd.Parameters.Add("@R_RoleID", SqlDbType.Int).Value = fam.R_RoleID;  //用户所属角色ID与Sys_Roles关联
         Conn.Open();
         rInt = Convert.ToInt32(cmd.ExecuteScalar());
         cmd.Dispose();
         Conn.Dispose();
         Conn.Close();
     }
     return rInt;
 }
Пример #3
0
        /// <summary>
        /// 保存用户角色信息
        /// </summary>
        private void SaveRoles(int UserID)
        {
            

            UserData.Move_UserPermissionCache(UserID);
            ArrayList lst = BusinessFacade.sys_UserRolesDisp(UserID);
            foreach (sys_UserRolesTable var in lst)
            {
                if (BusinessFacade.sys_Roles_CheckUser(var.R_RoleID))
                {
                    var.DB_Option_Action_ = "Delete";
                    BusinessFacade.sys_UserRolesInsertUpdate(var);
                }
            }

            sys_UserRolesTable urt = new sys_UserRolesTable();
            urt.DB_Option_Action_ = "Insert";
            urt.R_UserID = UserID;
            foreach (ListItem var in MultiListBox1.SecondListBox.Items)
            {
                urt.R_RoleID = Convert.ToInt32(var.Value);
                if (BusinessFacade.sys_Roles_CheckUser(urt.R_RoleID))
                {                   
                    BusinessFacade.sys_UserRolesInsertUpdate(urt);
                }
            }
        }
Пример #4
0
        /// <summary>
        /// 绑定按钮
        /// </summary>
        private void BindButton()
        {
            switch (CMD)
            {
                case "New":
                    CMD_Txt = "增加";
                    HiddenDisp();
                    TopTr.Visible = false;
                    break;
                case "Edit":
                    CMD_Txt = "修改";
                    HiddenDisp();
                    HeadMenuButtonItem Bm0 = new HeadMenuButtonItem();
                    Bm0.ButtonPopedom = PopedomType.List;
                    Bm0.ButtonUrl = string.Format("?CMD=Look&RoleID={0}", RoleID);
                    Bm0.ButtonIcon = "back.gif";
                    Bm0.ButtonName = "返回";
                    HeadMenuWebControls1.ButtonList.Add(Bm0);
                    HeadMenuButtonItem Bm1 = new HeadMenuButtonItem();
                    Bm1.ButtonPopedom = PopedomType.Delete;
                    Bm1.ButtonUrlType = UrlType.JavaScript;
                    Bm1.ButtonUrl = string.Format("DelData('?CMD=Delete&RoleID={0}')", RoleID);
                    HeadMenuWebControls1.ButtonList.Add(Bm1);
                    break;
                case "Look":
                    HiddenInput();
                    HeadMenuButtonItem Bm2 = new HeadMenuButtonItem();
                    Bm2.ButtonPopedom = PopedomType.Edit;
                    Bm2.ButtonUrl = string.Format("?CMD=Edit&RoleID={0}", RoleID);
                    HeadMenuWebControls1.ButtonList.Add(Bm2);
                    break;
                case "Delete":
                    CMD_Txt = "删除";
                    sys_RolesTable sat = new sys_RolesTable();
                    sat.RoleID = RoleID;
                    sat.DB_Option_Action_ = CMD;
                    BusinessFacade.sys_RolesInsertUpdate(sat);
                    BusinessFacade.sys_RoleApplication_Move(RoleID);
                    BusinessFacade.sys_RolePermission_Move(RoleID);
                    UserData.Move_RoleUserPermissionCache(RoleID);                  

                    EventMessage.MessageBox(1, "操作成功", "删除记录ID:(" + RoleID + ")成功!", Icon_Type.OK, Common.GetHomeBaseUrl("RoleList.aspx"));
                    break;
                case "Move":
                    sys_RoleApplicationTable rt = new sys_RoleApplicationTable();
                    rt.A_ApplicationID = (int)Common.sink("ApplicationID", MethodType.Get, 255, 1, DataType.Int);
                    rt.A_RoleID = RoleID;
                    rt.DB_Option_Action_ = "Delete";
                    BusinessFacade.sys_RoleApplicationInsertUpdate(rt);

                    BusinessFacade.sys_RolePermission_Move(rt.A_RoleID, rt.A_ApplicationID);
                    UserData.Move_RoleUserPermissionCache(RoleID);
                    EventMessage.MessageBox(1, "操作成功", "移除应用ID:(" + rt.A_ApplicationID + ")成功!", Icon_Type.OK, Common.GetHomeBaseUrl(string.Format("RoleManager.aspx?RoleID={0}&CMD=Look", RoleID)));
                    break;
                case "MoveUser":
                    //检测删除权限
                    FrameWorkPermission.CheckPermissionVoid(PopedomType.Delete);
                    int UserID = (int)Common.sink("UserID", MethodType.Get, 255, 1, DataType.Int);
                    UserData.Move_UserPermissionCache(UserID);
                    sys_UserRolesTable su = new sys_UserRolesTable();
                    su.DB_Option_Action_ = "Delete";
                    su.R_RoleID = RoleID;
                    su.R_UserID = UserID;
                    BusinessFacade.sys_UserRolesInsertUpdate(su);
                    EventMessage.MessageBox(1, "操作成功", string.Format("从角色ID:{0}中移除用户ID:{1}成功!",RoleID,UserID), Icon_Type.OK, Common.GetHomeBaseUrl(string.Format("RoleManager.aspx?RoleID={0}&CMD=Look", RoleID)));
                    break;
                    
            }
            All_Title_Txt = CMD_Txt + App_Txt;
            HeadMenuWebControls1.HeadOPTxt = TabOptionItem1.Tab_Name = All_Title_Txt;
        }
Пример #5
0
        /// <summary>
        /// 将记录集转为sys_UserRolesTable实体类
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <returns>sys_UserRolesTable</returns>
        protected object Populatesys_UserRoles(IDataReader dr)
        {
            sys_UserRolesTable nc = new sys_UserRolesTable();

            if (!Convert.IsDBNull(dr["R_UserID"])) nc.R_UserID = Convert.ToInt32(dr["R_UserID"]); // 用户ID与sys_User表中UserID相关
            if (!Convert.IsDBNull(dr["R_RoleID"])) nc.R_RoleID = Convert.ToInt32(dr["R_RoleID"]); // 用户所属角色ID与Sys_Roles关联
            return nc;
        }
Пример #6
0
 /// <summary>
 /// 新增/删除/修改 sys_UserRoles
 /// </summary>
 /// <param name="fam">sys_UserRolesTable实体类</param>
 /// <returns>返回0操正常</returns>
 public abstract int sys_UserRolesInsertUpdate(sys_UserRolesTable fam);
Пример #7
0
 /// <summary>
 /// 根据角色ID,返回 sys_UserRolesTable实体类 集合
 /// </summary>
 /// <param name="roleid">角色ID</param>
 /// <returns>返回sys_UserRolesTable实体类 为0则无记录</returns>
 public static ArrayList sys_UserRolesList(int roleid)
 {
     sys_UserRolesTable fam = new sys_UserRolesTable();
     QueryParam qp = new QueryParam();
     qp.PageIndex = 1;
     qp.Where = " Where sys_UserRoles.R_RoleID = " + roleid.ToString();
     int RecordCount = 0;
     return sys_UserRolesList(qp, out RecordCount);
 }
Пример #8
0
 /// <summary>
 /// 根据ID返回 sys_UserRolesTable实体类 单笔资料
 /// </summary>
 /// <param name="R_UserID"></param>
 /// <param name="R_RoleID"></param>
 /// <returns>返回sys_UserRolesTable实体类 为0则无记录</returns>
 public static sys_UserRolesTable sys_UserRolesDisp(int R_UserID, int R_RoleID)
 {
     sys_UserRolesTable fam = new sys_UserRolesTable();
     QueryParam qp = new QueryParam();
     qp.PageIndex = 1;
     qp.PageSize = 1;
     qp.Where = " Where sys_UserRoles.R_UserID = " + R_UserID.ToString() + " and sys_UserRoles.R_RoleID=" + R_RoleID.ToString();
     int RecordCount = 0;
     ArrayList lst = sys_UserRolesList(qp, out RecordCount);
     if (RecordCount > 0)
     {
         fam = (sys_UserRolesTable)lst[0];
     }
     return fam;
 }
Пример #9
0
 /// <summary>
 /// 新增/删除/修改 sys_UserRoles
 /// </summary>
 /// <param name="fam">sys_UserRolesTable实体类</param>
 /// <returns>返回0操正常</returns>
 public static int sys_UserRolesInsertUpdate(sys_UserRolesTable fam)
 {
     return DataProvider.Instance().sys_UserRolesInsertUpdate(fam);
 }