bumen.cpp

管理类软件,入门咯.公司管理系统MFC开发设计,轻松学会

// BUMEN.cpp : implementation file
//

#include "stdafx.h"
#include "B05050727.h"
#include "BUMEN.h"
#include "ADDBUMEN.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBUMEN dialog


CBUMEN::CBUMEN(CWnd* pParent /*=NULL*/)
	: CDialog(CBUMEN::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBUMEN)
	//}}AFX_DATA_INIT
}


void CBUMEN::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBUMEN)
	DDX_Control(pDX, IDSHANCHU1, m_shanchu1);
	DDX_Control(pDX, IDC_LIST1, m_bumen);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBUMEN, CDialog)
	//{{AFX_MSG_MAP(CBUMEN)
	ON_BN_CLICKED(IDCHAXUN1, OnChaxun1)
	ON_BN_CLICKED(IDTIANJIA1, OnTianjia1)
	ON_BN_CLICKED(IDSHANCHU1, OnShanchu1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBUMEN message handlers

void CBUMEN::OnChaxun1() 
{
	// TODO: Add your control notification handler code here
	m_shanchu1.EnableWindow(true);
	m_bumen.InsertColumn(0,"部门");
	m_bumen.InsertColumn(1,"部门名");
	m_bumen.InsertColumn(2,"部门的电话号码");
	
	CRect rect;
	GetWindowRect(&rect);
	int x=rect.right-rect.left;
	m_bumen.SetColumnWidth(0,x/3); 
	m_bumen.SetColumnWidth(1,x/3); 
	m_bumen.SetColumnWidth(2,x/3); 
	m_bumen.DeleteAllItems();
	
	m_bumen.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
	//初始化结束
	
	CoInitialize(NULL);
	_ConnectionPtr pconnect(__uuidof(Connection));
	_RecordsetPtr record(__uuidof(Recordset));	
	_CommandPtr comd(__uuidof(Command));
	pconnect->ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=人事";
	pconnect->Open("","","",NULL);
	comd->put_ActiveConnection(_variant_t((IDispatch *)pconnect));
	comd->CommandText="select * from 部门";//得到SQL语句
	record=comd->Execute(NULL,NULL,adCmdText);
	while(!record->end)
	{
		
		m_bumen.InsertItem(0,(_bstr_t)record->GetCollect("部门号"));
		m_bumen.SetItemText(0,1,(_bstr_t)record->GetCollect("部门名"));
		m_bumen.SetItemText(0,2,(_bstr_t)record->GetCollect("电话号码"));
		record->MoveNext();
	}
	
	record->Close();
	pconnect->Close();
	comd.Release();
	record.Release();
	pconnect.Release();
	CoUninitialize();

}

void CBUMEN::OnTianjia1() 
{
	// TODO: Add your control notification handler code here
	CADDBUMEN dlg;
	dlg.DoModal();
}

void CBUMEN::OnShanchu1() 
{
	// TODO: Add your control notification handler code here
	
	// TODO: Add your control notification handler code here
	int n=m_bumen.GetItemCount();//存储的记录数目
	if (n==0)
	{
		AfxMessageBox("记录为空");
		CDialog::OnOK();
	}
	else
	{
		POSITION pos1= m_bumen.GetFirstSelectedItemPosition();
		int nSel=-1;
		if (n==1)
			nSel=0;
		else
			nSel = m_bumen.GetNextSelectedItem(pos1);
		if (nSel==-1)
		{
			AfxMessageBox("请选择所要删除的记录");
		}
		else
		{
			if(IDOK==MessageBox("删除部门后，所有相关员工信息将全部删除？", "提示", MB_OKCANCEL))
			{
				CString str=m_bumen.GetItemText(nSel,0);
				CoInitialize(NULL);
				_ConnectionPtr pconnect(__uuidof(Connection));
				_CommandPtr comd(__uuidof(Command));
				pconnect->ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=人事";
				pconnect->Open("","","",NULL);
				comd->put_ActiveConnection(_variant_t((IDispatch *)pconnect));
				//首先删除员工表工相关信息
				CString cmd="DELETE FROM  职工 where 部门号=";
				
				cmd+="'";cmd+=str;cmd+="'";
				comd->CommandText=_bstr_t(cmd);
				comd->Execute(NULL,NULL,adCmdText);
				
				cmd="DELETE FROM  部门 where 部门号=";
				cmd+="'";cmd+=str;cmd+="'";
				comd->CommandText=_bstr_t(cmd);
				comd->Execute(NULL,NULL,adCmdText);
				
				pconnect->Close();
				comd.Release();
				pconnect.Release();
				CoUninitialize();
				AfxMessageBox("删除成功");
				CDialog::OnOK();
			}
		}
	}
	
		
		
}