📄 borrowbook.cpp
字号:
// BorrowBook.cpp : implementation file
//
#include "stdafx.h"
#include "libraryMS.h"
#include "BorrowBook.h"
#include "Borrow.h"
/////////////////////////////////////////////
#include "column.h"
#include "columns.h"
////////////////////////////////////////////
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
extern CBorrow Borrow;
extern CReader BReader;
extern CBook BBook;
CBorrowBook::CBorrowBook(CWnd* pParent /*=NULL*/)
: CDialog(CBorrowBook::IDD, pParent)
{
//{{AFX_DATA_INIT(CBorrowBook)
m_vIDReader = _T("");
m_vIDReaderShow = _T("");
m_vDateB = _T("");
m_vISBN = _T("");
m_vKeepTime = _T("");
m_Query = _T("");
m_vTitle = _T("");
m_vNameReaderShow = _T("");
//}}AFX_DATA_INIT
}
void CBorrowBook::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CBorrowBook)
DDX_Text(pDX, IDC_IDReader_EDIT, m_vIDReader);
DDX_Control(pDX, IDC_DATAGRID, m_datagrid);
DDX_Control(pDX, IDC_ADODC1, m_adodc);
DDX_Text(pDX, IDC_IDReader_show_EDIT, m_vIDReaderShow);
DDX_Text(pDX, IDC_DateB_EDIT, m_vDateB);
DDX_Text(pDX, IDC_ISBN_EDIT, m_vISBN);
DDX_Text(pDX, IDC_KeepTime_EDIT, m_vKeepTime);
DDX_Text(pDX, IDC_Query_EDIT, m_Query);
DDX_Text(pDX, IDC_Title_EDIT, m_vTitle);
DDX_Text(pDX, IDC_NameReader_show_DIT, m_vNameReaderShow);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CBorrowBook, CDialog)
//{{AFX_MSG_MAP(CBorrowBook)
ON_BN_CLICKED(IDC_exit, Onexit)
ON_BN_CLICKED(IDC_Login_BUTTON, OnLoginBUTTON)
ON_BN_CLICKED(IDC_Ok, OnOk)
ON_BN_CLICKED(IDC_suer, Onsuer)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CBorrowBook message handlers
BOOL CBorrowBook::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
//GetDlgItem(IDC_Show_BUTTON)->EnableWindow(false);
GetDlgItem(IDC_Ok)->EnableWindow(false);
GetDlgItem(IDC_Query)->EnableWindow(false);
GetDlgItem(IDC_QueryAll)->EnableWindow(false);
GetDlgItem(IDC_Query_EDIT)->EnableWindow(false);
GetDlgItem(IDC_ISBN_EDIT)->EnableWindow(false);
GetDlgItem(IDC_Ok)->EnableWindow(false);
vSQL="SELECT Title as 书名, ISBN, DateB 借书日期, KeepTime as 还书日期 FROM t_Borrow where IDReader = '";
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CBorrowBook::Onexit()
{
// TODO: Add your control notification handler code here
OnOK();
}
void CBorrowBook::OnLoginBUTTON()
{
// TODO: Add your control notification handler code here
if(IsValidate())//登录成功
{
m_vIDReaderShow=BReader.GetIDReader();
m_vNameReaderShow = BReader.GetNameReader();
// GetDlgItem(IDC_Show_BUTTON)->EnableWindow(true);
GetDlgItem(IDC_Ok)->EnableWindow(true);
GetDlgItem(IDC_Query)->EnableWindow(true);
GetDlgItem(IDC_QueryAll)->EnableWindow(true);
GetDlgItem(IDC_Query_EDIT)->EnableWindow(true);
GetDlgItem(IDC_Login_BUTTON)->EnableWindow(false);
GetDlgItem(IDC_IDReader_EDIT)->EnableWindow(false);
GetDlgItem(IDC_ISBN_EDIT)->EnableWindow(true);
Borrow.sql_getKeepTime();
m_vKeepTime = Borrow.GetKeepTime();
Borrow.sql_getTime();
m_vDateB = Borrow.GetDateB();
UpdateData(false);
_bstr_t vSQL2;
vSQL2 = vSQL+m_vIDReaderShow+"'";
m_adodc.SetRecordSource(vSQL2);
m_adodc.Refresh();
UpdateData(false);
}
/////////////////////////////////////////////////////////调节列表宽度
variant_t vIndex;
vIndex = long(0);
m_datagrid.GetColumns().GetItem(vIndex).SetWidth(170);
vIndex = long(1);
m_datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
vIndex = long(2);
m_datagrid.GetColumns().GetItem(vIndex).SetWidth(105);
vIndex = long(3);
m_datagrid.GetColumns().GetItem(vIndex).SetWidth(105);
//////////////////////////////////////////////////////////////
}
BOOL CBorrowBook::IsValidate()
{
UpdateData(true);
m_vIDReader.TrimLeft();
m_vIDReader.TrimRight();
if(m_vIDReader.IsEmpty())
{
MessageBox("请输入借书证号");
return false;
}
BReader.GetData(m_vIDReader);
if(BReader.GetIDReader()!='-1')
{
MessageBox("借书证号正确");
return true;
}
else//登录失败
{
MessageBox("借书证号错误");
return false;
}
}
void CBorrowBook::OnOk()
{
// TODO: Add your control notification handler code here
////////////////////////////////////////////////////////检查ISBN是否正确
if(BBook.GetISBNBook()!='-1')
{
//CBorrow BorrowBook;
Borrow.SetIDReader(BReader.GetIDReader());
Borrow.SetISBN(BBook.GetISBNBook());
Borrow.SetNameReader(BReader.GetNameReader());
Borrow.SetTitle(BBook.GetTitleBook());
Borrow.sql_insert();
}
else{MessageBox("ISBN错误");return;}
////////////////////////////////////////////////////////
}
void CBorrowBook::Onsuer()
{
// TODO: Add your control notification handler code here
UpdateData(true);
////////////////////////////////////////////////////////检查ISBN是否正确
m_vISBN.TrimLeft();
m_vISBN.TrimRight();
if(m_vISBN.IsEmpty())
{
MessageBox("ISBN不能为空");
return;
}
BBook.GetData(m_vISBN);
m_vTitle = BBook.GetTitleBook();
UpdateData(false);
GetDlgItem(IDC_Ok)->EnableWindow(true);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -