public ActionResult GetMsGoodsPageList(MdmGoodsMstrQuery query)
{
try
{
var result = _mdmGoodsMstrRepository.GetMsGoodsPageList(query);
return(Page(result.Data, result.Page));
}
catch (Exception ex)
{
return(Fail("获取失败：" + ex.Message));
}
}
/// <summary>
/// 获取秒杀商品分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public dynamic GetMsGoodsPageList(MdmGoodsMstrQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "good.CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
return(_sqlQuery.Select(@"good.goods_id,good.GOODS_RMK ,good.goods_name,gl.UDF2 Pic,gl.GL_STATUS,good.sp_sdate,good.sp_edate,good.sp_qty,good.SP_PRICE,gs.PL_SELL_PRICE,gs.PL_PROMO_PRICE")
.Filter("good.sp_flag", 1)
.Filter("gl.GL_STATUS", 1)
.Contains("good.GOODS_RMK", query.GOODS_RMK)
.And(where)
.OrderBy("good.CREATE_DATE DESC")
.GetPageList <dynamic>(@"mdm_goods_mstr good
left join mdm_goods_list gl on good.gl_id = gl.gl_id
left join MDM_GOODS_SPL gs on gs.pl_goods_no = good.goods_no", Context.Database.GetDbConnection(), query));
}
