Esempio n. 1
0
        public IList <UserList_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression)
        {
            IList <UserList_DetailedEntity> userList_DetailedEntityList = new List <UserList_DetailedEntity>();

            try
            {
                if (String.IsNullOrEmpty(sortExpression))
                {
                    sortExpression = "MemberID";
                }

                Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1;
                //startRowIndex = Convert.ToInt32(  startRowIndex / pageSize) + 1;

                if (pageSize == -1)
                {
                    pageSize = 1000000000;
                }

                userList_DetailedEntityList = FCCUserList_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression);

                if (userList_DetailedEntityList != null && userList_DetailedEntityList.Count > 0)
                {
                    totalRowCount = userList_DetailedEntityList[0].TotalRowCount;
                }
            }
            catch (Exception ex)
            {
            }

            return(userList_DetailedEntityList ?? new List <UserList_DetailedEntity>());
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                try
                {
                    lblTotalUser.Text = "0";

                    String sortExpression = SqlExpressionBuilder.PrepareSortExpression(UserList_DetailedEntity.FLD_NAME_UserName, SQLSortOrderType.Assending);

                    lblTotalUser.Text = FCCUserList_Detailed.GetFacadeCreate().GetIL(1000000, 1, sortExpression, String.Empty).Count.ToString();
                }
                catch (Exception ex)
                {
                }
            }
        }