After I finished implementing the ERP system for this company in May, 2018, TMMA asked me to add several extra functions, including report and batch processing.
After adding five new functions, executing individual code started to become tedious.
Therefore, I created an application to organize all the extra functions to be more productive.
This project spent around 10 months and eventually they can fully utilize ERP sytem.
In their ERP system, the POS system and inventory system are separated. Their employee had to spend plenty of time integrating the sales data from both systems every month. Also, their business has some unique procedures that the standard system does not support. Therefore, I developed an application to integrate all the functions.
This file works as a config file. It records the following information for the MSSQL database.
serverid // SQL server id
user // SQL user account
passward // SQL account
database // target database
apploginpwd // the password to login into this application. (They need some safety control)
fontpath // for special font
outputpath // sometimes their staff need to create some plots by themselves. So this path where output excel file will go
This file is a login interface.
This file is for all the logic and commend for the application.
I created a lot of store procedures in the database. Those .sql files are to call those store procedures when they click certain buttons.
-
Buyonegetonefree.sql // Automatically insert cretain genre of products to a buy one get on free table
-
Adjustmin.sql // Automatically adjust the POS system's price of certain product
-
posall.sql // Automatically insert cretain genre of products to a pos buy one get on free table
-
All the store procedure will be put in All store procedures!