/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind(ProcessWorkLocalSupplierVo conditionInVo) { ProcessWork_dgv.DataSource = null; try { ProcessWorkLocalSupplierVo outVo = (ProcessWorkLocalSupplierVo)base.InvokeCbm(new GetProcessWorkLocalSupplierMasterMntCbm(), conditionInVo, false); ProcessWork_dgv.AutoGenerateColumns = false; outVo.ProcessWorkLocalSupplierListVo.ForEach(t => t.IsExists = t.LocalSupplierId > 0 ? "True" : "False"); BindingSource bindingSource1 = new BindingSource(outVo.ProcessWorkLocalSupplierListVo, null); if (bindingSource1.Count > 0) { ProcessWork_dgv.DataSource = bindingSource1; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //item process work logger.Info(messageData); popUpMessage.Information(messageData, Text); } ProcessWork_dgv.ClearSelection(); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkLocalSupplierVo inVo = (ProcessWorkLocalSupplierVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete from m_process_work_local_supplier"); sqlQuery.Append(" Where "); sqlQuery.Append(" local_supplier_id = :suppid "); sqlQuery.Append(" and "); sqlQuery.Append(" process_work_id = :workid "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("suppid", inVo.LocalSupplierId); sqlParameter.AddParameterInteger("workid", inVo.ProcessWorkId); ProcessWorkLocalSupplierVo outVo = new ProcessWorkLocalSupplierVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkLocalSupplierVo inVo = (ProcessWorkLocalSupplierVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select"); sqlQuery.Append(" pw.process_work_id,"); sqlQuery.Append(" pw.process_work_name,"); sqlQuery.Append(" t.local_supplier_id"); sqlQuery.Append(" from m_process_work pw "); sqlQuery.Append(" left join "); sqlQuery.Append(" (select pws.process_work_id, pws.local_supplier_id from m_process_work_local_supplier pws "); sqlQuery.Append(" inner join m_local_supplier ls on ls.local_supplier_id = pws.local_supplier_id "); sqlQuery.Append(" where pws.local_supplier_id = :localsupplierid ) t "); sqlQuery.Append(" on t.process_work_id = pw.process_work_id "); //if (inVo.LocalSupplierId > 0) //{ // sqlQuery.Append(" and pws.local_supplier_id = :localsupplierid"); //} //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.LocalSupplierId > 0) { sqlParameter.AddParameterInteger("localsupplierid", inVo.LocalSupplierId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ProcessWorkLocalSupplierVo outVo = new ProcessWorkLocalSupplierVo(); while (dataReader.Read()) { ProcessWorkLocalSupplierVo currOutVo = new ProcessWorkLocalSupplierVo { LocalSupplierId = Convert.ToInt32(DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["local_supplier_id"])), ProcessWorkId = Convert.ToInt32(dataReader["process_work_id"]), ProcessWorkName = dataReader["process_work_name"].ToString(), }; outVo.ProcessWorkLocalSupplierListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
/// <summary> /// updates process work local supplier /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Update_btn_Click(object sender, EventArgs e) { try { ProcessWorkLocalSupplierVo outVo; Cursor.Current = Cursors.WaitCursor; if (CheckMandatory() && ProcessWork_dgv.RowCount > 0) { foreach (DataGridViewRow row in ProcessWork_dgv.Rows) { outVo = new ProcessWorkLocalSupplierVo(); ProcessWorkLocalSupplierVo checkInVo = new ProcessWorkLocalSupplierVo { LocalSupplierId = Convert.ToInt32(Supplier_cmb.SelectedValue.ToString()) }; ProcessWorkLocalSupplierVo checkOutVo = (ProcessWorkLocalSupplierVo)base.InvokeCbm(new GetProcessWorkLocalSupplierMasterMntCbm(), checkInVo, false); bool isExists = checkOutVo.ProcessWorkLocalSupplierListVo.Any(t => t.LocalSupplierId > 0 && t.ProcessWorkId == Convert.ToInt32(row.Cells["colProcessWorkId"].Value.ToString())); ProcessWorkLocalSupplierVo processWorkSupInVo = new ProcessWorkLocalSupplierVo { LocalSupplierId = Convert.ToInt32(Supplier_cmb.SelectedValue.ToString()), ProcessWorkId = Convert.ToInt32(row.Cells["colProcessWorkId"].Value.ToString()), RegistrationUserCode = UserData.GetUserData().UserCode, FactoryCode = UserData.GetUserData().FactoryCode }; if (row.Cells["colSelect"].Value.ToString() == "True" && !isExists) { outVo = (ProcessWorkLocalSupplierVo)base.InvokeCbm(new AddProcessWorkLocalSupplierMasterMntCbm(), processWorkSupInVo, false); } else if (row.Cells["colSelect"].Value.ToString() == "False" && isExists) { outVo = (ProcessWorkLocalSupplierVo)base.InvokeCbm(new DeleteProcessWorkLocalSupplierMasterMntCbm(), processWorkSupInVo, false); } } Cursor.Current = Cursors.Default; messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); Cursor.Current = Cursors.WaitCursor; GridBind(FormConditionVo()); Cursor.Current = Cursors.Default; } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
/// <summary> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private ProcessWorkLocalSupplierVo FormConditionVo() { ProcessWorkLocalSupplierVo inVo = new ProcessWorkLocalSupplierVo(); if (Supplier_cmb.SelectedIndex > -1) { inVo.LocalSupplierId = Convert.ToInt32(Supplier_cmb.SelectedValue); } return(inVo); }
/// <summary> /// Get with processwork /// </summary> private void LoadProcessWork() { ProcessWorkLocalSupplierVo prWLSInVo = new ProcessWorkLocalSupplierVo(); prWLSInVo.LocalSupplierId = Convert.ToInt32(Supplier_cmb.SelectedValue); ProcessWorkLocalSupplierVo prWLSOutVo = new ProcessWorkLocalSupplierVo(); try { prWLSOutVo = (ProcessWorkLocalSupplierVo)base.InvokeCbm(new GetProcessWorkLocalSupplierMasterMntCbm(), prWLSInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkLocalSupplierVo inVo = (ProcessWorkLocalSupplierVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_process_work_local_supplier"); sqlQuery.Append(" ( "); sqlQuery.Append(" local_supplier_id, "); sqlQuery.Append(" process_work_id, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :localsuppid ,"); sqlQuery.Append(" :processworkid ,"); 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.AddParameterInteger("localsuppid", inVo.LocalSupplierId); sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId); sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode); sqlParameter.AddParameterString("factorycode", inVo.FactoryCode); ProcessWorkLocalSupplierVo outVo = new ProcessWorkLocalSupplierVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }