// JieShu.cpp : implementation file
//

#include "stdafx.h"
#include "work.h"
#include "JieShu.h"
#include "CommonData.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CJieShu dialog


CJieShu::CJieShu(CWnd* pParent /*=NULL*/)
	: CDialog(CJieShu::IDD, pParent)
{
	//{{AFX_DATA_INIT(CJieShu)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CJieShu::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CJieShu)
	DDX_Control(pDX, IDC_JTIAOMA_EDIT, m_JTiaoMa_Edit);
	DDX_Control(pDX, IDC_JNUMBER_EDIT, m_JNumber_Edit);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CJieShu, CDialog)
	//{{AFX_MSG_MAP(CJieShu)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CJieShu message handlers

void CJieShu::OnOK() 
{
	// TODO: Add extra validation here

	_RecordsetPtr m_pRecordset;
	m_pRecordset.CreateInstance("ADODB.Recordset");
	CString tiaoma,number,BIsReturned,BPreDate;
	m_JTiaoMa_Edit.GetWindowText(tiaoma);
	m_JNumber_Edit.GetWindowText(number);
	//看用戶是否有未處理的違章
	CString 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();
				return;
			}
		}
	}
	m_pRecordset->Close();

	//執(zhí)行操作3:若該書(shū)若被預(yù)約：若是被該用戶預(yù)約的，則刪除該預(yù)約記錄;否則不能借
	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)
		{
			CString pdate,num;
			num=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BSNumber"));
			pdate=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BPreDate"));
			if(num==number&&pdate!="3000-1-1")//本人預(yù)約的書(shū)籍
			{
				 m_pRecordset->Delete(adAffectCurrent);  // 參數(shù)adAffectCurrent為刪除當(dāng)前記錄
				 m_pRecordset->Update();
				 break;
			}
			if(num!=number&&pdate!="3000-1-1")//別人預(yù)約的書(shū)籍
			{
				MessageBox("該書(shū)為別人預(yù)約書(shū)籍!");
				m_pRecordset->Close();
				CDialog::OnOK();
				return;
			}
			m_pRecordset->MoveNext();
		}
	}
	m_pRecordset->Close();


	//該讀者是否可以預(yù)約:欠款或借書(shū)、預(yù)約書(shū)之和達(dá)最大量5
	int booknumber=0;
	QueryString="SELECT * FROM Book_Borrow_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();
		while(!m_pRecordset->adoEOF)
		{
			BPreDate=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BPreDate"));
			BIsReturned=(LPCTSTR)_bstr_t(m_pRecordset->GetCollect("BIsReturned"));
			if(BIsReturned=="-1"||BPreDate!="3000-1-1")
			{
				booknumber++;
			}

			m_pRecordset->MoveNext();
		}
	}
	if(booknumber>=5)
	{
		MessageBox("該用戶所借和所預(yù)約的書(shū)數(shù)量已達(dá)最大量……");
		m_pRecordset->Close();
		return;
	}
	m_pRecordset->Close();

	//執(zhí)行借操作1:將要在Book_Borrow_Infor表中插入記錄
	QueryString="SELECT * FROM Book_Borrow_Infor WHERE BSNumber='"+number+"'";
	m_pRecordset->Open((_bstr_t)QueryString,_variant_t((IDispatch *)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
	
	m_pRecordset->AddNew();
	CTime BBorrowDate=CTime::GetCurrentTime(),BReturnDate;
	CTimeSpan t(30,0,0,0);
	BReturnDate=BBorrowDate+t;
	int year,month,day;
	year=BBorrowDate.GetYear();month=BBorrowDate.GetMonth();day=BBorrowDate.GetDay();
	CString time;
	time.Format("%d-%d-%d",year,month,day);
	m_pRecordset->PutCollect("BNTiaoMa",(LPCTSTR)tiaoma);
	m_pRecordset->PutCollect("BBorrowDate",(LPCTSTR)time);
	m_pRecordset->PutCollect("BIsReturned","0");
	m_pRecordset->PutCollect("BPreDate","3000-1-1");
	m_pRecordset->PutCollect("BSNumber",(LPCTSTR)number);
	year=BReturnDate.GetYear();month=BReturnDate.GetMonth();day=BReturnDate.GetDay();
	time.Format("%d-%d-%d",year,month,day);
	m_pRecordset->PutCollect("BReturnDate",(LPCTSTR)time);
	m_pRecordset->Update();

	m_pRecordset->Close();

	//執(zhí)行操作2:修改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);
	m_pRecordset->MoveFirst();
	m_pRecordset->PutCollect("BCanBorrowDate",(LPCTSTR)time);
	m_pRecordset->Update();

	m_pRecordset->Close();

	MessageBox("借書(shū)成功");

	CDialog::OnOK();
}