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