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