コード例 #1
0
        /// <summary>
        /// 获取该部门下所有职业
        /// </summary>
        /// <param name="Role_Id"></param>
        /// <returns></returns>
        public DataTable ChildrenJobByRole(int Role_Id)
        {
            MySqlParameter sqlParameters = new MySqlParameter("@RoleId", MySqlDbType.Int32);

            sqlParameters.Value = Role_Id;
            var query = DbProcedureHelper.ExecuteDt("P_GetChildrenJobByRoleId", sqlParameters);

            return(query);
        }
コード例 #2
0
        /// <summary>
        /// 岗位维护,当前部门下的角色
        /// </summary>
        /// <returns></returns>
        public DataTable ChlidrenUserByRole(int id)
        {
            MySqlParameter sqlParameters = new MySqlParameter("@RoleId", MySqlDbType.Int32);

            sqlParameters.Value = id;

            var model = DbProcedureHelper.ExecuteDt("P_GetChildrenUserByRole", sqlParameters);

            return(model);
        }