/// <summary>
/// 执行Sql，返回物件
/// </summary>
/// <param name="sSql">SQL</param>
/// <returns></returns>
protected object ExecuteScalar(string Sql, IDbTransaction Atran)
{
// 实例化命令
IDbCommand NewCommand = CommandUnit.NewCommand(Sql, Atran.Connection, Atran);
// 加入参数
NewCommand.AddParameters(this.Parameter);
return(NewCommand.ExeScalar());
}
/// <summary>
/// 查询结果集
/// </summary>
/// <param name="sSql">SQL</param>
/// <param name="tran">tran事务</param>
/// <returns></returns>
/// <remarks></remarks>
protected DataSet SearchDataSet(string Sql, IDbTransaction tran)
{
// 实例化命令
IDbCommand NewCommand = CommandUnit.NewCommand(Sql, tran.Connection, tran);
// 加入参数
NewCommand.AddParameters(this.Parameter);
// 返回结果集
return(NewCommand.SearchDataSet());
}
/// <summary>
/// 执行Sql，返回影响行数
/// </summary>
/// <param name="Sql">Sql</param>
/// <param name="ATans">事务</param>
/// <returns></returns>
protected int ExeNonQuery(string Sql, IDbTransaction ATans)
{
// 实例化命令
IDbCommand NewCommand = CommandUnit.NewCommand(Sql, ATans.Connection, ATans);
// 加入参数
NewCommand.AddParameters(this.Parameter);
// 返回结果
return(NewCommand.ExeNonQuery());
}
/// <summary>
/// 执行Sql，返回影响行数
/// </summary>
/// <param name="sSql">SQL</param>
/// <returns></returns>
protected int ExecuteNonQueryByAtt(string Sql)
{
using (IDbConnection AConnection = this.OpenConnection())
{
IDbCommand NewCommand = CommandUnit.NewCommand(Sql, AConnection);
NewCommand.AddParameters(this.Parameter);
return(NewCommand.ExeNonQuery());
}
}
/// <summary>
/// 查询结果集
/// </summary>
/// <param name="Sql">SQL</param>
/// <returns></returns>
protected DataSet SearchDataSet(string Sql)
{
using (IDbConnection AConnection = this.OpenConnection())
{
// 实例化命令
IDbCommand NewCommand = CommandUnit.NewCommand(Sql, AConnection);
// 加入参数
NewCommand.AddParameters(this.Parameter);
// 返回结果集
return(NewCommand.SearchDataSet());
}
}
/// <summary>
/// 执行Sql，返回物件
/// </summary>
/// <param name="Sql">Sql</param>
/// <param name="bPrepare">是否要预编译</param>
/// <returns></returns>
protected object ExecuteScalar(string Sql, bool bPrepare)
{
using (IDbConnection AConnection = this.OpenConnection())
{
// 實例化命令
IDbCommand NewCommand = CommandUnit.NewCommand(Sql, AConnection);
// 加入參數
NewCommand.AddParameters(this.Parameter);
// 返回結果物件
return(NewCommand.ExeScalar());
}
}
/// <summary>
/// 执行Sql，返回影响行数
/// </summary>
/// <param name="Sql">Sql</param>
/// <param name="bPrepare">是否要预编译</param>
/// <returns></returns>
protected int ExeNonQuery(string Sql, bool bPrepare)
{
using (IDbConnection AConnection = this.OpenConnection())
{
// 实例化命令
IDbCommand NewCommand = CommandUnit.NewCommand(Sql, AConnection);
// 加入参数
NewCommand.AddParameters(this.Parameter);
// 返回结果
return(NewCommand.ExeNonQuery());
}
}
/// <summary>
/// 执行Sql，返回Reader物件
/// </summary>
/// <param name="sSql">Sql</param>
/// <param name="bPrepare">是否要预编译</param>
/// <returns></returns>
protected IDataReader ExecuteReader(string Sql, bool bPrepare)
{
// 实例化并开启连接
using (IDbConnection AConnection = this.OpenConnection())
{
// 实例化命令
IDbCommand NewCommand = CommandUnit.NewCommand(Sql, AConnection);
// 加入参数
NewCommand.AddParameters(this.Parameter);
// 返回Reader
return(NewCommand.ExeReader(CommandBehavior.CloseConnection));
}
}
/// <summary>
/// 使用StoredProcedure查询结果集
/// </summary>
/// <param name="spName">SP名称</param>
/// <returns></returns>
protected DataTable ExecuteSP(string spName)
{
using (IDbConnection AConnection = this.OpenConnection())
{
// 实例化命令
IDbCommand NewCommand = CommandUnit.NewCommand(AConnection);
// 存储过程命令类型
NewCommand.CommandType = CommandType.StoredProcedure;
// 命令文本
NewCommand.CommandText = spName;
// 加入参数
NewCommand.AddParameters(this.Parameter);
// 返回结果集
return(NewCommand.Search());
}
}
/// <summary>
/// 使用StoredProcedure查询结果集
/// </summary>
/// <param name="spName">SP名称</param>
/// <returns></returns>
protected int ExecuteNonQuerySP(string spName)
{
using (IDbConnection AConnection = this.OpenConnection())
{
// 实例化命令
IDbCommand newCommand = CommandUnit.NewCommand(AConnection);
// 存储过程类型
newCommand.CommandType = CommandType.StoredProcedure;
// 存储过程名称
newCommand.CommandText = spName;
// 加入参数
newCommand.AddParameters(this.Parameter);
// 返回结果
return(newCommand.ExeNonQuery());;
}
}
