/// <summary>
/// 存储过程查询在线产品库存
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <param name="ProductName"></param>
/// <param name="begin"></param>
/// <param name="end"></param>
/// <returns></returns>
public List<ProductEntity> GetList(ProductEntity entity, ref PageInfo pageInfo, string searchKey, string begin, string end)
{
entity.IncludeAll();
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
entity.OrderBy(a => a.ID, EOrderBy.DESC);
int rowCount = 0;
List<ProductEntity> list = this.Product.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);
List<ProductEntity> listResult = new List<ProductEntity>();
pageInfo.RowCount = rowCount;
DateTime beginTime = ConvertHelper.ToType<DateTime>(begin, DateTime.Now.AddDays(-1));
DateTime endTime = ConvertHelper.ToType<DateTime>(end, DateTime.Now);
Proc_ProductReportEntity prEntity = new Proc_ProductReportEntity();
prEntity.SearchKey = searchKey;
prEntity.BeginTime = beginTime;
prEntity.EndTime = endTime;
if (!begin.IsEmpty() && !end.IsEmpty())
{
prEntity.IsTime = 1;//加上时间条件
}
else
{
prEntity.IsTime = 0;
}
if (!list.IsNullOrEmpty())
{
List<ProductCategoryEntity> listCates = new ProductCategoryProvider().GetList();
listCates = listCates.IsNull() ? new List<ProductCategoryEntity>() : listCates;
foreach (ProductEntity item in list)
{
if (item.CateName.IsEmpty())
{
ProductCategoryEntity cate= listCates.FirstOrDefault(a => a.CateNum == item.CateNum);
item.CateName = cate == null ? "" : cate.CateName;
}
prEntity.ProductNum = item.SnNum;
prEntity.IsDelete = (int)EIsDelete.NotDelete;
prEntity.Status = (int)EAudite.Pass;
int line = this.Proc_ProductReport.ExecuteNonQuery(prEntity);
item.LocalProductNum = prEntity.LocalProductNum;
item.InStorageNum = prEntity.InStorageNum;
item.OutStorageNum = prEntity.OutStorageNum;
item.BadReportNum = prEntity.BadReportNum;
item.TotalLocalProductNum = prEntity.TotalLocalProductNum;
item.TotalInStorageNum = prEntity.TotalInStorageNum;
item.TotalOutStorageNum = prEntity.TotalOutStorageNum;
item.TotalBadReportNum = prEntity.TotalBadReportNum;
if (item.InStorageNum > 0 && item.TotalInStorageNum > 0)
{
item.InStorageNumPCT = (item.InStorageNum * 100.00f) / item.TotalInStorageNum;
}
if (item.OutStorageNum > 0 && item.TotalOutStorageNum > 0)
{
item.OutStorageNumPCT = (item.OutStorageNum * 100.00f) / item.TotalOutStorageNum;
}
listResult.Add(item);
}
}
return listResult;
}
/// <summary>
/// 查询产品列表
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List<ProductEntity> GetList(ProductEntity entity, ref PageInfo pageInfo)
{
entity.IncludeAll();
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
entity.OrderBy(a => a.ID, EOrderBy.DESC);
int rowCount = 0;
List<ProductEntity> list = this.Product.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);
if (!list.IsNullOrEmpty())
{
List<ProductCategoryEntity> listCate = new ProductCategoryProvider().GetList();
listCate = listCate.IsNull() ? new List<ProductCategoryEntity>() : listCate;
foreach (ProductEntity item in list)
{
if (listCate.Exists(a => a.CateNum == item.CateNum))
{
item.CateName = listCate.First(a => a.CateNum == item.CateNum).CateName;
}
}
}
pageInfo.RowCount = rowCount;
return list;
}