library.clw

多张数据表 含有SQL语句

; CLW file contains information for the MFC ClassWizard

[General Info]
Version=1
LastClass=CCheckBorrowDlg
LastTemplate=CDialog
NewFileInclude1=#include "stdafx.h"
NewFileInclude2=#include "Library.h"

ClassCount=21
Class1=CLibraryApp
Class2=CLibraryDlg

ResourceCount=34
Resource2=IDD_DIALOG_NEW_PROOF
Resource1=IDR_MAINFRAME
Class3=CMainDlg
Resource3=IDD_LIBRARY_DIALOG
Class4=CLoginSet
Resource4=IDD_DIALOG_BOOK_INFO
Class5=CPasswdDlg
Resource5=IDD_DIALOG_CHECK_BORROW
Class6=CBorrowDlg
Class7=CProofSet
Class8=CBookSet
Class9=CBorrowSet
Resource6=IDD_DIALOG_ABOUT
Class10=CCheckBorrowDlg
Resource7=IDD_DIALOG_BOOK_LOST
Class11=CNewBooksDlg
Resource8=IDD_DIALOG_BORROW
Class12=CCheckBooksDlg
Resource9=IDD_DIALOG_CHECK_BOOKS
Class13=CBookLostDlg
Resource10=IDD_DIALOG_PROOF_INFO
Class14=CBookInfoDlg
Resource11=IDD_DIALOG_PROOF_LOST
Class15=CPersonInfoDlg
Class16=CPunishSet
Resource12=IDR_MENU_MAIN
Class17=CAboutDlg
Resource13=IDD_DIALOG_PASSWD
Class18=CNewProofDlg
Resource14=IDD_DIALOG_BEGIN
Class19=CCheckProofDlg
Resource15=IDD_DIALOG_MAIN
Class20=CProofLostDlg
Resource16=IDD_DIALOG_NEW_BOOKS
Class21=CBeginDlg
Resource17=IDD_DIALOG_CHECKPROOF
Resource18=IDR_TOOLBAR_MAIN (Chinese (P.R.C.))
Resource19=IDD_MAIN (Chinese (P.R.C.))
Resource20=IDD_DIALOG1 (Chinese (P.R.C.))
Resource21=IDD_PROOF_LOST (Chinese (P.R.C.))
Resource22=IDD_BORROW (Chinese (P.R.C.))
Resource23=IDD_CHECK_BORROW (Chinese (P.R.C.))
Resource24=IDD_NEW_BOOKS (Chinese (P.R.C.))
Resource25=IDD_BOOK_INFO (Chinese (P.R.C.))
Resource26=IDD_ABOUT (Chinese (P.R.C.))
Resource27=IDD_CHECK_PROOF (Chinese (P.R.C.))
Resource28=IDD_BOOK_LOST (Chinese (P.R.C.))
Resource29=IDD_PROOF_INFO (Chinese (P.R.C.))
Resource30=IDD_NEW_PROOF (Chinese (P.R.C.))
Resource31=IDD_CHECK_BOOKS (Chinese (P.R.C.))
Resource32=IDD_LIBRARY (Chinese (P.R.C.))
Resource33=IDD_PASSWD (Chinese (P.R.C.))
Resource34=IDR_MENU_MAIN (Chinese (P.R.C.))

[CLS:CLibraryApp]
Type=0
HeaderFile=Library.h
ImplementationFile=Library.cpp
Filter=N
LastObject=CLibraryApp

[CLS:CLibraryDlg]
Type=0
HeaderFile=LibraryDlg.h
ImplementationFile=LibraryDlg.cpp
Filter=W
BaseClass=CDialog
VirtualFilter=dWC
LastObject=CLibraryDlg



[DLG:IDD_LIBRARY_DIALOG]
Type=1
Class=CLibraryDlg
ControlCount=9
Control1=IDC_EDIT_USER,edit,1350631552
Control2=IDC_EDIT_PASSWD,edit,1350631584
Control3=IDC_BUTTON_OK,button,1342242816
Control4=IDC_BUTTON_CANCEL,button,1342242816
Control5=IDC_STATIC,static,1342308865
Control6=IDC_STATIC,static,1342308352
Control7=IDC_STATIC,static,1342312961
Control8=IDC_STATIC,static,1342308352
Control9=IDC_STATIC,static,1342308352

[DLG:IDD_DIALOG_MAIN]
Type=1
Class=CMainDlg
ControlCount=6
Control1=IDC_STATIC,static,1342312448
Control2=IDC_STATIC_PERSON,static,1342312448
Control3=IDC_STATIC,static,1342312448
Control4=IDC_STATIC_TIMER,static,1342312448
Control5=IDC_STATIC,static,1342177294
Control6=IDC_BUTTON_BEGIN,button,1342242816

[CLS:CMainDlg]
Type=0
HeaderFile=MainDlg.h
ImplementationFile=MainDlg.cpp
BaseClass=CDialog
Filter=W
LastObject=CMainDlg
VirtualFilter=dWC

[MNU:IDR_MENU_MAIN]
Type=1
Class=CMainDlg
Command1=ID_MENU_LOGOUT
Command2=ID_MENU_PASSWORD
Command3=ID_MENU_EXIT
Command4=ID_MENU_NEW_BOOKS
Command5=ID_MENU_CHECK_BOOKS
Command6=ID_MENU_BORROW
Command7=ID_MENU_CHECK_BORROW
Command8=ID_MENU_BOOK_LOST
Command9=ID_MENU_MAKE_PROOF
Command10=ID_MENU_CHECK_PROOF
Command11=ID_MENU_PROOF_LOST
Command12=ID_MENU_HOWTO
Command13=ID_MENU_ABOUT
CommandCount=13

[CLS:CLoginSet]
Type=0
HeaderFile=LoginSet.h
ImplementationFile=LoginSet.cpp
BaseClass=CRecordset
Filter=N
VirtualFilter=r
LastObject=CLoginSet

[DB:CLoginSet]
DB=1
DBType=ODBC
ColumnCount=3
Column1=[User_Name], 12, 100
Column2=[Password], 12, 100
Column3=[WorkID], 8, 8

[DLG:IDD_DIALOG_PASSWD]
Type=1
Class=CPasswdDlg
ControlCount=7
Control1=IDC_EDIT_NEW_PASS,edit,1350631584
Control2=IDC_EDIT_CONFIRM_PASS,edit,1350631584
Control3=IDC_STATIC,static,1342308352
Control4=IDC_STATIC,static,1342308352
Control5=IDC_STATIC,static,1342177283
Control6=IDC_BUTTON_OK,button,1342242816
Control7=IDC_BUTTON_CANCEL,button,1342242816

[CLS:CPasswdDlg]
Type=0
HeaderFile=PasswdDlg.h
ImplementationFile=PasswdDlg.cpp
BaseClass=CDialog
Filter=D
LastObject=IDC_BUTTON_CANCEL
VirtualFilter=dWC

[DLG:IDD_DIALOG_BORROW]
Type=1
Class=CBorrowDlg
ControlCount=14
Control1=IDC_STATIC,button,1342177287
Control2=IDC_LIST_SHOW,SysListView32,1350631425
Control3=IDC_STATIC,static,1342177294
Control4=IDC_EDIT_PROOF,edit,1350631552
Control5=IDC_EDIT_BOOK,edit,1350631552
Control6=IDC_STATIC,static,1342308352
Control7=IDC_STATIC,static,1342308352
Control8=IDC_BUTTON_OK,button,1342242816
Control9=IDC_BUTTON_RESET,button,1342242816
Control10=IDC_STATIC,static,1342308352
Control11=IDC_BUTTON_CHECK_BOOKS,button,1342242816
Control12=IDC_BUTTON_CHECK_BORROW,button,1342242816
Control13=IDC_BUTTON_BACK,button,1342242816
Control14=IDC_BUTTON_RETURN,button,1342242816

[CLS:CBorrowDlg]
Type=0
HeaderFile=BorrowDlg.h
ImplementationFile=BorrowDlg.cpp
BaseClass=CDialog
Filter=D
LastObject=IDC_BUTTON_RETURN
VirtualFilter=dWC

[CLS:CProofSet]
Type=0
HeaderFile=ProofSet.h
ImplementationFile=ProofSet.cpp
BaseClass=CRecordset
Filter=N
VirtualFilter=r

[DB:CProofSet]
DB=1
DBType=ODBC
ColumnCount=8
Column1=[Proof_ID], 12, 100
Column2=[Name], 12, 100
Column3=[Sex], 12, 100
Column4=[Birth_Time], 11, 16
Column5=[Address], 12, 100
Column6=[ID_Number], 12, 100
Column7=[Tel_Number], 12, 100
Column8=[Now_Borrow_Amount], 4, 4

[CLS:CBookSet]
Type=0
HeaderFile=BookSet.h
ImplementationFile=BookSet.cpp
BaseClass=CRecordset
Filter=N
VirtualFilter=r
LastObject=CBookSet

[DB:CBookSet]
DB=1
DBType=ODBC
ColumnCount=8
Column1=[Book_ID], 12, 100
Column2=[Book_Name], 12, 100
Column3=[Writer], 12, 100
Column4=[Press], 12, 100
Column5=[Price], 8, 8
Column6=[InLibrary_Date], 11, 16
Column7=[Total_Amount], 4, 4
Column8=[Now_Amount], 4, 4

[CLS:CBorrowSet]
Type=0
HeaderFile=BorrowSet.h
ImplementationFile=BorrowSet.cpp
BaseClass=CRecordset
Filter=N
VirtualFilter=r
LastObject=CBorrowSet

[DB:CBorrowSet]
DB=1
DBType=ODBC
ColumnCount=4
Column1=[BorrowID], 4, 4
Column2=[Proof_ID], 12, 100
Column3=[Book_ID], 12, 100
Column4=[Borrow_Date], 11, 16

[DLG:IDD_DIALOG_CHECK_BORROW]
Type=1
Class=CCheckBorrowDlg
ControlCount=7
Control1=IDC_EDIT_PROOF,edit,1350631552
Control2=IDC_STATIC,static,1342308352
Control3=IDC_BUTTON_REQUERY,button,1342242816
Control4=IDC_BUTTON_RESET,button,1342242816
Control5=IDC_LIST_RESULT,SysListView32,1350631425
Control6=IDC_BUTTON_BACK,button,1342242816
Control7=IDC_STATIC,static,1342177294

[CLS:CCheckBorrowDlg]
Type=0
HeaderFile=CheckBorrowDlg.h
ImplementationFile=CheckBorrowDlg.cpp
BaseClass=CDialog
Filter=D
LastObject=CCheckBorrowDlg
VirtualFilter=dWC

[DLG:IDD_DIALOG_NEW_BOOKS]
Type=1
Class=CNewBooksDlg
ControlCount=21
Control1=IDC_EDIT_BOOK_NO,edit,1350631552
Control2=IDC_EDIT_BOOK_NAME,edit,1350631552
Control3=IDC_EDIT_WRITER,edit,1350631552
Control4=IDC_EDIT_PRICE,edit,1350631552
Control5=IDC_EDIT_PRESS,edit,1350631552
Control6=IDC_EDIT_TOTAL,edit,1350631552
Control7=IDC_EDIT_NOW,edit,1350631552
Control8=IDC_BUTTON_IN,button,1342242816
Control9=IDC_BUTTON_CHECK_BOOKS,button,1342242816
Control10=IDC_BUTTON_CHECK_ALL,button,1342242816
Control11=IDC_BUTTON_BACK,button,1342242816
Control12=IDC_LIST_RESULT,SysListView32,1350631433
Control13=IDC_STATIC,static,1342177294
Control14=IDC_STATIC,button,1342177287
Control15=IDC_STATIC,static,1342308352
Control16=IDC_STATIC,static,1342308352
Control17=IDC_STATIC,static,1342308352
Control18=IDC_STATIC,static,1342308352
Control19=IDC_STATIC,static,1342308352
Control20=IDC_STATIC,static,1342308352
Control21=IDC_STATIC,static,1342308352

[CLS:CNewBooksDlg]
Type=0
HeaderFile=NewBooksDlg.h
ImplementationFile=NewBooksDlg.cpp
BaseClass=CDialog
Filter=D
LastObject=IDC_BUTTON_IN
VirtualFilter=dWC

[DLG:IDD_DIALOG_CHECK_BOOKS]
Type=1
Class=CCheckBooksDlg
ControlCount=6
Control1=IDC_STATIC,static,1342308352
Control2=IDC_EDIT_BOOK_NO,edit,1350631552
Control3=IDC_BUTTON_CHECK,button,1342242816
Control4=IDC_BUTTON_CHECK_ALL,button,1342242816
Control5=IDC_BUTTON_BACK,button,1342242816
Control6=IDC_LIST_RESULT,SysListView32,1350631425

[CLS:CCheckBooksDlg]
Type=0
HeaderFile=CheckBooksDlg.h
ImplementationFile=CheckBooksDlg.cpp
BaseClass=CDialog
Filter=D
LastObject=IDC_BUTTON_BACK
VirtualFilter=dWC

[DLG:IDD_DIALOG_BOOK_LOST]
Type=1
Class=CBookLostDlg
ControlCount=9
Control1=IDC_STATIC,static,1342308352
Control2=IDC_EDIT_BOOK_NO,edit,1350631552
Control3=IDC_STATIC,static,1342308352
Control4=IDC_EDIT_PROOF_NO,edit,1350631552
Control5=IDC_BUTTON_LOST,button,1342242816
Control6=IDC_BUTTON_BOOK_INFO,button,1342242816
Control7=IDC_BUTTON_PROOF_INFO,button,1342242816
Control8=IDC_EDIT_PUNI_MONEY,edit,1342244865
Control9=IDC_STATIC,static,1342308352

[CLS:CBookLostDlg]
Type=0
HeaderFile=BookLostDlg.h
ImplementationFile=BookLostDlg.cpp
BaseClass=CDialog
Filter=D
LastObject=IDC_BUTTON_BOOK_INFO
VirtualFilter=dWC

[DLG:IDD_DIALOG_BOOK_INFO]
Type=1
Class=CBookInfoDlg
ControlCount=10
Control1=IDC_STATIC,static,1342308352
Control2=IDC_STATIC,static,1342308352
Control3=IDC_STATIC,static,1342308352
Control4=IDC_STATIC,static,1342308352
Control5=IDC_STATIC,static,1342308352
Control6=IDC_STATIC_BOOKNO,static,1342308865
Control7=IDC_STATIC_NAME,static,1342308353
Control8=IDC_STATIC_WRITER,static,1342308865
Control9=IDC_STATIC_PRESS,static,1342308865
Control10=IDC_EDIT_PRICE,edit,1342244865

[CLS:CBookInfoDlg]
Type=0
HeaderFile=BookInfoDlg.h
ImplementationFile=BookInfoDlg.cpp
BaseClass=CDialog
Filter=D
LastObject=CBookInfoDlg
VirtualFilter=dWC

[DLG:IDD_DIALOG_PROOF_INFO]
Type=1
Class=CPersonInfoDlg
ControlCount=16
Control1=IDC_STATIC,static,1342308352
Control2=IDC_STATIC,static,1342308352
Control3=IDC_STATIC,static,1342308352
Control4=IDC_STATIC,static,1342308352
Control5=IDC_STATIC,static,1342308352
Control6=IDC_STATIC,static,1342308352
Control7=IDC_STATIC,static,1342308352
Control8=IDC_STATIC,static,1342308352
Control9=IDC_STATIC_PROOF_NO,static,1342308352
Control10=IDC_STATIC_NAME,static,1342308352
Control11=IDC_STATIC_SEX,static,1342308352
Control12=IDC_STATIC_BIRTH_DATE,static,1342308352
Control13=IDC_STATIC_ID_NUMBER,static,1342308352
Control14=IDC_STATIC_PHONE,static,1342308352