public IList <INVStore_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression) { IList <INVStore_DetailedEntity> iNVStore_DetailedEntityList = new List <INVStore_DetailedEntity>(); try { if (String.IsNullOrEmpty(sortExpression)) { sortExpression = "StoreID"; } Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1; //startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1; if (pageSize == -1) { pageSize = 1000000000; } iNVStore_DetailedEntityList = FCCINVStore_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression); if (iNVStore_DetailedEntityList != null && iNVStore_DetailedEntityList.Count > 0) { totalRowCount = iNVStore_DetailedEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(iNVStore_DetailedEntityList ?? new List <INVStore_DetailedEntity>()); }
public static IList <INVStore_DetailedEntity> GetAllStoresDetailed(Int32 pageSize, Int32 currentPage, String sortExpression, String filterExpression) { IList <INVStore_DetailedEntity> lst = new List <INVStore_DetailedEntity>(); try { lst = FCCINVStore_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression); } catch (Exception ex) { } return(lst); }
public static IList <INVStore_DetailedEntity> GetAllStoresDetailed() { IList <INVStore_DetailedEntity> lst = new List <INVStore_DetailedEntity>(); try { lst = FCCINVStore_Detailed.GetFacadeCreate().GetIL(1000000000, 1, String.Empty, String.Empty); } catch (Exception ex) { } return(lst); }
public static INVStore_DetailedEntity GetStoreDetailedByID(Int64 storeID) { INVStore_DetailedEntity ent = new INVStore_DetailedEntity(); try { IList <INVStore_DetailedEntity> lst = new List <INVStore_DetailedEntity>(); String filterExpression = SqlExpressionBuilder.PrepareFilterExpression("INVStore." + INVStore_DetailedEntity.FLD_NAME_StoreID, storeID.ToString(), SQLMatchType.Equal); lst = FCCINVStore_Detailed.GetFacadeCreate().GetIL(1, 1, String.Empty, filterExpression); if (lst != null && lst.Count > 0) { ent = lst[0]; } } catch (Exception ex) { } return(ent); }