dbviewdlg.cpp

VC数据库通用模块及典型系统开发配套代码,包含完整例子,各模块在开发数据库的时候可以直接用

// DBViewDlg.cpp : implementation file
//

#include "stdafx.h"
#include "DBView.h"
#include "DBViewDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDBViewDlg dialog

CDBViewDlg::CDBViewDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDBViewDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDBViewDlg)
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CDBViewDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDBViewDlg)
	DDX_Control(pDX, IDC_BTN_UPDATE, m_btnUpdate);
	DDX_Control(pDX, IDC_BTN_PREV, m_btnPrev);
	DDX_Control(pDX, IDC_BTN_NEXT, m_btnNext);
	DDX_Control(pDX, IDC_BTN_LAST, m_btnLast);
	DDX_Control(pDX, IDC_BTN_INSERT, m_btnInsert);
	DDX_Control(pDX, IDC_BTN_FIRST, m_btnFirst);
	DDX_Control(pDX, IDC_BTN_DELETE, m_btnDelete);
	DDX_Control(pDX, IDC_EDIT_POSTCODE, m_edtPostCode);
	DDX_Control(pDX, IDC_EDIT_NOTE, m_edtNote);
	DDX_Control(pDX, IDC_EDIT_NATIONALITY, m_edtNationality);
	DDX_Control(pDX, IDC_EDIT_NAME, m_edtName);
	DDX_Control(pDX, IDC_EDIT_AGE, m_edtAge);
	DDX_Control(pDX, IDC_EDIT_ADDRESS, m_edtAddress);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CDBViewDlg, CDialog)
	//{{AFX_MSG_MAP(CDBViewDlg)
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	ON_BN_CLICKED(IDC_BTN_FIRST, OnBtnFirst)
	ON_BN_CLICKED(IDC_BTN_PREV, OnBtnPrev)
	ON_BN_CLICKED(IDC_BTN_NEXT, OnBtnNext)
	ON_BN_CLICKED(IDC_BTN_LAST, OnBtnLast)
	ON_BN_CLICKED(IDC_BTN_INSERT, OnBtnInsert)
	ON_BN_CLICKED(IDC_BTN_DELETE, OnBtnDelete)
	ON_WM_SHOWWINDOW()
	ON_EN_CHANGE(IDC_EDIT_ADDRESS, OnChangeEditAddress)
	ON_EN_CHANGE(IDC_EDIT_AGE, OnChangeEditAge)
	ON_EN_CHANGE(IDC_EDIT_NAME, OnChangeEditName)
	ON_EN_CHANGE(IDC_EDIT_NATIONALITY, OnChangeEditNationality)
	ON_EN_CHANGE(IDC_EDIT_NOTE, OnChangeEditNote)
	ON_EN_CHANGE(IDC_EDIT_POSTCODE, OnChangeEditPostcode)
	ON_BN_CLICKED(IDC_RADIO_FEMALE, OnRadioFemale)
	ON_BN_CLICKED(IDC_RADIO_MALE, OnRadioMale)
	ON_WM_DESTROY()
	ON_BN_CLICKED(IDC_BTN_UPDATE, OnBtnUpdate)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDBViewDlg message handlers

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

	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	
	//初始化m_ds对象的数据
	m_ds.InitData();

	return TRUE;  // return TRUE  unless you set the focus to a control
}

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.

void CDBViewDlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // device context for painting

		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// Draw the icon
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

// The system calls this to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CDBViewDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}

void CDBViewDlg::OnBtnFirst() 
{
	//移动到第一条记录
	m_ds.MoveFirst();
	//装载界面上的数据
	LoadData();
	//刷新界面显示
	RefreshView();
}

void CDBViewDlg::LoadData()
{
	//家庭住址
	m_edtAddress.SetWindowText(m_ds.GetAsString("ADDRESS")); 
	//年龄
	m_edtAge.SetWindowText(m_ds.GetAsString("AGE"));
	//姓名
	m_edtName.SetWindowText(m_ds.GetAsString("NAME"));
	//民族
	m_edtNationality.SetWindowText(m_ds.GetAsString("NATIONALITY"));
	//备注
	m_edtNote.SetWindowText(m_ds.GetAsString("NOTE"));
	//邮政编码
	m_edtPostCode.SetWindowText(m_ds.GetAsString("POSTCODE"));
	
	//如果性别为1，则单选按钮“女”将被选中
	if (m_ds.GetAsInteger("GENDER") == 1) 
	{
		((CButton *)GetDlgItem(IDC_RADIO_FEMALE))->SetCheck(BST_CHECKED);
		((CButton *)GetDlgItem(IDC_RADIO_MALE))->SetCheck(BST_UNCHECKED);	
	}
	//如果性别不为1，则单选按钮“男”将被选中
	else 
	{
		((CButton *)GetDlgItem(IDC_RADIO_MALE))->SetCheck(BST_CHECKED);
		((CButton *)GetDlgItem(IDC_RADIO_FEMALE))->SetCheck(BST_UNCHECKED);
	}
}

void CDBViewDlg::OnBtnPrev() 
{
	//移动到上一条记录
	m_ds.MovePrev();
	//装载当前记录的数据
	LoadData();
	//刷新界面显示
	RefreshView();
}

void CDBViewDlg::OnBtnNext() 
{
	//移动到下一条记录
	m_ds.MoveNext();
	//装载当前记录的数据
	LoadData();	
	//刷新界面显示
	RefreshView();
}

void CDBViewDlg::OnBtnLast() 
{
	//移动到最后一条记录
	m_ds.MoveLast();
	//装载当前记录的数据
	LoadData();	
	//刷新界面显示
	RefreshView();
}

void CDBViewDlg::OnBtnInsert() 
{
	//新增一条记录
	m_ds.New();
	//装载当前记录的数据
	LoadData();
	//刷新界面显示
	RefreshView();
}

void CDBViewDlg::OnBtnDelete() 
{
	m_ds.Delete();
	m_ds.MoveNext();
	if (!m_ds.IsBOF() && m_ds.IsEOF())
	{
		m_ds.MovePrev();
	};
	LoadData();
	RefreshView();
}

void CDBViewDlg::OnShowWindow(BOOL bShow, UINT nStatus) 
{
	CDialog::OnShowWindow(bShow, nStatus);
	LoadData();
	RefreshView();
}

void CDBViewDlg::RefreshView()
{
	//如果当前记录指针处于数据集第一条记录之前或最后一条记录之后，
	//编辑框控件和单选按钮控件不可用
	if (m_ds.IsBOF() || m_ds.IsEOF())
	{
		m_edtAddress.EnableWindow(FALSE);
		m_edtAge.EnableWindow(FALSE);
		m_edtName.EnableWindow(FALSE);
		m_edtNationality.EnableWindow(FALSE);
		m_edtNote.EnableWindow(FALSE);
		m_edtPostCode.EnableWindow(FALSE);
		((CButton *)GetDlgItem(IDC_RADIO_MALE))->EnableWindow(FALSE);
		((CButton *)GetDlgItem(IDC_RADIO_FEMALE))->EnableWindow(FALSE);		
	}
	//否则编辑框控件和单选按钮控件可用
	else
	{
		m_edtAddress.EnableWindow(TRUE);
		m_edtAge.EnableWindow(TRUE);
		m_edtName.EnableWindow(TRUE);
		m_edtNationality.EnableWindow(TRUE);
		m_edtNote.EnableWindow(TRUE);
		m_edtPostCode.EnableWindow(TRUE);
		((CButton *)GetDlgItem(IDC_RADIO_MALE))->EnableWindow(TRUE);
		((CButton *)GetDlgItem(IDC_RADIO_FEMALE))->EnableWindow(TRUE);	
	}

	//首先设置各控件均可用
	m_btnDelete.EnableWindow(TRUE);
	m_btnFirst.EnableWindow(TRUE);
	m_btnInsert.EnableWindow(TRUE);
	m_btnLast.EnableWindow(TRUE);
	m_btnNext.EnableWindow(TRUE);
	m_btnPrev.EnableWindow(TRUE);
	m_btnUpdate.EnableWindow(TRUE);

	//如果当前记录集处于第一条记录，“上一条”和“第一条”两个按钮不可用
	if (m_ds.IsFirst())
	{
		m_btnFirst.EnableWindow(FALSE);
		m_btnPrev.EnableWindow(FALSE);
	}

	//如果当前记录集处于最后一条记录，“下一条”和“最后一条”两个按钮不可用
	if (m_ds.IsLast())
	{
		m_btnLast.EnableWindow(FALSE);
		m_btnNext.EnableWindow(FALSE);
	}

	//如果记录集中没有数据，“删除”按钮不可用
	if (m_ds.IsEOF() && m_ds.IsBOF())
		m_btnDelete.EnableWindow(FALSE);

	//刷新“更新”按钮
	RefreshUpdateBtn();
}

BOOL CDBViewDlg::IsNeedUpdate()
{
	CString strTemp;

	//判断家庭住址
	m_edtAddress.GetWindowText(strTemp);
	if (strTemp != m_ds.GetAsString("ADDRESS"))
		return TRUE;

	//判断年龄
	m_edtAge.GetWindowText(strTemp);
	if (strTemp != m_ds.GetAsString("AGE"))
		return TRUE;

	//判断姓名
	m_edtName.GetWindowText(strTemp);
	if (strTemp != m_ds.GetAsString("NAME"))
		return TRUE;

	//判断民族
	m_edtNationality.GetWindowText(strTemp);
	if (strTemp != m_ds.GetAsString("NATIONALITY"))
		return TRUE;

	//判断备注
	m_edtNote.GetWindowText(strTemp);
	if (strTemp != m_ds.GetAsString("NOTE"))
		return TRUE;

	//判断邮政编码
	m_edtPostCode.GetWindowText(strTemp);
	if (strTemp != m_ds.GetAsString("POSTCODE"))
		return TRUE;

	//判断性别
	if (((m_ds.GetAsInteger("GENDER") == 1) && (((CButton *)GetDlgItem(IDC_RADIO_MALE))->GetCheck() == BST_CHECKED)) 
		|| ((m_ds.GetAsInteger("GENDER") != 1) && (((CButton *)GetDlgItem(IDC_RADIO_FEMALE))->GetCheck() == BST_CHECKED))) 
			return TRUE;

	return FALSE;

}

void CDBViewDlg::ClearAll()
{
	m_edtAddress.SetWindowText(""); 
	m_edtAge.SetWindowText("");
	m_edtName.SetWindowText("");
	m_edtNationality.SetWindowText("");
	m_edtNote.SetWindowText("");
	m_edtPostCode.SetWindowText("");
	((CButton *)GetDlgItem(IDC_RADIO_MALE))->SetCheck(BST_CHECKED);
	((CButton *)GetDlgItem(IDC_RADIO_FEMALE))->SetCheck(BST_UNCHECKED);
}

void CDBViewDlg::RefreshUpdateBtn()
{
	//存在更改，设置“更新”按钮可用
	if (IsNeedUpdate())
	{
		m_btnUpdate.EnableWindow(TRUE);
	}
	//不存在更改，设置“更新”按钮不可用
	else 
	{
		m_btnUpdate.EnableWindow(FALSE);
	}
}

void CDBViewDlg::OnChangeEditAddress() 
{
	RefreshUpdateBtn();
}

void CDBViewDlg::OnChangeEditAge() 
{
	RefreshUpdateBtn();
}

void CDBViewDlg::OnChangeEditName() 
{
	RefreshUpdateBtn();
}

void CDBViewDlg::OnChangeEditNationality() 
{
	RefreshUpdateBtn();
}

void CDBViewDlg::OnChangeEditNote() 
{
	RefreshUpdateBtn();
}

void CDBViewDlg::OnChangeEditPostcode() 
{
	RefreshUpdateBtn();
}

void CDBViewDlg::OnRadioFemale() 
{
	RefreshUpdateBtn();
}

void CDBViewDlg::OnRadioMale() 
{
	RefreshUpdateBtn();
}

void CDBViewDlg::OnBtnUpdate() 
{
	CString strTemp;

	//将家庭住址保存到记录集
	m_edtAddress.GetWindowText(strTemp);
	m_ds.SetAsString("ADDRESS", strTemp);

	//将年龄保存到记录集
	m_edtAge.GetWindowText(strTemp);
	m_ds.SetAsString("AGE", strTemp);

	//将姓名保存到记录集
	m_edtName.GetWindowText(strTemp);
	m_ds.SetAsString("NAME", strTemp);

	//将民族保存到记录集
	m_edtNationality.GetWindowText(strTemp);
	m_ds.SetAsString("NATIONALITY", strTemp);

	//将备注保存到记录集
	m_edtNote.GetWindowText(strTemp);
	m_ds.SetAsString("NOTE", strTemp);

	//将邮政编码保存到记录集
	m_edtPostCode.GetWindowText(strTemp);
	m_ds.SetAsString("POSTCODE", strTemp);

	//将性别保存到记录集
	//当单选按钮“女”被选中，保存1
	if (((CButton *)GetDlgItem(IDC_RADIO_FEMALE))->GetCheck() == BST_CHECKED)
	{
		m_ds.SetAsInteger("GENDER", 1);
	}
	//否则保存0
	else
	{
		m_ds.SetAsInteger("GENDER", 0);
	}

	//更新到数据库
	m_ds.Update();

	//设置更新按钮不可用
	m_btnUpdate.EnableWindow(FALSE);
}