主 選 單
 登入
使用者名稱:

密碼:


忘了密碼?

現在就註冊!
 版面風格

(10 個版面風格)
站長部落格 - lutuni 的日誌
 訂閱 lutuni 的日誌

2009/04/02
查詢未沖帳資料

作者: lutuni (10:26 am)
external M_SEC
M_SEC=0
MTOA("",MEMO1.LINES)
ASSIGN(MEMO1.LINES[1]," ")
SELECT INVO
Set Filter To
SET WHILE TO
SET TAG TO INVO8
SET WHILE FROM EDIT12.TEXT TO EDIT13.TEXT
&&Browse()
GO TOP
MESSAGE2(1,"計算中...")
DO WHILE !EOF()
IF M_SEC=0 .AND. S_AMT<>0
M_SEC=1
CUSTOMER.SEEK(INVO->CUST_CODE)
ASSIGN(MEMO1.LINES[M_SEC],"│"+INVO->CUST_CODE+SPACE(2)+"│"+CUSTOMER->NAME_SHORT+"│"+TRANSFORM(AMOUNT,'@N8')+"│"+TRANSFORM(TAX_AMT,'@N8')+"│"+TRANSFORM(DISCOUNT,'@N8')+"│"+TRANSFORM(R_AMT,'@N8')+"│"+TRANSFORM(S_AMT,'@N8')+"│")
ASSIGN(MEMO1.LINES[M_SEC+1]," ")
ELSE
DO WHILE INKEY()<>27 .AND. M_SEC<>0 .AND. S_AMT<>0
INKEY()
IF EMPTY(MEMO1.LINES[M_SEC])
CUSTOMER.SEEK(INVO->CUST_CODE)
ASSIGN(MEMO1.LINES[M_SEC],"│"+INVO->CUST_CODE+SPACE(2)+"│"+CUSTOMER->NAME_SHORT+"│"+TRANSFORM(AMOUNT,'@N8')+"│"+TRANSFORM(TAX_AMT,'@N8')+"│"+TRANSFORM(DISCOUNT,'@N8')+"│"+TRANSFORM(R_AMT,'@N8')+"│"+TRANSFORM(S_AMT,'@N8')+"│")
ASSIGN(MEMO1.LINES[M_SEC+1]," ")
M_SEC=1
EXIT
ELSE
IF SUBS(MEMO1.LINES[M_SEC],3,6)=INVO->CUST_CODE
CUSTOMER.SEEK(INVO->CUST_CODE)
ASSIGN(MEMO1.LINES[M_SEC],"│"+INVO->CUST_CODE+SPACE(2)+"│"+CUSTOMER->NAME_SHORT+"│"+TRANSFORM(AMOUNT+VAL(SUBS(MEMO1.LINES[M_SEC],25,10)),'@N8')+"│"+TRANSFORM(TAX_AMT+VAL(SUBS(MEMO1.LINES[M_SEC],37,10)),'@N8')+"│"+TRANSFORM(DISCOUNT+VAL(SUBS(MEMO1.LINES[M_SEC],49,10)),'@N8')+"│"+TRANSFORM(R_AMT+VAL(SUBS(MEMO1.LINES[M_SEC],61,10)),'@N8')+"│"+TRANSFORM(S_AMT+VAL(SUBS(MEMO1.LINES[M_SEC],73,10)),'@N8')+"│")
EXIT
ELSE
M_SEC=M_SEC+1
ENDIF
ENDIF
ENDDO
ENDIF
SKIP
ENDDO
M_SEC=1
DO WHILE !EMPTY(MEMO1.LINES[M_SEC])
M_SEC=M_SEC+1
ENDDO
ASSIGN(MEMO1.LINES[M_SEC],"└────┴─────┴─────┴─────┴─────┴─────┴─────┘")
ASSIGN(MEMO1.LINES[M_SEC+1],"2 4 6 8 1012141618202224262830323436384042444648505254565860626466687072747678808284")
MESSAGE2(0)
閱讀 lutuni 的日誌 | 迴響 (0) | 引用次數 (0) | 瀏覽次數 (642)
本篇文章引用網址
http://123.204.89.156/etype/modules/weblog/weblog-tb.php/20
列印這一篇日誌 發送這篇日誌給你的朋友(Email)