public ActionResult GoodsList(int pageIndex, jf_GoodsSearch condition)
{
string where = string.Empty;
if (condition != null)
{
if (!string.IsNullOrWhiteSpace(condition.keyword))
{
string keyword = Common.Filter(condition.keyword);
where += string.Format(" and GoodsName like '%{0}%'", keyword);
}
}
PageJsonModel <jf_Goods> page = new PageJsonModel <jf_Goods>();
page.pageIndex = pageIndex;
page.strForm = "jf_Goods";
page.strSelect = "*";
page.strWhere = " and PublishStat='已上架' " + where;
page.strOrder = " ID desc";
page.LoadListNoCnt();
if (page.pageResponse != null && page.pageResponse.RtnList != null && page.pageResponse.RtnList.Count > 0)
{
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
private string StrWhere(jf_GoodsSearch condition)
{
string where = string.Empty;
//产品名称
if (!string.IsNullOrWhiteSpace(condition.GoodsName))
{
where += " and jf_Goods.GoodsName like '%" + Common.Filter(condition.GoodsName) + "%' ";
}
if (!string.IsNullOrWhiteSpace(condition.PublishStat))
{
where += string.Format(" and jf_Goods.PublishStat='{0}' ", Common.Filter(condition.PublishStat));
}
return(where);
}
public ActionResult GetGoodsPage(jf_GoodsSearch condition)
{
string where = StrWhere(condition);
PageJsonModel <jf_Goods> page = new PageJsonModel <jf_Goods>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = " jf_Goods ";
page.strSelect = " jf_Goods.* ";
page.strWhere = where;
page.strOrder = "jf_Goods.ID desc";
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
