Know yourself, know yourself, and know each other-Sun Tzu
The original system uses Delphi 7 + SQL Server 2005 for development. The third-party controls and auxiliary programs used include:
- Grid ++ Report Printing
- BarTender Label Printing
- Msagent Office Assistant (used to remind messages)
- Dog Driver dongle Driver
- SpComm Serial Communication (for electronic weighing machine)
- Ehlib Table Control
The original system is divided into three parts, using a typical CS two-layer structure: as the Server SQL Server 2005 placed on the Server, the "headquarters management system" and "branch management system" as clients are arranged on the clients respectively. The server accesses the Internet through 1433 m optical fiber, and develops port of SQL for client connection. The client accesses the Internet through its own ADSL, and automatically connects to the server when the program is opened.
Open SQL Server Management Studio of SQL Server to view the database of the original system. The database has a total of 66 tables, 0 views, and 1 stored procedure (the specific name cannot be listed due to harmony). All Tables and Fields use Chinese characters as names (it is easy to find and clear at a glance, is not convenient when writing programs ).
The "headquarters management system" of the client is mainly responsible for goods management, tag management, daily management, revenue and expenditure management, and system management. It is mainly used by Headquarters management personnel.
- Batch warehouse receiving Ticket: Enter the basic attributes of the product, obtain the weight of each product by weighing the machine, and fill in the default sales price (also known as the tag price) of each product ). Once saved, the system will automatically assign a unique barcode to each product as the unique identifier of the product. Then, the entered product information is printed to the tag through the tag printer.
- Warehouse receiving ticket list and query.
- Waybill: select the name of the sub-store to be sent; select the batch warehouse receiving ticket to transfer the goods information. Click "Deliver" to display the goods in transit.
- List and query of waybills.
- Office inventory list and query.
- List and query of the database.
- Store inventory list and query.
- Store sales summary list and query.
- List and query of branch sales details.
- List and query of branch sales orders.
- List and query of store old materials recycling.
- List and query of branch orders.
- List and query of branch expenses.
- Store balance list and query.
- Confirm the operation, list, and query of the delivery from the branch to the headquarters.
- View branch messages.
- Send notification: send a notification to one or all branches.
- Staff information list and query.
- List and query of branch customers.
- Branch logon records.
- Add tags.
- Branch expenditure restrictions.
- Fingerprint sign-in.
- Attendance List and query.
- Attendance time settings.
- System dictionary: metal color, beaded stone category, jewelry name, place of origin, brand, summary category, gift name, user account, branch ticket settings, label layout, expense settings, diamond level, task settings, recycling restrictions.
- Change the logon password.
- Set office user permissions.
- Dongle authorization.
- Sales ranking: lists the sales and task amounts of all branches in the task category.
The "branch management system" of the client is mainly responsible for goods sales, daily work, revenue and expenditure reports, and is mainly used by the management and sales personnel of each branch.
- Order Form: Enter the attributes, quantity, weight, and amount of the required goods.
- List and query orders.
- Waybill operation, list, and query: query the waybill issued by the headquarters to the Branch. After checking the information, click "receive ".
- Store inventory list and query.
- Expense registration: Fill in the amount of all expenditure items and expenses. After the Headquarters check is correct, the balance can be deducted from the branch balance.
- Office message: Leave a message to the headquarters.
- Company notification: view company notifications. If a new notification arrives, a message is displayed.
- Employee information management: Fill in the archive information of all employees of this branch.
- Logon password: Change the logon password.
- Customer Information Registration: after each sales, you should carefully fill in the customer's archives.
- Fingerprint attendance.
