/// <summary>
/// 异步执行带有参数的存储过程方法 增删改操作以及返回带有输出的参数
/// </summary>
/// <param name="db"></param>
/// <param name="sql"></param>
/// <param name="sqlParams"></param>
/// <returns></returns>
public async static Task <int> ExecuteNonQueryAsync(FirstServerDbcontext db, string sql, SqlParameter[] sqlParams)
{
int numint;
var connection = db.Database.GetDbConnection();
using (var cmd = connection.CreateCommand())
{
await db.Database.OpenConnectionAsync();
cmd.CommandText = sql;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddRange(sqlParams);
numint = await cmd.ExecuteNonQueryAsync();
}
return(numint);
}
public S_HandleMarkData(ILogger <S_HandleMarkData> logger, Data.FirstServerDbcontext firstServerDbcontext)
{
Logger = logger;
FirstServerDbcontext = firstServerDbcontext;
}
