public override int Query(MapperCommand command)
{
int num;
SqlParameter[] dbParameter = command.Parameter.ToDbParameter <SqlParameter>();
using (SqlConnection sqlConnection = new SqlConnection(this.connectionString))
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand();
bool flag = false;
SqlHelper.PrepareCommand(sqlCommand, sqlConnection, null, (System.Data.CommandType)command.Type, command.Text, dbParameter, out flag);
if (command.Timeout > SqlHelper.CommandTimeout)
{
sqlCommand.CommandTimeout = command.Timeout;
}
int num1 = sqlCommand.ExecuteNonQuery();
sqlCommand.Parameters.Clear();
if (flag)
{
sqlConnection.Close();
}
if (command.Type != Test.Core.CommandType.Text)
{
this.UpdateParameter(command.Parameter, dbParameter);
}
num = num1;
}
return(num);
}
public MapperCommand AddCommand(MapperCommand command)
{
this.commands.Add(command);
if (this.noCombine)
{
command.Query();
}
return(command);
}
public static MapperCommand GetCommand(MapperProvider provider, string commandId, params object[] source)
{
CommandItem item = CommandRepository.Instance[commandId];
if (item == null)
{
throw new Exception(string.Concat(commandId, " not exist mapper command"));
}
return(MapperCommand.GetCommand(provider, item, source));
}
public static MapperCommand GetCommand(string commandId, params object[] source)
{
CommandItem item = CommandRepository.Instance[commandId];
if (item == null)
{
throw new Exception(string.Concat(commandId, " not exist mapper command"));
}
return(MapperCommand.GetCommand((string.IsNullOrEmpty(item.Provider) ? MapperProvider.DefaultProvider : MapperProvider.CreateProvider(item.Provider)), item, source));
}
public override object QueryForScalar(MapperCommand command)
{
SqlParameter[] dbParameter = command.Parameter.ToDbParameter <SqlParameter>();
object obj = SqlHelper.ExecuteScalar(this.connectionString, (System.Data.CommandType)command.Type, command.Text, dbParameter);
if (command.Type != Test.Core.CommandType.Text)
{
this.UpdateParameter(command.Parameter, dbParameter);
}
return(obj);
}
public override ValueSet QueryForValueSet(MapperCommand command)
{
SqlParameter[] dbParameter = command.Parameter.ToDbParameter <SqlParameter>();
ValueSet valueSet = SqlHelper.ExecuteDataset(this.connectionString, (System.Data.CommandType)command.Type, command.Text, dbParameter);
if (command.Type != Test.Core.CommandType.Text)
{
this.UpdateParameter(command.Parameter, dbParameter);
}
return(valueSet);
}
public static MapperCommand GetTextCommand(MapperProvider provider, string text, params object[] source)
{
if (provider == null)
{
provider = MapperProvider.DefaultProvider;
}
List <ParameterSource> parameterSources = MapperCommand.ConvertParameterSource(provider, source);
MapperCommand mapperCommand = new MapperCommand(provider)
{
parameterSource = parameterSources,
Type = Test.Core.CommandType.Text,
Text = text
};
mapperCommand.BuildCommand();
return(mapperCommand);
}
private static MapperCommand GetCommand(MapperProvider provider, CommandItem item, params object[] source)
{
if (provider == null)
{
provider = MapperProvider.DefaultProvider;
}
List <ParameterSource> parameterSources = MapperCommand.ConvertParameterSource(provider, source);
MapperCommand mapperCommand = new MapperCommand(provider)
{
commandId = item.Id,
parameterSource = parameterSources,
Type = item.Type,
Text = item.GetParameterMatchText(parameterSources),
Result = item.ResultType,
Timeout = item.Timeout
};
mapperCommand.BuildCommand();
return(mapperCommand);
}
public MapperCommand AddCommand(string commandId, params object[] source)
{
MapperCommand command = MapperCommand.GetCommand(this.mapper.Provider, commandId, source);
return(this.AddCommand(command));
}
public MapperCommand GetCommand(string commandId, params object[] source)
{
return(MapperCommand.GetCommand(this.Provider, commandId, source));
}
public static ValueTable QueryForValueTable(MapperProvider provider, string commandId, params object[] param)
{
return(MapperCommand.GetCommand(provider, commandId, param).QueryForValueTable());
}
public static T QueryForScalar <T>(MapperProvider provider, string commandId, params object[] param)
{
return((T)MapperCommand.GetCommand(provider, commandId, param).QueryForScalar());
}
public static int Query(MapperProvider provider, string commandId, params object[] param)
{
return(MapperCommand.GetCommand(provider, commandId, param).Query());
}
public abstract object QueryForScalar(MapperCommand command);
public MapperCommand AddSpCommand(string sptext, params object[] source)
{
MapperCommand spCommand = MapperCommand.GetSpCommand(this.mapper.Provider, sptext, source);
return(this.AddCommand(spCommand));
}
public ValueRow QueryForValueRow(MapperCommand command)
{
return(this.QueryForValueSet(command).FirstRow());
}
public ValueTable QueryForValueTable(MapperCommand command)
{
return(this.QueryForValueSet(command).Tables[0]);
}
public abstract ValueSet QueryForValueSet(MapperCommand command);
public MapperCommand AddTextCommand(string text, params object[] source)
{
MapperCommand textCommand = MapperCommand.GetTextCommand(this.mapper.Provider, text, source);
return(this.AddCommand(textCommand));
}
public abstract int Query(MapperCommand command);