public string GetWorkPlanBars(string plan, string ViewName) { GetWorkplanBars PlanInfo = new GetWorkplanBars(); DataTable table = PlanInfo.GetPlanBars(plan, ViewName); return(PMPublicFuncs.DatatableToJson(table)); }
/// <summary> /// 导出计划列表 /// </summary> /// <returns>路径让浏览器下载</returns> public ActionResult ExportPlanData() { GetWorkplanBars getWorkplanBars = new GetWorkplanBars(); DataTable table = getWorkplanBars.GetAllPlanData(); string path = ExportExcel.Excel(table, "计划列表_" + PMUser.UserGuid + ".xlsx", "计划数据"); Task.Run(() => { Thread.Sleep(30000); ExportExcel.DelExcel("计划列表_" + PMUser.UserGuid); }); return(Ok(path)); }
/// <summary> /// 获取订单列表的数据 /// </summary> /// <returns>table</returns> public DataTable WorkOrderData() { GetWorkplanBars getWorkplanBars = new GetWorkplanBars(); //查看要查询数据库中的哪些列 JObject SQLWorkOrderFileds = PMAppSettings.TableFileds.SelectToken("SQLWorkOrderFiled").ToObject <JObject>(); string SQLWorkOrderFiled = ""; foreach (var item in SQLWorkOrderFileds) { if (string.IsNullOrEmpty(SQLWorkOrderFiled)) { SQLWorkOrderFiled += item.Key; } else { SQLWorkOrderFiled += "," + item.Key; } } DataTable dt = Workplaninfo.GetWorkOrder(SQLWorkOrderFiled, "isScheduleWorkID = '1'", string.Empty); DataTable productId = Workplaninfo.GetWorkOrder("productID", "isScheduleWorkID = '1'", string.Empty); foreach (var item in SQLWorkOrderFileds) { dt.Columns[item.Key].ColumnName = item.Value.Value <string>(); } DataTable AttrTable = getWorkplanBars.GetAttrTable(productId); JObject SQLAttrFiled = PMAppSettings.TableFileds.SelectToken("SQLAttrFiled").ToObject <JObject>(); foreach (var item in SQLAttrFiled) { dt.Columns.Add(item.Value.Value <string>()); } for (int i = 0; i < dt.Rows.Count; i++) { for (int v = 0; v < AttrTable.Rows.Count; v++) { if (AttrTable.Rows[v]["itemName"].ToString() == dt.Rows[i]["产品名称"].ToString()) { foreach (DataColumn col in AttrTable.Columns) { if (col.ColumnName != "itemName") { dt.Rows[i][col.ColumnName] = AttrTable.Rows[v][col.ColumnName].ToString().Replace(" - ", " ").Replace("\"", "'"); } } } } } return(dt); }
/// <summary> /// 执行计划的表格 /// </summary> /// <param name="plan">计划名称</param> /// <param name="ViewName">设备名称</param> /// <returns></returns> public ActionResult WorkPlanBar(string plan, string ViewName) { GetWorkplanBars PlanInfo = new GetWorkplanBars(); DataTable table = PlanInfo.GetPlanBars(plan, ViewName); string JsonString = JsonConvert.SerializeObject(table); JObject tableData = new JObject { { "total", table.Rows.Count }, { "rows", JsonString } }; JObject data = new JObject { { "code", "0" }, { "data", tableData }, { "msg", "successful" } }; return(Ok(data)); }