public List <MTempOvenInfo> GetChartTempOvenCH(int Month, string BoardID)
{
List <MTempOvenInfo> oListTempOven = new List <MTempOvenInfo>();
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(23, 59, 59);
for (DateTime i = strHr; dateEnd.CompareTo(i) > 0; i = i.AddDays(1))
{
DataTable dtTempOven = new DataTable();
SqlCommand sqlTempOven = new SqlCommand();
DateTime ChDate = strDate;
// if (strHr <= dateEnd)
// {
MTempOvenInfo oItemTempOven = new MTempOvenInfo();
sqlTempOven.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '1'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven = oConn.SqlGet(sqlTempOven);
for (int ii = 1; ii <= 701; ii++) //---------- Loop for 1 Min - 701 Min Is 8:20 - 20:00 ------------
{
if (dtTempOven.Rows.Count > 0)
{
oItemTempOven.Temp1 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
// foreach (DataRow row in dtTempOven.Rows)
// {
// oItemTempOven.DTemp1 = Convert.ToDouble(row["Temp"].ToString()) / 10.0; ;
// }
}
}
// }
}
return(oListTempOven);
}
// sqlTempOven.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '1' " +
// " and MONTH(TimeStamp) = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
// sqlTempOven.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = " +
// "'" + CH + " ' " + "and MONTH(TimeStamp) " +
// " = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
/* sqlTempOven.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
* sqlTempOven.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
* sqlTempOven.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
*
* dtTempOven = oConn.SqlGet(sqlTempOven);*/
//}
//---------------- Get Energy Line Main 301 from Costy ------------
//------------------------- Fillter Data Actual Each Day ---------------------
//Tuple<int, int> resultMain = oPD.GetActualMainAssyIoT(BoardID, i);
//int Actual = resultMain.Item1 + resultMain.Item2;
// int Actual = 0;
// DataRow[] _fillActual = dtActual.Select("Date = '" + i.ToString("dd") + "'");
// if (_fillActual.Length > 0)
// {
// Actual = Convert.ToInt16(_fillActual[0]["Actual"].ToString());
// }
//------------------------- Fillter Data Actual Each Day ---------------------
// decimal costkwh = 0, kwh = 0;
//double TempValue = 0;
// if (dtTempOven.Rows.Count > 0)
// {
// int Record = dtTempOven.Rows.Count;
// for (int ii = 0; ii < dtTempOven.Rows.Count; ii++)
// {
//dtTempOven.Rows[0]["IDCH"].ToString()
// switch (dtTempOven.Rows[ii]["IDCH"].ToString())
// {
// case "2":
// oItemTempOven.TempValue = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
// oItemTempOven.IDCH = Convert.ToChar(dtTempOven.Rows[0]["IDCH"]);
/* if (dtTempOven.Rows[0]["IDCH"].ToString() == "1")
* {
* oItemTempOven.Temp1 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
* }
* else if (dtTempOven.Rows[0]["IDCH"].ToString() == "2")
* {
* oItemTempOven.Temp2 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
* }
* else if (dtTempOven.Rows[0]["IDCH"].ToString() == "3")
* {
* oItemTempOven.Temp3 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
* }
* else if (dtTempOven.Rows[0]["IDCH"].ToString() == "4")
* {
* oItemTempOven.Temp4 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
* }
*
* else if (dtTempOven.Rows[0]["IDCH"].ToString() == "5")
* {
* oItemTempOven.Temp5 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
* }
* else if (dtTempOven.Rows[0]["IDCH"].ToString() == "6")
* {
* oItemTempOven.Temp6 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
* }
* else if (dtTempOven.Rows[0]["IDCH"].ToString() == "7")
* {
* oItemTempOven.Temp7 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
* }
*
* else if (dtTempOven.Rows[0]["IDCH"].ToString() == "8")
* {
* oItemTempOven.Temp8 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
*
* }
* else if (dtTempOven.Rows[0]["IDCH"].ToString() == "9")
* {
* oItemTempOven.Temp9 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
* }
* else if (dtTempOven.Rows[0]["IDCH"].ToString() == "10")
* {
* oItemTempOven.Temp10 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
* }
* else if (dtTempOven.Rows[0]["IDCH"].ToString() == "11")
* {
* oItemTempOven.Temp11 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
* }
* else if (dtTempOven.Rows[0]["IDCH"].ToString() == "12")
* {
* oItemTempOven.Temp12 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
* }*/
//oItemTempOven.Date = Convert.ToChar(dtTempOven.Rows[0]["IDCH"]);
// oItemTempOven.TempValue(ii) = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
// break;
// case "3":
// oItemTempOven.TempValue2 = Convert.ToDouble(dtTempOven.Rows[ii]["Temp"].ToString()) / 10.0;
// oItemTempOven.TempValue1(ii) = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
// break;
// }
// if (dtTempOven.Rows[0]["IDCH"].ToString() == "1")
// {
// oItemTempOven.IDCH = Convert.ToDouble(dtTempOven.Rows[0]["IDCH"].ToString());
// oItemTempOven.TempValue1 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
// }
// else
// {
// oItemTempOven.TempValue = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
// }
// }
/* kwh = 0;
*
* try
* {
* kwh = Convert.ToDecimal(dtTempOven.Rows[0]["Temp"].ToString()) * 2;
*
* }
* catch { }
*
* if (Actual > 0)
* {
* costkwh = (kwh / Convert.ToDecimal(Actual)) * Convert.ToDecimal(3.86);
* oItemTempOven.CostKwh = Math.Round(costkwh, 2);
*
* }*/
// oItemTempOven.CostGas = null;
// oItemTempOven.CostWater = null;
//---------------- Hardcode set data is NULL ----------------
/* if (i.Day >= 1 && i.Day <= 22 && i.Month == 4)
* {
* oItemTempOven.CostKwh = null;
* oItemTempOven.CostGas = null;
* oItemTempOven.CostWater = null;
* }*/
// oListTempOven.Add(oItemTempOven);
// }
// }
// else
// {
/* oItemTempOven.CostKwh = null;
* oItemTempOven.CostGas = null;
* oItemTempOven.CostWater = null;
* oItemTempOven.TempValue = null;*/
// oItemTempOven.TempValue1 = null;
// oItemTempOven.TempValue2 = null;
// }
// oListTempOven.Add(oItemTempOven);
// }
// return oListTempOven;
public List <MTempOvenInfo> GetChartTempOvenCH(int Month, int Channel, string BoardID)
{
List <MTempOvenInfo> oListTempOven = new List <MTempOvenInfo>();
DateTime strDate = new DateTime(DateTime.Now.Year, Month, 1, 0, 0, 0);
DateTime endDate = strDate.AddMonths(1).Date + new TimeSpan(0, 0, 0);
for (DateTime i = strDate; endDate.CompareTo(i) > 0; i = i.AddDays(1))
{
// DataTable dtActual = oPD.GetDataActualOfMonth(BoardID, Month, DateTime.Now.Year);
DataTable dtTempOven = new DataTable();
SqlCommand sqlTempOven = new SqlCommand();
DateTime ChDate = strDate;
if (i == (DateTime.Today))
{
MTempOvenInfo oItemTempOven = new MTempOvenInfo();
sqlTempOven.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '1'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven = oConn.SqlGet(sqlTempOven);
// for (DateTime i = strDate; endDate.CompareTo(i) > 0; i = i.AddDays(1))
// {
for (int ii = 1; ii <= 701; ii++)//---------- Loop for 1 Min - 701 Min Is 8:20 - 20:00 ------------
{
// MDataGraph oMDPlan = new MDataGraph();
// int plan = 0;
// oMDPlan.Target = DailyPlan;
// if (CurrDate > DateNow)
// {
// oMDPlan.PlanAccu = null;// Convert.ToInt32(ComPerMin);
// oMDPlan.ActualAccu = null;
// oMDPlan.EffiAccu = null;
// }
// else
// {
//-------- Get Data Plan Form Andon Board Table DataLog -----------
if (dtTempOven.Rows.Count > 0)
{
oItemTempOven.Temp1 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row in dtTempOven.Rows)
{
// oMD.mhi_id = row["mhi_id"].ToString();
oItemTempOven.DTemp1 = Convert.ToDouble(row["Temp"].ToString()) / 10.0;;
}
}
}
}
}
return(oListTempOven);
}
public List <MTempOvenInfo> GetChartTempOven(int Month, string BoardID)
{
List <MTempOvenInfo> oListTempOven = new List <MTempOvenInfo>();
DateTime strDate = new DateTime(DateTime.Now.Year, Month, 1, 0, 0, 0);
DateTime endDate = strDate.AddMonths(1).Date + new TimeSpan(0, 0, 0);
// DataTable dtActual = oPD.GetDataActualOfMonth(BoardID, Month, DateTime.Now.Year);
for (DateTime i = strDate; endDate.CompareTo(i) > 0; i = i.AddDays(1))
{
// MTempOvenInfo oItemTempOven = new MTempOvenInfo();
// oItemTempOven.Date = i.ToString("dd");
// oItemTempOven.CostKwhTarget = Convert.ToDecimal(oTarget.GetTargetChart("Daily", "Energy Cost"));
DateTime dateEnd = i.Date + new TimeSpan(23, 59, 59);
// DataTable dtTempOven = new DataTable();
// SqlCommand sqlTempOven = new SqlCommand();
if (i == (DateTime.Today))
{
//---------------- Get Energy Line Main 301 from Costy ------------
// if (BoardID == "301")
// {
/* sqlTempOven.CommandText = "SELECT TOP 1 ((SELECT TOP 1 MAX(kWh) FROM [Scada_kWh] AS SUB1" +
* " WHERE MONTH(StarmTime) = @month AND YEAR(StarmTime) = @year AND DAY(StarmTime) = @day AND MeterID IN('5')) -" +
* " (SELECT TOP 1 MIN(kWh) FROM [Scada_kWh] AS SUB1" +
* " WHERE MONTH(StarmTime) = @month2 AND YEAR(StarmTime) = @year2 AND DAY(StarmTime) = @day2 AND MeterID IN('5'))) AS Kwh" +
* " FROM [Scada_kWh] WHERE MONTH(StarmTime) = @month3 AND YEAR(StarmTime) = @year3 AND DAY(StarmTime) = @day3 AND MeterID IN('5')";
*
* sqlTempOven.Parameters.Add(new SqlParameter("@month", i.Month.ToString()));
* sqlTempOven.Parameters.Add(new SqlParameter("@month2", i.Month.ToString()));
* sqlTempOven.Parameters.Add(new SqlParameter("@month3", i.Month.ToString()));
* sqlTempOven.Parameters.Add(new SqlParameter("@year", i.Year.ToString()));
* sqlTempOven.Parameters.Add(new SqlParameter("@year2", i.Year.ToString()));
* sqlTempOven.Parameters.Add(new SqlParameter("@year3", i.Year.ToString()));
* sqlTempOven.Parameters.Add(new SqlParameter("@day", i.Day.ToString()));
* sqlTempOven.Parameters.Add(new SqlParameter("@day2", i.Day.ToString()));
* sqlTempOven.Parameters.Add(new SqlParameter("@day3", i.Day.ToString()));*/
// for (int ii = 1; ii <= 12; ii++)
// {
MTempOvenInfo oItemTempOven = new MTempOvenInfo();
oItemTempOven.Date = DateTime.Now.ToString("dd/MMM/yyyy HH:mm:ss");
DataTable dtTempOven = new DataTable();
DataTable dtTempOven2 = new DataTable();
DataTable dtTempOven3 = new DataTable();
DataTable dtTempOven4 = new DataTable();
DataTable dtTempOven5 = new DataTable();
DataTable dtTempOven6 = new DataTable();
DataTable dtTempOven7 = new DataTable();
DataTable dtTempOven8 = new DataTable();
DataTable dtTempOven9 = new DataTable();
DataTable dtTempOven10 = new DataTable();
DataTable dtTempOven11 = new DataTable();
DataTable dtTempOven12 = new DataTable();
SqlCommand sqlTempOven = new SqlCommand();
SqlCommand sqlTempOven2 = new SqlCommand();
SqlCommand sqlTempOven3 = new SqlCommand();
SqlCommand sqlTempOven4 = new SqlCommand();
SqlCommand sqlTempOven5 = new SqlCommand();
SqlCommand sqlTempOven6 = new SqlCommand();
SqlCommand sqlTempOven7 = new SqlCommand();
SqlCommand sqlTempOven8 = new SqlCommand();
SqlCommand sqlTempOven9 = new SqlCommand();
SqlCommand sqlTempOven10 = new SqlCommand();
SqlCommand sqlTempOven11 = new SqlCommand();
SqlCommand sqlTempOven12 = new SqlCommand();
// int CH = ii;
//CH1
sqlTempOven.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '1'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day ";
sqlTempOven.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven = oConn.SqlGet(sqlTempOven);
if (dtTempOven.Rows.Count > 0)
{
oItemTempOven.Temp1 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
// foreach (DataRow row in dtTempOven.Rows)
// {
// oMD.mhi_id = row["mhi_id"].ToString();
// oItemTempOven.DTemp1 = Convert.ToDouble(row["Temp"].ToString()) / 10.0; ;
// }
}
// sqlTempOven.Cancel();
// dtTempOven.Clear(
//CH2
sqlTempOven2.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '2'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven2.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven2.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven2.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven2 = oConn.SqlGet(sqlTempOven2);
if (dtTempOven2.Rows.Count > 0)
{
oItemTempOven.Temp2 = Convert.ToDouble(dtTempOven2.Rows[0]["Temp"].ToString()) / 10.0;
}
//CH3
sqlTempOven3.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '3'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven3.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven3.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven3.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven3 = oConn.SqlGet(sqlTempOven3);
if (dtTempOven3.Rows.Count > 0)
{
oItemTempOven.Temp3 = Convert.ToDouble(dtTempOven3.Rows[0]["Temp"].ToString()) / 10.0;
}
//CH4
sqlTempOven4.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '4'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven4.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven4.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven4.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven4 = oConn.SqlGet(sqlTempOven4);
if (dtTempOven4.Rows.Count > 0)
{
oItemTempOven.Temp4 = Convert.ToDouble(dtTempOven4.Rows[0]["Temp"].ToString()) / 10.0;
}
//CH5
sqlTempOven5.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '5'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven5.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven5.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven5.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven5 = oConn.SqlGet(sqlTempOven5);
if (dtTempOven5.Rows.Count > 0)
{
oItemTempOven.Temp5 = Convert.ToDouble(dtTempOven5.Rows[0]["Temp"].ToString()) / 10.0;
}
//CH6
sqlTempOven6.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '6'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven6.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven6.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven6.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven6 = oConn.SqlGet(sqlTempOven6);
if (dtTempOven6.Rows.Count > 0)
{
oItemTempOven.Temp6 = Convert.ToDouble(dtTempOven6.Rows[0]["Temp"].ToString()) / 10.0;
}
//CH7
sqlTempOven7.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '7'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven7.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven7.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven7.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven7 = oConn.SqlGet(sqlTempOven7);
if (dtTempOven7.Rows.Count > 0)
{
oItemTempOven.Temp7 = Convert.ToDouble(dtTempOven7.Rows[0]["Temp"].ToString()) / 10.0;
}
//CH8
sqlTempOven8.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '8'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven8.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven8.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven8.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven8 = oConn.SqlGet(sqlTempOven8);
if (dtTempOven8.Rows.Count > 0)
{
oItemTempOven.Temp8 = Convert.ToDouble(dtTempOven8.Rows[0]["Temp"].ToString()) / 10.0;
}
//CH9
sqlTempOven9.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '9'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven9.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven9.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven9.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven9 = oConn.SqlGet(sqlTempOven9);
if (dtTempOven9.Rows.Count > 0)
{
oItemTempOven.Temp9 = Convert.ToDouble(dtTempOven9.Rows[0]["Temp"].ToString()) / 10.0;
}
//CH10
sqlTempOven10.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '10'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven10.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven10.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven10.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven10 = oConn.SqlGet(sqlTempOven10);
if (dtTempOven10.Rows.Count > 0)
{
oItemTempOven.Temp10 = Convert.ToDouble(dtTempOven10.Rows[0]["Temp"].ToString()) / 10.0;
}
//CH11
sqlTempOven11.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '11'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven11.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven11.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven11.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven11 = oConn.SqlGet(sqlTempOven11);
if (dtTempOven11.Rows.Count > 0)
{
oItemTempOven.Temp11 = Convert.ToDouble(dtTempOven11.Rows[0]["Temp"].ToString()) / 10.0;
}
//CH12
sqlTempOven12.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '12'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven12.Parameters.Add(new SqlParameter("@month", strDate.Month.ToString()));
sqlTempOven12.Parameters.Add(new SqlParameter("@year", strDate.Year.ToString()));
sqlTempOven12.Parameters.Add(new SqlParameter("@day", strDate.Day.ToString()));
dtTempOven12 = oConn.SqlGet(sqlTempOven12);
if (dtTempOven12.Rows.Count > 0)
{
oItemTempOven.Temp12 = Convert.ToDouble(dtTempOven12.Rows[0]["Temp"].ToString()) / 10.0;
}
oListTempOven.Add(oItemTempOven);
// }
}
}
return(oListTempOven);
}
public List <MTempOvenInfo> GetChartTempOven(int Month, string BoardID)
{
List <MTempOvenInfo> oListTempOven = new List <MTempOvenInfo>();
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;
// DataTable dtActual = oPD.GetDataActualOfMonth(BoardID, Month, DateTime.Now.Year);
for (DateTime i = strHr; i <= Endtoday; i = i.AddMinutes(15))
{
// MTempOvenInfo oItemTempOven = new MTempOvenInfo();
// oItemTempOven.Date = i.ToString("dd");
// oItemTempOven.CostKwhTarget = Convert.ToDecimal(oTarget.GetTargetChart("Daily", "Energy Cost"));
// DateTime dateEnd = i.Date + new TimeSpan(23, 59, 59);
// DataTable dtTempOven = new DataTable();
// SqlCommand sqlTempOven = new SqlCommand();
DateTime Sqlstrdate = DateTime.Now;
// if (i == (DateTime.Today))
// {
MTempOvenInfo oItemTempOven = new MTempOvenInfo();
oItemTempOven.Date = i.ToString("HH:mm:ss");
DataTable dtTempOven1 = new DataTable();
DataTable dtTempOven2 = new DataTable();
DataTable dtTempOven3 = new DataTable();
DataTable dtTempOven4 = new DataTable();
DataTable dtTempOven5 = new DataTable();
DataTable dtTempOven6 = new DataTable();
DataTable dtTempOven7 = new DataTable();
DataTable dtTempOven8 = new DataTable();
DataTable dtTempOven9 = new DataTable();
DataTable dtTempOven10 = new DataTable();
DataTable dtTempOven11 = new DataTable();
DataTable dtTempOven12 = new DataTable();
SqlCommand sqlTempOven1 = new SqlCommand();
SqlCommand sqlTempOven2 = new SqlCommand();
SqlCommand sqlTempOven3 = new SqlCommand();
SqlCommand sqlTempOven4 = new SqlCommand();
SqlCommand sqlTempOven5 = new SqlCommand();
SqlCommand sqlTempOven6 = new SqlCommand();
SqlCommand sqlTempOven7 = new SqlCommand();
SqlCommand sqlTempOven8 = new SqlCommand();
SqlCommand sqlTempOven9 = new SqlCommand();
SqlCommand sqlTempOven10 = new SqlCommand();
SqlCommand sqlTempOven11 = new SqlCommand();
SqlCommand sqlTempOven12 = new SqlCommand();
//CH1
sqlTempOven1.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '1'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day Order by TimeStamp asc";
sqlTempOven1.Parameters.Add(new SqlParameter("@month", strHr.Month.ToString()));
sqlTempOven1.Parameters.Add(new SqlParameter("@year", strHr.Year.ToString()));
sqlTempOven1.Parameters.Add(new SqlParameter("@day", strHr.Day.ToString()));
dtTempOven1 = oConn.SqlGet(sqlTempOven1);
if (dtTempOven1.Rows.Count > 0)
{
// oItemTempOven.Temp1 = Convert.ToDouble(dtTempOven.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row in dtTempOven1.Rows)
{
// DateTime PP = Convert.ToDateTime(row["TimeStamp"]);
DateTime ii = i.AddMinutes(5);
// if (ii == Convert.ToDateTime(row["TimeStamp"]))
// {
oItemTempOven.Temp1 = Convert.ToDouble(row["Temp"].ToString()) / 10.0;
// }
}
}
//CH2
sqlTempOven2.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '2'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by TimeStamp asc";
sqlTempOven2.Parameters.Add(new SqlParameter("@month", Sqlstrdate.Month.ToString()));
sqlTempOven2.Parameters.Add(new SqlParameter("@year", Sqlstrdate.Year.ToString()));
sqlTempOven2.Parameters.Add(new SqlParameter("@day", Sqlstrdate.Day.ToString()));
dtTempOven2 = oConn.SqlGet(sqlTempOven2);
if (dtTempOven2.Rows.Count > 0)
{
// oItemTempOven.Temp2 = Convert.ToDouble(dtTempOven2.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row2 in dtTempOven2.Rows)
{
oItemTempOven.Temp2 = Convert.ToDouble(row2["Temp"].ToString()) / 10.0;
}
}
//CH3
sqlTempOven3.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '3'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven3.Parameters.Add(new SqlParameter("@month", Sqlstrdate.Month.ToString()));
sqlTempOven3.Parameters.Add(new SqlParameter("@year", Sqlstrdate.Year.ToString()));
sqlTempOven3.Parameters.Add(new SqlParameter("@day", Sqlstrdate.Day.ToString()));
dtTempOven3 = oConn.SqlGet(sqlTempOven3);
if (dtTempOven3.Rows.Count > 0)
{
// oItemTempOven.Temp3 = Convert.ToDouble(dtTempOven3.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row3 in dtTempOven3.Rows)
{
oItemTempOven.Temp3 = Convert.ToDouble(row3["Temp"].ToString()) / 10.0;
}
}
//CH4
sqlTempOven4.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '4'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven4.Parameters.Add(new SqlParameter("@month", Sqlstrdate.Month.ToString()));
sqlTempOven4.Parameters.Add(new SqlParameter("@year", Sqlstrdate.Year.ToString()));
sqlTempOven4.Parameters.Add(new SqlParameter("@day", Sqlstrdate.Day.ToString()));
dtTempOven4 = oConn.SqlGet(sqlTempOven4);
if (dtTempOven4.Rows.Count > 0)
{
// oItemTempOven.Temp4 = Convert.ToDouble(dtTempOven4.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row4 in dtTempOven4.Rows)
{
oItemTempOven.Temp4 = Convert.ToDouble(row4["Temp"].ToString()) / 10.0;
}
}
//CH5
sqlTempOven5.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '5'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven5.Parameters.Add(new SqlParameter("@month", Sqlstrdate.Month.ToString()));
sqlTempOven5.Parameters.Add(new SqlParameter("@year", Sqlstrdate.Year.ToString()));
sqlTempOven5.Parameters.Add(new SqlParameter("@day", Sqlstrdate.Day.ToString()));
dtTempOven5 = oConn.SqlGet(sqlTempOven5);
if (dtTempOven5.Rows.Count > 0)
{
// oItemTempOven.Temp5 = Convert.ToDouble(dtTempOven5.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row5 in dtTempOven5.Rows)
{
oItemTempOven.Temp5 = Convert.ToDouble(row5["Temp"].ToString()) / 10.0;
}
}
//CH6
sqlTempOven6.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '6'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven6.Parameters.Add(new SqlParameter("@month", Sqlstrdate.Month.ToString()));
sqlTempOven6.Parameters.Add(new SqlParameter("@year", Sqlstrdate.Year.ToString()));
sqlTempOven6.Parameters.Add(new SqlParameter("@day", Sqlstrdate.Day.ToString()));
dtTempOven6 = oConn.SqlGet(sqlTempOven6);
if (dtTempOven6.Rows.Count > 0)
{
// oItemTempOven.Temp6 = Convert.ToDouble(dtTempOven6.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row6 in dtTempOven6.Rows)
{
oItemTempOven.Temp6 = Convert.ToDouble(row6["Temp"].ToString()) / 10.0;
}
}
//CH7
sqlTempOven7.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '7'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven7.Parameters.Add(new SqlParameter("@month", Sqlstrdate.Month.ToString()));
sqlTempOven7.Parameters.Add(new SqlParameter("@year", Sqlstrdate.Year.ToString()));
sqlTempOven7.Parameters.Add(new SqlParameter("@day", Sqlstrdate.Day.ToString()));
dtTempOven7 = oConn.SqlGet(sqlTempOven7);
if (dtTempOven7.Rows.Count > 0)
{
//oItemTempOven.Temp7 = Convert.ToDouble(dtTempOven7.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row7 in dtTempOven7.Rows)
{
oItemTempOven.Temp7 = Convert.ToDouble(row7["Temp"].ToString()) / 10.0;
}
}
//CH8
sqlTempOven8.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '8'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven8.Parameters.Add(new SqlParameter("@month", Sqlstrdate.Month.ToString()));
sqlTempOven8.Parameters.Add(new SqlParameter("@year", Sqlstrdate.Year.ToString()));
sqlTempOven8.Parameters.Add(new SqlParameter("@day", Sqlstrdate.Day.ToString()));
dtTempOven8 = oConn.SqlGet(sqlTempOven8);
if (dtTempOven8.Rows.Count > 0)
{
// oItemTempOven.Temp8 = Convert.ToDouble(dtTempOven8.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row8 in dtTempOven8.Rows)
{
oItemTempOven.Temp8 = Convert.ToDouble(row8["Temp"].ToString()) / 10.0;
}
}
//CH9
sqlTempOven9.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '9'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven9.Parameters.Add(new SqlParameter("@month", Sqlstrdate.Month.ToString()));
sqlTempOven9.Parameters.Add(new SqlParameter("@year", Sqlstrdate.Year.ToString()));
sqlTempOven9.Parameters.Add(new SqlParameter("@day", Sqlstrdate.Day.ToString()));
dtTempOven9 = oConn.SqlGet(sqlTempOven9);
if (dtTempOven9.Rows.Count > 0)
{
// oItemTempOven.Temp9 = Convert.ToDouble(dtTempOven9.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row9 in dtTempOven9.Rows)
{
oItemTempOven.Temp9 = Convert.ToDouble(row9["Temp"].ToString()) / 10.0;
}
}
//CH10
sqlTempOven10.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '10'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven10.Parameters.Add(new SqlParameter("@month", Sqlstrdate.Month.ToString()));
sqlTempOven10.Parameters.Add(new SqlParameter("@year", Sqlstrdate.Year.ToString()));
sqlTempOven10.Parameters.Add(new SqlParameter("@day", Sqlstrdate.Day.ToString()));
dtTempOven10 = oConn.SqlGet(sqlTempOven10);
if (dtTempOven10.Rows.Count > 0)
{
// oItemTempOven.Temp10 = Convert.ToDouble(dtTempOven10.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row10 in dtTempOven10.Rows)
{
oItemTempOven.Temp10 = Convert.ToDouble(row10["Temp"].ToString()) / 10.0;
}
}
//CH11
sqlTempOven11.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '11'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven11.Parameters.Add(new SqlParameter("@month", Sqlstrdate.Month.ToString()));
sqlTempOven11.Parameters.Add(new SqlParameter("@year", Sqlstrdate.Year.ToString()));
sqlTempOven11.Parameters.Add(new SqlParameter("@day", Sqlstrdate.Day.ToString()));
dtTempOven11 = oConn.SqlGet(sqlTempOven11);
if (dtTempOven11.Rows.Count > 0)
{
// oItemTempOven.Temp11 = Convert.ToDouble(dtTempOven11.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row11 in dtTempOven11.Rows)
{
oItemTempOven.Temp11 = Convert.ToDouble(row11["Temp"].ToString()) / 10.0;
}
}
//CH12
sqlTempOven12.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where IDCH = '12'" +
" and MONTH(TimeStamp) " +
" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day order by IDCH asc, TimeStamp DESC";
sqlTempOven12.Parameters.Add(new SqlParameter("@month", Sqlstrdate.Month.ToString()));
sqlTempOven12.Parameters.Add(new SqlParameter("@year", Sqlstrdate.Year.ToString()));
sqlTempOven12.Parameters.Add(new SqlParameter("@day", Sqlstrdate.Day.ToString()));
dtTempOven12 = oConn.SqlGet(sqlTempOven12);
if (dtTempOven12.Rows.Count > 0)
{
// oItemTempOven.Temp12 = Convert.ToDouble(dtTempOven12.Rows[0]["Temp"].ToString()) / 10.0;
foreach (DataRow row12 in dtTempOven12.Rows)
{
oItemTempOven.Temp12 = Convert.ToDouble(row12["Temp"].ToString()) / 10.0;
}
}
oListTempOven.Add(oItemTempOven);
// }
}
return(oListTempOven);
}
public List <MTempOvenInfo> GetChartTempOvenCH(int Month, string BoardID)
{
List <MTempOvenInfo> oListTempOven = new List <MTempOvenInfo>();
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(23, 59, 59);
for (DateTime i = strHr; dateEnd.CompareTo(i) > 0; i = i.AddDays(1))
{
DataTable dtTempOven1 = new DataTable();
SqlCommand sqlTempOven1 = new SqlCommand();
DateTime ChDate = strDate;
// if (strHr <= dateEnd)
// {
MTempOvenInfo oItemTempOven = new MTempOvenInfo();
oItemTempOven.Date = i.ToString("HH:mm:ss");
sqlTempOven1.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where "
+ "TimeStamp >= '" + strHr + "' and TimeStamp <= '" + dateEnd + "' order by TimeStamp asc ";
// sqlTempOven1.CommandText = "Select IDCH,Temp,TimeStamp from [FN_TempOven] where " +
// " MONTH(TimeStamp) " +
//" = @month AND YEAR(TimeStamp) = @year AND DAY(TimeStamp) = @day Order by TimeStamp asc";
// sqlTempOven1.Parameters.Add(new SqlParameter("@month", strHr.Month.ToString()));
// sqlTempOven1.Parameters.Add(new SqlParameter("@year", strHr.Year.ToString()));
// sqlTempOven1.Parameters.Add(new SqlParameter("@day", strHr.Day.ToString()));
dtTempOven1 = oConn.SqlGet(sqlTempOven1);
// dtTempOven = oConn.SqlGet(sqlTempOven);
int IDCH = 0;
for (int ii = 1; ii <= 701; ii++) //---------- Loop for 1 Min - 701 Min Is 8:20 - 20:00 ------------
{
//oItemTempOven.Date = i.ToString("HH:mm:ss");
if (dtTempOven1.Rows.Count > 0)
{
// MTempOvenInfo oItemTempOven1 = new MTempOvenInfo();
//MTempOvenInfo oItemTempOven1 = new MTempOvenInfo();
//oItemTempOven.Date = i.ToString("HH:mm:ss");
// IDCH = Convert.ToInt16(dtTempOven1.Rows[ii]["IDCH"].ToString());
foreach (DataRow row1 in dtTempOven1.Select("IDCH=1"))
{
MTempOvenInfo oItemTempOven1 = new MTempOvenInfo();
oItemTempOven1.Temp1 = Convert.ToDouble(row1["Temp"].ToString()) / 10.0;
oListTempOven.Add(oItemTempOven1);
}
foreach (DataRow row2 in dtTempOven1.Select("IDCH=2"))
{
MTempOvenInfo oItemTempOven2 = new MTempOvenInfo();
oItemTempOven2.Temp2 = Convert.ToDouble(row2["Temp"].ToString()) / 10.0;
oListTempOven.Add(oItemTempOven2);
}
//oListTempOven.Add(oItemTempOven1);
}
}
// }
}
return(oListTempOven);
}