Hotel/Common/Data/SqlServer/SqlEasy.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Reflection;
using System.Configuration;
using System.Web.Configuration;
using System.Web;
using System.Web.Caching;

namespace Common.Data.SqlServer
{
    public static class SqlEasy
    {
        /// <summary>
        /// 獲取連接字符串
        /// </summary>
        public static string connString
        {
            get
            {
                //Configuration config = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
                string connStr = ConfigurationManager.ConnectionStrings["Hotel.DbConnection"].ConnectionString;
                bool useEncrypt = ConfigHelper.GetValue("useEncrypt").ToLower() == "true";
                if (useEncrypt)
                    return StringHelper.UnBase64(connStr);
                else
                    return connStr;
            }
        }



        #region ExecuteDataTable
        public static DataTable ExecuteDataTable(string sql)
        {
            return SqlHelper.ExecuteDataset(connString, CommandType.Text, sql).Tables[0];
        }
        public static DataTable ExecuteDataTable(string sql, params SqlParameter[] para)
        {
            return SqlHelper.ExecuteDataset(connString, CommandType.Text, sql, para).Tables[0];
        }

        public static DataTable ExecuteDataTable(string connectionString, string sql, params SqlParameter[] para)
        {
            return SqlHelper.ExecuteDataset(connectionString, CommandType.Text, sql, para).Tables[0];
        }
        #endregion

        #region ExecuteNonQuery
        public static int ExecuteNonQuery(string sql)
        {
            return SqlHelper.ExecuteNonQuery(connString, CommandType.Text, sql);
        }

        public static int ExecuteNonQuery(string sql, params SqlParameter[] para)
        {
            return SqlHelper.ExecuteNonQuery(connString, CommandType.Text, sql, para);
        }