引子:
#region 获取连接字符串
/// <summary>
/// 获取连接字符串:从XML文件中获取
/// </summary>
/// <returns></returns>
public static string GetConnectionString()
{
if (connectionString=="")
{
XmlDocument doc = new XmlDocument();
doc.Load(BrainSoft.Common.Global.SystemConfigFile);
//private const string _SystemConfigFile = "SystemConfig.xml";
XmlNode nod = doc.SelectSingleNode("configuration/ConnectionString");
connectionString = nod.Attributes["sqlvalue"].Value;
}
return connectionString;
}
#endregion
<configuration>
<!--连接字符串 -->
<ConnectionString sqlvalue="database=FMIS;server=.;uid=sa;pwd=sa"/>
//——————————————————————————————————————
using System;
using System.Data;
using System.Xml;
using System.Data.SqlClient;
namespace BrainSoft.Common
{
/// <summary>
/// 描 述:对 SQL Server 数据库执行操作 进行封装,对外提供接品操作
/// 参数说明:
/// 说 明:
/// 创 建 人:thanktheworld
/// 日 期:now
/// </summary>
public class Execute
{
#region 定义变量
private static string connectionString="";
#endregion
#region 获取连接字符串
/// <summary>
/// 获取连接字符串
/// </summary>
/// <returns></returns>
public static string GetConnectionString()
{
if (connectionString=="")
{
XmlDocument doc = new XmlDocument();
doc.Load(BrainSoft.Common.Global.SystemConfigFile);
XmlNode nod = doc.SelectSingleNode("configuration/ConnectionString");
connectionString = nod.Attributes["sqlvalue"].Value;
}
return connectionString;
}
#endregion
#region 打开连接字符串
/// <summary>
/// 打开连接字符串
/// </summary>
/// <returns></returns>
public static SqlConnection OpenConnection()
{
SqlConnection connection=new SqlConnection(GetConnectionString());
connection.Open();
return connection;
}
#endregion
#region 执行SQL 文本命令返回 int
/// <summary>
/// 执行SQL 文本命令返回 int
/// </summary>
/// <param name="commandText">Sql语句</param>
/// <returns>返回int</returns>
public static int ExecuteNonQuery(string commandText)
{
string connectionString = GetConnectionString();
return SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, commandText);
}
#endregion
#region 执行SQL 文本命令返回 DataSet
/// <summary>
/// 执行SQL 文本命令返回 DataSet
/// </summary>
/// <param name="commandText">Sql语句</param>
/// <returns>返回DataSet</returns>
public static DataSet ExecuteDataset(string commandText)
{
string connectionString = GetConnectionString();
return SqlHelper.ExecuteDataset(connectionString, CommandType.Text, commandText);
}
#endregion
#region 执行SQL 文本命令返回 DataTable
/// <summary>
/// 执行SQL 文本命令返回 DataTable
/// </summary>
/// <param name="commandText">Sql语句</param>
/// <returns>返回DataTable</returns>
public static DataTable ExecuteDataTable(string commandText)
{
string connectionString = GetConnectionString();
DataSet ds=SqlHelper.ExecuteDataset(connectionString, CommandType.Text, commandText);
return ds.Tables[0];
}
#endregion
#region 执行存储过程返回 int
/// <summary>
/// 执行存储过程返回 int
/// </summary>
/// <param name="commandProcedureName">Sql语句</param>
/// <param name="commandParameters">存储过程参数</param>
/// <returns>返回int</returns>
public static int ExecuteProcNonQuery(string commandProcedureName, ref SqlParameter[] commandParameters)
{
string connectionString = GetConnectionString();
return SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, commandProcedureName, commandParameters);
}
#endregion
#region 执行存储过程返回 DataSet
/// <summary>
/// 执行存储过程返回 DataSet
/// </summary>
/// <param name="commandProcedureName">Sql语句</param>
/// <param name="commandParameters">存储过程参数</param>
/// <returns>返回DataSet</returns>
public static DataSet ExecuteProcDataset(string commandProcedureName, ref SqlParameter[] commandParameters)
{
string connectionString = GetConnectionString();
return SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, commandProcedureName, commandParameters);
}
#endregion
#region 执行存储过程返回 DataTable
/// <summary>
/// 执行存储过程返回 DataTable
/// </summary>
/// <param name="commandProcedureName">Sql语句</param>
/// <param name="commandParameters">存储过程参数</param>
/// <returns>返回DataSet</returns>
public static DataTable ExecuteProcDataTable(string commandProcedureName, ref SqlParameter[] commandParameters)
{
string connectionString = GetConnectionString();
DataSet ds=SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, commandProcedureName, commandParameters);
return ds.Tables[0];
}
#endregion
#region 执行SQL 文本命令返回(带事务) int
/// <summary>
/// 执行SQL 文本命令返回(带事务) int
/// </summary>
/// <param name="commandText">Sql语句</param>
/// <returns>返回int</returns>
public static int ExecuteNonQuery(SqlTransaction transaction,string commandText)
{
return SqlHelper.ExecuteNonQuery(transaction, CommandType.Text, commandText);
}
#endregion
#region 执行SQL 文本命令返回(带事务) DataSet
/// <summary>
/// 执行SQL 文本命令返回(带事务) DataSet
/// </summary>
/// <param name="commandText">Sql语句</param>
/// <returns>返回DataSet</returns>
public static DataSet ExecuteDataset(SqlTransaction transaction,string commandText)
{
return SqlHelper.ExecuteDataset(transaction, CommandType.Text, commandText);
}
#endregion
#region 执行SQL 文本命令返回(带事务) DataTable
/// <summary>
/// 执行SQL 文本命令返回(带事务) DataTable
/// </summary>
/// <param name="commandText">Sql语句</param>
/// <returns>返回DataTable</returns>
public static DataTable ExecuteDataTable(SqlTransaction transaction,string commandText)
{
DataSet ds=SqlHelper.ExecuteDataset(transaction, CommandType.Text, commandText);
return ds.Tables[0];
}
#endregion
#region 执行存储过程返回(带事务) int
/// <summary>
/// 执行存储过程返回(带事务) int
/// </summary>
/// <param name="commandProcedureName">Sql语句</param>
/// <param name="commandParameters">存储过程参数</param>
/// <returns>返回int</returns>
public static int ExecuteProcNonQuery(SqlTransaction transaction,string commandProcedureName, ref SqlParameter[] commandParameters)
{
return SqlHelper.ExecuteNonQuery(transaction, CommandType.StoredProcedure, commandProcedureName, commandParameters);
}
#endregion
#region 执行存储过程返回(带事务) DataSet
/// <summary>
/// 执行存储过程返回(带事务) DataSet
/// </summary>
/// <param name="commandProcedureName">Sql语句</param>
/// <param name="commandParameters">存储过程参数</param>
/// <returns>返回DataSet</returns>
public static DataSet ExecuteProcDataset(SqlTransaction transaction,string commandProcedureName, ref SqlParameter[] commandParameters)
{
return SqlHelper.ExecuteDataset(transaction, CommandType.StoredProcedure, commandProcedureName, commandParameters);
}
#endregion
#region 执行存储过程返回(带事务) DataTable
/// <summary>
/// 执行存储过程返回(带事务) DataTable
/// </summary>
/// <param name="commandProcedureName">Sql语句</param>
/// <param name="commandParameters">存储过程参数</param>
/// <returns>返回DataSet</returns>
public static DataTable ExecuteProcDataTable(SqlTransaction transaction,string commandProcedureName, ref SqlParameter[] commandParameters)
{
DataSet ds=SqlHelper.ExecuteDataset(transaction, CommandType.StoredProcedure, commandProcedureName, commandParameters);
return ds.Tables[0];
}
#endregion
}
}