/// <summary>
/// 获取实时轨迹中历史轨迹点
/// </summary>
/// <param name="phone"></param>
/// <param name="time"></param>
/// <returns></returns>
public JsonResult GetRealDataAjax(string phone, string time)
{
string uid = Request.Params["uid"];//护林员id
string maptype = Request.Params["maptype"];
MessageListObject msg = null;
var sw = new T_IPS_REALDATASW();
sw.PHONE = phone.Trim();
sw.searchDate = DateTime.Now.ToString("yyyy-MM-dd");
sw.HID = uid;
if (!string.IsNullOrEmpty(maptype))
{
sw.MapType = maptype;//地图类型
}
if (!string.IsNullOrEmpty(time))
{
sw.DateBegin = Convert.ToDateTime(time).AddSeconds(1).ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
sw.DateEnd = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
var list = T_IPS_REALDATACls.getModelList(sw);
if (list.Count() > 0)
{
msg = new MessageListObject(true, list);
}
return(Json(msg));
}
/// <summary>
/// 获取历史经纬度(历史轨迹回放)
/// </summary>
/// <param name="uid"></param>
/// <param name="time"></param>
/// <returns></returns>
public JsonResult GetHisLogLatAjax(string uid, string time)
{
MessageListObject ms = null;
if (string.IsNullOrEmpty(uid) || string.IsNullOrEmpty(time))
{
ms = new MessageListObject(false, null);
return(Json(ms));
}
string maptype = Request.Params["maptype"]; //地图类型
string starttime = Request.Params["starttime"]; //开始时分
string endtime = Request.Params["endtime"]; //结束时分
var model = new T_IPS_REALDATASW();
model.HID = uid;
//model.searchDate = time;
if (!string.IsNullOrEmpty(starttime.Trim()) && !string.IsNullOrEmpty(endtime.Trim()))//时分参数
{
model.DateBegin = time + " " + starttime + ":00";
model.DateEnd = time + " " + endtime + ":00";
if (endtime.Trim() == "23:59")
{
model.DateEnd = time + " " + endtime + ":59";
}
}
if (!string.IsNullOrEmpty(maptype))
{
model.MapType = maptype;
}
var list = T_IPS_REALDATACls.getModelList(model).ToList();
if (list.Any())
{
for (int i = 0; i < list.Count; i++)
{
if (i != 0)
{
bool bo = ISBetweenInDistance(list[i - 1].LONGITUDE, list[i - 1].LATITUDE, list[i].LONGITUDE, list[i].LATITUDE);//去除在参数设置范围内的经纬度
if (bo)
{
list.Remove(list[i]);
--i;
}
}
}
ms = new MessageListObject(true, list);
}
return(Json(ms));
}
/// <summary>
/// 电量查询Html
/// </summary>
/// <param name="uid"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public JsonResult GetElectricAjax(string uid, string startTime, string endTime)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<table cellpadding=\"0\" cellspacing=\"0\">");
sb.AppendFormat("<thead><tr>");
sb.AppendFormat("<th>序号</th>");
sb.AppendFormat("<th>单位</th>");
sb.AppendFormat("<th>姓名</th>");
sb.AppendFormat("<th>电话号码</th>");
sb.AppendFormat("<th>时间</th>");
sb.AppendFormat("<th>电量</th>");
sb.AppendFormat("</tr></thead>");
sb.AppendFormat("<tbody>");
Message ms = null;
if (string.IsNullOrEmpty(uid))
{
ms = new Message(false, "", "");
return(Json(ms));
}
var sw = new T_IPS_REALDATASW();
sw.HID = uid;
sw.DateBegin = startTime + " 0:00:00";
sw.DateEnd = endTime + " 23:59:59";
var list = T_IPS_REALDATACls.getElectricModelList(sw).Take(500);//获取电量列表
if (list.Any())
{
if (list.Count() <= 500)
{
int i = 0;
foreach (var item in list)
{
sb.AppendFormat("<tr>");
sb.AppendFormat("<td>{0}</td>", ++i);
sb.AppendFormat("<td>{0}</td>", item.ORGNAME);
sb.AppendFormat("<td>{0}</td>", item.HNAME);
sb.AppendFormat("<td>{0}</td>", item.PHONE);
sb.AppendFormat("<td>{0}</td>", item.SBTIME);
sb.AppendFormat("<td>{0}</td>", item.ELECTRIC);
sb.AppendFormat("</tr>");
}
}
else
{
sb.AppendFormat("<tr>");
sb.AppendFormat("<td colspan=\"6\">暂无电量信息</td>");
sb.AppendFormat("</tr>");
ms = new Message(false, sb.ToString(), "检索的数据量过大,请缩短时间间隔或减少查询护林员数量!");
return(Json(ms));
}
}
else
{
sb.AppendFormat("<tr>");
sb.AppendFormat("<td colspan=\"6\">暂无电量信息</td>");
sb.AppendFormat("</tr>");
}
sb.AppendFormat("</tbody>");
sb.AppendFormat("</table>");
ms = new Message(true, sb.ToString(), "");
return(Json(ms));
}