searchdlg.cpp

学生请假管理系统,用ADO写的,很不错的代码,界面美观,大方请使用

// Search.cpp : implementation file
//

#include "stdafx.h"
#include "cc.h"
#include "SearchDlg.h"
#include"CcDlg.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_strName = _T("");
	m_strCollege = _T("");
	m_strReason = _T("");
	m_nSel = 0;

	CString strTimeNow;
	CTime now=CTime::GetCurrentTime();
	strTimeNow=now.Format(_T("%Y%m%d"));

	m_strDate1 = strTimeNow;
	m_strDate2 = strTimeNow;

	

	
	//}}AFX_DATA_INIT
}


void CSearchDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearchDlg)
	DDX_Text(pDX, IDC_NAME, m_strName);
	DDX_Text(pDX, IDC_COLLEGES, m_strCollege);
	DDX_Text(pDX, IDC_REASONS, m_strReason);
	DDX_Radio(pDX, IDC_RADIO1, m_nSel);
	DDX_Text(pDX, IDC_DATE1, m_strDate1);
	DDX_Text(pDX, IDC_DATE2, m_strDate2);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearchDlg, CDialog)
	//{{AFX_MSG_MAP(CSearchDlg)
	ON_BN_CLICKED(IDC_RADIO1, OnRadio1)
	ON_BN_CLICKED(IDC_RADIO2, OnRadio2)
	ON_BN_CLICKED(IDC_RADIO3, OnRadio3)
	ON_BN_CLICKED(IDC_RADIO4, OnRadio4)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearchDlg message handlers
extern CCcApp theApp;

BOOL CSearchDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();

 		ShowEnable();


	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CSearchDlg::OnOK() 
{
	try
	{
		UpdateData();
		switch(m_nSel)
		{
		case 0:
			theApp.m_strSQL="SELECT * FROM Records WHERE   date1>='"+m_strDate1+"' AND date2<='"+m_strDate2+"'";
			break;

		case 1:
			theApp.m_strSQL="SELECT * FROM Records WHERE  Name LIKE '%"+m_strName+"%'";
			break;
			
		case 2:
			theApp.m_strSQL="SELECT * FROM Records WHERE  College LIKE '%"+m_strCollege+"%'";
			break;
			
		case 3:
			theApp.m_strSQL="SELECT * FROM Records WHERE  Reason LIKE '%"+m_strReason+"%'";
			break;			
		}
		((CCcDlg*)AfxGetMainWnd())->List(theApp.m_strSQL);  
	}
	catch(_com_error e)
	{
		CATCH_ERROR;
	}
	
	CDialog::OnOK();	
}


void CSearchDlg::OnRadio1() 
{
	ShowEnable();
	
}

void CSearchDlg::OnRadio2() 
{

	ShowEnable();
}

void CSearchDlg::OnRadio3() 
{

	ShowEnable();
}

void CSearchDlg::OnRadio4() 
{
	ShowEnable();
	
}

void CSearchDlg::ShowEnable()
{
	UpdateData();
	switch(m_nSel)
	{
	case 0:
		GetDlgItem(IDC_DATE1)->EnableWindow(true);
		GetDlgItem(IDC_DATE2)->EnableWindow(true);
		GetDlgItem(IDC_NAME)->EnableWindow(false);
		GetDlgItem(IDC_COLLEGES)->EnableWindow(false);
		GetDlgItem(IDC_REASONS)->EnableWindow(false);
		break;

	case 1:
		GetDlgItem(IDC_DATE1)->EnableWindow(false);
		GetDlgItem(IDC_DATE2)->EnableWindow(false);
		GetDlgItem(IDC_NAME)->EnableWindow(true);
		GetDlgItem(IDC_COLLEGES)->EnableWindow(false);
		GetDlgItem(IDC_REASONS)->EnableWindow(false);
		break;

	case 2:
		GetDlgItem(IDC_DATE1)->EnableWindow(false);
		GetDlgItem(IDC_DATE2)->EnableWindow(false);
		GetDlgItem(IDC_NAME)->EnableWindow(false);
		GetDlgItem(IDC_COLLEGES)->EnableWindow(true);
		GetDlgItem(IDC_REASONS)->EnableWindow(false);
		break;

	case 3:
		GetDlgItem(IDC_DATE1)->EnableWindow(false);
		GetDlgItem(IDC_DATE2)->EnableWindow(false);
		GetDlgItem(IDC_NAME)->EnableWindow(false);
		GetDlgItem(IDC_COLLEGES)->EnableWindow(false);
		GetDlgItem(IDC_REASONS)->EnableWindow(true);
		break;
	}
}