⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 dialog_personnel.cpp

📁 < Visual C+++SQL Server数据库开发与实例>>一书中的实例核心源程序提供了几个案例的编程源代码。
💻 CPP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
// DIALOG_PERSONNEL.cpp : implementation file
//

#include "stdafx.h"
#include "train.h"
#include "DIALOG_PERSONNEL.h"
#include "PersonnelInfo.h"
#include "PersonnelPlan.h"
#include "PersonnelNeed.h"
#include "PersonSet.h"
#include "ScoreSet.h"
#include "PersonNeedSet.h"
#include "PersonPlanSet.h"
#include "ScoreInfo.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDIALOG_PERSONNEL dialog


CDIALOG_PERSONNEL::CDIALOG_PERSONNEL(CWnd* pParent /*=NULL*/)
	: CDialog(CDIALOG_PERSONNEL::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDIALOG_PERSONNEL)
	m_field = _T("");
	m_relation = _T("");
	m_content = _T("");
	//}}AFX_DATA_INIT
}


void CDIALOG_PERSONNEL::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDIALOG_PERSONNEL)
	DDX_Control(pDX, IDC_LIST4, m_need);
	DDX_Control(pDX, IDC_LIST3, m_plan);
	DDX_Control(pDX, IDC_LIST2, m_score);
	DDX_Control(pDX, IDC_LIST1, m_basic);
	DDX_CBString(pDX, IDC_COMBO1, m_field);
	DDX_CBString(pDX, IDC_COMBO2, m_relation);
	DDX_Text(pDX, IDC_EDIT1, m_content);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDIALOG_PERSONNEL, CDialog)
	//{{AFX_MSG_MAP(CDIALOG_PERSONNEL)
	ON_BN_CLICKED(IDC_BUTTONADD, OnButtonadd)
	ON_BN_CLICKED(IDC_RADIO1, OnRadio1)
	ON_BN_CLICKED(IDC_RADIO2, OnRadio2)
	ON_BN_CLICKED(IDC_RADIO3, OnRadio3)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_BN_CLICKED(IDC_BUTTONDEL, OnButtondel)
	ON_BN_CLICKED(IDC_RADIO4, OnRadio4)
	ON_NOTIFY(NM_RETURN, IDC_LIST1, OnReturnList1)
	ON_BN_CLICKED(IDC_BUTTONQUERY, OnButtonquery)
	ON_BN_CLICKED(IDC_RADIO4, OnRadio4)
	ON_NOTIFY(HDN_ITEMCLICK, IDC_LIST1, OnItemclickList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDIALOG_PERSONNEL message handlers

void CDIALOG_PERSONNEL::OnButtonadd() 
{
	// TODO: Add your control notification handler code here
	int choice=CDialog::GetCheckedRadioButton(IDC_RADIO1,IDC_RADIO4);
	if(choice==IDC_RADIO1)
	{
		m_database.Close();
		CPersonnelInfo m_personnelinfo;
		m_personnelinfo.m_database.Open(_T("train"));
		m_personnelinfo.DoModal();
		RefreshData();
	}
	else if(choice==IDC_RADIO2)
	{
		m_database.Close();
		CPersonnelPlan m_personnelplan;
		m_personnelplan.person_id=person_id;
		m_personnelplan.m_database.Open(_T("train"));
		m_personnelplan.DoModal();
		RefreshData();
	}
	else if(choice==IDC_RADIO3)
	{
		m_database.Close();
		CPersonnelNeed m_personnelneed;
		m_personnelneed.person_id=person_id;
		m_personnelneed.m_database.Open(_T("train"));
		m_personnelneed.DoModal();
		RefreshData();
	}
	else if(choice==IDC_RADIO4)
	{
		m_database.Close();
		CScoreInfo m_scoreinfo;
		m_scoreinfo.person_id=person_id;
		m_scoreinfo.m_database.Open(_T("train"));
		m_scoreinfo.DoModal();
		RefreshData();
	}
	else
	{
		MessageBox("Please choose a class first!!");
	}
	
}

void CDIALOG_PERSONNEL::OnRadio1() 
{
	// TODO: Add your control notification handler code here
	CDialog::CheckRadioButton(IDC_RADIO1,IDC_RADIO4,IDC_RADIO1);
}

void CDIALOG_PERSONNEL::OnRadio2() 
{
	// TODO: Add your control notification handler code here
	CDialog::CheckRadioButton(IDC_RADIO1,IDC_RADIO4,IDC_RADIO2);
}

void CDIALOG_PERSONNEL::OnRadio3() 
{
	// TODO: Add your control notification handler code here
	CDialog::CheckRadioButton(IDC_RADIO1,IDC_RADIO4,IDC_RADIO3);
}

void CDIALOG_PERSONNEL::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int i=m_basic.GetSelectionMark();
	CString strSQL;
	if(i==-1){
		MessageBox("please choose a record first!");
	}
	else{
		person_id=atoi(m_basic.GetItemText(i,0));
		m_basic.SetHotItem(i);
		RefreshData();
	}	
//	*pResult = 0;
}

void CDIALOG_PERSONNEL::RefreshData()
{
	if(!m_database.IsOpen()){
		m_database.Open(_T("train"));
	}
	m_basic.DeleteAllItems();
	CPersonSet m_basicset(&m_database);
	CString strSQL;
	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_basic.InsertItem(i,buf);
		m_basicset.GetFieldValue(1,varValue);
		m_basic.SetItemText(i,1,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(2,varValue);
		sprintf(buf,"%d",varValue.m_chVal); m_basic.SetItemText(i,2,buf);
		m_basicset.GetFieldValue(3,varValue);
		m_basic.SetItemText(i,3,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(4,varValue);
		m_basic.SetItemText(i,4,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(5,varValue);
		sprintf(buf,"%d-%d-%d",varValue.m_pdate->year,varValue.m_pdate->month,varValue.m_pdate->day); m_basic.SetItemText(i,5,buf);
		m_basicset.GetFieldValue(6,varValue);
		m_basic.SetItemText(i,6,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(7,varValue);
		m_basic.SetItemText(i,7,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(8,varValue);
		m_basic.SetItemText(i,8,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(9,varValue);
		m_basic.SetItemText(i,9,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(10,varValue);
		m_basic.SetItemText(i,10,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(11,varValue);
		m_basic.SetItemText(i,11,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(12,varValue);
		sprintf(buf,"%d-%d-%d",varValue.m_pdate->year,varValue.m_pdate->month,varValue.m_pdate->day); m_basic.SetItemText(i,12,buf);
		m_basicset.GetFieldValue(13,varValue);
		m_basic.SetItemText(i,13,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(14,varValue);
		sprintf(buf,"%d-%d-%d",varValue.m_pdate->year,varValue.m_pdate->month,varValue.m_pdate->day); m_basic.SetItemText(i,14,buf);
		m_basicset.GetFieldValue(15,varValue);
		m_basic.SetItemText(i,15,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(16,varValue);
		sprintf(buf,"%d",varValue.m_chVal); m_basic.SetItemText(i,16,buf);
		m_basicset.GetFieldValue(17,varValue);
		m_basic.SetItemText(i,17,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(18,varValue);
		sprintf(buf,"%d",varValue.m_chVal); m_basic.SetItemText(i,18,buf);
		m_basicset.MoveNext();
		i++;
	}
	m_score.DeleteAllItems();
	CScoreSet m_scoreset(&m_database);
	strSQL.Format("select * from SCORE where EMP_NO=%d",person_id);
	m_scoreset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_scoreset.GetRecordCount()!=0) m_scoreset.MoveFirst();
	i=0;
	while(!m_scoreset.IsEOF())
	{
		int temp=0;
		m_scoreset.GetFieldValue(temp,varValue);
		sprintf(buf,"%d",varValue.m_iVal); m_score.InsertItem(i,buf);
		m_scoreset.GetFieldValue(1,varValue);
		sprintf(buf,"%d",varValue.m_iVal); m_score.SetItemText(i,1,buf);
		m_scoreset.GetFieldValue(2,varValue);
		sprintf(buf,"%d-%d-%d",varValue.m_pdate->year,varValue.m_pdate->month,varValue.m_pdate->day); m_score.SetItemText(i,2,buf);
		m_scoreset.GetFieldValue(3,varValue);
		m_score.SetItemText(i,3,varValue.m_pstring->GetBuffer(1));
		m_scoreset.GetFieldValue(4,varValue);
		sprintf(buf,"%d",varValue.m_iVal); m_score.SetItemText(i,4,buf);
		m_scoreset.GetFieldValue(5,varValue);
		sprintf(buf,"%d",varValue.m_iVal); m_score.SetItemText(i,5,buf);
		m_scoreset.GetFieldValue(6,varValue);
		sprintf(buf,"%d",varValue.m_iVal); m_score.SetItemText(i,6,buf);
		m_scoreset.GetFieldValue(7,varValue);
		m_score.SetItemText(i,7,varValue.m_pstring->GetBuffer(1));
		m_scoreset.GetFieldValue(8,varValue);
		sprintf(buf,"%d",varValue.m_chVal); m_score.SetItemText(i,8,buf);
		m_scoreset.MoveNext();
		i++;
	}
	m_need.DeleteAllItems();
	CPersonNeedSet m_needset(&m_database);
	strSQL.Format("select * from COURSE_NEED where COURSE_NEED=%d",person_id);
	m_needset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_needset.GetRecordCount()!=0) m_needset.MoveFirst();
	i=0;
	while(!m_needset.IsEOF())
	{
		int temp=0;
		m_needset.GetFieldValue(temp,varValue);
		sprintf(buf,"%d",varValue.m_iVal); m_need.InsertItem(i,buf);
		m_needset.GetFieldValue(1,varValue);
		sprintf(buf,"%d",varValue.m_lVal); m_need.SetItemText(i,1,buf);
		m_needset.MoveNext();
		i++;
	}
	m_plan.DeleteAllItems();
	CPersonPlanSet m_planset(&m_database);
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -