经纬度 lbs 笔记
2024-08-27 00:29:14
string Lat = objRequest.HeadLat.ToString(); 纬度
string Lng = objRequest.HeadLng.ToString(); 经度
NC.BLL.VisitLogs.UpdateUserLocation(objRequest.UID, Lat, Lng);
UPDATE userinfo SET UserLocation= geography::Point({0}, {1}, 4326) WHERE uid={2}
更新经纬度
( select UserLocation from userinfo where UID=visitlog.ToUID).STDistance(visitlog.UserLocation) AS Distance
string strDistance = NC.MSSQL.VWVisitLogs.GetDistance(userInfoHobby2User.ID);
userHobby.Distance = strDistance != null ? (int)Math.Round(strDistance.ConvertDecimal(), 0) : 99999999;
string Lat = objRequest.HeadLat.ToString();
string Lng = objRequest.HeadLng.ToString();
VisitLog objVisitLog = new VisitLog();
objVisitLog.FromuID = myUserId;
objVisitLog.ToUID = UID;
objVisitLog.Cretime = System.DateTime.Now;
NC.BLL.VisitLogs.InsertVisitLog(objVisitLog, Lat, Lng);
string strsql = string.Format(" UPDATE VisitLog SET UserLocation= geography::Point({0}, {1}, 4326) WHERE id={2} ", Lat, Lng, objVisitLog.ID);
conn.ExecuteCommand(strsql);
public static void UpdateUserLocation(int UID, string Lat, string Lng)
{
using (VIPDataContext conn = new VIPDataContext(PlatformConfig.DBConnectionString))
{
string strsql = string.Format(" UPDATE userinfo SET UserLocation= geography::Point({0}, {1}, 4326) WHERE uid={2} ", Lat, Lng, UID);
conn.ExecuteCommand(strsql);
}
}
/// <summary>
/// 纬度
/// </summary>
public decimal Lat { get; set; }
/// <summary>
/// 经度
/// </summary>
public decimal Lng { get; set; }
/// <summary>
/// 高德纬度
/// </summary>
public decimal ALat { get; set; }
/// <summary>
/// 高德经度
/// </summary>
public decimal ALng { get; set; }
USE [FcityDB２]
GO
SELECT [UserLocation]
,[UserLocation2]
FROM [dbo].[Table_1]
GO
118.115196,24.49956
118.152884,24.632101
118.115959,24.500226
118.155484,24.633353
UPDATE [Table_1] SET UserLocation= geography::Point(24.632101, 118.152884, 4326)
UPDATE [Table_1] SET UserLocation2= geography::Point(24.633353, 118.155484, 4326)
SELECT UserLocation.STDistance(UserLocation2) AS Distance from [Table_1]
--106.876085126272
--297.540495255538
最新文章
- Android之常见问题集锦Ⅱ
- Signlar
- 【转】IP协议详解之子网寻址、子网掩码、构造超网
- Python基础之生成器
- http状态码介绍
- js 精确小数俩位
- 数据类型转换的三种方式 Convert,parse和TryParse的解析
- Django Web在Apache上的部署
- C#截取字符串的方法小结
- Android 高仿微信即时聊天 百度云为基础的推
- C++11标准后的C++阅读书目
- sudo 和su
- 规则集Set与线性表List性能分析
- Redis持久化存储
- jQuery-委托事件和on方法注册事件
- flask 第二章 endpoint重名 Flask路由 初始化配置 Falsk Config 蓝图+目录结构
- （4.3）mysql备份还原——mysql备份策略
- 用jQuery实现ajax总结以及跨域问题
- Perl之my与local
- Alpha阶段敏捷冲刺⑥