public ActionResult OOEBarChartPartial()
{
var data = new Acme.Core.EquipmentManagement.WebService.Impl.EquipmentManagement().GetProcedures();
IList <OOEChartData> formatData = new List <OOEChartData>();
foreach (var procedure in data)
{
formatData.Add(new OOEChartData()
{
TypeName = "时间稼动率", Value = procedure.RateOfTimeMovement, EquipmentName = procedure.Equipment.Name
});
formatData.Add(new OOEChartData()
{
TypeName = "性能稼动率", Value = procedure.PerformanceYield, EquipmentName = procedure.Equipment.Name
});
formatData.Add(new OOEChartData()
{
TypeName = "合格率", Value = procedure.Yield, EquipmentName = procedure.Equipment.Name
});
formatData.Add(new OOEChartData()
{
TypeName = "全局设备效率", Value = procedure.GlobalPlantEfficiency, EquipmentName = procedure.Equipment.Name
});
}
return(PartialView("OOEBarChartPartial", formatData));
}
public ActionResult Show(DateTimeOffset?t)
{
//var data = new List<Models.Test>() {
//new Models.Test(){ A="a",B=2,C=1,D="d"},
//new Models.Test(){ A="a2",B=4,C=2,D="d2"},
//new Models.Test(){ A="a3",B=6,C=3,D="d3"},
//};
IList <Procedure> data = new List <Procedure>();
IList <OOEChartData> formatData = new List <OOEChartData>();
if (t == null)
{
ViewBag.GridData = formatData;
return(View(data));
}
data = new Acme.Core.EquipmentManagement.WebService.Impl.EquipmentManagement().GetProcedures(t.Value);
foreach (var procedure in data)
{
formatData.Add(new OOEChartData()
{
TypeName = "时间稼动率", Value = procedure.RateOfTimeMovement, EquipmentName = procedure.Equipment.Name
});
formatData.Add(new OOEChartData()
{
TypeName = "性能稼动率", Value = procedure.PerformanceYield, EquipmentName = procedure.Equipment.Name
});
formatData.Add(new OOEChartData()
{
TypeName = "合格率", Value = procedure.Yield, EquipmentName = procedure.Equipment.Name
});
formatData.Add(new OOEChartData()
{
TypeName = "全局设备效率", Value = procedure.GlobalPlantEfficiency, EquipmentName = procedure.Equipment.Name
});
}
ViewBag.GridData = formatData;
return(View(data));
}
private void simpleButton1_Click(object sender, EventArgs e)
{
var data = new Acme.Core.EquipmentManagement.WebService.Impl.EquipmentManagement().GetProcedures();
gridControl1.DataSource = data;
DataSet ds = new DataSet();
var tb = new DataTable();
tb.Columns.Add("Number");
tb.Columns.Add("Equipment.Code");
tb.Columns.Add("Equipment.Name");
tb.Columns.Add("FormatProduction");
tb.Columns.Add("FormatRejects");
tb.Columns.Add("RunTime");
tb.Columns.Add("PlanHaltTime");
tb.Columns.Add("FormatTheoreticallyMeter");
tb.Columns.Add("RateOfTimeMovement");
tb.Columns.Add("PerformanceYield");
tb.Columns.Add("Yield");
tb.Columns.Add("GlobalPlantEfficiency");
foreach (var a in data)
{
var newRow = tb.NewRow();
newRow.ItemArray = new object[] {
a.Number,
a.Equipment.Code, a.Equipment.Name,
a.Production, a.Rejects, a.RunTime, a.PlanHaltTime, a.TheoreticallyMeter, a.RateOfTimeMovement, a.PerformanceYield, a.Yield, a.GlobalPlantEfficiency
};
tb.Rows.Add(newRow);
}
ds.Tables.Add(tb);
gridControl1.DataSource = ds.Tables[0];
IList <OOEChartData> formatData = new List <OOEChartData>();
foreach (var procedure in data)
{
formatData.Add(new OOEChartData()
{
TypeName = "时间稼动率", Value = procedure.RateOfTimeMovement, EquipmentName = procedure.Equipment.Name
});
formatData.Add(new OOEChartData()
{
TypeName = "性能稼动率", Value = procedure.PerformanceYield, EquipmentName = procedure.Equipment.Name
});
formatData.Add(new OOEChartData()
{
TypeName = "合格率", Value = procedure.Yield, EquipmentName = procedure.Equipment.Name
});
formatData.Add(new OOEChartData()
{
TypeName = "全局设备效率", Value = procedure.GlobalPlantEfficiency, EquipmentName = procedure.Equipment.Name
});
}
chartControl1.BindToData(ViewType.Bar, formatData, "TypeName", "EquipmentName", "Value");
//chartControl1.Series[0].Points.Add(new SeriesPoint("TypeName",)
}
public ActionResult OEEGridPartial()
{
var data = new Acme.Core.EquipmentManagement.WebService.Impl.EquipmentManagement().GetProcedures();
return(PartialView("OEEGridPartial", data));
}
// This action method sends a document with the exported Grid to response.
public ActionResult ExportTo()
{
var data = new Acme.Core.EquipmentManagement.WebService.Impl.EquipmentManagement().GetProcedures();
return(GridViewExtension.ExportToXls(GetGridSettings(), data));
}
