/// <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)); }