/// <summary> /// 获取定位最大排序号 /// </summary> /// <returns></returns> public static int GetTransportPositionMaxOrder() { CmcsTransportPosition entity = Dbers.GetInstance().SelfDber.Entity <CmcsTransportPosition>("order by OrderNumber desc"); if (entity == null) { return(1); } return(Convert.ToInt32(entity.OrderNumber) + 1); }
/// <summary> /// 移除轨道车辆定位信息 /// </summary> /// <param name="transportId"></param> public static bool RemoveTransportPosition(string trainNumber) { CmcsTrainCarriagePass oldtrain = Dbers.GetInstance().SelfDber.Entity <CmcsTrainCarriagePass>("where TrainNumber=:TrainNumber and PassTime>=:PassTime order by PassTime desc", new { TrainNumber = trainNumber, PassTime = DateTime.Now.AddDays(-1) }); if (oldtrain == null) { return(false); } CmcsTransportPosition entity = Dbers.GetInstance().SelfDber.Entity <CmcsTransportPosition>("where TransportId='" + oldtrain.Id + "' order by CreationTime desc"); if (entity == null) { return(false); } return(Dbers.GetInstance().SelfDber.Delete <CmcsTransportPosition>(entity.Id) > 0); }
/// <summary> /// 修改轨道车辆定位信息,设定为未翻车 /// </summary> /// <param name="transportId"></param> public static bool UnTurnTransportPosition(string trainNumber) { CmcsTrainCarriagePass oldtrain = Dbers.GetInstance().SelfDber.Entity <CmcsTrainCarriagePass>("where TrainNumber=:TrainNumber and PassTime>=:PassTime order by PassTime desc", new { TrainNumber = trainNumber, PassTime = DateTime.Now.AddDays(-1) }); if (oldtrain == null) { return(false); } CmcsTransportPosition entity = Dbers.GetInstance().SelfDber.Entity <CmcsTransportPosition>("where TransportId='" + oldtrain.Id + "' and IsDisCharged=1 order by CreationTime desc"); if (entity == null) { return(false); } entity.IsDisCharged = 0; entity.TurnCarDate = DateTime.MinValue; return(Dbers.GetInstance().SelfDber.Update(entity) > 0); }
/// <summary> /// 插入定位信息 /// </summary> /// <param name="trackNumber"></param> /// <param name="transportid"></param> /// <returns></returns> public static bool InsertTransportPosition(string trackNumber, string carNumber) { CmcsTrainCarriagePass transport = Dbers.GetInstance().SelfDber.Entity <CmcsTrainCarriagePass>("where TrainNumber=:TrainNumber and PassTime>=:PassTime order by CreationTime desc", new { TrainNumber = carNumber, PassTime = DateTime.Now.AddDays(-1) }); if (transport == null) { return(false); } CmcsTransportPosition entity = Dbers.GetInstance().SelfDber.Entity <CmcsTransportPosition>("where TransportId='" + transport.Id + "'"); if (entity != null) { Dbers.GetInstance().SelfDber.Delete <CmcsTransportPosition>(entity.Id); } return(Dbers.GetInstance().SelfDber.Insert(new CmcsTransportPosition() { OrderNumber = GetTransportPositionMaxOrder(), TrackNumber = trackNumber, TransportId = transport.Id, IsDisCharged = 0 }) > 0); }