Backup/DAL/DB_Management.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
//该源码首发自www.51aspx.com(５１ａspｘ．ｃｏｍ)

namespace DAL
{
    public class SQLAccess
    {
        public readonly string connstr = ConfigurationManager.AppSettings["server"];

        /// <summary>
        /// 执行修改数据信息
        /// </summary>
        /// <param name="connstring">连接对象</param>
        /// <param name="commandText">执行命令</param>
        /// <returns>返回受影响的行数</returns>
        public int ExecuteNonQuery(string commandText)
        {
            SqlCommand cmd = new SqlCommand();
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                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(connstr))
            {
                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(connstr))
            {
                Paremerts(conn, cmd, commandText);
                object obj = cmd.ExecuteScalar();