コード例 #1
0
        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));
        }
コード例 #2
0
ファイル: AjaxUser.cs プロジェクト: chahongjing/net_logistics
        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 }));
        }
コード例 #3
0
 public UserListViewDataFixture()
 {
     _viewData = new UserListViewData();
 }
コード例 #4
0
        public String UserList()
        {
            UserListViewData ulvd = new UserListViewData();

            return(PageViewHelper.LoadPage("/System/UserList.aspx", ulvd));
        }