Backup/shequ/App_Code/DAL/SqlHelperN.cs

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

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

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


    public class SqlHelperN
    {

        public static readonly string SM_SQLConnStr = ConfigurationManager.ConnectionStrings["SM_ConnStr"].ConnectionString;

        public SqlHelperN()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }

        //hashtable to store cached parameters用来缓存参数的哈希表
        private static Hashtable parmCache = Hashtable.Synchronized(new Hashtable());

        #region ------- ExecuteNonQuery -------
        /// <summary>
        /// Execute a SqlCommand (that returns no resultset) against the database specified in the connection string 
        /// 执行一个存在特定连接数据库，返回受影响行数的sql命令
        /// </summary>
        /// <param name="connectionString">a valid connection string for a SqlConnection</param>
        /// <param name="cmdType">the CommandType (stored procedure, text, etc.)</param>
        /// <param name="cmdText">the stored procedure name or T-SQL command</param>
        /// <param name="cmdParameters">an array of SqlParamters used to execute the command</param>
        /// <returns>an int representing the number of rows affected by the command</returns>
        public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] cmdParameters)
        {
            SqlCommand cmd = new SqlCommand();

            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                PreparaCommand(cmd, conn, null, cmdType, cmdText, cmdParameters);
                int val = cmd.ExecuteNonQuery();
                cmd.Parameters.Clear();
                return val;
            }
        }

        public static int ExecuteNonQuery(string connectionString, string storedProcedureName)
        {
            return ExecuteNonQuery(connectionString, CommandType.StoredProcedure, storedProcedureName, (SqlParameter[])null);
        }

        public static int ExecuteNonQuery(string connectionString, string storedProedureName, params SqlParameter[] cmdParameters)
        {
            return ExecuteNonQuery(connectionString, CommandType.StoredProcedure, storedProedureName, cmdParameters);
        }

        public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText)