public ActionResult GetNoRebatePage(RebateSearch condition)
{
condition.State = "未发放";
string where = RebateSearch.StrWhere_tj(condition);
PageJsonModel <C_UserRebate> page = GetPage(condition, where);
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
public ActionResult ExportExcel_NoRebate_tj(RebateSearch condition)
{
condition.State = "未发放";
string where = RebateSearch.StrWhere_tj(condition);
PageJsonModel <C_UserRebate> page = GetPage(condition, where);
string sql = @" select convert(varchar(20),年)+'年'+convert(varchar(20),月)+'月',Name,Phone,返利合计,[State] from " + page.strForm + " where 1=1 " + page.strWhere;
DataTable dt = ExportWay.ExcelDataTable(sql);
string[] list = { "月份", "返利人", "返利人手机号", "返利金额", "状态" };
return(File(ExportWay.GetExcel(dt, list), "application/vnd.ms-excel", "未发放推荐返利" + DateTime.Now.ToShortTimeString() + ".xls"));
}