写了一半没写完，备份一下吧

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

TemplateEditorisused to create user fill excel table.Itis a two dimension tablelikeexcel.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 cellstomake 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 XMLformat.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 IDrelatedinto 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:

<Sheet>

<Styles>

<StylestyleName=”style1”>

<Alignmenthorizontal=”left”vertical=”center”></Alignment>

<LockisLock=”1”></Lock>

<Fontfamily=”Serif”size=”14”bold=”0”italic=”0”></Font>

<Foregroundcolor=”255,0,0”></Foreground>

<Backgroundcolor=”255,0,0”></Background>

</Style>

</Styles>

</Sheet>

3.PMS Staff