/// <summary> /// 删除用户组 /// </summary> /// <returns></returns> public async Task<ActionResult> RemoveGroup(FaceDatabaseModel.GroupModel 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); } group.is_delete = true;//是否移除 group.updated_at = DateTime.Now; try { using (var tra = SqlDapperHelper.GetOpenConnection().BeginTransaction()) { // 修改用户的删除状态 await Service_user_face_storage.Remove_Storage_By_Group(group, tra); // 修改用户组的删除状态 await Service_user_face_storage_group.Remove_storage_group(group, tra); tra.Commit(); request.Enum = RequestEnum.Succeed; } } catch (Exception ex) { LogHelperNLog.Error(ex, "操作日志添加失败"); request.Enum = RequestEnum.操作日志添加失败; } return Ok(request); }
/// <summary> /// 创建用户组 /// </summary> /// <returns></returns> public async Task<ActionResult> CreatGroup(FaceDatabaseModel.GroupModel model) { RequestFaceModel request = new RequestFaceModel() { Status = 500, Message = null, FaceList = null }; //FaceDatabaseModel.CreatGroupModel creatGroup = new FaceDatabaseModel.CreatGroupModel(); // 基本验证 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); } // 扣费等验证 // 保存到数据库 request.Enum = RequestEnum.Succeed; DateTime dateTime_Now = DateTime.Now; try { using (var tra = SqlDapperHelper.GetOpenConnection().BeginTransaction()) { long num = 0; user_face_storage_group storage_Group = new user_face_storage_group() { user_id = userFaceSet.user_id, group_name = model.group_id, remake = "", created_at = dateTime_Now, secret_id = model.secret_id, updated_at = dateTime_Now, api_respone = JsonConvert.SerializeObject(request, UnderlineSplitContractResolver.GetSettings()), is_delete = false }; num += await SqlDapperHelper.ExecuteInsertAsync(storage_Group); if (num >= 0) { tra.Commit(); } else { request.Enum = RequestEnum.数据存储处理失败; } } } catch (Exception ex) { LogHelperNLog.Error(ex, "操作日志添加失败"); request.Enum = RequestEnum.操作日志添加失败; return Ok(request); } return Ok(request); }