// BkLookupDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookManager.h"
#include "BkLookupDlg.h"
#include "BookIMSet.h"
#include "GetbookDlg.h"
#include "CountmoneyDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBkLookupDlg dialog


CBkLookupDlg::CBkLookupDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBkLookupDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBkLookupDlg)
	m_str_lookupid = _T("");
	//}}AFX_DATA_INIT
}


void CBkLookupDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBkLookupDlg)
	DDX_Control(pDX, IDC_Getbook, m_bnt_Getbook);
	DDX_Control(pDX, IDC_Countmoney, m_bnt_Countmoney);
	DDX_Control(pDX, IDC_Begin_lookup, m_bnt_beginlookup);
	DDX_Control(pDX, IDC_Lookup_id, m_ctr_lookupid);
	DDX_Control(pDX, IDC_BkLookuplist, m_BkLookuplist);
	DDX_Text(pDX, IDC_Lookup_id, m_str_lookupid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBkLookupDlg, CDialog)
	//{{AFX_MSG_MAP(CBkLookupDlg)
	ON_BN_CLICKED(IDC_Begin_lookup, OnBeginlookup)
	ON_BN_CLICKED(IDC_Lookupexit, OnLookupexit)
	ON_BN_CLICKED(IDC_Getbook, OnGetbook)
	ON_BN_CLICKED(IDC_Countmoney, OnCountmoney)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBkLookupDlg message handlers

BOOL CBkLookupDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_BkLookuplist.InsertColumn(0,"書籍條碼");
	m_BkLookuplist.InsertColumn(1,"書籍名稱");
	m_BkLookuplist.InsertColumn(2,"作者姓名");
	m_BkLookuplist.InsertColumn(3,"出版社");
    m_BkLookuplist.InsertColumn(4,"單價");
	m_BkLookuplist.InsertColumn(5,"庫存量");
	m_BkLookuplist.InsertColumn(6,"開課單位");
	m_BkLookuplist.InsertColumn(7,"版次");
	m_BkLookuplist.InsertColumn(8,"備注說明");
	m_BkLookuplist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
    m_BkLookuplist.SetColumnWidth(0,80);
    m_BkLookuplist.SetColumnWidth(1,140);
	m_BkLookuplist.SetColumnWidth(2,100);
	m_BkLookuplist.SetColumnWidth(3,150);
	m_BkLookuplist.SetColumnWidth(4,100);
	m_BkLookuplist.SetColumnWidth(5,80);
	m_BkLookuplist.SetColumnWidth(6,150);
    m_BkLookuplist.SetColumnWidth(7,80);
	m_BkLookuplist.SetColumnWidth(8,500);
	m_ctr_lookupid.SetFocus();
	m_bnt_Getbook.EnableWindow(FALSE);


	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CBkLookupDlg::OnBeginlookup() 
{
	// TODO: Add your control notification handler code here
	m_bnt_beginlookup.SetWindowText("查詢");
	UpdateData(TRUE);
	if(m_str_lookupid.IsEmpty())
	{
	   MessageBox("請輸入你要查詢的書籍條碼！");
	   m_ctr_lookupid.SetFocus();
	}
	else{
	CString strSQL;
    CBookIMSet recordset;
	strSQL.Format("select * from bookIM where book_id='%s'",m_str_lookupid);
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
	   MessageBox("打開數據庫失敗！","數據庫錯誤",MB_OK);
	   return;
	}
	else if(recordset.GetRecordCount()==0)
	{
	   MessageBox("沒有找到你要查詢的記錄！");
	   return;
	   m_str_lookupid.Empty();
	   UpdateData(FALSE);
	   m_ctr_lookupid.SetFocus();
	}
	else
	{
	   m_BkLookuplist.DeleteAllItems();
	   m_BkLookuplist.SetRedraw(FALSE);
       m_BkLookuplist.InsertItem(0," ");
	   m_BkLookuplist.SetItemText(0,0,recordset.m_book_id);
	   m_BkLookuplist.SetItemText(0,1,recordset.m_book_name);
	   m_BkLookuplist.SetItemText(0,2,recordset.m_author);
	   m_BkLookuplist.SetItemText(0,3,recordset.m_publishment);
	   CString str1;
	   CString str2;
       str1.Format("%f",recordset.m_price);
	   str2.Format("%d",recordset.m_number);
	   m_BkLookuplist.SetItemText(0,4,str1);
	   m_BkLookuplist.SetItemText(0,5,str2);
	   m_BkLookuplist.SetItemText(0,6,recordset.m_department);
	   m_BkLookuplist.SetItemText(0,7,recordset.m_version);
	   m_BkLookuplist.SetItemText(0,8,recordset.m_note);
	   m_BkLookuplist.SetRedraw(TRUE);
	}
	recordset.Close();
	m_bnt_Getbook.EnableWindow(TRUE);
	}
	
	
}

void CBkLookupDlg::OnLookupexit() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();
	
}



void CBkLookupDlg::OnGetbook() 
{
	// TODO: Add your control notification handler code here
	if(m_str_lookupid.IsEmpty())
	{
	   MessageBox("請先輸入書籍條碼查看書庫！");
	   m_ctr_lookupid.SetFocus();
	}
	else{
       CBookManagerApp* app=(CBookManagerApp*)::AfxGetApp();
	app->temp=m_str_lookupid;
	CGetbookDlg dlg;
	dlg.DoModal();     	
	}
	
	
}

void CBkLookupDlg::OnCountmoney() 
{
	// TODO: Add your control notification handler code here
	CCountmoneyDlg dlg;
	dlg.DoModal();
	
}