/// <summary> /// 导出界面 /// 获得某个视频的元信息和所有检测结果信息 /// </summary> /// <param name="id">视频id</param> /// <returns></returns> public List <AbnormalViewModel> ExportByVideoId(int id) { List <AbnormalViewModel> list = new List <AbnormalViewModel>(); using (IDbConnection conn = SqlHelper.GetConnection()) { conn.Open(); var sql = @"SELECT * FROM TB_ABNORMAL,TB_METADATA WHERE TB_ABNORMAL.VIDEOID=TB_METADATA.ID AND TB_ABNORMAL.VIDEOID=@id;"; IEnumerable <dynamic> dynamics = conn.Query(sql, new { id }); foreach (var item in dynamics) { MetaModel mm = new MetaModel(); AbnormalModel am = new AbnormalModel(); AbnormalViewModel avm = new AbnormalViewModel(); mm.PipeCode = item.PIPECODE; mm.PipeType = (int)item.PIPETYPE; mm.TaskCode = item.TASKCODE; mm.FramePath = item.FRAMEPATH; mm.Addr = item.ADDR; mm.Charge = item.CHARGE; mm.StartTime = item.STARTTIME; am.VideoId = (int)item.VIDEOID; am.Type = (int)item.TYPE; am.Position = item.POSITION; avm.Meta = mm; avm.Abnormal = am; list.Add(avm); } } return(list); }
public MainWindow() { InitializeComponent(); _abnormalModel = new AbnormalViewModel(); _abnormalModel.PopulateModel(); AbnormalAttackWindow = new AbnormalAttackUserControl(_abnormalModel); var sbModel = new SimpleBindViewModel(); sbModel.PopulateModel(); LsbAttackWindow = new LsbAttackUserControl(sbModel); var testModel = new TestViewModel(); testModel.PopulateModel(); TestWindow = new TestUserControl(testModel); var vpnModel = new VpnViewModel(); vpnModel.PopulateModel(); VpnWindow = new VpnUserControl(vpnModel); var samrModel = new SamrViewModel(); samrModel.PopulateModel(); SamrWindow = new SamrUserControl(samrModel); DataContext = this; }
/// <summary> /// 人工回溯界面 /// 获取未查看的所有异常 /// </summary> /// <param name="TaskIds"></param> /// <returns></returns> public ObservableCollection <AbnormalViewModel> SelectAllWithoutWatch(List <int> TaskIds) { ObservableCollection <AbnormalViewModel> avms = new ObservableCollection <AbnormalViewModel>(); using (IDbConnection conn = SqlHelper.GetConnection()) { conn.Open(); var sql = @"SELECT ADDR,PIPECODE,PIPETYPE,STARTTIME,TB_ABNORMAL.TYPE, POSITION,TB_ABNORMAL.ID AS TID,VIDEOID AS VID, FRAMEPATH,STATE,TASKID FROM TB_ABNORMAL,TB_METADATA WHERE TASKID IN @ids AND STATE==1000 AND VID=TB_METADATA.ID;"; IEnumerable <dynamic> dynamics = conn.Query(sql, new { ids = TaskIds.ToArray() }); foreach (var item in dynamics) { MetaModel mm = new MetaModel(); AbnormalModel am = new AbnormalModel(); AbnormalViewModel avm = new AbnormalViewModel(); mm.Addr = item.ADDR; mm.PipeCode = item.PIPECODE; mm.PipeType = (int)item.PIPETYPE; mm.FramePath = item.FRAMEPATH; if (!string.IsNullOrEmpty(item.STARTTIME)) { mm.StartTime = item.STARTTIME; } else { mm.StartTime = "未填写"; } am.VideoId = (int)item.VID; am.Type = (int)item.TYPE; am.Position = item.POSITION; //新加的状态和任务编号 am.State = (int)item.STATE; am.TaskId = (int)item.TASKID; avm.AbnormalId = (int)item.TID; Debug.WriteLine("get tid: " + avm.AbnormalId); avm.Meta = mm; avm.Abnormal = am; avms.Add(avm); } } return(avms); }
public DeviceManageViewModel() { DevicemaCommand = new DelegateCommand <object>(DevicemaShow); UseCommand = new DelegateCommand <object>(UseShow); NetCommand = new DelegateCommand <object>(NetShow); UpgradeCommand = new DelegateCommand <object>(UpgradeShow); AbnormalCommand = new DelegateCommand <object>(AbnormalShow); HardwareCommand = new DelegateCommand <object>(HardwareShow); _DevicemaViewModel = new DevicemaViewModel(); _UserViewModel = new UserViewModel(); _NetViewModel = new NetViewModel(); _UpgradeViewModel = new UpgradeViewModel(); _AbnormalViewModel = new AbnormalViewModel(); _HardwareViewModel = new HardwareViewModel(); bShowPage = DeviceVisibleEnum.DeviceVisibleEnum_Device; }