/// <summary> /// selects user record for updation and show user form /// </summary> private void UpdateWorkContentType() { int selectedrowindex = ProdutionWorkContentType_dgv.SelectedCells[0].RowIndex; ProdutionWorkContentTypeVo vo = (ProdutionWorkContentTypeVo)ProdutionWorkContentType_dgv.Rows[selectedrowindex].DataBoundItem; AddProdutionWorkContentTypeForm addform = new AddProdutionWorkContentTypeForm(); addform.vo = vo; if (addform.ShowDialog() == DialogResult.OK) { 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) { ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("Update m_prodution_work_content_type_master set prodution_work_content_type_cd=:prodution_work_content_type_cd,prodution_work_content_type_name=:prodution_work_content_type_name"); sql.Append(" where prodution_work_content_type_id=:prodution_work_content_type_id"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode); sqlParameter.AddParameterString("prodution_work_content_type_name", inVo.ProdutionWorkContentTypeName); sqlParameter.AddParameterInteger("prodution_work_content_type_id", inVo.ProdutionWorkContentTypeId); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <ProdutionWorkContentTypeVo> voList = new ValueObjectList <ProdutionWorkContentTypeVo>(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select prodution_work_content_type_id,prodution_work_content_type_cd,prodution_work_content_type_name,registration_user_cd,registration_date_time,factory_cd from m_prodution_work_content_type_master"); 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.ProdutionWorkContentTypeId > 0) { sql.Append(" and prodution_work_content_type_id = :prodution_work_content_type_id "); sqlParameter.AddParameterInteger("prodution_work_content_type_id", inVo.ProdutionWorkContentTypeId); } if (!string.IsNullOrEmpty(inVo.ProdutionWorkContentTypeCode)) { sql.Append(" and prodution_work_content_type_cd = :prodution_work_content_type_cd "); sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode); } if (!string.IsNullOrEmpty(inVo.ProdutionWorkContentTypeName)) { sql.Append(" and prodution_work_content_type_name = :prodution_work_content_type_name "); sqlParameter.AddParameterString("prodution_work_content_type_name", inVo.ProdutionWorkContentTypeName); } //create command //DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo { ProdutionWorkContentTypeCode = dataReader["prodution_work_content_type_cd"].ToString(), ProdutionWorkContentTypeId = int.Parse(dataReader["prodution_work_content_type_id"].ToString()), ProdutionWorkContentTypeName = dataReader["prodution_work_content_type_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 (ProdutionWorkContentType_dgv.SelectedRows.Count > 0) { int selectedrowindex = ProdutionWorkContentType_dgv.SelectedCells[0].RowIndex; ProdutionWorkContentTypeVo vo = (ProdutionWorkContentTypeVo)ProdutionWorkContentType_dgv.Rows[selectedrowindex].DataBoundItem; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.ProdutionWorkContentTypeCode); logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { try { ProdutionWorkContentTypeVo outVo = (ProdutionWorkContentTypeVo)base.InvokeCbm(new DeleteProdutionWorkContentTypeCbm(), vo, false); 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()); } } } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("delete from m_prodution_work_content_type_master Where 1=1 "); if (!String.IsNullOrEmpty(inVo.FactoryCode)) { sql.Append(" and factory_cd = :factory_cd "); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); } if (inVo.ProdutionWorkContentTypeId > 0) { sql.Append(" and prodution_work_content_type_id = :prodution_work_content_type_id "); sqlParameter.AddParameterInteger("prodution_work_content_type_id", inVo.ProdutionWorkContentTypeId); } if (!string.IsNullOrEmpty(inVo.ProdutionWorkContentTypeCode)) { sql.Append(" and prodution_work_content_type_cd = :prodution_work_content_type_cd "); sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode); } if (!string.IsNullOrEmpty(inVo.ProdutionWorkContentTypeName)) { sql.Append(" and prodution_work_content_type_name = :prodution_work_content_type_name "); sqlParameter.AddParameterString("prodution_work_content_type_name", inVo.ProdutionWorkContentTypeName); } //create command sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private bool CheckDate() { if (ProdutionWorkContentTypeCode_txt.Text.Trim().Length == 0) { messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, ProdutionWorkContentTypeCode_lbl.Text); popUpMessage.Warning(messageData, Text); ProdutionWorkContentTypeCode_txt.Focus(); return(false); } if (ProdutionWorkContentTypeName_txt.Text.Trim().Length == 0) { messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, ProdutionWorkContentTypeName_lbl.Text); popUpMessage.Warning(messageData, Text); ProdutionWorkContentTypeName_txt.Focus(); return(false); } ProdutionWorkContentTypeCode_txt.Text = ProdutionWorkContentTypeCode_txt.Text.Trim(); ProdutionWorkContentTypeName_txt.Text = ProdutionWorkContentTypeName_txt.Text.Trim(); ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo(), inVo = new ProdutionWorkContentTypeVo { ProdutionWorkContentTypeId = vo.ProdutionWorkContentTypeId, ProdutionWorkContentTypeCode = ProdutionWorkContentTypeCode_txt.Text }; try { outVo = (ProdutionWorkContentTypeVo)base.InvokeCbm(new CheckProdutionWorkContentTypeCbm(), inVo, false); if (outVo.AffectedCount > 0) { messageData = new MessageData("mmcc00006", Properties.Resources.mmcc00006, ProdutionWorkContentTypeCode_lbl.Text); popUpMessage.Warning(messageData, Text); ProdutionWorkContentTypeCode_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) { ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("Select Count(*) as CountNum "); sql.Append(" from m_work_content_type"); 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.ProdutionWorkContentTypeCode)) { sql.Append(" and UPPER(work_content_type_cd) = UPPER(:prodution_work_content_type_cd) "); sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode); } if (inVo.ProdutionWorkContentTypeId > 0) { sql.Append(" and work_content_type_id != :prodution_work_content_type_id "); sqlParameter.AddParameterInteger("prodution_work_content_type_id", inVo.ProdutionWorkContentTypeId); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["CountNum"].ToString()); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(" insert into "); sql.Append(" m_work_content_type( "); sql.Append(" work_content_type_cd, "); sql.Append(" work_content_type_name, "); sql.Append(" registration_user_cd, "); sql.Append(" registration_date_time, "); sql.Append(" factory_cd) "); sql.Append(" values( "); sql.Append(" :prodution_work_content_type_cd, "); sql.Append(" :prodution_work_content_type_name, "); sql.Append(" :registration_user_cd, "); sql.Append(" :registrationdatetime, "); sql.Append(" :factorycd)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode); sqlParameter.AddParameterString("prodution_work_content_type_name", inVo.ProdutionWorkContentTypeName); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("registration_user_cd", UserData.GetUserData().UserCode); sqlParameter.AddParameterString("factorycd", UserData.GetUserData().FactoryCode); //execute SQL ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void Ok_btn_Click(object sender, EventArgs e) { if (CheckDate()) { ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo(); ProdutionWorkContentTypeVo inVo = new ProdutionWorkContentTypeVo { ProdutionWorkContentTypeId = vo.ProdutionWorkContentTypeId, ProdutionWorkContentTypeCode = ProdutionWorkContentTypeCode_txt.Text, ProdutionWorkContentTypeName = ProdutionWorkContentTypeName_txt.Text, FactoryCode = UserData.GetUserData().FactoryCode, RegistrationUserCode = UserData.GetUserData().UserCode }; try { if (inVo.ProdutionWorkContentTypeId > 0) { outVo = (ProdutionWorkContentTypeVo)base.InvokeCbm(new UpdateProdutionWorkContentTypeCbm(), inVo, false); } else { outVo = (ProdutionWorkContentTypeVo)base.InvokeCbm(new AddProdutionWorkContentTypeCbm(), inVo, false); } 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(); } } }