/// <summary> /// 获取人脸坐标(68个点) /// </summary> /// <param name="files"></param> /// <returns></returns> public ActionResult GetFaceLink(string image) { //var lines = await GetLinesAsync(new List<IFormFile>() { file }); //if (lines.Count <= 0) //{ // return Ok(null); //} (Bitmap, string)bitmap = (null, null); // 获取图片文件 //bitmap = model.image_type.ToUpper() == "BASE64" ? FileCommon.Base64ToBitmap(model.image) : FileCommon.UrlToBitmap(model.image); bitmap = FileCommon.UrlToBitmap(image); var date = FaceLandmarkDetectionCompute.GetLandmark(bitmap.Item1); //var hh= FaceLandmarkDetectionCompute.Getlines(date); return(Ok(date)); }
/// <summary> /// 人脸更新 /// </summary> /// <returns></returns> public async Task<ActionResult> UpdateFace(FaceDatabaseModel.UserFaceModel model) { // 一系列检查 RequestFaceModel request = new RequestFaceModel() { Status = 500, Message = null, FaceList = null }; var userFaceSet = Verify(ref request, model); // 基本验证 if (userFaceSet == null) { return Ok(request); } // 判断是否存在此用户,是否存在此分组 // 判断是否有同样的人,判断是否有此分组 var group = await Service_user_face_storage_group.Get_storage_group_BySecretGroupAsync(model.secret_id, model.group_id); if (group == null) { request.Enum = RequestEnum.数据不存在; return Ok(request); } user_face_storage group_user = null; if (model.group_id == "@ALL") { group_user = await Service_user_face_storage.GetUser_By_UGS_ALL(model.user_id, model.secret_id); } else { group_user = await Service_user_face_storage.GetUser_By_UGS(model.user_id, group.id, model.secret_id); } if (group_user == null) { request.Enum = RequestEnum.数据不存在; return Ok(request); } // 将以前的人脸状态变为删除 user_face_storage user = new user_face_storage() { is_delete = true, updated_at = DateTime.Now, secret_id = model.secret_id }; // 增加一个人脸 #region 获取图片 var face_token = string.Empty; (Bitmap, string) bitmap = (null, null); // 获取图片文件 bitmap = model.image_type.ToUpper() == "BASE64" ? FileCommon.Base64ToBitmap(model.image) : FileCommon.UrlToBitmap(model.image); if (bitmap.Item1 == null && !string.IsNullOrEmpty(bitmap.Item2)) { if (model.image_type.ToUpper() == "BASE64") { request.Enum = RequestEnum.Base64图片格式错误; } else { request.Enum = RequestEnum.从图片的url下载图片失败; } return Ok(request); } #endregion #region 图片以及数据处理 // 查找是否有相同的图片 face_token = model.image_type.ToUpper() == "BASE64" ? EncryptProvider.Md5(model.image) : EncryptProvider.Md5(FileCommon.BitmapToBase64(bitmap.Item1)); // 查询 图片库 var user_images = await Service_user_face_image_data.Getuser_face_image_data_By_Token_Async(face_token); if (user_images != null) { bitmap.Item2 = user_images.url; } else { try { // 存入本地 bitmap.Item2 = FileCommon.SaveBitmap(bitmap.Item1, bitmap.Item2); } catch (Exception ex) { LogHelperNLog.Error(ex); request.Enum = RequestEnum.数据存储处理失败; return Ok(request); } } // 获取人脸数据 //var faceDate = FaceDetectionCompute.GetRectangle(bitmap.Item1); DlibDotNet.Rectangle[] faceDate = new DlibDotNet.Rectangle[0]; try { // 截取人像,面积排序 faceDate = FaceDetectionCompute.GetRectangle(bitmap.Item1).OrderByDescending(d => d.Area).Take(1).ToArray(); } catch (Exception ex) { LogHelperNLog.Error(ex, "FaceDetectionCompute.GetRectangles:人脸获取坐标出错"); request.Enum = RequestEnum.无法解析人脸; return Ok(request); } #endregion request.Enum = RequestEnum.Succeed; request.Location = faceDate; #region 日志&&扣费 try { DateTime dateTime = DateTime.Now; // 图片保存到数据库 user_images = new user_face_image_data() { token = face_token, url = bitmap.Item2, created_at = dateTime, updated_at = dateTime }; //查找分组信息 user.api_group_id = group.id; //用户信息 user_face_storage face_Storage = new user_face_storage() { user_id = userFaceSet.user_id, secret_id = model.secret_id, face_token = face_token, image = bitmap.Item2, image_type = model.image_type, api_group_id = group.id, api_user_id = model.user_id, api_user_info = model.user_info, quality_control = model.quality_control, liveness_control = model.quality_control, sign = model.sign, timestamp = model.timestamp, is_delete = false, api_respone = JsonConvert.SerializeObject(request, UnderlineSplitContractResolver.GetSettings()), created_at = dateTime, updated_at = dateTime }; using (var tra = SqlDapperHelper.GetOpenConnection().BeginTransaction()) { await Service_user_face_storage.Remove_Storage_By_ApiUserID(user, tra); if (user_images == null) { await Service_user_face_image_data.Creatuser_face_image_data(user_images, tra); } await SqlDapperHelper.ExecuteInsertAsync(face_Storage, tra); tra.Commit(); } } catch (Exception ex) { LogHelperNLog.Error(ex, "操作日志添加失败"); request.Enum = RequestEnum.操作日志添加失败; } #endregion return Ok(request); }
/// <summary> /// 获取人脸坐标(单个文件) /// </summary> /// <param name="files"></param> /// <returns></returns> public async Task <ActionResult> GetFaceLocation(FaceLocationsViewModel model) { RequestFaceModel request = new RequestFaceModel() { Status = 500, Message = null, FaceList = null }; #region 基本验证 // 模型验证 if (!ModelState.IsValid) { request.Message = ModelState.Where(e => e.Value.Errors.Count > 0).FirstOrDefault().Value.Errors[0].ErrorMessage; request.Status = (int)RequestEnum.必要参数未传入; return(Ok(request)); } // 根据 secretkey 获取set var userFaceSet = await Service_user_face_set.GetUser_Face_Set_By_Secret_key_Async(model.secret_id); if (userFaceSet == null) { // 您未开通此项目 request.Enum = RequestEnum.没有接口权限; return(Ok(request)); } // 签名判断 var dic = ModleToDictionary.GetProperties(model); var key = userFaceSet.secret_key; dic.Remove("sign"); var sign = Signature.GetSign(dic, key); if (sign != model.sign) { // 签名错误 request.Enum = RequestEnum.签名错误; return(Ok(request)); } #endregion #region 余额逻辑判断 // 根据 userFaceSet.user_id 获取用户信息 var user = await Service_user.GetUser_By_User_id_Async(userFaceSet.user_id); // 根据user_id 先查预付款,未查询到则扣费使用 var prepayment = await Service_user_face_detect_prepayment.GetUser_Face_Detect_Prepayment_By_User_id_Asynv(user.id); user_face_detect_price derectPrice = null; if (prepayment == null || prepayment.number <= 0) { prepayment = null; derectPrice = await Service_user_face_detect_price.GetUser_Face_Detect_Price_By_User_idAsync(user.id); if (derectPrice == null) { // 用户没有预付费次数 request.Enum = RequestEnum.没有预付费次数未开通余额付款; } else { // 查询用户余额 derectPrice.price>余额 if (user.use_amount < derectPrice.price) { // 预付费次数为0,余额不足 request.Enum = RequestEnum.预付费次数为0且余额不足; } } } // 用户余额验证 if (!string.IsNullOrEmpty(request.Message)) { return(Ok(request)); } #endregion #region 获取图片 // 变量初始化 var face_token = string.Empty; (Bitmap, string)bitmap = (null, null); if (model.image_type.ToUpper() == "FACE_TOKEN") { if (model.image.Length > 50) { request.Enum = RequestEnum.face_token格式错误; return(Ok(request)); } var detect = await Service_user_face_detect_log.GetUser_Face_Detect_Log_By_Face_token(model.image); if (detect == null) { request.Enum = RequestEnum.face_token不存在; return(Ok(request)); } bitmap.Item2 = detect.image; var obj = JsonConvert.DeserializeObject <dynamic>(detect.api_respone); request.FaceList = obj.face_list; request.FaceNum = obj.face_num; face_token = model.image; } else { // 获取图片文件 bitmap = model.image_type.ToUpper() == "BASE64" ? FileCommon.Base64ToBitmap(model.image) : FileCommon.UrlToBitmap(model.image); if (bitmap.Item1 == null && !string.IsNullOrEmpty(bitmap.Item2)) { if (model.image_type.ToUpper() == "BASE64") { request.Enum = RequestEnum.Base64图片格式错误; } else { request.Enum = RequestEnum.从图片的url下载图片失败; } return(Ok(request)); } } #endregion #region 图片以及数据处理 // 不是 FACE_TOKEN 的处理方式 if (model.image_type.ToUpper() != "FACE_TOKEN") { // 查找是否有相同的图片 face_token = model.image_type.ToUpper() == "BASE64" ? EncryptProvider.Md5(model.image) : EncryptProvider.Md5(FileCommon.BitmapToBase64(bitmap.Item1)); var detect_Log = await Service_user_face_detect_log.GetUser_Face_Detect_Log_By_Face_token(face_token); if (detect_Log != null) { bitmap.Item2 = detect_Log.image; } else { try { // 存入本地 bitmap.Item2 = FileCommon.SaveBitmap(bitmap.Item1, bitmap.Item2); } catch (Exception ex) { LogHelperNLog.Error(ex); request.Enum = RequestEnum.数据存储处理失败; return(Ok(request)); } } // 获取人脸数据 //var faceDate = FaceDetectionCompute.GetRectangle(bitmap.Item1); DlibDotNet.Rectangle[] faceDate = new DlibDotNet.Rectangle[0]; try { // 截取人像,面积排序 faceDate = FaceDetectionCompute.GetRectangle(bitmap.Item1).OrderByDescending(d => d.Area).Take(model.max_face_num).ToArray(); //faceDate = FaceDetectionCompute.GetResult(bitmap.Item2); } catch (Exception ex) { LogHelperNLog.Error(ex, "FaceDetectionCompute.GetRectangles:人脸获取坐标出错"); request.Enum = RequestEnum.无法解析人脸; return(Ok(request)); } // 人脸关键点识别 var landmark68 = FaceLandmarkDetectionCompute.DetsTolandmark68(bitmap.Item1, faceDate); if (model.face_field.ToUpper().Contains("LANDMARK")) { request.LandmarkList = landmark68.Select(x => x.Item1); } // 人脸旋转角度 var angles = FaceDetectionCompute.GetRotationAngle(landmark68.Select(x => x.Item2)); // 人脸之态预测 var gesture = FaceDetectionCompute.GetFaceGesture(landmark68.Select(x => x.Item2), bitmap.Item1.Width, bitmap.Item1.Height); if (faceDate != null) { // 返回数据格式处理 var json = JsonConvert.SerializeObject(faceDate); var data = JsonConvert.DeserializeObject <List <FaceLocationsOutMdole> >(json); //data = data.OrderByDescending(d => d.Area).Take(model.max_face_num).ToList(); data.ForEach(x => { x.FaceToken = face_token; }); for (int i = 0; i < data.Count; i++) { data[i].FaceToken = face_token; data[i].Angle = angles[i]; data[i].Gesture = new Gesture() { Pitch = gesture[i].Item1, Yaw = gesture[i].Item2, Roll = gesture[i].Item3 }; } request.FaceList = data; request.FaceNum = data.Count(); } } #endregion request.Enum = RequestEnum.Succeed; #region 日志&&扣费 try { // 预付费/扣费 log // 时间戳 DateTime dateTime = DateTime.Now; user_face_detect_prepayment_detail prepayment_Detail = null; user_amount_detail amount_Detail = null; if (prepayment != null) { prepayment_Detail = new user_face_detect_prepayment_detail() { user_id = user.id, change_number = -1, now_number = prepayment.number - 1, info = string.Format("应用ID:{0},图片名称:{1}", model.secret_id, bitmap.Item2), created_at = dateTime, updated_at = dateTime }; } else { amount_Detail = new user_amount_detail() { user_id = user.id, change_amount = -derectPrice.price, now_amount = user.use_amount - derectPrice.price, info = string.Format("应用ID:{0},图片名称:{1},费用:{2}", model.secret_id, bitmap.Item2, derectPrice.price), created_at = dateTime, updated_at = dateTime, type = 0 }; } // 操作信息 user_face_detect_log face_Detect_Log = new user_face_detect_log() { user_id = user.id, secret_id = model.secret_id, face_token = face_token, image = bitmap.Item2, image_type = model.image_type, face_field = model.face_field, max_face_num = model.max_face_num, face_type = model.face_type, is_deductions_success = true, api_respone = JsonConvert.SerializeObject(request, UnderlineSplitContractResolver.GetSettings()), timestamp = Timelong.GetUnixDateTime(model.timestamp), sign = sign, created_at = dateTime, updated_at = dateTime, is_search = 1, }; // 修改余额,存库,日志 using (var tra = SqlDapperHelper.GetOpenConnection().BeginTransaction()) { if (prepayment != null) { await SqlDapperHelper.ExecuteInsertAsync(prepayment_Detail, tra); await Service_user_face_detect_prepayment.MinusUsernumber_By_User_id(prepayment_Detail, tra); } else { await SqlDapperHelper.ExecuteInsertAsync(amount_Detail, tra); await Service_user.MinusUserAmount_By_User_id(amount_Detail); } await SqlDapperHelper.ExecuteInsertAsync(face_Detect_Log, tra); tra.Commit(); } } catch (Exception ex) { LogHelperNLog.Error(ex, "操作日志添加失败"); request.Enum = RequestEnum.操作日志添加失败; return(Ok(request)); } #endregion return(Ok(request)); }
public async Task <ActionResult> Search(FaceFindModel.Search model) { RequestFaceModel request = new RequestFaceModel() { Status = 500, Message = null, FaceList = null }; #region 基本验证 // 模型验证 if (!ModelState.IsValid) { request.Message = ModelState.Where(e => e.Value.Errors.Count > 0).FirstOrDefault().Value.Errors[0].ErrorMessage; request.Status = (int)RequestEnum.必要参数未传入; return(Ok(request)); } // 根据 secretkey 获取set var userFaceSet = await Service_user_face_set.GetUser_Face_Set_By_Secret_key_Async(model.secret_id); if (userFaceSet == null) { // 您未开通此项目 request.Enum = RequestEnum.没有接口权限; return(Ok(request)); } // 签名判断 var dic = ModleToDictionary.GetProperties(model); var key = userFaceSet.secret_key; dic.Remove("sign"); var sign = Signature.GetSign(dic, key); if (sign != model.sign) { // 签名错误 request.Enum = RequestEnum.签名错误; return(Ok(request)); } #endregion #region 获取图片 var face_token = string.Empty; (Bitmap, string)bitmap = (null, null); // 获取图片文件 bitmap = model.image_type.ToUpper() == "BASE64" ? FileCommon.Base64ToBitmap(model.image) : FileCommon.UrlToBitmap(model.image); if (bitmap.Item1 == null && !string.IsNullOrEmpty(bitmap.Item2)) { if (model.image_type.ToUpper() == "BASE64") { request.Enum = RequestEnum.Base64图片格式错误; } else { request.Enum = RequestEnum.从图片的url下载图片失败; } return(Ok(request)); } #endregion #region 图片以及数据处理 // 查找是否有相同的图片 face_token = model.image_type.ToUpper() == "BASE64" ? EncryptProvider.Md5(model.image) : EncryptProvider.Md5(FileCommon.BitmapToBase64(bitmap.Item1)); // 查询 图片库 // 判断是否还需要进行图片存储 var user_images = await Service_user_face_image_data.Getuser_face_image_data_By_Token_Async(face_token); if (user_images != null) { bitmap.Item2 = user_images.url; } else { try { // 存入本地 bitmap.Item2 = FileCommon.SaveBitmap(bitmap.Item1, bitmap.Item2); } catch (Exception ex) { LogHelperNLog.Error(ex); request.Enum = RequestEnum.数据存储处理失败; return(Ok(request)); } } #endregion //var bitmaps = "从数据库查询,然后加载Bitmap"; // 查询分组 var groupList = await Service_user_face_storage_group.Get_storage_group_BySecretGroupAsync(model.secret_id, model.group_id_list.Split(',')); // 查询到用户信息 var users = await Service_user_face_storage.GetUserList_By_UGS(model.user_id, groupList.Select(x => x.id).ToList(), model.secret_id); var bitmaps = FileCommon.SrcToBitmap(users.Select(x => x.image)); var difference = DnnFaceRecognitionCompute.GetOutputLabels(bitmap.Item1, bitmaps); // 过滤相识度 List <FaceFindOutModel.User> list = new List <FaceFindOutModel.User>(); for (int i = 0; i < bitmaps.Count; i++) { var group = groupList.FirstOrDefault(x => x.id == users[i].api_group_id); list.Add(new FaceFindOutModel.User { GroupId = group != null ? group.group_name : null, UserId = users[i].api_user_id, UserInfo = users[i].api_user_info, Score = difference[i].Item1 }); } request.FaceToken = face_token; request.FaceList = list; // 数据处理,存库,日志 return(Ok(request)); }
public async Task <ActionResult> FaceContrast([FromBody] FaceContrastViewModel model) { RequestFaceModel request = new RequestFaceModel() { Status = 500, Message = null, FaceList = null }; #region 基本验证 // 模型验证 if (!ModelState.IsValid) { request.Message = ModelState.Where(e => e.Value.Errors.Count > 0).FirstOrDefault().Value.Errors[0].ErrorMessage; request.Status = (int)RequestEnum.必要参数未传入; return(Ok(request)); } // 根据 secretkey 获取set var userFaceSet = await Service_user_face_set.GetUser_Face_Set_By_Secret_key_Async(model.secret_id); if (userFaceSet == null) { // 您未开通此项目 request.Enum = RequestEnum.没有接口权限; return(Ok(request)); } // 签名判断 var dic = ModleToDictionary.GetProperties(model); var key = userFaceSet.secret_key; dic.Remove("face_field"); dic.Remove("sign"); var sign = Signature.GetSign(dic, key); if (sign != model.sign) { // 签名错误 request.Enum = RequestEnum.签名错误; return(Ok(request)); } #endregion #region 余额逻辑判断 // 根据 userFaceSet.user_id 获取用户信息 var user = await Service_user.GetUser_By_User_id_Async(userFaceSet.user_id); //Service_user_face_compare_prepayment // 根据user_id 先查预付款,未查询到则扣费使用 var prepayment = await Service_user_face_compare_prepayment.GetUser_Face_Compare_Prepayment_By_User_id(user.id); user_face_compare_price comparePrice = null; if (prepayment == null || prepayment.number <= 0) { prepayment = null; comparePrice = await Service_user_face_compare_price.GetUser_Face_Compare_Price_By_User_idAsync(user.id); if (comparePrice == null) { // 用户没有预付费次数 request.Enum = RequestEnum.没有预付费次数未开通余额付款; } else { // 查询用户余额 derectPrice.price>余额 if (user.use_amount < comparePrice.price) { // 预付费次数为0,余额不足 request.Enum = RequestEnum.预付费次数为0且余额不足; } } } // 用户余额验证 if (!string.IsNullOrEmpty(request.Message)) { return(Ok(request)); } #endregion #region 获取图片 List <(Bitmap, string)> bitmaps = new List <(Bitmap, string)>(); List <ContrastData> face_tokens = new List <ContrastData>(); for (int i = 0; i < model.images.Count; i++) { var image = model.images[i]; var face_token = string.Empty; (Bitmap, string)bitmap = (null, null); // 获取图片文件 bitmap = image.image_type.ToUpper() == "BASE64" ? FileCommon.Base64ToBitmap(image.image) : FileCommon.UrlToBitmap(image.image); if (bitmap.Item1 == null && !string.IsNullOrEmpty(bitmap.Item2)) { if (image.image_type.ToUpper() == "BASE64") { request.Enum = RequestEnum.Base64图片格式错误; } else { request.Enum = RequestEnum.从图片的url下载图片失败; } return(Ok(request)); } #endregion #region 图片以及数据处理 // 查找是否有相同的图片 face_token = image.image_type.ToUpper() == "BASE64" ? EncryptProvider.Md5(image.image) : EncryptProvider.Md5(FileCommon.BitmapToBase64(bitmap.Item1)); // 查询 图片库 // 判断是否还需要进行图片存储 var user_images = await Service_user_face_image_data.Getuser_face_image_data_By_Token_Async(face_token); if (user_images != null) { bitmap.Item2 = user_images.url; } else { try { // 存入本地 bitmap.Item2 = FileCommon.SaveBitmap(bitmap.Item1, bitmap.Item2); } catch (Exception ex) { LogHelperNLog.Error(ex); request.Enum = RequestEnum.数据存储处理失败; return(Ok(request)); } } bitmaps.Add(bitmap); face_tokens.Add(new ContrastData() { face_token = face_token }); } #region old Code //foreach (var image in model.images) //{ // // 变量初始化 // var face_token = string.Empty; // (Bitmap, string) bitmap = (null, null); // bitmap = image.image_type.ToUpper() == "BASE64" ? FileCommon.Base64ToBitmap(image.image) : FileCommon.UrlToBitmap(image.image); // if (bitmap.Item1 == null && !string.IsNullOrEmpty(bitmap.Item2)) // { // if (image.image_type.ToUpper() == "BASE64") // { // request.Enum = RequestEnum.Base64图片格式错误; // request.Message = string.IsNullOrEmpty(request.Message) ? num + RequestEnum.Base64图片格式错误.ToString() : request.Message + num + RequestEnum.Base64图片格式错误.ToString(); // } // else // { // request.Enum = RequestEnum.从图片的url下载图片失败; // request.Message = string.IsNullOrEmpty(request.Message) ? num + RequestEnum.从图片的url下载图片失败.ToString() : request.Message + num + RequestEnum.从图片的url下载图片失败.ToString(); // } // return Ok(request); // } // bitmaps.Add(bitmap); //} //#endregion //#region 图片以及数据处理 //List<ContrastData> face_tokens = new List<ContrastData>(); //for (int i = 0; i < bitmaps.Count; i++) //{ // var face_token = string.Empty; // face_token = EncryptProvider.Md5(FileCommon.BitmapToBase64(bitmaps[i].Item1)); // //此处后期要更改为人脸库的图片 // var detect_Log = await Service_user_face_detect_log.GetUser_Face_Detect_Log_By_Face_token(face_token); // if (detect_Log != null) // { // bitmaps[i] = (bitmaps[i].Item1, detect_Log.image); // //bitmaps[i].Item2 = detect_Log.image; // } // else // { // try // { // // 存入本地 // bitmaps[i] = (bitmaps[i].Item1, FileCommon.SaveBitmap(bitmaps[i].Item1, bitmaps[i].Item2)); // } // catch (Exception ex) // { // LogHelperNLog.Error(ex); // request.Enum = RequestEnum.数据存储处理失败; // return Ok(request); // } // } // face_tokens.Add(new ContrastData() { // face_token=face_token // }); //} #endregion var difference = DnnFaceRecognitionCompute.GetOutputLabels(bitmaps[0].Item1, bitmaps[1].Item1); // 是否需要人脸位置 if (model.face_field.ToUpper().Contains("FACE_SHAPE")) { for (int i = 0; i < face_tokens.Count; i++) { face_tokens[i].rectangles = difference.Item2[i]; } } request.FaceList = face_tokens; request.Score = difference.Item1; #endregion request.Enum = RequestEnum.Succeed; //日志&&扣费 try { // 预付费/扣费 log // 时间戳 DateTime dateTime = DateTime.Now; user_face_compare_prepayment_detail prepayment_Detail = null; user_amount_detail amount_Detail = null; if (prepayment != null) { prepayment_Detail = new user_face_compare_prepayment_detail() { user_id = user.id, change_number = -1, now_number = prepayment.number - 1, info = string.Format("应用ID:{0}", model.secret_id), created_at = dateTime, updated_at = dateTime }; } else { amount_Detail = new user_amount_detail() { user_id = user.id, change_amount = -comparePrice.price, now_amount = user.use_amount - comparePrice.price, info = string.Format("应用ID:{0},费用:{1}", model.secret_id, comparePrice.price), created_at = dateTime, updated_at = dateTime, type = 0 }; } // 操作信息 user_face_compare_log face_Compare_Log = new user_face_compare_log() { user_id = user.id, secret_id = model.secret_id, image = JsonConvert.SerializeObject(bitmaps.Select(x => x.Item2)), is_deductions_success = true, api_respone = JsonConvert.SerializeObject(request, UnderlineSplitContractResolver.GetSettings()), timestamp = Timelong.GetUnixDateTime(model.timestamp), sign = sign, created_at = dateTime, updated_at = dateTime, }; // 修改余额,存库,日志 using (var tra = SqlDapperHelper.GetOpenConnection().BeginTransaction()) { if (prepayment != null) { await SqlDapperHelper.ExecuteInsertAsync(prepayment_Detail, tra); await Service_user_face_compare_prepayment.MinusUsernumber_By_User_id(prepayment_Detail, tra); } else { await SqlDapperHelper.ExecuteInsertAsync(amount_Detail, tra); await Service_user.MinusUserAmount_By_User_id(amount_Detail); } await SqlDapperHelper.ExecuteInsertAsync(face_Compare_Log, tra); tra.Commit(); } } catch (Exception ex) { LogHelperNLog.Error(ex, "操作日志添加失败"); request.Enum = RequestEnum.操作日志添加失败; return(Ok(request)); } return(Ok(request)); }