//工作日数 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); }