employeepara.cpp

本程序使用Visual C++6.0编写

// EmployeePara.cpp : implementation file
//

#include "stdafx.h"
#include "sjsys.h"
#include "EmployeePara.h"

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

/////////////////////////////////////////////////////////////////////////////
// CEmployeePara dialog


CEmployeePara::CEmployeePara(CWnd* pParent /*=NULL*/)
	: CDialog(CEmployeePara::IDD, pParent)
{
	//{{AFX_DATA_INIT(CEmployeePara)
	m_id = _T("");
	m_name = _T("");
	m_phone = _T("");
	m_email = _T("");
	m_flag=0;
	m_department = _T("");
	//}}AFX_DATA_INIT
}


void CEmployeePara::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEmployeePara)
	DDX_Control(pDX, IDC_COMBO1, m_departmentcombo);
	DDX_Control(pDX, IDOK, m_OK);
	DDX_Control(pDX, IDCANCEL, m_cancel);
	DDX_Text(pDX, IDC_EDIT1, m_id);
	DDX_Text(pDX, IDC_EDIT2, m_name);
	DDX_Text(pDX, IDC_EDIT4, m_phone);
	DDX_Text(pDX, IDC_EDIT5, m_email);
	DDX_CBString(pDX, IDC_COMBO1, m_department);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CEmployeePara, CDialog)
	//{{AFX_MSG_MAP(CEmployeePara)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CEmployeePara message handlers

BOOL CEmployeePara::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_OK.SetShade(CShadeButtonST::SHS_HBUMP);
	m_cancel.SetShade(CShadeButtonST::SHS_HBUMP);
//	GetDlgItem(IDC_EDIT6)->EnableWindow(FALSE);
    _variant_t var;
	pRecordset.CreateInstance(__uuidof(Recordset));
	try 
	{
			   
        CString SQLStr="select * from Employee";
	    pRecordset->Open(_bstr_t(SQLStr),
				             ((CSjsysApp*)AfxGetApp())->pConnection.GetInterfacePtr(),
						     adOpenDynamic,
							 adLockOptimistic,
							 adCmdText);
		while(!pRecordset->adoEOF)
		{
				  
			var = pRecordset->GetCollect("Departmentid");
			if(var.vt != VT_NULL)
			{
                     //(LPCSTR)_bstr_t(var)
               m_departmentcombo.AddString((LPCSTR)_bstr_t(var)); 
			}
			pRecordset->MoveNext();	  
		}
	}
    catch(_com_error *e)
	{
	   AfxMessageBox(e->ErrorMessage());
	}
	pRecordset->Close();
    m_departmentcombo.SetCurSel(0);

	if(m_flag)
	{
		GetDlgItem(IDC_STATIC7)->ShowWindow(SW_SHOW);
    	GetDlgItem(IDC_STATIC6)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_STATIC5)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_STATIC4)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_EDIT5)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_EDIT4)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_COMBO1)->ShowWindow(SW_HIDE);
     	SetDlgItemText(IDC_STATIC7,"请输入查询条件：工号或姓名");
	}
	else
	{
		GetDlgItem(IDC_STATIC7)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_STATIC6)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_STATIC5)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_STATIC4)->ShowWindow(SW_SHOW);
    	GetDlgItem(IDC_EDIT5)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_EDIT4)->ShowWindow(SW_SHOW);
		if(m_id!="")
		{
			m_departmentcombo.SelectString(0,m_department);
		}
	//	GetDlgItem(IDC_EDIT3)->ShowWindow(SW_SHOW);
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}