private PageJsonModel <C_UserRebate> Rebate_nh_GetPage(RebateSearch condition, string where)
{
decimal GetOrderRateMaxPrice = BaseParameters.getPrice("GetOrderRateMaxPrice"); //拿货返利门槛金额
decimal GetOrderRate = BaseParameters.getRate("GetOrderRate"); //拿货返利
PageJsonModel <C_UserRebate> page = new PageJsonModel <C_UserRebate>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = string.Format(@"( select C_UserRebate.R_People,C_User.Name,C_User.Phone,year(DatCreat) 年,
month(DatCreat) 月,
case when sum(C_UserRebate.[OrderMoney])>={0}
then sum(C_UserRebate.[OrderMoney])*{1}
else 0 end
返利合计,sum(C_UserRebate.[OrderMoney]) 订单总额,C_UserRebate.[State]
from C_UserRebate left join C_User on C_UserRebate.R_People=C_User.UserName
where C_UserRebate.Cat='拿货返利' and C_UserRebate.Issuer='总部' {2}
group by C_UserRebate.R_People,C_User.Name,C_User.Phone,year(DatCreat),
month(DatCreat),C_UserRebate.[State] ) as Show", GetOrderRateMaxPrice, GetOrderRate, where);
page.strSelect = " * ";
page.strWhere = "";
page.strOrder = "年,月 desc";
return(page);
}
