public void sss() { try { WebReference.AutomationWebService FA = new WebReference.AutomationWebService(); string sSql = ""; sSql = " INSERT INTO FA.JOBLOG_HIS (SP_NAME, TIMESTAMP, ERRORCODE, ERRORDESC, STATUS) "; sSql += " VALUES('OLP_STATUS_MAIL', '20190520 172605', 'sss',:pb, 'START');"; WebReference.OracleParameter[] param = new WebReference.OracleParameter[1] { new WebReference.OracleParameter() }; param[0].ParameterName = ":pb"; param[0].OracleDbType = WebReference.OracleDbType.Varchar2; param[0].Value = "TEST"; int I = FA.Perform_FA_ExecuteNonQuery(sSql, WebReference.CommandType.Text, param); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
public void GetDataFromDB() { DateTime NowDt = DateTime.Now; string sLog = ""; sLog += "WebService Start:" + DateTime.Now.ToString() + "\r\n"; WebReference.AutomationWebService FA = new WebReference.AutomationWebService(); TimeSpan Span = DateTime.Now - NowDt; sLog += " Total Time:" + Span.TotalMilliseconds + "\r\n"; string sSql = " SELECT 'A' FROM DUAL"; string sProNo = FA.Perform_FA_QueryTableToString(sSql); Span = DateTime.Now - NowDt; sLog += "WebService End!Result:" + sProNo + DateTime.Now.ToString() + " Total Time:" + Span.TotalMilliseconds + "\r\n"; WriteLogTime(sLog); }