public IEnumerable <T> ExecuteByProcTable <T>(string procName, DbParameter[] dbParameter)
{
if (dbTransaction == null)
{
using (var dbConnection = Connection)
{
DynamicParameters dp = DatabaseCommon.GetDynamicParameter(dbParameter);
return(dbConnection.Query <T>(procName, dp, commandType: CommandType.StoredProcedure));
}
}
else
{
dbTransaction.Connection.Execute(procName, dbParameter, dbTransaction);
return(null);
}
}
public int ExecuteByProc(string procName, params DbParameter[] dbParameter)
{
if (dbTransaction == null)
{
using (var connection = Connection)
{
DynamicParameters dp = DatabaseCommon.GetDynamicParameter(dbParameter);
return(connection.Execute(procName, dp, null, null, CommandType.StoredProcedure));
}
}
else
{
dbTransaction.Connection.Execute(procName, dbParameter, dbTransaction);
return(0);
}
}
public DataTable ExecuteByProcReportTable(string procName, DbParameter[] dbParameter)
{
if (dbTransaction == null)
{
using (var dbConnection = Connection)
{
DynamicParameters dp = DatabaseCommon.GetDynamicParameter(dbParameter);
var IDataReader = new DbHelper(dbConnection).ExecuteReader(CommandType.StoredProcedure, procName, dbParameter);
return(ConvertExtension.IDataReaderToDataTable(IDataReader));
}
}
else
{
dbTransaction.Connection.Execute(procName, dbParameter, dbTransaction);
return(null);
}
}
public int ExecuteByProcReturn(string procName, DbParameter[] dbParameter)
{
if (dbTransaction == null)
{
using (var connection = Connection)
{
DynamicParameters dp = DatabaseCommon.GetDynamicParameter(dbParameter);
dp.Add("@RES", string.Empty, DbType.String, ParameterDirection.ReturnValue);
connection.Execute(procName, dp, null, null, CommandType.StoredProcedure);
return(dp.Get <int>("@RES"));
}
}
else
{
dbTransaction.Connection.Execute(procName, dbParameter, dbTransaction);
return(0);
}
}
/// <summary>
/// 实体插入dapper作实现
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="entity"></param>
/// <returns></returns>
public int Insert <T>(T entity, string NotUpdateColName = "") where T : class
{
return(ExecuteBySql(DatabaseCommon.InsertSql <T>(entity, NotUpdateColName).ToString(), DatabaseCommon.GetDynamicParameter <T>(entity)));
}