DBUtility/DbHelperSQL.cs

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

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

//*********************
//功能:数据访问抽象基础类
//Author：YanyanQing
//Time：2013-12-23
//*********************
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace DBUtility
{
   public abstract class DbHelperSQL
   {
       ///数据库连接字符串(web.config来配置)，多数据库可使用PubConstant.GetConnectionString()来实现.
       public static string connectionString = PubConstant.ConnectionString;
       public DbHelperSQL()
       { 
       }
       #region ExecuteNonQuery
       /// <summary>
       /// 执行sql命令
       /// </summary>
       /// <param name="connectionString">连接字符串</param>
       /// <param name="commandType">命令类型</param>
       /// <param name="commandText">sql语句/参数化sql语句/存储过程名</param>
       /// <param name="commandParameters">参数</param>
       /// <returns>受影响的行数</returns>
       public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
       {

           SqlCommand cmd = new SqlCommand();

           using (SqlConnection conn = new SqlConnection(connectionString))
           {
               PrepareCommand(cmd, commandType, conn, commandText, commandParameters);
               int val = cmd.ExecuteNonQuery();

               return val;
           }
       }

       /// <summary>
       /// 执行Sql Server存储过程
       /// 注意：不能执行有out 参数的存储过程
       /// </summary>
       /// <param name="connectionString">连接字符串</param>
       /// <param name="spName">存储过程名</param>
       /// <param name="parameterValues">对象参数</param>
       /// <returns>受影响的行数</returns>
       public static int ExecuteNonQuery(string connectionString, string spName, params object[] parameterValues)
       {

           using (SqlConnection conn = new SqlConnection(connectionString))
           {
               SqlCommand cmd = new SqlCommand();

               PrepareCommand(cmd, conn, spName, parameterValues);
               int val = cmd.ExecuteNonQuery();