PRO.DataAccess/Commons/SqlHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace PRO.DataAccess.Commons
{
    /// <summary>
    /// SqlServer数据库工具类(实现数据库连接并执行增,删,改,查)
    /// </summary>
    public class SqlHelper
    {
        private static string connectionStr;

        static SqlHelper()
        {
            connectionStr = ConfigurationManager.ConnectionStrings["sqlConnectionString"].ConnectionString;
        }


        /// <summary>
        /// 获取数据集
        /// </summary>
        /// <param name="sql">sql查询语句</param>
        /// <param name="paras">参数</param>
        /// <returns>数据集</returns>
        public static DataSet GetDataSet(string sql, SqlParameter[] paras)
        {
            using (SqlConnection conn = new SqlConnection(connectionStr))
            {
                DataSet ds = new DataSet();
                try
                {
                    conn.Open();
                    SqlCommand cmd = new SqlCommand(sql, conn);
                    if (paras != null)
                    {
                        foreach (SqlParameter p in paras)
                        {
                            cmd.Parameters.Add(p);
                        }
                    }
                    SqlDataAdapter ad = new SqlDataAdapter(cmd);
                    ad.Fill(ds);
                }
                catch (SqlException ex)
                {
                    throw new Exception("sql 异常", ex);
                }
                finally
                {
                    conn.Close();
                }
                return ds;
            }
        }