C#SQL数据访问帮助类

最新推荐文章于 2021-07-18 23:23:17 发布

被遗忘的开平方

最新推荐文章于 2021-07-18 23:23:17 发布

阅读量968

点赞数

分类专栏： C# 数据访问文章标签： c# 数据访问帮助类

本文链接：https://blog.csdn.net/Mychenxinyu/article/details/17348367

版权

C# 同时被 2 个专栏收录

8 篇文章 1 订阅

订阅专栏

数据访问

1 篇文章 0 订阅

订阅专栏

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.ObjectBuilder;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Data;


namespace 权限管理
{
    public class SQLHelper
    {
        //   App.config 配置
        //        <?xml version="1.0" encoding="utf-8" ?>
        //<configuration>
        //    <configSections>
        //        <section name="dataConfiguration" type="CxFramework.DBUtility.DataConfigurationSection, DBUtility, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" />
        //        <section name="database" type="CxFramework.DBUtility.DatabaseSection, DBUtility, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" />
        //    </configSections>
        //    <connectionStrings>
        //        <add name="DataSource" connectionString="Data Source=127.0.0.1;Initial Catalog=QXDATE;Persist Security Info=True;User ID=sa;Password=123456" providerName="System.Data.SqlClient" />
        //    </connectionStrings>
        //    <dataConfiguration defaultDatabase="DataSource" />
        //    <startup>
        //    </startup>
        //    <runtime>
        //        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
        //            <probing privatePath="bin;AddIns;SchemaProviders"/>
        //        </assemblyBinding>
        //    </runtime>
        //</configuration>

        /// <summary>
        /// 添加数据 添加成功返回true
        /// </summary>
        /// <param name="Sql">SQL语句</param>
        /// <returns></returns>
        public bool DataInsert(string Sql)
        {
            bool ReturnResult = false;
            Database db = DatabaseFactory.CreateDatabase();
            SqlCommand cmd = new SqlCommand(Sql);
            if (db.ExecuteNonQuery(cmd) > 0)
            {
                ReturnResult = true;
            }
            return ReturnResult;
        }
        /// <summary>
        /// 修改数据 修改成功返回true
        /// </summary>
        /// <param name="Sql">SQL语句</param>
        /// <returns></returns>
        public bool DataUpdate(string Sql)
        {
            bool ReturnResult = false;
            Database db = DatabaseFactory.CreateDatabase();
            SqlCommand cmd = new SqlCommand(Sql);
            if (db.ExecuteNonQuery(cmd) > 0)
            {
                ReturnResult = true;
            }
            return ReturnResult;
        }
        /// <summary>
        /// 删除数据 删除成功返回true
        /// </summary>
        /// <param name="Sql">SQL语句</param>
        /// <returns></returns>
        public bool DataDelete(string Sql)
        {
            bool ReturnResult = false;
            Database db = DatabaseFactory.CreateDatabase();
            SqlCommand cmd = new SqlCommand(Sql);
            if (db.ExecuteNonQuery(cmd) > 0)
            {
                ReturnResult = true;
            }
            return ReturnResult;
        }
        /// <summary>
        /// 查询数据 返回数据集
        /// </summary>
        /// <param name="Sql">SQL语句</param>
        /// <returns></returns>
        public DataSet DataSelect(string Sql)
        {
            try
            {
                Database db = DatabaseFactory.CreateDatabase();
                SqlCommand cmd = new SqlCommand(Sql);
                DataSet reader = db.ExecuteDataSet(cmd);
                return reader;
            }
            catch(Exception ex)
            {
                return null;
            }
        }

        /// <summary>
        /// 查询数据 返回第一条数据
        /// </summary>
        /// <param name="Sql">SQL语句</param>
        /// <returns></returns>
        public SqlDataReader DataSelectTop(string Sql)
        {
            try
            {
                Database db = DatabaseFactory.CreateDatabase();
                SqlCommand cmd = new SqlCommand(Sql);
                SqlDataReader reader = (SqlDataReader)db.ExecuteReader(cmd);
                return reader;
            }
            catch(Exception ex)
            {
                return null;
            }
        }
    }
}

希望对你们有用