public TransferOrderHdr GetTransferOrder(string qcReturnNo) { TransferOrderHdr TOhdr = null; try { ProcParam param = new ProcParam(3) { ProcedureName = "TO_PACK.GET_TO_HDR" }; param.AddParamRefCursor(0, "io_cursor"); param.AddParamInput(1, "strFindAll", DBNull.Value); param.AddParamInput(2, "strTO_NO", qcReturnNo); OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; if (OraDataReader.Instance.OraReader.HasRows) { OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1; while (OraDataReader.Instance.OraReader.Read()) { TOhdr = new TransferOrderHdr(); TOhdr.TO_NO = OraDataReader.Instance.GetString("TO_NO"); TOhdr.TO_DATE = OraDataReader.Instance.GetDateTime("TO_DATE"); TOhdr.REF_NO = OraDataReader.Instance.GetString("REF_NO"); TOhdr.PROD_TYPE = OraDataReader.Instance.GetString("PROD_TYPE"); TOhdr.TO_DEST = OraDataReader.Instance.GetString("TO_DEST"); TOhdr.DELIVERY_DATE = OraDataReader.Instance.GetDateTime("DELIVERY_DATE"); TOhdr.REMARK = OraDataReader.Instance.GetString("REMARK"); TOhdr.ISSUED_BY = OraDataReader.Instance.GetString("ISSUED_BY"); TOhdr.ISSUED_DATE = OraDataReader.Instance.GetDateTime("ISSUED_DATE"); TOhdr.UPDATE_BY = OraDataReader.Instance.GetString("UPDATE_BY"); TOhdr.UPDATE_DATE = OraDataReader.Instance.GetDateTime("UPDATE_DATE"); TOhdr.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y"); TOhdr.POST_REF = OraDataReader.Instance.GetString("POST_REF"); } } // always call Close when done reading. OraDataReader.Instance.Close(); } catch (Exception ex) { TOhdr = null; throw ex; } return(TOhdr); }
public string InsertTransferOrder(ref TransferOrderHdr TO_HDR, string userid) { string resultMsg = string.Empty; try { #region "Transaction Header" ProcParam paramHDR = new ProcParam(10); paramHDR.ProcedureName = "TO_PACK.TO_HDR_INS"; paramHDR.AddParamInOutput(0, "strTO_NO", OracleDbType.Varchar2, 255, TO_HDR.TO_NO); paramHDR.AddParamInput(1, "strTO_DATE ", TO_HDR.TO_DATE); paramHDR.AddParamInput(2, "strREF_NO", TO_HDR.REF_NO); paramHDR.AddParamInput(3, "strPROD_TYPE", TO_HDR.PROD_TYPE); paramHDR.AddParamInput(4, "strTO_DEST", TO_HDR.TO_DEST); paramHDR.AddParamInput(5, "strDELIVERY_DATE", TO_HDR.DELIVERY_DATE); paramHDR.AddParamInput(6, "strREMARK", TO_HDR.REMARK); paramHDR.AddParamInput(7, "strREC_STAT", (TO_HDR.REC_STAT ? "Y" : "N")); paramHDR.AddParamInput(8, "strUSER_ID", userid); paramHDR.AddParamOutput(9, "RESULTMSG", OracleDbType.Varchar2, 255); #endregion GlobalDB.Instance.DataAc.ExecuteNonQuery(paramHDR); //this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString resultDB = (OracleString)paramHDR.ReturnValue(0); OracleString result = (OracleString)paramHDR.ReturnValue(9); if (!result.IsNull) { TO_HDR.TO_NO = resultDB.Value; resultMsg = result.Value; } } catch (Exception ex) { throw ex; } return(resultMsg); }