public String FunctionList()
{
FunctionListViewData view = new FunctionListViewData();
view.List = new List <FunctionInfo>();
view.PageData = new PaginationData();
view.PageData.PageIndex = 1;
view.PageData.PageSize = 10;
view.PageData.PagintionJsFunction = "window.System.FunctionList.search()";
view.PageData.OrderBy = "Code";
string sql = @"SELECT A.CreatedBy, A.CreatedOn, A.ModifiedBy, A.ModifiedOn, A.FunctionGuid,
A.Code, A.Name, A.Remark, B.Name AS SystemName
FROM dbo.FunctionInfo AS A
LEFT JOIN dbo.SystemInfo AS B ON A.SystemGuid = B.SystemGuid
";
view.List = new Pagintion(sql, null, view.PageData).ToList <FunctionInfo>();
return(PageViewHelper.LoadPage("/System/FunctionList.aspx", view));
}
public string Search(PaginationData pd)
{
FunctionListViewData view = new FunctionListViewData();
view.PageData = new BaseFrameWork.Model.PaginationData();
view.PageData.PageIndex = pd.PageIndex;
view.PageData.PageSize = pd.PageSize;
view.PageData.PagintionJsFunction = "window.System.FunctionList.search()";
view.PageData.OrderBy = pd.OrderBy;
string sql = @"SELECT CreatedBy, CreatedOn, ModifiedBy, ModifiedOn, FunctionGuid,
Code, Name, Remark
FROM dbo.FunctionInfo
";
view.List = new Pagintion(sql, null, view.PageData).ToList <FunctionInfo>();
string table = UserControlExcutor.RenderUserControl("/System/UserControl/FunctionList.ascx", view);
string pagination = UserControlExcutor.RenderUserControl("/System/CommonUserControl/Pagination.ascx", view.PageData);
return(JsonHelper.ToJson(new { table = table, pagination = pagination }));
}