newbooksdlg.cpp

< Visual C+++SQL Server数据库开发与实例>>一书中的实例核心源程序提供了几个案例的编程源代码。

// NewBooksDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LibDBS.h"
#include "NewBooksDlg.h"
#include "BookSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CNewBooksDlg dialog


CNewBooksDlg::CNewBooksDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CNewBooksDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CNewBooksDlg)
	m_strWriter = _T("");
	m_lTotal = 0;
	m_strBookID = _T("");
	m_strBookName = _T("");
	m_strPress = _T("");
	m_dPrice = 0.0;
	m_lNow = 0;
	//}}AFX_DATA_INIT
}


void CNewBooksDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CNewBooksDlg)
	DDX_Control(pDX, IDC_LIST_RESULT, m_ctrList);
	DDX_Text(pDX, IDC_EDIT_WRITER, m_strWriter);
	DDX_Text(pDX, IDC_EDIT_TOTAL, m_lTotal);
	DDX_Text(pDX, IDC_EDIT_BOOK_NO, m_strBookID);
	DDX_Text(pDX, IDC_EDIT_BOOK_NAME, m_strBookName);
	DDX_Text(pDX, IDC_EDIT_PRESS, m_strPress);
	DDX_Text(pDX, IDC_EDIT_PRICE, m_dPrice);
	DDX_Text(pDX, IDC_EDIT_NOW, m_lNow);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CNewBooksDlg, CDialog)
	//{{AFX_MSG_MAP(CNewBooksDlg)
	ON_BN_CLICKED(IDC_BUTTON_IN, OnButtonIn)
	ON_BN_CLICKED(IDC_BUTTON_CHECK_BOOKS, OnButtonCheckBooks)
	ON_BN_CLICKED(IDC_BUTTON_CHECK_ALL, OnButtonCheckAll)
	ON_BN_CLICKED(IDC_BUTTON_BACK, OnButtonBack)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CNewBooksDlg message handlers
BOOL CNewBooksDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_ctrList.InsertColumn(0,"书号");
	m_ctrList.InsertColumn(1,"书名");
	m_ctrList.InsertColumn(2,"作者");
	m_ctrList.InsertColumn(3,"出版社");
	m_ctrList.InsertColumn(4,"定价");
	m_ctrList.InsertColumn(5,"入库日期");
	m_ctrList.InsertColumn(6,"存储总量");
	m_ctrList.InsertColumn(7,"现存数量");

	RECT rect;
	m_ctrList.GetWindowRect(&rect);
	int Width=rect.right-rect.left;
	m_ctrList.SetColumnWidth(0,Width/8);
	m_ctrList.SetColumnWidth(1,Width/8);
	m_ctrList.SetColumnWidth(2,Width/8);
	m_ctrList.SetColumnWidth(3,Width/8);
	m_ctrList.SetColumnWidth(4,Width/8);
	m_ctrList.SetColumnWidth(5,Width/8);
	m_ctrList.SetColumnWidth(6,Width/8);
	m_ctrList.SetColumnWidth(7,Width/8);
	m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT);

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

void CNewBooksDlg::OnButtonIn() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strBookID.Compare("")==0)
	{
		MessageBox("请正确填写要求的数据","新书入库登记");
		return;
	}
	
	if(!m_database.IsOpen())
	{
			
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("Cannot access database!","新书登记");
			return;
		}
	}
	CBookSet *m_pset=new CBookSet(&m_database);
	//判断书库中是否有该书，进行相应操作
	//有，把数量加到库中
	CString strSQL;
	strSQL.Format("select * from Book_Info where Book_ID='%s'",m_strBookID);
	m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pset->GetRecordCount()!=0)
	{
		
		m_pset->Edit();
		m_pset->m_Total_Amount=m_pset->m_Total_Amount+m_lTotal;
		m_pset->m_Now_Amount=m_pset->m_Now_Amount+m_lNow;
		m_pset->Update();
		m_pset->Requery();
		m_pset->Close();
		m_database.Close();
		MessageBox("Adding new books successfully!","新书入库登记");
		OnButtonCheckBooks();
		return;
	}
	m_pset->Close();
	if(m_strBookID==""||m_strBookName==""||m_strWriter==""
		||m_strPress==""||m_dPrice==0||m_lTotal==0
		||m_lNow==0)
	{
		MessageBox("请正确填写要求的数据！","新书登记入库");
		m_database.Close();
		return;
	}
	strSQL.Format("select * from Book_Info");
	m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	//if(m_pset->GetRecordCount()==0)
	//{
		//MessageBox("There are not any book information!","新书登记");
	//}
	m_pset->AddNew();
	m_pset->SetFieldNull(&(m_pset->m_Book_ID),FALSE);
	m_pset->m_Book_ID=m_strBookID;

	m_pset->SetFieldNull(&(m_pset->m_Book_Name),FALSE);
	m_pset->m_Book_Name=m_strBookName;

	m_pset->SetFieldNull(&(m_pset->m_Writer),FALSE);
	m_pset->m_Writer=m_strWriter;

	m_pset->SetFieldNull(&(m_pset->m_Press),FALSE);
	m_pset->m_Press=m_strPress;

	m_pset->SetFieldNull(&(m_pset->m_Price),FALSE);
	m_pset->m_Price=m_dPrice;

	m_pset->SetFieldNull(&(m_pset->m_Total_Amount),FALSE);
	m_pset->m_Total_Amount=m_lTotal;

	m_pset->SetFieldNull(&(m_pset->m_Now_Amount),FALSE);
	m_pset->m_Now_Amount=m_lNow;

	CTime curTime=CTime::GetCurrentTime();
	m_pset->SetFieldNull(&(m_pset->m_InLibrary_Date),FALSE);
	m_pset->m_InLibrary_Date=curTime;

	m_pset->Update();
	m_pset->Requery();
	
	m_pset->Close();
	m_database.Close();
	MessageBox("Adding new books successfully!","新书入库登记");
	
	OnButtonCheckBooks();
	
	m_strBookID.Empty();
	m_strBookName.Empty();
	m_strPress.Empty();
	m_strWriter.Empty();
	m_lNow=0;
	m_lTotal=0;
	m_dPrice=0.0;
	UpdateData(FALSE);
	return;
	
}

void CNewBooksDlg::OnButtonCheckBooks() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	
	if(m_strBookID=="")
	{
		MessageBox("请正确填写信息，（书号?）","新书登记");
		return;
	}
	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("Cannot access the database!","新书登记");
			return;
		}
	}
	
	CBookSet *m_pset=new CBookSet(&m_database);
	CString strSQL;
	strSQL.Format("select * from Book_Info where Book_ID='%s'",m_strBookID);
	m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pset->GetRecordCount()==0)
	{
		MessageBox("No this book in the database!","新书登记");
		m_database.Close();
		return;
	}
	
	//处理表格
	m_ctrList.DeleteAllItems();
	m_pset->MoveFirst();
	char buf[50];
	CDBVariant varValue;
	int i=0;
	CString strBookName;
	while(!m_pset->IsEOF())
	{
	
		m_ctrList.InsertItem(i,buf);
		m_ctrList.SetItemText(i,0,m_strBookID);
		m_pset->GetFieldValue(1,strBookName);
		
		m_ctrList.SetItemText(i,1,strBookName);
		m_pset->GetFieldValue(2,strBookName);
		
		m_ctrList.SetItemText(i,2,strBookName);
		m_pset->GetFieldValue(3,strBookName);
		
		m_ctrList.SetItemText(i,3,strBookName);
		m_pset->GetFieldValue(4,varValue);
		sprintf(buf,"%.2f",varValue.m_dblVal);
		m_ctrList.SetItemText(i,4,buf);
		m_pset->GetFieldValue(5,varValue);
		
		sprintf(buf,"%d-%d-%d",varValue.m_pdate->year,varValue.m_pdate->month,
			varValue.m_pdate->day);
		
		m_ctrList.SetItemText(i,5,buf);
		m_pset->GetFieldValue(6,varValue);
		sprintf(buf,"%d",varValue.m_lVal);
		m_ctrList.SetItemText(i,6,buf);
		
		m_pset->GetFieldValue(7,varValue);
		sprintf(buf,"%d",varValue.m_lVal);
		m_ctrList.SetItemText(i,7,buf);
		i++;
		m_pset->MoveNext();
		UpdateData(FALSE);
	}

	m_pset->Close();
	m_database.Close();
	
}

void CNewBooksDlg::OnButtonCheckAll() 
{
	// TODO: Add your control notification handler code here
	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("Cannot access the database!","新书登记");
			return;
		}
	}
	

	//打开数据库的连接,并且捕获异常
	CBookSet *m_pset=new CBookSet(&m_database);

	CString strSQL;
	strSQL.Format("select * from Book_Info");
	TRY{
		m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	
	}
	CATCH(CDBException,ex)
	{	AfxMessageBox("OK1");
		AfxMessageBox (ex->m_strError);
		AfxMessageBox (ex->m_strStateNativeOrigin);		
	}
	AND_CATCH(CException,e)
	{
		TCHAR szError[100];
		e->GetErrorMessage(szError,100);
		AfxMessageBox (szError);
	}
	END_CATCH
	if(m_pset->GetRecordCount()==0)
	{
		MessageBox("书库中没有任何书籍信息！","新书登记");
		m_database.Close();
		return;
	}
	
	//处理表格
	m_ctrList.DeleteAllItems();
	m_pset->MoveFirst();

	char buf[50];
	CDBVariant varValue;
	int i=0;
	CString strBookName;
	while(!m_pset->IsEOF())

	{
		int temp=0;
		m_ctrList.InsertItem(i,buf);
		m_pset->GetFieldValue((short)0,m_strBookID);
	
		
		m_ctrList.SetItemText(i,0,m_strBookID);

		m_pset->GetFieldValue(1,strBookName);
		m_ctrList.SetItemText(i,1,strBookName);
		m_pset->GetFieldValue(2,strBookName);
		m_ctrList.SetItemText(i,2,strBookName);
		m_pset->GetFieldValue(3,strBookName);
		m_ctrList.SetItemText(i,3,strBookName);
		m_pset->GetFieldValue(4,varValue);
		sprintf(buf,"%.2f",varValue.m_dblVal);
		m_ctrList.SetItemText(i,4,buf);
		m_pset->GetFieldValue(5,varValue);
		sprintf(buf,"%d-%d-%d",varValue.m_pdate->year,varValue.m_pdate->month,
			varValue.m_pdate->day);
		m_ctrList.SetItemText(i,5,buf);
		m_pset->GetFieldValue(6,varValue);
		sprintf(buf,"%d",varValue.m_lVal);
		m_ctrList.SetItemText(i,6,buf);
		
		m_pset->GetFieldValue(7,varValue);
		sprintf(buf,"%d",varValue.m_lVal);
		m_ctrList.SetItemText(i,7,buf);
		i++;
		m_pset->MoveNext();
		UpdateData(FALSE);
	}
	m_pset->Close();
	m_database.Close();
	m_strBookID.Empty();
	UpdateData(FALSE);
	
}

void CNewBooksDlg::OnButtonBack() 
{
	// TODO: Add your control notification handler code here
	if(m_database.IsOpen())
		m_database.Close();
	OnOK();
	
}
void CNewBooksDlg::OnClose() 
{
	OnButtonBack();
}