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); }