Beispiel #1
0
        public string QueryLog(int page, int rows)
        {
            var now = DateTime.Now;
            var vm  = LoggingTo.Query(now.AddYears(-5), now, page, rows);

            return(new
            {
                data = vm.Data,
                total = vm.Total,
                lost = vm.Lost
            }.ToJson());
        }
Beispiel #2
0
        public string QueryLog(int page, int rows, string wheres)
        {
            var now = DateTime.Now;
            List <List <string> > listWhere = new();

            try
            {
                if (!string.IsNullOrWhiteSpace(wheres))
                {
                    var jws = JArray.Parse(wheres);
                    foreach (var wi in jws)
                    {
                        var w1 = wi[0]?.ToString();
                        var w2 = wi[1]?.ToString();
                        var w3 = wi[2]?.ToString();
                        if (!string.IsNullOrWhiteSpace(w2) && !string.IsNullOrWhiteSpace(w3))
                        {
                            listWhere.Add(new List <string> {
                                w1, w2, w3
                            });
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex);
                listWhere = null;
            }

            var vm = LoggingTo.Query(now.AddYears(-5), now, page, rows, listWhere);

            return(new
            {
                data = vm.Data,
                total = vm.Total,
                lost = vm.Lost
            }.ToJson());
        }