List<RealTimeInfo> list = ProductionInfoManager.GetProductionInfoAll(number);
this.dataGridView1.AutoGenerateColumns = true;
DataTable dt = new DataTable( "RealTimeInfor");
string[] title = { "实时Id", "线别", "机种类型", "计划总产量", "当日计划产量", "当日目标产量", "当前实际产量", "当前生产效率", "不良数量", "不良率", "实际人数", "状态", "完成时间" };
//添加列
for ( int i = 0; i < title.Length; i++)
{
DataColumn dc = new DataColumn();
dc.ColumnName = title[i];
dt.Columns.Add(dc);
}
//添加行
for ( int j = 0; j < list.Count; j++)
{
DataRow dr = dt.NewRow();
dr[ "实时Id"] = list[j].RealTime_Id;
dr[ "线别"] = list[j].RealTime_productLine.ProductLine_Name;
dr[ "机种类型"] = list[j].RealTime_type;
dr[ "计划总产量"] = list[j].RealTime_planNumber;
dr[ "当日计划产量"] = list[j].RealTime_dayPlanNumber;
dr[ "当日目标产量"] = list[j].RealTime_nowNumber;
dr[ "当前实际产量"] = list[j].RealTime_factNumber;
dr[ "当前生产效率"] = ToEfficiency(list[j].RealTime_factNumber, list[j].RealTime_nowNumber);
dr[ "不良数量"] = list[j].RealTime_badNumber;
dr[ "不良率"] = ToPeprent(list[j].RealTime_factNumber, list[j].RealTime_badNumber);
dr[ "实际人数"] = list[j].RealTime_factPeople;
dr[ "状态"] = list[j].RealTime_status == 0 ? "执行" : list[j].RealTime_status == 1 ? "完成" : "";
dr[ "完成时间"] = GetTime(list[j].RealTime_time);
dt.Rows.Add(dr);
}
this.dataGridView1.DataSource = dt;
this.dataGridView1.AutoGenerateColumns = true;
DataTable dt = new DataTable( "RealTimeInfor");
string[] title = { "实时Id", "线别", "机种类型", "计划总产量", "当日计划产量", "当日目标产量", "当前实际产量", "当前生产效率", "不良数量", "不良率", "实际人数", "状态", "完成时间" };
//添加列
for ( int i = 0; i < title.Length; i++)
{
DataColumn dc = new DataColumn();
dc.ColumnName = title[i];
dt.Columns.Add(dc);
}
//添加行
for ( int j = 0; j < list.Count; j++)
{
DataRow dr = dt.NewRow();
dr[ "实时Id"] = list[j].RealTime_Id;
dr[ "线别"] = list[j].RealTime_productLine.ProductLine_Name;
dr[ "机种类型"] = list[j].RealTime_type;
dr[ "计划总产量"] = list[j].RealTime_planNumber;
dr[ "当日计划产量"] = list[j].RealTime_dayPlanNumber;
dr[ "当日目标产量"] = list[j].RealTime_nowNumber;
dr[ "当前实际产量"] = list[j].RealTime_factNumber;
dr[ "当前生产效率"] = ToEfficiency(list[j].RealTime_factNumber, list[j].RealTime_nowNumber);
dr[ "不良数量"] = list[j].RealTime_badNumber;
dr[ "不良率"] = ToPeprent(list[j].RealTime_factNumber, list[j].RealTime_badNumber);
dr[ "实际人数"] = list[j].RealTime_factPeople;
dr[ "状态"] = list[j].RealTime_status == 0 ? "执行" : list[j].RealTime_status == 1 ? "完成" : "";
dr[ "完成时间"] = GetTime(list[j].RealTime_time);
dt.Rows.Add(dr);
}
this.dataGridView1.DataSource = dt;
转载于:https://blog.51cto.com/ningyb/542290