// 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();
}