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