furdlg.cpp

这是一个实验室的图书管理系统

// FurDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Lab.h"
#include "FurDlg.h"
#include "FurSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CFurDlg dialog


CFurDlg::CFurDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CFurDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CFurDlg)
	m_lTotal = 0;
	m_strFurID = _T("");
	m_strFurModel = _T("");
	m_strFurName = _T("");
	m_lNow = 0;
	//}}AFX_DATA_INIT
}


void CFurDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CFurDlg)
	DDX_Control(pDX, IDC_LIST, m_ctrList);
	DDX_Text(pDX, IDC_EDIT_ALL, m_lTotal);
	DDX_Text(pDX, IDC_EDIT_ID, m_strFurID);
	DDX_Text(pDX, IDC_EDIT_MODEL, m_strFurModel);
	DDX_Text(pDX, IDC_EDIT_NAME, m_strFurName);
	DDX_Text(pDX, IDC_EDIT_NOW, m_lNow);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CFurDlg, CDialog)
	//{{AFX_MSG_MAP(CFurDlg)
	ON_BN_CLICKED(IDC_BTN_SEE, OnBtnSee)
	ON_BN_CLICKED(IDC_BTN_CHECK, OnBtnCheck)
	ON_BN_CLICKED(IDC_BTN_ADD, OnBtnAdd)
	ON_BN_CLICKED(IDC_BTN_DEL, OnBtnDel)
	ON_BN_CLICKED(IDC_BTN_EXIT, OnBtnExit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CFurDlg message handlers

void CFurDlg::OnBtnSee() 
{
	// TODO: Add your control notification handler code here
	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Lab")))
		{
			MessageBox("Cannot access the database!","新家具登记");
			return;
		}
	}
	

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

	CString strSQL;
	strSQL.Format("select * from fur_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[200];
	CDBVariant varValue;
	int i=0;
	CString strFurName,strFurModel;
	while(!m_pset->IsEOF())

	{
		int temp=0;
		m_ctrList.InsertItem(i,buf);
		m_pset->GetFieldValue((short)0,m_strFurID);
		m_ctrList.SetItemText(i,0,m_strFurID);
		m_pset->GetFieldValue(1,strFurName);
		m_ctrList.SetItemText(i,1,strFurName);
		m_pset->GetFieldValue(2,strFurModel);
		m_ctrList.SetItemText(i,2,strFurModel);
	
		m_pset->GetFieldValue(3,varValue);
		sprintf(buf,"%d",varValue.m_lVal);
		m_ctrList.SetItemText(i,3,buf);
		
		m_pset->GetFieldValue(4,varValue);
		sprintf(buf,"%d",varValue.m_lVal);
		m_ctrList.SetItemText(i,4,buf);
		i++;
		m_pset->MoveNext();
		UpdateData(FALSE);
	}
	m_pset->Close();
	m_database.Close();
	m_strFurID.Empty();
	UpdateData(FALSE);
}

BOOL CFurDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	
	m_ctrList.InsertColumn(0,"家具号");
	m_ctrList.InsertColumn(1,"家具名");
	m_ctrList.InsertColumn(2,"型号");
	m_ctrList.InsertColumn(3,"现存数量");
	m_ctrList.InsertColumn(4,"存储总量");

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

void CFurDlg::OnBtnCheck() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	
	if(m_strFurID=="")
	{
		MessageBox("请正确填写信息，（家具号?）","新家具登记");
		return;
	}
	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Lab")))
		{
			MessageBox("Cannot access the database!","新家具登记");
			return;
		}
	}
	
	CFurSet *m_pset=new CFurSet(&m_database);
	CString strSQL;
	strSQL.Format("select * from fur_info where Fur_Id='%s'",m_strFurID);
	m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pset->GetRecordCount()==0)
	{
		MessageBox("No this furniture in the database!","新家具登记");
		m_database.Close();
		return;
	}
	
	//处理表格
	m_ctrList.DeleteAllItems();
	m_pset->MoveFirst();
	char buf[100];
	CDBVariant varValue;
	int i=0;
	CString strFurName,strFurModel;
	while(!m_pset->IsEOF())
	{
		m_ctrList.InsertItem(i,buf);
		m_pset->GetFieldValue((short)0,m_strFurID);
		m_ctrList.SetItemText(i,0,m_strFurID);

		m_pset->GetFieldValue(1,strFurName);
		m_ctrList.SetItemText(i,1,strFurName);

		m_pset->GetFieldValue(2,strFurModel);
		m_ctrList.SetItemText(i,2,strFurModel);

		m_pset->GetFieldValue(3,varValue);
		sprintf(buf,"%d",varValue.m_lVal);
		m_ctrList.SetItemText(i,3,buf);
		
		m_pset->GetFieldValue(4,varValue);
		sprintf(buf,"%d",varValue.m_lVal);
		m_ctrList.SetItemText(i,4,buf);
		i++;
		
		m_pset->MoveNext();
		UpdateData(FALSE);
	}

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

void CFurDlg::OnBtnAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strFurID.Compare("")==0)
	{
		MessageBox("请正确填写要求的数据","新家具入库登记");
		return;
	}
	
	if(!m_database.IsOpen())
	{
			
		if(!m_database.Open(_T("Lab")))
		{
			MessageBox("Cannot access database!","新家具登记");
			return;
		}
	}
	CFurSet *m_pset=new CFurSet(&m_database);
	//判断书库中是否有该家具，进行相应操作
	//有，把数量加到库中
	CString strSQL;
	strSQL.Format("select * from fur_info where Fur_ID='%s'",m_strFurID);
	m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pset->GetRecordCount()!=0)
	{
		
		m_pset->Edit();
		m_pset->m_AllCount=m_pset->m_AllCount+m_lTotal;
		m_pset->m_NowCount=m_pset->m_NowCount+m_lNow;
		m_pset->Update();
		m_pset->Requery();
		m_pset->Close();
		m_database.Close();
		MessageBox("Adding new furnitures successfully!","新家具入库登记");
		return;
	}
	m_pset->Close();

	if(m_strFurID==""||m_strFurName==""||m_strFurModel==""
		||m_lTotal==0||m_lNow==0)
	{
		MessageBox("请正确填写要求的数据！","新家具登记入库");
		m_database.Close();
		return;
	}
	strSQL.Format("select * from fur_info");
	m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pset->GetRecordCount()==0)
	{
		MessageBox("There are not any furniture information!","新家具登记");
	}
	m_pset->AddNew();
	m_pset->SetFieldNull(&(m_pset->m_Fur_Id),FALSE);
	m_pset->m_Fur_Id=m_strFurID;

	m_pset->SetFieldNull(&(m_pset->m_FurName),FALSE);
	m_pset->m_FurName=m_strFurName;

	m_pset->SetFieldNull(&(m_pset->m_Model),FALSE);
	m_pset->m_Model=m_strFurModel;

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

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

	m_pset->Update();
	m_pset->Requery();
	
	m_pset->Close();
	m_database.Close();
	MessageBox("Adding new furnitures successfully!","新家具入库登记");
	
	OnBtnCheck();
	
	m_strFurID.Empty();
	m_strFurName.Empty();
	m_strFurModel.Empty();
	m_lNow=0;
	m_lTotal=0;
	UpdateData(FALSE);
	return;
}

void CFurDlg::OnBtnDel() 
{
	// TODO: Add your control notification handler code here
	if (m_ctrList.GetSelectionMark()!=-1)
	{
		if (MessageBox("确实要删除数据吗?","提示",MB_YESNO|MB_ICONINFORMATION)==IDYES)
		{
			int i = m_ctrList.GetSelectionMark();
			CString c_strFurID = m_ctrList.GetItemText(i,0);
			CFurSet *m_pset=new CFurSet(&m_database);
			CString strSQL;
			strSQL.Format("select * from fur_info where Fur_Id='%s'",c_strFurID);
			m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
			m_pset->Delete();
			m_pset->MoveNext();

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

			MessageBox("Deleting furniture successfully!","家具删除");
	
			OnBtnSee();
		}
	}
	else
		MessageBox("请选择欲删除的信息.","提示",MB_OK|MB_ICONINFORMATION);
}

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