public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { InspectionFormatVo inVo = (InspectionFormatVo)vo; InspectionFormatVo OutVo = null; //InspectionFormatVo formatVo = (InspectionFormatVo)checkInspectionFormatCbm.Execute(trxContext, vo); //if(formatVo != null && formatVo.AffectedCount > 0) //{ // OutVo = new InspectionFormatVo(); // OutVo.AffectedCount = formatVo.AffectedCount; // return OutVo; //} ItemLineInspectionFormatVo ItemlineinVo = new ItemLineInspectionFormatVo(); ItemlineinVo.LineId = inVo.LineId; ItemlineinVo.SapItemCode = inVo.SapItemCode; ItemLineInspectionFormatVo itemlineVo = (ItemLineInspectionFormatVo)checkItemLineInspectionFormatMasterMntCbm.Execute(trxContext, ItemlineinVo); if (itemlineVo != null && itemlineVo.AffectedCount > 0) { OutVo = new InspectionFormatVo(); OutVo.AffectedCount = itemlineVo.AffectedCount; return(OutVo); } return(OutVo); }
private bool CheckItemLineInspectionDataExist() { ItemLineInspectionFormatVo inVo = new ItemLineInspectionFormatVo(); inVo.InspectionFormatId = FormatId; ValueObjectList <ItemLineInspectionFormatVo> outVo = null; try { outVo = (ValueObjectList <ItemLineInspectionFormatVo>)base.InvokeCbm(new GetItemLineInspectionFormatMasterMntCbm(), 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) { return(false); } LoadInspectionProcessData(outVo.GetList()[0]); mode = CommonConstants.MODE_UPDATE; return(true); }
/// <summary> /// passing update data to update form /// </summary> private void BindUpdateInspectionProcessData() { int selectedrowindex = ItemLineInspectionFormatDetails_dgv.SelectedCells[0].RowIndex; ItemLineInspectionFormatVo inspProcessVo = (ItemLineInspectionFormatVo)ItemLineInspectionFormatDetails_dgv.Rows[selectedrowindex].DataBoundItem; AddItemLineInspectionFormatForm newAddForm = new AddItemLineInspectionFormatForm(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()); } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ItemLineInspectionFormatVo inVo = (ItemLineInspectionFormatVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete From m_item_line_inspection_format"); sqlQuery.Append(" Where "); sqlQuery.Append(" inspection_format_id = :inspectionformatid "); sqlQuery.Append(" and factory_cd = :faccd ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
/// <summary> /// inserts new record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Ok_btn_Click(object sender, EventArgs e) { ItemLineInspectionFormatVo inVo = new ItemLineInspectionFormatVo(); var sch = StringCheckHelper.GetInstance(); if (CheckMandatory() == true) { inVo.ItemId = Convert.ToInt32(ItemId_cmb.SelectedValue.ToString()); inVo.LineId = Convert.ToInt32(LineId_cmb.SelectedValue.ToString()); inVo.InspectionFormatId = Convert.ToInt32(InspectionFormat_cmb.SelectedValue.ToString()); inVo.Mode = mode; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { inVo.ItemLineInspectionFormatId = ItemLineInspectionFormatId; } ItemLineInspectionFormatVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, Environment.NewLine + ItemId_lbl.Text + " : " + ItemId_cmb.Text + " AND " + LineId_lbl.Text + " : " + LineId_cmb.Text + Environment.NewLine + " OR " + Environment.NewLine + InspectionFormat_lbl.Text + " : " + InspectionFormat_cmb.Text); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } try { if (string.Equals(mode, CommonConstants.MODE_ADD)) { ItemLineInspectionFormatVo outVo = (ItemLineInspectionFormatVo)base.InvokeCbm(new AddItemLineInspectionFormatMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } else if (mode.Equals(CommonConstants.MODE_UPDATE)) { ItemLineInspectionFormatVo outVo = (ItemLineInspectionFormatVo)base.InvokeCbm(new UpdateItemLineInspectionFormatMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); return; } if ((IntSuccess > 0) || (IntSuccess == 0)) { this.Close(); } } }
/// <summary> /// constructor /// </summary> /// <param name="pmode"></param> /// <param name="userItem"></param> public AddItemLineInspectionFormatForm(string pmode, ItemLineInspectionFormatVo userItem = null) { InitializeComponent(); mode = pmode; updateData = userItem; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { this.Text = UpdateText_lbl.Text; } }
/// <summary> /// Loads selected data from data grid /// </summary> /// <param name="dgvInspectionProcess"></param> private void LoadInspectionProcessData(ItemLineInspectionFormatVo dgvInspectionProcess) { if (dgvInspectionProcess != null) { this.ItemId_cmb.SelectedValue = dgvInspectionProcess.ItemId.ToString(); this.LineId_cmb.SelectedValue = dgvInspectionProcess.LineId.ToString(); this.InspectionFormat_cmb.SelectedValue = dgvInspectionProcess.InspectionFormatId.ToString(); } }
private void Delete_btn_Click(object sender, EventArgs e) { if (!CheckMandatory()) { return; } if (ItemLineInspectionFormatId <= 0) { messageData = new MessageData("mmce00010", Properties.Resources.mmce00010, "ItemLineInspectionFormatId"); popUpMessage.Warning(messageData, Text); return; } messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, ItemId_cmb.Text); // Logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { ItemLineInspectionFormatVo inVo = new ItemLineInspectionFormatVo(); inVo.ItemLineInspectionFormatId = ItemLineInspectionFormatId; try { ItemLineInspectionFormatVo outVo = (ItemLineInspectionFormatVo)base.InvokeCbm(new DeleteItemLineInspectionFormatMasterMntCbm(), 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()); } this.Close(); } 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 = ItemLineInspectionFormatDetails_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = ItemLineInspectionFormatDetails_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colItemName"].Value.ToString()); // Logger.Info(messageData); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { ItemLineInspectionFormatVo inVo = new ItemLineInspectionFormatVo(); inVo.ItemLineInspectionFormatId = Convert.ToInt32(selectedRow.Cells["colItemLineInspectionFormatId"].Value.ToString()); inVo.ItemId = Convert.ToInt32(selectedRow.Cells["colItemId"].Value.ToString()); inVo.LineId = Convert.ToInt32(selectedRow.Cells["colLineId"].Value.ToString()); inVo.InspectionFormatId = Convert.ToInt32(selectedRow.Cells["colInspectionFormatId"].Value.ToString()); try { ItemLineInspectionFormatVo outVo = (ItemLineInspectionFormatVo)base.InvokeCbm(new DeleteItemLineInspectionFormatMasterMntCbm(), 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 } }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { InspectionFormatVo inVo = (InspectionFormatVo)vo; UpdateResultVo OutVo = new UpdateResultVo(); OutVo = (UpdateResultVo)deleteInspectionFormatcbm.Execute(trxContext, inVo); if (OutVo != null && OutVo.AffectedCount > 0) { ItemLineInspectionFormatVo itemlineInVo = new ItemLineInspectionFormatVo(); itemlineInVo.InspectionFormatId = inVo.InspectionFormatId; return(deleteItemLineInspectionFormatMasterMntCbm.Execute(trxContext, itemlineInVo)); } return(OutVo); }
/// <summary> /// Loads selected data from data grid /// </summary> /// <param name="dgvInspectionProcess"></param> private void LoadInspectionProcessData(ItemLineInspectionFormatVo dgvInspectionProcess) { if (dgvInspectionProcess != null) { this.ItemId_cmb.SelectedValue = dgvInspectionProcess.SapItemCode.ToString(); this.LineId_cmb.SelectedValue = dgvInspectionProcess.LineId.ToString(); this.InspectionFormat_cmb.SelectedValue = dgvInspectionProcess.InspectionFormatId.ToString(); ItemLineInspectionFormatId = dgvInspectionProcess.ItemLineInspectionFormatId; Delete_btn.Enabled = true; } }
/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind(ItemLineInspectionFormatVo conditionInVo) { if (conditionInVo == null) { return; } ItemLineInspectionFormatDetails_dgv.DataSource = null; ValueObjectList <ItemLineInspectionFormatVo> outVo = null; try { outVo = (ValueObjectList <ItemLineInspectionFormatVo>)base.InvokeCbm(new GetItemLineInspectionFormatMasterMntCbm(), 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; } ItemLineInspectionFormatDetails_dgv.AutoGenerateColumns = false; BindingSource bindingSource1 = new BindingSource(outVo.GetList(), null); if (bindingSource1 != null && bindingSource1.Count > 0) { ItemLineInspectionFormatDetails_dgv.DataSource = bindingSource1; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } ItemLineInspectionFormatDetails_dgv.ClearSelection(); Update_btn.Enabled = false; Delete_btn.Enabled = false; }
/// <summary> /// checks duplicate Item line inspection format code /// </summary> /// <returns></returns> private ItemLineInspectionFormatVo DuplicateCheck(ItemLineInspectionFormatVo InsProcessVo) { ItemLineInspectionFormatVo outVo = new ItemLineInspectionFormatVo(); try { outVo = (ItemLineInspectionFormatVo)base.InvokeCbm(new CheckItemLineInspectionFormatMasterMntCbm(), InsProcessVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ItemLineInspectionFormatVo inVo = (ItemLineInspectionFormatVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_item_line_inspection_format"); sqlQuery.Append(" ( "); sqlQuery.Append(" sap_matnr_item_cd,"); sqlQuery.Append(" line_id,"); sqlQuery.Append(" inspection_format_id,"); sqlQuery.Append(" registration_user_cd,"); sqlQuery.Append(" registration_date_time,"); sqlQuery.Append(" factory_cd"); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :sapitemcd,"); sqlQuery.Append(" :lineid,"); sqlQuery.Append(" :inspectionformatid,"); sqlQuery.Append(" :registrationusercode,"); sqlQuery.Append(" :regdatetime,"); sqlQuery.Append(" :factorycode"); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("sapitemcd", inVo.SapItemCode); sqlParameter.AddParameterInteger("lineid", inVo.LineId); sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); UserData userdata = trxContext.UserData; sqlParameter.AddParameterString("registrationusercode", userdata.UserCode); sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", userdata.FactoryCode); ItemLineInspectionFormatVo outVo = new ItemLineInspectionFormatVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
/// <summary> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private ItemLineInspectionFormatVo FormConditionVo() { ItemLineInspectionFormatVo inVo = new ItemLineInspectionFormatVo(); if (ItemId_cmb.SelectedIndex > -1) { inVo.ItemId = Convert.ToInt32(ItemId_cmb.SelectedValue.ToString()); } if (LineId_cmb.SelectedIndex > -1) { inVo.LineId = Convert.ToInt32(LineId_cmb.SelectedValue.ToString()); } if (InspectionFormatId_cmb.SelectedIndex > -1) { inVo.InspectionFormatId = Convert.ToInt32(InspectionFormatId_cmb.SelectedValue.ToString()); } return(inVo); }
public ValueObject Execute(TransactionContext trxContext, ValueObject vo) { InspectionFormatVo inVo = (InspectionFormatVo)vo; InspectionFormatVo OutVo = null; int SerialNumber = 1; InspectionFormatVo getseqVo = (InspectionFormatVo)getInspectionFormatLastRecordforSerailNoMasterMnt.Execute(trxContext, vo); if (getseqVo != null && getseqVo.InspectionFormatCode != null) { string[] splitval = getseqVo.InspectionFormatCode.Split(Convert.ToChar(GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue())); if (splitval.Length > 3) { if (splitval[splitval.Length - 1].All(Char.IsDigit)) { SerialNumber = Convert.ToInt32(splitval[splitval.Length - 1]) + 1; } } } inVo.InspectionFormatCode = inVo.InspectionFormatCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + SerialNumber.ToString().PadLeft(5, '0'); inVo.InspectionFormatSeq = getseqVo.InspectionFormatSeq; InspectionFormatVo returnformatidVo = (InspectionFormatVo)addInspectionFormatCbm.Execute(trxContext, inVo); if (returnformatidVo != null && returnformatidVo.InspectionFormatId > 0) { ItemLineInspectionFormatVo itemlineInVo = new ItemLineInspectionFormatVo(); itemlineInVo.InspectionFormatId = returnformatidVo.InspectionFormatId; itemlineInVo.SapItemCode = inVo.SapItemCode; itemlineInVo.LineId = inVo.LineId; ItemLineInspectionFormatVo ItemlineOutVo = (ItemLineInspectionFormatVo)addItemLineInspectionFormatMasterMntCbm.Execute(trxContext, itemlineInVo); if (ItemlineOutVo != null) { OutVo = new InspectionFormatVo(); OutVo.AffectedCount = ItemlineOutVo.AffectedCount; OutVo.InspectionFormatId = returnformatidVo.InspectionFormatId; OutVo.InspectionFormatCode = inVo.InspectionFormatCode; } } return(OutVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ItemLineInspectionFormatVo inVo = (ItemLineInspectionFormatVo)arg; StringBuilder sql = new StringBuilder(); //create SQL sql.Append("Select Count(*) as itemlineinspectionformatcount from m_item_line_inspection_format ilf"); sql.Append(" inner join m_inspection_format if on if.inspection_format_id = ilf.inspection_format_id "); sql.Append(" where ilf.factory_cd = :faccd "); sql.Append(" and if.is_deleted = '0' "); if (inVo.SapItemCode != null) { sql.Append(" and sap_matnr_item_cd = :sapitemcd"); } if (inVo.LineId > 0) { sql.Append(" and line_id = :lineid"); } if (inVo.Mode.Equals(CommonConstants.MODE_UPDATE.ToString()) && inVo.ItemLineInspectionFormatId > 0) { sql.Append(" and item_line_inspection_format_id <> :itemlineinspectionformatid "); } if (inVo.InspectionFormatId > 0) { sql.Append(" or ( "); if (inVo.Mode.Equals(CommonConstants.MODE_UPDATE.ToString()) && inVo.ItemLineInspectionFormatId > 0) { sql.Append(" item_line_inspection_format_id <> :itemlineinspectionformatid and "); } sql.Append(" inspection_format_id = :inspectionformatid and factory_cd = :faccd) "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.SapItemCode != null) { sqlParameter.AddParameterString("sapitemcd", inVo.SapItemCode); } if (inVo.LineId > 0) { sqlParameter.AddParameterInteger("lineid", inVo.LineId); } if (inVo.InspectionFormatId > 0) { sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); } if (inVo.Mode.Equals(CommonConstants.MODE_UPDATE.ToString()) && inVo.ItemLineInspectionFormatId > 0) { sqlParameter.AddParameterInteger("itemlineinspectionformatid", inVo.ItemLineInspectionFormatId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ItemLineInspectionFormatVo outVo = new ItemLineInspectionFormatVo { AffectedCount = 0 }; while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["itemlineinspectionformatcount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ItemLineInspectionFormatVo inVo = (ItemLineInspectionFormatVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("select"); sqlQuery.Append(" ilif.item_line_inspection_format_id,"); sqlQuery.Append(" ilif.item_id,"); sqlQuery.Append(" si.sap_maktx_item_name,"); sqlQuery.Append(" ilif.line_id,"); sqlQuery.Append(" l.line_name,"); sqlQuery.Append(" ilif.inspection_format_id,"); sqlQuery.Append(" if.inspection_format_name"); sqlQuery.Append(" from m_item_line_inspection_format ilif"); sqlQuery.Append(" inner join sap_item si"); sqlQuery.Append(" on si.sap_matnr_item_cd = ilif.sap_matnr_item_cd"); sqlQuery.Append(" inner join m_line l"); sqlQuery.Append(" on l.line_id = ilif.line_id"); sqlQuery.Append(" inner join m_inspection_format if"); sqlQuery.Append(" on if.inspection_format_id = ilif.inspection_format_id"); sqlQuery.Append(" where ilif.factory_cd = :faccd "); if (inVo.SapItemCode != null) { sqlQuery.Append(" and ilif.sap_matnr_item_cd = :sapitemcd "); } if (inVo.LineId > 0) { sqlQuery.Append(" and ilif.line_id = :lineid "); } if (inVo.InspectionFormatId > 0) { sqlQuery.Append(" and ilif.inspection_format_id = :inspectionformatid "); } sqlQuery.Append(" order by ilif.item_line_inspection_format_id "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.SapItemCode != null) { sqlParameter.AddParameterString("itemid", inVo.SapItemCode); } if (inVo.LineId > 0) { sqlParameter.AddParameterInteger("lineid", inVo.LineId); } if (inVo.InspectionFormatId > 0) { sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ValueObjectList <ItemLineInspectionFormatVo> outVo = null; while (dataReader.Read()) { ItemLineInspectionFormatVo currOutVo = new ItemLineInspectionFormatVo(); currOutVo.ItemLineInspectionFormatId = ConvertDBNull <int>(dataReader, "item_line_inspection_format_id"); currOutVo.SapItemCode = ConvertDBNull <string>(dataReader, "sap_matnr_item_cd"); currOutVo.SapItemName = ConvertDBNull <string>(dataReader, "sap_maktx_item_name"); currOutVo.LineId = ConvertDBNull <int>(dataReader, "line_id"); currOutVo.LineName = ConvertDBNull <string>(dataReader, "line_name"); currOutVo.InspectionFormatId = ConvertDBNull <int>(dataReader, "inspection_format_id"); currOutVo.InspectionFormatName = ConvertDBNull <string>(dataReader, "inspection_format_name"); if (outVo == null) { outVo = new ValueObjectList <ItemLineInspectionFormatVo>(); } outVo.add(currOutVo); } dataReader.Close(); return(outVo); }