searchdlg.cpp

毕业生信息管理系统的基本功能是对毕业生的信息进行管理

// SearchDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BySys.h"
#include "SearchDlg.h"
#include "MoHuSearchDlg.h"
#include "_recordset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSearchDlg dialog


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


void CSearchDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchDlg)
	DDX_Control(pDX, IDC_COMBO1, m_combo);
	DDX_Control(pDX, IDC_ADODC1, m_adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
	DDX_Text(pDX, IDC_EDIT3, m_Search);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearchDlg, CDialog)
	//{{AFX_MSG_MAP(CSearchDlg)
	ON_BN_CLICKED(IDC_MH_BUTTON, OnMhButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearchDlg message handlers

void CSearchDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	if( m_combo.GetCurSel() == 0)
	{	
		m_adodc.SetRecordSource("SELECT Stu_id AS 学号,Stu_Name AS  姓名 ,Stu_Nat AS 民族 ,Birthday AS 生日 FROM Base_Mat WHERE Stu_Name = '"+m_Search+"'");
		m_adodc.Refresh();

	}
	else if( m_combo.GetCurSel() == 1)
	{
		m_adodc.SetRecordSource("SELECT Stu_id AS 学号,Stu_Name AS  姓名 ,Stu_Nat AS 民族 ,Birthday AS 生日 FROM Base_Mat WHERE Stu_id = '"+m_Search+"'");
		m_adodc.Refresh();

	}
	else if( m_combo.GetCurSel() == 2)
	{
		m_adodc.SetRecordSource("SELECT  Stu_id AS 学号,Stu_Name AS  姓名 ,Stu_Nat AS 民族 ,Birthday AS 生日 FROM Department WHERE Yard_Name = '"+m_Search+"'");
		m_adodc.Refresh();

	}
	else if( m_combo.GetCurSel() == 3)
	{
		m_adodc.SetRecordSource("SELECT Stu_id AS 学号,Stu_Name AS  姓名 ,Stu_Nat AS 民族 ,Birthday AS 生日 FROM Department WHERE Sep_Name = '"+m_Search+"'");
		m_adodc.Refresh();

	}
	
}

BOOL CSearchDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	m_combo.AddString("姓名");
	m_combo.AddString("学号");
	m_combo.AddString("学院");
	m_combo.AddString("专业");
	m_combo.SetCurSel(0);
	m_adodc.SetRecordSource("SELECT Stu_id AS 学号,Stu_Name AS  姓名 ,Stu_Nat AS 民族 ,Birthday AS 生日  FROM Base_Mat");
	m_adodc.Refresh();

	return TRUE;
}

void CSearchDlg::OnMhButton() 
{
	// TODO: Add your control notification handler code here
	CMoHuSearchDlg dlg6;
	dlg6.DoModal();
		
}