public String RoleToPermissionList(Guid oid)
{
RolePermissionListViewData view = new RolePermissionListViewData();
view.RoleGuid = oid;
view.systemList = bllS.GetList();
view.functionList = bllF.GetList();
view.PageData.PagintionJsFunction = "window.System.RoleToPermissionList.search()";
view.PageData.OrderBy = "Code";
string sql = @"SELECT A.*, B.Name AS FunctionName, C.Name AS SystemName, D.RoleToPermissionGuid AS PermissionGuid
FROM dbo.ActionInfo AS A
LEFT JOIN dbo.FunctionInfo AS B ON A.FunctionGuid = B.FunctionGuid
LEFT JOIN dbo.SystemInfo AS C ON B.SystemGuid = C.SystemGuid
LEFT JOIN dbo.RoleToPermission AS D ON A.ActionGuid = D.ActionGuid AND D.RoleGuid = @RoleGuid
";
view.List = new Pagintion(sql, new { RoleGuid = oid }, view.PageData).ToList <ActionInfo>();
return(PageViewHelper.LoadPage("/System/RoleToPermissionList.aspx", view));
}
public string Search(PaginationData pd, Guid RoleGuid)
{
RolePermissionListViewData view = new RolePermissionListViewData();
view.PageData.PagintionJsFunction = "window.System.RoleToPermissionList.search()";
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, B.Name AS FunctionName, C.Name AS SystemName, D.RoleToPermissionGuid AS PermissionGuid
FROM dbo.ActionInfo AS A
LEFT JOIN dbo.FunctionInfo AS B ON A.FunctionGuid = B.FunctionGuid
LEFT JOIN dbo.SystemInfo AS C ON B.SystemGuid = C.SystemGuid
LEFT JOIN dbo.RoleToPermission AS D ON A.ActionGuid = D.ActionGuid AND D.RoleGuid = @RoleGuid
";
view.List = new Pagintion(sql, new { RoleGuid = RoleGuid }, view.PageData).ToList <ActionInfo>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/RolePermissionList.ascx", view.List);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
