private void JigDrawForm_Load(object sender, EventArgs e) { ValueObjectList <ModelVo> modelvolist = (ValueObjectList <ModelVo>)DefaultCbmInvoker.Invoke(new GetModelCbm(), new ModelVo()); model_cmb.DisplayMember = "ModelCode"; BindingSource b1 = new BindingSource(modelvolist.GetList(), null); model_cmb.DataSource = b1; model_cmb.Text = ""; process_cmb.Text = ""; LocalSupplierVo suppliervolist = (LocalSupplierVo)DefaultCbmInvoker.Invoke(new GetLocalSupplierMasterMntCbm(), new LocalSupplierVo()); supplier_cmb.DisplayMember = "LocalSupplierName"; supplier_cmb.DataSource = suppliervolist.LocalSupplierListVo; supplier_cmb.Text = ""; ValueObjectList <DrawVo> drawvolist = (ValueObjectList <DrawVo>)DefaultCbmInvoker.Invoke(new GetDrawCbm(), new DrawVo()); drawing_cmb.DisplayMember = "DrawCode"; BindingSource b = new BindingSource(drawvolist.GetList(), null); drawing_cmb.DataSource = b; drawing_cmb.Text = ""; }
/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind(LocalSupplierVo conditionInVo) { LocalSupplier_dgv.DataSource = null; try { LocalSupplierVo outVo = (LocalSupplierVo)base.InvokeCbm(new GetLocalSupplierMasterMntCbm(), conditionInVo, false); LocalSupplier_dgv.AutoGenerateColumns = false; BindingSource bindingSource1 = new BindingSource(outVo.LocalSupplierListVo, null); if (bindingSource1.Count > 0) { LocalSupplier_dgv.DataSource = bindingSource1; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //process logger.Info(messageData); popUpMessage.Information(messageData, Text); } LocalSupplier_dgv.ClearSelection(); Update_btn.Enabled = false; Delete_btn.Enabled = false; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
/// <summary> /// selects user record for updation and show user form /// </summary> private void BindUpdateUserData() { int selectedrowindex = LocalSupplier_dgv.SelectedCells[0].RowIndex; LocalSupplierVo selectedData = (LocalSupplierVo)LocalSupplier_dgv.Rows[selectedrowindex].DataBoundItem; AddLocalSupplierForm newAddForm = new AddLocalSupplierForm(CommonConstants.MODE_UPDATE, selectedData); newAddForm.ShowDialog(this); if (newAddForm.IntSuccess > 0) { messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } else if (newAddForm.IntSuccess == 0) { messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LocalSupplierVo inVo = (LocalSupplierVo)arg; LocalSupplierVo outVo = new LocalSupplierVo(); StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select * from m_local_supplier "); sqlQuery.Append(" where 1 = 1 "); if (inVo.LocalSupplierCode != null) { sqlQuery.Append(" and local_supplier_cd like :localsuppliercd "); } if (inVo.LocalSupplierName != null) { sqlQuery.Append(" and local_supplier_name like :localsuppliername "); } sqlQuery.Append(" order by local_supplier_cd"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.LocalSupplierCode != null) { sqlParameter.AddParameterString("localsuppliercd", inVo.LocalSupplierCode + "%"); } if (inVo.LocalSupplierName != null) { sqlParameter.AddParameterString("localsuppliername", inVo.LocalSupplierName + "%"); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { LocalSupplierVo currOutVo = new LocalSupplierVo { LocalSupplierId = Convert.ToInt32(dataReader["local_supplier_id"]), LocalSupplierCode = dataReader["local_supplier_cd"].ToString(), LocalSupplierName = dataReader["local_supplier_name"].ToString(), }; outVo.LocalSupplierListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
/// <summary> /// For setting selected user record into respective controls(textbox and combobox) for update operation /// passing selected user data as parameter /// </summary> /// <param name="dgvData"></param> private void LoadUserData(LocalSupplierVo dgvData) { if (dgvData != null) { LocalSupplierCode_txt.Text = dgvData.LocalSupplierCode; LocalSupplierName_txt.Text = dgvData.LocalSupplierName; } }
/// <summary> /// event to delete the selected record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Delete_btn_Click(object sender, EventArgs e) { int selectedrowindex = LocalSupplier_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = LocalSupplier_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colLocalSupplierCode"].Value.ToString()); // Logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { LocalSupplierVo inVo = new LocalSupplierVo { LocalSupplierId = Convert.ToInt32(selectedRow.Cells["colLocalSupplierId"].Value), }; try { inVo.LocalSupplierCode = selectedRow.Cells["colLocalSupplierCode"].Value.ToString(); LocalSupplierVo tableCount = tableCount = CheckSupplierRelationCbm(inVo); if (tableCount.AffectedCount > 0) { messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, ProcessSupplier.ToString()); popUpMessage.Information(messageData, Text); return; } LocalSupplierVo outVo = (LocalSupplierVo)base.InvokeCbm(new DeleteLocalSupplierMasterMntCbm(), inVo, false); if (outVo.AffectedCount > 0) { messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } else if (outVo.AffectedCount == 0) { messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(FormConditionVo()); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } } else if (dialogResult == DialogResult.Cancel) { //do something else } }
/// <summary> /// constructor for the form /// </summary> /// <param name="pmode"></param> /// <param name="dataItem"></param> public AddLocalSupplierForm(string pmode, LocalSupplierVo dataItem = null) { InitializeComponent(); mode = pmode; updateData = dataItem; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { this.Text = UpdateText_lbl.Text; } }
/// <summary> /// checks duplicate Process Code /// </summary> /// <param name="processVo"></param> /// <returns></returns> private LocalSupplierVo DuplicateCheck(LocalSupplierVo localSupplierVo) { LocalSupplierVo outVo = new LocalSupplierVo(); try { outVo = (LocalSupplierVo)base.InvokeCbm(new CheckLocalSupplierMasterMntCbm(), localSupplierVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
/// <summary> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private LocalSupplierVo FormConditionVo() { LocalSupplierVo inVo = new LocalSupplierVo(); if (LocalSupplierCode_txt.Text != string.Empty) { inVo.LocalSupplierCode = LocalSupplierCode_txt.Text; } if (LocalSupplierName_txt.Text != string.Empty) { inVo.LocalSupplierName = LocalSupplierName_txt.Text; } return(inVo); }
/// <summary> /// Loads Process Work /// </summary> private void LoadLocalSupplier() { LocalSupplierVo outVo = new LocalSupplierVo(); try { outVo = (LocalSupplierVo)base.InvokeCbm(new GetLocalSupplierMasterMntCbm(), new LocalSupplierVo(), false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } ComboBind(Supplier_cmb, outVo.LocalSupplierListVo, "LocalSupplierName", "LocalSupplierId"); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LocalSupplierVo inVo = (LocalSupplierVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_local_supplier"); sqlQuery.Append(" ( "); sqlQuery.Append(" local_supplier_cd, "); sqlQuery.Append(" local_supplier_name, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :localsuppliercd ,"); sqlQuery.Append(" :localsuppliername ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" now() ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("localsuppliercd", inVo.LocalSupplierCode); sqlParameter.AddParameterString("localsuppliername", inVo.LocalSupplierName); sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode); //sqlParameter.AddParameterDateTime("registrationdatetime", inVo.RegistrationDateTime); sqlParameter.AddParameterString("factorycode", inVo.FactoryCode); LocalSupplierVo outVo = new LocalSupplierVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LocalSupplierVo inVo = (LocalSupplierVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append(" select Count(lsr.local_supplier_cd) as SupplierCount from m_local_supplier as lsr"); sqlQuery.Append(" inner join m_process_work_local_supplier as prsup on lsr.local_supplier_id = prsup.local_supplier_id "); sqlQuery.Append(" where 1 = 1 "); if (inVo.LocalSupplierCode != null) { sqlQuery.Append(" and UPPER(local_supplier_cd) = UPPER(:localsuppliercd)"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.LocalSupplierCode != null) { sqlParameter.AddParameterString("localsuppliercd", inVo.LocalSupplierCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); LocalSupplierVo outVo = new LocalSupplierVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["SupplierCount"]); } dataReader.Close(); return(outVo); }
/// <summary> /// form country and factory data for combo /// </summary> private void FormDatatableFromVo() { localSupplierDatatable = new DataTable(); localSupplierDatatable.Columns.Add("id"); localSupplierDatatable.Columns.Add("code"); try { LocalSupplierVo localSupplierVo = (LocalSupplierVo)base.InvokeCbm(new GetLocalSupplierMasterMntCbm(), new LocalSupplierVo(), false); foreach (LocalSupplierVo localSupplier in localSupplierVo.LocalSupplierListVo) { localSupplierDatatable.Rows.Add(localSupplier.LocalSupplierId, localSupplier.LocalSupplierName); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LocalSupplierVo inVo = (LocalSupplierVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete From m_local_supplier"); sqlQuery.Append(" Where "); sqlQuery.Append(" local_supplier_id = :localsupplierid ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("localsupplierid", inVo.LocalSupplierId); LocalSupplierVo outVo = new LocalSupplierVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void AddJigDrawForm_Load(object sender, EventArgs e) { status_cmb.Items.Add("OK"); status_cmb.Items.Add("NG"); ValueObjectList <ModelVo> modelvolist = null; try { modelvolist = (ValueObjectList <ModelVo>)DefaultCbmInvoker.Invoke(getModelCbm, new ModelVo()); } catch (Com.Nidec.Mes.Framework.ApplicationException ex) { logger.Error(ex.GetMessageData()); popUpMessage.ApplicationError(ex.GetMessageData(), Text); return; } model_cmb.DisplayMember = "ModelCode"; BindingSource b1 = new BindingSource(modelvolist.GetList(), null); model_cmb.DataSource = b1; model_cmb.Text = ""; ValueObjectList <DrawVo> drawvolist = null; try { drawvolist = (ValueObjectList <DrawVo>)DefaultCbmInvoker.Invoke(new GetDrawCbm(), new DrawVo()); } catch (Com.Nidec.Mes.Framework.ApplicationException ex) { logger.Error(ex.GetMessageData()); popUpMessage.ApplicationError(ex.GetMessageData(), Text); return; } drawing_cmb.DisplayMember = "DrawCode"; BindingSource b = new BindingSource(drawvolist.GetList(), null); drawing_cmb.DataSource = b; drawing_cmb.Text = ""; LocalSupplierVo suppliervolist = null; try { suppliervolist = (LocalSupplierVo)DefaultCbmInvoker.Invoke(new GetLocalSupplierMasterMntCbm(), new LocalSupplierVo()); } catch (Com.Nidec.Mes.Framework.ApplicationException ex) { logger.Error(ex.GetMessageData()); popUpMessage.ApplicationError(ex.GetMessageData(), Text); return; } supplier_cmb.DisplayMember = "LocalSupplierName"; BindingSource b2 = new BindingSource(suppliervolist.LocalSupplierListVo, null); supplier_cmb.DataSource = b2; supplier_cmb.Text = ""; if (vo.JigID > 0) { model_cmb.Enabled = false; supplier_cmb.Enabled = false; model_cmb.Text = vo.ModelCode; supplier_cmb.Text = vo.SupplierName; process_cmb.Text = vo.ProcessName; jig_code_txt.Text = vo.JigBCode; drawing_cmb.Text = vo.DrawCode; place_cmb.Text = vo.JigPlace; status_cmb.Text = vo.Status; timereceive_dtp.Value = vo.TimeReceive; } }
/// <summary> /// inserts/updates process on ok click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { if (CheckMandatory()) { var sch = StringCheckHelper.GetInstance(); if (string.IsNullOrEmpty(LocalSupplierCode_txt.Text) || string.IsNullOrEmpty(LocalSupplierName_txt.Text)) { messageData = new MessageData("mmce00003", Properties.Resources.mmce00003); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); if (string.IsNullOrEmpty(LocalSupplierCode_txt.Text)) { LocalSupplierCode_txt.Focus(); } else { LocalSupplierName_txt.Focus(); } return; } LocalSupplierVo inVo = new LocalSupplierVo { LocalSupplierCode = LocalSupplierCode_txt.Text.Trim(), LocalSupplierName = LocalSupplierName_txt.Text.Trim(), //RegistrationDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"), RegistrationUserCode = UserData.GetUserData().UserCode, FactoryCode = UserData.GetUserData().FactoryCode }; if (string.Equals(mode, CommonConstants.MODE_ADD)) { LocalSupplierVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, LocalSupplierCode_lbl.Text + " : " + LocalSupplierCode_txt.Text); logger.Info(messageData); popUpMessage.ApplicationError(messageData, Text); return; } } try { if (string.Equals(mode, CommonConstants.MODE_ADD)) { LocalSupplierVo outVo = (LocalSupplierVo)base.InvokeCbm(new AddLocalSupplierMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.LocalSupplierId = updateData.LocalSupplierId; LocalSupplierVo outVo = (LocalSupplierVo)base.InvokeCbm(new UpdateLocalSupplierMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if ((IntSuccess > 0) || (IntSuccess == 0)) { this.Close(); } } }