private string StrWhere(SYSIntegralCodePrizesVMSearch condition)
{
string where = string.Empty;
if (!string.IsNullOrWhiteSpace(condition.keyword))
{
where += string.Format(" and (WaterCode like '%{0}%' or IntegralCode like '%{0}%')", Common.Filter(condition.keyword));
}
if (!string.IsNullOrWhiteSpace(condition.State))
{
where += string.Format(" and [State]='{0}'", Common.Filter(condition.State));
}
if (condition.PrizesID != 0)
{
where += string.Format(" and [PrizesID]={0}", condition.PrizesID);
}
if (condition.ActivityID != 0 && condition.PrizesID == 0)
{
where += string.Format(" and LotteryActivitys.ID={0}", condition.ActivityID);
}
if (condition.AreaID != 0)
{
where += string.Format(" and SYSIntegralCodeArea.ID={0}", condition.AreaID);
}
return(where);
}
public ActionResult GetPage(SYSIntegralCodePrizesVMSearch condition)
{
string where = StrWhere(condition);
PageJsonModel <SYSIntegralCodePrizesVM> page = new PageJsonModel <SYSIntegralCodePrizesVM>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = @" [SYSIntegralCode]
left join SYSIntegralCodeArea on [SYSIntegralCode].AreaID=SYSIntegralCodeArea.ID
left join LotteryPrizes on [SYSIntegralCode].PrizesID=LotteryPrizes.ID
left join LotteryActivitys on LotteryPrizes.ActivityID=LotteryActivitys.ID ";
page.strSelect = " [SYSIntegralCode].*,SYSIntegralCodeArea.AreaName,isnull(LotteryPrizes.PrizeLevel,'') PrizeLevel,isnull(LotteryPrizes.PrizeName,'') PrizeName,isnull(LotteryActivitys.Title,'') activityName ";
page.strWhere = where;
page.strOrder = "[SYSIntegralCode].ID desc";
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
