/// <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;
}
