There's sometimes a tendency of CAD files opened in CS to "explode". It's because of the "layered" nature of the plotted coordinates in the CAD file.
I haven't used Autocad for a long while now and in tandem with CS 4 or a higher version, but try exporting the file as an object (if possible) and import into CS. Or see if you can group all the plots into a single group (or the Autcad equivalent of "Flatten"), save and import into CS.
I might be wrong... but might as well rotate it into the view you need in Autocad and export/import it into CS for whatever editing you plan to do with it.
If your trying to create an aerial perspective view, take a full screen grab of your plan view, paste into your CS document and try the perspective transform control. I used to do this when I create architectural renders from CAD files. Also try and see if the 3d rotate will work on it.