public String UserList() { UserListViewData view = new UserListViewData(); view.PageData = new BaseFrameWork.Model.PaginationData(); view.PageData.PageIndex = 1; view.PageData.PageSize = 10; view.PageData.PagintionJsFunction = "window.System.UserList.search()"; view.PageData.OrderBy = "UserCode"; 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>(); return(PageViewHelper.LoadPage("/System/UserList.aspx", view)); }
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 UserListViewDataFixture() { _viewData = new UserListViewData(); }
public String UserList() { UserListViewData ulvd = new UserListViewData(); return(PageViewHelper.LoadPage("/System/UserList.aspx", ulvd)); }