Dynamic Visualization of Hydraulic Systems

Project Source

The project was deliberated by Yang Xingke's group and the supervisor, Lecturer Wenhai Wu, for declaring the 2020 Southwest Jiaotong University Student Research Training Program (SRTP) and successfully establishing the project.

Project Description

Utilizing the SQL server database and Internet technology, we developed a technical method to use remote APP monitoring for the MCGS simulation software, which can only be run on a computer. The project first built the hydraulic system simulation system in MCGS software, then used the front-end development technology to build the corresponding APP interface, and finally used the database and server back-end technology to synchronize the data of MCGS software and mobile APP.

Project Work Structure

■System Construction

  • Utilized the C/S architecture to build the server side and the client side.
  • Employed the MCGS to simulate the real industrial hydraulic system environment and operation logic and connected the MCGS with the SQL server database.
  • Carried out the APP interface UI design and API data interface design, and completed the two-way data communication from MCGS to the mobile APP.
    •
    ■Database Processing
  • Established a table in the SQL Server database to store operating data and designed control tables.
    •
    ■Backend Server Processing
  • Utilized MSSQL to move the SQL statements of the database to the server side and connected the server and the display front end through WebSocket to realize two-way data transmission.
  • Employed the timer function to periodically send the latest data to the front end to realize the real-time push function and monitored the button control signal of the front end.
    •

    Project Result

    1. Establish MCGS—database—backend server—data exchange line displayed on the front end, the two-way communication function is stable, and the data is not lost.
    2. The backend uses a timer to push new data so that the frontend data is updated every second. At the same time, the front-end control data is monitored, and the front-end control signal is immediately returned to the MCGS terminal.

    Project Achievements

  • National Utility Model Patent: We have applied for a patent for the technical method of this project for software copyright, which has been granted.
    •