?? huanshu.cpp
字號:
// HuanShu.cpp : implementation file
//
#include "stdafx.h"
#include "work.h"
#include "HuanShu.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CHuanShu dialog
CHuanShu::CHuanShu(CWnd* pParent /*=NULL*/)
: CDialog(CHuanShu::IDD, pParent)
{
//{{AFX_DATA_INIT(CHuanShu)
//}}AFX_DATA_INIT
}
void CHuanShu::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CHuanShu)
DDX_Control(pDX, IDC_HTIAOMA_EDIT, m_HTiaoMa_Edit);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CHuanShu, CDialog)
//{{AFX_MSG_MAP(CHuanShu)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CHuanShu message handlers
void CHuanShu::OnOK()
{
// TODO: Add extra validation here
_RecordsetPtr m_pRecordset;
m_pRecordset.CreateInstance("ADODB.Recordset");
CString number,QueryString;
//將Book_Borrow_Infor的BIsReturned改變
CString tiaoma,BIsReturned;
m_HTiaoMa_Edit.GetWindowText(tiaoma);
QueryString="SELECT * FROM Book_Borrow_Infor WHERE BNTiaoMa='"+tiaoma+"'";
m_pRecordset->Open((_bstr_t)QueryString,_variant_t((IDispatch *)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
if(!m_pRecordset->BOF)
{
m_pRecordset->MoveFirst();
while(!m_pRecordset->adoEOF)
{
BIsReturned=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BIsReturned"));
if(BIsReturned=="0")
{
m_pRecordset->PutCollect("BIsReturned","-1");
number=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BSNumber"));
m_pRecordset->Update();
break;
}
m_pRecordset->MoveNext();
}
}
m_pRecordset->Close();
//將Book_Infor的BCanBorrowDate值改為當前日期
QueryString="SELECT * FROM Book_Infor WHERE BNTiaoMa='"+tiaoma+"'";
m_pRecordset->Open((_bstr_t)QueryString,_variant_t((IDispatch *)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
if(!m_pRecordset->BOF)
{
m_pRecordset->MoveFirst();
m_pRecordset->PutCollect("BCanBorrowDate","2000-1-1");
m_pRecordset->Update();
}
m_pRecordset->Close();
//看用戶是否有違章記錄
QueryString="SELECT * FROM WeiZhang_Infor WHERE BSNumber='"+number+"'";
m_pRecordset->Open((_bstr_t)QueryString,_variant_t((IDispatch *)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
if(!m_pRecordset->BOF)
{
m_pRecordset->MoveFirst();
CString IsOK;
IsOK=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("IsOK"));
while(!m_pRecordset->adoEOF)
{
if(IsOK=="0")
{
MessageBox("請提醒該用戶有未處理的違章記錄!");
}
}
}
m_pRecordset->Close();
MessageBox("還書成功!");
CDialog::OnOK();
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -