DAL/DBHelper.cs

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

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

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


namespace DAL
{
    public class DBHelper
    {
        static string connectionString = ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString;
        /*将连接字符串设计成属性*/
        public static string ConnecttionString
        {
            get
            {
                return connectionString;
            }
            set
            {
                connectionString = value;
            }
        }

        public static int ExecuteCommand(string safeSql)
        {
            return ExecuteCommand(safeSql, null);
        }
        

        public static int ExecuteCommand(string sql, params SqlParameter[] values)
        {
            using (SqlConnection conn = new SqlConnection(ConnecttionString))
            {
                SqlCommand cmd = new SqlCommand();
                PrepareCommand(cmd, conn, sql, values);
                return cmd.ExecuteNonQuery();
            }
        }

        public static int GetIntScalar(string safeSql)
        {
            return GetIntScalar(safeSql, null);
        }

        public static int GetIntScalar(string sql, params SqlParameter[] values)
        {
            using (SqlConnection conn = new SqlConnection(ConnecttionString))
            {
                SqlCommand cmd = new SqlCommand();
                PrepareCommand(cmd, conn, sql, values);
                return Convert.ToInt32(cmd.ExecuteScalar());
            }
        }

        public static int GetIntScalar2(string safeSql)
        {