实时数据分页显示技术在MES中的应用  

Application of Real Time Data Paging Technology in MES

作　　者：张新生 金朝勇 李航 李永胜 Zhang Xinsheng;Jin Chaoyong;Li Hang;Li Yongsheng(SIPPR Engineering Group Co., Ltd., Zhengzhou Henan 450007, Chin)

机构地区：[1]机械工业第六设计研究院有限公司智能与信息工程中心,河南郑州450007

出　　处：《信息与电脑》2018年第9期8-10,共3页Information & Computer

摘　　要：基于Web的MES(Manufacturing Execution System)需要在页面中实时浏览大量数据库中订单执行情况数据,因此,系统开发中涉及实时数据的分页显示问题。传统的异步分页系统采用AJAX(Asynchronous Java Script and XML)进行数据的传输,该方法不仅无法传输大量分页数据,又不具有实时性。笔者分析了传统分页技术的原理及局限性,提出了基于Web Socket的实时分页数据异步传输方法,服务器端采用物理分页获得分页数据,客户端结合MVVM(Model-View-View Model)模式的数据绑定方法实现了视图的局部更新。实践表明,该分页方法具有良好的实时性和实用价值。Since MES（Manufacturing Execution System） based on web needs to browse a large number of real-time data about the production of materials and products in the database, The problem of paging display of real-time data in system development will occur.During the system development, the traditional asynchronous paging system uses AJAX to transmit data,which not only can not transmit large amounts of paging data, but also request data actively on the client side without real time. The author analyzes the principle and limitation of traditional paging technology, we put forward a real-time asynchronous paged data transmission method based on Web Socket, and user MVVM in the client（Model-View-View Model） data binding method to achieve the local view update, the server side uses the stored procedure to get paging data. The practice shows that the paging method has good real time and practical value.

关 键 词：分页查询 WEB SOCKET MVVM AJAX 存储过程 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]