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;
}
}
}
}
希望对你们有用