dlgemployee.cpp

完成信息管理的功能

// DlgEmployee.cpp : implementation file
//

#include "stdafx.h"
#include "NorthMIS.h"
#include "DlgEmployee.h"
#include "_recordset.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDlgEmployee dialog


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


void CDlgEmployee::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgEmployee)
	DDX_Control(pDX, IDC_ADODC_EMPLOYEE, m_adoDCEm);
	DDX_Text(pDX, IDC_EDIT_CITY, m_editCity);
	DDX_Control(pDX, IDC_DATAGRID1, m_dataGridEm);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgEmployee, CDialog)
	//{{AFX_MSG_MAP(CDlgEmployee)
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnButtonQuery)
	ON_BN_CLICKED(IDC_BUTTON_BASIC, OnButtonBasic)
	ON_BN_CLICKED(IDC_BUTTON_STO, OnButtonSto)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgEmployee message handlers

void CDlgEmployee::OnButtonQuery() 
{
	UpdateData(TRUE);
	CString strSQL;
	strSQL.Format("select EmployeeID,LastName,FirstName,Title,City from Employees where City='%s'",m_editCity);
	m_adoDCEm.SetRecordSource(strSQL);
	m_adoDCEm.Refresh();
	
}

void CDlgEmployee::OnButtonBasic() 
{
	CString strSQL="select EmployeeID,LastName,FirstName,Title,Address from Employees";
	m_adoDCEm.SetRecordSource(strSQL);
	m_adoDCEm.Refresh();

	CColumns allCols;
	CColumn onecol;

	allCols=m_dataGridEm.GetColumns();

	onecol=allCols.GetItem(COleVariant(long(0)));
	onecol.SetCaption("编号");
	onecol.SetWidth(20);
	onecol=allCols.GetItem(COleVariant(long(1)));
	onecol.SetCaption("姓氏");
	onecol.SetWidth(60);
	onecol=allCols.GetItem(COleVariant(long(2)));
	onecol.SetCaption("名");
	onecol.SetWidth(60);
	onecol=allCols.GetItem(COleVariant(long(3)));
	onecol.SetCaption("职位");
	onecol.SetWidth(100);
	onecol=allCols.GetItem(COleVariant(long(4)));
	onecol.SetCaption("住址");
	onecol.SetWidth(140);
}

void CDlgEmployee::OnButtonSto() 
{
	// TODO: Add your control notification handler code here
	m_adoDCEm.SetCommandType(4);
	m_adoDCEm.SetRecordSource("EmployeeAddress");//Ten Most Expensive Products
	m_adoDCEm.Refresh();
}