/// <summary>
/// 获取
/// </summary>
/// <param name="pins"></param>
/// <returns></returns>
public List <TmpFPModel> Get(string pin)
{
string sql = string.Format(@"
select * from TmpFP where pin = '{0}';", pin);
DataTable dt = SqliteHelper.GetDataTable(sql);
if (dt == null || dt.Rows.Count == 0)
{
return(new List <TmpFPModel>());
}
List <TmpFPModel> fps = new List <TmpFPModel>();
foreach (DataRow row in dt.Rows)
{
TmpFPModel fp = new TmpFPModel();
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.MajorVer = row["MajorVer"].ToString();
fp.MinorVer = row["MinorVer"].ToString();
fp.Duress = row["Duress"].ToString();
fps.Add(fp);
}
return(fps);
}
/// <summary>
/// 更新10.0算法指纹模板数量
/// </summary>
/// <param name="fpver10">10.0算法指纹数据</param>
public void UpdateUserFP10Info(TmpFPModel fpver10)
{
if (_dt.Select($"PIN='{fpver10.Pin}'").Length > 0)
{
DataRow dataRow = _dt.Select($"PIN='{fpver10.Pin}'")[0];
dataRow["FP10Count"] = (Convert.ToInt32(dataRow["FP10Count"].ToString()) + 1).ToString();
this.dgvUser.DataSource = _dt;
}
}
private void listenClient_OnNewFP(TmpFPModel fp)
{
if (FPBll.Add(fp) > 0)
{
if (_currentPageId == (int)PageIdEnum.User && m_lastfrm != null)
{
if (fp.MajorVer == "9")
{
((UCUser)m_lastfrm).UpdateUserFP9Info(fp);
}
else if (fp.MajorVer == "10")
{
((UCUser)m_lastfrm).UpdateUserFP10Info(fp);
}
}
}
// Cuando el usuario tiene una huella digital para cargar, actualice el número de huellas digitales del usuario correspondiente en la lista
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(TmpFPModel model)
{
string sql = string.Format(@"
delete from TmpFP where Pin =@Pin and MajorVer=@MajorVer and Fid=@Fid ;
insert into TmpFP(Pin,Fid,Size,Valid,Tmp,MajorVer,MinorVer,Duress)
values(@Pin,@Fid,@Size,@Valid,@Tmp,@MajorVer,@MinorVer,@Duress);
");
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("@MajorVer", model.MajorVer),
new SQLiteParameter("@MinorVer", model.MinorVer),
new SQLiteParameter("@Duress", model.Duress)
};
return(SqliteHelper.ExecuteNonQuery(sql.ToString(), parameters));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(TmpFPModel model)
{
return(_dal.Add(model));
}