/// <summary>
/// 获得所有的库位
/// </summary>
/// <returns></returns>
public List <LocationEntity> GetList()
{
string Key = string.Format(CacheKey.JOOSHOW_LOCATION_CACHE, this.CompanyID);
List <LocationEntity> listResult = CacheHelper.Get <List <LocationEntity> >(Key);
if (!listResult.IsNullOrEmpty())
{
return(listResult);
}
LocationEntity entity = new LocationEntity();
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete)
.And(a => a.CompanyID == this.CompanyID);
entity.IncludeAll();
entity.OrderBy(a => a.ID, EOrderBy.DESC);
listResult = this.Location.GetList(entity);
if (!listResult.IsNullOrEmpty())
{
StorageProvider storageProvider = new StorageProvider(this.CompanyID);
List <StorageEntity> listStorage = storageProvider.GetList();
listStorage = listStorage.IsNull() ? new List <StorageEntity>() : listStorage;
foreach (LocationEntity item in listResult)
{
StorageEntity storage = listStorage.FirstOrDefault(a => a.SnNum == item.StorageNum);
if (storage != null)
{
item.StorageName = storage.StorageName;
}
}
CacheHelper.Insert(Key, listResult);
}
return(listResult);
}
/// <summary>
/// 查询分页
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List <LocationEntity> GetList(LocationEntity entity, ref PageInfo pageInfo)
{
try
{
entity.IncludeAll();
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
entity.OrderBy(a => a.ID, EOrderBy.DESC);
int rowCount = 0;
List <LocationEntity> listResult = this.Location.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);
pageInfo.RowCount = rowCount;
if (!listResult.IsNullOrEmpty())
{
StorageProvider storageProvider = new StorageProvider();
List <StorageEntity> listStorage = storageProvider.GetList();
listStorage = listStorage.IsNull() ? new List <StorageEntity>() : listStorage;
foreach (LocationEntity item in listResult)
{
StorageEntity storage = listStorage.FirstOrDefault(a => a.StorageNum == item.StorageNum);
if (storage != null)
{
item.StorageName = storage.StorageName;
}
else
{
item.StorageName = "";
}
}
}
return(listResult);
}
catch (Exception e)
{
log.Error(e.Message);
}
return(null);
}
