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