App_Code/SqlHelper.cs

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

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

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

public class SqlHelper
{
    private static readonly string connectionString = ConfigurationManager.ConnectionStrings["BLX_KqConnectionString"].ConnectionString;

    private static SqlConnection CreateConnection()
    {
        return new SqlConnection(connectionString);
    }

    public static DataTable ExecuteDataTable(string cmdText, params IDataParameter[] cmdParms)
    {
        return ExecuteDataset(cmdText, cmdParms).Tables[0];
    }

    public static DataTable ExecuteDataTable(CommandType cmdType, string cmdText, params IDataParameter[] cmdParms)
    {
        return ExecuteDataset(cmdType, cmdText, cmdParms).Tables[0];
    }

    public static DataSet ExecuteDataset(string cmdText, params IDataParameter[] cmdParms)
    {
        return ExecuteDataset(CommandType.Text, cmdText, cmdParms);
    }

    public static DataSet ExecuteDataset(CommandType cmdType, string cmdText, params IDataParameter[] cmdParms)
    {
        using (SqlConnection connection = CreateConnection())
        {
            DataSet dataSet = new DataSet();
            SqlCommand cmd = new SqlCommand();
            PrepareCommand(cmd, connection, cmdType, cmdText, cmdParms);
            using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                da.Fill(dataSet);
            return dataSet;
        }
    }

    public static int ExecuteNonQuery(string cmdText, params IDataParameter[] cmdParms)
    {
        return ExecuteNonQuery(CommandType.Text, cmdText, cmdParms);
    }

    public static int ExecuteNonQuery(CommandType cmdType, string cmdText, params IDataParameter[] cmdParms)
    {
        SqlCommand cmd = new SqlCommand();
        using (SqlConnection connection = CreateConnection())
        {
            PrepareCommand(cmd, connection, cmdType, cmdText, cmdParms);
            int num = cmd.ExecuteNonQuery();
            cmd.Parameters.Clear();
            return num;
        }
    }