protected override bool Execute(IIntegrationResult result)
{
result.BuildProgressInformation.SignalStartRunTask("Executing TqDBExecutor");
var ado = SpringContextHelper.GetAdoTemplate(Provider, ConnectionString);
ado.ExecuteNonQuery(System.Data.CommandType.Text, Query);
return(true);
}
public void Test()
{
var ado = SpringContextHelper.GetAdoTemplate("System.Data.SqlClient", "SERVER=192.168.1.45 ;DATABASE=adprintNewDB;USER ID=web; PASSWORD=xlzns!@#0");
var list = ado.QueryWithRowMapper(System.Data.CommandType.Text, "SELECT * FROM Joiner", new StringDictionaryMapper());
}
private IList <Dictionary <string, object> > GetData()
{
var ado = SpringContextHelper.GetAdoTemplate(Provider, ConnectionString);
return(ado.QueryWithRowMapper(System.Data.CommandType.Text, Query, new StringDictionaryMapper()));
}
