where 子句中的 MonoRail ActiveRecord/NHibernate 计算

发布于 2024-09-08 09:41:56 字数 531 浏览 4 评论 0原文

我试图让企业在用户的一定英里范围内，使用公式来获取企业的纬度/经度和用户的纬度/经度之间的距离。代码如下：

var criteria = DetachedCriteria.For<Core.Models.Business>();      criteria.Add(Restrictions.Le(String.Format(@"(3959*acos(cos(radians({0}))*cos(radians(Latitude))*cos(radians(Longitude)-radians({1}))
                    +sin(radians({0}))*sin(radians(Latitude))))", coordinates.Latitude, coordinates.Longitude), radiusInMiles));

问题是 ActiveRecord/NHibernate 的 Restrictions.Le 方法需要第一个参数的属性名称，因此我无法在其中放置公式。我该怎么做这样的事情？

谢谢！贾斯汀

原文

I'm trying to get businesses within a certain number of miles of a user, using a formula to get the distance between the lat/long of the business and the lat/long of the user. Here is the code:

var criteria = DetachedCriteria.For<Core.Models.Business>();      criteria.Add(Restrictions.Le(String.Format(@"(3959*acos(cos(radians({0}))*cos(radians(Latitude))*cos(radians(Longitude)-radians({1}))
                    +sin(radians({0}))*sin(radians(Latitude))))", coordinates.Latitude, coordinates.Longitude), radiusInMiles));

The problem is that ActiveRecord/NHibernate's Restrictions.Le method expects a property name for the first parameter so I can't put a formula in there. How would I do something like this?

Thanks!
Justin

分享到QQ

分享到微博