stusearchdlg.cpp

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

// StuSearchDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BySys.h"
#include "StuSearchDlg.h"
#include "_recordset.h"
#include "LLZLDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CStuSearchDlg dialog


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


void CStuSearchDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CStuSearchDlg)
	DDX_Control(pDX, IDC_Conditiong_COMBO1, m_Condition);
	DDX_Text(pDX, IDC_Nei_EDIT1, m_Nei);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_DataGrid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CStuSearchDlg, CDialog)
	//{{AFX_MSG_MAP(CStuSearchDlg)
	ON_BN_CLICKED(IDC_Search_BUTTON1, OnSearchBUTTON1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CStuSearchDlg message handlers

BOOL CStuSearchDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	CString cSource;
	cSource="SELECT Stu_id As 学号,Stu_Name As 姓名,Yard_Name As 学校,Dep_Name As 学院 FROM Students";
    m_Condition.AddString("姓名");
	m_Condition.AddString("学号");
	m_Condition.AddString("学院");
	m_Condition.AddString("专业");
	m_Adodc.SetRecordSource(cSource);
	m_Condition.SetCurSel(0);
    m_Adodc.Refresh();
	return TRUE;


}

void CStuSearchDlg::Refresh_Data()
{

}

void CStuSearchDlg::OnSearchBUTTON1() 
{
	
	// TODO: Add your control notification handler code here
   UpdateData(TRUE);
	if( m_Condition.GetCurSel() == 0)
	{	
		m_Adodc.SetRecordSource("SELECT Stu_id AS 学号,Stu_Name AS  姓名 ,Stu_Nat AS 民族 ,Birthday AS 生日 FROM Base_Mat WHERE Stu_Name = '"+m_Nei+"'");
		if( m_Adodc.GetRecordset().GetEof() ==1)
		{
			MessageBox("你要查询的信息不存在!");
			return ;
		}

		m_Adodc.Refresh();

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

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

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

	}
	
}

BEGIN_EVENTSINK_MAP(CStuSearchDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CStuSearchDlg)
	ON_EVENT(CStuSearchDlg, IDC_DATAGRID1, -601 /* DblClick */, OnDblClickDatagrid1, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CStuSearchDlg::OnDblClickDatagrid1() 
{
     CLLZLDlg  dlg;
	 dlg.DoModal();
	// TODO: Add your control notification handler code here
	
}