大家好， i一直在用c＃开发一个使用ASP.NET的网站应用程序。 问题是我需要开发AUTO TOPUP，这意味着重复付款。 i在我的申请中有4个douts， 步骤1.客户在他们的帐户中有一定金额。 例如他们在2013年4月30日有500卢比到他们的帐户。 步骤2.在剩下一些特定日期后，相同的客户金额余额为零。 $ b例如，在5/05/2013客户账户上，$ b的余额为零。 步骤3.此时客户需要订阅自动充值选项，其后是网站。 第4步。我的问题是如何将客户账户余额从零增加到约50,100。或者它是什么。 一旦客户在他们的帐户中达到零余额，这一步将经常发生， 所以这是我的问题，所以请考虑我上面提到的这个想法并给我一些解决方案或者给出一个与AUTO TOP UP相关的相应链接或者让我知道如何创建AUTO TOPUP。 如果有任何想法或解决方案，请告诉我。 建议值得一提......
hi all, i have been developing one website application using ASP.NET with c#. the thing is i would be need to develop AUTO TOPUP which means the repeat payment. i have 4 douts in my application , step 1. the customer having some amount in to their account . for example they have 500 rupees on 30/04/2013 in to their account. step 2. After some certain dates left , the same customer amount has zero balance. for example on 5/05/2013 customer account have zero balance. step 3. at this time customer need to subscribe auto top up option which is followed by the website. step 4. my question is how do i increment customer account balance from zero to some 50,100. or whatever it is. and this step will do frequently once customer met zero balance in their account, so this is my problem, so please consider this thoughts as i mentioned above and give me a drop of solution or else give a corresponding link which is related to AUTO TOP UP or else give me an idea how do i create AUTO TOPUP . please let me know if have any idea or solution. advices are appreciable....
推荐答案如果您正在使用SQL Server，并且希望在余额变为0后立即更新余额，则创建作业。 If you are using SQL Server and you want to update balance as soon as balance becomes 0 then create job.
（使用Sql server DB）您可以使用触发器执行此操作。触发器是一种特殊类型的存储过程，可响应表上的某些操作（如插入，删除或更新数据）执行。在您的情况下，当客户余额变为零时，您可以使用触发器被触发。有关触发器的更多信息，请查看 SQL中的触发器 (With Sql server DB)You can perform this operation with the use of triggers.A trigger is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.So in your case when customers balance becomes zero you can use trigger to be fired.For more on triggers have a look at Triggers in SQL
更多推荐
如何将账户余额从零增加到一定数额？
发布评论