vb´òÓ¡ÎÊÌâ
´ó¼ÒºÃ£¬Îʸövb´òÓ¡ÎÊÌâ
printer.print "dsff"
.....
....
Printer.EndDoc
´òÓ¡³É¹¦ºóÎÒ½«Ö´ÐÐ
sqlstr = "update vc_yh set pr=' ÒÑ´òÓ¡ ',czry='" & user & "',czrq=to_date('" & Format(Get_NowDate, "YYYY-MM-DD ") & "','yyyy-mm-dd ') where clsbdh='" & Trim(Text1(0).text) & "' "
If DBexecute(sqlstr, DBconnect) Then
End If
µ«ÊÇÔõÑùÅжϴòÓ¡ÊÇ·ñ³É¹¦ÄØ£¿
²»³É¹¦»áÓдíÎó
VB code:
Private Sub Command1_Click()
On Error GoTo ErrHandler
Printer.Print "dsff"
....
Printer.EndDoc
sqlstr = "update ..."
If DBexecute(sqlstr, DBconnect) Then
End If
ExitEntry:
Exit Sub
ErrHandler:
MsgBox Err.Description, vbCritical
Resume ExitEntry
End Sub
³ý·Ç´òӡ֮ǰÏȼì²é´òÓ¡»ú̬ ÊÇ·ñȱֽµÈ
µ«ÕâÑùÒ²²»Äܱ£Ö¤´òÓ¡¹ý³ÌÖв»³öÏÖÎÊÌâѽ,±ÈÈ翨ֽµÈ
ºÃµÄ°ì·¨Êǽ«´òÓ¡ºÍ¸üÐÂÊý¾Ý¿â×ö³ÉÁ½¿é
´òÓ¡»ú×Ô´ø»º´æ£¬Ð¡¹ÊÕÏ¿ÉÒÔÊÖ¹¤Åųýºó¼ÌÐø´òÓ¡£¬³ÌÐò²»ÐèÒª¹ØÐÄ¡£
Ïà¹ØÎÊ´ð£º
ÔÚVBÖУ¬ÈçºÎÖ´ÐÐÏÂÃæµÄSQLÓï¾ä
Update t_Icitem Set f_102 = IsNull(f_102,0)+1 Where FNumber='0001'
±ÈÈ磺
cn.execute("Update t_Icitem Set f_102 = IsNull(f_102,0)+1 Where FNumber= ......
ÎÒÏëдһ¸öasp¶ÁÈ¡±¾µØ»ú×ÓµÄÍøÍ«µÄ¹¦ÄÜ£¬ÐèÒªÓÃvbдһ¸ödll ÔÚÍøÉÏÕÒÁËһϣ¬°ÑÏÂÃæµÄ¶Î¿½Èëvb¹¤³ÌÀ
Option Explicit
Private Const NCBASTAT = &H33
Private Const NCBNAMSZ = 16
Private ......
¹¦ÄÜ£ºÔÚÊäÈëµãµÄ×ø±êºó£¬»³ö¶ÔÓ¦µÄµã£»ÔÚ»Á˵ãºó£¬¿ÉÒÔÐ޸ĵãµÄ×ø±ê£¬²¢´Óл£»Öظ´Ö±µ½Í¼ÐÎÂÖÀª»Íê¡£²¢¿ÉÒÔ½«µãµÄ×ø±ê×÷ΪÎı¾ÎĵµÊä³ö¡£
ÎÒ²»ÖªµÀÔõôÄÜʵÏÖ£¬Ð»Ð»£¡
ÓÃPictureBoxʵÏÖ°É,ÐèÒª¶Ô×ø±êµ¥Î»» ......
ÓÃVBÖеÄTimer¿Ø¼þ ¿ÉÒÔ»ñµÃʱ¼ä
µ«ÊÇÈç¹ûµçÄÔÉϵÄʱ¼äÏÔʾ²»ÕýÈ· ÄÇÆñ²»ÊÇ»ñµÃµÄʱ¼äÒ²ÊDz»ÕýÈ·µÄ
Ôõô»ñµÃÕýÈ·µÄʱ¼ä
Á¬Íø£¬´Ó±ðµÄµØ·½»ñµÃ
ÒýÓÃ
ÓÃVBÖеÄTimer¿Ø¼þ ¿ÉÒÔ»ñµÃʱ¼ä
µ«ÊÇÈç¹ûµçÄ ......