/// <summary>
/// 查询统计数据
/// </summary>
/// <returns>用户类集合</returns>
public Select_Statistical_data Select_Statistical_datas(String str)
{
using (SqlConnection conn = new SqlConnection(SqlCon))
{
SqlCommand cmd = new SqlCommand(); //新建数据库操作类
cmd.Connection = conn; //设置数据链接
cmd.CommandText = str; //设置查询语句
conn.Open(); //打开数据库连接
SqlDataReader dr = cmd.ExecuteReader(); //执行Reader查询，存入dr
Select_Statistical_data u1 = new Select_Statistical_data(); //新建一个对象
while (dr.Read())//遍历dr
{
//把查询的当前记录各字段值赋值给对于的u0的属性
u1.All = Convert.ToInt32(dr["All"]);
u1.Online = Convert.ToInt32(dr["Online"]);
u1.Offline = Convert.ToInt32(dr["Offline"]);
u1.Null = Convert.ToInt32(dr["Null"]);
u1.Run = Convert.ToInt32(dr["Run"]);
u1.Alarm = Convert.ToInt32(dr["Alarm"]);
u1.Ready = Convert.ToInt32(dr["Ready"]);
u1.Maintenance_advance = Convert.ToInt32(dr["Maintenance_advance"]);
u1.Maintenance_completed = Convert.ToInt32(dr["Maintenance_completed"]);
u1.Maintenance_expired = Convert.ToInt32(dr["Maintenance_expired"]);
u1.Maintenance_count = u1.Maintenance_advance + u1.Maintenance_completed;
}
//循环结束后，每一个用户数据都会被加入到用户类集合u1,最后返回u1
return(u1);
}
}
public ActionResult BigScreen4()
{
String Last_Months_Add = Last_Months.PadLeft(2, '0');
String Monthly_Test_Output = "Monthly_Test_Output" + Last_Months_Add;
String Monthly_Test_NG = "Monthly_Test_NG" + Last_Months_Add;
String Monthly_Test_NG_Ratio = "Monthly_Test_NG_Ratio" + Last_Months_Add;
String str_Select_Device_Information_Last_Month = "exec proc_BigScreen_Select_Device_Information_Last_Month '" + Monthly_Test_Output + "'" + ",'" + Monthly_Test_NG + "'";
String str_proc_BigScreen_Select_Real_Time_Progress = "exec proc_BigScreen_Select_Real_Time_Progress ";
String str_proc_BigScreen_Select_Statistical_data = "exec proc_BigScreen_Select_Statistical_data ";
String str_Select_Top10_Last_Month_Output_NG = "exec proc_BigScreen_Select_Top10_Last_Month_Output_NG '" + Monthly_Test_Output + "'" + ",'" + Monthly_Test_NG + "'";
String str_Select_Top10_Last_Month_Run_Alarm = "exec proc_BigScreen_Select_Top10_Last_Month_Run_Alarm";
String str_Select_Top5_Alarm_times = "exec proc_BigScreen_Select_Top5_Alarm_times";
String str_Select_Top5_NG = "exec proc_BigScreen_Select_Top5_NG " + Monthly_Test_NG_Ratio + "";
List <Select_Device_Information_Last_Month> list_Select_Device_Information_Last_Month = db_Overall_Situation.Select_Device_Information_Last_Months(str_Select_Device_Information_Last_Month);
List <Select_Real_Time_Progress> list_Select_Real_Time_Progress = db_Overall_Situation.Select_Real_Time_Progresss(str_proc_BigScreen_Select_Real_Time_Progress);
Select_Statistical_data list_Select_Statistical_data = db_Overall_Situation.Select_Statistical_datas(str_proc_BigScreen_Select_Statistical_data);
List <Select_Top10_Last_Month_Output_NG> list_Select_Top10_Last_Month_Output_NG = db_Overall_Situation.Select_Top10_Last_Month_Output_NGs(str_Select_Top10_Last_Month_Output_NG);
List <Select_Top10_Last_Month_Run_Alarm> list_Select_Top10_Last_Month_Run_Alarm = db_Overall_Situation.Select_Top10_Last_Month_Run_Alarms(str_Select_Top10_Last_Month_Run_Alarm);
List <Select_Top5_Alarm_times> list_Select_Top5_Alarm_times = db_Overall_Situation.Select_Top5_Alarm_timess(str_Select_Top5_Alarm_times);
List <Select_Top5_NG> list_Select_Top5_NG = db_Overall_Situation.Select_Top5_NGs(str_Select_Top5_NG);
//int[] i = { list_Select_Top10_Last_Month_Run_Alarm[0].Last_Month_Runing_Time, list_Select_Top10_Last_Month_Run_Alarm[1].Last_Month_Runing_Time, list_Select_Top10_Last_Month_Run_Alarm[2].Last_Month_Runing_Time, list_Select_Top10_Last_Month_Run_Alarm[3].Last_Month_Runing_Time, list_Select_Top10_Last_Month_Run_Alarm[4].Last_Month_Runing_Time };
//ViewBag.list_Select_Top5_Last_Month_Run_Alarm_MaxData = i.Max();
//int[] j = { list_Select_Top10_Last_Month_Output_NG[0].Monthly_Test_Output, list_Select_Top10_Last_Month_Output_NG[1].Monthly_Test_Output, list_Select_Top10_Last_Month_Output_NG[2].Monthly_Test_Output, list_Select_Top10_Last_Month_Output_NG[3].Monthly_Test_Output, list_Select_Top10_Last_Month_Output_NG[4].Monthly_Test_Output };
//ViewBag.list_Select_Top5_Last_Month_Output_NG_MaxData = j.Max();
//ViewBag.list_Select_Top5_Last_Month_Output_NG_interval = j.Max() / 5;
//需要改进报警次数集合数，容易超过索引值
int[] k = { list_Select_Top5_Alarm_times[0].Last_Month_Alarm_Times, list_Select_Top5_Alarm_times[1].Last_Month_Alarm_Times, list_Select_Top5_Alarm_times[2].Last_Month_Alarm_Times, list_Select_Top5_Alarm_times[3].Last_Month_Alarm_Times, list_Select_Top5_Alarm_times[4].Last_Month_Alarm_Times };
//int[] k = { list_Select_Top5_Alarm_times[0].Last_Month_Alarm_Times, list_Select_Top5_Alarm_times[1].Last_Month_Alarm_Times};
ViewBag.list_Select_Top5_Alarm_times_MaxData = k.Max();
ViewBag.Select_Device_Information_Last_Month = list_Select_Device_Information_Last_Month;
ViewBag.Select_Statistical_data = list_Select_Statistical_data;
ViewBag.Select_Top5_Last_Month_Output_NG = list_Select_Top10_Last_Month_Output_NG;
return(View(Tuple.Create(list_Select_Real_Time_Progress, list_Select_Top10_Last_Month_Run_Alarm, list_Select_Top5_Alarm_times, list_Select_Top5_NG)));
//return View(Tuple.Create(list_Select_Device_Information_Last_Month, list_Select_Real_Time_Progress, list_Select_Statistical_data, list_Select_Top10_Last_Month_Output_NG, list_Select_Top10_Last_Month_Run_Alarm, list_Select_Top5_Alarm_times, list_Select_Top5_NG));
}
