public override async Task <int> InternalExecuteAsync(DbQueryResult param)
{
OpenDb();
var dynamicParameters = ChangeDynamicParameters(param.SqlParameters);
var result = await dbConnection.ExecuteAsync(param.Sql, dynamicParameters, dbTransaction);
CloseDb();
return(result);
}
public override int InternalExecute(DbQueryResult param)
{
OpenDb();
var dynamicParameters = ChangeDynamicParameters(param.SqlParameters);
var result = dbConnection.Execute(param.Sql, dynamicParameters, dbTransaction);
CloseDb();
return(result);
}
public override List <TResult> InternalQueryList <TResult>(DbQueryResult param)
{
OpenDb();
var dynamicParameters = ChangeDynamicParameters(param.SqlParameters);
var result = dbConnection.Query <TResult>(param.Sql, dynamicParameters, dbTransaction).ToList();
CloseDb();
return(result);
}
public override TResult InternalQuery <TResult>(DbQueryResult param)
{
OpenDb();
var dynamicParameters = ChangeDynamicParameters(param.SqlParameters);
var result = dbConnection.QueryFirstOrDefault <TResult>(param.Sql, dynamicParameters, dbTransaction);
CloseDb();
return(result);
//return result.FirstOrDefault();
}
public async Task <T> GetAsync(dynamic id)
{
DbQueryResult internalResult = InternalGet(id);
OpenDb();
var dynamicParameters = ChangeDynamicParameters(internalResult.SqlParameters);
var result = await dbConnection.QueryFirstOrDefaultAsync <T>(internalResult.Sql, dynamicParameters, transaction : dbTransaction);
CloseDb();
return(result);
}
public override Page <TResult> InternalQueryPage <TResult>(DbQueryResult param)
{
OpenDb();
var dynamicParameters = ChangeDynamicParameters(param.SqlParameters);
var count = dbConnection.QueryFirst <int>(param.CountSql, dynamicParameters, dbTransaction);
var item = dbConnection.Query <TResult>(param.Sql, dynamicParameters, dbTransaction);
CloseDb();
var result = new Page <TResult>()
{
Data = item.ToList(),
TotalPages = count
};
return(result);
}