public async Task <int> Add(RoleStrActions roleStrActions) { return(await WithConnection(async c => { StringBuilder sql = new StringBuilder(); IDbTransaction trans = c.BeginTransaction(); try { sql.Append(" insert into Role ") .Append(" values (0,@role_name,@description, ") .Append(" @CreatedTime,@CreatedBy,@UpdatedTime,@UpdatedBy); ") .Append("select last_insert_id()"); int result = await c.QueryFirstOrDefaultAsync <int>(sql.ToString(), roleStrActions, trans); foreach (string item in roleStrActions.actions.Split(',')) { sql.Clear(); sql.Append(" insert into Role_Action ") .Append(" values (0," + result + "," + item + ") "); await c.ExecuteAsync(sql.ToString(), trans); } trans.Commit(); return result; } catch (Exception ex) { trans.Rollback(); throw new Exception(ex.ToString()); } })); }
public async Task <int> Update(RoleStrActions roleStrActions) { return(await WithConnection(async c => { StringBuilder sql = new StringBuilder(); IDbTransaction trans = c.BeginTransaction(); try { sql.Append(" update Role ") .Append(" set role_name=@role_name,description=@description, ") .Append(" updated_time=@UpdatedTime,updated_by=@UpdatedBy where id=@id "); int result = await c.ExecuteAsync(sql.ToString(), roleStrActions, trans); sql.Clear().Append("delete from Role_Action where role_id=@id"); await c.ExecuteAsync(sql.ToString(), roleStrActions, trans); foreach (string item in roleStrActions.actions.Split(',')) { sql.Clear() .Append(" insert into Role_Action ") .Append(" values (0," + roleStrActions.Id + "," + item + ") "); await c.ExecuteAsync(sql.ToString(), trans); } trans.Commit(); return result; } catch (Exception ex) { trans.Rollback(); throw new Exception(ex.ToString()); } })); }
public async Task <MSSResult> Add(RoleStrActions roleStrActions) { MSSResult mRet = new MSSResult(); try { DateTime dt = DateTime.Now; roleStrActions.UpdatedTime = dt; roleStrActions.CreatedTime = dt; roleStrActions.CreatedBy = userID; roleStrActions.UpdatedBy = userID; bool isRepeat = await _RoleRepo.IsNameRepeat(roleStrActions.role_name); if (isRepeat) { mRet.code = (int)ErrType.Repeat; mRet.msg = "角色名称重复"; } else { mRet.data = await _RoleRepo.Add(roleStrActions); await SaveRedis(); mRet.code = (int)ErrType.OK; } return(mRet); } catch (Exception ex) { mRet.code = (int)ErrType.SystemErr; mRet.msg = ex.Message; return(mRet); } }
public async Task <ActionResult <ApiResult> > Update(RoleStrActions roleStrActions) { await _RoleService.Update(roleStrActions); ApiResult resp = new ApiResult(); resp.code = Code.Success; return(resp); }
public async Task <MSSResult> Update(RoleStrActions roleStrActions) { MSSResult mRet = new MSSResult(); try { roleStrActions.UpdatedTime = DateTime.Now; roleStrActions.UpdatedBy = userID; var role = await _RoleRepo.GetByID(roleStrActions.Id); if (role == null) { mRet.code = (int)ErrType.NoRecord; mRet.msg = "此角色已不存在"; } else { if (role.role_name != roleStrActions.role_name) { bool isRepeat = await _RoleRepo.IsNameRepeat(roleStrActions.role_name); if (isRepeat) { mRet.code = (int)ErrType.Repeat; mRet.msg = "角色名称重复"; return(mRet); } } mRet.data = await _RoleRepo.Update(roleStrActions); await SaveRedis(); mRet.code = (int)ErrType.OK; } return(mRet); } catch (Exception ex) { mRet.code = (int)ErrType.SystemErr; mRet.msg = ex.Message; return(mRet); } }