有一个表fee,是记账用的，结构和数据如下：
CREATE TABLE [Fee] (
[FeeID] [int] IDENTITY (1, 1) NOT NULL ,
[FeeDate] [datetime] NOT NULL ,
[FeeType] [int] NOT NULL ,--操作类型,1为收入,2为支出,3为存款,4为取款
[FeeInBank] [int] NULL ,--流入银行ID, 0为现金
[FeeIn] [decimal](18, 2) NULL DEFAULT (0),--流入金额
[FeeOutBank] [int] NULL ,--流出银行ID, 0为现金
[FeeOut] [decimal](18, 2) NULL DEFAULT (0) ,--流出金额
[FeeSaveBank] [int] NULL ,--存款银行,不为现金
[FeeSave] [decimal](18, 2) NULL DEFAULT (0),--存款金额
[FeeTakeBank] [int] NULL ,--取款银行,不为现金
[FeeTake] [decimal](18, 2) NULL DEFAULT (0)--取款金额
CONSTRAINT [PK_Fee] PRIMARY KEY CLUSTERED
(
[FeeID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
select * from fee
Insert Into Fee (FeeDate,FeeType,FeeInBank,FeeIn) values ('2009-10-1',1,0,2000) --现金收入2000
Insert Into Fee (FeeDate,FeeType,FeeInBank,FeeIn) values ('2009-10-2',1,1,1000) --银行一收入1000
Insert Into Fee (FeeDate,FeeType,FeeOutBank,FeeOut) values ('2009-10-3',2,0,200) --现金支出200
Insert Into Fee (FeeDate,FeeType,FeeOutBank,FeeOut) values ('2009-10-4',2,1,20) --银行一支出20
Insert Into Fee (FeeDate,FeeType,FeeSaveBank,FeeSave) values ('2009-10-6',3,2,100) --现金存入银行
