public static DbDataReader ExecuteReader(string commandTextOrSpName, CommandType commandType, IDictionary <string, object> dictionary)
{
//sqlDataReader不能用using 会关闭conn 导致不能获取到返回值。注意：DataReader获取值时必须保持连接状态
SqlConnection_RW conn = new SqlConnection_RW(DbType, ConnString_R, ConnString_RW);
DbCommandCommon cmd = new DbCommandCommon(DbType);
PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType, dictionary);
return(cmd.DbCommand.ExecuteReader(CommandBehavior.CloseConnection));
}
public static int ExecuteNonQuery(string commandTextOrSpName, CommandType commandType, IDictionary <string, object> dictionary)
{
using (SqlConnection_RW conn = new SqlConnection_RW(DbType, ConnString_RW))
{
using (DbCommandCommon cmd = new DbCommandCommon(DbType))
{
PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType, dictionary);//参数增加了commandType 可以自己编辑执行方式
return(cmd.DbCommand.ExecuteNonQuery());
}
}
}
public static int ExecuteNonQuery(string commandTextOrSpName, CommandType commandType = CommandType.Text)
{
using (SqlConnection_RW conn = new SqlConnection_RW(DbType, ConnString_RW))
{
using (DbCommandCommon cmd = new DbCommandCommon(DbType))
{
PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType);
return(cmd.DbCommand.ExecuteNonQuery());
}
}
}
public static Task <object> ExecuteScalarAsync(string commandTextOrSpName, CommandType commandType, IDictionary <string, object> dictionary)
{
using (SqlConnection_RW conn = new SqlConnection_RW(DbType, ConnString_R, ConnString_RW))
{
using (DbCommandCommon cmd = new DbCommandCommon(DbType))
{
PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType, dictionary);
return(cmd.DbCommand.ExecuteScalarAsync());
}
}
}
public static void BatchExecuteNonQuery(IEnumerable <BatchExecuteModel> batchExecuteModels)
{
using (SqlConnection_RW conn = new SqlConnection_RW(DbType, ConnString_RW))
{
using (DbCommandCommon cmd = new DbCommandCommon(DbType))
{
foreach (var item in batchExecuteModels)
{
PreparCommand(conn.DbConnection, cmd.DbCommand, item.CommandTextOrSpName, item.CommandType, item.ParamsDic);
cmd.DbCommand.ExecuteNonQuery();
}
}
}
}
public static DataSet ExecuteDataSet(string commandTextOrSpName, CommandType commandType, IDictionary <string, object> dictionary)
{
using (SqlConnection_RW conn = new SqlConnection_RW(DbType, ConnString_R, ConnString_RW))
{
using (DbCommandCommon cmd = new DbCommandCommon(DbType))
{
PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType, dictionary);
using (DbDataAdapterCommon da = new DbDataAdapterCommon(DbType, cmd.DbCommand))
{
DataSet ds = new DataSet();
da.Fill(ds);
return(ds);
}
}
}
}
/**
* Update At 2017-3-2 14:58:45
* Add the ExecuteDataTable Method into Sql_Helper_DG
**/
public static DataTable ExecuteDataTable(string commandTextOrSpName, CommandType commandType = CommandType.Text)
{
using (SqlConnection_RW conn = new SqlConnection_RW(DbType, ConnString_R, ConnString_RW))
{
using (DbCommandCommon cmd = new DbCommandCommon(DbType))
{
PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType);
using (DbDataAdapterCommon da = new DbDataAdapterCommon(DbType, cmd.DbCommand))
{
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
return(default(DataTable));
}
}
}
}