public String SelectAgentCompany()
{
AgentCompanyListViewData view = new AgentCompanyListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = 1;
view.PageData.PageSize = 10;
view.PageData.PagintionJsFunction = "window.System.SelectAgentCompany.search()";
view.PageData.OrderBy = "Name, CreatedOn";
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'";
view.List = new Pagintion(sql, null, view.PageData).ToList <AgentCompany>();
return(PageViewHelper.LoadPage("/System/SelectAgentCompany.aspx", view));
}
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 }));
}
