//将报警信息存入数据库
public void SaveAlarmList(AlarmList alarmlist)
{
List <qw_alarmcarmemorylocationdatas> list = GetAllList().Where(a => a.carid == alarmlist.CARID && a.alarmstrattime == alarmlist.ALARMSTRATTIME && a.alarmtype == 3).ToList();
if (list.Count == 0)
{
qw_alarmcarmemorylocationdatas ta = new qw_alarmcarmemorylocationdatas();
//ta.id = AlarmListBLL.GetNewAlarmListID();
ta.longitude = alarmlist.LONGITUDE == null ? 0 : (double)alarmlist.LONGITUDE;
ta.latitude = alarmlist.LATITUDE == null ? 0 : (double)alarmlist.LATITUDE;
//ta.X = alarmlist.X2000 == null ? 0 : (decimal)alarmlist.X2000;
//ta.Y = alarmlist.Y2000 == null ? 0 : (decimal)alarmlist.Y2000;
ta.speed = alarmlist.SPEED == null ? 0 : (double)alarmlist.SPEED;
ta.gpstime = alarmlist.GPSTIME;
ta.createtime = DateTime.Now;
ta.alarmendtime = alarmlist.ALARMENDTIME;
ta.alarmstrattime = alarmlist.ALARMSTRATTIME;
ta.alarmtype = alarmlist.ALARMTYPE;
ta.carid = alarmlist.CARID;
ta.state = 0;
AddTeamMemoryLocationData(ta);
}
else
{
XGSaveAlarmList(alarmlist);
}
}
//将报警信息存入数据库
public decimal SaveAlarmList(qw_alarmcarmemorylocationdatas alarmlist, string OutMapID)
{
Entities db = new Entities();
decimal outmapid = 0;
decimal.TryParse(OutMapID, out outmapid);
bool isnullstr = false;
qw_alarmcarmemorylocationdatas ta = db.qw_alarmcarmemorylocationdatas.Where(a => a.carid == outmapid).FirstOrDefault();
if (ta == null)
{
ta = new qw_alarmcarmemorylocationdatas();
isnullstr = true;
}
ta.longitude = alarmlist.longitude == null ? 0 : (double)alarmlist.longitude;
ta.latitude = alarmlist.latitude == null ? 0 : (double)alarmlist.latitude;
ta.speed = alarmlist.speed == null ? 0 : (double)alarmlist.speed;
ta.gpstime = alarmlist.gpstime;
ta.createtime = DateTime.Now;
ta.alarmendtime = alarmlist.alarmendtime;
ta.alarmstrattime = alarmlist.alarmstrattime;
ta.alarmtype = alarmlist.alarmtype;
ta.carid = alarmlist.carid;
ta.state = 0;
if (isnullstr)
{
db.qw_alarmcarmemorylocationdatas.Add(ta);
}
return(db.SaveChanges());
}
/// <summary>
/// 修改离线报警
/// </summary>
/// <param name="family"></param>
/// <returns></returns>
public int EditTeamMemoryLocationData(qw_alarmcarmemorylocationdatas va)
{
Entities db = new Entities();
qw_alarmcarmemorylocationdatas al = db.qw_alarmcarmemorylocationdatas.Where(t => t.id == va.id).FirstOrDefault();
if (al != null)
{
al.alarmendtime = va.alarmendtime;
al.createtime = va.createtime;
}
return(db.SaveChanges());
}
/// <summary>
/// 添加30分钟停留超时报警记录
/// </summary>
/// <param name="family"></param>
/// <returns></returns>
public int AddTeamMemoryLocationData(qw_alarmcarmemorylocationdatas va)
{
Entities db = new Entities();
int al = db.qw_alarmcarmemorylocationdatas.Where(t => t.alarmstrattime == va.alarmstrattime && t.alarmendtime == va.alarmendtime && t.carid == va.carid && t.alarmtype == va.alarmtype).Count();
if (al == 0)
{
va.createtime = DateTime.Now;
db.qw_alarmcarmemorylocationdatas.Add(va);
}
return(db.SaveChanges());
}
