c#三层架构 DbHelper封装类

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
namespace CZBK.ItcastProject.DAL
{
 public class SqlHelper
{
   private static readonly string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
    //查询
   public static DataTable GetDataTable(string sql,CommandType type,params SqlParameter[]pars)
   {
       using (SqlConnection conn = new SqlConnection(connStr))
       {
           using (SqlDataAdapter apter = new SqlDataAdapter(sql, conn))
           {
               if (pars != null)
               {
                   apter.SelectCommand.Parameters.AddRange(pars);
               }
               apter.SelectCommand.CommandType = type;
               DataTable da = new DataTable();
               apter.Fill(da);
               return da;
           }
       }
   }
    /// <summary>
    /// 增删改
    /// </summary>
    /// <param name="sql"></param>
    /// <param name="type"></param>
    /// <param name="pars"></param>
    /// <returns></returns>
   public static int ExecuteNonquery(string sql, CommandType type, params SqlParameter[] pars)
   {
       using (SqlConnection conn = new SqlConnection(connStr))
       {
           using (SqlCommand cmd = new SqlCommand(sql, conn))
           {
               if (pars != null)
               {
                   cmd.Parameters.AddRange(pars);
               }
               cmd.CommandType = type;
               conn.Open();
               return cmd.ExecuteNonQuery();
           }
       }
   }
    /// <summary>
    /// 返回首行首列
    /// </summary>
    /// <param name="sql"></param>
    /// <param name="type"></param>
    /// <param name="pars"></param>
    /// <returns></returns>
   public static object ExecuteScalar(string sql, CommandType type, params SqlParameter[] pars)
   {
       using (SqlConnection conn = new SqlConnection(connStr))
       {
           using (SqlCommand cmd = new SqlCommand(sql, conn))
           {
               if (pars != null)
               {
                   cmd.Parameters.AddRange(pars);
               }
               cmd.CommandType = type;
               conn.Open();
               return cmd.ExecuteScalar();
           }
       }
   }
}
}