计算余额金额超过Vb .net中收到的金额 [英] Calculate Balance Amount over Amount Received against Bill in Vb .net
问题描述
Hello Everyone，
我创建了Windows应用程序，它将值添加到PostgreSQL数据库中作为帐单号，付款金额，余额金额，并且必须计算余额金额使用vb .net从客户收到的金额。我已经为
收到了一个文本框，并且在按钮点击事件上，表格上的一个按钮必须执行此操作，
For Ex。 - 我在数据库中有三个账单，
账单号码付款金额|余额
1       | 1000                 | 1000
2       | 1500                 |   1500
3       | 700                   |   700
现在来自客户，我收到了1500卢比，所以我必须根据收到的总金额清算账单。这意味着，我必须更新账单的余额金额，因此账单1将清除，必须将余额金额更新为零，对于2号账单，500 RS
扣除所以余额金额将为1000卢比。
所以请帮我在vb .net中写这个逻辑。
问候，
MTrush
Hello Everyone，
我创建了Windows应用程序，它将值添加到PostgreSQL数据库中作为帐号，付款金额，余额金额并且必须使用vb .net计算客户收到的余额金额。我已经为
收到了一个文本框，并且在按钮点击事件上，表格上的一个按钮必须执行此操作，
For Ex。 - 我在数据库中有三个账单，
账单号码付款金额|余额
1       | 1000                 | 1000
2       | 1500                 |   1500
3       | 700                   |   700
现在来自客户，我收到了1500卢比，所以我必须根据收到的总金额清算账单。这意味着，我必须更新账单的余额金额，因此账单1将清除，必须将余额金额更新为零，对于2号账单，500 RS
扣除所以余额金额将为1000卢比。
所以请帮我在vb .net中写这个逻辑。
问候，
MTrush
嗨rushuMT，
根据您的描述，您说您已收到1500，因此您清除了Bill No1，将余额金额更新为零，对于Bill No2，更新余额金额为1000。 / p>
您能告诉我 您是否需要根据Bill No更新您的数据？并且
您将从客户的数量中获得资金，只有一个？
请详细说明申请。
最好的问候，
Cherry
Hello Everyone,
I have created windows application which will add the values into PostgreSQL Database As Bill Number, Payment Amount, Balance Amount and have to calculate the balance amount against Received Amount from Client using vb .net. I have taken one text box for Amount Received and one button on form, on button click event, have to perform this operation,
For Ex. - I have three Bills in the Database as,
Bill No | Payment Amount | Balance Amount
1 | 1000 | 1000
2 | 1500 | 1500
3 | 700 | 700
Now from client, i have received 1500 Rs Total, so i have to clear the Bills according to Total Amount Received. That means, i have to update the bill's Balance Amount, So Bill No 1 will clear, have to update Balance Amount to Zero, For Bill No 2, 500 RS deduct so Balance Amount will be 1000 Rs.
So Please help me to write this logic in vb .net.
Regards,
MTrush
Hello Everyone,
I have created windows application which will add the values into PostgreSQL Database As Bill Number, Payment Amount, Balance Amount and have to calculate the balance amount against Received Amount from Client using vb .net. I have taken one text box for Amount Received and one button on form, on button click event, have to perform this operation,
For Ex. - I have three Bills in the Database as,
Bill No | Payment Amount | Balance Amount
1 | 1000 | 1000
2 | 1500 | 1500
3 | 700 | 700
Now from client, i have received 1500 Rs Total, so i have to clear the Bills according to Total Amount Received. That means, i have to update the bill's Balance Amount, So Bill No 1 will clear, have to update Balance Amount to Zero, For Bill No 2, 500 RS deduct so Balance Amount will be 1000 Rs.
So Please help me to write this logic in vb .net.
Regards,
MTrush
Hi rushuMT,
Based on your description, you said that you received 1500, so you clear Bill No1, update Balance Amount to Zero, for Bill No2, update Balance amount 1000.
Can you tell me thatyou need not to update your data based on Bill No? And You will get the money from the number of client, only one?
Please describe more detailed about application.
Best Regards,
Cherry
这篇关于计算余额金额超过Vb .net中收到的金额的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
