finddlg.cpp

（1）学生信息的输入

// FINDDLG.cpp : implementation file
//

#include "stdafx.h"
#include "lxy.h"
#include "FINDDLG.h"

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

/////////////////////////////////////////////////////////////////////////////
// FINDDLG dialog


FINDDLG::FINDDLG(CWnd* pParent /*=NULL*/)
	: CDialog(FINDDLG::IDD, pParent)
{
	//{{AFX_DATA_INIT(FINDDLG)
	m_findstr = _T("");
	//}}AFX_DATA_INIT
	sortflag=false;
}


void FINDDLG::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(FINDDLG)
	DDX_Control(pDX, IDC_COMBO1, m_combo);
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Text(pDX, IDC_EDIT1, m_findstr);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(FINDDLG, CDialog)
	//{{AFX_MSG_MAP(FINDDLG)
	ON_BN_CLICKED(IDC_find, Onfind)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// FINDDLG message handlers

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

/////////////////////////////////////////////////////////////////////////////	
   
	m_combo.InsertString(0,"sno");
	m_combo.InsertString(1,"sname");
	m_combo.InsertString(2,"sage");
	m_combo.InsertString(3,"ssex");
	m_combo.InsertString(4,"semail");
	m_combo.InsertString(5,"sdept");
    m_combo.SetCurSel(0);
    pdb=new CDatabase;
	m_pSet=new StudentSet(pdb);
	m_pSet->Open();
	m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
	m_list.InsertColumn(0,"学号",LVCFMT_CENTER,80);
	m_list.InsertColumn(1,"姓名",LVCFMT_CENTER,80);
	m_list.InsertColumn(2,"年龄",LVCFMT_CENTER,50);
	m_list.InsertColumn(3,"性别",LVCFMT_CENTER,50);
	m_list.InsertColumn(4,"E-MAIL",LVCFMT_CENTER,150);
	m_list.InsertColumn(5,"院系",LVCFMT_CENTER,100);
	sqlstr.Format("select * from student");
/////////////////////////////////////////////////////////////////////////////  
	if(sortflag)
	{
	  SetWindowText("排序");
	  GetDlgItem(IDC_find)->SetWindowText("排序");
	  GetDlgItem(IDC_EDIT1)->ShowWindow(false);  
	}
	else 
	{
	  SetWindowText("查找");
	}	
	LoadData();
/////////////////////////////////////////////////////////////////////////////		
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void FINDDLG::LoadData()
{
 if(m_pSet->IsOpen())
	 m_pSet->Close();
     m_pSet->Open(AFX_DB_USE_DEFAULT_TYPE,sqlstr);
         int i=0;
		 while(!m_pSet->IsEOF())
		 {
		   CString  str;
		   str.Format("%d",m_pSet->m_sage);
		   m_list.InsertItem(i,m_pSet->m_sno);
		   m_list.SetItemText(i,1,m_pSet->m_sname);
		   m_list.SetItemText(i,2, str);
		   m_list.SetItemText(i,3,m_pSet->m_ssex);
		   m_list.SetItemText(i,4,m_pSet->m_semail);
		   m_list.SetItemText(i,5,m_pSet->m_sdept);
		   i++;
		   m_pSet->MoveNext();
		}
}

void FINDDLG::Onfind() 
{   m_list.DeleteAllItems();
	UpdateData();
	CString temp;
	int k=m_combo.GetCurSel();
	m_combo.GetLBText(k,temp);
	if(!sortflag)
			{
				if(m_findstr.IsEmpty())
				{	AfxMessageBox("请输入查找内容!");
					m_list.DeleteAllItems();
					 return;
				}
				sqlstr.Format("select * from student where %s like '%%%s%%'",temp,m_findstr);
				if((m_pSet->IsBOF())&&(m_pSet->IsEOF()))
				{
					MessageBox("无此记录!");
					return;
				}
			}
	else
			{
				 sqlstr.Format("select * from student order by %s",temp);
			}	

	LoadData();	
}