www.pudn.com > 6-7cha.rar > 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(); 
}