public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RateNGVo inVo = (RateNGVo)vo; StringBuilder sql = new StringBuilder(); RateNGVo voList = new RateNGVo(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("insert into m_rate_ng (rate_ng_cd, rate_ng_model, rate_ng_line , rate_ng_ratio) "); sql.Append("values (:rate_ng_cd, :rate_ng_model, :rate_ng_line , :rate_ng_ratio) "); sqlParameter.AddParameter("rate_ng_cd", inVo.RateCode); sqlParameter.AddParameter("rate_ng_model", inVo.RateModel); sqlParameter.AddParameter("rate_ng_line", inVo.RateLine); sqlParameter.AddParameter("rate_ng_ratio", inVo.RateRatio); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL voList = new RateNGVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter), }; return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RateNGVo inVo = (RateNGVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <RateNGVo> voList = new ValueObjectList <RateNGVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select distinct rate_ng_model from m_rate_ng where 1=1"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); //execute SQL while (dataReader.Read()) { RateNGVo outVo1 = new RateNGVo { RateModel = dataReader["rate_ng_model"].ToString(), }; voList.add(outVo1); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RateNGVo inVo = (RateNGVo)vo; StringBuilder sql = new StringBuilder(); RateNGVo voList = new RateNGVo(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("delete from m_rate_ng where 1=1"); if (inVo.RatelId > 0) { sql.Append(" and rate_ng_id = :rate_ng_id"); sqlParameter.AddParameter("rate_ng_id", inVo.RatelId); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL voList = new RateNGVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter), }; return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RateNGVo inVo = (RateNGVo)vo; StringBuilder sql = new StringBuilder(); RateNGVo voList = new RateNGVo(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select rate_ng_id, rate_ng_model,rate_ng_line,rate_ng_cd, rate_ng_ratio from m_rate_ng where 1=1"); if (!string.IsNullOrEmpty(inVo.RateCode)) { sql.Append(" and rate_ng_cd = :rate_ng_cd "); sqlParameter.AddParameter("rate_ng_cd", inVo.RateCode); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); DataSet ds = sqlCommandAdapter.ExecuteDataSet(sqlParameter); //execute SQL RateNGVo outVo1 = new RateNGVo { dt = ds.Tables[0], }; return(outVo1); }
private void Ok_btn_Click(object sender, EventArgs e) { if (checkdate()) { RateNGVo outvo = new RateNGVo(); RateNGVo invo = new RateNGVo { RatelId = this.RatelId, RateModel = model_cmb.Text, RateLine = line_cmb.Text, RateCode = RateCode_txt.Text, RateRatio = Ratio_txt.Text }; try { if (invo.RatelId > 0) { outvo = (RateNGVo)DefaultCbmInvoker.Invoke(new UpdateRateNGCbm(), invo); } else { outvo = (RateNGVo)DefaultCbmInvoker.Invoke(new InsertRateNGCbm(), invo); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outvo.AffectedCount > 0) { if (UpdateText_lbl.Text == "Add") { messageData = new MessageData("mmci00001", Properties.Resources.mmci00001); popUpMessage.Information(messageData, "Notice"); ResetControlValues.ResetControlValue(this); } else { messageData = new MessageData("mmci00002", Properties.Resources.mmci00002); popUpMessage.Information(messageData, "Notice"); Close(); } } } }
private void Delete_btn_Click(object sender, EventArgs e) { if (RateNG_dgv.SelectedRows.Count > 0) { int selectedrowindex = RateNG_dgv.CurrentCell.RowIndex; //RateNGVo vo = (RateNGVo)RateNG_dgv.Rows[selectedrowindex].DataBoundItem; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, RateNG_dgv.Rows[selectedrowindex].Cells["rate_ng_cd"].Value.ToString()); logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { try { RateNGVo outVo = (RateNGVo)DefaultCbmInvoker.Invoke(new DeleteRateNGCbm(), new RateNGVo() { RatelId = int.Parse(RateNG_dgv.Rows[selectedrowindex].Cells["rate_ng_id"].Value.ToString()) }); 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 bool checkdate() { if (RateCode_txt.Text.Trim().Length == 0) { messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, RankCode_lbl.Text); popUpMessage.Warning(messageData, Text); RateCode_txt.Focus(); return(false); } if (Ratio_txt.Text.Trim().Length == 0) { messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, RankName_lbl.Text); popUpMessage.Warning(messageData, Text); Ratio_txt.Focus(); return(false); } RateCode_txt.Text = RateCode_txt.Text.Trim(); Ratio_txt.Text = Ratio_txt.Text.Trim(); RateNGVo outVo = new RateNGVo(), inVo = new RateNGVo { RateCode = RateCode_txt.Text, RateModel = model_cmb.Text, RateLine = line_cmb.Text }; try { outVo = (RateNGVo)DefaultCbmInvoker.Invoke(new CheckRateNGCbm(), inVo); if (outVo.AffectedCount > 0 && RatelId == 0) { messageData = new MessageData("mmcc00006", Properties.Resources.mmcc00006, RankCode_lbl.Text); popUpMessage.Warning(messageData, Text); RateCode_txt.Focus(); return(false); } } catch (Com.Nidec.Mes.Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return(false); } return(true); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RateNGVo inVo = (RateNGVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <RateNGVo> voList = new ValueObjectList <RateNGVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select rate_ng_ratio from m_rate_ng where 1=1 "); if (!string.IsNullOrEmpty(inVo.RateModel)) { sql.Append(@" and rate_ng_model =:rate_ng_model"); sqlParameter.AddParameterString("rate_ng_model", inVo.RateModel); } if (!string.IsNullOrEmpty(inVo.RateLine)) { sql.Append(@" and rate_ng_line =:rate_ng_line"); sqlParameter.AddParameterString("rate_ng_line", inVo.RateLine); } if (!string.IsNullOrEmpty(inVo.RateCode)) { sql.Append(@" and rate_ng_cd =:rate_ng_cd"); sqlParameter.AddParameterString("rate_ng_cd", inVo.RateCode); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL string a = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString(); RateNGVo outVo = new RateNGVo { RateRatio = a, }; return(outVo); }
private void GridBind() { RateNG_dgv.DataSource = null; try { RateNGVo vo = new RateNGVo { RateCode = RateNGCode_txt.Text, }; RateNGVo volist = (RateNGVo)DefaultCbmInvoker.Invoke(new SearchRateNGCbm(), vo); if (volist.dt != null && volist.dt.Rows.Count > 0) { RateNG_dgv.DataSource = volist.dt; RateNG_dgv.Columns["rate_ng_id"].Visible = false; RateNG_dgv.Columns["rate_ng_cd"].HeaderText = "Rate Code"; RateNG_dgv.Columns["rate_ng_model"].HeaderText = "Model"; RateNG_dgv.Columns["rate_ng_line"].HeaderText = "Line"; RateNG_dgv.Columns["rate_ng_ratio"].HeaderText = "Ratio"; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } RateNG_dgv.ClearSelection(); Update_btn.Enabled = false; Delete_btn.Enabled = false; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }