/// <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)); }