public TransferOrderInfo GetTOInfo(string toNo, string userid, out string resultMessage) { resultMessage = string.Empty; TransferOrderInfo tOrder = null; try { ProcParam procPara = new ProcParam(4) { ProcedureName = "SCANNER_PACK_MTST_VER.GET_TO_INFO" }; procPara.AddParamRefCursor(0, "io_cursor"); procPara.AddParamInput(1, "strTO_NO", toNo); 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()) { tOrder = new TransferOrderInfo(); tOrder.TO_NO = OraDataReader.Instance.GetString("TO_NO"); } } 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(tOrder); }
public TransferOrderInfo GetTOInfo(string toNo, string userid, out string resultMsg) //, out string resultMsg { resultMsg = string.Empty; TransferOrderInfo toInfo = null; try { using (ProductCardTOBLL pdToBll = new ProductCardTOBLL()) { toInfo = pdToBll.GetTOInfo(toNo, userid, out resultMsg); } } catch (Exception ex) { toInfo = null; throw ex; } return(toInfo); }