/// <summary>
/// 添加最新定位表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int CarLastPositions(QW_CarHistoryPositionsModel model)
{
using (Entities db = new Entities())
{
qw_carlastpositions qumodel = new qw_carlastpositions();
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_carlastpositions.Add(qumodel);
return(db.SaveChanges());
}
}
/// <summary>
/// 更新最新定位表
/// </summary>
/// <param name="CarId"></param>
/// <param name="PositionTime"></param>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateLastPosition(int CarId, DateTime PositionTime, QW_CarHistoryPositionsModel model)
{
using (Entities db = new Entities())
{
qw_carlastpositions lastmodel = new qw_carlastpositions();
lastmodel = db.qw_carlastpositions.Where(a => a.carid == CarId && a.positiontime == PositionTime).FirstOrDefault();
if (lastmodel == null)
{
return(CarLastPositions(model));
}
else
{
lastmodel.lc = model.lc;
lastmodel.pk = model.pk;
lastmodel.positiontime = model.positiontime;
lastmodel.speed = model.speed;
lastmodel.x84 = model.x84;
lastmodel.yl = model.yl;
lastmodel.y84 = model.y84;
return(db.SaveChanges());
}
}
}
