/// <summary>
/// 获取
/// </summary>
/// <param name="pins"></param>
/// <param name="ver"></param>
/// <returns></returns>
public List <TmpFaceModel> Get(string pin)
{
string sql = string.Format(@"
select * from TmpFace where pin ='{0}';", pin);
DataTable dt = SqliteHelper.GetDataTable(sql);
if (dt == null || dt.Rows.Count == 0)
{
return(new List <TmpFaceModel>());
}
List <TmpFaceModel> fps = new List <TmpFaceModel>();
foreach (DataRow row in dt.Rows)
{
TmpFaceModel fp = new TmpFaceModel();
fp.ID = Convert.ToInt32(row["ID"].ToString());
fp.Pin = row["PIN"].ToString();
fp.Fid = row["FID"].ToString();
fp.Size = Convert.ToInt32(row["Size"].ToString());
fp.Valid = row["Valid"].ToString();
fp.Tmp = row["Tmp"].ToString();
fp.Ver = row["Ver"].ToString();
fps.Add(fp);
}
return(fps);
}
//Face tmplate copy to Database
private void listenClient_OnNewFace(TmpFaceModel face)
{
if (FaceBll.Add(face) > 0)
{
//Cuando el usuario tenga una cara para cargar, actualice la cantidad de caras del usuario correspondiente en la lista
if (_currentPageId == (int)PageIdEnum.User && m_lastfrm != null)
{
((UCUser)m_lastfrm).UpdateUserFaceInfo(face);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(TmpFaceModel model)
{
string sql = string.Format(@"
delete from TmpFace where Pin =@Pin and Ver=@Ver and Fid=@Fid ;
insert into TmpFace(Pin,Fid,Size,Valid,Tmp,Ver)
values(@Pin,@Fid,@Size,@Valid,@Tmp,@Ver);
");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@Pin", model.Pin),
new SQLiteParameter("@Fid", model.Fid),
new SQLiteParameter("@Size", model.Size),
new SQLiteParameter("@Valid", model.Valid),
new SQLiteParameter("@Tmp", model.Tmp),
new SQLiteParameter("@Ver", model.Ver)
};
return(SqliteHelper.ExecuteNonQuery(sql.ToString(), parameters));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(TmpFaceModel model)
{
return(_dal.Add(model));
}
