menu_queryremovedlg.cpp

VC++和ACCESS使用ADO连接

// Menu_QueryRemoveDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ministryperson.h"
#include "Menu_QueryRemoveDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// Menu_QueryRemoveDlg dialog
Menu_InputRemInfoDlg MenuInPutDlg;

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

void Menu_QueryRemoveDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Menu_QueryRemoveDlg)
	DDX_Control(pDX, IDC_MENU4_AR_LIST, m_Menu4_AR_List);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Menu_QueryRemoveDlg, CDialog)
	//{{AFX_MSG_MAP(Menu_QueryRemoveDlg)
	ON_MESSAGE(UM_LISTEDIT_DBCLICK, OnListEditDBClick)
	ON_BN_CLICKED(IDC_MENU4_AR_QUERY, OnMenu4ArQuery)
	ON_BN_CLICKED(IDC_MENU4_AR_MOREINFO, OnMenu4ArMoreinfo)
	ON_NOTIFY(NM_CLICK, IDC_MENU4_AR_LIST, OnClickMenu4ArList)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Menu_QueryRemoveDlg message handlers

BOOL Menu_QueryRemoveDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	GetDlgItem(IDC_MENU4_AR_LIST)->EnableWindow(FALSE);
	MakeShowStyle();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

/*********************************************************************
函数说明:	  清空数据表的显示
函数参数:	  void
*********************************************************************/
BOOL Menu_QueryRemoveDlg::DeleteAllRows()
{
	m_Menu4_AR_List.DeleteAllItems();	// 清空列表控件
	return TRUE;
}

/*********************************************************************
函数说明:	  设置列表控件一行的内容
函数参数:	  
*********************************************************************/
BOOL Menu_QueryRemoveDlg::SetRow(int row, CString *strArray, int nCount)
{
	m_Menu4_AR_List.InsertItem(row, strArray[0]);			// 在列表控件中插入一行
	for (int i = 1; i < nCount; i++)
	{
		m_Menu4_AR_List.SetItemText(row, i, strArray[i]);	// 设置除第一行外的其他行
	}
	return TRUE;
}

/*********************************************************************
函数说明:	  显示内容
函数参数:	  
*********************************************************************/
void Menu_QueryRemoveDlg::MakeShowStyle()
{
	m_Menu4_AR_List.SetExtendedStyle(LVS_EX_FLATSB | 
									  LVS_EX_GRIDLINES | 
									  LVS_EX_FULLROWSELECT | 
									  LVS_EX_ONECLICKACTIVATE);
	m_Menu4_AR_List.InsertColumn(0, "姓名", LVCFMT_LEFT, 50);
	m_Menu4_AR_List.InsertColumn(1, "身份证", LVCFMT_LEFT, 145);
	m_Menu4_AR_List.InsertColumn(2, "性别", LVCFMT_LEFT, 50);
	m_Menu4_AR_List.InsertColumn(3, "单位", LVCFMT_LEFT, 100);
	m_Menu4_AR_List.InsertColumn(4, "部门", LVCFMT_LEFT, 122);
	m_Menu4_AR_List.InsertColumn(5, "职务", LVCFMT_LEFT, 80);	
}
/*********************************************************************
函数说明:	  [按钮] 查询姓名
函数参数:	  
*********************************************************************/
void Menu_QueryRemoveDlg::OnMenu4ArQuery() 
{
	CString strName;
	GetDlgItemText(IDC_MENU4_AR_EDIT_NAME, strName);
	strName.TrimLeft();
	if (strName.IsEmpty())
	{
		MessageBox("请填写一个人员姓名\t", "提示", MB_ICONEXCLAMATION | MB_OK);
		return;
	}	

	CADOOperation ADOdbo;
	CString SQL;
	CString strFields[] = {"Name", "IDCard", "Sex", "Company", "Depart", "Duty"};
	SQL.Format("select Employee_BasicInfor_Table.employee_Name as Name, \
					   Employee_BasicInfor_Table.employee_IDCard as IDCard, \
					   Employee_BasicInfor_Table.employee_Sex as Sex, \
					   Employee_InActiveSer_Table.InActiveSer_Company as Company, \
					   Employee_InActiveSer_Table.InActiveSer_Department as Depart, \
					   Employee_InActiveSer_Table.InActiveSer_Duty as Duty \
				from Employee_BasicInfor_Table, Employee_InActiveSer_Table \
				where Employee_BasicInfor_Table.employee_ID = Employee_InActiveSer_Table.employee_ID and \
					  Employee_BasicInfor_Table.employee_IDCard = Employee_InActiveSer_Table.employee_IDCard and \
					  Employee_BasicInfor_Table.employee_Name = '%s'", strName);
	ADOdbo.OpenRecordset(SQL);
	ADOdbo.ShowADOView(strFields, 6, this);
	ADOdbo.CloseRecorset();
	GetDlgItem(IDC_MENU4_AR_LIST)->EnableWindow(TRUE);
}

int g_nAddRem = -1;
/*********************************************************************
函数说明:	  [按钮] 打开调动添加表
函数参数:	  
*********************************************************************/
void Menu_QueryRemoveDlg::OnMenu4ArMoreinfo() 
{
	if (g_nAddRem < 0)
	{
		MessageBox("请选择在表中选择一项\t", "提示", MB_OK | MB_ICONEXCLAMATION);
		return;
	}
	else
	{
		MenuInPutDlg.DoModal();
	}	
}

/*********************************************************************
函数说明:	  双击
函数参数:	  
*********************************************************************/
LRESULT Menu_QueryRemoveDlg::OnListEditDBClick(WPARAM wParam, LPARAM lParam)
{
	LPNMLISTVIEW lpnmlv = (LPNMLISTVIEW)wParam;
	
	MenuInPutDlg.m_strName   = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 0);
	MenuInPutDlg.m_strIDCard = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 1);
	MenuInPutDlg.m_strSex    = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 2);
	MenuInPutDlg.m_strOldCompany = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 3);
	MenuInPutDlg.m_strOldDepart = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 4);
	MenuInPutDlg.m_strOldDuty = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 5);
	
	MenuInPutDlg.DoModal();
	return TRUE;
}

/*********************************************************************
函数说明:	  单击
函数参数:	  
*********************************************************************/
void Menu_QueryRemoveDlg::OnClickMenu4ArList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	LPNMLISTVIEW lpnmlv = (LPNMLISTVIEW)pNMHDR;
	g_nAddRem = lpnmlv->iItem;

	MenuInPutDlg.m_strName   = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 0);
	MenuInPutDlg.m_strIDCard = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 1);
	MenuInPutDlg.m_strSex    = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 2);
	MenuInPutDlg.m_strOldCompany = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 3);
	MenuInPutDlg.m_strOldDepart = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 4);
	MenuInPutDlg.m_strOldDuty = m_Menu4_AR_List.GetItemText(lpnmlv->iItem, 5);

	*pResult = 0;
}