写了一半没写完，备份一下吧_qtbug-36129-优快云博客

本文链接：https://blog.youkuaiyun.com/shell_albert/article/details/45556357

PMS User Guide

PMS is an automaticsystem for factories to manage production missions. Its aims to helpthe company to reduce the paper cost. The following guide is to helpthe users to use the system more easily.

From the technology,PMS consists three parts as follows:

1.PMS Server

The PMS servercontains the MySQL database server and the file server. MySQL is usedto store the data includes user information, template table xml dataand necessary link data to make the components can connect easily.

The File Server isa basic data transfer service, it is used to implement the fileupload, download, delete, etc.

2.PMS Manager

PMS Manager is usedby the system manager, have all the permissions. It is split-tedmultiple sections, each section to handle its data processing.

UserManager

Functions:

A.Create/modify/delete/query role, assign permission bits.

B.Create/modify/delete/query user, a user must be assigned with a role,of course a role can hold many users.

Detail:

In system initialperiod, its only has one role and one user, admin and admin. It willbe created automatically at the beginning. It is necessary exist tomake the system running. It cannot be deleted.

There are sometables in database to hold different information. Shown as following:

Table Name	Function	Memo
RoleTable	Store the role name, role permission bits.	RoleName is the key value, cannot be same or duplicate.
UserTable	Store the user name, belongs to which role.	User's creator is very important, the task will be posted toits creator at default.

Table-1(User manager related data table)

TemplateEditor

TemplateEditor isused to create user fill excel table. Itis a two dimension table likeexcel. Systemmanager should use it to design production inspection table. Itsupports multiple features. Eachtable contains 64 rows and 64 columns cells at maximum. Usercan merge and split cells tomake the table more beautiful and readable. Cellis a basic unit, it has many attributes, the following list showsthem.

Attribute Name	Specification	Type	Memo
Cell Type	Indicates a cell's content data type.	String Numeric Boolean Image	String type can hold everything. Numeric type is used to limit the user input, ithas minimum value, maximum value and tolerance value. Boolean type is shown as a check box to receivethe yes or no value. Image type is used to insert picture. Default is String.
Cell Data	Hold the user input data.	As above.
Cell Alignment	Restrict the text's alignment.	Horizontal Vertical	Horizontal: Left, Center, Right. Vertical: Top, Center, Right.
Cell Lock	Lock the cell cannot be modified.		If the lock attribute is set, the cell cannot bemodified.
Cell Foreground Color	Set the font color.		Support the Alpha channel.
Cell Background Color	Set the background color.		Support the Alpha channel.
Cell Font	Set the font.		Font Family, Font Size, Bold, Italic.
Cell Frame	Set the cell border frame.		Top, Bottom, Left, Right (Border Color).

Table-2(Cell attributes)

Table data structure

Thetableis stored in database using XML format. Toreduce the data size, I parse the Microsoft Excel File Format. It'sarranged in XML format.Theengineers is so smart, they create a style format list at the top ofthe file, each style has its own name. Astyle contains all the information of a cell. Cellsare stored row by row. Eachcell has a style ID relatedinto the style format list. Whenthe GUI renders the table, it fetchesthe specified style from the style list by the style ID. Sothe final table XML data format is generated: