Backup/DBunit/SQLAccess.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace DBunit
{
    public class SQLAccess
    {
         public static readonly string constr =ConfigurationManager.AppSettings["server"];
        /// <summary>
        /// 执行修改数据信息
        /// </summary>
        /// <param name="constr">连接对象</param>
        /// <param name="commandText">执行命令</param>
        /// <returns>返回受影响的行数</returns>
        public int ExecuteNonQuery(string commandText)
        {
            SqlCommand cmd =new SqlCommand();
            using(SqlConnection conn =new SqlConnection(constr))
            {
              Paremerts(conn,cmd,commandText);
              int i =cmd.ExecuteNonQuery();
              cmd.Parameters.Clear();
              return i;

            }
        }
        /// <summary>
        /// 数据阅读器查询
        /// </summary>
        /// <param name="commandText">查询语句</param>
        /// <returns>读取的结果集</returns>
        public SqlDataReader ExecuteDataReader(string commandText)
        {
            SqlCommand cmd = new SqlCommand();
            using (SqlConnection conn = new SqlConnection(constr))
            {
                Paremerts(conn, cmd, commandText);
                SqlDataReader dr = cmd.ExecuteReader();
                cmd.Parameters.Clear();
                return dr;
            }
 
        }
        /// <summary>
        /// 查询第一行的第一条记录
        /// </summary>
        /// <param name="commandText">查询语句</param>
        /// <returns>返回结果</returns>
        public  object ExecuteSc(string commandText)
        {
             SqlCommand cmd = new SqlCommand();
             using (SqlConnection conn = new SqlConnection(constr))
             {
                 Paremerts(conn, cmd, commandText);
                 object obj = cmd.ExecuteScalar();
                 cmd.Parameters.Clear();
                 return obj;