C# (CSharp) TmpBioDataModel Examples

Example #1

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

Example #2

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

Example #3

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

Example #4

File: UCUser.cs Project: esumanjoseluisrivera/SDK_ZK_Push_DEMO

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

Example #5

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

Example #6

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

Example #7

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

Example #8

 /// <summary>
 /// IsExist
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public bool IsExist(TmpBioDataModel model)
 {
     return(_dal.IsExist(model));
 }