Пример #1
0
        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);
        }
Пример #2
0
 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);
 }