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