// public IList <AVEItem> GetType(DateTime?datee) { string connectionString_ATL = @"server=127.0.0.1;database=IFactory;uid=root;pwd=root;Persist Security Info=True;Charset=utf8;"; MySqlConnection connatl = new MySqlConnection(connectionString_ATL); connatl.Open(); DateTime?DateE = datee; string sql = "select distinct ProductNo from autoinspection1_facility_production_data a where a.StartDate >= '" + DateE.Value.ToString() + "' and a.StartDate <= '" + DateE.Value.AddDays(1.0).ToString() + "'"; MySqlDataAdapter b = new MySqlDataAdapter(sql, connatl); DataTable bt = new DataTable(); b.Fill(bt); connatl.Close(); List <AVEItem> lstDataCapacityModel = new List <AVEItem>(); if (bt != null && bt.Rows.Count > 0) { foreach (DataRow row in bt.Rows) { AVEItem info = new AVEItem(); info.Type = row[0].ToString(); lstDataCapacityModel.Add(info); } } connatl.Close(); return(lstDataCapacityModel); }
// public IList <AVEItem> GetAlarm(DateTime?TimeStart, DateTime?TimeEnd, String size) { string connectionString_ATL = @"server=127.0.0.1;database=IFactory;uid=root;pwd=root;Persist Security Info=True;Charset=utf8;"; MySqlConnection connatl = new MySqlConnection(connectionString_ATL); connatl.Open(); String filename = size; if (filename == "") { filename = "0X0D0301"; } string sql1 = "select alarm_time from alarm_record where rule_did = " + "'" + @filename + "'"; MySqlDataAdapter b = new MySqlDataAdapter(sql1, connatl); DataTable bt = new DataTable(); b.Fill(bt); connatl.Close(); List <AVEItem> lstDataCapacityModel = new List <AVEItem>(); if (bt != null && bt.Rows.Count > 0) { foreach (DataRow row in bt.Rows) { AVEItem info = new AVEItem(); info.TimeStart = DateTime.Parse(row[0].ToString()); lstDataCapacityModel.Add(info); } } connatl.Close(); return(lstDataCapacityModel); }
//平均测量值2 public IList <AVEItem> GetAVE2(DateTime?TimeStart, DateTime?TimeEnd, String side, DateTime?datee, string type) { string connectionString_ATL = @"server=127.0.0.1;database=IFactory;uid=root;pwd=root;Persist Security Info=True;Charset=utf8;"; MySqlConnection connatl = new MySqlConnection(connectionString_ATL); connatl.Open(); String filename = side; string battype = type; DateTime?DateE = datee; string sql = "select a.StartDate," + @filename + " from autoinspection2_facility_production_data a" + " where a.StartDate >= '" + DateE.Value.ToString() + "' and a.StartDate <= '" + DateE.Value.AddDays(1.0).ToString() + "' and " + @filename + " <> 0 and a.ProductNo = '" + @battype + "'"; MySqlDataAdapter b = new MySqlDataAdapter(sql, connatl); DataTable bt = new DataTable(); b.Fill(bt); connatl.Close(); List <AVEItem> lstDataCapacityModel = new List <AVEItem>(); if (bt != null && bt.Rows.Count > 0) { foreach (DataRow row in bt.Rows) { AVEItem info = new AVEItem(); info.TimeStart = DateTime.Parse(row[0].ToString()); info.Size = Double.Parse(row[1].ToString()); lstDataCapacityModel.Add(info); } } connatl.Close(); return(lstDataCapacityModel); }