async public Task <Varsis.Data.Infrastructure.Pagination> TotalLinhas(long?size, List <Criteria> criterias) { List <string> filter = new List <string>(); int cont = 0; if (criterias?.Count != 0) { foreach (var c in criterias) { cont++; string field = _FieldMap[c.Field]; string type = _FieldType[c.Field]; if (type == "T") { filter.Add($"{field} {c.Operator.ToLower()} '{c.Value}'"); } else if (type == "N") { filter.Add($"{field} {c.Operator.ToLower()} {c.Value}"); } } } Varsis.Data.Infrastructure.Pagination page = new Varsis.Data.Infrastructure.Pagination(); string query = Global.MakeODataQuery("NFModels/$count", null, filter.Count == 0 ? null : filter.ToArray(), null, 1, 0); string data = await _serviceLayerConnector.getQueryResult(query); page.Linhas = Convert.ToInt64(data); page.Paginas = (Convert.ToInt64(data) / size.Value) + 1; page.qtdPorPagina = size.Value == 0 ? Convert.ToInt64(data) : size.Value; return(page); }
async public Task <Varsis.Data.Infrastructure.Pagination> TotalLinhas(long?size, List <Criteria> criterias) { Varsis.Data.Infrastructure.Pagination page = new Varsis.Data.Infrastructure.Pagination(); //string query = Global.MakeODataQuery("U_VSITENTIDADECONT/$count", null, filter.Count == 0 ? null : filter.ToArray(), null, 1, 0); //string data = await _serviceLayerConnector.getQueryResult(query); //page.Linhas = Convert.ToInt64(data); //page.Paginas = (Convert.ToInt64(data) / size.Value) + 1; //page.qtdPorPagina = size.Value == 0 ? Convert.ToInt64(data) : size.Value; return(page); }