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