/// <summary> /// 获取设备利用率 /// </summary> /// <param name="resName">线体名称</param> /// <returns>Json</returns> public string GetResUsuage(string resName) { DataTable data = ResourceModels.GetResUsuage(resName); //useDate,dayAllWorkHour,dayPlanWorkHour,dayResRatio data.Columns["useDate"].ColumnName = "日期"; data.Columns["dayAllWorkHour"].ColumnName = "当日总工时"; data.Columns["dayPlanWorkHour"].ColumnName = "计划工时"; data.Columns["dayResRatio"].ColumnName = "稼动率"; return(PMPublicFuncs.DatatableToJson(data)); }
public ActionResult <List <ResGroup> > GetAllUsuage() { List <ResGroup> resGroups = new List <ResGroup>(); ResGroup resGroup = new ResGroup(); DataTable data = ResourceModels.GetAllResUsuage(); resGroup.Rescontent = new DataTable(); resGroup.Rescontent.Columns.Add("日期"); resGroup.Rescontent.Columns.Add("当日总工时"); resGroup.Rescontent.Columns.Add("计划工时"); resGroup.Rescontent.Columns.Add("稼动率"); for (int i = 0; i < data.Rows.Count; i++) { if (i == 0) { resGroup.Resname = data.Rows[i]["mainResName"].ToString(); DataRow row = resGroup.Rescontent.NewRow(); row["日期"] = data.Rows[i]["useDate"].ToString(); row["当日总工时"] = data.Rows[i]["dayAllWorkHour"].ToString(); row["计划工时"] = data.Rows[i]["dayPlanWorkHour"].ToString(); row["稼动率"] = data.Rows[i]["dayResRatio"].ToString(); resGroup.Rescontent.Rows.Add(row); continue; } if (data.Rows[i]["mainResName"].ToString() == resGroup.Resname.ToString()) { DataRow row = resGroup.Rescontent.NewRow(); row["日期"] = data.Rows[i]["useDate"].ToString(); row["当日总工时"] = data.Rows[i]["dayAllWorkHour"].ToString(); row["计划工时"] = data.Rows[i]["dayPlanWorkHour"].ToString(); row["稼动率"] = data.Rows[i]["dayResRatio"].ToString(); resGroup.Rescontent.Rows.Add(row); } else { resGroups.Add(resGroup); resGroup = new ResGroup(); resGroup.Resname = data.Rows[i]["mainResName"].ToString(); resGroup.Rescontent = new DataTable(); DataRow row = resGroup.Rescontent.NewRow(); resGroup.Rescontent.Columns.Add("日期"); resGroup.Rescontent.Columns.Add("当日总工时"); resGroup.Rescontent.Columns.Add("计划工时"); resGroup.Rescontent.Columns.Add("稼动率"); row["日期"] = data.Rows[i]["useDate"].ToString(); row["当日总工时"] = data.Rows[i]["dayAllWorkHour"].ToString(); row["计划工时"] = data.Rows[i]["dayPlanWorkHour"].ToString(); row["稼动率"] = data.Rows[i]["dayResRatio"].ToString(); resGroup.Rescontent.Rows.Add(row); } } return(resGroups); }
/// <summary> /// 获取设备名称列表 /// </summary> /// <param name="resGroup">设备组名称</param> /// <returns>Json</returns> public string GetResNameList(string resGroup) { return(PMPublicFuncs.DatatableToJson(ResourceModels.GetResList(resGroup))); }
/// <summary> /// 获取设备组 /// </summary> /// <returns>Json</returns> public string GetResGroup() { return(PMPublicFuncs.DatatableToJson(ResourceModels.GetResGroup())); }
public ActionResult <DataTable> GetuseDate() { DataTable data = ResourceModels.GetUseDate(); return(data); }
public void AddMockResource(IResourceModel mockRes) { ResourceModels.Add(mockRes); }