brrowpage.cpp

bookman电子图书馆

// BrrowPage.cpp : implementation file
//

#include "stdafx.h"
#include "bookMan.h"
#include "BrrowPage.h"
#include "bookManView.h"
#include "MainFrm.h"
#include "AdoBind.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBrrowPage dialog

CBrrowPage::CBrrowPage(CWnd* pParent /*=NULL*/)
	: CDialog(CBrrowPage::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBrrowPage)

	//}}AFX_DATA_INIT
	InitData();
}


void CBrrowPage::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBrrowPage)
	DDX_Control(pDX, IDC_BORROWANDBOUT_BUTTON_RETURN, m_return);
	DDX_Control(pDX, IDC_BORROWANDBOUT_COMBO_BORROWTYPE, m_borrowType);
	DDX_Control(pDX, IDC_BORROWANDBOUT_BUTTON_SUBMIT, m_ctrlSubmit);
	DDX_Control(pDX, IDC_BORROWANDBOUT_LIST_EXIST, m_exist);
	DDX_CBIndex(pDX, IDC_BORROWANDBOUT_COMBO_DOTYPE, m_doType);
	DDX_Text(pDX, IDC_BORROWANDBOUT_EDIT_OWNER, m_strOwner);
	DDV_MaxChars(pDX, m_strOwner, 10);
	DDX_Text(pDX, IDC_BORROWANDBOUT_EDIT_NAME, m_strBookName);
	DDV_MaxChars(pDX, m_strBookName, 50);
	DDX_Text(pDX, IDC_BORROWANDBOUT_EDIT_BORROWER, m_strBorrower);
	DDV_MaxChars(pDX, m_strBorrower, 10);
	DDX_CBIndex(pDX, IDC_BORROWANDBOUT_COMBO_BORROWTYPE, m_nBigType);
	DDX_CBString(pDX, IDC_BUYSELF_COMBO_PRESS, m_strPress);
	DDV_MaxChars(pDX, m_strPress, 30);
	DDX_CBString(pDX, IDC_BORROWANDBOUT_COMBO_TYPE, m_strType);
	DDX_DateTimeCtrl(pDX, IDC_BORROWANDBOUT_DATETIMEPICKER_BORROWDATE, m_bInDate);
	DDX_DateTimeCtrl(pDX, IDC_BORROWANDBOUT_DATETIMEPICKER_BOUTDATE, m_bOutDate);
	DDX_DateTimeCtrl(pDX, IDC_BORROWANDBOUT_DATETIMEPICKER_RETURNDATE, m_returnDate);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CBrrowPage, CDialog)
	//{{AFX_MSG_MAP(CBrrowPage)
	ON_WM_CTLCOLOR()
	ON_CBN_SELCHANGE(IDC_BORROWANDBOUT_COMBO_DOTYPE, OnSelchangeBorrowandboutComboDotype)
	ON_BN_CLICKED(IDC_BORROWANDBOUT_BUTTON_RETURN, OnBorrowandboutButtonReturn)
	ON_BN_CLICKED(IDC_BORROWANDBOUT_BUTTON_SUBMIT, OnBorrowandboutButtonSubmit)
	ON_NOTIFY(NM_CLICK, IDC_BORROWANDBOUT_LIST_EXIST, OnClickBorrowandboutListExist)
	ON_NOTIFY(NM_KILLFOCUS, IDC_BORROWANDBOUT_LIST_EXIST, OnKillfocusBorrowandboutListExist)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBrrowPage message handlers
HBRUSH CBrrowPage::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	return hbr;
}

BOOL CBrrowPage::OnInitDialog() 
{
	CDialog::OnInitDialog();

	//设置物种组合框的图像列表
	iBorrowType.Create(16,16,TRUE,3,1);
	AddBitmap(IDB_BOOK);
	AddBitmap(IDB_CDROM);
	AddBitmap(IDB_PAPER);

	COMBOBOXEXITEM buyItem[3];
	LPTSTR pszText[3]={"书籍杂志","软件光盘","报刊读物"};
	for(int i=0;i<3;i++)
	{
		buyItem[i].mask=CBEIF_TEXT|CBEIF_IMAGE|CBEIF_SELECTEDIMAGE;
		buyItem[i].iItem=i;
		buyItem[i].pszText=pszText[i];
		buyItem[i].iImage=i;
		buyItem[i].iSelectedImage=i;
		m_borrowType.InsertItem(&buyItem[i]);
	}
	m_borrowType.SetCurSel(0);
	m_borrowType.SetImageList(&iBorrowType);
	
	brush.CreateSolidBrush(RGB(255,224,240));
	//得到TAB控件的客户区大小
	CRect tabRect;
	((CBookManView *)((CMainFrame *)AfxGetMainWnd())->GetActiveView())->m_tabCtrl.GetClientRect(&tabRect);
	//设置对话框大小，使其与TAB控件相适应
	SetWindowPos(NULL,0,0,tabRect.Width()-SP_RIGHT,tabRect.Height()-SP_BOTTOM,SWP_NOMOVE);
	//得到TAB控件的WINDOW位置大小
	CRect tabWindowRect;
	((CBookManView *)((CMainFrame *)AfxGetMainWnd())->GetActiveView())->m_tabCtrl.GetWindowRect(&tabWindowRect);
	//得到LIST控件的窗口位置
	CRect listWindowRect;
	m_exist.GetWindowRect(&listWindowRect);
	//设置列表控件的初始大小
	m_exist.SetWindowPos(NULL,0,0,tabWindowRect.right-listWindowRect.left-10,tabWindowRect.bottom-listWindowRect.top-10,SWP_NOMOVE);
	//向列表控件插入列项目
	m_exist.InsertColumn(0,"类别",LVCFMT_LEFT,50,0);
	m_exist.InsertColumn(1,"物种",LVCFMT_LEFT,80,1);
	m_exist.InsertColumn(2,"名称",LVCFMT_LEFT,120,2);
	m_exist.InsertColumn(3,"出版社",LVCFMT_LEFT,120,3);
	m_exist.InsertColumn(4,"类型",LVCFMT_LEFT,100,4);
	m_exist.InsertColumn(5,"所有人",LVCFMT_LEFT,100,5);
	m_exist.InsertColumn(6,"借书人",LVCFMT_LEFT,100,6);
	m_exist.InsertColumn(7,"借入日期",LVCFMT_LEFT,120,7);
	m_exist.InsertColumn(8,"借出日期",LVCFMT_LEFT,120,8);
	m_exist.InsertColumn(9,"是否归还",LVCFMT_LEFT,30,8);
	m_exist.InsertColumn(10,"归还日期",LVCFMT_LEFT,120,9);
	//设置列表控件扩展属性
	m_exist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_TRACKSELECT|
		LVS_EX_GRIDLINES);

	RefreshData();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CBrrowPage::OnSelchangeBorrowandboutComboDotype() 
{
	UpdateData();
	if(m_doType==0)
	{
		m_ctrlSubmit.SetWindowText("借入");
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_BOUTDATE)->EnableWindow(FALSE);
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_RETURNDATE)->EnableWindow(FALSE);
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_BORROWDATE)->EnableWindow(TRUE);
	}
	else if(m_doType==1)
	{
		m_ctrlSubmit.SetWindowText("借出");
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_BOUTDATE)->EnableWindow(TRUE);
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_RETURNDATE)->EnableWindow(FALSE);
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_BORROWDATE)->EnableWindow(FALSE);
	}
	m_return.EnableWindow(FALSE);
	//InitDat
}

void CBrrowPage::AddBitmap(UINT nID)
{
	BOOL breturn;
	CBitmap bm;
	breturn=bm.LoadBitmap(nID);
	if(breturn)
	{
		iBorrowType.Add(&bm,RGB(255,255,255));
		bm.DeleteObject();
	}
}

void CBrrowPage::InitData()
{
	m_doType = 0;
	m_strOwner = _T("none");
	m_strBookName = _T("none");
	m_strBorrower = _T("none");
	m_bInDate = COleDateTime::GetCurrentTime();
	m_bOutDate = COleDateTime::GetCurrentTime();
	m_returnDate = COleDateTime::GetCurrentTime();
	m_nBigType = 0;
	m_strPress = _T("");
	m_strType = _T("");
}

void CBrrowPage::RefreshData()
{
	_RecordsetPtr pRst=NULL;
	IADORecordBinding *picRs=NULL;
	CBorrowAdoBind rs;
	CString strType,strReturn;
	m_exist.DeleteAllItems();
	try{
		TESTHR(pRst.CreateInstance("ADODB.Recordset"));
		pRst->Open("select * from BORROW",pConn.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);
		TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID *)&picRs));
		TESTHR(picRs->BindToRecordset(&rs));
		int item=0;
		CString str;
		while(!pRst->adoEOF)
		{
			str.Format("%s",rs.m_szFlag);
			m_exist.InsertItem(item,str);
			strType=str;
			str.Format("%s",rs.m_szBigType);
			m_exist.SetItemText(item,1,str);
			str.Format("%s",rs.m_szName);
			m_exist.SetItemText(item,2,str);
			str.Format("%s",rs.m_szCbs);
			m_exist.SetItemText(item,3,str);
			str.Format("%s",rs.m_szType);
			m_exist.SetItemText(item,4,str);
			str.Format("%s",rs.m_szOwner);
			m_exist.SetItemText(item,5,str);
			str.Format("%s",rs.m_szBorrower);
			m_exist.SetItemText(item,6,str);
			if(strType=="借入")
				str.Format("%s",rs.m_szBinTime);
			else
				str="---";
			m_exist.SetItemText(item,7,str);
			if(strType=="借出")
				str.Format("%s",rs.m_szBoutTime);
			else
				str="---";
			m_exist.SetItemText(item,8,str);
			str.Format("%s",rs.m_szReturn);
			m_exist.SetItemText(item,9,str);
			strReturn=str;
			if(strReturn=="是")
			{
				str.Format("%s",rs.m_szReturnTime);
				m_exist.SetItemText(item,10,str);
			}
			else
				m_exist.SetItemText(item,10,"---");
			item++;
			pRst->MoveNext();
		}
		picRs->Release();
		pRst->Close();
	}
	catch(_com_error &e)
	{
		DisplayAdoError(e);
		return;
	}
}

void CBrrowPage::OnBorrowandboutButtonReturn() 
{
	if(m_exist.GetItemCount()==0)
	{
		m_ctrlSubmit.EnableWindow(TRUE);
		m_return.EnableWindow(FALSE);
		return;
	}
	UpdateData();
	_RecordsetPtr pRst=NULL;
	CString strQuery,strReturnTime;
	strQuery="select * from BORROW where NAME='"+m_strBookName+"' and CBS='"+m_strPress+"'";
	try{
		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));
		pRst->Open(strQuery.AllocSysString(),pConn.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);
		int count=pRst->GetRecordCount();
		if(count!=0)
		{
			strReturnTime=m_returnDate.Format("%Y-%m-%d");
			strQuery="update BORROW set RETURN='是', RETURNTIME='"+strReturnTime+"' where NAME='"+m_strBookName+"' and CBS='"+m_strPress+"'";
			pConn->Execute(strQuery.AllocSysString(),NULL,adModeUnknown);
		}
		pRst->Close();
	}
	catch(_com_error &e)
	{
		DisplayAdoError(e);
		return;
	}
	RefreshData();
	InitData();
	UpdateData(FALSE);
}

void CBrrowPage::OnBorrowandboutButtonSubmit() 
{
	UpdateData();
	CString strQuery,strDoType,strBigtype,strBoutDate,strBinDate,strReturnDate;
	if(m_doType==0)
		strDoType="借入";
	else
		strDoType="借出";
	if(m_nBigType==0)
		strBigtype="书籍杂志";
	else if(m_nBigType==1)
		strBigtype="软件光盘";
	else
		strBigtype="报刊读物";
	strBinDate=m_bInDate.Format("%Y-%m-%d");
	strBoutDate=m_bOutDate.Format("%Y-%m-%d");
	strReturnDate=m_returnDate.Format("%Y-%m-%d");
	strQuery="Insert into BORROW (FLAG,BIGTYPE,NAME,CBS,TYPE,OWNER,BORROWER,BINTIME,BOUTTIME,RETURN,RETURNTIME) values('" \
		+strDoType+"','"+strBigtype+"','"+m_strBookName+"','"+m_strPress+"','"+m_strType+"','"+m_strOwner+"','" \
		+m_strBorrower+"','"+strBinDate+"','"+strBoutDate+"','"+"否','"+strReturnDate+"')";
	try{
		pConn->Execute(strQuery.AllocSysString(),NULL,adModeUnknown);
	}
	catch(_com_error &e)
	{
		DisplayAdoError(e);
		return;
	}
	InitData();
	UpdateData(FALSE);
	RefreshData();
}

void CBrrowPage::OnClickBorrowandboutListExist(NMHDR* pNMHDR, LRESULT* pResult) 
{
	if(m_exist.GetSelectedCount()==0)
	{
		m_return.EnableWindow(FALSE);
		m_ctrlSubmit.EnableWindow(TRUE);
		return;
	}
	CString str;
	_variant_t vt;
	COleDateTime odt;
	//CString strType,strReturn;
	int sel;
	sel=m_exist.GetSelectionMark();
	str=m_exist.GetItemText(sel,0);
	if(str=="借入")
		m_doType=0;
	else
		m_doType=1;
	str=m_exist.GetItemText(sel,1);
	if(str=="书籍杂志")
		m_nBigType=0;
	else if(str=="软件光盘")
		m_nBigType=1;
	else 
		m_nBigType=2;
	str=m_exist.GetItemText(sel,2);
	m_strBookName=str;
	str=m_exist.GetItemText(sel,3);
	m_strPress=str;
	str=m_exist.GetItemText(sel,4);
	m_strType=str;
	str=m_exist.GetItemText(sel,5);
	m_strOwner=str;
	str=m_exist.GetItemText(sel,6);
	m_strBorrower=str;
	if(m_doType==0)
	{
		str=m_exist.GetItemText(sel,7);
		vt=str;
		odt=vt;
		m_bInDate=odt;
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_BOUTDATE)->EnableWindow(FALSE);
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_BORROWDATE)->EnableWindow(TRUE);
	}
	else
	{
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_BOUTDATE)->EnableWindow(TRUE);
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_BORROWDATE)->EnableWindow(FALSE);
		str=m_exist.GetItemText(sel,8);
		vt=str;
		odt=vt;
		m_bOutDate=odt;
	}
	str=m_exist.GetItemText(sel,9);
	if(str=="是")
	{
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_RETURNDATE)->EnableWindow(TRUE);
		str=m_exist.GetItemText(sel,10);
		vt=str;
		odt=vt;
		m_returnDate=odt;
	}
	else
		GetDlgItem(IDC_BORROWANDBOUT_DATETIMEPICKER_RETURNDATE)->EnableWindow(TRUE);
	m_ctrlSubmit.EnableWindow(FALSE);
	m_return.EnableWindow(TRUE);
	UpdateData(FALSE);	
	*pResult = 0;
}

void CBrrowPage::OnKillfocusBorrowandboutListExist(NMHDR* pNMHDR, LRESULT* pResult) 
{
	//m_ctrlSubmit.EnableWindow(TRUE);
	//m_return.EnableWindow(FALSE);
	//InitData();
	//UpdateData(FALSE);
	*pResult = 0;
}