/////////////////////////////////////////////////////////////////////////
/// <summary> ﾛｸﾞ出力 </summary>
/// <remarks>
/// ﾛｸﾞﾃｰﾌﾞﾙへﾛｸﾞを出力
/// </remarks>
/// <param name="sSts">ﾛｸﾞ種別</param>
/// <param name="sTtl">ﾛｸﾞﾀｲﾄﾙ</param>
/// <param name="sMsg">ﾛｸﾞﾒｯｾｰｼﾞ</param>
/// <param name="sMsgEx">ﾛｸﾞ負荷情報</param>
protected void LogWrite(string sSts, string sTtl, string sMsg, string sMsgEx)
{
StringBuilder sbSQL = new StringBuilder();
//
// ｴﾗｰﾄﾗｯﾌﾟ
try
{
// 環境存在判定
if (m_config != null)
{
using (NpgDB npgDB = TTCommon.DBConnect(m_config))
{
// SQLの作成 & 実行
sbSQL.AppendLine(" INSERT INTO " + m_sTbl);
sbSQL.AppendLine(" " + "(");
sbSQL.AppendLine(" " + "log_stamp" + ",");
sbSQL.AppendLine(" " + "log_kbn" + ",");
sbSQL.AppendLine(" " + "log_ttl" + ",");
sbSQL.AppendLine(" " + "log_memo" + ",");
sbSQL.AppendLine(" " + "log_ext" + ",");
sbSQL.AppendLine(" " + "log_prg_nm" + ",");
sbSQL.AppendLine(" " + "stf_cd" + ",");
sbSQL.AppendLine(" " + "stf_j_nm" + " ");
sbSQL.AppendLine(" " + ")" + " " + "VALUES" + " " + "(");
sbSQL.AppendLine(" " + "CURRENT_TIMESTAMP" + ",");
sbSQL.AppendLine(" " + ":log_kbn" + ",");
sbSQL.AppendLine(" " + ":log_ttl" + ",");
sbSQL.AppendLine(" " + ":log_memo" + ",");
sbSQL.AppendLine(" " + ":log_ext" + ",");
sbSQL.AppendLine(" " + ":log_prg_nm" + ",");
sbSQL.AppendLine(" " + ":stf_cd" + ",");
sbSQL.AppendLine(" " + ":stf_j_nm" + " ");
sbSQL.AppendLine(" " + ")");
npgDB.Command = sbSQL.ToString();
npgDB.SetParams("log_kbn", sSts);
npgDB.SetParams("log_ttl", sTtl);
npgDB.SetParams("log_memo", sMsg);
npgDB.SetParams("log_ext", sMsgEx);
npgDB.SetParams("log_prg_nm", m_sPgNm);
npgDB.SetParams("stf_cd", m_sStfCd);
npgDB.SetParams("stf_j_nm", m_sStfNm);
npgDB.ExecuteNonQuery();
}
}
else
{
LogfileWrite(sTtl, sMsg, sMsgEx);
}
}
catch (Exception ex)
{
DebugWrite("ﾛｸﾞ出力失敗:" + ex.Message);
LogfileWrite(sTtl, sMsg, ex.Source);
LogfileWrite(sTtl, sMsg, sMsgEx);
}
}
/////////////////////////////////////////////////////////////////////////
// <summary>
// ｲﾍﾞﾝﾄ処理
// </summary>
// <param name="delEventHandler">ｲﾍﾞﾝﾄ処理ﾃﾞﾘｹﾞｰﾄ</param>
// <remarks></remarks>
protected void OnEventExecute(string sEventName, OnEventHandler delEventHandler)
{
// ｴﾗｰﾄﾗｯﾌﾟ
try
{
// ﾛｸﾞ生成
m_log = new TTLog(m_sSysNm, m_sPgNm);
//
// 環境生成
m_config = new TTConfig(m_sConfigPath);
//
// ﾛｸﾞﾃｰﾌﾞﾙ設定
m_log.SetLogInfo(m_config, m_sLogTbl, m_sStfCd, m_sStfNm);
//
// DB接続
m_npgDB = TTCommon.DBConnect(m_config);
//
// 開始ﾛｸﾞ
m_log.EventStart(sEventName);
//
// ｲﾍﾞﾝﾄ処理実行
delEventHandler();
}
catch (TTConfig.TTConfigError ex)
{
m_log.Error("環境設定エラー", ex);
}
catch (IcelineExceptionNpgDBConnect ex)
{
m_log.Error("ＤＢ接続エラー", ex);
}
catch (System.Threading.ThreadAbortException)
{
// Redirectを実行するとこの例外が発生する為、Nop
}
catch (Exception ex)
{
m_log.Error("想定外エラー", ex);
}
finally
{
// 終了ﾛｸﾞ
m_log.EventEnd(sEventName);
//
// 後処理
m_log.Dispose();
//
if (m_npgDB != null)
{
m_npgDB.Dispose();
m_npgDB = null;
}
}
}
