mohusearchdlg.cpp

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

// MoHuSearchDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CMoHuSearchDlg dialog


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


void CMoHuSearchDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CMoHuSearchDlg)
	DDX_Control(pDX, IDC_COMBO2, m_combo);
	DDX_Text(pDX, IDC_EDIT1, m_chaxun);
	DDX_Control(pDX, IDC_ADODC1, m_adodc);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CMoHuSearchDlg message handlers

BOOL CMoHuSearchDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	m_combo.AddString("姓名");
	m_combo.AddString("学号");
	m_combo.AddString("学院");
	m_combo.AddString("专业");
	return TRUE;
}

void CMoHuSearchDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	int n;
	n = m_combo.GetCurSel();
	CString str,str1;
	str = "'%"+m_chaxun;
	str1 = str+"%'";
	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 LIKE "+str1+" ");
		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 LIKE "+str1+"");
		m_adodc.Refresh();

	}
	else if( m_combo.GetCurSel() == 2)
	{
		m_adodc.SetRecordSource("SELECT  Stu_id AS 学号,Stu_Name AS  姓名 ,Sch_Name AS 学校 ,Yard_Name AS 学院,Dep_Name AS 系,Sep_Name AS 专业 FROM Department WHERE Yard_Name LIKE "+str1+"");
		m_adodc.Refresh();

	}
	else if( m_combo.GetCurSel() == 3)
	{
		m_adodc.SetRecordSource("SELECT  Stu_id AS 学号,Stu_Name AS  姓名 ,Sch_Name AS 学校 ,Yard_Name AS 学院,Dep_Name AS 系,Sep_Name AS 专业 FROM Department WHERE Sep_Name LIKE "+str1+"");
		m_adodc.Refresh();

	}
}