person.cpp

本源码为图书管理系统

// PERSON.cpp : implementation file
//

#include "stdafx.h"
#include "TSG.h"
#include "PERSON.h"
#include "personinfo.h"
#include "personadd.h"
#include "personmod.h"
#include "afxdb.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// PERSON dialog


PERSON::PERSON(CWnd* pParent /*=NULL*/)
	: CDialog(PERSON::IDD, pParent)
{
	//{{AFX_DATA_INIT(PERSON)
	m_field = _T("");
	m_relation = _T("");
	m_content = _T("");
	m_pid1 = 0;
	m_pname1 = _T("");
	m_psex1 = _T("");
	m_pyuan1 = _T("");
	m_pli1 = _T("");
	change1=false;
	//}}AFX_DATA_INIT
}


void PERSON::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(PERSON)
	DDX_Control(pDX, IDC_LIST1, m_book1);
	DDX_CBString(pDX, IDC_COMBO1, m_field);
	DDX_CBString(pDX, IDC_COMBO2, m_relation);
	DDX_Text(pDX, IDC_EDIT1, m_content);
	DDX_Text(pDX, IDC_EDIT111, m_pid1);
	DDX_Text(pDX, IDC_EDIT112, m_pname1);
	DDX_Text(pDX, IDC_EDIT113, m_psex1);
	DDX_Text(pDX, IDC_EDIT114, m_pyuan1);
	DDX_Text(pDX, IDC_EDIT115, m_pli1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(PERSON, CDialog)
	//{{AFX_MSG_MAP(PERSON)
	ON_BN_CLICKED(IDC_PERADD, OnPeradd)
	ON_BN_CLICKED(IDC_PERSUB, OnPersub)
	ON_BN_CLICKED(IDC_PERMOD, OnPermod)
	ON_BN_CLICKED(IDC_PERCHAXUN, OnPerchaxun)
	ON_NOTIFY(LVN_ITEMCHANGED, IDC_LIST1, OnItemchangedList1)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// PERSON message handlers


///////////////////////////////////////////////////////////////////////////////
BOOL PERSON::OnInitDialog()
{	CDialog::OnInitDialog();


	// TODO: Add extra initialization here
	m_book1.InsertColumn(0,"学号");
	m_book1.InsertColumn(1,"姓名");
	m_book1.InsertColumn(2,"性别");
	m_book1.InsertColumn(3,"学院");
    m_book1.InsertColumn(4,"学历");

	RECT rectbasic;
	m_book1.GetWindowRect(&rectbasic);
	int widbasic = rectbasic.right - rectbasic.left;
	m_book1.SetColumnWidth(0,widbasic/4);
	m_book1.SetColumnWidth(1,widbasic/4);
	m_book1.SetColumnWidth(2,widbasic/4);
	m_book1.SetColumnWidth(3,widbasic/4);
	m_book1.SetColumnWidth(4,widbasic/4);

	m_book1.SetExtendedStyle(LVS_EX_FULLROWSELECT);
    if(!change1)
	{p_query.Format("select * from personinfo");}
    RefreshData();
	
	//{m_book1.SetHotItem(bb);}
    
	change1=false;
	return true;

}


/////////////////////////////////////////////////////
void PERSON::RefreshData()
{if(!m_database.IsOpen()){
		m_database.Open(_T("TSG"));
	}
	m_book1.DeleteAllItems();
	personinfo m_basicset(&m_database);
	CString strSQL;
	strSQL.Format("select * from personinfo");
	m_basicset.Open(AFX_DB_USE_DEFAULT_TYPE,p_query);
	CDBVariant varValue;
	if(m_basicset.GetRecordCount()!=0) m_basicset.MoveFirst();
	char buf[20];
	int i=0;
	while(!m_basicset.IsEOF())
	{
		int temp=0;
		m_basicset.GetFieldValue(temp,varValue);
		sprintf(buf,"%d",varValue.m_lVal); m_book1.InsertItem(i,buf);
	    
		m_basicset.GetFieldValue(1,varValue);
		m_book1.SetItemText(i,1,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(2,varValue);
		m_book1.SetItemText(i,2,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(3,varValue);
		m_book1.SetItemText(i,3,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(4,varValue);
		m_book1.SetItemText(i,4,varValue.m_pstring->GetBuffer(1));
		m_basicset.MoveNext();
		i++;
	}
     	

}

void PERSON::OnPeradd() 
{
	    m_database.Close();
		personadd pad;
		pad.m_database.Open(_T("TSG"));
		pad.DoModal();
		RefreshData();
	
}

void PERSON::OnPersub() 
{   int i=m_book1.GetSelectionMark();
		CString strSQL;
	if(i==-1){
			MessageBox("please choose a record first!");
		}
		else{
			int keyid=atoi(m_book1.GetItemText(i,0));
			strSQL.Format("delete from personinfo where 学号=%d",keyid);
			m_database.ExecuteSQL(strSQL);
			
			m_database.Close();
			RefreshData();}
	// TODO: Add your control notification handler code here

}

void PERSON::OnPermod() 
{       personmod pm;
        int r=m_book1.GetSelectionMark();
		CString strSQL;
	    if(r==-1){
			MessageBox("please choose a record first!");
		}
		else {int i=m_book1.GetSelectionMark();
        pm.m_pid=(int)atoi(m_book1.GetItemText(i,0));
		pm.m_pname=m_book1.GetItemText(i,1);
        pm.m_psex=m_book1.GetItemText(i,2);
        pm.m_pyuan=m_book1.GetItemText(i,3);
        pm.m_pli=m_book1.GetItemText(i,4);
        m_database.Close();
		
		pm.m_database.Open(_T("TSG"));
		pm.DoModal();
		RefreshData();}
	// TODO: Add your control notification handler code here
	
}

void PERSON::OnPerchaxun() 
{UpdateData(TRUE);
	CString m_realfield;
	if(m_field.Compare("学号")==0)
	{
		m_realfield.Format("学号");
		p_query.Format("select * from personinfo where %s%s%d",m_realfield,m_relation,atoi(m_content));
	}
	if(m_field.Compare("姓名")==0)
	{
		m_realfield.Format("姓名");
		p_query.Format("select * from personinfo where %s%s'%s'",m_realfield,m_relation,m_content);
	}
	if(m_field.Compare("性别")==0)
	{
		m_realfield.Format("性别");
		p_query.Format("select * from personinfo where %s%s'%s'",m_realfield,m_relation,m_content);
	}
	
	if(m_field.Compare("学院")==0)
	{
		m_realfield.Format("学院");
		p_query.Format("select * from personinfo where %s%s'%s'",m_realfield,m_relation,m_content);
	}
    if(m_field.Compare("学历")==0)
	{
		m_realfield.Format("学历");
		p_query.Format("select * from personinfo where %s%s'%s'",m_realfield,m_relation,m_content);
	}
	RefreshData();
	// TODO: Add your control notification handler code here
	
}

void PERSON::OnItemchangedList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	    int i=m_book1.GetNextItem(-1,LVNI_SELECTED);
	    m_pid1=(int)atoi(m_book1.GetItemText(i,0));
		m_pname1=m_book1.GetItemText(i,1);
        m_psex1=m_book1.GetItemText(i,2);
        m_pyuan1=m_book1.GetItemText(i,3);
        m_pli1=m_book1.GetItemText(i,4);
		UpdateData(FALSE);
	*pResult = 0;
}

void PERSON::OnButton1() 
{RefreshData();
	// TODO: Add your control notification handler code here
	
}

void PERSON::theperson(int aa)
{
  if(!m_database.IsOpen()){
		m_database.Open(_T("TSG"));
	}
    p_query.Format("select * from personinfo where 学号=%d",aa);
    
    //bb=aa;
    change1=true;
	m_database.Close();
}