//public DataTable GetMP(string CostCenter) //{ // DataTable dtMPAll = new DataTable(); // dtMPAll.Columns.Add("Time", typeof(string)); // dtMPAll.Columns.Add("IDCH", typeof(string)); // dtMPAll.Columns.Add("Temp", typeof(decimal)); // DateTime strDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0); // int idx = 1; // DataTable dtManPower = new DataTable(); // return dtMPAll; //} public List <MTmpOvenInfo.MTmpAllChartInfo> GetChartTempOvenScratter(int _Month, DateTime _DataDate, string _Type) { List <MTmpOvenInfo.MTmpAllChartInfo> oListTempOven = new List <MTmpOvenInfo.MTmpAllChartInfo>(); DateTime strDate = new DateTime(DateTime.Now.Year, _Month, 1, 0, 0, 0); DateTime endDate = strDate.AddMonths(1).Date + new TimeSpan(0, 0, 0); DateTime strHr = DateTime.Today + new TimeSpan(08, 00, 00); DateTime dateEnd = DateTime.Today + new TimeSpan(20, 00, 00); DateTime Endtoday = DateTime.Now; string Channel = ""; //for (DateTime i = strHr; i <= dateEnd; i = i.AddMinutes(30)) //{ // MTmpOvenInfo.MTmpAllChartInfo oItemTempOven1 = new MTmpOvenInfo.MTmpAllChartInfo(); // oItemTempOven1.Date = i.ToString("HH:mm:ss"); if (_Type != "") { if (_Type == "CH1") { Channel = "1"; } else if (_Type == "CH2") { Channel = "2"; } else if (_Type == "CH3") { Channel = "3"; } else if (_Type == "CH4") { Channel = "4"; } else if (_Type == "CH5") { Channel = "5"; } else if (_Type == "CH6") { Channel = "6"; } else if (_Type == "CH7") { Channel = "7"; } else if (_Type == "CH8") { Channel = "8"; } else if (_Type == "CH9") { Channel = "9"; } else if (_Type == "CH10") { Channel = "10"; } else if (_Type == "CH11") { Channel = "11"; } else if (_Type == "CH12") { Channel = "12"; } // CH1 DataGet DataTable dtTempOven1 = new DataTable(); SqlCommand sqlTempOven1 = new SqlCommand(); //CH1 //sqlTempOven1.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '1'" sqlTempOven1.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '" + Channel + "'" + " and TimeStamp >= '" + strHr + "' and TimeStamp <= '" + Endtoday + "' order by TimeStamp asc "; sqlTempOven1.Parameters.Add(new SqlParameter("@day", strHr.Day.ToString())); dtTempOven1 = oConn.SqlGet(sqlTempOven1); //for (DateTime i = strHr; i <= Endtoday; i = i.AddMinutes(15)) //{ foreach (DataRow row in dtTempOven1.Rows) { MTmpOvenInfo.MTmpAllChartInfo oItemTempOven1 = new MTmpOvenInfo.MTmpAllChartInfo(); oItemTempOven1.Date = Convert.ToDateTime(row["TimeStamp"].ToString()).ToString("HH:mm:ss"); // oItemTempOven1.IDCH = Convert.ToDouble(Channel.ToString()); oItemTempOven1.CH = Convert.ToDouble(row["Temp"].ToString()) / 10.0; oListTempOven.Add(oItemTempOven1); // oListTempOven.Add(oItemTempOven); } // oItemTempOven.Date = i.ToString("HH:mm:ss"); //} /* * // CH2 DataGet * DataTable dtTempOven2 = new DataTable(); * SqlCommand sqlTempOven2 = new SqlCommand(); * * // CH2 * sqlTempOven2.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '2'" + " and TimeStamp >= '" + strHr + "' and TimeStamp <= '" + dateEnd + "' order by TimeStamp asc "; + sqlTempOven2.Parameters.Add(new SqlParameter("@day", strHr.Day.ToString())); + dtTempOven2 = oConn.SqlGet(sqlTempOven2); + + + + + foreach (DataRow row in dtTempOven2.Rows) + { + + MTmpOvenInfo.MTmpAllChartInfo oItemTempOven2 = new MTmpOvenInfo.MTmpAllChartInfo(); + // oItemTempOven2.Date = Convert.ToDateTime(row["TimeStamp"].ToString()).ToString("HH:mm:ss"); + oItemTempOven2.CH2 = Convert.ToDouble(row["Temp"].ToString()) / 10.0; + + oListTempOven.Add(oItemTempOven2); + + }*/ // oListTempOven.Add(oItemTempOven); //} } return(oListTempOven); }
public List <MTmpOvenInfo.MTmpAllChartInfo> GetChartTempOven(int _Month, DateTime _DataSDate, DateTime _DataEDate, string _Type) { List <MTmpOvenInfo.MTmpAllChartInfo> oListTempOven = new List <MTmpOvenInfo.MTmpAllChartInfo>(); DateTime strDate = new DateTime(DateTime.Now.Year, _Month, 1, 0, 0, 0); DateTime endDate = strDate.AddMonths(1).Date + new TimeSpan(0, 0, 0); DateTime strHr = _DataSDate + new TimeSpan(08, 00, 00); //DateTime strHr = DateTime.Today + new TimeSpan(08, 00, 00); DateTime dateEnd = DateTime.Today + new TimeSpan(20, 00, 00); DateTime Endtoday = _DataEDate.AddDays(1) + new TimeSpan(08, 00, 00); //DateTime Endtoday = DateTime.Now; string Channel = ""; //for (DateTime i = strHr; i <= dateEnd; i = i.AddMinutes(15)) //{ // MTmpOvenInfo.MTmpAllChartInfo oItemTempOven1 = new MTmpOvenInfo.MTmpAllChartInfo(); // oItemTempOven1.Date = i.ToString("HH:mm:ss"); string IDCHSql = ""; if (_Type != "") { if (_Type == "ALL") { Channel = "All"; IDCHSql = " IDCH = '" + Channel + "'"; } else { Channel = _Type.Substring(2); IDCHSql = " IDCH = '" + Channel + "'"; } // CH1 DataGet DataTable dtTempOven1 = new DataTable(); SqlCommand sqlTempOven1 = new SqlCommand(); //CH1 //sqlTempOven1.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '1'" sqlTempOven1.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where " + IDCHSql + " and TimeStamp >= '" + strHr + "' and TimeStamp <= '" + Endtoday + "' order by TimeStamp asc "; // sqlTempOven1.Parameters.Add(new SqlParameter("@day", strHr.Day.ToString())); dtTempOven1 = oConn.SqlGet(sqlTempOven1); //for (DateTime i = strHr; i <= Endtoday; i = i.AddMinutes(15)) //{ //int kk = 0; //for (kk = 0; kk <= dtTempOven1.Rows.Count;kk++) //{ //} //MTmpOvenInfo.MTmpAllChartInfo oItemTempOven = new MTmpOvenInfo.MTmpAllChartInfo(); //oItemTempOven.Date = i.ToString("HH:mm:ss"); // string Period = i.ToString("HH:m:ss"); foreach (DataRow row in dtTempOven1.Rows) { MTmpOvenInfo.MTmpAllChartInfo oItemTempOven1 = new MTmpOvenInfo.MTmpAllChartInfo(); oItemTempOven1.Date = Convert.ToDateTime(row["TimeStamp"].ToString()).ToString("dd-MMM HH:mm:ss"); // oItemTempOven1.IDCH = Convert.ToDouble(Channel.ToString()); oItemTempOven1.CH = Convert.ToDouble(row["Temp"].ToString()) / 10.0; oItemTempOven1.STPoint = 130; oItemTempOven1.Max = 150; oItemTempOven1.Min = 130; oListTempOven.Add(oItemTempOven1); // oListTempOven.Add(oItemTempOven); } // oItemTempOven.Date = i.ToString("HH:mm:ss"); //} /* * // CH2 DataGet * DataTable dtTempOven2 = new DataTable(); * SqlCommand sqlTempOven2 = new SqlCommand(); * * // CH2 * sqlTempOven2.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '2'" + " and TimeStamp >= '" + strHr + "' and TimeStamp <= '" + dateEnd + "' order by TimeStamp asc "; + sqlTempOven2.Parameters.Add(new SqlParameter("@day", strHr.Day.ToString())); + dtTempOven2 = oConn.SqlGet(sqlTempOven2); + + + + + foreach (DataRow row in dtTempOven2.Rows) + { + + // MTmpOvenInfo.MTmpAllChartInfo oItemTempOven2 = new MTmpOvenInfo.MTmpAllChartInfo(); + // oItemTempOven2.Date = Convert.ToDateTime(row["TimeStamp"].ToString()).ToString("dd HH:mm:ss"); + oItemTempOven1.CH2 = Convert.ToDouble(row["Temp"].ToString()) / 10.0; + + oListTempOven.Add(oItemTempOven1); + + }*/ // oListTempOven.Add(oItemTempOven); //} } return(oListTempOven); }