/// <summary>
/// 订单列表的导出功能
/// </summary>
/// <returns>路径让浏览器下载</returns>
public ActionResult ExportDataCenter()
{
MDatacenter mDatacenter = new MDatacenter();
DataTable table = mDatacenter.WorkOrderData();
string path = ExportExcel.Excel(table, "订单列表_" + PMUser.UserGuid + ".xlsx", "订单数据");
Task.Run(() =>
{
Thread.Sleep(30000);
ExportExcel.DelExcel("订单列表_" + PMUser.UserGuid);
});
return(Ok(path));
}
public ActionResult DTworkOrder()
{
MDatacenter mDatacenter = new MDatacenter();
DataTable dt = mDatacenter.WorkOrderData();
JObject tableData = new JObject {
{ "total", dt.Rows.Count },
{ "rows", JsonConvert.SerializeObject(dt) }
};
JObject data = new JObject {
{ "code", "0" },
{ "data", tableData },
{ "msg", "successful" }
};
return(Ok(data));
}