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);
}
