c#中的期初和期末余额 [英] opening and closing balance in c#
问题描述
如何从前一天的期末余额中获得期初余额。
这里是示例
date 14/2/2013 closingbalance 2000
date 15/2/2013期初余额2000
积分2000
借记500
date 15/2/2013 closingbalance 3500
date 16/2/2013开盘余额3500等等
这里前期期末余额成为期初余额。
问题是我必须在日期之间显示数据,不知道如何获得第一条记录的期初余额。
i我正在使用sqlser 2005和水晶报告10.
how do i get opening balance from previous day closing balance.
here is the example
date 14/2/2013 closingbalance 2000
date 15/2/2013 opening balance 2000
credit 2000
debit 500
date 15/2/2013 closingbalance 3500
date 16/2/2013 opening balance 3500 and so on
here previous closing balance become opening balance.
problem is that i have to show data between date and no idea how to get opening balance of first record.
i am using sqlser 2005 and crystal report 10.
推荐答案
我认为您需要考虑截止日期和日期,例如01-01-2014 23:59:59
然后与开放日平衡相同,比如01-02-2014 00:00:00
那么它们应该是一样的。
I think you need to consider the closing day time AND date, eg 01-01-2014 23:59:59
Then the same with the opening day balance as, say 01-02-2014 00:00:00
Then they should be the same.
这篇关于c#中的期初和期末余额的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!