public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RangeVo inVo = (RangeVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <RangeVo> voList = new ValueObjectList <RangeVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select distinct model from t_ovenmachine order by model "); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { RangeVo outVo = new RangeVo { Model = dataReader["model"].ToString(), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RangeVo inVo = (RangeVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <RangeVo> voList = new ValueObjectList <RangeVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select count(*) count_process 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); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); RangeVo outVo = new RangeVo(); outVo.Count = int.Parse(sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString()); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RangeVo inVo = (RangeVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("delete from m_ovenmachine_range Where 1=1 "); if (inVo.RangeId > 0) { sql.Append(" and ovenmachine_range_id = :ovenmachine_range_id "); sqlParameter.AddParameterInteger("ovenmachine_range_id", inVo.RangeId); } //create command sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL RangeVo outVo = new RangeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void BindUpdateCavityData() { int selectedrowindex = RangeOven_dgv.SelectedCells[0].RowIndex; RangeVo vo = (RangeVo)RangeOven_dgv.Rows[selectedrowindex].DataBoundItem; AddRangeLS12Form addform = new AddRangeLS12Form(); addform.vo = vo; addform.ShowDialog(); if (addform.IntSuccess > 0) { messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(); } else if (addform.IntSuccess == 0) { messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RangeVo inVo = (RangeVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(@"update m_ovenmachine_range set range_lower=:range_lower,range_upper=:range_upper,registration_user_cd=:registration_user_cd,registration_date_time = now()"); sql.Append(" where range_model=:range_model and range_line=:range_line and range_barcode=:range_barcode "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("ovenmachine_range_id", inVo.RangeId); sqlParameter.AddParameterString("range_model", inVo.Model); sqlParameter.AddParameterString("range_line", inVo.Line); sqlParameter.AddParameterString("range_barcode", inVo.Barcode); sqlParameter.AddParameterString("range_lower", inVo.Lower); sqlParameter.AddParameterString("range_upper", inVo.Upper); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUser); //execute SQL RangeVo outVo = new RangeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void GridBind() { RangeOven_dgv.DataSource = null; try { RangeVo vo = new RangeVo { Model = range_model_cbm.Text, Process = range_process_cbm.Text }; ValueObjectList <RangeVo> volist = (ValueObjectList <RangeVo>)DefaultCbmInvoker.Invoke(new SearchRangeLS12Cbm(), vo); if (volist.GetList() != null && volist.GetList().Count > 0) { RangeOven_dgv.AutoGenerateColumns = false; BindingSource bindingsource = new BindingSource(volist.GetList(), null); RangeOven_dgv.DataSource = bindingsource; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } RangeOven_dgv.ClearSelection(); Update_btn.Enabled = false; Delete_btn.Enabled = false; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RangeVo inVo = (RangeVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("insert into m_ovenmachinels12_range(range_model,range_process,range_lower,range_upper, registration_user_cd, registration_date_time) "); sql.Append("values(:range_model,:range_process,:range_lower,:range_upper, :registration_user_cd, now())"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("range_model", inVo.Model); sqlParameter.AddParameterString("range_process", inVo.Process); sqlParameter.AddParameterString("range_lower", inVo.Lower); sqlParameter.AddParameterString("range_upper", inVo.Upper); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUser); //execute SQL RangeVo outVo = new RangeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RangeVo inVo = (RangeVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <RangeVo> voList = new ValueObjectList <RangeVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select * from m_ovenmachine_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.Line)) { sql.Append(@" and range_line = :range_line "); sqlParameter.AddParameterString("range_line", inVo.Line); } sql.Append(" order by range_model,range_line,range_barcode "); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { RangeVo outVo = new RangeVo { RangeId = int.Parse(dataReader["ovenmachine_range_id"].ToString()), Model = dataReader["range_model"].ToString(), Line = dataReader["range_line"].ToString(), Barcode = dataReader["range_barcode"].ToString(), Lower = dataReader["range_lower"].ToString(), Upper = dataReader["range_upper"].ToString(), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RangeVo inVo = (RangeVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <RangeVo> voList = new ValueObjectList <RangeVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select distinct barcode from t_ovenmachine 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()) { RangeVo outVo = new RangeVo { Barcode = dataReader["barcode"].ToString(), }; voList.add(outVo); } dataReader.Close(); return(voList); }
private void Delete_btn_Click(object sender, EventArgs e) { if (RangeOven_dgv.SelectedRows.Count > 0) { int selectedrowindex = RangeOven_dgv.SelectedCells[0].RowIndex; RangeVo vo = (RangeVo)RangeOven_dgv.Rows[selectedrowindex].DataBoundItem; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.Model + " and process = " + vo.Process); logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { try { RangeVo outVo = (RangeVo)DefaultCbmInvoker.Invoke(new DeleteRangeCbm(), vo); if (outVo.AffectedCount > 0) { messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(); } else if (outVo.AffectedCount == 0) { messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(); } } catch (Com.Nidec.Mes.Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } } } }
private void Ok_btn_Click(object sender, EventArgs e) { if (checkdate()) { int fail = 0; int a = vo.RangeId; RangeVo outvo = new RangeVo(); try { if (vo.RangeId > 0) { outvo = (RangeVo)DefaultCbmInvoker.Invoke(new UpdateRangeLS12Cbm(), new RangeVo { RangeId = vo.RangeId, Model = model_cbm.Text, Line = process_cbm.Text, Lower = lower_txt.Text, Upper = upper_txt.Text, RegistrationUser = UserData.GetUserData().UserCode }); IntSuccess = outvo.AffectedCount; } else { int countDem = 0; RangeVo checkBarcode = (RangeVo)DefaultCbmInvoker.Invoke(new CheckBarcodeRangeLS12Cbm(), new RangeVo() { Model = model_cbm.Text, Process = process_cbm.Text, }); countDem = countDem + 1; if (checkBarcode.Count == 0)//kiểm tra barcode có trùng trong database { outvo = (RangeVo)DefaultCbmInvoker.Invoke(new AddRangeLS12Cbm(), new RangeVo { RangeId = vo.RangeId, Model = model_cbm.Text, Process = process_cbm.Text, Lower = lower_txt.Text, Upper = upper_txt.Text, RegistrationUser = UserData.GetUserData().UserCode }); IntSuccess = outvo.AffectedCount; } else { messageData = new MessageData("mmcc00005", "Process have set temperature", "Warning"); popUpMessage.ApplicationError(messageData, Text); } } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if ((IntSuccess > 0) || (IntSuccess == 0)) { if (fail > 0) { } this.DialogResult = DialogResult.OK; this.Close(); } } }
private void Ok_btn_Click(object sender, EventArgs e) { if (checkdate()) { int fail = 0; int a = vo.RangeId; RangeVo outvo = new RangeVo(); try { int countCheckTrue = 0; foreach (TreeNode aNode in Barcode_tv.Nodes) { if (aNode.Checked == true) { countCheckTrue = countCheckTrue + 1; } } if (vo.RangeId > 0) { foreach (TreeNode aNode in Barcode_tv.Nodes) { if (aNode.Checked == true) { outvo = (RangeVo)DefaultCbmInvoker.Invoke(new UpdateRangeCbm(), new RangeVo { //RangeId = vo.RangeId, Model = model_cbm.Text, Barcode = aNode.Text, Line = line_cbm.Text, Lower = lower_txt.Text, Upper = upper_txt.Text, RegistrationUser = UserData.GetUserData().UserCode }); IntSuccess = outvo.AffectedCount; } } } else { int countDem = 0; string duplicate_barcode = ""; foreach (TreeNode aNode in Barcode_tv.Nodes) { RangeVo checkBarcode = (RangeVo)DefaultCbmInvoker.Invoke(new CheckBarcodeRangeCbm(), new RangeVo() { Model = model_cbm.Text, Barcode = aNode.Text, Line = line_cbm.Text, }); if (aNode.Checked == true) { countDem = countDem + 1; if (checkBarcode.Count == 0)//kiểm tra barcode có trùng trong database { outvo = (RangeVo)DefaultCbmInvoker.Invoke(new AddRangeCbm(), new RangeVo { RangeId = vo.RangeId, Model = model_cbm.Text, Barcode = aNode.Text, Line = line_cbm.Text, Lower = lower_txt.Text, Upper = upper_txt.Text, RegistrationUser = UserData.GetUserData().UserCode }); IntSuccess = outvo.AffectedCount; } else { duplicate_barcode = duplicate_barcode + aNode.Text.Trim() + " & "; if (countDem == countCheckTrue) { messageData = new MessageData("mmcc00005", "Duplicate key Barcode: " + duplicate_barcode.Substring(0, duplicate_barcode.Length - 2), barcode_lbl.Text); popUpMessage.Warning(messageData, Text); Barcode_tv.Focus(); fail = fail + 1; //return; } } } } } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if ((IntSuccess > 0) || (IntSuccess == 0)) { if (fail > 0) { } this.DialogResult = DialogResult.OK; this.Close(); } } }