choosedepart.cpp

自已做的简单的库存管理软件。包含员工信息管理等

// ChooseDepart.cpp : 实现文件
//

#include "stdafx.h"
#include "ChooseDepart.h"

extern _ConnectionPtr pMyConnect;
extern CString str_choose_depart;
// CChooseDepart 对话框

IMPLEMENT_DYNAMIC(CChooseDepart, CDialog)

CChooseDepart::CChooseDepart(CWnd* pParent /*=NULL*/)
	: CDialog(CChooseDepart::IDD, pParent)
{

}

CChooseDepart::~CChooseDepart()
{
}

void CChooseDepart::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
}


BEGIN_MESSAGE_MAP(CChooseDepart, CDialog)
	ON_BN_CLICKED(IDOK, &CChooseDepart::OnBnClickedOk)
END_MESSAGE_MAP()


// CChooseDepart 消息处理程序
BOOL CChooseDepart::OnInitDialog()
{
	CDialog::OnInitDialog();



	int number = 0;

	_RecordsetPtr m_pRs; 
	CString m_strSql; 

	CComboBox* pWnd;
	pWnd = (CComboBox*)GetDlgItem(IDC_COMBO_DEPART);
	pWnd->ResetContent();

		
	m_strSql.Format(_T("select DEPART from DEPART_TABLE where ( SN > 0)") ); 
	m_pRs.CreateInstance( __uuidof(Recordset) ); 
	m_pRs->Open( _bstr_t(m_strSql), _variant_t((IDispatch *)pMyConnect,true), adOpenKeyset, adLockOptimistic, adCmdText);  
		
	try
	{	
		if ( m_pRs->GetRecordCount() > 0 )
		{
		
			_variant_t   TheValue;
			_bstr_t tmp;
		
			m_pRs->MoveFirst(); 
			while(m_pRs->adoEOF==VARIANT_FALSE)	
			{
				//Retrieve column's value: 	 									
			


				TheValue = m_pRs->Fields->GetItem(_variant_t("DEPART"))->Value;
				if( TheValue.vt != VT_NULL )
				{
					tmp=(_bstr_t)TheValue; 		
					CString str_tmp1 = tmp;
					pWnd->InsertString(number,str_tmp1);

					number++;
				}

					//Do something what you want to do:	......
				m_pRs->MoveNext(); 
			}		
		}
	}
	catch (_com_error &e)
	{
		::MessageBox(NULL,e.Description(),(LPCTSTR)(_T("警告")),MB_OK);
		
	}
	m_pRs->Close(); 
	
	

   
	return FALSE;// 将焦点设置到控件，否则返回 TRUE

}
void CChooseDepart::OnBnClickedOk()
{
	// TODO: 在此添加控件通知处理程序代码
	CWnd* pWnd;
	CString str0;
	
	
	//DEPART
	pWnd = GetDlgItem(IDC_COMBO_DEPART);
	pWnd->GetWindowText(str0);
	if ( str0.GetLength() == 0 )
	{
		AfxMessageBox(_T("请选择部门！"));
		return;
	}

	str_choose_depart = str0;
	OnOK();
}