public IList <ACBankAccountPaymentPostPayableStatementDetailMapEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression)
        {
            IList <ACBankAccountPaymentPostPayableStatementDetailMapEntity> aCBankAccountPaymentPostPayableStatementDetailMapEntityList = new List <ACBankAccountPaymentPostPayableStatementDetailMapEntity>();

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

                if (String.IsNullOrEmpty(sortExpression))
                {
                    sortExpression = ACBankAccountPaymentPostPayableStatementDetailMapEntity.FLD_NAME_BankAccountPaymentPostPayableStatementDetailMapID + " " + SQLConstants.SORT_ORDER_DESCENDING;
                }

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

                aCBankAccountPaymentPostPayableStatementDetailMapEntityList = FCCACBankAccountPaymentPostPayableStatementDetailMap.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);

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

            return(aCBankAccountPaymentPostPayableStatementDetailMapEntityList ?? new List <ACBankAccountPaymentPostPayableStatementDetailMapEntity>());
        }
        public IList <ACBankAccountPaymentPostPayableStatementDetailMapEntity> GetData()
        {
            IList <ACBankAccountPaymentPostPayableStatementDetailMapEntity> aCBankAccountPaymentPostPayableStatementDetailMapEntityList = new List <ACBankAccountPaymentPostPayableStatementDetailMapEntity>();

            try
            {
                aCBankAccountPaymentPostPayableStatementDetailMapEntityList = FCCACBankAccountPaymentPostPayableStatementDetailMap.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);

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

            return(aCBankAccountPaymentPostPayableStatementDetailMapEntityList ?? new List <ACBankAccountPaymentPostPayableStatementDetailMapEntity>());
        }