public ActionResult RebateDetail_nh(string dattype) { ViewData["dattype"] = dattype; ViewBag.GetOrderRateMaxPrice = BaseParameters.getPrice("GetOrderRateMaxPrice");//拿货返利门槛金额 return(View()); }
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); }