public String SystemList()
{
SystemListViewData view = new SystemListViewData();
view.List = new List <SystemInfo>();
view.PageData = new PaginationData();
view.PageData.PageIndex = 1;
view.PageData.PageSize = 10;
view.PageData.PagintionJsFunction = "window.System.SystemList.search()";
view.PageData.OrderBy = "Code";
string sql = @"SELECT CreatedBy, CreatedOn, ModifiedBy, ModifiedOn, SystemGuid,
Code, Name, Remark
FROM dbo.SystemInfo
";
view.List = new Pagintion(sql, null, view.PageData).ToList <SystemInfo>();
return(PageViewHelper.LoadPage("/System/SystemList.aspx", view));
}
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 }));
}
