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