www.pudn.com > jq_caiwu.ARJ > CSHXG.PRG
SET COLOR TO W/N
CLOS DATABASES
CLEA
SELE 1
USE kmk
SELE 2
USE pzk
xg = 0
SET COLOR TO GR/N
@ 0, 0 SAY 'JQ软件工作室'
@ 0, 67 SAY 'JQ财务系统'
SET COLOR TO G/N
@ 0, 25 SAY '初 始 化 录 入 接 口'
@ 1, 0 SAY '================================================================================'
@ 2, 0 SAY ' 借 方 累 计 贷 方 累 计 年 初 借 方 年 初 贷 方'
@ 4, 0 SAY '================================================================================'
@ 5, 0 SAY '科目代码'
@ 5, 10 SAY ' 总 帐 科 目'
@ 5, 31 SAY ' 明 细 科 目'
@ 5, 51 SAY ' 借方余额'
@ 5, 65 SAY ' 贷方余额'
? '================================================================================'
pd = 0
SET COLOR TO G/N
@ 23, 0 SAY '=================================================================================='
SET COLOR TO B/GR
@ 24, 0 SAY '↑上笔:↓下笔: PgUp上页: PgDn下页: Home整理: F6增加: F5修改: Delete删除: Esc退出'
SET COLOR TO W/N
GOTO BOTTOM
pd = RECNO()
pd = pd/16
pd1 = INT(pd)
ys = pd-pd1
IF ys=0
ys = pd1
ELSE
ys = pd1+1
ENDI
GOTO TOP
pd = 1
ys1 = 1
DO WHILE .T.
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
IF .NOT. EOF()
SKIP
pd = pd+1
ELSE
EXIT
ENDI
IF pd=17
EXIT
ENDI
ENDD
GOTO TOP
pd = 1
SET COLOR TO G+/B
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
SET COLOR TO W/N
@ 3, 1 SAY jje
@ 3, 22 SAY dje
@ 3, 45 SAY njye
@ 3, 64 SAY ndye
DO WHILE .T.
x = INKEY(0)
DO CASE
CASE x=1
SAVE SCREEN TO crt
IF EOF()
x = RECNO()-1
pd = pd-1
ELSE
ENDI
SET COLOR TO W+/B
@ 7, 20 CLEAR TO 10, 50
x1 = 7
x2 = 10
y1 = 22
y2 = 48
DO box-1
@ 8, 26 SAY ' 正在进行数据整理,'
@ 9, 26 SAY ' 请 稍 候 ......'
DO cshzl
GOTO x
REST SCREEN FROM crt
SET COLOR TO G+/B
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
SET COLOR TO W/N
@ 3, 1 SAY jje
@ 3, 22 SAY dje
@ 3, 45 SAY njye
@ 3, 64 SAY ndye
CASE x=-4
DO cshxg-1
CASE x=-5
IF pd<16
xg = 1
IF EOF() .AND. .NOT. BOF()
x1 = RECNO()-1
pd = pd-1
ELSE
x1 = RECNO()
ENDI
a1 = pd
IF EOF()
a1 = a1+1
ENDI
SET COLOR TO W/N
@ 6+pd, 0 CLEAR TO 22, 79
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
pd = pd+1
DO WHILE .T.
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
IF .NOT. EOF()
SKIP
pd = pd+1
ELSE
EXIT
ENDI
IF pd=17
EXIT
ENDI
ENDD
pd = a1
@ 6+pd, 0 SAY ' '
IF EOF() .AND. BOF()
GOTO TOP
ELSE
GOTO x1
ENDI
DO cshsr-1
SELE 2
GOTO BOTTOM
pd1 = RECNO()
pd1 = pd1/16
pd2 = INT(pd1)
ys = pd1-pd2
IF ys=0
ys = pd2
ELSE
ys = pd2+1
ENDI
IF BOF()
GOTO TOP
ELSE
IF x1<=0
x1 = 1
ENDI
IF pd<=0
pd = 1
ENDI
IF .NOT. RECNO()=1
GOTO x1+1
ELSE
GOTO BOTTOM
ENDI
ENDI
SET COLOR TO W/N
@ 6+pd, 0 SAY SPACE(80)
@ 3, 0 SAY SPACE(80)
SET COLOR TO G+/B
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
@ 6+pd, 66 SAY ' '
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
@ 6+pd, 52 SAY ' '
ENDI
ELSE
IF ye>=0
@ 6+pd, 52 SAY ' '
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 66 SAY ' '
@ 6+pd, 52 SAY -ye
ENDI
ENDI
SET COLOR TO W/N
@ 3, 1 SAY jje
@ 3, 22 SAY dje
@ 3, 43 SAY ' '
@ 3, 45 SAY njye
@ 3, 62 SAY ' '
@ 3, 65 SAY ndye
ELSE
?? CHR(7)
ENDI
CASE x=5
IF pd=1 .OR. RECNO()=1
?? CHR(7)
ELSE
SET COLOR TO W/N
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
@ 6+pd, 66 SAY ' '
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
@ 6+pd, 52 SAY ' '
ENDI
ELSE
IF ye>=0
@ 6+pd, 52 SAY ' '
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
@ 6+pd, 66 SAY ' '
ENDI
ENDI
SET COLOR TO W/N
@ 3, 1 SAY jje
@ 3, 22 SAY dje
@ 3, 45 SAY njye
@ 3, 65 SAY ndye
SET COLOR TO G+/B
IF .NOT. BOF()
SKIP -1
pd = pd-1
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
@ 6+pd, 66 SAY ' '
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
@ 6+pd, 52 SAY ' '
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
@ 6+pd, 52 SAY ' '
ELSE
@ 6+pd, 52 SAY -ye
@ 6+pd, 66 SAY ' '
ENDI
ENDI
SET COLOR TO W/N
@ 3, 1 SAY jje
@ 3, 22 SAY dje
@ 3, 45 SAY njye
@ 3, 65 SAY ndye
ENDI
ENDI
CASE x=7
xg = 1
IF EOF() .AND. .NOT. BOF()
?? CHR(7)
ELSE
x1 = RECNO()
x2 = x1
GOTO BOTTOM
IF x1=RECNO()
x2 = x1-1
IF pd>1
pd = pd-1
ENDI
ENDI
IF BOF()
GOTO TOP
ELSE
GOTO x1
ENDI
a1 = LTRIM(TRIM(kmdm))
DELE
PACK
SELE 1
LOCA ALL FOR a1$kmdm .AND. LEN(LTRIM(TRIM(kmdm)))=LEN(LTRIM(TRIM(a1)))
DELE
PACK
SELE 2
IF BOF()
GOTO TOP
ELSE
GOTO x2
ENDI
pd1 = pd
SET COLOR TO W/N
@ 6+pd, 0 CLEAR TO 22, 79
DO WHILE .T.
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
IF .NOT. EOF()
SKIP
pd = pd+1
ELSE
EXIT
ENDI
IF pd=17
EXIT
ENDI
ENDD
GOTO BOTTOM
pd = RECNO()
pd = pd/16
pd2 = INT(pd)
ys = pd-pd2
IF ys=0
ys = pd2
ELSE
ys = pd2+1
ENDI
IF ys1>ys
ys1 = ys
GOTO (ys1-1)*16+1
x2 = RECNO()
pd = 1
SET COLOR TO W/N
@ 7, 0 CLEAR TO 22, 79
DO WHILE .T.
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
SKIP
pd = pd+1
IF pd=17
EXIT
ENDI
ENDD
GOTO x2
ELSE
IF BOF()
GOTO TOP
ELSE
GOTO x2
ENDI
ENDI
pd = pd1
SET COLOR TO G+/B
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
SET COLOR TO W/N
@ 3, 1 SAY jje
@ 3, 22 SAY dje
@ 3, 45 SAY njye
@ 3, 65 SAY ndye
ENDI
CASE x=24
IF pd=16 .OR. EOF()
?? CHR(7)
ELSE
SET COLOR TO W/N
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
@ 6+pd, 66 SAY ' '
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
@ 6+pd, 52 SAY ' '
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
@ 6+pd, 52 SAY ' '
ELSE
@ 6+pd, 52 SAY -ye
@ 6+pd, 66 SAY ' '
ENDI
ENDI
SET COLOR TO W/N
@ 3, 1 SAY jje
@ 3, 22 SAY dje
@ 3, 45 SAY njye
@ 3, 65 SAY ndye
SET COLOR TO G+/B
SKIP
pd = pd+1
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
@ 6+pd, 66 SAY ' '
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
@ 6+pd, 52 SAY ' '
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
@ 6+pd, 52 SAY ' '
ELSE
@ 6+pd, 52 SAY -ye
@ 6+pd, 66 SAY ' '
ENDI
ENDI
SET COLOR TO W/N
@ 3, 1 SAY jje
@ 3, 22 SAY dje
@ 3, 45 SAY njye
@ 3, 65 SAY ndye
ENDI
CASE x=18
IF ys1>1
ys1 = ys1-1
GOTO ys1*16
SKIP -15
pd = 1
SET COLOR TO W/N
@ 7, 0 CLEAR TO 22, 79
DO WHILE .T.
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
IF .NOT. EOF()
SKIP
pd = pd+1
ELSE
EXIT
ENDI
IF pd=17
EXIT
ENDI
ENDD
SKIP -16
SET COLOR TO G+/B
pd = 1
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
SET COLOR TO W/N
@ 3, 1 SAY jje
@ 3, 22 SAY dje
@ 3, 45 SAY njye
@ 3, 65 SAY ndye
pd = 1
ELSE
?? CHR(7)
ENDI
CASE x=3
SET COLOR TO W/N
IF ys1=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
IF .NOT. EOF()
SKIP
pd = pd+1
ELSE
EXIT
ENDI
IF pd=17
EXIT
ENDI
ENDD
GOTO x
SET COLOR TO G+/B
pd = 1
@ 6+pd, 0 SAY kmdm
@ 6+pd, 10 SAY zzkm
@ 6+pd, 31 SAY mxkm
IF jhd='+'
IF ye>=0
@ 6+pd, 52 SAY ye
ELSE
@ 6+pd, 66 SAY -ye PICTURE '99999999999.99'
ENDI
ELSE
IF ye>=0
@ 6+pd, 66 SAY ye PICTURE '99999999999.99'
ELSE
@ 6+pd, 52 SAY -ye
ENDI
ENDI
SET COLOR TO W/N
@ 3, 1 SAY jje
@ 3, 22 SAY dje
@ 3, 45 SAY njye
@ 3, 65 SAY ndye
pd = 1
ELSE
?? CHR(7)
ENDI
CASE x=27
EXIT
OTHE
?? CHR(7)
ENDC
ENDD
IF xg=1
SET COLOR TO W+/B
@ 7, 20 CLEAR TO 10, 50
x1 = 7
x2 = 10
y1 = 22
y2 = 48
DO box-1
@ 8, 28 SAY '正在进行科目整理,'
@ 9, 28 SAY '请 稍 候 ......'
DO kmkzl
ENDI
CLOS DATABASES
SET COLOR TO W/N
RETU
*