//工作日数
public IList <DataPicItem> GetWorkDays()
{
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 sql = @"select MCCollectDDate
from autoinspection1_run_total_collect
where year(MCCollectDDate) = year(Now())
order by MCCollectDDate";
MySqlDataAdapter b = new MySqlDataAdapter(sql, connatl);
DataTable bt = new DataTable();
b.Fill(bt);
connatl.Close();
List <DataPicItem> lstDataCapacityModel = new List <DataPicItem>();
if (bt != null && bt.Rows.Count > 0)
{
foreach (DataRow row in bt.Rows)
{
DataPicItem info = new DataPicItem();
info.ProductTime = DateTime.Parse(row[0].ToString());
lstDataCapacityModel.Add(info);
}
}
connatl.Close();
return(lstDataCapacityModel);
}
/// <summary>
/// 生产质量2
/// </summary>
/// <param name="TimeStart"></param>
/// <param name="TimeEnd"></param>
/// <returns></returns>
public IList <DataPicItem> GetDataQuality2(DateTime?TimeStart, DateTime?TimeEnd, DateTime dates, 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?DateS = dates;
DateTime?DateE = datee;
string sql = @"select c.time
,c.OKCount
,c.nowYield
from craft_probably c
where c.nowYield <> 0
and c.OKCount <> 0 ";
string w1 = DateS.HasValue ? "and c.time >= '" + DateS.ToString() + "'" : "";
string w2 = DateE.HasValue ? " and c.time < '" + DateE.Value.AddDays(1.0).ToString() + "'" : "";
string w3 = " order by time";
MySqlDataAdapter b = new MySqlDataAdapter(sql + w1 + w2 + w3, connatl);
DataTable bt = new DataTable();
b.Fill(bt);
connatl.Close();
//string w1 = TimeStart.HasValue ? "and alarm_time >= '" + TimeStart.ToString() + "'" : "";
//string w2 = TimeEnd.HasValue ? " and alarm_time < '" + TimeEnd.Value.AddDays(1.0).ToString() + "'" : "";
//string w3 = "group by r.craft_did order by count(*) desc limit 10";
List <DataPicItem> lstAlarmCraftTopModel = new List <DataPicItem>();
if (bt != null && bt.Rows.Count > 0)
{
foreach (DataRow row in bt.Rows)
{
DataPicItem info = new DataPicItem();
info.ProductTime = DateTime.Parse(row[0].ToString());
info.OK = int.Parse(row[1].ToString());
info.total = int.Parse(row[2].ToString());
info.flo = double.Parse(row[1].ToString()) / double.Parse(row[2].ToString()) * 100;
lstAlarmCraftTopModel.Add(info);
}
}
connatl.Close();
return(lstAlarmCraftTopModel);
}
/// <summary>
/// 报警统计2
/// </summary>
/// <param name="TimeStart"></param>
/// <param name="TimeEnd"></param>
/// <returns></returns>
public IList <DataPicItem> GetDataAlarm2(DateTime?TimeStart, DateTime?TimeEnd, DateTime dates, DateTime datee)
{
//string connectionString_ATL = @"server=127.0.0.1;database=IFactory;uid=root;pwd=123456;Persist Security Info=True;Charset=utf8;";
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?DateS = dates;
DateTime?DateE = datee;
string sql = @"select ru.alarm_content,
count(0) as count
from alarm_record re
join alarm_rule ru ON re.rule_did = ru.rule_did
where ru.craft_did = 12 ";
string w1 = DateS.HasValue ? "and re.alarm_time >= '" + DateS.ToString() + "'" : "";
string w2 = DateE.HasValue ? " and re.alarm_time < '" + DateE.Value.AddDays(1.0).ToString() + "'" : "";
string w3 = " group by ru.alarm_content order by count DESC";
MySqlDataAdapter b = new MySqlDataAdapter(sql + w1 + w2 + w3, connatl);
DataTable bt = new DataTable();
b.Fill(bt);
connatl.Close();
List <DataPicItem> lstDataCapacityModel = new List <DataPicItem>();
if (bt != null && bt.Rows.Count > 0)
{
foreach (DataRow row in bt.Rows)
{
DataPicItem info = new DataPicItem();
info.Keyword = row[0].ToString();
info.Count = int.Parse(row[1].ToString());
lstDataCapacityModel.Add(info);
}
}
connatl.Close();
return(lstDataCapacityModel);
}
/// <summary>
/// 坏品数2
/// </summary>
/// <param name="TimeStart"></param>
/// <param name="TimeEnd"></param>
/// <returns></returns>
public IList <DataPicItem> GetDataNG2(DateTime?TimeStart, DateTime?TimeEnd, DateTime dates, DateTime datee)
{
//string connectionString_ATL = @"server = 127.0.0.1;database=ifactory;uid=root;pwd=123456;Persist Security Info=True;Charset=utf8;";
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?DateS = dates;
DateTime?DateE = datee;
string sql = @"select c.time
,c.NGCount
from craft_probably c
where c.nowYield <> 0 ";
string w1 = DateS.HasValue ? "and c.time >= '" + DateS.ToString() + "'" : "";
string w2 = DateE.HasValue ? " and c.time < '" + DateE.Value.AddDays(1.0).ToString() + "'" : "";
string w3 = " order by time";
MySqlDataAdapter b = new MySqlDataAdapter(sql + w1 + w2 + w3, connatl);
DataTable bt = new DataTable();
b.Fill(bt);
connatl.Close();
List <DataPicItem> lstDataCapacityModel = new List <DataPicItem>();
if (bt != null && bt.Rows.Count > 0)
{
foreach (DataRow row in bt.Rows)
{
DataPicItem info = new DataPicItem();
info.ProductTime = DateTime.Parse(row[0].ToString());
info.OK = int.Parse(row[1].ToString());
lstDataCapacityModel.Add(info);
}
}
connatl.Close();
return(lstDataCapacityModel);
}
