public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
OvenBarcodeVo inVo = (OvenBarcodeVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <OvenBarcodeVo> voList = new ValueObjectList <OvenBarcodeVo>();
OvenBarcodeVo von = new OvenBarcodeVo();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select case when count(*) = 0 then '110' else max(range_upper) end ca from m_ovenmachinels12_range where 1=1 ");
if (!String.IsNullOrEmpty(inVo.Model))
{
sql.Append(@" and range_model = :range_model ");
sqlParameter.AddParameterString("range_model", inVo.Model);
}
if (!String.IsNullOrEmpty(inVo.Process))
{
sql.Append(@" and range_process = :range_process ");
sqlParameter.AddParameterString("range_process", inVo.Process);
}
sql.Append(" limit 1");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
string dataReader = "";
//execute SQL
dataReader = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString();
von.Upper = dataReader;
return(von);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
OvenBarcodeVo inVo = (OvenBarcodeVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <OvenBarcodeVo> voList = new ValueObjectList <OvenBarcodeVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select distinct model from t_ovenmachine_ls order by model ");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
OvenBarcodeVo outVo = new OvenBarcodeVo
{
Model = dataReader["model"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
OvenBarcodeVo inVo = (OvenBarcodeVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <OvenBarcodeVo> voList = new ValueObjectList <OvenBarcodeVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select distinct barcode from t_ovenmachine_ls
where 1=1 ");
if (!String.IsNullOrEmpty(inVo.Model))
{
sql.Append(@" and model = :model ");
sqlParameter.AddParameterString("model", inVo.Model);
}
if (!String.IsNullOrEmpty(inVo.Line))
{
sql.Append(@" and line_cd = :line_cd ");
sqlParameter.AddParameterString("line_cd", inVo.Line);
}
sql.Append(" order by barcode");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
OvenBarcodeVo outVo = new OvenBarcodeVo
{
Barcode = dataReader["barcode"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
private void GridBind()
{
oven_dgv.DataSource = null;
try
{
OvenBarcodeVo vo = new OvenBarcodeVo
{
Model = model_cmb.Text,
Line = line_cmb.Text,
Process = process_cmb.Text,
//Barcode = barcode_cmb.Text,
Lower = lower_txt.Text,
Upper = upper_txt.Text,
DateTimeForm = timefrom_dtp.Value,
DateTimeTo = timeto_dtp.Value,
};
ValueObjectList <OvenBarcodeVo> volist = (ValueObjectList <OvenBarcodeVo>)DefaultCbmInvoker.Invoke(new SearchOvenLS12Cbm(), vo);
//OvenBarcodeVo vol = (OvenBarcodeVo)DefaultCbmInvoker.Invoke(new SearchOvenCbm(), vo);
if (volist.GetList() != null && volist.GetList().Count > 0)
{
oven_dgv.AutoGenerateColumns = false;
BindingSource bindingsource = new BindingSource(volist.GetList(), null);
oven_dgv.DataSource = bindingsource;
//oven_dgv.DataSource = vol.Table;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
oven_dgv.ClearSelection();
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void Chart()
{
chartOven.ResetAutoValues();
chartOven.ResumeLayout();
chartOven.Series.Clear();
chartOven.Titles[0].Text = "CHART SHOW TEMPERATURE DATA";
chartOven.Titles[0].Font = new Font("Arial", 16, FontStyle.Bold);
chartOven.ChartAreas[0].AxisX.LabelStyle.Format = "dd-MM HH:mm";
chartOven.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
chartOven.ChartAreas[0].AxisX2.MajorGrid.Enabled = false;
chartOven.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
chartOven.ChartAreas[0].AxisY2.MajorGrid.Enabled = false;
chartOven.ChartAreas[0].AxisX.IntervalAutoMode = IntervalAutoMode.VariableCount;
chartOven.ChartAreas[0].AxisX.LabelStyle.Angle = -60;
chartOven.ChartAreas[0].AxisY.Title = "Temperature";
chartOven.Series.Add("Temperature");
chartOven.Series["Temperature"].ChartType = SeriesChartType.Point;
chartOven.Series["Temperature"].XValueType = ChartValueType.DateTime;
chartOven.Series["Temperature"].Color = Color.FromArgb(0, 192, 0); //blue
chartOven.Series["Temperature"].XValueMember = "Date";
chartOven.Series["Temperature"].YValueMembers = "Temperature";
chartOven.Series["Temperature"].BorderWidth = 3;
upper_txt.ResetText();
lower_txt.ResetText();
if (barcode_cmb.Text.Length > 0)
{
//get temp range in cmb
OvenBarcodeVo upper = (OvenBarcodeVo)DefaultCbmInvoker.Invoke(new GetUpperOvenCbm(), new OvenBarcodeVo()
{
Model = model_cmb.Text, Line = line_cmb.Text, Barcode = barcode_cmb.Text
});
int Upper = int.Parse(upper.Upper);
upper_txt.Text = Upper.ToString();
OvenBarcodeVo lower = (OvenBarcodeVo)DefaultCbmInvoker.Invoke(new GetLowerOvenCbm(), new OvenBarcodeVo()
{
Model = model_cmb.Text, Line = line_cmb.Text, Barcode = barcode_cmb.Text
});
int Lower = int.Parse(lower.Lower);
lower_txt.Text = Lower.ToString();
//add range temp
chartOven.Series.Add("Lower");
chartOven.Series["Lower"].ChartType = SeriesChartType.Line;
chartOven.Series["Lower"].Color = Color.FromArgb(9, 9, 226);//red
chartOven.Series["Lower"].Points.AddXY(timefrom_dtp.Value, Lower);
chartOven.Series["Lower"].Points.AddXY(timeto_dtp.Value, Lower);
chartOven.Series["Lower"].BorderWidth = 2;
chartOven.Series.Add("Upper");
chartOven.Series["Upper"].ChartType = SeriesChartType.Line;
chartOven.Series["Upper"].Color = Color.FromArgb(9, 9, 226);//red
chartOven.Series["Upper"].Points.AddXY(timefrom_dtp.Value, Upper);
chartOven.Series["Upper"].Points.AddXY(timeto_dtp.Value, Upper);
chartOven.Series["Upper"].BorderWidth = 2;
TempAlarm();
}
chartOven.DataSource = oven_dgv.DataSource;
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
OvenBarcodeVo inVo = (OvenBarcodeVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <OvenBarcodeVo> voList = new ValueObjectList <OvenBarcodeVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select dates+times as datetime,* from t_ovenmachine_ls where 1=1 ");
if (!String.IsNullOrEmpty(inVo.Model))
{
sql.Append(@" and model = :model ");
sqlParameter.AddParameterString("model", inVo.Model);
}
if (!String.IsNullOrEmpty(inVo.Model))
{
sql.Append(@" and process_cd = :process_cd ");
sqlParameter.AddParameterString("process_cd", inVo.Process);
}
if (!String.IsNullOrEmpty(inVo.Line))
{
sql.Append(@" and line_cd = :line_cd ");
sqlParameter.AddParameterString("line_cd", inVo.Line);
}
if (!String.IsNullOrEmpty(inVo.Barcode))
{
sql.Append(@" and barcode = :barcode ");
sqlParameter.AddParameterString("barcode", inVo.Barcode);
}
sql.Append(@" and dates+times between :timefrom and :timeto order by dates,barcode,times ");
sqlParameter.AddParameter("timefrom", inVo.DateTimeForm);
sqlParameter.AddParameter("timeto", inVo.DateTimeTo);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
OvenBarcodeVo outVo = new OvenBarcodeVo
{
Date = DateTime.Parse(dataReader["datetime"].ToString()),
Times = dataReader["times"].ToString(),
FactoryCode = dataReader["factory_cd"].ToString(),
Model = dataReader["model"].ToString(),
Process = dataReader["process_cd"].ToString(),
Line = dataReader["line_cd"].ToString(),
Barcode = dataReader["barcode"].ToString(),
Temperature = dataReader["temperature"].ToString(),
Drying = int.Parse(dataReader["drying"].ToString()),
Status = dataReader["status"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
