/// <summary> /// Add /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(TmpBioDataModel model) { //判断是否存在,存在则更新 if (IsExist(model)) { return(Update(model)); } string sql = string.Format(@" insert into TmpBioData( [Pin], [No], [Index], [Valid], [Duress], [Type], [MajorVer], [MinorVer], [Format], [Tmp] ) values ( @Pin, @No, @Index, @Valid, @Duress, @Type, @MajorVer, @MinorVer, @Format, @Tmp );"); SQLiteParameter[] parameters = { new SQLiteParameter("@Pin", model.Pin.ToLower()), new SQLiteParameter("@No", model.No), new SQLiteParameter("@Index", model.Index), new SQLiteParameter("@Valid", model.Valid), new SQLiteParameter("@Duress", model.Duress), new SQLiteParameter("@Type", model.Type.ToLower()), new SQLiteParameter("@MajorVer", model.MajorVer.ToLower()), new SQLiteParameter("@MinorVer", model.MinorVer.ToLower()), new SQLiteParameter("@Format", model.Format.ToLower()), new SQLiteParameter("@Tmp", model.Tmp) }; return(SqliteHelper.ExecuteNonQuery(sql, parameters)); }
/// <summary> /// 获取 /// </summary> /// <param name="pins"></param> /// <param name="ver"></param> /// <returns></returns> public List <TmpBioDataModel> Get(string pin, string type) { string sql = string.Format(@" select * from TmpBioData where pin = '{0}' and type='{1}';", pin, type); DataTable dt = SqliteHelper.GetDataTable(sql); if (dt == null || dt.Rows.Count == 0) { return(new List <TmpBioDataModel>()); } List <TmpBioDataModel> bioList = new List <TmpBioDataModel>(); foreach (DataRow row in dt.Rows) { TmpBioDataModel bio = new TmpBioDataModel(); bio.ID = Tools.TryConvertToInt32(row["ID"].ToString()); bio.Pin = row["PIN"].ToString(); bio.No = row["No"].ToString(); bio.Index = row["Index"].ToString(); bio.Valid = row["Valid"].ToString(); bio.Duress = row["Duress"].ToString(); bio.Type = row["Type"].ToString(); bio.MajorVer = row["MajorVer"].ToString(); bio.MinorVer = row["MinorVer"].ToString(); bio.Format = row["Format"].ToString(); bio.Tmp = row["Tmp"].ToString(); bioList.Add(bio); } return(bioList); }
/// <summary> /// Update /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(TmpBioDataModel model) { string sql = string.Format(@" update TmpBioData set [Valid]=@Valid , [Duress]=@Duress , [Format]=@Format , [Tmp]=@Tmp where [pin]=@Pin and [no]=@No and [index]=@Index and [Type]=@Type; and [MajorVer]=@MajorVer and [MinorVer]=@MinorVer "); SQLiteParameter[] parameters = { new SQLiteParameter("@Pin", model.Pin), new SQLiteParameter("@No", model.No), new SQLiteParameter("@Index", model.Index), new SQLiteParameter("@Valid", model.Valid), new SQLiteParameter("@Duress", model.Duress), new SQLiteParameter("@Type", model.Type.ToLower()), new SQLiteParameter("@MajorVer", model.MajorVer.ToLower()), new SQLiteParameter("@MinorVer", model.MinorVer.ToLower()), new SQLiteParameter("@Format", model.Format), new SQLiteParameter("@Tmp", model.Tmp) }; return(SqliteHelper.ExecuteNonQuery(sql, parameters)); }
/// <summary> /// 更新掌静脉模板数量 /// </summary> /// <param name="face">人脸模板数据</param> public void UpdateUserPalmInfo(TmpBioDataModel palm) { if (_dt.Select($"PIN='{palm.Pin}'").Length > 0) { DataRow dataRow = _dt.Select($"PIN='{palm.Pin}'")[0]; dataRow["PalmCount"] = (Convert.ToInt32(dataRow["PalmCount"].ToString()) + 1).ToString(); this.dgvUser.DataSource = _dt; } }
/// <summary> /// Update /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(TmpBioDataModel model) { if (model == null || string.IsNullOrEmpty(model.Pin)) { return(-1); } return(_dal.Update(model)); }
//palm tmplate copy to Database private void listenClient_OnNewPalm(TmpBioDataModel palm) { if (BioDataBll.Add(palm) > 0) { if (_currentPageId == (int)PageIdEnum.User && m_lastfrm != null) { ((UCUser)m_lastfrm).UpdateUserPalmInfo(palm); } } }
/// <summary> /// IsExist /// </summary> /// <param name="model"></param> /// <returns></returns> public bool IsExist(TmpBioDataModel model) { return(IsExist(model.Pin, model.No, model.Index, model.Type, model.MajorVer, model.MinorVer)); }
/// <summary> /// IsExist /// </summary> /// <param name="model"></param> /// <returns></returns> public bool IsExist(TmpBioDataModel model) { return(_dal.IsExist(model)); }