/// <summary> /// 角色添加 /// </summary> /// <param name="role"></param> /// <returns></returns> public int AddRoles(Roles role) { using (OracleConnection conn = DapperHelper.GetConnectionString()) { string sql = string.Format("insert into Roles(RoleName,RoleDescribe) values(:RoleName,:RoleDescribe)"); var add = conn.Execute(sql, role); string sql1 = string.Format("select RoleID from Roles where RoleName=:RoleName"); var id = conn.Query <int>(sql1, role).FirstOrDefault(); var roles = role.PerMissionID.Split(','); for (int i = 0; i < roles.Length; i++) { RolePerMission rolePerMission = new RolePerMission(); rolePerMission.RoleID = id; rolePerMission.PerMissionID = roles[i]; string sql2 = string.Format("insert into RolePerMission (PerMissionID,RoleID) values(:PerMissionID,:RoleID)"); var addrole = conn.Execute(sql2, rolePerMission); } return(add); } }
public int UpdateRoles(Roles role) { using (OracleConnection conn = DapperHelper.GetConnectionString()) { string sql = string.Format("update roles set RoleName=:RoleName,RoleDescribe=:RoleDescribe where RoleID=:RoleID"); var add = conn.Execute(sql, role); var roles = role.PerMissionID.Split(','); string sql1 = string.Format("DELETE FROM RolePerMission where RoleID=:RoleID"); var id = conn.Query <int>(sql1, new { RoleID = role.RoleID }); for (int i = 0; i < roles.Length; i++) { RolePerMission rolePerMission = new RolePerMission(); rolePerMission.RoleID = role.RoleID; rolePerMission.PerMissionID = roles[i]; string sql2 = string.Format("insert into RolePerMission (PerMissionID,RoleID) values(:PerMissionID,:RoleID)"); var addrole = conn.Execute(sql2, rolePerMission); } return(add); } }