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);
}
