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