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>());
}
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);
}
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);
}
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);
}