/// <summary>
/// 修改是否删除状态
/// </summary>
/// <param name="group"></param>
/// <param name="tra"></param>
/// <returns></returns>
public static async Task <long> Remove_storage_group(user_face_storage_group group, IDbTransaction tra = null)
{
string set = "is_delete = @is_delete , updated_at = @updated_at";
string where = "AND user_id = @user_id AND group_name = @group_name AND secret_id = @secret_id";
return(await SqlDapperHelper.ExecuteSqlIntAsync(string.Format(UpdateSql + where, set), group, tra));
}
/// <summary>
/// 根据用户组将用户的状态变为删除
/// </summary>
/// <param name="user"></param>
/// <param name="tra"></param>
/// <returns></returns> Remove_Storage_By_Group
public static async Task <long> Remove_Storage_By_Group(user_face_storage_group group, IDbTransaction tra = null)
{
string set = "is_delete = @is_delete , updated_at = @updated_at";
string where = " AND api_group_id = @api_group_id AND secret_id = @secret_id";
return(await SqlDapperHelper.ExecuteSqlIntAsync(string.Format(Update + where, set),
new
{
is_delete = group.is_delete,
updated_at = group.updated_at,
api_group_id = group.id,
secret_id = group.secret_id
}, tra));
}
/// <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);
}
