/// <summary> /// passing update data to update form /// </summary> private void BindUpdateInspectionProcessData() { int selectedrowindex = InspectionProcessDetails_dgv.SelectedCells[0].RowIndex; InspectionProcessVo inspProcessVo = (InspectionProcessVo)InspectionProcessDetails_dgv.Rows[selectedrowindex].DataBoundItem; AddInspectionProcessForm newAddForm = new AddInspectionProcessForm(CommonConstants.MODE_UPDATE, inspProcessVo); 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()); } }
/// <summary> /// Load Inspection Process /// </summary> private void LoadInspectionProcessCombo() { ValueObjectList <InspectionProcessVo> outVo = null; InspectionProcessVo inVo = new InspectionProcessVo(); //inVo.InspectionFormatId = InspectionFormatId; try { outVo = (ValueObjectList <InspectionProcessVo>)base.InvokeCbm(new GetInsepctionProcessMasterMntCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0) { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } InspectionProcess_cmb.DisplayMember = "InspectionProcessName"; InspectionProcess_cmb.ValueMember = "InspectionProcessId"; InspectionProcess_cmb.DataSource = outVo.GetList(); InspectionProcess_cmb.SelectedValue = InspectionProcessId; }
private void checkRunningCount(InspectionProcessVo inVo) { InspectionProcessVo outVo = new InspectionProcessVo(); try { outVo = (InspectionProcessVo)base.InvokeCbm(new GetInspectionProcessSeqCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } RunningNumber = 1; if (outVo != null && outVo.InspectionProcessCode != null) { string strTemp; strTemp = outVo.InspectionProcessCode; if (strTemp.LastIndexOf(GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue()) > 0) { strTemp = strTemp.Substring(strTemp.LastIndexOf(GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue()) + 1); if (strTemp.All(Char.IsDigit)) { RunningNumber = Convert.ToInt32(strTemp) + 1; } } } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionProcessVo inVo = (InspectionProcessVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_inspection_process"); sqlQuery.Append(" Set "); sqlQuery.Append(" inspection_process_cd = :inspectionprocesscd, "); sqlQuery.Append(" inspection_process_name = :inspectionprocessname, "); sqlQuery.Append(" inspection_format_id = :inspectionformatid, "); sqlQuery.Append(" display_order = :displayorder "); sqlQuery.Append(" Where "); sqlQuery.Append(" inspection_process_id = :inspectionprocessid "); sqlQuery.Append(" and factory_cd = :faccd ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("inspectionprocessid", inVo.InspectionProcessId); sqlParameter.AddParameterString("inspectionprocesscd", inVo.InspectionProcessCode); sqlParameter.AddParameterString("inspectionprocessname", inVo.InspectionProcessName); sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); InspectionProcessVo outVo = new InspectionProcessVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
private void InspectionItem_btn_Click(object sender, EventArgs e) { int selectedrowindex = InspectionProcessDetails_dgv.SelectedCells[0].RowIndex; InspectionProcessVo inspProcessVo = (InspectionProcessVo)InspectionProcessDetails_dgv.Rows[selectedrowindex].DataBoundItem; InspectionItemForProcessForm frm = new GlobalMasterMaintenance.InspectionItemForProcessForm(); frm.InspectionProcessId = inspProcessVo.InspectionProcessId; frm.InspectionProcessCode = inspProcessVo.InspectionProcessCode; frm.InspectionProcessName = inspProcessVo.InspectionProcessName; frm.InspectionFormatId = FormatId; frm.ShowDialog(); if (frm.InspectionProcessId > 0) { InspectionFormatProcessBuzzLogic getprocessid = new InspectionFormatProcessBuzzLogic(); InspectionReturnVo invo = new InspectionReturnVo(); invo.InspectionProcessId = frm.InspectionProcessId; InspectionReturnVo getInspectionVo = getprocessid.RefreshAllFormGrid(invo); if (getInspectionVo != null && getInspectionVo.InspectionFormatId > 0) { FormatId = getInspectionVo.InspectionFormatId; //FormDatatableFromVo(); //ComboBind(InspectionFormatId_cmb, inspectionformatDatatable, "Name", "Id"); //InspectionFormatId_cmb.SelectedValue = FormatId; } } GridBind(); if (InspectionProcessDetails_dgv.Rows.Count > 0 && InspectionProcessDetails_dgv.Columns.Count > 0 && InspectionProcessDetails_dgv.Columns["colInspectionProcessId"] != null) { int searchProcessId; if (frm.InspectionProcessId > 0) { searchProcessId = frm.InspectionProcessId; } else { searchProcessId = inspProcessVo.InspectionProcessId; } DataGridViewRow row = InspectionProcessDetails_dgv.Rows .Cast <DataGridViewRow>() .FirstOrDefault(r => r.Cells["colInspectionProcessId"].Value.ToString().Equals(searchProcessId.ToString())); if (row == null) { return; } InspectionProcessDetails_dgv.Rows[row.Index].Selected = true; InspectionProcessDetails_dgv_CellClick(sender, new DataGridViewCellEventArgs(0, row.Index)); } }
/// <summary> /// delete the selected record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Delete_btn_Click(object sender, EventArgs e) { int selectedrowindex = InspectionProcessDetails_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = InspectionProcessDetails_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colInspectionProcessCode"].Value.ToString()); // Logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { InspectionProcessVo inVo = new InspectionProcessVo(); inVo.InspectionProcessId = Convert.ToInt32(selectedRow.Cells["colInspectionProcessId"].Value.ToString()); inVo.InspectionProcessCode = selectedRow.Cells["colInspectionProcessCode"].Value.ToString(); try { InspectionProcessVo tableCount = CheckInspectionProcessRelationCbm(inVo); if (tableCount.InspectionProcessId > 0) { messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, InspectionItem.ToString()); popUpMessage.Information(messageData, Text); return; } InspectionProcessVo outVo = (InspectionProcessVo)base.InvokeCbm(new DeleteInspectionProcessMasterMntCbm(), inVo, false); if (outVo.AffectedCount > 0) { this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); logger.Info(this.messageData); popUpMessage.Information(this.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> /// event to delete the selected record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { if (InspectionProcessDetails_dgv.Rows.Count > 0 && InspectionProcessDetails_dgv.SelectedRows.Count > 0) { InspectionProcessVo inspectionprocessInVo = (InspectionProcessVo)InspectionProcessDetails_dgv.Rows[InspectionProcessDetails_dgv.CurrentRow.Index].DataBoundItem; InspectionProcessId = inspectionprocessInVo.InspectionProcessId; InspectionProcessName = inspectionprocessInVo.InspectionProcessName; InspectionProcessCode = inspectionprocessInVo.InspectionProcessCode; } this.Close(); }
///// <summary> ///// InspectionFormatVo ///// </summary> //private ValueObjectList<InspectionFormatVo> inspectionFormatOutVo = null; #endregion #region Constructor /// <summary> /// constructor /// </summary> /// <param name="pmode"></param> /// <param name="userItem"></param> public AddInspectionProcessForFormatForm(string pmode, InspectionProcessVo userItem = null) { InitializeComponent(); mode = pmode; updateData = userItem; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { this.Text = UpdateText_lbl.Text; } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionProcessVo inVo = (InspectionProcessVo)arg; StringBuilder sql = new StringBuilder(); //create SQL sql.Append("Select Count(*) as InspectionProcessCount from m_inspection_process"); sql.Append(" where factory_cd = :faccd "); if (inVo.InspectionProcessName != null) { sql.Append(" and UPPER(inspection_process_name) = UPPER(:inspectionprocessname)"); } if (inVo.InspectionFormatId > 0) { sql.Append(" and inspection_format_id = :inspectionformatid "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.InspectionProcessName != null) { sqlParameter.AddParameterString("inspectionprocessname", inVo.InspectionProcessName); } if (inVo.InspectionFormatId > 0) { sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); InspectionProcessVo outVo = new InspectionProcessVo { AffectedCount = 0 }; while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["InspectionProcessCount"]); } dataReader.Close(); return(outVo); }
/// <summary> /// Loads selected data from data grid /// </summary> /// <param name="dgvInspectionProcess"></param> private void LoadInspectionProcessData(InspectionProcessVo dgvInspectionProcess) { if (dgvInspectionProcess != null) { this.InspectionProcessCode_txt.Text = dgvInspectionProcess.InspectionProcessCode; this.InspectionProcessName_txt.Text = dgvInspectionProcess.InspectionProcessName; this.InspectionFormat_cmb.SelectedValue = dgvInspectionProcess.InspectionFormatId.ToString(); } }
private void ChangeGridDataColorForRelationDataCheck() { foreach (DataGridViewRow row in InspectionProcessDetails_dgv.Rows) { InspectionProcessVo InspectionUpdateVo = (InspectionProcessVo)row.DataBoundItem; if (InspectionUpdateVo.InspectionItemId == 0) { row.DefaultCellStyle.ForeColor = Color.Red; row.Cells["Comments"].Value = Properties.Resources.mmci00026; } } }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { InspectionProcessVo inVo = (InspectionProcessVo)vo; ValueObjectList <InspectionProcessVo> inspectionProcessListInVo = new ValueObjectList <InspectionProcessVo>(); ValueObjectList <InspectionItemVo> inspectionItemListInVo = new ValueObjectList <InspectionItemVo>(); ValueObjectList <InspectionItemSelectionDatatypeValueVo> inspectionDataTypeSelectionListInVo = new ValueObjectList <InspectionItemSelectionDatatypeValueVo>(); ValueObjectList <InspectionSpecificationVo> inspectionSpecificationListInVo = new ValueObjectList <InspectionSpecificationVo>(); ValueObjectList <InspectionTestInstructionVo> inspectionTestInstructionListInVo = new ValueObjectList <InspectionTestInstructionVo>(); ValueObjectList <InspectionTestInstructionVo> inspectionTestInstructionDetailListInVo = new ValueObjectList <InspectionTestInstructionVo>(); ValueObjectList <ValueObject> OutVo = new ValueObjectList <ValueObject>(); inspectionProcessListInVo.add(inVo); // Create the Vo to get the Inspection Process ValueObjectList <InspectionProcessVo> GetProcessinVoList = new ValueObjectList <InspectionProcessVo>(); InspectionProcessVo ProcessVo = new InspectionProcessVo(); ProcessVo.InspectionProcessId = inVo.InspectionProcessIdCopy; GetProcessinVoList.add(ProcessVo); //get inspection item list for the above fetched processlist inspectionItemListInVo = (ValueObjectList <InspectionItemVo>)getInspectionItemListCbm.Execute(trxContext, GetProcessinVoList); if (inspectionItemListInVo != null && inspectionItemListInVo.GetList() != null && inspectionItemListInVo.GetList().Count > 0) { //get inspectionSelectionDataType for the above fetched itemlist inspectionDataTypeSelectionListInVo = (ValueObjectList <InspectionItemSelectionDatatypeValueVo>)getInspectionSelectionDataTypeListCbm.Execute(trxContext, inspectionItemListInVo); //get inspectionspecification for the above fetched itemlist inspectionSpecificationListInVo = (ValueObjectList <InspectionSpecificationVo>)getInspectionSpecficationListCbm.Execute(trxContext, inspectionItemListInVo); //get inspectiontestinstruction for the above fetched itemlist inspectionTestInstructionListInVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionListCbm.Execute(trxContext, inspectionItemListInVo); } if (inspectionTestInstructionListInVo != null && inspectionTestInstructionListInVo.GetList() != null && inspectionTestInstructionListInVo.GetList().Count > 0) { //get inspectiontestinstructiondetail for the above fetched inspectiontestinstruction inspectionTestInstructionDetailListInVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionDetailListCbm.Execute(trxContext, inspectionTestInstructionListInVo); } OutVo.add(null); OutVo.add(inspectionProcessListInVo); OutVo.add(inspectionItemListInVo); OutVo.add(inspectionDataTypeSelectionListInVo); OutVo.add(inspectionSpecificationListInVo); OutVo.add(inspectionTestInstructionListInVo); OutVo.add(inspectionTestInstructionDetailListInVo); return(OutVo); }
/// <summary> /// Fills all user records to gridview control /// </summary> protected void GridBind(InspectionProcessVo conditionInVo) { if (conditionInVo == null) { return; } Ok_btn.Enabled = false; InspectionProcessDetails_dgv.DataSource = null; ValueObjectList <InspectionProcessVo> outVo = null; try { outVo = (ValueObjectList <InspectionProcessVo>)base.InvokeCbm(new GetInspectionProcessForCopyMasterMntCbm(), conditionInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0) { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } InspectionFormatName_txt.Text = outVo.GetList()[0].InspectionFormatName; InspectionProcessDetails_dgv.AutoGenerateColumns = false; BindingSource bindingSource1 = new BindingSource(outVo.GetList(), null); if (bindingSource1 != null && bindingSource1.Count > 0) { InspectionProcessDetails_dgv.DataSource = bindingSource1; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } InspectionProcessDetails_dgv.ClearSelection(); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionProcessVo inVo = (InspectionProcessVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_inspection_process"); sqlQuery.Append(" ( "); sqlQuery.Append(" inspection_process_cd,"); sqlQuery.Append(" inspection_process_name,"); sqlQuery.Append(" inspection_format_id,"); sqlQuery.Append(" display_order,"); sqlQuery.Append(" registration_user_cd,"); sqlQuery.Append(" registration_date_time,"); sqlQuery.Append(" factory_cd"); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :inspectionprocesscd,"); sqlQuery.Append(" :inspectionprocessname,"); sqlQuery.Append(" :inspectionformatid,"); sqlQuery.Append(" :displayorder,"); sqlQuery.Append(" :registrationusercode,"); sqlQuery.Append(" :regdatetime,"); sqlQuery.Append(" :factorycode"); sqlQuery.Append(" ) "); sqlQuery.Append(" RETURNING inspection_process_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("inspectionprocesscd", inVo.InspectionProcessCode); sqlParameter.AddParameterString("inspectionprocessname", inVo.InspectionProcessName); sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); UserData userdata = trxContext.UserData; sqlParameter.AddParameterString("registrationusercode", userdata.UserCode); sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", userdata.FactoryCode); InspectionProcessVo outVo = new InspectionProcessVo(); outVo.InspectionProcessId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionProcessVo inVo = (InspectionProcessVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append(" Select ip.inspection_process_id as inspectionprocessid, "); sqlQuery.Append(" iitm.inspection_process_id as inspectionitemprocessid from m_inspection_process ip "); sqlQuery.Append(" left join m_inspection_item iitm on "); sqlQuery.Append(" iitm.inspection_process_id = ip.inspection_process_id "); sqlQuery.Append(" where ip.factory_cd = :faccd "); if (inVo.InspectionProcessCode != null) { sqlQuery.Append(" and UPPER(ip.inspection_process_cd) = UPPER(:inspectionprocesscd)"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.InspectionProcessCode != null) { sqlParameter.AddParameterString("inspectionprocesscd", inVo.InspectionProcessCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); InspectionProcessVo outVo = new InspectionProcessVo { AffectedCount = 0 }; while (dataReader.Read()) { if (outVo == null) { outVo = new InspectionProcessVo(); } outVo.InspectionProcessId = ConvertDBNull <int>(dataReader, "inspectionitemprocessid"); } dataReader.Close(); return(outVo); }
/// <summary> /// checks duplicate Display Record /// </summary> /// <param name="defectVo"></param> /// <returns></returns> private InspectionProcessVo DuplicateDisplayCheck(InspectionProcessVo defectVo) { InspectionProcessVo outVo = new InspectionProcessVo(); try { outVo = (InspectionProcessVo)base.InvokeCbm(new CheckInspectionProcessWorkDisplayOrderCbm(), defectVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
/// <summary> /// To idenctify the relation ship with tables /// </summary> private InspectionProcessVo CheckInspectionProcessRelationCbm(InspectionProcessVo inVo) { InspectionProcessVo outVo = new InspectionProcessVo(); try { outVo = (InspectionProcessVo)base.InvokeCbm(new CheckInspectionProcessRelationCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
/// <summary> /// insert the record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Add_btn_Click(object sender, EventArgs e) { InspectionProcessVo inspProcessVo = new InspectionProcessVo(); inspProcessVo.InspectionFormatId = FormatId; inspProcessVo.InspectionFormatCode = FormatCode; inspProcessVo.InspectionFormatName = FormatName; AddInspectionProcessForFormatForm newAddForm = new AddInspectionProcessForFormatForm(CommonConstants.MODE_ADD, inspProcessVo); newAddForm.ShowDialog(); if (newAddForm.IntSuccess > 0) { messageData = new MessageData("mmci00001", Properties.Resources.mmci00001, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); GridBind(); if (InspectionProcessDetails_dgv.Rows.Count > 0 && InspectionProcessDetails_dgv.Columns.Count > 0 && InspectionProcessDetails_dgv.Columns["colInspectionProcessId"] != null) { int searchProcessId; if (newAddForm.IntSuccess > 0) { searchProcessId = newAddForm.IntSuccess; } else { return; } DataGridViewRow row = InspectionProcessDetails_dgv.Rows .Cast <DataGridViewRow>() .FirstOrDefault(r => r.Cells["colInspectionProcessId"].Value.ToString().Equals(searchProcessId.ToString())); if (row == null) { return; } InspectionProcessDetails_dgv.Rows[row.Index].Selected = true; InspectionProcessDetails_dgv_CellClick(sender, new DataGridViewCellEventArgs(0, row.Index)); InspectionProcessDetails_dgv.FirstDisplayedScrollingRowIndex = row.Index; } } }
/// <summary> /// Loads selected data from data grid /// </summary> /// <param name="dgvInspectionProcess"></param> private void LoadInspectionProcessData(InspectionProcessVo dgvInspectionProcess) { if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { this.InspectionProcessName_txt.Text = dgvInspectionProcess.InspectionProcessName; //this.InspectionFormat_cmb.SelectedValue = dgvInspectionProcess.InspectionFormatId.ToString(); this.InspectionFormat_cmb.Text = updateData.InspectionFormatName; this.InspectionProcessDisplayOrder_txt.Text = dgvInspectionProcess.DisplayOrder.ToString(); } else { //this.InspectionFormat_cmb.SelectedValue = dgvInspectionProcess.InspectionFormatId.ToString(); this.InspectionFormat_cmb.Text = updateData.InspectionFormatName; } }
/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind() { InspectionItem_btn.Enabled = Update_btn.Enabled = Delete_btn.Enabled = false; InspectionProcessVo inVo = new InspectionProcessVo(); inVo.InspectionFormatId = FormatId; InspectionProcessDetails_dgv.DataSource = null; ValueObjectList <InspectionProcessVo> outVo = null; try { outVo = (ValueObjectList <InspectionProcessVo>)base.InvokeCbm(new GetInspectionProcessMasterMntCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0) { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); //popUpMessage.Information(messageData, Text); return; } InspectionProcessDetails_dgv.AutoGenerateColumns = false; BindingSource bindingSource1 = new BindingSource(outVo.GetList(), null); if (bindingSource1 != null && bindingSource1.Count > 0) { InspectionProcessDetails_dgv.DataSource = bindingSource1; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } ChangeGridDataColorForRelationDataCheck(); InspectionProcessDetails_dgv.ClearSelection(); }
/// <summary> /// Get process /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void GetProcess_btn_Click(object sender, EventArgs e) { if (!CheckMandatory()) { return; } InspectionProcessVo conditionInVo = FormConditionVo(); InspectionItem_dgv.DataSource = null; ValueObjectList <InspectionProcessVo> outVo = null; try { outVo = (ValueObjectList <InspectionProcessVo>)base.InvokeCbm(new GetInspectionProcessForCopyMasterMntCbm(), conditionInVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0) { InspectionFormatName_txt.Text = string.Empty; ItemName_lbl.Text = string.Empty; ProcessId_cmb.DataSource = null; ProcessId_cmb.SelectedIndex = -1; ProcessId_cmb.Enabled = false; messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } InspectionFormatName_txt.Text = outVo.GetList()[0].InspectionFormatName; ProcessId_cmb.DisplayMember = "InspectionProcessName"; ProcessId_cmb.ValueMember = "InspectionProcessId"; ProcessId_cmb.DataSource = outVo.GetList(); ProcessId_cmb.SelectedIndex = -1; ProcessId_cmb.Enabled = true; }
/// <summary> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> protected InspectionProcessVo FormConditionVo() { InspectionProcessVo inVo = new InspectionProcessVo(); //if (ItemId_cmb.SelectedIndex > -1) //{ // inVo.ItemCode = ItemId_cmb.SelectedValue.ToString(); //} if (ItemCode_txt.Text != string.Empty) //&& sapItemGlobalVo != null { inVo.ItemCode = ItemCode_txt.Text; } if (LineId_cmb.SelectedIndex > -1) { inVo.LineCode = LineId_cmb.SelectedValue.ToString(); } return(inVo); }
/// <summary> /// form load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void AddInspectionProcessForm_Load(object sender, EventArgs e) { //FormDatatableFromVo(); //ComboBind(InspectionFormat_cmb, inspectionformatDatatable, "Name", "Id"); if (updateData != null && updateData.InspectionProcessIdCopy > 0) { InspectionprocessId = updateData.InspectionProcessIdCopy; CopyProcess_txt.Text = updateData.InspectionProcessName; } InspectionProcessName_txt.Select(); if (updateData != null) { LoadInspectionProcessData(updateData); } if (string.Equals(mode, CommonConstants.MODE_ADD)) { InspectionProcessVo outVo = (InspectionProcessVo)base.InvokeCbm(new GetInspectionProcessDisplayOrderNextValCbm(), updateData, false); if (outVo != null && outVo.DisplayOrder > 0) { InspectionProcessDisplayOrder_txt.Text = outVo.DisplayOrder.ToString(); } else { InspectionProcessDisplayOrder_txt.Text = "1"; } InspectionProcessVo inVo = new InspectionProcessVo(); inVo.InspectionFormatId = updateData.InspectionFormatId; checkRunningCount(inVo); } else { CopyProcess_btn.Enabled = false; CopyProcess_txt.ReadOnly = true; CopyProcess_txt.Enabled = false; } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionProcessVo inVo = (InspectionProcessVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select max(display_order)+1 display_order "); sqlQuery.Append(" from m_inspection_process "); sqlQuery.Append(" where factory_cd = :factcd"); if (inVo.InspectionFormatId > 0) { sqlQuery.Append(" and inspection_format_id = :inspectionformatid"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factcd", UserData.GetUserData().FactoryCode); if (inVo.InspectionFormatId > 0) { sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); InspectionProcessVo outVo = null; while (dataReader.Read()) { outVo = new InspectionProcessVo(); outVo.DisplayOrder = ConvertDBNull <int>(dataReader, "display_order"); } dataReader.Close(); return(outVo); }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { InspectionProcessVo inVo = (InspectionProcessVo)vo; ValueObjectList <ValueObjectList <ValueObject> > outVo = null; //if process data not found return the vo if (inVo == null || inVo.InspectionProcessIdCopy == 0) { return(outVo); } InspectionProcessVo returnProcessVo = null; inVo.InspectionProcessCode = inVo.InspectionFormatCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.PROCESS_CODE.GetValue() + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + inVo.SequenceNo; returnProcessVo = (InspectionProcessVo)addInspectionProcessMasterMntCbm.Execute(trxContext, inVo); //To get the old record for InspectionItem Insertion inVo.InspectionProcessId = inVo.InspectionProcessIdCopy; //No records Added if (returnProcessVo == null || returnProcessVo.InspectionProcessId == 0) { return(outVo); } returnProcessVo.InspectionProcessCode = inVo.InspectionProcessCode; ValueObjectList <ValueObject> CombinationVo = new ValueObjectList <ValueObject>(); CombinationVo.add(inVo); CombinationVo.add(returnProcessVo); if (outVo == null) { outVo = new ValueObjectList <ValueObjectList <ValueObject> >(); } outVo.add(CombinationVo); return(outVo); }
/// <summary> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private InspectionProcessVo FormConditionVo() { InspectionProcessVo inVo = new InspectionProcessVo(); if (InspectionProcessCode_txt.Text != string.Empty) { inVo.InspectionProcessCode = InspectionProcessCode_txt.Text; } if (InspectionProcessName_txt.Text != string.Empty) { inVo.InspectionProcessName = InspectionProcessName_txt.Text; } if (InspectionFormatId_cmb.SelectedIndex > -1) { inVo.InspectionFormatId = Convert.ToInt32(InspectionFormatId_cmb.SelectedValue.ToString()); } return(inVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionProcessVo inVo = (InspectionProcessVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("select"); sqlQuery.Append(" inspection_process_cd "); sqlQuery.Append(" from m_inspection_process"); sqlQuery.Append(" where factory_cd = :faccd "); sqlQuery.Append(" and inspection_format_id = :inspectionformatid "); sqlQuery.Append(" order by inspection_process_id desc "); sqlQuery.Append(" limit 1 "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); InspectionProcessVo currOutVo = new InspectionProcessVo(); while (dataReader.Read()) { currOutVo.InspectionProcessCode = ConvertDBNull <string>(dataReader, "inspection_process_cd"); } dataReader.Close(); return(currOutVo); }
/// <summary> /// passing update data to update form /// </summary> private void BindUpdateInspectionProcessData() { int selectedrowindex = InspectionProcessDetails_dgv.SelectedCells[0].RowIndex; InspectionProcessVo inspProcessVo = (InspectionProcessVo)InspectionProcessDetails_dgv.Rows[selectedrowindex].DataBoundItem; AddInspectionProcessForFormatForm newAddForm = new AddInspectionProcessForFormatForm(CommonConstants.MODE_UPDATE, inspProcessVo); newAddForm.ShowDialog(this); if (newAddForm.IntSuccess > 0) { messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); if (newAddForm.ReturnFormatId > 0) { FormatId = newAddForm.ReturnFormatId; } //FormDatatableFromVo(); //ComboBind(InspectionFormatId_cmb, inspectionformatDatatable, "Name", "Id"); //InspectionFormatId_cmb.SelectedValue = FormatId; GridBind(); } else if (newAddForm.IntSuccess == 0) { messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); //GridBind(); } InspectionProcessDetails_dgv.Rows[selectedrowindex].Selected = true; InspectionProcessDetails_dgv_CellClick(this, new DataGridViewCellEventArgs(0, selectedrowindex)); InspectionProcessDetails_dgv.FirstDisplayedScrollingRowIndex = selectedrowindex; }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { InspectionFormatVo inVo = new InspectionFormatVo(); ValueObjectList <ValueObject> inListVo = (ValueObjectList <ValueObject>)vo; InspectionReturnVo outVo = null; if (inListVo == null && inListVo.GetList() == null && inListVo.GetList().Count == 0) { return(null); } InspectionFormatVo updateFormatVo = (InspectionFormatVo)inListVo.GetList()[0]; InspectionProcessVo updateprocessVo = (InspectionProcessVo)inListVo.GetList()[1]; InspectionItemVo updateitemVo = (InspectionItemVo)inListVo.GetList()[2]; InspectionItemSelectionDatatypeValueVo updateSelectionDataTypeValueVo = (InspectionItemSelectionDatatypeValueVo)inListVo.GetList()[3]; InspectionSpecificationVo updateSpecificationVo = (InspectionSpecificationVo)inListVo.GetList()[4]; InspectionTestInstructionVo updateTestInstructionVo = (InspectionTestInstructionVo)inListVo.GetList()[5]; InspectionTestInstructionVo updateTestInstructionDetailVo = (InspectionTestInstructionVo)inListVo.GetList()[6]; if (!(updateprocessVo != null && updateprocessVo.InspectionProcessIdCopy > 0 && updateitemVo != null && updateitemVo.InspectionItemIdCopy > 0)) { InspectionFormatVo inspFormatVo = new InspectionFormatVo(); inspFormatVo.InspectionFormatId = updateFormatVo.InspectionFormatIdCopy; inspFormatVo.InspectionFormatCode = updateFormatVo.InspectionFormatCode; inspFormatVo.InspectionFormatName = updateFormatVo.InspectionFormatName; UpdateResultVo updateResultVo = (UpdateResultVo)checkInspectionFormatExitInTransactionCbm.Execute(trxContext, inspFormatVo); if (updateResultVo.AffectedCount == 0) { outVo = new InspectionReturnVo(); if (updateFormatVo.Mode == CommonConstants.MODE_UPDATE) { //update inspectionformat InspectionFormatVo inspectionFormatVo = (InspectionFormatVo)updateInspectionFormatMasterMntCbm.Execute(trxContext, inspFormatVo); outVo.AffectedCount = inspectionFormatVo.AffectedCount; outVo.InspectionFormatId = inspFormatVo.InspectionFormatId; return(outVo); } if (updateprocessVo != null) { InspectionProcessVo inspectionProcessVo = new InspectionProcessVo(); if (updateprocessVo.DeleteFlag) { //delete inspectionprocess return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo)); } else { //update inspectionprocess inspectionProcessVo = (InspectionProcessVo)updateInspectionProcessMasterMntCbm.Execute(trxContext, updateprocessVo); } outVo.AffectedCount = inspectionProcessVo.AffectedCount; outVo.InspectionProcessId = updateprocessVo.InspectionProcessId; outVo.InspectionFormatId = inspFormatVo.InspectionFormatId; return(outVo); } if (updateSelectionDataTypeValueVo != null) { if (updateSelectionDataTypeValueVo.DeleteFlag) { //delete inspectionitemselectionvalue return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo)); } else { //update inspectionitemselectionvalue UpdateResultVo inspectionItemSelectionDatatypeValueVo = (UpdateResultVo)updateInspectionItemSelectionDatatypeValueCbm.Execute(trxContext, updateSelectionDataTypeValueVo); outVo.AffectedCount = inspectionItemSelectionDatatypeValueVo.AffectedCount; outVo.InspectionItemId = updateSelectionDataTypeValueVo.InspectionItemId; return(outVo); } } if (updateitemVo != null) { InspectionItemVo inspectionItemVo = new InspectionItemVo(); if (updateitemVo.DeleteFlag) { //delete inspectionitem return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo)); } else { //update inspectionitem inspectionItemVo = (InspectionItemVo)updateInspectionItemMasterMntCbm.Execute(trxContext, updateitemVo); } outVo.AffectedCount = inspectionItemVo.AffectedCount; outVo.InspectionItemId = updateitemVo.InspectionItemId; outVo.InspectionProcessId = updateitemVo.InspectionProcessId; return(outVo); } if (updateSpecificationVo != null) { InspectionSpecificationVo inspectionSpecificationVo = new InspectionSpecificationVo(); if (updateSpecificationVo.DeleteFlag) { //delete inspectionspecification return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo)); } else { //update inspectionspecification inspectionSpecificationVo = (InspectionSpecificationVo)updateInspectionSpecificationMasterMntCbm.Execute(trxContext, updateSpecificationVo); } outVo.AffectedCount = inspectionSpecificationVo.AffectedCount; outVo.InspectionItemId = updateSpecificationVo.InspectionItemId; return(outVo); } if (updateTestInstructionVo != null) { InspectionTestInstructionVo inspectionTestInstructionVo = new InspectionTestInstructionVo(); if (updateTestInstructionVo.DeleteFlag) { //delete inspectiontestinstruction return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo)); } else { //update inspectiontestinstruction inspectionTestInstructionVo = (InspectionTestInstructionVo)updateInspectionTestInstructionMasterMntCbm.Execute(trxContext, updateTestInstructionVo); } outVo.AffectedCount = inspectionTestInstructionVo.AffectedCount; outVo.InspectionItemId = updateTestInstructionVo.InspectionItemId; outVo.InspectionTestInstructionId = updateTestInstructionVo.InspectionTestInstructionId; return(outVo); } if (updateTestInstructionDetailVo != null) { InspectionTestInstructionVo inspectionTestInstructionDetailVo = new InspectionTestInstructionVo(); if (updateTestInstructionDetailVo.DeleteFlag) { //delete inspectiontestinstructiondetail return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo)); } else { //update inspectiontestinstructiondetail inspectionTestInstructionDetailVo = (InspectionTestInstructionVo)updateInspectionTestInstructionDetailMasterMntCbm.Execute(trxContext, updateTestInstructionDetailVo); } outVo.AffectedCount = inspectionTestInstructionDetailVo.AffectedCount; outVo.InspectionTestInstructionId = updateTestInstructionDetailVo.InspectionTestInstructionId; return(outVo); } } } inVo = (InspectionFormatVo)inListVo.GetList()[0]; inVo.InspectionFormatId = inVo.InspectionFormatIdCopy; updateInspectionFormatDeleteFlagMasterMntCbm.Execute(trxContext, inVo); return(copyInspectionFormatMasterMntCbm.Execute(trxContext, vo)); }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { InspectionFormatVo inVo = new InspectionFormatVo(); ValueObjectList <ValueObject> inListVo = (ValueObjectList <ValueObject>)vo; InspectionReturnVo outVo = null; if (inListVo == null && inListVo.GetList() == null && inListVo.GetList().Count == 0) { return(null); } InspectionFormatVo updateFormatVo = (InspectionFormatVo)inListVo.GetList()[0]; InspectionProcessVo updateprocessVo = (InspectionProcessVo)inListVo.GetList()[1]; InspectionItemVo updateitemVo = (InspectionItemVo)inListVo.GetList()[2]; InspectionItemSelectionDatatypeValueVo updateSelectionDataTypeValueVo = (InspectionItemSelectionDatatypeValueVo)inListVo.GetList()[3]; InspectionSpecificationVo updateSpecificationVo = (InspectionSpecificationVo)inListVo.GetList()[4]; InspectionTestInstructionVo updateTestInstructionVo = (InspectionTestInstructionVo)inListVo.GetList()[5]; InspectionTestInstructionVo updateTestInstructionDetailVo = (InspectionTestInstructionVo)inListVo.GetList()[6]; outVo = new InspectionReturnVo(); if (updateprocessVo != null && updateprocessVo.DeleteFlag) { InspectionProcessVo inspectionProcessVo = new InspectionProcessVo(); //delete inspectionprocess inspectionProcessVo = (InspectionProcessVo)deleteInspectionProcessMasterMntCbm.Execute(trxContext, updateprocessVo); InspectionItemVo InItemVo = new InspectionItemVo(); InItemVo.InspectionProcessId = updateprocessVo.InspectionProcessId; //get inspection item id ValueObjectList <InspectionItemVo> InspectionItemVo = (ValueObjectList <InspectionItemVo>)getInspectionItemMasterCbm.Execute(trxContext, InItemVo); if (InspectionItemVo == null || InspectionItemVo.GetList() == null || InspectionItemVo.GetList().Count == 0) { outVo.AffectedCount = inspectionProcessVo.AffectedCount; outVo.InspectionFormatId = updateFormatVo.InspectionFormatIdCopy; return(outVo); } foreach (InspectionItemVo getitemVo in InspectionItemVo.GetList()) { InspectionItemSelectionDatatypeValueVo deleteInspectionItemSelectionDatatypeValueVo = new InspectionItemSelectionDatatypeValueVo(); deleteInspectionItemSelectionDatatypeValueVo.InspectionItemId = getitemVo.InspectionItemId; //delete inspectionitemselectionvalue UpdateResultVo inspectionItemSelectionDatatypeValueVo = (UpdateResultVo)deleteInspectionItemSelectionDatatypeValueCbm.Execute(trxContext, deleteInspectionItemSelectionDatatypeValueVo); InspectionSpecificationVo deleteSpecInVo = new InspectionSpecificationVo(); deleteSpecInVo.InspectionItemId = getitemVo.InspectionItemId; //delete inspectionspecification InspectionSpecificationVo inspectionSpecificationVo = (InspectionSpecificationVo)deleteInspectionSpecificationMasterMntCbm.Execute(trxContext, deleteSpecInVo); InspectionTestInstructionVo inTestVo = new InspectionTestInstructionVo(); inTestVo.InspectionItemId = getitemVo.InspectionItemId; //get inspectiontestinstruction id ValueObjectList <InspectionTestInstructionVo> inspectionTestInstructionVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionMasterMntCbm.Execute(trxContext, inTestVo); if (inspectionTestInstructionVo != null && inspectionTestInstructionVo.GetList() != null && inspectionTestInstructionVo.GetList().Count > 0) { //delete inspectiontestinstruction InspectionTestInstructionVo deleteInspectionTestInstructionVo = (InspectionTestInstructionVo)deleteInspectionTestInstructionMasterMntNewCbm.Execute(trxContext, inspectionTestInstructionVo.GetList()[0]); } //delete inspectionitem InspectionItemVo deleteinspectionItemVo = (InspectionItemVo)deleteInspectionItemMasterMntCbm.Execute(trxContext, getitemVo); } outVo.AffectedCount = inspectionProcessVo.AffectedCount; outVo.InspectionFormatId = updateFormatVo.InspectionFormatIdCopy; return(outVo); } else if (updateitemVo != null && updateitemVo.DeleteFlag) { InspectionItemSelectionDatatypeValueVo deleteInspectionItemSelectionDatatypeValueVo = new InspectionItemSelectionDatatypeValueVo(); deleteInspectionItemSelectionDatatypeValueVo.InspectionItemId = updateitemVo.InspectionItemId; //delete inspectionitemselectionvalue UpdateResultVo inspectionItemSelectionDatatypeValueVo = (UpdateResultVo)deleteInspectionItemSelectionDatatypeValueCbm.Execute(trxContext, deleteInspectionItemSelectionDatatypeValueVo); InspectionSpecificationVo deleteSpecInVo = new InspectionSpecificationVo(); deleteSpecInVo.InspectionItemId = updateitemVo.InspectionItemId; //delete inspectionspecification InspectionSpecificationVo inspectionSpecificationVo = (InspectionSpecificationVo)deleteInspectionSpecificationMasterMntCbm.Execute(trxContext, deleteSpecInVo); InspectionTestInstructionVo inTestVo = new InspectionTestInstructionVo(); inTestVo.InspectionItemId = updateitemVo.InspectionItemId; //get inspectiontestinstruction id ValueObjectList <InspectionTestInstructionVo> inspectionTestInstructionVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionMasterMntCbm.Execute(trxContext, inTestVo); if (inspectionTestInstructionVo != null && inspectionTestInstructionVo.GetList() != null && inspectionTestInstructionVo.GetList().Count > 0) { //delete inspectiontestinstruction InspectionTestInstructionVo deleteInspectionTestInstructionVo = (InspectionTestInstructionVo)deleteInspectionTestInstructionMasterMntNewCbm.Execute(trxContext, inspectionTestInstructionVo.GetList()[0]); } //delete inspectionitem InspectionItemVo deleteinspectionItemVo = (InspectionItemVo)deleteInspectionItemMasterMntCbm.Execute(trxContext, updateitemVo); outVo.AffectedCount = deleteinspectionItemVo.AffectedCount; outVo.InspectionProcessId = updateitemVo.InspectionProcessId; return(outVo); } else if (updateSelectionDataTypeValueVo != null && updateSelectionDataTypeValueVo.DeleteFlag) { //delete inspectionitemselectionvalue UpdateResultVo inspectionItemSelectionDatatypeValueVo = (UpdateResultVo)deleteInspectionItemSelectionDatatypeValueCbm.Execute(trxContext, updateSelectionDataTypeValueVo); outVo.AffectedCount = inspectionItemSelectionDatatypeValueVo.AffectedCount; outVo.InspectionItemId = updateSelectionDataTypeValueVo.InspectionItemId; return(outVo); } else if (updateSpecificationVo != null && updateSpecificationVo.DeleteFlag) { //delete inspectionspecification InspectionSpecificationVo deleteinspectionSpecificationVo = (InspectionSpecificationVo)deleteInspectionSpecificationMasterMntCbm.Execute(trxContext, updateSpecificationVo); outVo.AffectedCount = deleteinspectionSpecificationVo.AffectedCount; outVo.InspectionItemId = updateSpecificationVo.InspectionItemId; return(outVo); } else if (updateTestInstructionVo != null && updateTestInstructionVo.DeleteFlag) { //delete inspectiontestinstruction InspectionTestInstructionVo deleteinspectionTestInstructionVo = (InspectionTestInstructionVo)deleteInspectionTestInstructionMasterMntNewCbm.Execute(trxContext, updateTestInstructionVo); outVo.AffectedCount = deleteinspectionTestInstructionVo.AffectedCount; outVo.InspectionItemId = updateTestInstructionVo.InspectionItemId; outVo.InspectionTestInstructionId = updateTestInstructionVo.InspectionTestInstructionId; return(outVo); } else if (updateTestInstructionDetailVo != null && updateTestInstructionDetailVo.DeleteFlag) { //delete inspectiontestinstructiondetail InspectionTestInstructionVo deleteInspectionTestInstructionDetailVo = (InspectionTestInstructionVo)deleteInspectionTestInstructionDetailMasterMntCbm.Execute(trxContext, updateTestInstructionDetailVo); outVo.AffectedCount = deleteInspectionTestInstructionDetailVo.AffectedCount; outVo.InspectionTestInstructionId = updateTestInstructionDetailVo.InspectionTestInstructionId; return(outVo); } return(outVo); }