public ProductCard_Status GetProductCardStatus(string serialNo, string userid, out string resultMessage) { resultMessage = string.Empty; ProductCard_Status pcCard = null; try { ProcParam procPara = new ProcParam(4) { ProcedureName = "SCANNER_PACK_VER.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()) { pcCard = new ProductCard_Status(); pcCard.SERIAL_NO = OraDataReader.Instance.GetString("SERIAL_NO"); pcCard.MC_NO = OraDataReader.Instance.GetString("MC_NO"); pcCard.PRODUCT_NO = OraDataReader.Instance.GetString("PRODUCT_NO"); pcCard.PRODUCT_NAME = OraDataReader.Instance.GetString("PRODUCT_NAME"); pcCard.STATUS = OraDataReader.Instance.GetString("STATUS"); if (!OraDataReader.Instance.IsDBNull("PROCESS_DATE")) { pcCard.PROCESS_DATE = OraDataReader.Instance.GetDateTime("PROCESS_DATE"); } pcCard.QTY = OraDataReader.Instance.GetInteger("QTY"); pcCard.NG_QTY = OraDataReader.Instance.GetInteger("NG_QTY"); pcCard.REP_QTY = OraDataReader.Instance.GetInteger("REP_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) { pcCard = null; throw ex; } return(pcCard); }
public ProductCard_Status GetProductCardStatus(string serialNo, string userid, out string resultMsg) { resultMsg = string.Empty; ProductCard_Status pdCard = null; try { using (ProductCardStatusBLL pdBll = new ProductCardStatusBLL()) { pdCard = pdBll.Horizontal_GetProductCardStatus(serialNo, userid, out resultMsg); } } catch (Exception ex) { pdCard = null; throw ex; } return(pdCard); }