public QCReturn GetQcReturnInfo(string qcReturnNo, string userid, out string resultMessage)
{
resultMessage = string.Empty;
QCReturn qcReturn = null;
try
{
ProcParam procPara = new ProcParam(4)
{
ProcedureName = "SCANNER_RETRUN_PACK.GET_FG_RETURN"
};
procPara.AddParamRefCursor(0, "io_cursor");
procPara.AddParamInput(1, "strRT_NO", qcReturnNo);
procPara.AddParamOutput(2, "resultmsg", OracleDbType.Varchar2, 255);
procPara.AddParamInput(3, "strUser_id", userid);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
while (OraDataReader.Instance.OraReader.Read())
{
qcReturn = new QCReturn();
qcReturn.WH_ID = OraDataReader.Instance.GetString("WH_ID");
qcReturn.RT_NO = OraDataReader.Instance.GetString("RT_NO");
qcReturn.NO_OF_LABEL = OraDataReader.Instance.GetInteger("NO_OF_LABEL");
}
}
else
{
OracleString result = (OracleString)procPara.ReturnValue(2);
if (!result.IsNull)
{
resultMessage = result.Value;
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
throw ex;
}
return(qcReturn);
}
public QCReturn GetQCReturnOrderInfo(string qcReturnNo, string userid, out string resultMsg) //,
{
resultMsg = string.Empty;
QCReturn qcReturn = null;
try
{
using (QCReturnBLL qcREturnBll = new QCReturnBLL())
{
qcReturn = qcREturnBll.GetQcReturnInfo(qcReturnNo, userid, out resultMsg);
}
}
catch (Exception ex)
{
qcReturn = null;
throw ex;
}
return(qcReturn);
}
