public AllAlarms GetAllAlarmsByPerson(AlarmSearchArgAll args) { AllAlarms alarms = new AllAlarms(); try { string sqlwhere1 = ""; string sqlwhere2 = ""; string personnels = ""; if (args != null) { if (args.personnels != null) { foreach (int person in args.personnels) { personnels += person.ToString() + ","; } personnels = personnels.Substring(0, personnels.Length - 1); sqlwhere1 += " and PersonnelId in (" + personnels + ")"; } if (args.startTime != null && args.endTime != null) { sqlwhere1 += string.Format(@" and AlarmTimeStamp>{0} and AlarmTimeStamp<{1}", args.startTime.ToStamp(), args.endTime.ToStamp()); sqlwhere2 += string.Format(@" and AlarmTimeStamp>{0} and AlarmTimeStamp<{1}", args.startTime.ToStamp(), args.endTime.ToStamp()); } } string sql1 = string.Format(@"select id,AlarmId,AlarmType,AlarmLevel,LocationCardId,PersonnelId,CardRoleId,AreaId,AuzId,AllAuzId,Content,AlarmTime,AlarmTimeStamp,HandleTime,HandleTimeStamp,`Handler`,HandleType from location.locationalarms where 1=1 " + sqlwhere1); string sql2 = string.Format(@"select id,AlarmId,AlarmType,AlarmLevel,LocationCardId,PersonnelId,CardRoleId,areadid,AuzId,AllAuzId,Content,AlarmTime,AlarmTimeStamp,HandleTime,HandleTimeStamp,`Handler`,HandleType, HistoryTime, HistoryTimeStamp from locationhistory.locationalarmhistories where 1=1 " + sqlwhere1); string sql3 = string.Format(@"select id,Abutment_Id,Title,Msg,`LEVEL`,`Code`,Src,DevInfoId,Device_desc,AlarmTime,AlarmTimeStamp from location.devalarms where 1=1 " + sqlwhere2); string sql4 = string.Format(@"select id,Abutment_Id,Title,Msg,`LEVEL`,`Code`,Src,DevInfoId,Device_desc,AlarmTime,AlarmTimeStamp,historyTime,historyTimeStamp from locationhistory.devalarmhistories where 1=1 " + sqlwhere2); List <DbModel.Location.Alarm.LocationAlarm> list1 = db.LocationAlarms.GetListBySql <DbModel.Location.Alarm.LocationAlarm>(sql1); List <LocationAlarmHistory> list2 = db.LocationAlarmHistorys.GetListBySql <LocationAlarmHistory>(sql2); List <DbModel.Location.Alarm.LocationAlarm> listalarm = new List <DbModel.Location.Alarm.LocationAlarm>(); listalarm.AddRange(list1); foreach (LocationAlarmHistory alarmHis in list2) { DbModel.Location.Alarm.LocationAlarm alarm = alarmHis.ConvertToAlarm(); listalarm.Add(alarm); } List <DevAlarm> list3 = db.DevAlarms.GetListBySql <DevAlarm>(sql3); List <DevAlarmHistory> devalarmHiss = db.DevAlarmHistorys.GetListBySql <DevAlarmHistory>(sql4); List <DevAlarm> devalarms = new List <DevAlarm>(); devalarms.AddRange(list3); foreach (DevAlarmHistory devalarmhis in devalarmHiss) { DevAlarm devalarm = devalarmhis.ConvertToDevAlarm(); devalarms.Add(devalarm); } alarms.alarmList = listalarm.ToTModel(); alarms.devAlarmList = devalarms.ToTModel(); } catch (Exception ex) { alarms.alarmList = new List <T_LocationAlarm>(); alarms.devAlarmList = new List <DeviceAlarm>(); Log.Error("AlarmService.GetAllAlarmsByPerson:" + ex.ToString()); } return(alarms); }
public AllAlarms GetAllAlarmsByPerson(AlarmSearchArgAll args) { return(service.GetAllAlarmsByPerson(args)); }