示例#1
0
        public IList <INVStoreUnit_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression)
        {
            IList <INVStoreUnit_DetailedEntity> iNVStoreUnit_DetailedEntityList = new List <INVStoreUnit_DetailedEntity>();

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

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

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

                iNVStoreUnit_DetailedEntityList = FCCINVStoreUnit_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression);

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

            return(iNVStoreUnit_DetailedEntityList ?? new List <INVStoreUnit_DetailedEntity>());
        }
示例#2
0
        public static IList <INVStoreUnit_DetailedEntity> GetAllStoreUnit_Detailed(Int32 pageSize, Int32 currentPage, String sortExpression, String filterExpression)
        {
            IList <INVStoreUnit_DetailedEntity> lst = new List <INVStoreUnit_DetailedEntity>();

            try
            {
                lst = FCCINVStoreUnit_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression);
            }
            catch (Exception ex)
            {
            }

            return(lst);
        }
示例#3
0
        public static IList <INVStoreUnit_DetailedEntity> GetAllStoreUnit_Detailed()
        {
            IList <INVStoreUnit_DetailedEntity> lst = new List <INVStoreUnit_DetailedEntity>();

            try
            {
                lst = FCCINVStoreUnit_Detailed.GetFacadeCreate().GetIL(10000000, 1, String.Empty, String.Empty);
            }
            catch (Exception ex)
            {
            }

            return(lst);
        }
示例#4
0
        public static IList <INVStoreUnit_DetailedEntity> GetStoreUnitByStoreID(Int64 storeID)
        {
            IList <INVStoreUnit_DetailedEntity> lst = new List <INVStoreUnit_DetailedEntity>();

            try
            {
                String filterExpression = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnit." + INVStoreUnit_DetailedEntity.FLD_NAME_StoreID, storeID.ToString(), SQLMatchType.Equal);

                lst = FCCINVStoreUnit_Detailed.GetFacadeCreate().GetIL(10000000, 1, String.Empty, filterExpression);
            }
            catch (Exception ex)
            {
            }

            return(lst);
        }