示例#1
0
        public List <DoorClick> GetListByCondition(DateTime dtBeginTime, DateTime dtEndTime, string doorIndexCode)
        {
            string[]       doorIndexCodes = new string[] { doorIndexCode };
            DoorSearchArgs args           = new DoorSearchArgs();
            DateTime       now            = new DateTime();

            if (dtBeginTime != null || dtEndTime != null)
            {
                args.startTime = dtBeginTime.ToString("yyyy-MM-ddTHH:mm:sszzz");
                args.endTime   = dtEndTime.ToString("yyyy-MM-ddTHH:mm:sszzz");
            }
            else
            {
                args.startTime = now.AddMonths(-1).ToString("yyyy-MM-ddTHH:mm:sszzz");
                args.endTime   = now.ToString("yyyy-MM-ddTHH:mm:sszzz");
            }
            args.doorIndexCodes = doorIndexCodes;
            args.pageNo         = 1;
            args.pageSize       = 100000;
            args.eventType      = "198914";
            return(GetPageByCondition(args).list);
        }
示例#2
0
 public DataDoor GetPageByCondition(DoorSearchArgs args)
 {
     return(service.GetPageByCondition(args));
 }
示例#3
0
        public DataDoor GetPageByCondition(DoorSearchArgs args)
        {
            //时间要传格林尼治时间
            DataDoor data = new DataDoor();

            try
            {
                DoorSearchArgs arg = args;
                arg.eventType = "198914";
                DateTime now = DateTime.Now;
                if (args == null)
                {
                    arg                = new DoorSearchArgs();
                    arg.startTime      = now.AddMonths(-1).ToString("yyyy-MM-dd HH:mm:ss");
                    arg.endTime        = now.ToString("yyyy-MM-dd HH:mm:ss");
                    arg.pageNo         = 1;
                    arg.pageSize       = 100;
                    arg.doorIndexCodes = null;
                    arg.personIds      = null;
                    arg.eventType      = "198914";
                }
                else
                {
                    if (string.IsNullOrEmpty(arg.startTime) || string.IsNullOrEmpty(arg.endTime))
                    {
                        arg.startTime = now.AddMonths(-1).ToString("yyyy-MM-dd HH:mm:ss");
                        arg.endTime   = now.ToString("yyyy-MM-dd HH:mm:ss");
                    }
                    if (arg.pageSize == 0)
                    {
                        arg.pageSize = 1000000;
                    }
                    if (arg.pageNo == 0)
                    {
                        arg.pageNo = 1;
                    }
                    if (string.IsNullOrEmpty(arg.eventType))
                    {
                        arg.eventType = "198914";
                    }
                }

                DateTime startTimeT;
                DateTime endTimeT;
                DateTime.TryParse(arg.startTime, out startTimeT);
                DateTime.TryParse(arg.endTime, out endTimeT);

                //对接部分:暂时注释
                ////DoorEvents doorEvents = getDoorEvents(arg.startTime.ToString("yyyy-MM-ddTHH:mm:sszzz"), arg.endTime.ToString("yyyy-MM-ddTHH:mm:sszzz"), arg.pageNo.ToString(), arg.pageSize.ToString(), arg.eventType, arg.personIds, arg.doorIndexCodes,arg.personName);
                DoorEvents doorEvents = getDoorEvents(startTimeT.ToString("yyyy-MM-ddTHH:mm:sszzz"), endTimeT.ToString("yyyy-MM-ddTHH:mm:sszzz"), arg.pageNo.ToString(), arg.pageSize.ToString(), arg.eventType, arg.personIds, arg.doorIndexCodes, arg.personName);
                if (doorEvents != null && doorEvents.data != null)
                {
                    data = doorEvents.data;
                }

                if (data.list == null)//从数据库获取
                {
                    //PageInfo<DoorClick> page = db.DoorClicks.GetPageByCondition(arg.startTime, arg.endTime, arg.eventType, arg.personIds, arg.doorIndexCodes,arg.personName, arg.pageNo, arg.pageSize);
                    PageInfo <DoorClick> page = db.DoorClicks.GetPageByCondition(startTimeT, endTimeT, arg.eventType, arg.personIds, arg.doorIndexCodes, arg.personName, arg.pageNo, arg.pageSize);
                    data.total     = page.total;
                    data.totalPage = page.totalPage;
                    data.list      = page.data;
                    data.pageNo    = page.pageIndex;
                    data.pageSize  = page.pageSize;
                }
            }
            catch (Exception ex)
            {
                Log.Error("DoorClickService.GetListByCondition:" + ex.ToString());
            }

            return(data);
        }