/// <summary>
        /// �����û���ɫ��Ϣ
        /// </summary>
        private void SaveRoles(int UserID)
        {
            UserData.Move_UserPermissionCache(UserID);
            ArrayList lst = BusinessFacade.sys_UserRolesDisp(UserID);
            foreach (sys_UserRolesTable var in lst)
            {
                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);
                BusinessFacade.sys_UserRolesInsertUpdate(urt);
            }
        }
 /// <summary>
 /// 新增/删除/修改 sys_UserRoles
 /// </summary>
 /// <param name="fam">sys_UserRolesTable实体类</param>
 /// <returns>返回0操正常</returns>
 public abstract int sys_UserRolesInsertUpdate(sys_UserRolesTable fam);
        /// <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;
        }
        /// <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 (OleDbConnection Conn = GetSqlConnection())
            {
                string CommTxt;
                OleDbCommand cmd = new OleDbCommand();
                cmd.Connection = Conn;
                if (fam.DB_Option_Action_ == "Insert")
                {
                    CommTxt = "Insert into 	sys_UserRoles(R_UserID,R_RoleID)VALUES(@R_UserID,@R_RoleID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@R_UserID", OleDbType.Integer).Value = fam.R_UserID; //用户ID与sys_User表中UserID相关	
                    cmd.Parameters.Add("@R_RoleID", OleDbType.Integer).Value = fam.R_RoleID; //用户所属角色ID与Sys_Roles关联
                }
                else if (fam.DB_Option_Action_ == "Update")
                {

                    CommTxt = "UPDATE sys_UserRoles SET	R_UserID = @R_UserID,R_RoleID = @R_RoleID WHERE (  R_UserID = @R_UserID and R_RoleID = @R_RoleID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@R_UserID", OleDbType.Integer).Value = fam.R_UserID; //用户ID与sys_User表中UserID相关	
                    cmd.Parameters.Add("@R_RoleID", OleDbType.Integer).Value = fam.R_RoleID; //用户所属角色ID与Sys_Roles关联
                }
                else if (fam.DB_Option_Action_ == "Delete")
                {
                    CommTxt = "Delete from  sys_UserRoles  WHERE ( R_UserID = @R_UserID and R_RoleID = @R_RoleID)";
                    cmd.CommandText = CommTxt;
                    cmd.Parameters.Add("@R_UserID", OleDbType.Integer).Value = fam.R_UserID; //用户ID与sys_User表中UserID相关	
                    cmd.Parameters.Add("@R_RoleID", OleDbType.Integer).Value = fam.R_RoleID; //用户所属角色ID与Sys_Roles关联
                }
                else
                    throw new ApplicationException("无法识别的操作命令!");
                Conn.Open();
                rInt = cmd.ExecuteNonQuery();
                if (fam.DB_Option_Action_ == "Insert")
                {
                    cmd.CommandText = "SELECT @@identity";
                    rInt = Convert.ToInt32(cmd.ExecuteScalar());
                }
                cmd.Dispose();
                Conn.Dispose();
                Conn.Close();
            }
            return rInt;
        }
Exemple #5
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 (OracleConnection Conn = GetSqlConnection())
            {
                string CommTxt;
                OracleCommand cmd = new OracleCommand();
                cmd.Connection = Conn;
                if (fam.DB_Option_Action_ == "Insert")
                {
                    CommTxt = "Insert into 	sys_UserRoles(R_UserID,R_RoleID)VALUES(:R_UserID,:R_RoleID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("R_UserID", OracleType.Int32).Value = fam.R_UserID; //�û�ID��sys_User����UserID���
                    cmd.Parameters.Add("R_RoleID", OracleType.Int32).Value = fam.R_RoleID; //�û������ɫID��Sys_Roles����
                }
                else if (fam.DB_Option_Action_ == "Update")
                {

                    CommTxt = "UPDATE sys_UserRoles SET	R_UserID = :R_UserID,R_RoleID = :R_RoleID WHERE (  R_UserID = :R_UserID and R_RoleID = :R_RoleID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("R_UserID", OracleType.Int32).Value = fam.R_UserID; //�û�ID��sys_User����UserID���
                    cmd.Parameters.Add("R_RoleID", OracleType.Int32).Value = fam.R_RoleID; //�û������ɫID��Sys_Roles����

                }
                else if (fam.DB_Option_Action_ == "Delete")
                {
                    CommTxt = "Delete from  sys_UserRoles  WHERE ( R_UserID = :R_UserID and R_RoleID = :R_RoleID)";
                    cmd.CommandText = CommTxt;
                    cmd.Parameters.Add("R_UserID", OracleType.Int32).Value = fam.R_UserID; //�û�ID��sys_User����UserID���
                    cmd.Parameters.Add("R_RoleID", OracleType.Int32).Value = fam.R_RoleID; //�û������ɫID��Sys_Roles����
                }
                else
                    throw new ApplicationException("�޷�ʶ��IJ�������!");
                Conn.Open();
                OracleTransaction Tran = Conn.BeginTransaction();
                cmd.Transaction = Tran;
                try
                {
                    rInt = cmd.ExecuteNonQuery();
                    cmd.Parameters.Clear();
                    Tran.Commit();
                }
                catch (Exception ex)
                {
                    Tran.Rollback();
                    throw new ApplicationException(ex.ToString());
                }
                finally
                {
                    Tran.Dispose();
                    cmd.Dispose();
                    Conn.Dispose();
                    Conn.Close();
                }
            }
            return rInt;
        }
Exemple #6
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);
 }
Exemple #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);
 }
Exemple #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;
 }
 /// <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;
 }
 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)));
 }
        /// <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;
        }
Exemple #12
0
        /// <summary>
        /// �����û���ɫ��Ϣ
        /// </summary>
        private void SaveRoles(int UserID)
        {
            UserData.Move_UserPermissionCache(UserID);

            sys_UserRolesTable urt = new sys_UserRolesTable();
            ArrayList lst = BusinessFacade.sys_UserRolesDisp(UserID);
            if (lst.Count == 0)
            {
                urt.DB_Option_Action_ = "Insert";
            }
            else
            {
                urt.DB_Option_Action_ = "Update";
            }
            urt.R_UserID = UserID;
            urt.R_RoleID = Convert.ToInt32(dropDownList.SelectedValue);
            BusinessFacade.sys_UserRolesInsertUpdate(urt);
        }