public static DataTable Search(string sql)
{
var dt = new DataTable();
SQLSERVER DB = new SQLSERVER(COMMON.TRUSTConnection);
try
{
DB.Open();
dt = DB.Select(sql);
}
catch (Exception ex)
{
SQLSERVERHelper.Log("1", ex.Message, "検索", sql, "NoLoginUser");
MessageBox.Show("エラー発生:" + Environment.NewLine + ex.Message);
}
finally
{
DB.Close();
}
return(dt);
}
public static int Delete(string sql)
{
var cnt = 0;
SQLSERVER DB = new SQLSERVER(COMMON.TRUSTConnection);
try
{
DB.Open();
cnt = DB.ExecuteNonQuery(sql);
SQLSERVERHelper.Log("0", "", "削除 ( " + cnt + " 件)", sql, "NoLoginUser");
return(cnt);
}
catch (Exception ex)
{
SQLSERVERHelper.Log("1", ex.Message, "削除", sql, "NoLoginUser");
MessageBox.Show("エラー発生:" + Environment.NewLine + ex.Message);
}
finally
{
DB.Close();
}
return(cnt);
}
public static void Log(string LOG_LEVEL, string ERROR_MESSAGE, string SUBJECT, string MESSAGE, string UPDTID)
{
try
{
SQLSERVER DB = new SQLSERVER(COMMON.TRUSTConnection);
DB.Open();
DB.ExecuteNonQuery(
"INSERT INTO SERVERLOG ( " +
" [TIME_STAMP] "+
" ,[LOG_LEVEL] "+
" ,[PG_ID] "+
" ,[ERROR_MESSAGE] "+
" ,[SUBJECT] "+
" ,[MESSAGE] "+
" ,[UPDTDT] "+
" ,[UPDTID] "+
" ,[UPDTTRM] "+
" ) "+
"VALUES ( " +
" getdate() "+
" ,1 "+ //0:情報、1:エラー
" ,'"+ Path.GetFileName(Environment.GetCommandLineArgs()[0]).Replace(".vshost", "") + "' " +
" , '"+ ERROR_MESSAGE.Replace("'", "''") + "' " +
" , '"+ SUBJECT.Replace("'", "''") + "' " +
" ,'"+ MESSAGE.Replace("'", "''") + "' " +
" ,getdate() "+
" ,'"+ UPDTID + "' " +
" ,'"+ Dns.GetHostName() + "' " +
" )");
DB.Close();
}
catch (Exception ex)
{
File.AppendAllText("ErrorLog.txt", DateTime.Now.ToString("yyyy/MM/dd (dddd) hh時mm分ss秒") + " " + ex.Message + Environment.NewLine);
}
}
