?? dialog_personnel.cpp
字號:
// 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_NOTIFY(HDN_ITEMCLICK, IDC_LIST1, OnItemclickList1)
ON_BN_CLICKED(IDC_RADIO4, OnRadio4)
ON_NOTIFY(NM_CLICK, IDC_LIST5, OnClickList5)
//}}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);
strSQL.Format("select * from PERSONNEL_PLAN where EMP_NO=%d",person_id);
m_planset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
if(m_planset.GetRecordCount()!=0) m_planset.MoveFirst();
i=0;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -