public PartialViewResult ActProduct(int actid, RequestPagedBase page)
{
int pindex = 1;
int.TryParse(Request["pindex"], out pindex);
page.pageindex = pindex > 0 ? pindex : 1;
int recordCount = 0;
var productList = ProductBLL.Instance.Product_GetList(page.pageindex, page.pagesize, "0", " EXISTS (SELECT * FROM ProductActivity AS pa WHERE pa.ActID =" + actid + " AND pa.ProductID =p.ProductID)", out recordCount);
var pagelist = new PagedList <ProductInfo>(productList, page.pageindex, page.pagesize, recordCount);
ViewBag.ProductList = pagelist;
ViewBag.ActID = actid;
return(PartialView("_PartialProduct"));
}
//显示
public ActionResult Product(int actid)
{
var page = new RequestPagedBase();
int recordCount = 0;
var productlist = ProductBLL.Instance.Product_GetList(page.pageindex, page.pagesize, "0", "EXISTS(SELECT 1 FROM ProductActivity pa where pa.ProductID = p.ProductID and pa.ActID =" + actid + ")", out recordCount);
var paged = new PagedList <ProductInfo>(productlist, page.pageindex, page.pagesize, recordCount);
ViewBag.ProductList = paged;
var searchlist = ProductBLL.Instance.Product_GetList(page.pageindex, page.pagesize, "0", "NOT EXISTS(SELECT * FROM ProductActivity pa where pa.ProductID = p.ProductID and pa.ActID =" + actid + ")", out recordCount);
var searchpaged = new PagedList <ProductInfo>(searchlist, page.pageindex, page.pagesize, recordCount);
ViewBag.SearchProductList = searchpaged;
ViewBag.ActID = actid;
return(View());
}