/// <summary>
/// 动态生成表格的数据
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public ActionResult GetJson(int?page, int?rows)
{
try
{
page = page == null ? 1 : page; //第几页
rows = rows == null ? 10 : rows; //行数
try
{
//后台接受前台数据是一个对象，所以先要实例化Tostring()
EndDate = Request.Form["EndDate"].ToString() == string.Empty ? EndDate : Request.Form["EndDate"].ToString();
StartDate = Request.Form["StartDate"].ToString() == string.Empty ? StartDate : Request.Form["StartDate"].ToString();
Queryid = Request.Form["Queryid"].ToString() == string.Empty ? Queryid : Request.Form["Queryid"].ToString();
SelectVal = Request.Form["SelectVal"].ToString() == string.Empty ? SelectVal : Request.Form["SelectVal"].ToString();
InputVals = Request.Form["inputVals"].ToString() == string.Empty ? InputVals : Request.Form["inputVals"].ToString();
shopID = Request.Form["shopID"].ToString() == string.Empty ? "" : Request.Form["shopID"].ToString();
}
catch (Exception ex)
{
return(Json(data: new { exs = ex.Message }));
}
StaffInfoparam staffInfoparam = new StaffInfoparam()
{
_endDate = DateTime.Parse(EndDate), //结束时间
_startDate = DateTime.Parse(StartDate), //起始时间
_queryName = Queryid, //时间查询字段
_rows = (int)rows, //行数
_page = (int)page, //页数
_total = 0, //总行数
_fileName = "", //导出文件名
_selectVal = SelectVal, //输入查询字段
_inputVals = InputVals, //用户信息
_shopID = shopID // 门店ID
};
// return Json(data: new { shopids = staffInfoparam._shopID }); //??? 单独测试，存在数据
var json = helpStaffs.Contaion(_hostingEnvironment, staffInfoparam, export);
return(Json(new { rows = json, total = staffInfoparam._total }));
}
catch (Exception ex)
{
return(Json(ResultMsg.FormatResult(ex)));
}
}
