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