public Task <IEnumerable <dynamic> > GetByConditions(string tableName, ISelectRequest request)
{
var whereSql = _pageSqlHelper.OutDefaultParams(request.Queries, out var whereParams);
var sql =
$"SELECT * FROM {tableName} WHERE 1=1 {whereSql} {request.Sort?.ToSql()} {(request.TopCount > 0 ? $"limit 0,{request.TopCount}" : "")} ";
return(Connection().QueryAsync(sql, whereParams));
}
public async Task <IEnumerable <dynamic> > GetByConditions(ISelectRequest request)
{
var columnField = request.GetQueryField("columnNum");
if (columnField == null || columnField.Value.ToStr().IsEmpty())
{
return(null);
}
var cm = await _columnService.GetModelByNum(columnField.Value.ToStr());
if (cm == null)
{
return(null);
}
return(await GetByConditions(cm?.ModelTable.SqlTableName, request));
}
public async Task <ContentData> GetFirstByColumnNum(string columnNum, ISelectRequest request)
{
var columnModel = await _columnService.GetModelByNum(columnNum);
if (columnModel == null)
{
return(null);
}
request?.Queries.Add(new DefaultQuery(columnNum, new DefaultQuerySql("ColumnNum")));
var list = (await _dapper.GetByConditions(columnModel?.ModelTable.SqlTableName, request)).ToList();
if (list.Count > 0)
{
return(list[0] != null ? new ContentData(list[0]) : null);
}
return(null);
}
public Task <IEnumerable <dynamic> > GetByConditions(string tableName, ISelectRequest request)
{
return(_dapper.GetByConditions(tableName, request));
}
