public List <User> FuzzyFindUserByName(String name) { name = "张进"; string query = "SELECT * FROM `face-reco`.`face` WHERE name like '" + name + "'"; List <User> userList = new List <User>(); if (this.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query, connection); // 命令+请求 MySqlDataReader dataReader = cmd.ExecuteReader(); // 读取数据 while (dataReader.Read()) { User user = new User(); user.Id = Convert.ToString(dataReader["id"]); user.Name = Convert.ToString(dataReader["name"]); user.Utoken = Convert.ToString(dataReader["utoken"]); user.Department = Convert.ToString(dataReader["department"]); user.Feature = TabConvert.ObjectToBytes(dataReader["feature"]).Skip(27).Take(1032).ToArray(); user.ChannelId = Convert.ToInt32(dataReader["channel_id"]); user.strUserID = Convert.ToString(dataReader["uid"]); user.strWorkCode = Convert.ToString(dataReader["work_code"]); user.strPassword = Convert.ToString(dataReader["password"]); user.dwOrigin = Convert.ToInt16(dataReader["origin"]); //user.strMobilePhone = Convert. userList.Add(user); } dataReader.Close(); this.CloseConnection();// 关闭连接 } return(userList); }
/// <summary> /// 通过特征比对用户 /// </summary> /// <returns></returns> public List <byte[]> SelectUserFaceByFeature() { string query = "SELECT `feature` FROM `face-reco`.`face`";// 全部查询 // 创建list存储数据 List <byte[]> list = new List <byte[]>(); byte[] faceFeature = null; byte[] finalFaceFeature = null; //Open connection if (this.OpenConnection() == true) { // 创建命令 MySqlCommand cmd = new MySqlCommand(query, connection); // 读取数据 MySqlDataReader dataReader = cmd.ExecuteReader(); // 存储数据 while (dataReader.Read()) { faceFeature = TabConvert.ObjectToBytes(dataReader["feature"]); finalFaceFeature = faceFeature.Skip(27).Take(1032).ToArray();// 从第5位开始截取3个字节 list.Add(finalFaceFeature); } //close Data Reader dataReader.Close(); //close Connection this.CloseConnection(); //return list to be displayed return(list); } else { return(list); } }