Sql Server数据库的查询、更新（删除、更新、新增）函数封装

#region    引用

#endregion 

public static void ExecuteSqlNonQuery(string SQL)
        {
          
            SqlConnection sqlCnn = new SqlConnection(strCnn);
            sqlCnn.Open();
            try
            {
                StringBuilder build = new StringBuilder();
                build.AppendFormat(SQL.ToString());
                SqlCommand sqlCmm = new SqlCommand(build.ToString(), sqlCnn);
                sqlCmm.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
               // LoggerHelper.WriteLog("", "", DateTime.Now.ToString() + "数据库操作异常" + ex.Message);
            }
            finally
            {
                sqlCnn.Close();
            }
        }

        ///
        ///
        ///
        ///
        ///
        public static DataTable ExecuteSqlForDT(string SQL)
        {
          
            DataSet ds = new DataSet();
            using (SqlConnection sqlCnn = new SqlConnection(strCnn))
            {
                sqlCnn.Open();
                try
                {
                    SqlCommand sqlCmm = new SqlCommand(SQL.ToString(), sqlCnn);
                    sqlCmm.CommandType = CommandType.Text;
                    SqlDataAdapter da = new SqlDataAdapter(sqlCmm);
                    da.Fill(ds);
                }
                catch (Exception ex)
                {
                   // LoggerHelper.WriteLog("", "", DateTime.Now.ToString() + "数据库操作异常"+ ex.Message);
                }
                finally
                {
                    sqlCnn.Close();
                }
            }
            return ds.Tables[0];
        }