gangweidlg.cpp

这是一个企业人力资源管理系统设计实例！比较实用！

// GangweiDlg.cpp : implementation file
//

#include "stdafx.h"
#include "EmpMan.h"
#include "GangweiDlg.h"
#include "GangSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CGangweiDlg dialog


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


void CGangweiDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CGangweiDlg)
	DDX_Control(pDX, IDC_LIST1, m_List);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CGangweiDlg, CDialog)
	//{{AFX_MSG_MAP(CGangweiDlg)
	ON_BN_CLICKED(ID_ADD, OnAdd)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CGangweiDlg message handlers

void CGangweiDlg::OnAdd() 
{
	// TODO: Add your control notification handler code here
	CGangSet dlg;
	dlg.m_badd=true;
	dlg.DoModal();
	SelectSQL();
}

void CGangweiDlg::AddItemToList()
{
	LVITEM item;
	item.mask=LVIF_TEXT;
	item.iItem=0;
	item.iSubItem=0;
	char x[50];					//加入标题(CString->Char)
	strcpy(x,infor[0]);
	item.pszText=x;
	m_List.InsertItem(&item);
	for(int i=1;i<2;i++)
		m_List.SetItemText(0,i,infor[i]);
	m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT);

}

void CGangweiDlg::InsertColumn()
{
	LVCOLUMN column;
	column.mask=LVCF_FMT|LVCF_WIDTH|LVCF_TEXT|LVCF_SUBITEM;
	column.fmt=LVCFMT_LEFT;
	column.cx=80;
	column.iSubItem=0;
	column.pszText="岗位ID";
	m_List.InsertColumn(0,&column);
	
	column.iSubItem=1;
	column.pszText="岗位名称";
	column.cx=120;
	m_List.InsertColumn(1,&column);
	
	

}

void CGangweiDlg::SelectSQL()
{
		 CRecordset rs(&db);
   m_List.DeleteAllItems();
	CString sql;
	sql.Format("Select * From gangwei order by gangweiID desc") ;
	
	rs.Open(CRecordset::forwardOnly,sql);

	if (rs.IsEOF())
	{
		MessageBox("没有任何岗位,请设置岗位");
		
	}
	
	while(!rs.IsEOF()) // 非空则获取员工信息
	{
		CString name;
		rs.GetFieldValue("gangweiID",infor[0]); 
		rs.GetFieldValue("gangweiname",infor[1]);
		
		
		AddItemToList();
		rs.MoveNext();
		
		
	}
	rs.Close();


}

BOOL CGangweiDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	InsertColumn();
	SelectSQL();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CGangweiDlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int nChoice=m_List.GetNextItem(-1,LVNI_SELECTED);
	CGangSet dlg;
	dlg.m_id=m_List.GetItemText(nChoice,0);
	dlg.m_badd=false;
	dlg.DoModal();
	SelectSQL();
	*pResult = 0;
}