private void Detail_btn_Click(object sender, EventArgs e) { if (InspectionTestInstructionId <= 0) { messageData = new MessageData("mmce00010", Properties.Resources.mmce00010, "InspectionTestInstructionId"); popUpMessage.Warning(messageData, Text); return; } //updateData InspectionTestInstructionVo inVo = new InspectionTestInstructionVo(); inVo.InspectionTestInstructionId = InspectionTestInstructionId; inVo.InspectionTestInstructionText = InspectionTestInstructionText_txt.Text.Trim(); inVo.InspectionTestInstructionCode = InspectionTestInstructionCode; InspectionTestInstructionDetailForm frm = new GlobalMasterMaintenance.InspectionTestInstructionDetailForm(inVo); frm.ShowDialog(); if (frm.InspectionTestInstructionId > 0) { InspectionFormatProcessBuzzLogic getprocessid = new InspectionFormatProcessBuzzLogic(); InspectionReturnVo invo = new InspectionReturnVo(); invo.InspectionTestInstructionId = frm.InspectionTestInstructionId; InspectionTestInstructionId = frm.InspectionTestInstructionId; InspectionReturnVo getInspectionVo = getprocessid.RefreshAllFormGrid(invo); if (getInspectionVo != null && getInspectionVo.InspectionItemId > 0) { InspectionItemId = getInspectionVo.InspectionItemId; updateData.InspectionItemId = InspectionItemId; //FormDatatableFromVo(); //ComboBind(InspectionItem_cmb, inspectionitemDatatable, "Name", "Id"); //InspectionItem_cmb.SelectedValue = InspectionItemId; } } }
private void InspectionTestInstruction_btn_Click(object sender, EventArgs e) { int selectedrowindex = InspectionItem_dgv.SelectedCells[0].RowIndex; InspectionItemVo InspectionAddVo = (InspectionItemVo)InspectionItem_dgv.Rows[selectedrowindex].DataBoundItem; InspectionTestInstructionVo inVo = new InspectionTestInstructionVo(); inVo.InspectionTestInstructionId = InspectionAddVo.InspectionTestInstructionId; inVo.InspectionTestInstructionCode = InspectionAddVo.InspectionTestInstructionCode; inVo.InspectionItemId = InspectionAddVo.InspectionItemId; inVo.InspectionItemCode = InspectionAddVo.InspectionItemCode; inVo.InspectionItemName = InspectionAddVo.InspectionItemName; AddInspectionTestInstructionForItemForm newAddForm = new AddInspectionTestInstructionForItemForm(CommonConstants.MODE_ADD, inVo); newAddForm.InspectionProcessId = InspectionProcessId; newAddForm.ShowDialog(); if (newAddForm.InspectionItemId > 0) { InspectionFormatProcessBuzzLogic getprocessid = new InspectionFormatProcessBuzzLogic(); InspectionReturnVo invo = new InspectionReturnVo(); invo.InspectionItemId = newAddForm.InspectionItemId; InspectionReturnVo getInspectionVo = getprocessid.RefreshAllFormGrid(invo); if (getInspectionVo != null && getInspectionVo.InspectionProcessId > 0) { InspectionProcessId = getInspectionVo.InspectionProcessId; //LoadInspectionProcessCombo(); //InspectionProcess_cmb.SelectedValue = InspectionProcessId; } } GridBind(); if (InspectionItem_dgv.Rows.Count > 0 && InspectionItem_dgv.Columns.Count > 0 && InspectionItem_dgv.Columns["ColInspectionItemId"] != null) { int searchItemId; if (newAddForm.InspectionItemId > 0) { searchItemId = newAddForm.InspectionItemId; } else { searchItemId = InspectionAddVo.InspectionItemId; } DataGridViewRow row = InspectionItem_dgv.Rows .Cast <DataGridViewRow>() .FirstOrDefault(r => r.Cells["ColInspectionItemId"].Value.ToString().Equals(searchItemId.ToString())); if (row == null) { return; } InspectionItem_dgv.Rows[row.Index].Selected = true; InspectionItem_dgv_CellClick(sender, new DataGridViewCellEventArgs(0, row.Index)); InspectionItem_dgv.FirstDisplayedScrollingRowIndex = row.Index; } }
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> /// To get the Format Id based on Process id /// </summary> /// <param name="inspectionprocessid"></param> /// <returns></returns> public InspectionReturnVo RefreshAllFormGrid(InspectionReturnVo inVo) { InspectionReturnVo outVo = null; try { outVo = (InspectionReturnVo)DefaultCbmInvoker.Invoke(new GetAllInspectionIDMasterMntCbm(), inVo); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), null); logger.Error(exception.GetMessageData()); } return(outVo); }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ValueObjectList <ValueObject> inListVo = (ValueObjectList <ValueObject>)vo; InspectionReturnVo outVo = null; if (inListVo == null && inListVo.GetList() == null && inListVo.GetList().Count < 7) { return(outVo); } 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]; //Initialize Vo for Get the new inserted Result ValueObjectList <ValueObjectList <ValueObject> > inspectionProcessListInVo = null; ValueObjectList <ValueObjectList <ValueObject> > inspectionItemListInVo = null; // Only For Process Copy if (updateprocessVo != null && updateprocessVo.InspectionProcessIdCopy > 0) { //Insert inspection process master data inspectionProcessListInVo = (ValueObjectList <ValueObjectList <ValueObject> >)copyInspectionProcessFromProcessMasterMntCbm.Execute(trxContext, updateprocessVo); if (inspectionProcessListInVo != null) { outVo = new InspectionReturnVo(); outVo.InspectionFormatId = updateprocessVo.InspectionFormatId; foreach (ValueObjectList <ValueObject> getProcessVo in inspectionProcessListInVo.GetList()) { outVo.InspectionProcessId = ((InspectionProcessVo)getProcessVo.GetList()[1]).InspectionProcessId; outVo.AffectedCount = ((InspectionProcessVo)getProcessVo.GetList()[1]).InspectionProcessId; } } } else if (updateitemVo != null && updateitemVo.InspectionItemIdCopy > 0) // Only For Item Copy { //Insert inspection item master data inspectionItemListInVo = (ValueObjectList <ValueObjectList <ValueObject> >)copyInspectionItemFromItemMasterMntCbm.Execute(trxContext, updateitemVo); if (inspectionItemListInVo != null) { outVo = new InspectionReturnVo(); outVo.InspectionProcessId = updateitemVo.InspectionProcessId; foreach (ValueObjectList <ValueObject> getItemVo in inspectionItemListInVo.GetList()) { outVo.InspectionItemId = ((InspectionItemVo)getItemVo.GetList()[1]).InspectionItemId; outVo.AffectedCount = ((InspectionItemVo)getItemVo.GetList()[1]).InspectionItemId; } } } else //Format Copy ,update, delete { //add inspectionformat based on the copied format InspectionFormatVo inspectionFormatVo = (InspectionFormatVo)addInspectionFormatAndItemLineFormatCbm.Execute(trxContext, updateFormatVo); //if inspectionformat data is null return null if (inspectionFormatVo == null) { return(outVo); } outVo = new InspectionReturnVo(); outVo.AffectedCount = 1; outVo.InspectionFormatId = inspectionFormatVo.InspectionFormatId; //To get the Process Details based on the Copied format id inspectionFormatVo.InspectionFormatIdCopy = updateFormatVo.InspectionFormatIdCopy; // To pass the parameter to get and update the Inspection Process ValueObjectList <ValueObject> inVo = new ValueObjectList <ValueObject>(); inVo.add(inspectionFormatVo); inVo.add(updateprocessVo); //Insert inspection process master data inspectionProcessListInVo = (ValueObjectList <ValueObjectList <ValueObject> >)copyInspectionProcessMasterMntCbm.Execute(trxContext, inVo); } if (inspectionItemListInVo == null) { if (inspectionProcessListInVo == null || inspectionProcessListInVo.GetList() == null || inspectionProcessListInVo.GetList().Count == 0) { return(outVo); } if (outVo == null) { outVo = new InspectionReturnVo(); outVo.AffectedCount = 1; } if (updateprocessVo != null && updateprocessVo.InspectionProcessIdCopy == 0) { InspectionProcessVo returnProcessVo = (InspectionProcessVo)inspectionProcessListInVo.GetList()[inspectionProcessListInVo.GetList().Count - 1].GetList()[0]; if (returnProcessVo != null) { outVo.InspectionFormatId = returnProcessVo.InspectionFormatId; outVo.InspectionProcessId = returnProcessVo.InspectionProcessId; } //To Remove the ReturnVo inspectionProcessListInVo.GetList().RemoveAt(inspectionProcessListInVo.GetList().Count - 1); } // To pass the parameter to get and update the Inspection Item ValueObjectList <ValueObject> updateitemVoList = new ValueObjectList <ValueObject>(); updateitemVoList.add(updateitemVo); inspectionProcessListInVo.add(updateitemVoList); //Insert inspection Item master data inspectionItemListInVo = (ValueObjectList <ValueObjectList <ValueObject> >)copyInspectionItemMasterMntCbm.Execute(trxContext, inspectionProcessListInVo); if (inspectionItemListInVo == null || inspectionItemListInVo.GetList() == null || inspectionItemListInVo.GetList().Count == 0) { return(outVo); } if (updateitemVo != null) { InspectionItemVo returnItemVo = (InspectionItemVo)inspectionItemListInVo.GetList()[inspectionItemListInVo.GetList().Count - 1].GetList()[0]; if (returnItemVo != null) { outVo.InspectionProcessId = returnItemVo.InspectionProcessId; outVo.InspectionItemId = returnItemVo.InspectionItemId; } //To Remove the ReturnVo inspectionItemListInVo.GetList().RemoveAt(inspectionItemListInVo.GetList().Count - 1); } // To pass the parameter to get and update the Inspection Selection Value ValueObjectList <ValueObject> updateSelectionValueVoList = new ValueObjectList <ValueObject>(); updateSelectionValueVoList.add(updateSelectionDataTypeValueVo); inspectionItemListInVo.add(updateSelectionValueVoList); //Insert inspection Item Selection DataType Value master data InspectionReturnVo returnSelectionVo = (InspectionReturnVo)copyInspectionSelectionDataTypeMasterMntCbm.Execute(trxContext, inspectionItemListInVo); if (updateSelectionDataTypeValueVo != null && returnSelectionVo != null) { outVo.InspectionItemId = returnSelectionVo.InspectionItemId; } } // To pass the parameter to get and update the Inspection Specification ValueObjectList <ValueObject> updateSpecificationVoList = new ValueObjectList <ValueObject>(); updateSpecificationVoList.add(updateSpecificationVo); inspectionItemListInVo.add(updateSpecificationVoList); //Insert inspection Specification master data InspectionReturnVo returnSpecVo = (InspectionReturnVo)copyInspectionSpecificationMasterMntCbm.Execute(trxContext, inspectionItemListInVo); if (updateSpecificationVo != null && returnSpecVo != null) { outVo.InspectionItemId = returnSpecVo.InspectionItemId; } // To pass the parameter to get and update the Inspection Test Instruction ValueObjectList <ValueObject> updateTestInstVoList = new ValueObjectList <ValueObject>(); updateTestInstVoList.add(updateTestInstructionVo); inspectionItemListInVo.add(updateTestInstVoList); //Insert inspection Test Instruction master data ValueObjectList <ValueObjectList <ValueObject> > inspectionTestInstructionOutVo = (ValueObjectList <ValueObjectList <ValueObject> >)copyInspectionTestInstructionMasterMntCbm.Execute(trxContext, inspectionItemListInVo); if (inspectionTestInstructionOutVo == null || inspectionTestInstructionOutVo.GetList() == null || inspectionTestInstructionOutVo.GetList().Count == 0) { return(outVo); } if (updateTestInstructionVo != null) { InspectionTestInstructionVo returnTestInstVo = (InspectionTestInstructionVo)inspectionTestInstructionOutVo.GetList()[inspectionTestInstructionOutVo.GetList().Count - 1].GetList()[0]; if (returnTestInstVo != null) { outVo.InspectionItemId = returnTestInstVo.InspectionItemId; } //To Remove the ReturnVo inspectionTestInstructionOutVo.GetList().RemoveAt(inspectionTestInstructionOutVo.GetList().Count - 1); } // To pass the parameter to get and update the Insepection Test Instruction Details ValueObjectList <ValueObject> updateTestInstDetailVoList = new ValueObjectList <ValueObject>(); updateTestInstDetailVoList.add(updateTestInstructionDetailVo); inspectionTestInstructionOutVo.add(updateTestInstDetailVoList); //Insert inspection Test Instruction detail master data InspectionReturnVo returndetailVo = (InspectionReturnVo)copyInspectionTestInstructionDetailMasterMntCbm.Execute(trxContext, inspectionTestInstructionOutVo); if (updateTestInstructionDetailVo != null && returndetailVo != null) { outVo.InspectionTestInstructionId = returndetailVo.InspectionTestInstructionId; } return(outVo); }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ValueObjectList <ValueObjectList <ValueObject> > inVo = (ValueObjectList <ValueObjectList <ValueObject> >)vo; if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0) { return(outVo); } ValueObjectList <ValueObject> updateSelectionValueListVo = new ValueObjectList <ValueObject>(); UpdateResultVo returnitemSelectionInsertedVo = null; updateSelectionValueListVo = inVo.GetList()[inVo.GetList().Count - 1]; if (updateSelectionValueListVo != null && updateSelectionValueListVo.GetList() != null && updateSelectionValueListVo.GetList().Count > 0) { UpdateSelectionValueVo = new InspectionItemSelectionDatatypeValueVo(); UpdateSelectionValueVo = (InspectionItemSelectionDatatypeValueVo)updateSelectionValueListVo.GetList()[0]; } inVo.GetList().RemoveAt(inVo.GetList().Count - 1); //get inspection Selection Value list for the above fetched itemlist inspectionSelectionValueListInVo = (ValueObjectList <InspectionItemSelectionDatatypeValueVo>)getInspectionSelectionDataTypeListCbm.Execute(trxContext, inVo); if (inspectionSelectionValueListInVo == null || inspectionSelectionValueListInVo.GetList() == null || inspectionSelectionValueListInVo.GetList().Count == 0) { return(outVo); } if (UpdateSelectionValueVo != null && UpdateSelectionValueVo.InspectionItemSelectionDatatypeValueId > 0) { if (UpdateSelectionValueVo.DeleteFlag) { inspectionSelectionValueListInVo.GetList().Remove(inspectionSelectionValueListInVo.GetList().Single(v => v.InspectionItemSelectionDatatypeValueId == UpdateSelectionValueVo.InspectionItemSelectionDatatypeValueId)); } else { foreach (InspectionItemSelectionDatatypeValueVo ItemVo in inspectionSelectionValueListInVo.GetList().Where(v => v.InspectionItemSelectionDatatypeValueId == UpdateSelectionValueVo.InspectionItemSelectionDatatypeValueId)) { ItemVo.InspectionItemSelectionDatatypeValueText = UpdateSelectionValueVo.InspectionItemSelectionDatatypeValueText; ItemVo.DisplayOrder = UpdateSelectionValueVo.DisplayOrder; } } } int returnProcessId = 0; foreach (ValueObjectList <ValueObject> getitemVo in inVo.GetList()) { InspectionItemVo OldInsProcessVo = (InspectionItemVo)getitemVo.GetList()[0]; InspectionItemVo NewInsProcessVo = (InspectionItemVo)getitemVo.GetList()[1]; int ItemSelectionCount = 1; foreach (InspectionItemSelectionDatatypeValueVo itemVo in inspectionSelectionValueListInVo.GetList().Where(v => v.InspectionItemId == OldInsProcessVo.InspectionItemId).Distinct()) { itemVo.InspectionItemId = NewInsProcessVo.InspectionItemId; itemVo.InspectionItemSelectionDatatypeValueCode = NewInsProcessVo.InspectionItemCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.SELECTION_VALUE_CODE.GetValue() + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + ItemSelectionCount; ItemSelectionCount += 1; } if (UpdateSelectionValueVo != null) { if (UpdateSelectionValueVo.InspectionItemId == OldInsProcessVo.InspectionItemId) { UpdateSelectionValueVo.InspectionItemId = NewInsProcessVo.InspectionItemId; returnProcessId = NewInsProcessVo.InspectionProcessId; } } } returnitemSelectionInsertedVo = (UpdateResultVo)addInspectionItemSelectionDatatypeValueCopyCbm.Execute(trxContext, inspectionSelectionValueListInVo); if (UpdateSelectionValueVo != null) { if (outVo == null) { outVo = new InspectionReturnVo(); } outVo.InspectionItemId = UpdateSelectionValueVo.InspectionItemId; outVo.InspectionProcessId = returnProcessId; } return(outVo); }
/// <summary> /// inserts new record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { InspectionItemSelectionDatatypeValueVo inVo = new InspectionItemSelectionDatatypeValueVo(); var sch = StringCheckHelper.GetInstance(); if (CheckMandatory() == true) { inVo.InspectionItemSelectionDatatypeValueText = SelectionDatatypeValueText_txt.Text.Trim(); inVo.DisplayOrder = Convert.ToInt32(InspectionItemDisplayOrder_txt.Text); if (InspectionItem_cmb.SelectedValue != null && InspectionItem_cmb.SelectedIndex >= 0) { inVo.InspectionItemId = Convert.ToInt32(InspectionItem_cmb.SelectedValue.ToString()); } if (updateData != null) { inVo.InspectionItemId = updateData.InspectionItemId; } if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.InspectionItemSelectionDatatypeValueId = updateData.InspectionItemSelectionDatatypeValueId; } inVo.Mode = mode; try { if (string.Equals(mode, CommonConstants.MODE_ADD) || string.Equals(mode, CommonConstants.MODE_SELECT)) { InspectionItemSelectionDatatypeValueVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, SelectionDatatypeValueText_lbl.Text + " : " + SelectionDatatypeValueText_txt.Text); popUpMessage.Information(messageData, Text); return; } InspectionItemSelectionDatatypeValueVo checkDisplayVo = DuplicateDisplayCheck(inVo); if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemDisplayOrder_lbl.Text + " : " + InspectionItemDisplayOrder_txt.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); InspectionItemDisplayOrder_txt.Focus(); return; } inVo.InspectionItemSelectionDatatypeValueCode = InspectionItemCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.SELECTION_VALUE_CODE.GetValue() + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + RunningNumber; UpdateResultVo outVo = (UpdateResultVo)base.InvokeCbm(new AddInspectionItemSelectionDatatypeValueCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { if (SelectionDatatypeValueText_txt.Text == updateData.InspectionItemSelectionDatatypeValueText && updateData.DisplayOrder == Convert.ToInt32(InspectionItemDisplayOrder_txt.Text)) { return; } if (updateData.InspectionItemSelectionDatatypeValueText != SelectionDatatypeValueText_txt.Text) { InspectionItemSelectionDatatypeValueVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, SelectionDatatypeValueText_lbl.Text + " : " + SelectionDatatypeValueText_txt.Text); popUpMessage.Information(messageData, Text); return; } } if (updateData.DisplayOrder != Convert.ToInt32(InspectionItemDisplayOrder_txt.Text)) { InspectionItemSelectionDatatypeValueVo checkDisplayVo = DuplicateDisplayCheck(inVo); if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemDisplayOrder_lbl.Text + " : " + InspectionItemDisplayOrder_txt.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); InspectionItemDisplayOrder_txt.Focus(); return; } } if (updateData == null) { UpdateResultVo outResultVo = (UpdateResultVo)base.InvokeCbm(new UpdateInspectionItemSelectionDatatypeValueCbm(), inVo, false); if (outResultVo == null) { return; } IntSuccess = outResultVo.AffectedCount; } else { string message = string.Format(Properties.Resources.mmci00037, "Inspection Item Selection Datatype Value", SelectionDatatypeValueText_txt.Text); StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); InspectionFormatVo passformatVo = FormFormatVo(updateData.InspectionItemId); if (passformatVo == null || passformatVo.InspectionFormatId == 0) { return; } inVoList.add(passformatVo); inVoList.add(null); inVoList.add(null); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); InspectionReturnVo outVo = null; try { outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { CompleteProgress(); } if (outVo != null && outVo.AffectedCount > 0) { IntSuccess = outVo.AffectedCount; InspectionItemId = outVo.InspectionItemId; InspectionFormatProcessBuzzLogic getprocessid = new InspectionFormatProcessBuzzLogic(); InspectionReturnVo invo = new InspectionReturnVo(); invo.InspectionItemId = outVo.InspectionItemId; InspectionReturnVo getInspectionVo = getprocessid.RefreshAllFormGrid(invo); if (getInspectionVo != null && getInspectionVo.InspectionProcessId > 0) { InspectionProcessId = getInspectionVo.InspectionProcessId; } } } //UpdateInspectionItemSelectionDatatypeValueVo = new InspectionItemSelectionDatatypeValueVo(); //UpdateInspectionItemSelectionDatatypeValueVo = inVo; //this.Close(); } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if ((IntSuccess > 0)) { //messageData = new MessageData("mmci00001", Properties.Resources.mmci00001, null); //logger.Info(messageData); //popUpMessage.Information(messageData, Text); this.Close(); } } }
/// <summary> /// update data to db /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Ok_btn_Click(object sender, EventArgs e) { InspectionFormatVo inVo = new InspectionFormatVo(); if (CheckMandatory()) { if (LineId_cmb.SelectedIndex > -1) { inVo.LineCode = LineId_cmb.SelectedValue.ToString(); inVo.LineId = lineOutVo.GetList().Where(t => t.LineCode == inVo.LineCode).FirstOrDefault().LineId; } //if (ItemId_cmb.SelectedIndex > -1) //{ // inVo.SapItemCode = ItemId_cmb.SelectedValue.ToString(); // // inVo.ItemId = globalItemVo.GlobalItemListVo.Where(t => t.GlobalItemCode == inVo.ItemCode).FirstOrDefault().GlobalItemId; //} if (ItemCode_txt.Text.Trim() != string.Empty) { inVo.SapItemCode = ItemCode_txt.Text; // sapItemGlobalVo.SapItemCode; } string SapitemGroupName = getSapItemGroupId(); if (SapitemGroupName == null) { messageData = new MessageData("mmci00041", Properties.Resources.mmci00041, ItemId_cmb.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } inVo.InspectionFormatCode = SapitemGroupName + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + inVo.SapItemCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + inVo.LineCode; inVo.InspectionFormatName = inVo.InspectionFormatCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + InspectionFormatName_txt.Text.Trim(); if (string.Equals(mode, CommonConstants.MODE_ADD.ToString())) { GlobalMasterMaintenance.Vo.InspectionFormatVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmci00040", Properties.Resources.mmci00040, "ITEM LINE", "FORMAT NAME"); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } } if (string.Equals(mode, CommonConstants.MODE_ADD.ToString())) { if (InspectionFormatId == 0) { GlobalMasterMaintenance.Vo.InspectionFormatVo outVo = null; try { outVo = (InspectionFormatVo)base.InvokeCbm(new AddInspectionFormatAndItemLineFormatCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outVo == null) { return; } IntSuccess = outVo.InspectionFormatId; } else { inVo.InspectionFormatIdCopy = InspectionFormatId; string message = string.Format(Properties.Resources.mmci00042, CopyFormat_txt.Text); base.StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); InspectionReturnVo OutVo = null; try { OutVo = (InspectionReturnVo)base.InvokeCbm(new CopyInspectionFormatMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { CompleteProgress(); } if (OutVo == null) { return; } //IntSuccess = OutVo.AffectedCount; IntSuccess = OutVo.InspectionFormatId; } } else if (string.Equals(mode, CommonConstants.MODE_UPDATE.ToString())) { //if (updateData != null) { inVo.InspectionFormatCode = updateData.InspectionFormatCode; } if (InspectionFormatName_txt.Text.Trim() == updateData.InspectionFormatName.Replace(updateData.InspectionFormatCode.Substring(0, updateData.InspectionFormatCode.Length - 5), "")) { return; } GlobalMasterMaintenance.Vo.InspectionFormatVo checkVo = DuplicateCheckForUpdate(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmci00044", Properties.Resources.mmci00044, InspectionFormatName_txt.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } //inVo.InspectionFormatId = updateData.InspectionFormatId; //inVo.InspectionFormatCode = updateData.InspectionFormatCode; //inVo.InspectionFormatName = inVo.InspectionFormatCode.Substring(0, inVo.InspectionFormatCode.Length - 5) // + InspectionFormatName_txt.Text.Trim(); inVo.InspectionFormatIdCopy = updateData.InspectionFormatId; inVo.Mode = GlobalMasterMaintenance.CommonConstants.MODE_UPDATE; string message = string.Format(Properties.Resources.mmci00043, "Inspection Format", InspectionFormatName_txt.Text); base.StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); InspectionReturnVo outVo = null; try { outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { CompleteProgress(); } if (outVo == null) { return; } //IntSuccess = outVo.AffectedCount; IntSuccess = outVo.InspectionFormatId; } if ((IntSuccess > 0)) { this.Close(); } } }
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)); }
/// <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 = InspectionSelectionValue_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = InspectionSelectionValue_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colInspectionItemSelectionValueText"].Value.ToString()); // Logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { InspectionItemSelectionDatatypeValueVo inVo = new InspectionItemSelectionDatatypeValueVo(); inVo.InspectionItemSelectionDatatypeValueId = Convert.ToInt32(selectedRow.Cells["colInspectionItemSelectionDatatypeValueId"].Value.ToString()); inVo.DeleteFlag = true; if (inspectionItemdata != null) { inVo.InspectionItemId = inspectionItemdata.InspectionItemId; } else { inVo.InspectionItemId = InspectionItemId; } //UpdateInspectionItemSelectionDatatypeValueVo = inVo; //this.Close(); try { UpdateResultVo deleteVo = null; if (inspectionItemdata == null) { deleteVo = (UpdateResultVo)base.InvokeCbm(new DeleteInspectionItemSelectionDatatypeValueCbm(), inVo, false); if (deleteVo == null) { return; } IntSuccess = deleteVo.AffectedCount; if (deleteVo.AffectedCount > 0) { this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); logger.Info(this.messageData); popUpMessage.Information(this.messageData, Text); } else if (deleteVo.AffectedCount == 0) { messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } GridBind(); } else { string message = string.Format(Properties.Resources.mmci00038, "Inspection Item Selection Datatype Value", selectedRow.Cells["colInspectionItemSelectionValueText"].Value.ToString()); StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); InspectionFormatVo passformatVo = FormFormatVo(inspectionItemdata.InspectionItemId); if (passformatVo == null || passformatVo.InspectionFormatId == 0) { return; } inVoList.add(passformatVo); inVoList.add(null); inVoList.add(null); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); InspectionReturnVo outVo = null; try { outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { CompleteProgress(); } if (outVo != null && outVo.AffectedCount > 0) { IntSuccess = outVo.AffectedCount; InspectionItemId = outVo.InspectionItemId; inspectionItemdata.InspectionItemId = outVo.InspectionItemId; InspectionFormatProcessBuzzLogic getprocessid = new InspectionFormatProcessBuzzLogic(); InspectionReturnVo invo = new InspectionReturnVo(); invo.InspectionItemId = outVo.InspectionItemId; InspectionReturnVo getInspectionVo = getprocessid.RefreshAllFormGrid(invo); if (getInspectionVo != null && getInspectionVo.InspectionProcessId > 0) { InspectionProcessId = getInspectionVo.InspectionProcessId; } this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); logger.Info(this.messageData); popUpMessage.Information(this.messageData, Text); GridBind(); } else { messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } //string message = string.Format(Properties.Resources.mmci00038, "Inspection Selection DataType Value", selectedRow.Cells["colInspectionItemSelectionValueText"].Value.ToString()); //StartProgress(message); //ValueObjectList<ValueObject> inVoList = new ValueObjectList<ValueObject>(); //InspectionFormatVo passformatVo = FormFormatVo(inspectionItemdata.InspectionItemId); //if (passformatVo == null || passformatVo.InspectionFormatId == 0) return; //inVoList.add(passformatVo); //inVoList.add(null); //inVoList.add(null); //inVoList.add(inVo); //inVoList.add(null); //inVoList.add(null); //inVoList.add(null); //UpdateResultVo outVo = (UpdateResultVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); //CompleteProgress(); //if (outVo == null) { return; } //try //{ // UpdateResultVo outVo = (UpdateResultVo)base.InvokeCbm(new DeleteInspectionItemSelectionDatatypeValueCbm(), inVo, false); // if (outVo.AffectedCount > 0) // { // this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); // logger.Info(this.messageData); // popUpMessage.Information(this.messageData, Text); // } // else if (outVo.AffectedCount == 0) // { // messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null); // logger.Info(messageData); // popUpMessage.Information(messageData, Text); // } // GridBind(); //} //catch (Framework.ApplicationException exception) //{ // popUpMessage.ApplicationError(exception.GetMessageData(), Text); // logger.Error(exception.GetMessageData()); //} } else if (dialogResult == DialogResult.Cancel) { //do something else } }
/// <summary> /// inserts new record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { InspectionSpecificationVo inVo = new InspectionSpecificationVo(); var sch = StringCheckHelper.GetInstance(); if (!CheckMandatory()) { return; } inVo.InspectionSpecificationText = InspectionSpecificationText_txt.Text.Trim(); if (InspectionItemDataType == Convert.ToInt32(GlobalMasterDataTypeEnum.DATATYPE_DATETIME.GetValue()) && DateTime_pnl.Visible) { inVo.ValueFrom = DateFrom_dtp.Value.ToString(); if (!string.IsNullOrEmpty(DateTo_dtp.Text.Trim())) { inVo.ValueTo = DateTo_dtp.Value.ToString(); } } else { inVo.ValueFrom = ValueFrom_txt.Text; if (!string.IsNullOrWhiteSpace(ValueTo_txt.Text.Trim())) { inVo.ValueTo = ValueTo_txt.Text; } } inVo.Unit = Unit_txt.Text.Trim(); if (Operator_cmb.SelectedIndex > -1) { inVo.OperatorFrom = Operator_cmb.SelectedValue.ToString(); } if (!string.IsNullOrWhiteSpace(OperatorTo_txt.Text.Trim())) { inVo.OperatorTo = GlobalMasterDataTypeEnum.OPERATOR_LESSTHAN.GetValue(); } //inVo.InspectionItemId = Convert.ToInt32(InspectionItem_cmb.SelectedValue.ToString()); inVo.InspectionItemId = InspectionItemId; inVo.SpecificationResultJudgeType = Convert.ToInt32(SpecificationResultJudgeType_cmb.SelectedValue.ToString()); if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.InspectionSpecificationId = inspectionspecificationid; } inVo.Mode = mode; //InspectionSpecificationVo checkVo = DuplicateCheck(inVo); //if (checkVo != null && checkVo.AffectedCount > 0) //{ // messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionSpecificationCode_lbl.Text + " : " + InspectionSpecificationCode_txt.Text + // Environment.NewLine + " OR " + Environment.NewLine + InspectionItem_lbl.Text + " : " + InspectionItem_cmb.Text); // logger.Info(messageData); // popUpMessage.ConfirmationOkCancel(messageData, Text); // return; //} if (string.Equals(mode, CommonConstants.MODE_ADD) || string.Equals(mode, CommonConstants.MODE_SELECT)) { inVo.InspectionSpecificationCode = InspectionItemCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.SPECIFICATION_CODE.GetValue(); UpdateResultVo outVo = null; try { outVo = (UpdateResultVo)base.InvokeCbm(new AddInspectionSpecificationMasterMntCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outVo == null) { return; } IntSuccess = outVo.AffectedCount; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.InspectionSpecificationCode = InspectionSpecificationCode; //InspectionSpecificationVo outVo = (InspectionSpecificationVo)base.InvokeCbm(new UpdateInspectionSpecificationMasterMntCbm(), inVo, false); string message = string.Format(Properties.Resources.mmci00037, "Inspection Specification", InspectionSpecificationText_txt.Text); StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); InspectionFormatVo passformatVo = FormFormatVo(inVo.InspectionItemId); if (passformatVo == null || passformatVo.InspectionFormatId == 0) { return; } inVoList.add(passformatVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); InspectionReturnVo outVo = null; try { outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { CompleteProgress(); } if (outVo != null && outVo.AffectedCount > 0) { IntSuccess = outVo.AffectedCount; InspectionItemId = outVo.InspectionItemId; } } if ((IntSuccess > 0)) { messageData = new MessageData("mmci00001", Properties.Resources.mmci00001, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); this.Close(); } }
/// <summary> /// update data to db /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { var sch = StringCheckHelper.GetInstance(); InspectionItemVo inVo = new InspectionItemVo(); if (CheckMandatory()) { inVo.InspectionItemName = InspectionItemName_txt.Text.Trim(); if (ParentItemCode_cmb.SelectedIndex > -1) { inVo.ParentInspectionItemId = Convert.ToInt32(ParentItemCode_cmb.SelectedValue.ToString()); } //if (InspectionProcess_cmb.SelectedIndex > -1) //{ // inVo.InspectionProcessId = Convert.ToInt32(InspectionProcess_cmb.SelectedValue); //} inVo.InspectionProcessId = updateData.InspectionProcessId; inVo.InspectionItemMandatory = Convert.ToInt32(InspectionItemMandatory_chk.Checked); inVo.InspectionEmployeeMandatory = Convert.ToInt32(InspectionEmployeeMandatory_chk.Checked); inVo.InspectionMachineMandatory = Convert.ToInt32(InspectionMachineMandatory_chk.Checked); inVo.InspectionItemDataType = Convert.ToInt32(InspectionItemDataType_cmb.SelectedValue); inVo.DisplayOrder = Convert.ToInt32(InspectionItemDisplayOrder_txt.Text); if (!string.IsNullOrEmpty(ResultItemDecimalDigits_txt.Text)) { inVo.InspectionResultItemDecimalDigits = Convert.ToInt32(ResultItemDecimalDigits_txt.Text); } if (string.Equals(mode, CommonConstants.MODE_ADD)) { InspectionItemVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemName_lbl.Text + " : " + InspectionItemName_txt.Text); popUpMessage.Information(messageData, Text); return; } InspectionItemVo checkDisplayVo = DuplicateDisplayCheck(inVo); if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemDisplayOrder_lbl.Text + " : " + InspectionItemDisplayOrder_txt.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); InspectionItemDisplayOrder_txt.Focus(); return; } } else if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { if (updateData.InspectionItemName != InspectionItemName_txt.Text) { InspectionItemVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemName_lbl.Text + " : " + InspectionItemName_txt.Text); popUpMessage.Information(messageData, Text); return; } } if (updateData.DisplayOrder != Convert.ToInt32(InspectionItemDisplayOrder_txt.Text)) { InspectionItemVo checkDisplayVo = DuplicateDisplayCheck(inVo); if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemDisplayOrder_lbl.Text + " : " + InspectionItemDisplayOrder_txt.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); InspectionItemDisplayOrder_txt.Focus(); return; } } } if (string.Equals(mode, CommonConstants.MODE_ADD)) { inVo.InspectionItemCode = InspectionItemCode; if (InspectionItemCopyId == 0) { InspectionItemVo outVo = null; try { outVo = (InspectionItemVo)base.InvokeCbm(new AddInspectionItemMasterMntCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outVo == null && outVo.InspectionItemId == 0) { return; } IntSuccess = outVo.InspectionItemId; // if (InspectionItemDataType_cmb.SelectedIndex > -1 && InspectionItemDataType_cmb.SelectedValue.ToString() == GlobalMasterDataTypeEnum.DATATYPE_SELECTION.GetValue().ToString()) { InspectionItemSelectionDatatypeValueVo inspectionItemSelectionDatatypeValueVo = new InspectionItemSelectionDatatypeValueVo(); inspectionItemSelectionDatatypeValueVo.InspectionItemCode = InspectionItemCode; inspectionItemSelectionDatatypeValueVo.InspectionItemId = outVo.InspectionItemId; try { UpdateResultVo updateResultVo = (UpdateResultVo)base.InvokeCbm(new UpdateInspectionItemIdForSelectionValueCbm(), inspectionItemSelectionDatatypeValueVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } } } else { inVo.InspectionItemIdCopy = InspectionItemCopyId; //InspectionFormatVo getformatvo = inspectionFormatOutVo.GetList().Where(t => t.InspectionFormatId == inVo.InspectionFormatId).FirstOrDefault(); //if (getformatvo == null) return; if (!CheckDataExist(InspectionItemCopyId)) { messageData = new MessageData("mmci00048", Properties.Resources.mmci00048.ToString(), CopyItem_txt.Text); logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult != DialogResult.OK) { return; } } string message = string.Format(Properties.Resources.mmci00045, CopyItem_txt.Text); base.StartProgress(message); inVo.InspectionProcessCode = updateData.InspectionProcessCode; // getformatvo.InspectionFormatCode; //inVo.SequenceNo = RunningNumber; ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); inVoList.add(null); inVoList.add(null); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); InspectionReturnVo OutVo = null; try { OutVo = (InspectionReturnVo)base.InvokeCbm(new CopyInspectionItemFromItemAllCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { CompleteProgress(); } if (OutVo != null && OutVo.AffectedCount > 0) { IntSuccess = OutVo.InspectionItemId; ReturnProcessId = OutVo.InspectionProcessId; is_Copied = true; } } } else if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { inVo.InspectionItemId = updateData.InspectionItemId; string message = string.Format(Properties.Resources.mmci00037, "Inspection Item", InspectionItemName_txt.Text); StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); InspectionFormatVo passformatVo = FormFormatVo(updateData.InspectionItemId); if (passformatVo == null || passformatVo.InspectionFormatId == 0) { return; } inVoList.add(passformatVo); inVoList.add(null); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); InspectionReturnVo outVo = null; try { outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { CompleteProgress(); } if (outVo != null && outVo.AffectedCount > 0) { IntSuccess = outVo.InspectionItemId; ReturnProcessId = outVo.InspectionProcessId; } //InspectionItemVo outVo = (InspectionItemVo)base.InvokeCbm(new UpdateInspectionItemMasterMntCbm(), inVo, false); } if (IntSuccess > 0) { this.Close(); } } }
/// <summary> /// inserts new record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { InspectionTestInstructionVo inVo = new InspectionTestInstructionVo(); var sch = StringCheckHelper.GetInstance(); if (!CheckMandatory()) { return; } inVo.InspectionTestInstructionText = InspectionTestInstructionText_txt.Text.Trim(); //inVo.InspectionItemId = Convert.ToInt32(InspectionItem_cmb.SelectedValue.ToString()); inVo.InspectionItemId = updateData.InspectionItemId; inVo.Mode = mode; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { inVo.InspectionTestInstructionId = InspectionTestInstructionId; } //InspectionTestInstructionVo checkVo = DuplicateCheck(inVo); //if (checkVo != null && checkVo.AffectedCount > 0) //{ // messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionTestInstructionCode_lbl.Text + " : " + InspectionTestInstructionCode_txt.Text + // Environment.NewLine + " OR " + Environment.NewLine + InspectionItem_lbl.Text + " : " + InspectionItem_cmb.Text); // logger.Info(messageData); // popUpMessage.ConfirmationOkCancel(messageData, Text); // return; //} if (string.Equals(mode, CommonConstants.MODE_ADD)) { InspectionTestInstructionCode = updateData.InspectionItemCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.TEST_INST_CODE.GetValue(); inVo.InspectionTestInstructionCode = InspectionTestInstructionCode; InspectionTestInstructionVo outVo = null; try { outVo = (InspectionTestInstructionVo)base.InvokeCbm(new AddInspectionTestInstructionMasterMntCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outVo == null) { return; } IntSuccess = outVo.InspectionTestInstructionId; InspectionTestInstructionId = outVo.InspectionTestInstructionId; mode = CommonConstants.MODE_UPDATE; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { inVo.InspectionTestInstructionCode = InspectionTestInstructionCode; // InspectionTestInstructionVo outVo = (InspectionTestInstructionVo)base.InvokeCbm(new UpdateInspectionTestInstructionMasterMntCbm(), inVo, false); string message = string.Format(Properties.Resources.mmci00037, "Inspection Test Instruction", InspectionTestInstructionText_txt.Text); StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); InspectionFormatVo passformatVo = FormFormatVo(inVo.InspectionItemId); if (passformatVo == null || passformatVo.InspectionFormatId == 0) { return; } inVoList.add(passformatVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(inVo); inVoList.add(null); InspectionReturnVo outVo = null; try { outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { CompleteProgress(); } if (outVo != null && outVo.AffectedCount > 0) { IntSuccess = outVo.AffectedCount; InspectionItemId = outVo.InspectionItemId; updateData.InspectionItemId = InspectionItemId; InspectionTestInstructionId = outVo.InspectionTestInstructionId; //FormDatatableFromVo(); //ComboBind(InspectionItem_cmb, inspectionitemDatatable, "Name", "Id"); //InspectionItem_cmb.SelectedValue = InspectionItemId; } } if ((IntSuccess > 0)) { messageData = new MessageData("mmci00001", Properties.Resources.mmci00001, null); popUpMessage.Information(messageData, Text); Detail_btn.Enabled = delete_btn.Enabled = true; } }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ValueObjectList <ValueObjectList <ValueObject> > inVo = (ValueObjectList <ValueObjectList <ValueObject> >)vo; if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0) { return(outVo); } ValueObjectList <ValueObject> updateSpecificationListVo = new ValueObjectList <ValueObject>(); UpdateResultVo returnitemSpecificationInsertedVo = null; updateSpecificationListVo = inVo.GetList()[inVo.GetList().Count - 1]; if (updateSpecificationListVo != null && updateSpecificationListVo.GetList() != null && updateSpecificationListVo.GetList().Count > 0) { UpdateSpecificationVo = new InspectionSpecificationVo(); UpdateSpecificationVo = (InspectionSpecificationVo)updateSpecificationListVo.GetList()[0]; } inVo.GetList().RemoveAt(inVo.GetList().Count - 1); //get inspection Specification list for the above fetched itemlist InspectionSpecificationListInVo = (ValueObjectList <InspectionSpecificationVo>)getInspectionSpecficationListCbm.Execute(trxContext, inVo); if (InspectionSpecificationListInVo == null || InspectionSpecificationListInVo.GetList() == null || InspectionSpecificationListInVo.GetList().Count == 0) { return(outVo); } if (UpdateSpecificationVo != null && UpdateSpecificationVo.InspectionSpecificationId > 0) { if (UpdateSpecificationVo.DeleteFlag) { InspectionSpecificationListInVo.GetList().Remove(InspectionSpecificationListInVo.GetList().Single(v => v.InspectionSpecificationId == UpdateSpecificationVo.InspectionSpecificationId)); } else { foreach (InspectionSpecificationVo ItemVo in InspectionSpecificationListInVo.GetList().Where(v => v.InspectionSpecificationId == UpdateSpecificationVo.InspectionSpecificationId)) { ItemVo.InspectionSpecificationCode = UpdateSpecificationVo.InspectionSpecificationCode; ItemVo.InspectionSpecificationText = UpdateSpecificationVo.InspectionSpecificationText; ItemVo.ValueFrom = UpdateSpecificationVo.ValueFrom; ItemVo.ValueTo = UpdateSpecificationVo.ValueTo; ItemVo.Unit = UpdateSpecificationVo.Unit; ItemVo.OperatorFrom = UpdateSpecificationVo.OperatorFrom; ItemVo.OperatorTo = UpdateSpecificationVo.OperatorTo; ItemVo.InspectionItemId = UpdateSpecificationVo.InspectionItemId; ItemVo.SpecificationResultJudgeType = UpdateSpecificationVo.SpecificationResultJudgeType; } } } foreach (ValueObjectList <ValueObject> getitemVo in inVo.GetList()) { InspectionItemVo OldInsProcessVo = (InspectionItemVo)getitemVo.GetList()[0]; InspectionItemVo NewInsProcessVo = (InspectionItemVo)getitemVo.GetList()[1]; foreach (InspectionSpecificationVo inspectionSpecificationVo in InspectionSpecificationListInVo.GetList().Where(v => v.InspectionItemId == OldInsProcessVo.InspectionItemId).Distinct()) { inspectionSpecificationVo.InspectionItemId = NewInsProcessVo.InspectionItemId; inspectionSpecificationVo.InspectionSpecificationCode = NewInsProcessVo.InspectionItemCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.SPECIFICATION_CODE.GetValue(); } if (UpdateSpecificationVo != null) { if (UpdateSpecificationVo.InspectionItemId == OldInsProcessVo.InspectionItemId) { UpdateSpecificationVo.InspectionItemId = NewInsProcessVo.InspectionItemId; } } } returnitemSpecificationInsertedVo = (UpdateResultVo)addInspectionSpecificationCopyCbm.Execute(trxContext, InspectionSpecificationListInVo); if (UpdateSpecificationVo != null) { if (outVo == null) { outVo = new InspectionReturnVo(); } outVo.InspectionItemId = UpdateSpecificationVo.InspectionItemId; } return(outVo); }
/// <summary> /// inserts new record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { InspectionProcessVo inVo = new InspectionProcessVo(); var sch = StringCheckHelper.GetInstance(); if (!CheckMandatory()) { return; } inVo.InspectionProcessName = InspectionProcessName_txt.Text.Trim(); inVo.InspectionFormatId = updateData.InspectionFormatId; // Convert.ToInt32(InspectionFormat_cmb.SelectedValue.ToString()); inVo.DisplayOrder = Convert.ToInt32(InspectionProcessDisplayOrder_txt.Text); if (string.Equals(mode, CommonConstants.MODE_ADD)) { InspectionProcessVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionProcessName_lbl.Text + " : " + InspectionProcessName_txt.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } InspectionProcessVo checkDisplayVo = DuplicateDisplayCheck(inVo); if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionProcessDisplayOrder_lbl.Text + " : " + InspectionProcessDisplayOrder_txt.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); InspectionProcessDisplayOrder_txt.Focus(); return; } if (InspectionprocessId == 0) { inVo.InspectionProcessCode = updateData.InspectionFormatCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.PROCESS_CODE.GetValue() + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + RunningNumber; InspectionProcessVo outVo = null; try { outVo = (InspectionProcessVo)base.InvokeCbm(new AddInspectionProcessMasterMntCbm(), inVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if (outVo == null) { return; } IntSuccess = outVo.InspectionProcessId; } else { inVo.InspectionProcessIdCopy = InspectionprocessId; //InspectionFormatVo getformatvo = inspectionFormatOutVo.GetList().Where(t => t.InspectionFormatId == inVo.InspectionFormatId).FirstOrDefault(); //if (getformatvo == null) return; string message = string.Format(Properties.Resources.mmci00036, CopyProcess_txt.Text); base.StartProgress(message); inVo.InspectionFormatCode = updateData.InspectionFormatCode; // getformatvo.InspectionFormatCode; inVo.SequenceNo = RunningNumber; ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); inVoList.add(null); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); InspectionReturnVo OutVo = null; try { OutVo = (InspectionReturnVo)base.InvokeCbm(new CopyInspectionFormatMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { CompleteProgress(); } if (OutVo != null && OutVo.AffectedCount > 0) { IntSuccess = OutVo.InspectionProcessId; ReturnFormatId = OutVo.InspectionFormatId; } } } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { if (InspectionProcessName_txt.Text == updateData.InspectionProcessName && InspectionProcessDisplayOrder_txt.Text == updateData.DisplayOrder.ToString()) { return; } if (InspectionProcessName_txt.Text != updateData.InspectionProcessName) { InspectionProcessVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionProcessName_lbl.Text + " : " + InspectionProcessName_txt.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } } if (InspectionProcessDisplayOrder_txt.Text != updateData.DisplayOrder.ToString()) { InspectionProcessVo checkDisplayVo = DuplicateDisplayCheck(inVo); if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionProcessDisplayOrder_lbl.Text + " : " + InspectionProcessDisplayOrder_txt.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); InspectionProcessDisplayOrder_txt.Focus(); return; } } inVo.InspectionProcessId = updateData.InspectionProcessId; inVo.InspectionProcessCode = updateData.InspectionProcessCode; string message = string.Format(Properties.Resources.mmci00037, "Inspection Process", InspectionProcessName_txt.Text); StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); InspectionFormatVo passformatVo = FormFormatVo(updateData.InspectionProcessId); if (passformatVo == null || passformatVo.InspectionFormatId == 0) { return; } inVoList.add(passformatVo); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); InspectionReturnVo outVo = null; try { outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } finally { CompleteProgress(); } if (outVo != null && outVo.AffectedCount > 0) { IntSuccess = outVo.InspectionProcessId; ReturnFormatId = outVo.InspectionFormatId; } } if (IntSuccess > 0) { this.Close(); } }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ValueObjectList <ValueObjectList <ValueObject> > inVo = (ValueObjectList <ValueObjectList <ValueObject> >)vo; if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0) { return(outVo); } ValueObjectList <ValueObject> UpdateInstTestDetailListVo = new ValueObjectList <ValueObject>(); UpdateResultVo returnInstTestDetailInsertedVo = null; UpdateInstTestDetailListVo = inVo.GetList()[inVo.GetList().Count - 1]; if (UpdateInstTestDetailListVo != null && UpdateInstTestDetailListVo.GetList() != null && UpdateInstTestDetailListVo.GetList().Count > 0) { UpdateTestInstDetailVo = new InspectionTestInstructionVo(); UpdateTestInstDetailVo = (InspectionTestInstructionVo)UpdateInstTestDetailListVo.GetList()[0]; } inVo.GetList().RemoveAt(inVo.GetList().Count - 1); //get inspection Selection Value list for the above fetched itemlist inspectionTestInstructionListInVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionDetailCbm.Execute(trxContext, inVo); if (inspectionTestInstructionListInVo == null || inspectionTestInstructionListInVo.GetList() == null || inspectionTestInstructionListInVo.GetList().Count == 0) { return(outVo); } if (UpdateTestInstDetailVo != null && UpdateTestInstDetailVo.InspectionTestInstructionDetailId > 0) { if (UpdateTestInstDetailVo.DeleteFlag) { inspectionTestInstructionListInVo.GetList().Remove(inspectionTestInstructionListInVo.GetList().Single(v => v.InspectionTestInstructionDetailId == UpdateTestInstDetailVo.InspectionTestInstructionDetailId)); } else { foreach (InspectionTestInstructionVo ItemVo in inspectionTestInstructionListInVo.GetList().Where(v => v.InspectionTestInstructionDetailId == UpdateTestInstDetailVo.InspectionTestInstructionDetailId)) { ItemVo.InspectionTestInstructionDetailCode = UpdateTestInstDetailVo.InspectionTestInstructionDetailCode; ItemVo.InspectionTestInstructionDetailText = UpdateTestInstDetailVo.InspectionTestInstructionDetailText; ItemVo.InspectionTestInstructionDetailResultCount = UpdateTestInstDetailVo.InspectionTestInstructionDetailResultCount; ItemVo.InspectionTestInstructionDetailMachine = UpdateTestInstDetailVo.InspectionTestInstructionDetailMachine; } } } foreach (ValueObjectList <ValueObject> getTestInstructionVo in inVo.GetList()) { InspectionTestInstructionVo OldTestInstVo = (InspectionTestInstructionVo)getTestInstructionVo.GetList()[0]; InspectionTestInstructionVo NewTestInstVo = (InspectionTestInstructionVo)getTestInstructionVo.GetList()[1]; int InspTestInstructionDetailCount = 1; foreach (InspectionTestInstructionVo inspectionTestInstructionVo in inspectionTestInstructionListInVo.GetList().Where(v => v.InspectionTestInstructionId == OldTestInstVo.InspectionTestInstructionId).Distinct()) { inspectionTestInstructionVo.InspectionTestInstructionId = NewTestInstVo.InspectionTestInstructionId; inspectionTestInstructionVo.InspectionTestInstructionDetailCode = NewTestInstVo.InspectionTestInstructionCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.DETAIL_CODE.GetValue() + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + InspTestInstructionDetailCount; InspTestInstructionDetailCount += 1; } if (UpdateTestInstDetailVo != null) { if (UpdateTestInstDetailVo.InspectionTestInstructionId == OldTestInstVo.InspectionTestInstructionId) { UpdateTestInstDetailVo.InspectionTestInstructionId = NewTestInstVo.InspectionTestInstructionId; } } } returnInstTestDetailInsertedVo = (UpdateResultVo)addInspectionTestInstructionDetailCopyCbm.Execute(trxContext, inspectionTestInstructionListInVo); if (UpdateTestInstDetailVo != null) { if (outVo == null) { outVo = new InspectionReturnVo(); } outVo.InspectionTestInstructionId = UpdateTestInstDetailVo.InspectionTestInstructionId; } return(outVo); }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { InspectionReturnVo outVo = new InspectionReturnVo(); InspectionReturnVo copyChildVo = null; ValueObjectList <ValueObject> inListVo = (ValueObjectList <ValueObject>)vo; if (inListVo == null || inListVo.GetList() == null || inListVo.GetList().Count == 0) { return(outVo); } InspectionItemVo updateitemVo = (InspectionItemVo)inListVo.GetList()[2]; InspectionItemSelectionDatatypeValueVo updateSelectionDataTypeValueVo = (InspectionItemSelectionDatatypeValueVo)inListVo.GetList()[3]; copyInspectionFormatMasterMntCbm = new CopyInspectionFormatMasterMntCbm(); outVo = (InspectionReturnVo)copyInspectionFormatMasterMntCbm.Execute(trxContext, vo); updateitemVo.InspectionItemId = outVo.InspectionItemId; //copyChildItemsExist(trxContext, updateitemVo); InspectionItemVo childInVo = new InspectionItemVo(); childInVo.ParentInspectionItemId = updateitemVo.InspectionItemIdCopy; ValueObjectList <InspectionItemVo> childOutVo = (ValueObjectList <InspectionItemVo>)getInspectionItemChildCbm.Execute(trxContext, childInVo); if (childOutVo != null && childOutVo.GetList() != null && childOutVo.GetList().Count > 0) { int RunningNumber = 1; InspectionItemVo inVo = new InspectionItemVo(); //inVo.ParentInspectionItemId = updateitemVo.InspectionItemId; inVo.InspectionProcessId = updateitemVo.InspectionProcessId; InspectionItemVo getRunningNoVo = (InspectionItemVo)getInspectionItemSeqCbm.Execute(trxContext, inVo); if (getRunningNoVo != null && getRunningNoVo.InspectionItemCode != null) { string strTemp; strTemp = getRunningNoVo.InspectionItemCode; 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; } } } int displyOrd = 0; foreach (InspectionItemVo itmVo in childOutVo.GetList()) { displyOrd += 1; itmVo.ParentInspectionItemId = updateitemVo.InspectionItemId; itmVo.InspectionItemIdCopy = itmVo.InspectionItemId; itmVo.InspectionProcessCode = updateitemVo.InspectionProcessCode; itmVo.DisplayOrder = displyOrd; itmVo.InspectionItemCode = updateitemVo.InspectionProcessCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.ITEM_CODE.GetValue() + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + RunningNumber; inListVo.GetList()[2] = itmVo; copyInspectionFormatMasterMntCbm = new CopyInspectionFormatMasterMntCbm(); copyChildVo = (InspectionReturnVo)copyInspectionFormatMasterMntCbm.Execute(trxContext, inListVo); RunningNumber += 1; } } if (copyChildVo != null) { return(copyChildVo); } return(outVo); }
private void Delete_btn_Click(object sender, EventArgs e) { if (!CheckMandatory()) { return; } if (inspectionspecificationid <= 0) { messageData = new MessageData("mmce00010", Properties.Resources.mmce00010, "InspectionSpecificationId"); popUpMessage.Warning(messageData, Text); return; } messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, InspectionSpecificationText_txt.Text); // Logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { InspectionSpecificationVo inVo = new InspectionSpecificationVo(); inVo.InspectionSpecificationId = inspectionspecificationid; inVo.InspectionItemId = InspectionItemId; inVo.DeleteFlag = true; string message = string.Format(Properties.Resources.mmci00038, "Inspection Specification", InspectionSpecificationText_txt.Text); StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); InspectionFormatVo passformatVo = FormFormatVo(InspectionItemId); if (passformatVo == null || passformatVo.InspectionFormatId == 0) { return; } inVoList.add(passformatVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); InspectionReturnVo outVo = new InspectionReturnVo(); try { outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } finally { CompleteProgress(); } if (outVo == null) { return; } InspectionItemId = outVo.InspectionItemId; this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); logger.Info(this.messageData); popUpMessage.Information(this.messageData, Text); this.Close(); //try //{ // InspectionSpecificationVo outVo = (InspectionSpecificationVo)base.InvokeCbm(new DeleteInspectionSpecificationMasterMntCbm(), inVo, false); // if (outVo.AffectedCount > 0) // { // this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); // logger.Info(this.messageData); // popUpMessage.Information(this.messageData, Text); // } // else if (outVo.AffectedCount == 0) // { // messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null); // logger.Info(messageData); // popUpMessage.Information(messageData, Text); // } //} //catch (Framework.ApplicationException exception) //{ // popUpMessage.ApplicationError(exception.GetMessageData(), Text); // logger.Error(exception.GetMessageData()); //} } else if (dialogResult == DialogResult.Cancel) { //do something else } }
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); }
/// <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 = InspectionItem_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = InspectionItem_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colInspectionItemName"].Value.ToString()); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { InspectionItemVo inVo = new InspectionItemVo { //InspectionItemCode = selectedRow.Cells["colInspectionItemCode"].Value.ToString(), InspectionItemId = Convert.ToInt32(selectedRow.Cells["ColInspectionItemId"].Value), InspectionProcessId = Convert.ToInt32(selectedRow.Cells["colInspectionProcessId"].Value), DeleteFlag = true }; string message = string.Format(Properties.Resources.mmci00038, "Inspection Item", selectedRow.Cells["colInspectionItemName"].Value.ToString()); StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); InspectionFormatVo passformatVo = FormFormatVo(inVo.InspectionItemId); if (passformatVo == null || passformatVo.InspectionFormatId == 0) { return; } inVoList.add(passformatVo); inVoList.add(null); inVoList.add(inVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); InspectionReturnVo outVo = new InspectionReturnVo(); try { outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } finally { CompleteProgress(); } if (outVo == null) { return; } if (outVo.InspectionProcessId > 0) { InspectionProcessId = outVo.InspectionProcessId; } //LoadInspectionProcessCombo(); //InspectionProcess_cmb.SelectedValue = InspectionProcessId; GridBind(); messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); //try //{ // InspectionItemVo checkVo = CheckRelation(inVo); // if (checkVo != null && (checkVo.InspectionItemId > 0 || checkVo.AffectedCount>0) ) // { // messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, "[INSPECTION SPECIFICATION, INSPECTION INSTRUCTION, PARENT ITEM ID]"); // popUpMessage.Information(messageData, Text); // return; // } // InspectionItemVo outVo = (InspectionItemVo)base.InvokeCbm(new DeleteInspectionItemMasterMntCbm(), inVo, 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 (Framework.ApplicationException exception) //{ // popUpMessage.ApplicationError(exception.GetMessageData(), Text); // logger.Error(exception.GetMessageData()); //} } else if (dialogResult == DialogResult.Cancel) { //do something else } }
/// <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 = InspectionTestInstructionDetail_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = InspectionTestInstructionDetail_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colInspectionTestInstructionDetailText"].Value.ToString()); // Logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { InspectionTestInstructionVo inVo = new InspectionTestInstructionVo(); inVo.InspectionTestInstructionDetailId = Convert.ToInt32(selectedRow.Cells["colInspectionTestInstructionDetailId"].Value.ToString()); inVo.InspectionTestInstructionId = Convert.ToInt32(selectedRow.Cells["colInspectionTestInstructionId"].Value.ToString()); inVo.DeleteFlag = true; string message = string.Format(Properties.Resources.mmci00038, "Inspection Test Instruction Detail", selectedRow.Cells["colInspectionTestInstructionDetailText"].Value.ToString()); StartProgress(message); ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>(); InspectionFormatVo passformatVo = FormFormatVo(updateData.InspectionTestInstructionId); if (passformatVo == null || passformatVo.InspectionFormatId == 0) { return; } inVoList.add(passformatVo); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(null); inVoList.add(inVo); InspectionReturnVo outVo = new InspectionReturnVo(); try { outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } finally { CompleteProgress(); } if (outVo == null) { return; } InspectionTestInstructionId = outVo.InspectionTestInstructionId; updateData.InspectionTestInstructionId = outVo.InspectionTestInstructionId; GetInspTestCode(); GridBind(); this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null); logger.Info(this.messageData); popUpMessage.Information(this.messageData, Text); //inVo.InspectionTestInstructionDetailCode = selectedRow.Cells["colInspectionTestInstructionDetailCode"].Value.ToString(); //try //{ // InspectionTestInstructionVo outVo = (InspectionTestInstructionVo)base.InvokeCbm(new DeleteInspectionTestInstructionDetailMasterMntCbm(), 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(); // } // else if (outVo.AffectedCount == 0) // { // messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null); // logger.Info(messageData); // popUpMessage.Information(messageData, Text); // GridBind(); // } //} //catch (Framework.ApplicationException exception) //{ // popUpMessage.ApplicationError(exception.GetMessageData(), Text); // logger.Error(exception.GetMessageData()); //} } else if (dialogResult == DialogResult.Cancel) { //do something else } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionReturnVo inVo = (InspectionReturnVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append(" select distinct if.inspection_format_id, "); sqlQuery.Append(" ip.inspection_process_id, "); sqlQuery.Append(" it.inspection_item_id, "); sqlQuery.Append(" isn.inspection_specification_id, "); sqlQuery.Append(" ti.inspection_test_instruction_id, "); sqlQuery.Append(" sv.inspection_item_selection_datatype_value_id, "); sqlQuery.Append(" itd.inspection_test_instruction_detail_id "); sqlQuery.Append(" from m_inspection_format if "); sqlQuery.Append(" left join "); sqlQuery.Append(" m_inspection_process ip "); sqlQuery.Append(" on ip.inspection_format_id = if.inspection_format_id "); sqlQuery.Append(" left join "); sqlQuery.Append(" m_inspection_item it "); sqlQuery.Append(" on it.inspection_process_id = ip.inspection_process_id "); sqlQuery.Append(" left join "); sqlQuery.Append(" m_inspection_specification isn "); sqlQuery.Append(" on isn.inspection_item_id = it.inspection_item_id "); sqlQuery.Append(" left join "); sqlQuery.Append(" m_inspection_test_instruction ti on "); sqlQuery.Append(" ti.inspection_item_id = it.inspection_item_id "); sqlQuery.Append(" left join "); sqlQuery.Append(" m_inspection_item_selection_datatype_value sv "); sqlQuery.Append(" on sv.inspection_item_id = it.inspection_item_id "); sqlQuery.Append(" left join m_inspection_test_instruction_detail itd "); sqlQuery.Append(" on itd.inspection_test_instruction_id = ti.inspection_test_instruction_id "); sqlQuery.Append(" where if.factory_cd = :factorycd "); if (inVo.InspectionFormatId > 0) { sqlQuery.Append(" and if.inspection_format_id = :inspectionformatid "); } if (inVo.InspectionProcessId > 0) { sqlQuery.Append(" and ip.inspection_process_id = :inspectionprocessid "); } if (inVo.InspectionItemId > 0) { sqlQuery.Append(" and it.inspection_item_id = :inspectionitemid "); } if (inVo.InspectionSelectionValueDataTypeId > 0) { sqlQuery.Append(" and sv.inspection_item_selection_datatype_value_id = :selectiondatatypevalueid"); } if (inVo.InspectionSpecificationId > 0) { sqlQuery.Append(" and isn.inspection_specification_id = :inspectionspecificationid "); } if (inVo.InspectionTestInstructionId > 0) { sqlQuery.Append(" and ti.inspection_test_instruction_id = :inspectiontestinstructionid "); } if (inVo.InspectionTestInstructionDetailId > 0) { sqlQuery.Append(" and itd.inspection_test_instruction_detail_id = :inspectiontestinstdetailid "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); sqlParameter.AddParameterInteger("inspectionprocessid", inVo.InspectionProcessId); sqlParameter.AddParameterInteger("inspectionitemid", inVo.InspectionItemId); sqlParameter.AddParameterInteger("selectiondatatypevalueid", inVo.InspectionSelectionValueDataTypeId); sqlParameter.AddParameterInteger("inspectionspecificationid", inVo.InspectionSpecificationId); sqlParameter.AddParameterInteger("inspectiontestinstructionid", inVo.InspectionTestInstructionId); sqlParameter.AddParameterInteger("inspectiontestinstdetailid", inVo.InspectionTestInstructionDetailId); sqlParameter.AddParameterString("factorycd", trxContext.UserData.FactoryCode); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); InspectionReturnVo outVo = new InspectionReturnVo(); while (dataReader.Read()) { outVo = new InspectionReturnVo(); outVo.InspectionFormatId = ConvertDBNull <int>(dataReader, "inspection_format_id"); outVo.InspectionProcessId = ConvertDBNull <int>(dataReader, "inspection_process_id"); outVo.InspectionItemId = ConvertDBNull <int>(dataReader, "inspection_item_id"); outVo.InspectionSpecificationId = ConvertDBNull <int>(dataReader, "inspection_specification_id"); outVo.InspectionSelectionValueDataTypeId = ConvertDBNull <int>(dataReader, "inspection_item_selection_datatype_value_id"); outVo.InspectionTestInstructionId = ConvertDBNull <int>(dataReader, "inspection_test_instruction_id"); outVo.InspectionTestInstructionDetailId = ConvertDBNull <int>(dataReader, "inspection_test_instruction_detail_id"); } dataReader.Close(); return(outVo); }