public void GetGPS() { while (true) { QW_CarsBLL bll = new QW_CarsBLL(); List <QW_CarsModel> listCar = bll.GetCars().Where(a => !string.IsNullOrEmpty(a.remarks)).ToList(); foreach (QW_CarsModel item in listCar) { string url = string.Format(@"http://116.247.83.157/StandardApiAction_getDeviceStatus.action?jsession={0}&devIdno={1}&toMap=2", jsession, item.cartel); string Tracking = HttpWebPost.Request(url, false, ""); // 反序列化json JavaScriptSerializer jss = new JavaScriptSerializer(); JObject Trackingjson = (JObject)JsonConvert.DeserializeObject(Tracking); string result = Trackingjson["result"] == null ? "" : Trackingjson["result"].ToString(); if (result == "0") { string status = Trackingjson["status"] == null ? "" : Trackingjson["status"].ToString(); if (!string.IsNullOrEmpty(status)) { JArray jo = new JArray(); jo = (JArray)JsonConvert.DeserializeObject(status); foreach (JObject array in jo) { QW_CarHistoryPositionsModel model = new QW_CarHistoryPositionsModel(); model.carid = item.carid; model.cartel = item.cartel; model.isanalyze = 0; model.lc = array["lc"] == null ? 0 : Convert.ToDouble(array["lc"].ToString()); model.pk = array["pk"] == null ? 0 : Convert.ToInt32(array["pk"].ToString()); model.positiontime = array["gt"] == null ? DateTime.Now : Convert.ToDateTime(array["gt"].ToString()); model.speed = array["sp"] == null ? 0 : Convert.ToDecimal(array["sp"].ToString()); model.x84 = array["mlng"] == null ? 0 : Convert.ToDecimal(array["mlng"].ToString()); model.y84 = array["mlat"] == null ? 0 : Convert.ToDecimal(array["mlat"].ToString()); model.yl = array["yl"] == null ? 0 : Convert.ToDouble(array["yl"].ToString()); DateTime dt = model.positiontime; bool his = bll.GetBoolCarPostiton(item.carid, dt); if (!his) { bll.CarHistoryPositions(model); } bll.UpdateLastPosition(item.carid, dt, model); Console.WriteLine("车辆:" + item.carnumber + "---PositionTime:" + dt.ToString("yyyy-MM-dd hh:mm:ss")); } } } else { GetPassWord(); break; } } System.Threading.Thread.Sleep(20000); } }
/// <summary> /// 获取内容 /// </summary> /// <param name="dtNow">时间</param> /// <returns></returns> public string GetTableContentMes(DateTime dtNow, int unitId) { StringBuilder sbMes = new StringBuilder(); QW_CarsBLL bll = new QW_CarsBLL(); QW_CarTasksBLL utbll = new QW_CarTasksBLL(); IList <QW_CarsModel> carList = bll.GetCarsUnitList(unitId); #region 拼接日历视图 if (carList != null && carList.Count() > 0) { //获取要显示的周期 int startIndex = 0; int endIndex = 0; GetStartEndIndex(dtNow, ref startIndex, ref endIndex); IList <qw_cartasks> CarTaskList = utbll.GetCarTaskList(); foreach (var item in carList) { sbMes.Append("<tr>"); sbMes.Append("<td style=\"text-align: center; width: 12%; height:30px; border:1px solid #ddd; border-collapse: collapse; line-height:60px; background:#f2f5f7\">" + item.carnumber + "</td>"); for (int i = startIndex; i < endIndex; i++)//遍历对应时间的勤务 { DateTime dtnow_New = dtNow.AddDays(i); DateTime dtOne = dtnow_New.Date.Date; DateTime dtTwo = dtOne.AddDays(1); IList <qw_cartasks> CarTaskList_Where = CarTaskList .Where(a => a.carnum == item.carnumber && a.taskstarttime >= dtOne && a.taskstarttime < dtTwo).ToList(); string onlyT = item.carid + "_" + dtnow_New.ToString("yyyyMMdd"); if (CarTaskList_Where != null && CarTaskList_Where.Count() > 0) { sbMes.Append("<td id=\"td_" + onlyT + "\" style=\"text-align: center; width: 12%; height:30px; border:1px solid #ddd; border-collapse: collapse;background:#F0AD4E\" ><img src='/Images/images/normal.png' style='width:30px; height:30px; cursor:pointer;' title='点我修改车辆任务' onclick=\"EditCarTask('" + item.carnumber + "','" + dtnow_New.ToString("yyyy-MM-dd") + "','" + item.unitid + "','" + item.carid + "')\"/></td>"); } else { sbMes.Append("<td id=\"td_" + onlyT + "\" style=\"text-align: center; width: 12%; height:30px; border:1px solid #ddd; border-collapse: collapse;background:#f2f5f7\" ><img src='/Images/images/abnormal.png' style='width:30px; height:30px; cursor:pointer;' title='点我添加车辆任务' onclick=\"AddCarTask('" + item.carnumber + "','" + dtnow_New.ToString("yyyy-MM-dd") + "','" + item.unitid + "','" + item.carid + "')\" /></td>"); } } sbMes.Append("</tr>"); } } else { sbMes.Append("<tr>"); sbMes.Append("<td style=\"text-align: center; width: 12%; height:30px; border:1px solid #ddd; border-collapse: collapse; color:red;\" colspan=\"8\">没有查询到车辆</td>"); sbMes.Append("</tr>"); } #endregion return(sbMes.ToString()); }
public List <QW_CarsModel> GetCarsUnitList(string unitid) { QW_CarsBLL bll = new QW_CarsBLL(); return(bll.GetCarsUnitList(Convert.ToInt32(unitid))); }