Hidistro.UI.Web/DBUtility/SqlAccess.cs

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

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

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace db_conn
{
    /// <summary>
    /// SqlServerDataBase 的摘要说明
    /// </summary>
    public class userdb
    {
        private string strError = null;
        private int intCount = 0;
        public SqlConnection DBconn()//公开方法DBConn，返回数据库连接
        {
            string strConn = ConfigurationManager.ConnectionStrings["HidistroSqlServer"].ConnectionString;
            try
            {
                return new SqlConnection(strConn);
            }
            catch (Exception)
            {
                return null;
            }
        }

        public string ErrorMessage//公开属性ErrorMessage，返回错误信息
        {
            get
            {
                return strError;
            }
        }

        public DataTable GetDataTable(string sqlstr)//返回数据表对象
        {
            DataTable tab = new DataTable();
            using (SqlConnection con = DBconn())
            {
                using (SqlCommand command = new SqlCommand(sqlstr, con))
                {
                    SqlDataAdapter adapter = new SqlDataAdapter(command);
                    adapter.Fill(tab);
                }
            }
            return tab;
        }

        /// <summary>
        /// 根据查询语句从数据库检索数据
        /// </summary>
        /// <param name="strSelect">查询语句</param>
        /// <param name="SqlConn">数据库连接</param>
        /// <returns>有数据则返回DataSet对象，否则返回null</returns>
        public DataSet Select(string SelectString, SqlConnection sqlConn)
        {
            strError = "";
            SqlConnection conn;
            if (sqlConn == null)
            {