DAL/SQLHelper.cs

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

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

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



namespace DAL
{
   public class SQLHelper
    {
        private static String connectionString = ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;
        public static SqlConnection Connect()
        {
            SqlConnection con = new SqlConnection(connectionString);
            return con;
        }
        
        /// <summary>
        /// 获取连接字符串
        /// </summary>
        public static string ConnectionString
        {
            get
            {
                string _connectionString = ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;
                string ConStringEncrypt = ConfigurationManager.AppSettings["SqlConnection"];
                if (ConStringEncrypt == "true")
                {
                    _connectionString = DESEncrypt.Decrypt(_connectionString);
                }
                return _connectionString;
            }
        }



        public static string conStr = ConfigurationManager.ConnectionStrings["SqlConnection"].ToString();

        public static SqlConnection con = new SqlConnection();
        public static SqlCommand cmd = new SqlCommand();


        public static void openConnection()//打开数据库
        {
            if (con.State == ConnectionState.Closed)
            {
                try
                {
                    con.ConnectionString = conStr;
                    cmd.Connection = con;
                    con.Open();
                }
                catch (Exception err)
                {

                    throw new Exception(err.Message);