/// <summary> /// 执行语句 /// </summary> /// <param name="ado">数据库访问对象</param> /// <param name="cmdType">命令类型</param> /// <param name="cmdText">命令</param> /// <param name="models">模型</param> /// <returns></returns> public async static Task <int> ExecuteNonQueryWithModelsAsync(this IAdo ado, System.Data.CommandType cmdType, string cmdText, params object[] models) { var parameters = models.GetParametersFromModels(); var result = await ado.ExecuteNonQueryAsync(cmdType, cmdText, parameters.AllParameters); models.SetOutputParametersValueToModels(parameters.OutputParameters); return(result); }
/// <summary> /// 执行语句 /// </summary> /// <param name="ado">数据库访问对象</param> /// <param name="cmdType">命令类型</param> /// <param name="cmdText">命令</param> /// <param name="parameters">参数</param> /// <returns></returns> public async static Task <int> ExecuteNonQueryAsync(this IAdo ado, System.Data.CommandType cmdType, string cmdText, params DbParameter[] parameters) { return(await ado.ExecuteNonQueryAsync(cmdType, cmdText, parameters)); }
/// <summary> /// 执行存储过程 /// </summary> /// <param name="ado">数据库访问对象</param> /// <param name="name">存储过程名称</param> /// <param name="parameters">参数</param> /// <returns></returns> public async static Task <int> ExecuteStoredProcedureAsync(this IAdo ado, string name, params DbParameter[] parameters) { return(await ado.ExecuteNonQueryAsync(System.Data.CommandType.StoredProcedure, name, parameters)); }
/// <summary> /// 执行语句 /// </summary> /// <param name="ado">数据库访问对象</param> /// <param name="name">存储过程名称</param> /// <param name="parameters">参数</param> /// <returns></returns> public static int ExecuteNonQuery(this IAdo ado, string name, params DbParameter[] parameters) { return(ado.ExecuteNonQueryAsync(name, parameters).GetAwaiter().GetResult()); }