clerkdlg.cpp

此源程序是图书馆管理系统

// ClerkDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "ClerkDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CClerkDlg dialog


CClerkDlg::CClerkDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CClerkDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CClerkDlg)
	m_ClerkId = _T("");
	m_ClerkName = _T("");
	m_IdCard = _T("");
	m_Officer = _T("");
	//}}AFX_DATA_INIT
}


void CClerkDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CClerkDlg)
	DDX_Control(pDX, IDC_COMBO1, m_OfficerC);
	DDX_Text(pDX, IDC_EDIT1, m_ClerkId);
	DDX_Text(pDX, IDC_EDIT2, m_ClerkName);
	DDX_Text(pDX, IDC_EDIT3, m_IdCard);
	DDX_CBString(pDX, IDC_COMBO1, m_Officer);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CClerkDlg, CDialog)
	//{{AFX_MSG_MAP(CClerkDlg)
	ON_BN_CLICKED(IDC_FIRST, OnFirst)
	ON_BN_CLICKED(IDC_NEXT, OnNext)
	ON_BN_CLICKED(IDC_FORWARD, OnForward)
	ON_BN_CLICKED(IDC_LAST, OnLast)
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	ON_BN_CLICKED(IDC_EDIT, OnEdit)
	ON_BN_CLICKED(IDC_SAVE, OnSave)
	ON_BN_CLICKED(IDC_DEL, OnDel)
	ON_WM_CLOSE()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CClerkDlg message handlers

BOOL CClerkDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CString Sqlstr;
	Sqlstr="SELECT * FROM CLERK";
	if(!clkSet.Open(AFX_DB_USE_DEFAULT_TYPE,Sqlstr))
	{
		AfxMessageBox("clerk表打开失败");
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CClerkDlg::OnFirst() 
{
	// TODO: Add your control notification handler code here
	if(!clkSet.IsBOF())
	{
		clkSet.MoveFirst();
		DisplayRecord();
	}
	
}
bool CClerkDlg::DisplayRecord()
{
	if(clkSet.IsBOF()&&clkSet.IsEOF())
	{
		m_ClerkId="";
		m_ClerkName="";
		m_IdCard="";
		m_Officer="";
	}
	else
	{
		if(clkSet.IsBOF())
		{
			clkSet.MoveNext();
		}
		else
		{
			if(clkSet.IsEOF())
			{
				clkSet.MovePrev();
			}
		}
	}
	m_ClerkId=clkSet.m_CLERK_ID;
	m_ClerkName=clkSet.m_NAME;
	m_IdCard=clkSet.m_ID_CARD;
	m_Officer=clkSet.m_OFFICIER;
	UpdateData(false);
	return true;

}

void CClerkDlg::OnNext() 
{
	// TODO: Add your control notification handler code here
	if(!clkSet.IsBOF())
	{
		clkSet.MoveNext();
		DisplayRecord();
	}
}

void CClerkDlg::OnForward() 
{
	// TODO: Add your control notification handler code here
	if(!clkSet.IsEOF())
	{
		clkSet.MovePrev();
		DisplayRecord();
	}
	
}

void CClerkDlg::OnLast() 
{
	// TODO: Add your control notification handler code here
	if(!clkSet.IsEOF())
	{
		clkSet.MoveLast();
		DisplayRecord();
	}
	
}

void CClerkDlg::OnAdd() 
{
	// TODO: Add your control notification handler code here
	m_ClerkId="";
	m_ClerkName="";
	m_IdCard="";
	m_Officer="";
	UpdateData(false);
	m_bAdd=true;

	
}

void CClerkDlg::OnEdit() 
{
	// TODO: Add your control notification handler code here
	m_bEdit=true;
	
}

void CClerkDlg::OnSave() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	if(m_ClerkId.IsEmpty()||m_ClerkName.IsEmpty())
	{
		AfxMessageBox("请输入相应数据");
	}
	if(m_bAdd)
	{
		clkSet.AddNew();
	}
	else
	{
		clkSet.Edit();
	}
	clkSet.m_CLERK_ID=m_ClerkId;
	clkSet.m_NAME=m_ClerkName;
	clkSet.m_OFFICIER=m_Officer;
	clkSet.m_ID_CARD=m_IdCard;
	clkSet.m_PASSWORD="123";
	clkSet.Update();
	clkSet.Requery();
	m_bAdd=false;
	m_bEdit=false;
	DisplayRecord();
	
}

void CClerkDlg::OnDel() 
{
	// TODO: Add your control notification handler code here
	clkSet.Delete();
	clkSet.Requery();
	DisplayRecord();
	
}

void CClerkDlg::OnClose() 
{
	// TODO: Add your message handler code here and/or call default
	if(clkSet.IsOpen())
	{
		clkSet.Close();
	}
	
	CDialog::OnClose();
}