public PalletList GetPalletList(string pickno, out string resultMessage) //
{
resultMessage = string.Empty;
PalletList lstPallet = null;
Pallet pallet = null;
try
{
ProcParam procPara = new ProcParam(3)
{
ProcedureName = "SCANNER_PACK_FG.GET_PALLET_LIST"
};
procPara.AddParamRefCursor(0, "IO_CURSOR");
procPara.AddParamInput(1, "strPICK_NO", pickno);
procPara.AddParamOutput(2, "RESULTMSG", OracleDbType.Varchar2, 255);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstPallet = new PalletList();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 100;
while (OraDataReader.Instance.OraReader.Read())
{
pallet = new Pallet();
pallet.PALLET_NO = OraDataReader.Instance.GetString("PALLET_NO");
pallet.SO_NO = OraDataReader.Instance.GetString("SO_NO");
pallet.PALLET_SEQ = OraDataReader.Instance.GetInteger("PALLET_SEQ");
pallet.PALLET_TOTAL = OraDataReader.Instance.GetInteger("PALLET_TOTAL");
pallet.PALLET_STATUS = OraDataReader.Instance.GetString("PALLET_STATUS");
pallet.PALLET_BOX = OraDataReader.Instance.GetInteger("PALLET_BOX");
pallet.PALLET_PCS = OraDataReader.Instance.GetInteger("PALLET_PCS");
lstPallet.Add(pallet);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
OracleString resultDB = (OracleString)procPara.ReturnValue(2);
if (!resultDB.IsNull)
{
resultMessage = resultDB.Value;
}
}
catch (Exception ex)
{
lstPallet = null;
throw ex;
}
return(lstPallet);
}
