/// <summary>
/// 执行查询返回受首行首列
/// </summary>
/// <param name="connectionString">数据库连接</param>
/// <param name="commandText">sql查询</param>
/// <param name="dbParameters">参数集</param>
/// <param name="commandType">命令分类</param>
/// <returns>object</returns>
public static object ExecuteScalar(string connectionString, string commandText, IDbDataParameter[] dbParameters = null, CommandType commandType = CommandType.Text)
{
object result = null;
var dbHelper = DbHelperFactory.Create(CurrentDbType, connectionString);
result = dbHelper.ExecuteScalar(commandText, dbParameters, commandType);
dbHelper.Close();
return(result);
}
/// <summary>
/// 填充数据表
/// </summary>
/// <param name="connectionString">数据库连接</param>
/// <param name="commandText">sql查询</param>
/// <param name="dbParameters">参数集</param>
/// <param name="commandType">命令分类</param>
/// <returns>数据表</returns>
public static DataTable Fill(string connectionString, string commandText, IDbDataParameter[] dbParameters = null, CommandType commandType = CommandType.Text)
{
var dt = new DataTable("DotNet");
var dbHelper = DbHelperFactory.Create(CurrentDbType, connectionString);
dbHelper.Fill(dt, commandText, dbParameters, commandType);
dbHelper.Close();
return(dt);
}
/// <summary>
/// 制作参数
/// </summary>
/// <param name="targetFiled"></param>
/// <param name="targetValue"></param>
/// <returns></returns>
public static IDbDataParameter MakeParameter(string targetFiled, object targetValue)
{
var dbHelper = DbHelperFactory.Create(CurrentDbType, ConnectionString);
return(dbHelper.MakeParameter(targetFiled, targetValue));
}
/// <summary>
/// 执行查询返回DataReader
/// </summary>
/// <param name="connectionString">数据库连接</param>
/// <param name="commandType">命令分类</param>
/// <param name="commandText">sql查询</param>
/// <param name="dbParameters">参数集</param>
/// <returns>结果集流</returns>
public static IDataReader ExecuteReader(string connectionString, string commandText, IDbDataParameter[] dbParameters = null, CommandType commandType = CommandType.Text)
{
var dbHelper = DbHelperFactory.Create(CurrentDbType, connectionString);
return(dbHelper.ExecuteReader(commandText, dbParameters, commandType));
}
