public async Task <DataTable> FindLocationByMdn(SynLocationDataInput input)
{
DataTable output = new DataTable();
DBConnection dbConnection = new DBConnection();
//var conn = dbConnection.GetDbConnection();
string sql = @"select * from sys_usertrack where UserId=@P_UserId and Time>=@P_BegDate and Time<=@P_EndDate order by Time";
MySqlParameter[] parms = new MySqlParameter[3];
parms[0] = new MySqlParameter("P_UserId", MySqlDbType.Int64);
parms[0].Value = input.UserId;
parms[1] = new MySqlParameter("P_BegDate", MySqlDbType.DateTime);
parms[1].Value = input.BegDate;
parms[2] = new MySqlParameter("P_EndDate", MySqlDbType.DateTime);
parms[2].Value = input.EndDate;
output = (await MySqlHelper.ExecuteDatasetAsync(dbConnection.DefaultConnectionStringSettings.ConnectionString, sql, parms)).Tables[0];
return(output);
}
public ActionResult <string> SynLocationData(SynLocationDataInput input)
{
//http://118.85.200.79/ids/flex/findLocationByMdn/18995896655/2020-06-01%2000:00/2020-06-04%2015:52?jsonp=jsonp_D87B57B230AE403CAEB03F9DA276A3FF
//http://118.85.200.79/ids/flex/findLocationByMdn/18908604880/2020-06-01%2000:00/2020-06-04%2017:08?jsonp=jsonp_FA012AFB6B144FBA8323F6247F565100
string jsonp = (input.Url.Split('?')[1]).Split('=')[1];
_httpClient.Url = input.Url;
//_httpClient.PostingData.Add("SerialnbrCode", code);
string result = _httpClient.GetResponseBySimple("1");
if (string.IsNullOrEmpty(result) == false)
{
if (result.IndexOf(jsonp) == 0)
{
result = result.Replace(jsonp + "(", "").TrimEnd(')');
}
}
result = result.Trim();
var resultObj = (JArray)JsonConvert.DeserializeObject(result);
//onp_D87B57B230AE403CAEB03F9DA276A3FF( [ { "
//output = resultObj["result"].ToString();
//ype": '基站定位', "time": '2020-06-01 08:56:00', "loc": '湖北省 宜昌市 五峰土家族自治县 曹家坪路 附近；渔洋关国土所往西北约305米', "r": 1, "lng": 111.070966, "lat": 30.166492 }
//先删除，再新增
DBConnection dbConnection = new DBConnection();
//var conn = dbConnection.GetDbConnection();
MySqlParameter[] parms = new MySqlParameter[1];
parms[0] = new MySqlParameter("P_Id", MySqlDbType.Int64);
parms[0].Value = input.UserId;
var username = MySqlHelper.ExecuteScalar(dbConnection.DefaultConnectionStringSettings.ConnectionString, "select UserName from sys_user where Id=@P_Id", parms);
input.UserName = username.ToString();
#region 除
string sqldel = @"delete from sys_usertrack where UserId=@P_UserId and Time>=@P_BegDate and Time<=@P_EndDate";
parms = new MySqlParameter[3];
parms[0] = new MySqlParameter("P_UserId", MySqlDbType.Int64);
parms[0].Value = input.UserId;
parms[1] = new MySqlParameter("P_BegDate", MySqlDbType.DateTime);
parms[1].Value = input.BegDate;
parms[2] = new MySqlParameter("P_EndDate", MySqlDbType.DateTime);
parms[2].Value = input.EndDate;
MySqlHelper.ExecuteNonQuery(dbConnection.DefaultConnectionStringSettings.ConnectionString, sqldel, parms);
#endregion
foreach (var item in resultObj)
{
_sysUserTrackRepository.InsertAsync(new SysUsertrack()
{
Type = item["type"].ToString(),
DeviceId = null,
Lat = item["lat"].ToString(),
Lon = item["lng"].ToString(),
Loc = item["loc"].ToString(),
Time = Convert.ToDateTime(item["time"]),
UserId = input.UserId.Value,
UserName = input.UserName
});
}
return("Ok");
}
