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