Exemplo n.º 1
0
        /// <summary>
        /// 資料個數取得
        /// </summary>
        /// <param name="option">資料查詢參數</param>
        /// <param name="condition">查詢條件</param>
        /// <param name="parms">其他傳入參數</param>
        /// <returns></returns>
        public int GetCount(QueryOption option, T condition = null, params string[] parms)
        {
            var context = QueryContextFactory.CreateInstance <T>(option);

            DataQuery(context.Main, option, condition, parms);
            return(context.GetCount());
        }
Exemplo n.º 2
0
        /// <summary>
        /// 實體集合取得
        /// </summary>
        /// <param name="option">資料查詢參數</param>
        /// <param name="condition">查詢條件</param>
        /// <param name="parms">其他傳入參數</param>
        /// <returns></returns>
        public IEnumerable <T> GetList(QueryOption option, T condition = null, params string[] parms)
        {
            var context = QueryContextFactory.CreateInstance <T>(option);

            DataQuery(context.Main, option, condition, parms);
            DataPagerSort(context.Main, option);
            return(context.GetEntities());
        }
Exemplo n.º 3
0
        /// <summary>
        /// 待通知檢查監控資訊清單取得
        /// </summary>
        /// <returns></returns>
        public IEnumerable <Monitor> GetNotificationMonitors()
        {
            var context   = QueryContextFactory.CreateInstance <Monitor>();
            var condition = new QueryCondition
            {
                PropertyName = "IS_NOTIFICATION",
                Type         = OperatorType.ISNULL
            };

            context.Main.Query("IS_NOTIFICATION", OperatorType.ISNULL, new List <object>());

            return(context.GetEntities());
        }
Exemplo n.º 4
0
        /// <summary>
        /// 通知記錄取得
        /// </summary>
        /// <param name="condition">查詢條件</param>
        /// <returns></returns>
        public Notification GetRecord(Notification condition)
        {
            var context = QueryContextFactory.CreateInstance <Notification>();
            var orders  = new List <UserOrder>
            {
                new UserOrder
                {
                    PropertyName = "NOTIFICATION_SN",
                    Type         = OrderType.DESC
                }
            };

            context.Main.Query(condition)
            .OrderBy(orders)
            .Pager(1, 1);

            return(context.GetEntity());
        }
Exemplo n.º 5
0
        /// <summary>
        /// 前次監控資訊取得
        /// </summary>
        /// <param name="monitor">目前監控資訊</param>
        /// <returns></returns>
        public Monitor GetPreviousMonitor(Monitor monitor)
        {
            var context = QueryContextFactory.CreateInstance <Monitor>();

            var condition = new Monitor
            {
                DEVICE_SN   = monitor.DEVICE_SN,
                TARGET_NAME = monitor.TARGET_NAME
            };
            var query = new List <QueryCondition>
            {
                new QueryCondition
                {
                    PropertyName = "RECORD_SN",
                    Type         = OperatorType.LessThan,
                    Values       = new List <object> {
                        monitor.RECORD_SN
                    }
                }
            };
            var orders = new List <UserOrder>
            {
                new UserOrder
                {
                    PropertyName = "RECORD_SN",
                    Type         = OrderType.DESC
                }
            };

            context.Main.Query(condition)
            .UserQuery(query)
            .OrderBy(orders)
            .Pager(1, 1);

            return(context.GetEntity());
        }