/// <summary>
/// 根据集合获取符合条件的商品属性集合
/// </summary>
/// <returns></returns>
public List <GoodsDto> GetGoodsDto(GetGoodsApo pageDataApo, out int totalCount)
{
totalCount = 0;
List <GoodsDto> data;
//查询语句
var queryable = Db.Queryable <Goods>()
.Where(it => pageDataApo.goodsEpsDatas.Contains(it.code))
.WhereIF(pageDataApo.expire_date != null, it => it.expire_date <= pageDataApo.expire_date && it.expire_date >= DateTime.Now)
.WhereIF(!string.IsNullOrWhiteSpace(pageDataApo.name), it => it.name.Contains(pageDataApo.name))
.WhereIF(!string.IsNullOrWhiteSpace(pageDataApo.code), it => it.goods_code.Contains(pageDataApo.code))
.OrderBy(it => it.name, OrderByType.Asc)
.Select <GoodsDto>();
//如果小于0，默认查全部
if (pageDataApo.PageSize > 0)
{
data = queryable.ToPageList(pageDataApo.PageIndex, pageDataApo.PageSize, ref totalCount);
}
else
{
data = queryable.ToList();
totalCount = data.Count();
}
return(data);
}
/// <summary>
/// 效期 查询
/// </summary>
/// <param name="getGoodApo"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List <GoodsDto> GetValidityGoodsDto(GetGoodsApo getGoodApo, out int totalCount)
{
return(GoodsDal.GetGoodsDto(getGoodApo, out totalCount));
}
