public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { DetailPositionVo inVo = (DetailPositionVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("insert into m_detail_postion(detail_postion_cd, detail_postion_name, registration_user_cd, registration_date_time, factory_cd) "); sql.Append("values(:detail_postion_cd,:detail_postion_name, :registration_user_cd,now(),:factory_cd)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode); sqlParameter.AddParameterString("detail_postion_name", inVo.DetailPositionName); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL DetailPositionVo outVo = new DetailPositionVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void BindUpdateCavityData() { int selectedrowindex = Detail_Position_dgv.SelectedCells[0].RowIndex; DetailPositionVo vo = (DetailPositionVo)Detail_Position_dgv.Rows[selectedrowindex].DataBoundItem; AddDetailPositionForm addform = new AddDetailPositionForm(); 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) { DetailPositionVo inVo = (DetailPositionVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("update m_detail_postion set detail_postion_cd=:detail_postion_cd,detail_postion_name=:detail_postion_name, location_id=:location_id"); sql.Append(" where detail_postion_id =:detail_postion_id"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode); sqlParameter.AddParameterString("detail_postion_name", inVo.DetailPositionName); sqlParameter.AddParameterInteger("detail_postion_id", inVo.DetailPositionId); sqlParameter.AddParameterInteger("location_id", inVo.LocationId); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL DetailPositionVo outVo = new DetailPositionVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void GridBind() { Detail_Position_dgv.DataSource = null; try { DetailPositionVo vo = new DetailPositionVo { DetailPositionCode = DetailPositionCode_txt.Text, DetailPositionName = DetailPositionName_txt.Text, LocationCd = locationcd_cbm.Text, }; ValueObjectList <DetailPositionVo> volist = (ValueObjectList <DetailPositionVo>)DefaultCbmInvoker.Invoke(new GetDetailPositionCbm(), vo); if (volist.GetList() != null && volist.GetList().Count > 0) { Detail_Position_dgv.AutoGenerateColumns = false; BindingSource bindingsource = new BindingSource(volist.GetList(), null); Detail_Position_dgv.DataSource = bindingsource; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } Detail_Position_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) { DetailPositionVo inVo = (DetailPositionVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <DetailPositionVo> voList = new ValueObjectList <DetailPositionVo>(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select dt.detail_postion_id,l.location_cd, dt.detail_postion_cd, dt.detail_postion_name, dt.registration_user_cd,dt.registration_date_time,dt.factory_cd from m_detail_postion dt left join m_location l on dt.location_id = l.location_id Where 1=1 "); if (inVo.DetailPositionId > 0) { sql.Append(" and dt.detail_postion_id = :detail_postion_id "); sqlParameter.AddParameterInteger("detail_postion_id", inVo.DetailPositionId); } if (!string.IsNullOrEmpty(inVo.DetailPositionCode)) { sql.Append(" and dt.detail_postion_cd = :detail_postion_cd "); sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode); } if (!string.IsNullOrEmpty(inVo.DetailPositionName)) { sql.Append(" and dt.detail_postion_name = :detail_postion_name "); sqlParameter.AddParameterString("detail_postion_name", inVo.DetailPositionName); } if (!string.IsNullOrEmpty(inVo.LocationCd)) { sql.Append(" and l.location_cd = :location_cd "); sqlParameter.AddParameterString("location_cd", inVo.LocationCd); } //create command //DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { DetailPositionVo outVo = new DetailPositionVo { DetailPositionCode = dataReader["detail_postion_cd"].ToString(), DetailPositionId = int.Parse(dataReader["detail_postion_id"].ToString()), DetailPositionName = dataReader["detail_postion_name"].ToString(), LocationCd = dataReader["location_cd"].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); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { try { //VARIABLE DetailPositionVo inVo = (DetailPositionVo)vo; StringBuilder query = new StringBuilder(); ValueObjectList <DetailPositionVo> listVo = new ValueObjectList <DetailPositionVo>(); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); //QUERY STRING query.Append("Select * from m_detail_postion where 1=1 "); if (inVo.detail_postion_id > 0 || inVo != null) { query.Append("and detail_postion_id='").Append(inVo.detail_postion_id).Append("' "); } if (string.IsNullOrEmpty(inVo.detail_postion_cd)) { query.Append("and detail_postion_cd='").Append(inVo.detail_postion_cd).Append("' "); } query.Append("order by detail_postion_id"); //GET SQL ADAPTER sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString()); //EXECUTE READER FROM COMMAND IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (datareader.Read()) { DetailPositionVo outVo = new DetailPositionVo { detail_postion_id = (int)datareader["detail_postion_id"], location_id = (int)datareader["location_id"], detail_postion_cd = datareader["detail_postion_cd"].ToString(), detail_postion_name = datareader["detail_postion_name"].ToString(), registration_user_cd = datareader["registration_user_cd"].ToString(), registration_date_time = (DateTime)datareader["registration_date_time"], factory_cd = datareader["factory_cd"].ToString() }; listVo.add(outVo); } //CLEAR AND CLOSE CONNECTION query.Clear(); datareader.Close(); base.CloseConnection(trxContext); return(listVo); } catch { throw new NotImplementedException(); } }
private bool checkdate() { if (DetailPositionCode_txt.Text.Trim().Length == 0) { messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, DetailPositionCode_lbl.Text); popUpMessage.Warning(messageData, Text); DetailPositionCode_txt.Focus(); return(false); } if (DetailPositionCode_txt.Text.Trim().Length == 0) { messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, DetailPositionCode_lbl.Text); popUpMessage.Warning(messageData, Text); DetailPositionCode_txt.Focus(); return(false); } if (location_cmb.Text.Length == 0) { messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, location_lbl.Text); popUpMessage.Warning(messageData, Text); location_cmb.Focus(); return(false); } DetailPositionCode_txt.Text = DetailPositionCode_txt.Text.Trim(); DetailPositionName_txt.Text = DetailPositionName_txt.Text.Trim(); DetailPositionVo outVo = new DetailPositionVo(), inVo = new DetailPositionVo { DetailPositionId = vo.DetailPositionId, DetailPositionCode = DetailPositionCode_txt.Text }; try { outVo = (DetailPositionVo)DefaultCbmInvoker.Invoke(new CheckDetailPositionCbm(), inVo); if (outVo.AffectedCount > 0) { messageData = new MessageData("mmcc00006", Properties.Resources.mmcc00006, DetailPositionCode_lbl.Text); popUpMessage.Warning(messageData, Text); DetailPositionCode_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) { DetailPositionVo inVo = (DetailPositionVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("delete from m_detail_postion Where 1=1 "); if (!String.IsNullOrEmpty(inVo.FactoryCode)) { sql.Append(" and factory_cd = :factory_cd "); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); } if (inVo.DetailPositionId > 0) { sql.Append(" and detail_postion_id = :detail_postion_id "); sqlParameter.AddParameterInteger("detail_postion_id", inVo.DetailPositionId); } if (!string.IsNullOrEmpty(inVo.DetailPositionCode)) { sql.Append(" and detail_postion_cd = :detail_postion_cd "); sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode); } if (!string.IsNullOrEmpty(inVo.DetailPositionName)) { sql.Append(" and detail_postion_name = :detail_postion_name "); sqlParameter.AddParameterString("detail_postion_name", inVo.DetailPositionName); } //create command sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL DetailPositionVo outVo = new DetailPositionVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void Delete_btn_Click(object sender, EventArgs e) { if (Detail_Position_dgv.SelectedRows.Count > 0) { int selectedrowindex = Detail_Position_dgv.SelectedCells[0].RowIndex; DetailPositionVo vo = (DetailPositionVo)Detail_Position_dgv.Rows[selectedrowindex].DataBoundItem; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.DetailPositionCode); logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { try { DetailPositionVo outVo = (DetailPositionVo)DefaultCbmInvoker.Invoke(new DeleteDetailPositionCbm(), 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()) { DetailPositionVo outvo = new DetailPositionVo(); DetailPositionVo invo = new DetailPositionVo { LocationId = ((LocationVo)this.location_cmb.SelectedItem).LocationId, DetailPositionId = vo.DetailPositionId, DetailPositionCode = DetailPositionCode_txt.Text, DetailPositionName = DetailPositionName_txt.Text, FactoryCode = UserData.GetUserData().FactoryCode, RegistrationUserCode = UserData.GetUserData().UserCode }; try { if (invo.DetailPositionId > 0) { outvo = (DetailPositionVo)DefaultCbmInvoker.Invoke(new UpdateDetailPositionCbm(), invo); } else { outvo = (DetailPositionVo)DefaultCbmInvoker.Invoke(new AddDetailPositionCbm(), invo); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if ((IntSuccess > 0) || (IntSuccess == 0)) { this.DialogResult = DialogResult.OK; this.Close(); } } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { DetailPositionVo inVo = (DetailPositionVo)vo; ValueObjectList <DetailPositionVo> voList = new ValueObjectList <DetailPositionVo>(); StringBuilder sql = new StringBuilder(); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select distinct detail_postion_id, detail_postion_cd, detail_postion_name from m_detail_postion where 1=1 "); if (!string.IsNullOrEmpty(inVo.detail_postion_cd)) { sql.Append("and detail_postion_cd='").Append(inVo.detail_postion_cd).Append("' "); } if (!string.IsNullOrEmpty(inVo.detail_postion_name)) { sql.Append("and detail_postion_name='").Append(inVo.detail_postion_name).Append("' "); } sql.Append("order by detail_postion_id"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); sql.Clear(); //EXECUTE READER FROM COMMAND IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (datareader.Read()) { DetailPositionVo outVo = new DetailPositionVo { detail_postion_id = (int)datareader["detail_postion_id"], detail_postion_cd = datareader["detail_postion_cd"].ToString(), detail_postion_name = datareader["detail_postion_name"].ToString() }; voList.add(outVo); } datareader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { DetailPositionVo inVo = (DetailPositionVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("Select Count(*) as DetailPositionCounter "); sql.Append(" from m_detail_postion"); sql.Append(" Where 1=1 "); if (!string.IsNullOrEmpty(inVo.DetailPositionCode)) { sql.Append(" and UPPER(detail_postion_cd) = UPPER(:detail_postion_cd) "); sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode); } if (inVo.DetailPositionId > 0) { sql.Append(" and detail_postion_id != :detail_postion_id "); ///????? sqlParameter.AddParameterInteger("detail_postion_id", inVo.DetailPositionId); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); DetailPositionVo outVo = new DetailPositionVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["DetailPositionCounter"].ToString()); } dataReader.Close(); return(outVo); }