Example #1
0
        /// <summary>
        /// 获取跨库查询所需的表达式
        /// </summary>
        /// <returns></returns>
        protected override DisPageEntity <HeartbeatEntity> GetDisPageEntity(HeartbeatEntityParams paramz)
        {
            DisPageEntity <HeartbeatEntity> disPageEntity = new DisPageEntity <HeartbeatEntity>();

            disPageEntity.InCondition = (entities) =>
            {
                List <long?> keys = entities.Select(a => a.Id).ToList();
                return(a => keys.Contains(a.Id));
            };
            HeartbeatEntityOrderBy orderBy = paramz.orderByAsc;

            if (orderBy != null)
            {
                disPageEntity.OrderType = true;
                if (orderBy.Id)
                {
                    disPageEntity.OrderCol           = a => a.Id;
                    disPageEntity.OrderColLazy       = a => a.Id;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.Id) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.Id) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.Id) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.Id) >= 0;
                    return(disPageEntity);
                }
                if (orderBy.LastHeartbeatTime)
                {
                    disPageEntity.OrderCol           = a => a.LastHeartbeatTime;
                    disPageEntity.OrderColLazy       = a => a.LastHeartbeatTime;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id, LastHeartbeatTime = a.LastHeartbeatTime
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.LastHeartbeatTime) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.LastHeartbeatTime) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.LastHeartbeatTime) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.LastHeartbeatTime) >= 0;
                    return(disPageEntity);
                }
                if (orderBy.RobotMac)
                {
                    disPageEntity.OrderCol           = a => a.RobotMac;
                    disPageEntity.OrderColLazy       = a => a.RobotMac;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id, RobotMac = a.RobotMac
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.RobotMac) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.RobotMac) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.RobotMac) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.RobotMac) >= 0;
                    return(disPageEntity);
                }
                if (orderBy.Remark)
                {
                    disPageEntity.OrderCol           = a => a.Remark;
                    disPageEntity.OrderColLazy       = a => a.Remark;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id, Remark = a.Remark
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.Remark) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.Remark) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.Remark) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.Remark) >= 0;
                    return(disPageEntity);
                }
                if (orderBy.ExtendField)
                {
                    disPageEntity.OrderCol           = a => a.ExtendField;
                    disPageEntity.OrderColLazy       = a => a.ExtendField;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id, ExtendField = a.ExtendField
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.ExtendField) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.ExtendField) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.ExtendField) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.ExtendField) >= 0;
                    return(disPageEntity);
                }
                if (orderBy.MonitorServer)
                {
                    disPageEntity.OrderCol           = a => a.MonitorServer;
                    disPageEntity.OrderColLazy       = a => a.MonitorServer;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id, MonitorServer = a.MonitorServer
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.MonitorServer) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.MonitorServer) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.MonitorServer) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.MonitorServer) >= 0;
                    return(disPageEntity);
                }
            }
            disPageEntity.OrderType = false;
            orderBy = paramz.orderByDesc;
            if (orderBy != null)
            {
                if (orderBy.Id)
                {
                    disPageEntity.OrderCol           = a => a.Id;
                    disPageEntity.OrderColLazy       = a => a.Id;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.Id) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.Id) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.Id) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.Id) >= 0;
                    return(disPageEntity);
                }
                else
                if (orderBy.LastHeartbeatTime)
                {
                    disPageEntity.OrderCol           = a => a.LastHeartbeatTime;
                    disPageEntity.OrderColLazy       = a => a.LastHeartbeatTime;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id, LastHeartbeatTime = a.LastHeartbeatTime
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.LastHeartbeatTime) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.LastHeartbeatTime) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.LastHeartbeatTime) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.LastHeartbeatTime) >= 0;
                    return(disPageEntity);
                }
                else
                if (orderBy.RobotMac)
                {
                    disPageEntity.OrderCol           = a => a.RobotMac;
                    disPageEntity.OrderColLazy       = a => a.RobotMac;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id, RobotMac = a.RobotMac
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.RobotMac) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.RobotMac) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.RobotMac) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.RobotMac) >= 0;
                    return(disPageEntity);
                }
                else
                if (orderBy.Remark)
                {
                    disPageEntity.OrderCol           = a => a.Remark;
                    disPageEntity.OrderColLazy       = a => a.Remark;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id, Remark = a.Remark
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.Remark) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.Remark) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.Remark) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.Remark) >= 0;
                    return(disPageEntity);
                }
                else
                if (orderBy.ExtendField)
                {
                    disPageEntity.OrderCol           = a => a.ExtendField;
                    disPageEntity.OrderColLazy       = a => a.ExtendField;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id, ExtendField = a.ExtendField
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.ExtendField) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.ExtendField) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.ExtendField) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.ExtendField) >= 0;
                    return(disPageEntity);
                }
                else
                if (orderBy.MonitorServer)
                {
                    disPageEntity.OrderCol           = a => a.MonitorServer;
                    disPageEntity.OrderColLazy       = a => a.MonitorServer;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id, MonitorServer = a.MonitorServer
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.MonitorServer) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.MonitorServer) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.MonitorServer) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.MonitorServer) >= 0;
                    return(disPageEntity);
                }
                else
                {
                    disPageEntity.OrderCol           = a => a.Id;
                    disPageEntity.OrderColLazy       = a => a.Id;
                    disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                        Id = a.Id
                    };
                    disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.Id) < 0;
                    disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.Id) <= 0;
                    disPageEntity.LessThan    = (val) => a => val.CompareTo(a.Id) > 0;
                    disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.Id) >= 0;
                    return(disPageEntity);
                }
            }
            else
            {
                disPageEntity.OrderCol           = a => a.Id;
                disPageEntity.OrderColLazy       = a => a.Id;
                disPageEntity.OrderColAndKeyLazy = a => new HeartbeatEntity {
                    Id = a.Id
                };
                disPageEntity.GreatThan   = (val) => a => val.CompareTo(a.Id) < 0;
                disPageEntity.GreatEqThan = (val) => a => val.CompareTo(a.Id) <= 0;
                disPageEntity.LessThan    = (val) => a => val.CompareTo(a.Id) > 0;
                disPageEntity.LessEqThan  = (val) => a => val.CompareTo(a.Id) >= 0;
                return(disPageEntity);
            }
        }
Example #2
0
        /// <summary>
        /// 升序、降序排序的查询参数设置,当对应字段的升序设置为true时才会对
        /// 该字段降序。
        /// </summary>
        /// <param name="query">待设置降序参数的query对象</param>
        /// <param name="orderBy">装载降序参数的实体类</param>
        /// <returns>返回设置好降序参数的query对象</returns>
        IQueryable <HeartbeatEntity> OrderBy(IQueryable <HeartbeatEntity> query, HeartbeatEntityParams eqArgs)
        {
            HeartbeatEntityOrderBy orderBy = eqArgs.orderByAsc;

            if (orderBy != null)
            {
                if (orderBy.Id)
                {
                    return(query = query.OrderBy(a => a.Id));
                }
                else
                if (orderBy.LastHeartbeatTime)
                {
                    return(query = query.OrderBy(a => a.LastHeartbeatTime));
                }
                else
                if (orderBy.RobotMac)
                {
                    return(query = query.OrderBy(a => a.RobotMac));
                }
                else
                if (orderBy.Remark)
                {
                    return(query = query.OrderBy(a => a.Remark));
                }
                else
                if (orderBy.ExtendField)
                {
                    return(query = query.OrderBy(a => a.ExtendField));
                }
                else
                if (orderBy.MonitorServer)
                {
                    return(query = query.OrderBy(a => a.MonitorServer));
                }
            }
            orderBy = eqArgs.orderByDesc;
            if (orderBy != null)
            {
                if (orderBy.Id)
                {
                    return(query = query.OrderByDescending(a => a.Id));
                }
                else
                if (orderBy.LastHeartbeatTime)
                {
                    return(query = query.OrderByDescending(a => a.LastHeartbeatTime));
                }
                else
                if (orderBy.RobotMac)
                {
                    return(query = query.OrderByDescending(a => a.RobotMac));
                }
                else
                if (orderBy.Remark)
                {
                    return(query = query.OrderByDescending(a => a.Remark));
                }
                else
                if (orderBy.ExtendField)
                {
                    return(query = query.OrderByDescending(a => a.ExtendField));
                }
                else
                if (orderBy.MonitorServer)
                {
                    return(query = query.OrderByDescending(a => a.MonitorServer));
                }
                else
                {
                    return(query = query.OrderByDescending(a => a.Id));
                }
            }
            else
            {
                return(query = query.OrderByDescending(a => a.Id));
            }
        }