/// <summary>
/// 获取字段权限
/// </summary>
/// <param name="view"></param>
/// <returns></returns>
public static string GetFieldPrivilege(string view)
{
string sql = @"select PrivilegeMaster,PrivilegeMasterKey,PrivilegeAccess,PrivilegeAccessKey,PrivilegeOperation from CF_Privilege";
sql += " where PrivilegeAccess like '{0}.%'".FormatWith(view);
return(JSONHelper.ExecuteCommandToJSON(sql));
}
/// <summary>
/// 获取全部用户账户列表
/// </summary>
/// <returns></returns>
public static string GetUserListJSON()
{
var sql = "select UserID,LoginName,[Title] from CF_User";
sql += " where UserID <> {0}".FormatWith(AdminUserID);
sql += " and UserID not in (select UserID from CF_UserRole where RoleID = {0}) ".FormatWith(AdminRoleID);
return(JSONHelper.ExecuteCommandToJSON(sql));
}
/// <summary>
/// 获取全部角色列表
/// </summary>
/// <returns></returns>
public static string GetRoleListJSON()
{
var sql = "select RoleID,RoleName from CF_Role where RoleID <> {0} ".FormatWith(AdminRoleID);
return(JSONHelper.ExecuteCommandToJSON(sql));
}
