projectmanage.cpp

一个简单的公司员工管理系统

// ProjectManage.cpp : implementation file
//

#include "stdafx.h"
#include "SQL.h"
#include "ProjectManage.h"
#include "PojectSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CProjectManage dialog


CProjectManage::CProjectManage(CWnd* pParent /*=NULL*/)
	: CDialog(CProjectManage::IDD, pParent)
{
	//{{AFX_DATA_INIT(CProjectManage)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CProjectManage::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CProjectManage)
	DDX_Control(pDX, IDC_PROJECTLISTCTRL, m_ProjectListCtrl);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CProjectManage, CDialog)
	//{{AFX_MSG_MAP(CProjectManage)
	ON_NOTIFY(NM_CLICK, IDC_PROJECTLISTCTRL, OnClickProjectlistctrl)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CProjectManage message handlers

BOOL CProjectManage::OnInitDialog()
{
	CDialog::OnInitDialog();
    
	m_ProjectListCtrl.InsertColumn(0,"工程号",LVCFMT_LEFT,100);
	m_ProjectListCtrl.InsertColumn(1,"工程名",LVCFMT_LEFT,100);
	m_ProjectListCtrl.InsertColumn(2,"项目经理",LVCFMT_LEFT,100);
	m_ProjectListCtrl.InsertColumn(3,"合同经费",LVCFMT_LEFT,100);
	m_ProjectListCtrl.InsertColumn(4,"类型",LVCFMT_LEFT,100);
	m_ProjectListCtrl.InsertColumn(5,"签订时间",LVCFMT_LEFT,100);
	m_ProjectListCtrl.InsertColumn(6,"应完成时间",LVCFMT_LEFT,100);
	m_ProjectListCtrl.InsertColumn(7,"验收时间",LVCFMT_LEFT,100);
	m_ProjectListCtrl.InsertColumn(8,"备注",LVCFMT_LEFT,100);
    
   CString str = "select * from Project";
   CPojectSet m_projectSet(&m_db);
   if(!m_projectSet.Open(CRecordset::dynaset,str))
   {
	   AfxMessageBox("");
	   return false;
   }
   m_projectSet.MoveFirst();
  int nItem;
   while(!m_projectSet.IsEOF())
   {
	   CString pno,pName,peno,pcost,pkind,pdaty,psfinish,pfinish,pother;
	   m_projectSet.GetFieldValue((short)0,pno);
	   m_projectSet.GetFieldValue((short)1,pName);
	   m_projectSet.GetFieldValue((short)2,peno);
	   m_projectSet.GetFieldValue((short)3,pcost);
	   m_projectSet.GetFieldValue((short)4,pkind);
	   m_projectSet.GetFieldValue((short)5,pdaty);
       m_projectSet.GetFieldValue((short)6,psfinish);
	   m_projectSet.GetFieldValue((short)7,pfinish);
       m_projectSet.GetFieldValue((short)8,pother);
	   if (peno == Id)
	   {
         nItem = m_ProjectListCtrl.InsertItem(0,pno);
	     m_ProjectListCtrl.SetItemText(nItem,1,pName);
		 m_ProjectListCtrl.SetItemText(nItem,2,peno);
		 m_ProjectListCtrl.SetItemText(nItem,3,pcost);
		 m_ProjectListCtrl.SetItemText(nItem,4,pkind);
		 m_ProjectListCtrl.SetItemText(nItem,5,pdaty);
		 m_ProjectListCtrl.SetItemText(nItem,6,psfinish);
		 m_ProjectListCtrl.SetItemText(nItem,7,pfinish);
		 m_ProjectListCtrl.SetItemText(nItem,8,pother);
	     
	   }

     m_projectSet.MoveNext();
   }
   return true;

}

void CProjectManage::OnClickProjectlistctrl(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	
	*pResult = 0;
}