public ProductCardStatusFG GetProductCardStatus(string serialNo, string userid, out string resultMsg)
{
resultMsg = string.Empty;
ProductCardStatusFG pdCard = null;
try
{
using (ProductCardStatusBLL pdBll = new ProductCardStatusBLL())
{
pdCard = pdBll.GetProductCardStatusFG(serialNo, userid, out resultMsg);
}
}
catch (Exception ex)
{
pdCard = null;
throw ex;
}
return(pdCard);
}
public ProductCardStatusFG FGPress_GetProductCardStatusFG(string serialNo, string userid, out string resultMessage)
{
resultMessage = string.Empty;
ProductCardStatusFG pcCardfg = null;
try
{
ProcParam procPara = new ProcParam(4)
{
ProcedureName = "SCANNER_PACK_FG_PRESS.GET_PC_STATUS"
};
procPara.AddParamRefCursor(0, "io_cursor");
procPara.AddParamInput(1, "strSERIAL_NO", serialNo);
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())
{
pcCardfg = new ProductCardStatusFG();
pcCardfg.SERIAL_NO = OraDataReader.Instance.GetString("SERIAL_NO");
pcCardfg.WH = OraDataReader.Instance.GetString("WH");
pcCardfg.MC_NO = OraDataReader.Instance.GetString("MC_NO");
pcCardfg.PRODUCT_NO = OraDataReader.Instance.GetString("PRODUCT_NO");
pcCardfg.PRODUCT_NAME = OraDataReader.Instance.GetString("PRODUCT_NAME");
pcCardfg.STATUS = OraDataReader.Instance.GetString("STATUS");
pcCardfg.PROCESS_NO = OraDataReader.Instance.GetString("PROCESS_NO");
pcCardfg.STATUS = OraDataReader.Instance.GetString("STATUS");
if (!OraDataReader.Instance.IsDBNull("PROCESS_DATE"))
{
pcCardfg.PROCESS_DATE = OraDataReader.Instance.GetDateTime("PROCESS_DATE");
}
pcCardfg.QTY = OraDataReader.Instance.GetInteger("QTY");
pcCardfg.UNIT_ID = OraDataReader.Instance.GetString("UNIT_ID");
pcCardfg.ORI_LABEL = OraDataReader.Instance.GetString("ORI_LABEL");
pcCardfg.BREAK_QTY = OraDataReader.Instance.GetInteger("BREAK_QTY");
}
}
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)
{
pcCardfg = null;
throw ex;
}
return(pcCardfg);
}
