/// <summary>
/// 根据应用，分组，用户查询
/// </summary>
/// <param name="user_id"></param>
/// <param name="group_id"></param>
/// <param name="secret_id"></param>
/// <returns></returns>
public static async Task <user_face_storage> GetUser_By_UGS(string user_id, long group_id, string face_token, string secret_id)
{
string where = @" AND api_user_id = @user_id
AND api_group_id = @group_id
AND face_token = @face_token
AND secret_id = @secret_id
AND is_delete = @is_delete";
return(await SqlDapperHelper.ExecuteReaderRetTAsync <user_face_storage>(Select + where,
new { user_id, group_id, secret_id, face_token, is_delete = false }));
}
/// <summary>
/// 根据应用，分组，用户查询
/// </summary>
/// <param name="user_id"></param>
/// <param name="group_id"></param>
/// <param name="secret_id"></param>
/// <returns></returns>
public static async Task <user_face_storage> GetUser_By_UGS_ALL(string user_id, string secret_id)
{
string where = " AND api_user_id = @user_id AND secret_id = @secret_id AND is_delete=@is_delete";
return(await SqlDapperHelper.ExecuteReaderRetTAsync <user_face_storage>(Select + where,
new { user_id, secret_id, is_delete = false }));
}
/// <summary>
/// 根据用户ID，查询用户的预存
/// </summary>
/// <param name="user_id">用户ID</param>
/// <returns></returns>
public static async Task <user_face_compare_prepayment> GetUser_Face_Compare_Prepayment_By_User_id(long user_id)
{
string where = " AND public.user_face_compare_prepayment.user_id = @user_id";
return(await SqlDapperHelper.ExecuteReaderRetTAsync <user_face_compare_prepayment>(Select + where, new { user_id }));
}
/// <summary>
/// 根据User_id 查询 User
/// </summary>
/// <param name="user_id"></param>
/// <returns></returns>
public static async Task <user> GetUser_By_User_id_Async(long user_id)
{
string where = " AND id = @user_id";
return(await SqlDapperHelper.ExecuteReaderRetTAsync <user>(Select + where, new { user_id }));
}
/// <summary>
/// 根据Face_Token 查询图片是否存在
/// </summary>
/// <param name="face_token"></param>
/// <returns></returns>
public static async Task <user_face_detect_log> GetUser_Face_Detect_Log_By_Face_token(string face_token)
{
string where = " AND public.user_face_detect_log.face_token = @face_token";
//string orderBy = "";
return(await SqlDapperHelper.ExecuteReaderRetTAsync <user_face_detect_log>(Select + where, new { face_token }));
}
/// <summary>
/// 根据Key获取配置信息
/// </summary>
/// <param name="secret_key">密钥</param>
/// <returns></returns>
public static async Task <user_face_set> GetUser_Face_Set_By_Secret_key_Async(string secret_id)
{
string where = " AND public.user_face_set.secret_id = @secret_id";
return(await SqlDapperHelper.ExecuteReaderRetTAsync <user_face_set>(SelectSet + where, new { secret_id }));
}
/// <summary>
/// 根据Token 查询
/// </summary>
/// <param name="token"></param>
/// <returns></returns>
public static async Task <user_face_image_data> Getuser_face_image_data_By_Token_Async(string token)
{
string where = " AND token = @token";
return(await SqlDapperHelper.ExecuteReaderRetTAsync <user_face_image_data>(Select + where, new { token }));
}
/// <summary>
/// 根据应用ID和分组 查找数据
/// </summary>
/// <returns></returns>
public static async Task <user_face_storage_group> Get_storage_group_BySecretGroupAsync(string secret_id, string group_name)
{
string where = " AND is_delete=@is_delete AND secret_id = @secret_id AND group_name = @group_name";
return(await SqlDapperHelper.ExecuteReaderRetTAsync <user_face_storage_group>(SelectSql + where, new { secret_id, group_name, is_delete = false }));
}
/// <summary>
/// 根据用户ID获取用户每张图片设置的价格
/// </summary>
/// <param name="user_id"></param>
/// <returns></returns>
public static async Task <user_face_detect_price> GetUser_Face_Detect_Price_By_User_idAsync(long user_id)
{
string where = " AND public.user_face_detect_price.user_id = @user_id";
return(await SqlDapperHelper.ExecuteReaderRetTAsync <user_face_detect_price>(Select + where, new { user_id }));
}
