C#SQL数据访问帮助类

来源：互联网发布：c语言图形编程技术编辑：程序博客网时间：2024/06/04 08:37
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;            }        }    }}
希望对你们有用
0 0