public DataSet ExecuteQuery(string sql, IQueryParameter parameter)
{
using (var command = GetCommand())
{
command.Connection = _connection;
command.CommandText = sql;
foreach (var item in parameter.Get())
{
command.Parameters.Add(GetParameter(item));
}
return(FillDataSet(command));
}
}
public void ExecuteCommand(string sql, IQueryParameter parameter)
{
using (var command = GetCommand())
{
command.Connection = _connection;
command.CommandText = sql;
foreach (var item in parameter.Get())
{
command.Parameters.Add(GetParameter(item));
}
command.ExecuteNonQuery();
}
}
