public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { JigCauseVo inVo = (JigCauseVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("insert into public.m_jig_cause(jig_cause_cd, jig_cause_name, registration_user_cd, registration_date_time, factory_cd) "); sql.Append("values(:jig_cause_cd,:jig_cause_name, :registration_user_cd,now(),:factory_cd)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("jig_cause_cd", inVo.JigCauseCode); sqlParameter.AddParameterString("jig_cause_name", inVo.JigCauseName); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL JigCauseVo outVo = new JigCauseVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { JigCauseVo inVo = (JigCauseVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("update public.m_ncvp_jig_cause set jig_cause_cd=:jig_cause_cd,jig_cause_name=:jig_cause_name"); sql.Append(" where jig_cause_id =:jig_cause_id"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("jig_cause_cd", inVo.JigCauseCode); sqlParameter.AddParameterString("jig_cause_name", inVo.JigCauseName); sqlParameter.AddParameterInteger("jig_cause_id", inVo.JigCauseId); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL JigCauseVo outVo = new JigCauseVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
/// <summary> /// selects user record for updation and show user form /// </summary> private void BindUpdateCavityData() { int selectedrowindex = JigCause_dgv.SelectedCells[0].RowIndex; JigCauseVo vo = (JigCauseVo)JigCause_dgv.Rows[selectedrowindex].DataBoundItem; AddJigCauseMasterForm addform = new AddJigCauseMasterForm(); addform.vo = vo; 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) { JigCauseVo inVo = (JigCauseVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <JigCauseVo> voList = new ValueObjectList <JigCauseVo>(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select jig_cause_id,jig_cause_cd,jig_cause_name, registration_user_cd,registration_date_time,factory_cd from public.m_ncvp_jig_cause"); sql.Append(" Where 1=1 "); if (!String.IsNullOrEmpty(inVo.FactoryCode)) { sql.Append(" and factory_cd = :factory_cd "); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); } if (inVo.JigCauseId > 0) { sql.Append(" and jig_cause_id = :jig_cause_id "); sqlParameter.AddParameterInteger("jig_cause_id", inVo.JigCauseId); } if (!string.IsNullOrEmpty(inVo.JigCauseCode)) { sql.Append(" and jig_cause_cd = :jig_cause_cd "); sqlParameter.AddParameterString("jig_cause_cd", inVo.JigCauseCode); } if (!string.IsNullOrEmpty(inVo.JigCauseName)) { sql.Append(" and jig_cause_name = :jig_cause_name "); sqlParameter.AddParameterString("jig_cause_name", inVo.JigCauseName); } //create command //DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { JigCauseVo outVo = new JigCauseVo { JigCauseCode = dataReader["jig_cause_cd"].ToString(), JigCauseId = int.Parse(dataReader["jig_cause_id"].ToString()), JigCauseName = dataReader["jig_cause_name"].ToString(), RegistrationUserCode = dataReader["registration_user_cd"].ToString(), RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()), FactoryCode = dataReader["factory_cd"].ToString() }; voList.add(outVo); } dataReader.Close(); return(voList); }
private void Delete_btn_Click(object sender, EventArgs e) { if (JigCause_dgv.SelectedRows.Count > 0) { int selectedrowindex = JigCause_dgv.SelectedCells[0].RowIndex; JigCauseVo vo = (JigCauseVo)JigCause_dgv.Rows[selectedrowindex].DataBoundItem; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.JigCauseCode); logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { try { JigCauseVo outVo = (JigCauseVo)DefaultCbmInvoker.Invoke(new DeleteJigCauseCbm(), 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 bool CheckDate() { if (JigCauseCode_txt.Text.Trim().Length == 0) { messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, JigCauseCode_lbl.Text); popUpMessage.Warning(messageData, Text); JigCauseCode_txt.Focus(); return(false); } if (JigCauseName_txt.Text.Trim().Length == 0) { messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, JigCauseName_lbl.Text); popUpMessage.Warning(messageData, Text); JigCauseName_txt.Focus(); return(false); } JigCauseCode_txt.Text = JigCauseCode_txt.Text.Trim(); JigCauseName_txt.Text = JigCauseName_txt.Text.Trim(); JigCauseVo outVo = new JigCauseVo(), inVo = new JigCauseVo { JigCauseId = vo.JigCauseId, JigCauseCode = JigCauseCode_txt.Text }; try { outVo = (JigCauseVo)DefaultCbmInvoker.Invoke(new CheckJigCauseCbm(), inVo); if (outVo.AffectedCount > 0) { messageData = new MessageData("mmcc00006", Properties.Resources.mmcc00006, JigCauseCode_lbl.Text); popUpMessage.Warning(messageData, Text); JigCauseCode_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) { JigCauseVo inVo = (JigCauseVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("delete from public.m_jig_cause Where 1=1 "); if (!String.IsNullOrEmpty(inVo.FactoryCode)) { sql.Append(" and factory_cd = :factory_cd "); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); } if (inVo.JigCauseId > 0) { sql.Append(" and jig_cause_id = :jig_cause_id "); sqlParameter.AddParameterInteger("jig_cause_id", inVo.JigCauseId); } if (!string.IsNullOrEmpty(inVo.JigCauseCode)) { sql.Append(" and jig_cause_cd = :jig_cause_cd "); sqlParameter.AddParameterString("jig_cause_cd", inVo.JigCauseCode); } if (!string.IsNullOrEmpty(inVo.JigCauseName)) { sql.Append(" and jig_cause_name = :jig_cause_name "); sqlParameter.AddParameterString("jig_cause_name", inVo.JigCauseName); } //create command sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL JigCauseVo outVo = new JigCauseVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { JigCauseVo inVo = (JigCauseVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("Select Count(*) as JigCauseCount "); sql.Append(" from public.m_jig_cause"); sql.Append(" Where 1=1 "); if (!String.IsNullOrEmpty(inVo.FactoryCode)) { sql.Append(" and factory_cd = :factory_cd "); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); } if (!string.IsNullOrEmpty(inVo.JigCauseCode)) { sql.Append(" and UPPER(jig_cause_cd) = UPPER(:jig_cause_cd) "); sqlParameter.AddParameterString("jig_cause_cd", inVo.JigCauseCode); } if (inVo.JigCauseId > 0) { sql.Append(" and jig_cause_id != :jig_cause_id "); ///????? sqlParameter.AddParameterInteger("jig_cause_id", inVo.JigCauseId); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); JigCauseVo outVo = new JigCauseVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["JigCauseCount"].ToString()); } dataReader.Close(); return(outVo); }
private void Ok_btn_Click(object sender, EventArgs e) { if (CheckDate()) { JigCauseVo outVo = new JigCauseVo(); JigCauseVo inVo = new JigCauseVo { JigCauseId = vo.JigCauseId, JigCauseCode = JigCauseCode_txt.Text, JigCauseName = JigCauseName_txt.Text, FactoryCode = UserData.GetUserData().FactoryCode, RegistrationUserCode = UserData.GetUserData().UserCode }; try { if (inVo.JigCauseId > 0) { outVo = (JigCauseVo)DefaultCbmInvoker.Invoke(new UpdateJigCauseCbm(), inVo); } else { outVo = (JigCauseVo)DefaultCbmInvoker.Invoke(new AddJigCauseCbm(), inVo); } IntSuccess = outVo.AffectedCount; } catch (Com.Nidec.Mes.Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if ((IntSuccess > 0) || (IntSuccess == 0)) { this.DialogResult = DialogResult.OK; this.Close(); } } }