#NoTrayIcon
#region ;**** 参数创建于 ACNWrapper_GUI ****
#AutoIt3Wrapper_icon=C:\Windows\system32\SHELL32.dll|-2
#AutoIt3Wrapper_Outfile=会员111.exe
#AutoIt3Wrapper_Res_Comment=会员信息 DIY BASC
#AutoIt3Wrapper_Res_Description=会员信息 DIY BASC
#AutoIt3Wrapper_Res_Fileversion=1.0.0.8
#AutoIt3Wrapper_Res_Fileversion_AutoIncrement=y
#endregion ;**** 参数创建于 ACNWrapper_GUI ****
#include <EditConstants.au3>
#include <GUIConstantsEx.au3>
#include <StaticConstants.au3>
#include <WindowsConstants.au3>
#include <String.au3>
#region ### START Koda GUI section ### Form=
Local $kahao, $zhuzhi, $xingming, $mima, $sfz, $chuangkou, $mulu, $ziti
$mulu = IniRead("basc.ini", "会员信息", "mulu", "")
$ziti = IniRead("basc.ini", "会员信息", "ziti", "楷体")
$chuangkou = IniRead("basc.ini", "会员信息", "chuangkou", "金雅网吧会员卡信息")
$Form1 = GUICreate($chuangkou, 305, 271, 0, @DesktopHeight - 318, $WS_SYSMENU)
GUISetBkColor(0xABCDEF)
WinSetOnTop($Form1, "", 1);窗口前置
$Label1 = GUICtrlCreateLabel("姓名", 28, 12, 42, 29)
GUICtrlSetFont(-1, 14, 400, 0, $ziti)
$Label2 = GUICtrlCreateLabel("会员密码", 5, 160, 80, 29)
GUICtrlSetFont(-1, 14, 400, 0, $ziti)
$Label3 = GUICtrlCreateLabel("身份证号码", 6, 207, 99, 29)
GUICtrlSetFont(-1, 14, 400, 0, $ziti)
$Label4 = GUICtrlCreateLabel("会员卡号", 4, 111, 80, 29)
GUICtrlSetFont(-1, 14, 400, 0, $ziti)
$Label5 = GUICtrlCreateLabel("住址", 29, 59, 42, 29)
GUICtrlSetFont(-1, 14, 400, 0, $ziti)
;~ ssdds()
$Input1 = GUICtrlCreateInput("", 109, 16, 180, 21)
GUICtrlSetFont(109, 16, 209, 21, $ziti)
$Input2 = GUICtrlCreateInput("", 108, 67, 180, 21)
GUICtrlSetFont(108, 67, 209, 21, $ziti)
$Input3 = GUICtrlCreateInput("", 106, 111, 180, 21)
GUICtrlSetFont(106, 111, 209, 21, $ziti)
$Input4 = GUICtrlCreateInput("", 106, 163, 180, 21)
GUICtrlSetFont(106, 163, 209, 21, $ziti)
$Input5 = GUICtrlCreateInput("", 108, 210, 180, 21)
GUICtrlSetFont(108, 210, 209, 21, $ziti)
GUISetState(@SW_SHOW)
AdlibRegister("ssdds",1000)
While 1
$nMsg = GUIGetMsg()
Switch $nMsg
Case $GUI_EVENT_CLOSE
Exit
EndSwitch
WEnd
Func ssdds()
;读取RZXCard.mdb,表为userinfo的最后一行
Local $mdb_data_path = $mulu & "\RZXCard.mdb", $mdb_data_pwd = "rzx1218"
Local $tblname = "userinfo"
$addfld = ObjCreate("ADODB.Connection")
$addfld.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & $mdb_data_path & ";Jet Oledb:Database Password=" & $mdb_data_pwd)
$RS = ObjCreate("ADODB.Recordset")
$RS.ActiveConnection = $addfld
$RS.Open("Select last(id_usernum) as kahao From " & $tblname & " ")
$kahao = $RS.fields("kahao").value
$RS.close
$RS.Open("Select last(id_key) as mima From " & $tblname & " ")
$mima = $RS.fields("mima").value
$RS.close
$RS.Open("Select last(id_idcard) as sfz From " & $tblname & " ")
$sfz = $RS.fields("sfz").value
$RS.close
$RS.Open("Select last(id_workcompany) as zhuzhi From " & $tblname & " ")
$zhuzhi = $RS.fields("zhuzhi").value
$RS.close
$RS.Open("Select last(id_Name) as xingming From " & $tblname & " ")
$xingming = $RS.fields("xingming").value
$RS.close
$addfld.Close
;读取RZXCard.mdb,表为userinfo的最后一行
$kahao = _HexToString($kahao);十六进制转换
$zhuzhi = _HexToString($zhuzhi)
$xingming = _HexToString($xingming)
$mima = _HexToString($mima)
$sfz = _HexToString($sfz)
GUICtrlSetData($Input1, $xingming)
GUICtrlSetData($Input2, $zhuzhi)
GUICtrlSetData($Input3, $kahao)
GUICtrlSetData($Input4, $mima)
GUICtrlSetData($Input5, $sfz)
EndFunc ;==>ssdds