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);