平時寫的bat 備用之

@echo off
graftabl 437
graftabl 950
echo 將EastRiver刷卡資料上傳遞到tkcz.tkf_file
rem copy EastRiver.mdb
net use //192.168.50.96/ipc$ "6444" /user:01500
del c:/EastRiver.mdb
copy //192.168.50.96/一卡通軟件/EastRiver.mdb c:/
if not exist c:/EastRiver.mdb goto error1

rem 從EastRiver抓資料
z:/ap/getb.exe c:/EastRiver.mdb c:/out_tkf.csv 5
if not exist c:/out_tkf.csv goto error1

rem 上傳資料
echo open 192.168.1.17 > c:/ftptkf.txt
echo mischeck>>c:/ftptkf.txt
echo check5577>>c:/ftptkf.txt
echo cd /u1/out>>c:/ftptkf.txt
echo send c:/out_tkf.csv>>c:/ftptkf.txt
echo quit>>c:/ftptkf.txt
if not exist c:/ftptkf.txt goto error1
ftp -s:c:/ftptkf.txt

del c:/ftptkf.txt

rem 執行remote host sh
z:/ap/plink.exe -ssh 192.168.1.17 -l mischeck -pw check5577 -v /u1/out/ins_tkf.sh
::del C:/telnet_tmp.vbs

goto end

:error1
echo error!
goto out

:end
echo All Done.
::echo Now you can run /u1/out/ins_tkf.sh to put the data into tkf_file from /u1/outo/ut_tkf.csv

:out