public void AjouterSelectCount(Requete requete, Type type) { var rr = _connectionFactory.ObtenirNomTable(type); _type = type; _sb = new StringBuilder(); var(parameters, listParamsWhere) = requete.GetWhere(type); _paramsSql = listParamsWhere.ToArray(); _sb.AppendLine($"select count(*) from {_connectionFactory.ObtenirNomTable(_type)}"); }
public void AjouterSelectFrom(Requete request, Type type) { var tt = _connectionFactory.ObtenirNomTable(type); var(dynamicParameters, listParams) = request.GetWhere(type); _type = type; _sb = new StringBuilder(); _objectParameters = dynamicParameters; _paramsSql = listParams.ToArray(); _sortDescriptor = request.Ordres?.FirstOrDefault(); _sb.AppendLine($"select {_type.Sql().GetParamsWithCommas()}"); _sb.AppendLine($"from {_connectionFactory.ObtenirNomTable(type)}"); }
public BuilderCount SelectCount <T>(Requete request) { StartBuiderCount <T>(request); return(_builderCount); }
public SqlBuilder SelectFrom <T>(Requete request) { _builderParams.AjouterSelectFrom(request, typeof(T)); return(this); }
public static (DynamicParameters ObjectParams, List <string> ListParams) GetWhere(this Requete request, Type type) { var dbArgs = new DynamicParameters(); var listParam = new List <string>(); dbArgs.Add("Row", request.GetRow()); dbArgs.Add("PageSize", request.TaillePage); foreach (var filterDesc in request.Filtres) { dbArgs.Add(filterDesc.Membre, filterDesc.Valeur); listParam.Add(GetDescriptor(filterDesc, type)); } return(dbArgs, listParam); }
public async Task <ResultatPagine <TProjection> > ObtenirPagine <TProjection>(Requete requete) { var(sqlSelect, parametersSelect) = _sqlBuilder.GetSelectWithPaging <TProjection>(requete); var(sqlCount, parametersCount) = _sqlBuilder.SelectFullCount <TProjection>(requete); return(new ResultatPagine <TProjection>( data: await Connection.QueryAsync <TProjection>(sqlSelect, parametersSelect), total: await Connection.QuerySingleAsync <int>(sqlCount, parametersCount) )); }