protected override object DoQuery(Context context)
{
var queryConfig = context.Config;
var handlerConfig = context.HandlerConfig;
if (string.IsNullOrEmpty(queryConfig.Connection))
{
queryConfig.Connection = handlerConfig.Connection;
}
IValueSetter valueSetter = queryConfig.Create();
var datas = SqlExcuter.ExcuteQuery(context, valueSetter);
context.Data = datas;
ExcuteSubQueries(context, queryConfig, valueSetter, datas);
if (!queryConfig.OnlyOne)
{
return(datas);
}
if (datas.Any())
{
return(datas.First());
}
return(new object());
}
protected override object DoQuery(Context context)
{
var queryConfig = context.Config;
var handlerConfig = context.HandlerConfig;
if (string.IsNullOrEmpty(queryConfig.Connection))
{
queryConfig.Connection = handlerConfig.Connection;
}
IValueSetter valueSetter = new ValueSetter.SimpleRecordQueryHandler();
var datas = SqlExcuter.ExcuteQuery(context, valueSetter);
context.Data = datas;
return(datas);
}
protected override object DoUpdate(UpdateContext context)
{
context.Submit();
var queryConfig = context.Config;
var handlerConfig = context.HandlerConfig;
if (string.IsNullOrEmpty(queryConfig.Connection))
{
queryConfig.Connection = handlerConfig.Connection;
}
IValueSetter valueSetter = queryConfig.Create();
var querySql = queryConfig.Config["query_sql"].ToSingleData <string>(string.Empty);
var datas = SqlExcuter.ExcuteQuery(context, valueSetter, querySql);
foreach (var data in datas)
{
context.ContentParams.ReplaceOrInsert(SqlKeyWorld.ComplexData, data);
SqlExcuter.ExcuteTrann(context);
}
return(true);
}
