/// <summary> /// 修改分析后的车辆字段 /// </summary> /// <param name="id"></param> /// <returns></returns> public int UpdateISANALYZE(int carid, DateTime date) { Entities db = new Entities(); qw_carhistorypositions _model = db.qw_carhistorypositions.FirstOrDefault(t => t.carid == carid && t.positiontime == date); if (_model != null) { _model.isanalyze = 1; } return(db.SaveChanges()); }
/// <summary> /// 根据车辆标识和定位时间判断是否存在 /// </summary> /// <param name="CarId"></param> /// <param name="PositionTime"></param> /// <returns></returns> public bool GetBoolCarPostiton(int CarId, DateTime PositionTime) { using (Entities db = new Entities()) { qw_carhistorypositions qumodel = new qw_carhistorypositions(); qumodel = db.qw_carhistorypositions.Where(a => a.carid == CarId && a.positiontime == PositionTime).FirstOrDefault(); if (qumodel != null) { return(true); } else { return(false); } } }
/// <summary> /// 添加用户历史位置 /// </summary> /// <param name="model"></param> /// <returns></returns> public int CarHistoryPositions(QW_CarHistoryPositionsModel model) { using (Entities db = new Entities()) { qw_carhistorypositions qumodel = new qw_carhistorypositions(); qumodel.x2000 = model.x2000; qumodel.y2000 = model.y2000; qumodel.x84 = model.x84; qumodel.y84 = model.y84; qumodel.carid = model.carid; qumodel.positiontime = model.positiontime; qumodel.cartel = model.cartel; qumodel.speed = model.speed; qumodel.lc = model.lc; qumodel.pk = model.pk; qumodel.yl = model.yl; db.qw_carhistorypositions.Add(qumodel); return(db.SaveChanges()); } }