public ActionResult ExportExcel(SYSIntegralCodeSearch condition)
{
StringBuilder where = new StringBuilder();
where.Append("select WaterCode,IntegralCode from [SYSIntegralCode] where 1=1 ");
where.Append(SYSIntegralCodeSearch.StrWhere(condition));
DataTable dt = ExportWay.ExcelDataTable(where.ToString());
string[] list = { "流水码", "防伪码" };
return(File(ExportWay.GetExcel(dt, list), "application/vnd.ms-excel", "防伪码" + DateTime.Now.ToShortTimeString() + ".xls"));
}
public ActionResult GetList(SYSIntegralCodeSearch condition)
{
string where = SYSIntegralCodeSearch.StrWhere(condition);
PageJsonModel <SYSIntegralCode> page = new PageJsonModel <SYSIntegralCode>();
page.pageIndex = condition.pageIndex;
page.strForm = " SYSIntegralCode ";
page.strSelect = " * ";
page.pageSize = condition.pageSize;
page.strWhere = where;
page.strOrder = " ID Desc";
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}