public ActionResult DoIcpProductListPaging(ParaIcpGoodsItemFilter filter)
{
filter.PageSize = 10;
var pager = IcpBo.Instance.GetIcpProductList(filter);
var list = new PagedList <CBIcpGoodsItem>
{
PageSize = filter.PageSize,
TData = pager.Rows,
CurrentPageIndex = pager.CurrentPage,
TotalItemCount = pager.TotalRows
};
return(PartialView("_IcpProductPager", list));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2016-3-23 王耀发 创建</remarks>
public override Pager <CBIcpGoodsItem> GetIcpProductList(ParaIcpGoodsItemFilter filter)
{
string where = " 1=1 ";
switch (filter.IcpType)
{
case (int)Model.CommonEnum.商检.广州白云机场:
where += " and exists(select * from IcpBYJiChangGoodsInfo where ProductSysNo = p.SysNo) ";
break;
case (int)Model.CommonEnum.商检.广州南沙:
where += "and exists(select * from IcpGZNanShaGoodsInfo where ProductSysNo = p.SysNo)";
break;
default:
break;
}
if (filter.name != null)
{
where += " and (p.ErpCode like '%" + filter.name + "%' or p.ProductName like '%" + filter.name + "%')";
}
string sql = @"(select p.SysNo,p.ErpCode,p.ProductName from PdProduct p
where " + where + " and not exists(select * from IcpGoodsItem where ProductSysNo = p.SysNo and IcpGoodsSysNo in (select SysNo from Icp where SourceSysNo = 0 and [Status] <> -1 and IcpType = @0))) tb";
var paras = new object[]
{
filter.IcpType
};
var dataList = Context.Select <CBIcpGoodsItem>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(0)").From(sql);
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBIcpGoodsItem>
{
PageSize = filter.PageSize,
CurrentPage = filter.Id,
TotalRows = dataCount.QuerySingle(),
Rows = dataList.OrderBy("tb.SysNo desc").Paging(filter.Id, filter.PageSize).QueryMany()
};
return(pager);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分页</returns>
/// <remarks>2016-3-23 王耀发 创建</remarks>
public Pager <CBIcpGoodsItem> GetIcpProductList(ParaIcpGoodsItemFilter filter)
{
return(IcpDao.Instance.GetIcpProductList(filter));
}
/// <summary> /// 分页查询 /// </summary> /// <param name="filter">查询参数</param> /// <returns>分页</returns> /// <remarks>2016-3-23 王耀发 创建</remarks> public abstract Pager <CBIcpGoodsItem> GetIcpProductList(ParaIcpGoodsItemFilter filter);
