Prepayment function

The user needs

l  Before the formal charging process , You can prepay the project .
l  Prepaid operation record charge number 、 Payment amount 、 date .
l  The advance payment is only recorded on the project as a piece of information , Do not make logical judgments .
l  The actual total paid in expenses of the whole project shall be recorded at the end of the project payment , There is no logical connection with pre charge .
================================================

demand
increase 、 Modify the pre charge ：
The advance payment includes 4 Item information ： Charge No 、 Transaction amount 、 Trading hours 、 Pre chargers . Charge No , User input , Can't be empty , most 50 Characters . Transaction amount , User input , Must be a positive number , Keep two decimal places . It is the time to add or modify the pre charge . The pre collector is the current operator of the business system . The default value of the case number 000000.
Function entry ：
Add a menu item in the right-click menu of selecting a case “ Advance charge ”. see 、 increase 、 Modify the pre charge in the same interface .
After the official charge, this menu is hidden or not added at all .
One of the following , View only , Do not modify ：
a, Official charging link .
b, There is already charging information , And the pre collector is not the current operator .
There can only be one pre charge information in the same case .

Design ：
Database design ：
New data table PreCharge,5 A field
WorkID, case ID,CHAR(32). Primary key , Foreign keys , Non empty .
TollNumber, Charge No ,VARCHAR2(50), Non empty .
PaymentAmount, Payment amount ,NUMBER(18,2), Non empty .
DateTime, date ,DATE , Non empty .

Interface design ：
Transaction time format ： year - month - Japan Hours : minute : second , year 4 position , Other 2 position ,24 hourly ）
Others omitted .

In particular ：
1,9 month 1 Number Received in advance 30 element , Accidentally recorded as 25 element .9 month 2 Number Found the wrong record , So I changed it to 30 element . It turns out to be ,9 month 2 No 30 element .
This function is not a core function , So don't be picky .