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();
}