public string MonthSearch(SearchKeyPaginationData pd, string company, DateTime?from, DateTime?to)
{
BusinessTypeListViewData view = new BusinessTypeListViewData();
view.pageDataParents = new BaseFrameWork.Model.PaginationData();
view.pageDataParents.PageIndex = pd.PageIndex;
view.pageDataParents.PageSize = pd.PageSize;
view.pageDataParents.PagintionJsFunction = "window.System.CustomerMonthList.search()";
view.pageDataParents.OrderBy = pd.OrderBy;
string sql = @"SELECT DISTINCT C.Code, C.Name, SUM(BidCost) OVER(PARTITION BY A.BusinessType, C.Code, C.NAME) AS BidCost,
SUM(SaleAmount) OVER(PARTITION BY A.BusinessType, C.Code, C.NAME) AS SaleAmount,
SUM(FactCost) OVER(PARTITION BY A.BusinessType, C.Code, C.NAME) AS FactCost,
SUM(Profit) OVER(PARTITION BY A.BusinessType, C.Code, C.NAME) AS Profit,
SUM(BidCost) OVER() AS TotalBidCost, SUM(SaleAmount) OVER() AS TotalSaleAmount,
SUM(FactCost) OVER() AS TotalFactCost, SUM(Profit) OVER() AS TotalProfit
FROM dbo.Customer AS A
LEFT JOIN dbo.Company AS B ON A.CompanyID = B.CompanyID
LEFT JOIN dbo.BusinessType AS C ON A.BusinessType = C.TypeID
WHERE (((ISNULL(@CustomerName, '') <> '') AND A.Name LIKE '%' + @CustomerName + '%') OR (ISNULL(@CustomerName, '') = ''))
AND (((ISNULL(@CompanyName, '') <> '') AND B.Name LIKE '%' + @CompanyName + '%') OR (ISNULL(@CompanyName, '') = ''))
AND (((ISNULL(@From, '') <> '') AND A.CreatedOn >= @From) OR (ISNULL(@From, '') = ''))
AND (((ISNULL(@To, '') <> '') AND A.CreatedOn < DATEADD(DAY, 1, @To)) OR (ISNULL(@To, '') = ''))";
view.menuListParents = new Pagintion(sql, new { CustomerName = pd.SearchKey, CompanyName = company, From = from, To = to }, view.pageDataParents).ToList <BusinessType>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/CustomerMonthList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.pageDataParents);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string Search(SearchKeyPaginationData pd)
{
CompanyListViewData view = new CompanyListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.CompanyList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, B.Name AS CompanyCharacterName, C.Name AS PayTypeName, D.Processing, E.AllCustomer - D.Processing AS Finished
FROM dbo.Company AS A
LEFT JOIN dbo.KeyValuePair AS B ON A.PayType = B.Code AND B.[Group] = 'CompanyCharacter'
LEFT JOIN dbo.KeyValuePair AS C ON A.PayType = C.Code AND C.[Group] = 'PayType'
OUTER APPLY (SELECT COUNT(DISTINCT IA.CustomerID) AS Processing
FROM dbo.Customer AS IA
INNER JOIN dbo.ProcessStep AS IB ON IA.CustomerID = IB.CustomerID
WHERE IB.FinishDate IS NULL
AND IA.CompanyID = A.CompanyID) AS D
OUTER APPLY(SELECT COUNT(*) AS AllCustomer FROM dbo.Customer AS IA WHERE IA.CompanyID = A.CompanyID) AS E
WHERE A.Name LIKE '%' + @key + '%'";
view.List = new Pagintion(sql, new { key = pd.SearchKey }, view.PageData).ToList <Company>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/CompanyList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string SearchRole(PaginationData pd)
{
ListViewData <RoleInfo> view = new ListViewData <RoleInfo>();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.RoleTab.searchRole()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, CASE WHEN B.OrganizationName IS NOT NULL THEN STUFF(B.OrganizationName, 1, 1, '') ELSE '' END AS OrganizationName,
CASE WHEN C.UserName IS NOT NULL THEN STUFF(C.UserName, 1, 1, '') ELSE '' END AS UserName
FROM dbo.RoleInfo AS A
OUTER APPLY (SELECT ';' + IB.Name
FROM dbo.RoleToBusiness AS IA
INNER JOIN dbo.Organization AS IB ON IA.BusinessGuid = IB.UnitGuid
WHERE IB.Name > ''
ORDER BY IB.Code
FOR XML PATH('')) AS B(OrganizationName)
OUTER APPLY (SELECT ';' + IB.UserName
FROM dbo.RoleToBusiness AS IA
INNER JOIN dbo.UserInfo AS IB ON IA.BusinessGuid = IB.UserGuid
WHERE IB.UserName > ''
ORDER BY IB.UserCode
FOR XML PATH('')) AS C(UserName)";
view.List = new Pagintion(sql, null, view.PageData).ToList <RoleInfo>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/RoleList.ascx", view.List);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string AlertSearch(SearchKeyPaginationData pd, string company, DateTime?from, DateTime?to)
{
CustomerListViewData view = new CustomerListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.CustomerAlertList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, B.Name AS CompanyName, C.Name AS BusinessTypeName, SUM(BidCost) OVER() AS TotalBidCost, SUM(SaleAmount) OVER() AS TotalSaleAmount,
SUM(FactCost) OVER() AS TotalFactCost, SUM(Profit) OVER() AS TotalProfit, D.StepName, D.EstimateDate
FROM dbo.Customer AS A
LEFT JOIN dbo.Company AS B ON A.CompanyID = B.CompanyID
LEFT JOIN dbo.BusinessType AS C ON A.BusinessType = C.TypeID
OUTER APPLY (SELECT TOP 1 IA.ID AS StepID, IA.StepName, IA.EstimateDate
FROM dbo.ProcessStep AS IA
WHERE A.CustomerID = IA.CustomerID
AND IA.EstimateDate > GETDATE()
AND IA.EstimateDate < GETDATE() + @AlertDays
AND FinishDate IS NULL
ORDER BY IA.EstimateDate, IA.CreatedOn) AS D
WHERE D.StepID IS NOT NULL
AND (((ISNULL(@CustomerName, '') <> '') AND A.Name LIKE '%' + @CustomerName + '%') OR (ISNULL(@CustomerName, '') = ''))
AND (((ISNULL(@CompanyName, '') <> '') AND B.Name LIKE '%' + @CompanyName + '%') OR (ISNULL(@CompanyName, '') = ''))
AND (((ISNULL(@From, '') <> '') AND A.CreatedOn >= @From) OR (ISNULL(@From, '') = ''))
AND (((ISNULL(@To, '') <> '') AND A.CreatedOn < DATEADD(DAY, 1, @To)) OR (ISNULL(@To, '') = ''))";
view.List = new Pagintion(sql, new { AlertDays = Convert.ToInt32(ConfigurationManager.AppSettings["AlertDays"]), CustomerName = pd.SearchKey, CompanyName = company, From = from, To = to }, view.PageData).ToList <Customer>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/CustomerAlertList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string StatisticSearch(SearchKeyPaginationData pd, string company, DateTime?from, DateTime?to, int num)
{
CustomerListViewData view = new CustomerListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.CustomerStatisticList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, B.Name AS CompanyName, C.Name AS BusinessTypeName, SUM(BidCost) OVER() AS TotalBidCost, SUM(SaleAmount) OVER() AS TotalSaleAmount,
SUM(FactCost) OVER() AS TotalFactCost, SUM(Profit) OVER() AS TotalProfit
FROM dbo.Customer AS A
LEFT JOIN dbo.Company AS B ON A.CompanyID = B.CompanyID
LEFT JOIN dbo.BusinessType AS C ON A.BusinessType = C.TypeID
OUTER APPLY (SELECT COUNT(*) AS StepCount
FROM dbo.ProcessStep AS IA
WHERE FinishDate IS NULL) AS D
WHERE (((ISNULL(@CustomerName, '') <> '') AND A.Name LIKE '%' + @CustomerName + '%') OR (ISNULL(@CustomerName, '') = ''))
AND (((ISNULL(@CompanyName, '') <> '') AND B.Name LIKE '%' + @CompanyName + '%') OR (ISNULL(@CompanyName, '') = ''))
AND (((ISNULL(@From, '') <> '') AND A.CreatedOn >= @From) OR (ISNULL(@From, '') = ''))
AND (((ISNULL(@To, '') <> '') AND A.CreatedOn < DATEADD(DAY, 1, @To)) OR (ISNULL(@To, '') = ''))
AND CASE WHEN D.StepCount = 0 THEN 0 ELSE 1 END = @Num";
view.List = new Pagintion(sql, new { Num = num, CustomerName = pd.SearchKey, CompanyName = company, From = from, To = to }, view.PageData).ToList <Customer>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/CustomerStatisticList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string SecondSearch(Guid parentGuid, PaginationData pd)
{
NavigationListViewData view = new NavigationListViewData();
view.pageDataChildren = new BaseFrameWork.Model.PaginationData();
view.pageDataChildren.PageIndex = pd.PageIndex;
view.pageDataChildren.PageSize = pd.PageSize;
view.pageDataChildren.PagintionJsFunction = "window.System.NavigationList.secondSearch()";
view.pageDataChildren.OrderBy = pd.OrderBy;
string sql = "select A.*, B.Name AS ParentName from dbo.Menu AS A INNER JOIN dbo.Menu AS B ON A.ParentGuid = B.MenuGuid where A.ParentGuid = @ParentGuid";
view.menuListChildren = new Pagintion(sql, new { ParentGuid = parentGuid }, view.pageDataChildren).ToList <Menu>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/NavigationListSecond.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.pageDataChildren);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string FirstSearch(PaginationData pd)
{
NavigationListViewData view = new NavigationListViewData();
view.pageDataParents = new BaseFrameWork.Model.PaginationData();
view.pageDataParents.PageIndex = pd.PageIndex;
view.pageDataParents.PageSize = pd.PageSize;
view.pageDataParents.PagintionJsFunction = "window.System.NavigationList.firstSearch()";
view.pageDataParents.OrderBy = pd.OrderBy;
string sql = "select * from dbo.Menu where ParentGuid IS NULL";
view.menuListParents = new Pagintion(sql, null, view.pageDataParents).ToList <Menu>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/NavigationListFirst.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.pageDataParents);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string SecondSearch(Guid parentID, PaginationData pd)
{
BusinessTypeListViewData view = new BusinessTypeListViewData();
view.pageDataChildren = new BaseFrameWork.Model.PaginationData();
view.pageDataChildren.PageIndex = pd.PageIndex;
view.pageDataChildren.PageSize = pd.PageSize;
view.pageDataChildren.PagintionJsFunction = "window.System.BusinessTypeList.secondSearch()";
view.pageDataChildren.OrderBy = pd.OrderBy;
string sql = "SELECT A.*, B.[Name] AS ParentName FROM BusinessType AS A INNER JOIN BusinessType AS B ON A.ParentID = B.TypeID WHERE B.TypeID = @TypeID";
view.menuListChildren = new Pagintion(sql, new { TypeID = parentID }, view.pageDataChildren).ToList <BusinessType>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/BusinessTypeListSecond.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.pageDataChildren);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string Search(PaginationData pd)
{
PriceListViewData view = new PriceListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.PriceList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT * FROM dbo.PriceList";
view.List = new Pagintion(sql, null, view.PageData).ToList <PriceList>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/PriceList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string SelectSearch(SearchKeyPaginationData pd)
{
PriceListViewData view = new PriceListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.SelectPrice.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT * FROM dbo.PriceList WHERE StartPlace LIKE '%' + @Place + '%' OR DestinationPlace LIKE '%' + @Place + '%' OR InterimPlace LIKE '%' + @Place + '%'";
view.List = new Pagintion(sql, new { Place = pd.SearchKey }, view.PageData).ToList <PriceList>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/SelectPrice.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string FirstSearch(PaginationData pd)
{
BusinessTypeListViewData view = new BusinessTypeListViewData();
view.pageDataParents = new BaseFrameWork.Model.PaginationData();
view.pageDataParents.PageIndex = pd.PageIndex;
view.pageDataParents.PageSize = pd.PageSize;
view.pageDataParents.PagintionJsFunction = "window.System.BusinessTypeList.firstSearch()";
view.pageDataParents.OrderBy = pd.OrderBy;
string sql = "SELECT * FROM BusinessType WHERE ParentID IS NULL";
view.menuListParents = new Pagintion(sql, null, view.pageDataParents).ToList <BusinessType>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/BusinessTypeListFirst.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.pageDataParents);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string SearchPermissionToRole(PaginationData pd, Guid actionGuid)
{
ListViewData <RoleInfo> view = new ListViewData <RoleInfo>();
view.PageData.PagintionJsFunction = "window.System.PermissionToRoleList.search()";
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, B.RoleToPermissionGuid AS PermissionGuid
FROM dbo.RoleInfo AS A
LEFT JOIN dbo.RoleToPermission AS B ON A.RoleGuid = B.RoleGuid AND B.ActionGuid = @ActionGuid
";
view.List = new Pagintion(sql, new { ActionGuid = actionGuid }, view.PageData).ToList <RoleInfo>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/BusinessToRole.ascx", view.List);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string SearchRoleByBusiness(PaginationData pd, Guid businessGuid)
{
ListViewData <RoleInfo> view = new ListViewData <RoleInfo>();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.RoleTab.searchRoleByBusiness()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*
FROM dbo.RoleInfo AS A
INNER JOIN dbo.RoleToBusiness AS B ON A.RoleGuid = B.RoleGuid
WHERE B.BusinessGuid = @BusinessGuid";
view.List = new Pagintion(sql, new { BusinessGuid = businessGuid }, view.PageData).ToList <RoleInfo>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/RoleList.ascx", view.List);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string SearchRoleBusiness(PaginationData pd, Guid roleGuid)
{
ListViewData <Organization> view = new ListViewData <Organization>();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.OrderBy = pd.OrderBy;
view.PageData.PagintionJsFunction = "window.System.RoleToBusinessList.searchRoleBusiness()";
string sql = @"SELECT A.*, B.Name AS ParentName, C.RoleToBusinessGuid AS PermissionGuid
FROM dbo.Organization AS A
LEFT JOIN dbo.Organization AS B ON A.ParentGuid = B.UnitGuid
LEFT JOIN dbo.RoleToBusiness AS C ON A.UnitGuid = C.BusinessGuid AND C.RoleGuid = @RoleGuid
";
view.List = new Pagintion(sql, new { RoleGuid = roleGuid }, view.PageData).ToList <Organization>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/RoleOrganizationList.ascx", view.List);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string SelectSearch(SearchKeyPaginationData pd)
{
AgentCompanyListViewData view = new AgentCompanyListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.SelectAgentCompany.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, B.Name AS AgentCompanyCharacterName
FROM dbo.AgentCompany AS A
LEFT JOIN dbo.KeyValuePair AS B ON A.[Character] = B.Code AND B.[Group] = 'CompanyCharacter'
WHERE A.Name LIKE '%' + @key + '%'";
view.List = new Pagintion(sql, new { key = pd.SearchKey }, view.PageData).ToList <AgentCompany>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/SelectAgentCompany.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string Search(PaginationData pd)
{
SystemListViewData view = new SystemListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.SystemList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT CreatedBy, CreatedOn, ModifiedBy, ModifiedOn, SystemGuid,
Code, Name, Remark
FROM dbo.SystemInfo
";
view.List = new Pagintion(sql, null, view.PageData).ToList <SystemInfo>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/SystemList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string Search(PaginationData pd)
{
UserListViewData view = new UserListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.UserList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, B.Name AS CompanyName, C.Name AS DepartmentName
FROM dbo.UserInfo AS A
LEFT JOIN dbo.Organization AS B ON A.CompanyGuid = B.UnitGuid
LEFT JOIN dbo.Organization AS C ON A.DepartmentGuid = C.UnitGuid";
view.List = new Pagintion(sql, null, view.PageData).ToList <UserInfo>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/UserList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
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 }));
}
public string Search(PaginationData pd, String code)
{
KeyValuePListViewData view = new KeyValuePListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.KeyValuePList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, B.[Name] AS ParentName
FROM KeyValuePair AS A
LEFT JOIN KeyValuePair AS B ON A.ParentGuid = B.ID
WHERE A.[Group] = @Group
";
view.List = new Pagintion(sql, new { Group = code }, view.PageData).ToList <KeyValueP>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/KeyValuePList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string Search(PaginationData pd)
{
OrganizationListViewData view = new OrganizationListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.OrganizationList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.*, B.Name AS ParentName
FROM dbo.Organization AS A
LEFT JOIN dbo.Organization AS B ON A.ParentGuid = B.UnitGuid
WHERE 1 = 1
--AND A.ParentGuid = @ParentGuid
AND 1 = 1";
view.List = new Pagintion(sql, null, view.PageData).ToList <Organization>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/OrganizationList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
public string Search(PaginationData pd)
{
ActionListViewData view = new ActionListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.ActionList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT A.CreatedBy, A.CreatedOn, A.ModifiedBy, A.ModifiedOn, A.ActionGuid,
A.Code, A.Name, A.Remark, B.Name AS FunctionName, C.Name AS SystemName
FROM dbo.ActionInfo AS A
INNER JOIN dbo.FunctionInfo AS B ON A.FunctionGuid = B.FunctionGuid
INNER JOIN dbo.SystemInfo AS C ON B.SystemGuid = C.SystemGuid
";
view.List = new Pagintion(sql, null, view.PageData).ToList <ActionInfo>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/ActionList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}
