studentinfo_finddlg.cpp

用VC++做的学生管理系统

// Studentinfo_finddlg.cpp : implementation file
//

#include "stdafx.h"
#include "mystudentsys.h"
#include "Studentinfo_finddlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CStudentinfo_finddlg dialog


CStudentinfo_finddlg::CStudentinfo_finddlg(CWnd* pParent /*=NULL*/)
	: CDialog(CStudentinfo_finddlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CStudentinfo_finddlg)
	m_studentaddr = _T("");
	m_studentage = 0.0f;
	m_studentclass = _T("");
	m_studentname = _T("");
	m_studentphone = _T("");
	m_studentsex = _T("");
	m_studentid = _T("");
	//}}AFX_DATA_INIT
}


void CStudentinfo_finddlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CStudentinfo_finddlg)
	DDX_Control(pDX, IDC_LIST1, m_List);
	DDX_Text(pDX, IDC_studentaddr, m_studentaddr);
	DDX_Text(pDX, IDC_studentage, m_studentage);
	DDX_Text(pDX, IDC_studentclass, m_studentclass);
	DDX_Text(pDX, IDC_studentname, m_studentname);
	DDX_Text(pDX, IDC_studentphone, m_studentphone);
	DDX_Text(pDX, IDC_studentsex, m_studentsex);
	DDX_Text(pDX, IDC_findstudent_id, m_studentid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CStudentinfo_finddlg, CDialog)
	//{{AFX_MSG_MAP(CStudentinfo_finddlg)
	ON_BN_CLICKED(IDC_findstudentinfo, Onfindstudentinfo)
	ON_WM_CLOSE()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CStudentinfo_finddlg message handlers

BOOL CStudentinfo_finddlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_List.InsertColumn(0,"学生姓名");
	m_List.InsertColumn(1,"性别");
	m_List.InsertColumn(2,"年龄");
	m_List.InsertColumn(3,"住址");
	m_List.InsertColumn(4,"电话");
	m_List.InsertColumn(5,"班级");

	RECT rect;
	m_List.GetWindowRect(&rect);
	int wid=rect.right-rect.left;
	m_List.SetColumnWidth(0,wid/6);
	m_List.SetColumnWidth(1,wid/6);
    m_List.SetColumnWidth(2,wid/6);
	m_List.SetColumnWidth(3,wid/6);
	m_List.SetColumnWidth(4,wid/6);
	m_List.SetColumnWidth(5,wid/6);

	m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CStudentinfo_finddlg::Onfindstudentinfo() 
{
	// TODO: Add your control notification handler code here
	if(mystudentset.IsOpen())
	{
		mystudentset.Close();
	}

	UpdateData(true);
	CString sqlStr;
	sqlStr="SELECT * FROM tb_studentinfo WHERE studentid='";
	sqlStr+=m_studentid;
	sqlStr+="'";
	if(!mystudentset.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
	{
		AfxMessageBox("tb_studentinfo表打开失败!");
	}
	
	DisplayRecord();

}
bool CStudentinfo_finddlg::DisplayRecord()
{
   if(mystudentset.IsBOF()&&mystudentset.IsEOF())
	{
		m_studentaddr="";
	    m_studentage = 0.0f;
	    m_studentclass ="";
	    m_studentname ="";
	    m_studentphone ="";
    	m_studentsex ="";
    	m_studentid ="";
	
	}
	else
	{
		if(mystudentset.IsBOF())
		{
			mystudentset.MoveNext();
		}
		else
		{
			if(mystudentset.IsEOF())
			{
				mystudentset.MovePrev();
			}
		}
	}

	    m_studentaddr=mystudentset.m_addr;
	    m_studentage =mystudentset.m_age;
	    m_studentclass =mystudentset.m_class;
	    m_studentname =mystudentset.m_studentname;
	    m_studentphone =mystudentset.m_phone;
    	m_studentsex =mystudentset.m_sex;

	CString addr,age,studentclass;
	CString name,phone,sex;
	CString date;
    
	name=mystudentset.m_studentname;
	addr=mystudentset.m_addr;
	age =mystudentset.m_age;
	studentclass =mystudentset.m_class;
	phone =mystudentset.m_phone;
    sex =mystudentset.m_sex;

	m_List.InsertItem(0,name.GetBuffer(50));
    m_List.SetItemText(0,1,sex.GetBuffer(50));
	m_List.SetItemText(0,2,age.GetBuffer(50));
	m_List.SetItemText(0,3,addr.GetBuffer(50));
    m_List.SetItemText(0,4,phone.GetBuffer(50));
	m_List.SetItemText(0,5,studentclass.GetBuffer(50));
	  
	UpdateData(false);
	return true;
}

void CStudentinfo_finddlg::OnClose() 
{
	// TODO: Add your message handler code here and/or call default
	if(mystudentset.IsOpen())
	{
		mystudentset.Close();
	}
	CDialog::OnClose();
}

void CStudentinfo_finddlg::OnOK()
{

}