?? boss.cpp
字號:
// Boss.cpp : implementation file
//
#include "stdafx.h"
#include "SQL.h"
#include "Boss.h"
#include "Main.h"
#include "CostNumber.h"
#include "Note.h"
#include "PojectSet.h"
#include "Dtatabaseset.h"
#include "Mainctrl.h"
#include "Projectctrl.h"
#include "BossNoteCtrl.h"
#include "CostCtr.h"
#include "Employeectrl.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CBoss dialog
CBoss::CBoss(CWnd* pParent /*=NULL*/)
: CDialog(CBoss::IDD, pParent)
{
//{{AFX_DATA_INIT(CBoss)
//}}AFX_DATA_INIT
}
void CBoss::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CBoss)
DDX_Control(pDX, IDC_EMPLOYEELIST, m_employeelistctrl);
DDX_Control(pDX, IDC_BOSSCOST, m_bosscostnumberctrl);
DDX_Control(pDX, IDC_COMPANYNOTE, m_bossnotectrl);
DDX_Control(pDX, IDC_BOSSPROJECT, m_bossprojectctrl);
DDX_Control(pDX, IDC_BOSSMAIN, m_bossmainctrl);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CBoss, CDialog)
//{{AFX_MSG_MAP(CBoss)
ON_BN_CLICKED(IDC_BUTTON1, OnMain)
ON_BN_CLICKED(IDC_BUTTON2, OnProject)
ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
ON_BN_CLICKED(IDC_BUTTON4, OnCost)
ON_BN_CLICKED(IDC_BUTTON5, OnEmployees)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CBoss message handlers
void CBoss::OnClickBossemployeectrl(NMHDR* pNMHDR, LRESULT* pResult)
{
// TODO: Add your control notification handler code here
*pResult = 0;
}
////////////////////////////////////////////////////////////////////////////
BOOL CBoss::OnInitDialog()
{
CDialog::OnInitDialog();
m_bossprojectctrl.InsertColumn(0,"工程號",LVCFMT_LEFT,100);
m_bossprojectctrl.InsertColumn(1,"工程名",LVCFMT_LEFT,100);
m_bossprojectctrl.InsertColumn(2,"項目經理",LVCFMT_LEFT,100);
m_bossprojectctrl.InsertColumn(3,"合同經費",LVCFMT_LEFT,100);
m_bossprojectctrl.InsertColumn(4,"類型",LVCFMT_LEFT,100);
m_bossprojectctrl.InsertColumn(5,"簽訂時間",LVCFMT_LEFT,100);
m_bossprojectctrl.InsertColumn(6,"應完成時間",LVCFMT_LEFT,100);
m_bossprojectctrl.InsertColumn(7,"驗收時間",LVCFMT_LEFT,100);
m_bossprojectctrl.InsertColumn(8,"備注",LVCFMT_LEFT,100);
CString str1 = "select * from Project";
CPojectSet m_bossprojectSet(&m_db);
if(!m_bossprojectSet.Open(CRecordset::dynaset,str1))
{
AfxMessageBox("");
return false;
}
m_bossprojectSet.MoveFirst();
int nItem0;
while(!m_bossprojectSet.IsEOF())
{
CString pno,pName,peno,pcost,pkind,pdaty,psfinish,pfinish,pother;
m_bossprojectSet.GetFieldValue((short)0,pno);
m_bossprojectSet.GetFieldValue((short)1,pName);
m_bossprojectSet.GetFieldValue((short)2,peno);
m_bossprojectSet.GetFieldValue((short)3,pcost);
m_bossprojectSet.GetFieldValue((short)4,pkind);
m_bossprojectSet.GetFieldValue((short)5,pdaty);
m_bossprojectSet.GetFieldValue((short)6,psfinish);
m_bossprojectSet.GetFieldValue((short)7,pfinish);
m_bossprojectSet.GetFieldValue((short)8,pother);
nItem0 = m_bossprojectctrl.InsertItem(0,pno);
m_bossprojectctrl.SetItemText(nItem0,1,pName);
m_bossprojectctrl.SetItemText(nItem0,2,peno);
m_bossprojectctrl.SetItemText(nItem0,3,pcost);
m_bossprojectctrl.SetItemText(nItem0,4,pkind);
m_bossprojectctrl.SetItemText(nItem0,5,pdaty);
m_bossprojectctrl.SetItemText(nItem0,6,psfinish);
m_bossprojectctrl.SetItemText(nItem0,7,pfinish);
m_bossprojectctrl.SetItemText(nItem0,8,pother);
m_bossprojectSet.MoveNext();
}
m_bossprojectSet.Close();
////////////////////////////////////////////////////////////////////
m_bossmainctrl.InsertColumn(0,"項目號",LVCFMT_LEFT,100);
m_bossmainctrl.InsertColumn(1,"項目名",LVCFMT_LEFT,100);
m_bossmainctrl.InsertColumn(2,"項目經理號",LVCFMT_LEFT,100);
m_bossmainctrl.InsertColumn(3,"供貨商號",LVCFMT_LEFT,100);
m_bossmainctrl.InsertColumn(4,"資料號",LVCFMT_LEFT,100);
CString str2 = "select * from Main";
CMain m_bossmain(&m_db);
if(!m_bossmain.Open(CRecordset::dynaset,str2))
{
AfxMessageBox("");
return false;
}
m_bossmain.MoveFirst();
int nItem1;
while(!m_bossmain.IsEOF())
{
CString mpno,mpname,meno,mcsno,mnno;
m_bossmain.GetFieldValue((short)0,mpno);
m_bossmain.GetFieldValue((short)1,meno);
m_bossmain.GetFieldValue((short)2,meno);
m_bossmain.GetFieldValue((short)3,mcsno);
m_bossmain.GetFieldValue((short)4,mnno);
nItem1 = m_bossmainctrl.InsertItem(0,mpno);
m_bossmainctrl.SetItemText(nItem1,1,mpname);
m_bossmainctrl.SetItemText(nItem1,2,meno);
m_bossmainctrl.SetItemText(nItem1,3,mcsno);
m_bossmainctrl.SetItemText(nItem1,4,mnno);
m_bossmain.MoveNext();
}
////////////////////////////////////////
m_employeelistctrl.InsertColumn(0,"職工號",LVCFMT_LEFT,100);
m_employeelistctrl.InsertColumn(1,"姓名",LVCFMT_LEFT,100);
m_employeelistctrl.InsertColumn(2,"性別",LVCFMT_LEFT,100);
m_employeelistctrl.InsertColumn(3,"年齡",LVCFMT_LEFT,100);
m_employeelistctrl.InsertColumn(4,"合同號",LVCFMT_LEFT,100);
m_employeelistctrl.InsertColumn(5,"部門",LVCFMT_LEFT,100);
m_employeelistctrl.InsertColumn(6,"職務",LVCFMT_LEFT,100);
m_employeelistctrl.InsertColumn(7,"備注",LVCFMT_LEFT,100);
CString str3 = "select * from Employee";
CDatabaseset m_bossempolyeelist(&m_db);
if(!m_bossempolyeelist.Open(CRecordset::dynaset,str3))
{
AfxMessageBox("");
return false;
}
m_bossempolyeelist.MoveFirst();
int nItem2;
while(!m_bossempolyeelist.IsEOF())
{
CString eno,ename,esex,eage,econtract,esector,eduty,eother;
m_bossempolyeelist.GetFieldValue((short)0,eno);
m_bossempolyeelist.GetFieldValue((short)1,ename);
m_bossempolyeelist.GetFieldValue((short)2,esex);
m_bossempolyeelist.GetFieldValue((short)3,eage);
m_bossempolyeelist.GetFieldValue((short)4,econtract);
m_bossempolyeelist.GetFieldValue((short)5,esector);
m_bossempolyeelist.GetFieldValue((short)6,eduty);
m_bossempolyeelist.GetFieldValue((short)7,eother);
nItem2 = m_employeelistctrl.InsertItem(0,eno);
m_employeelistctrl.SetItemText(nItem2,1,ename);
m_employeelistctrl.SetItemText(nItem2,2,esex);
m_employeelistctrl.SetItemText(nItem2,3,eage);
m_employeelistctrl.SetItemText(nItem2,4,econtract);
m_employeelistctrl.SetItemText(nItem2,5,esector);
m_employeelistctrl.SetItemText(nItem2,6,eduty);
m_employeelistctrl.SetItemText(nItem2,7,eother);
m_bossempolyeelist.MoveNext();
}
//////////////////////////////////////////////////////////////////////////
m_bosscostnumberctrl.InsertColumn(0,"項目號",LVCFMT_LEFT,100);
m_bosscostnumberctrl.InsertColumn(1,"采購名",LVCFMT_LEFT,100);
m_bosscostnumberctrl.InsertColumn(2,"費用",LVCFMT_LEFT,100);
m_bosscostnumberctrl.InsertColumn(3,"供應商號",LVCFMT_LEFT,100);
m_bosscostnumberctrl.InsertColumn(4,"備注",LVCFMT_LEFT,100);
CString str4 = "select * from CostNumber";
CCostNumber m_bosscostnumber(&m_db);
if(!m_bosscostnumber.Open(CRecordset::dynaset,str4))
{
AfxMessageBox("");
return false;
}
m_bosscostnumber.MoveFirst();
int nItem3;
while(!m_bosscostnumber.IsEOF())
{
CString cpno,cname,ccost,csno,cother;
m_bosscostnumber.GetFieldValue((short)0,cpno);
m_bosscostnumber.GetFieldValue((short)1,cname);
m_bosscostnumber.GetFieldValue((short)2,ccost);
m_bosscostnumber.GetFieldValue((short)3,csno);
m_bosscostnumber.GetFieldValue((short)4,cother);
nItem3 = m_bosscostnumberctrl.InsertItem(0,cpno);
m_bosscostnumberctrl.SetItemText(nItem3,1,cname);
m_bosscostnumberctrl.SetItemText(nItem3,2,ccost);
m_bosscostnumberctrl.SetItemText(nItem3,3,csno);
m_bosscostnumberctrl.SetItemText(nItem3,4,cother);
m_bosscostnumber.MoveNext();
}
//////////////////////////////////////////////////////////////////////////
m_bossnotectrl.InsertColumn(0,"項目名",LVCFMT_LEFT,100);
m_bossnotectrl.InsertColumn(1,"編號",LVCFMT_LEFT,100);
m_bossnotectrl.InsertColumn(2,"資料名",LVCFMT_LEFT,100);
m_bossnotectrl.InsertColumn(3,"保管人",LVCFMT_LEFT,100);
m_bossnotectrl.InsertColumn(4,"存放地",LVCFMT_LEFT,100);
m_bossnotectrl.InsertColumn(5,"入庫時間",LVCFMT_LEFT,100);
CString str5 = "select * from Note2";
CNote m_bossnote(&m_db);
if(!m_bossnote.Open(AFX_DB_USE_DEFAULT_TYPE,str5))
{
AfxMessageBox("");
return false;
}
m_bossnote.MoveFirst();
int nItem4;
while(!m_bossnote.IsEOF())
{
CString npno,nno,nname,nmanager,nplace,ndaty;
m_bossnote.GetFieldValue((short)0,npno);
m_bossnote.GetFieldValue((short)1,nno);
m_bossnote.GetFieldValue((short)2,nname);
m_bossnote.GetFieldValue((short)3,nmanager);
m_bossnote.GetFieldValue((short)4,nplace);
m_bossnote.GetFieldValue((short)5,ndaty);
nItem4 = m_bossnotectrl.InsertItem(0,npno);
m_bossnotectrl.SetItemText(nItem4,1,nno);
m_bossnotectrl.SetItemText(nItem4,2,nname);
m_bossnotectrl.SetItemText(nItem4,3,nmanager);
m_bossnotectrl.SetItemText(nItem4,4,nplace);
m_bossnotectrl.SetItemText(nItem4,5,ndaty);
m_bossnote.MoveNext();
}
//////////////////////////////////////////////////////
return true;
}
void CBoss::OnMain()
{
// TODO: Add your control notification handler code here
CMainctrl m_mainctrl;
m_mainctrl.DoModal();
}
void CBoss::OnProject()
{
// TODO: Add your control notification handler code here
CProjectctrl m_projectctrl;
m_projectctrl.DoModal();
}
void CBoss::OnButton3()
{
// TODO: Add your control notification handler code here
CBossNoteCtrl m_bossnotectrl;
m_bossnotectrl.DoModal();
}
void CBoss::OnCost()
{
// TODO: Add your control notification handler code here
CCostCtr m_bosscost;
m_bosscost.DoModal();
}
void CBoss::OnEmployees()
{
// TODO: Add your control notification handler code here
CEmployeectrl m_bossemploy;
m_bossemploy.DoModal();
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -