Пример #1
0
        public async Task <Dictionary <string, int> > Get()
        {
            List <Dictionary <string, int> > list = new List <Dictionary <string, int> >();
            DateTime dt     = DateTime.Now;
            var      zjList = await _d_alarm_infoServices.Query(a => a.AlarmTime > dt.Date && a.AlarmTypeID == 2);

            var jgList = await _d_alarm_infoServices.Query(a => a.AlarmTime > dt.Date && a.AlarmTypeID == 14);

            var handList = await _HandAlarmServices.Query(a => Convert.ToDateTime(a.time) > dt.Date);

            Dictionary <string, int> dc = new Dictionary <string, int>();

            dc.Add("dayzj", zjList.Count);
            dc.Add("dayjg", jgList.Count);
            dc.Add("dayhand", handList.Count);
            DateTime temp  = new DateTime(dt.Year, dt.Month, dt.Day);
            int      count = dt.DayOfWeek - DayOfWeek.Monday;

            if (count == -1)
            {
                count = 6;
            }
            temp.AddDays(-count);
            DateTime week = Convert.ToDateTime(temp.AddDays(-count).ToString("yyyy-MM-dd 00:00:00"));

            zjList = await _d_alarm_infoServices.Query(a => a.AlarmTime > week && a.AlarmTypeID == 2);

            jgList = await _d_alarm_infoServices.Query(a => a.AlarmTime > week && a.AlarmTypeID == 14);

            handList = await _HandAlarmServices.Query(a => Convert.ToDateTime(a.time) > week);

            dc.Add("weekzj", zjList.Count);
            dc.Add("weekjg", jgList.Count);
            dc.Add("weekhand", handList.Count);
            DateTime month = Convert.ToDateTime(dt.AddDays(1 - dt.Day).ToString("yyyy-MM-dd 00:00:00"));

            zjList = await _d_alarm_infoServices.Query(a => a.AlarmTime > month && a.AlarmTypeID == 2);

            jgList = await _d_alarm_infoServices.Query(a => a.AlarmTime > month && a.AlarmTypeID == 14);

            handList = await _HandAlarmServices.Query(a => Convert.ToDateTime(a.time) > month);

            dc.Add("monthzj", zjList.Count);
            dc.Add("monthjg", jgList.Count);
            dc.Add("monthhand", handList.Count);
            return(dc);
        }
Пример #2
0
 public async Task <List <HandAlarm> > Get()
 {
     return(await _HandAlarmServices.Query("", "time desc"));
 }