public List <ComplexInfoModel> QueryVideo() { List <ComplexInfoModel> l = new List <ComplexInfoModel>(); using (IDbConnection conn = SqlHelper.GetConnection()) { conn.Open(); var sql = @"SELECT DISTINCT VIDEOID,TASKCODE FROM TB_METADATA,TB_ABNORMAL WHERE TB_METADATA.ID = TB_ABNORMAL.VIDEOID ORDER BY VIDEOID DESC;"; IEnumerable <dynamic> dynamics = conn.Query(sql); foreach (var item in dynamics) { ComplexInfoModel c = new ComplexInfoModel(); c.Key = Convert.ToString(item.VIDEOID); c.Text = item.TASKCODE; l.Add(c); } } return(l); }
/// <summary> /// 标注界面 /// 获取已分帧的视频列表 /// </summary> /// <returns></returns> public List <ComplexInfoModel> QueryVideoFramed() { List <ComplexInfoModel> l = new List <ComplexInfoModel>(); using (IDbConnection conn = SqlHelper.GetConnection()) { conn.Open(); var sql = @"SELECT ID,TASKCODE FROM TB_METADATA WHERE FRAMEPATH IS NOT NULL ORDER BY ID DESC;"; IEnumerable <dynamic> dynamics = conn.Query(sql); foreach (var item in dynamics) { ComplexInfoModel c = new ComplexInfoModel(); c.Key = Convert.ToString(item.ID); c.Text = item.TASKCODE; l.Add(c); } } return(l); }