identitycardquerydlg.h

IdentityCardQuery是一个基于ado身份证查询系统,包括多表操作,查询,添加,删除等.

// IdentityCardQueryDlg.h : header file
//

#if !defined(AFX_IDENTITYCARDQUERYDLG_H__48A52101_09FF_4281_A6EA_7E0E93F94351__INCLUDED_)
#define AFX_IDENTITYCARDQUERYDLG_H__48A52101_09FF_4281_A6EA_7E0E93F94351__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

#include "BtnST.h"
/////////////////////////////////////////////////////////////////////////////
// CIdentityCardQueryDlg dialog
#include "ado2.h"
#include "CheckComboBox.h"
#include <vector>
using namespace std;
class CIdentityCardQueryDlg : public CDialog
{
// Construction
public:
	CIdentityCardQueryDlg(CWnd* pParent = NULL);	// standard constructor

private:
// Dialog Data
	//{{AFX_DATA(CIdentityCardQueryDlg)
	enum { IDD = IDD_IDENTITYCARDQUERY_DIALOG };
	CComboBox	m_comDelType;
	CCheckComboBox	m_comTableQuery;
	CComboBox	m_comTableName;
	CButtonST	m_BT_Query;
	CButtonST	m_BT_Add;
	CButtonST	m_BT_DELETE;
	CButtonST	m_BT_OK;
	CComboBox	m_ComSexType;
	CComboBox	m_comType;
	CListCtrl	m_DataListCtrl;
	CString	m_strData;
	CString	m_strID;
	CString	m_strName;
	CString	m_strPace;
	int		m_nAge;
	BOOL	m_bSelectAll;
	CString	m_strDelInfo;
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CIdentityCardQueryDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);	// DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CIdentityCardQueryDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnBtQuery();
	afx_msg void OnBtDelete();
	afx_msg void OnBtAdd();
	afx_msg void OnSelchangetype();
	afx_msg void OnBtAddtable();
	afx_msg void OnCheckAll();
	virtual void OnCancel();
	afx_msg void OnSelchangeComboDeltype();
	afx_msg void OnItemchangedListData(NMHDR* pNMHDR, LRESULT* pResult);
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()

private:
	CADORecordset m_pRs;
	CADODatabase m_pDb;
	bool m_bConnect;//连接上数据库为真
	CStringArray m_accessTableArray;//保存所有的表名字

	void InitDataList();
	bool  CheckData();
	void InsertOneRow(int row, CString strID, CString strName,CString strSex,CString strAge,CString strPace);
	void DeleteOneRecordByID(CString strID);
	void DeleteOneRecordByName(CString strID);
	void DeleteAllRecord();
	void AddOneRecord(CString tablename,CString strID, CString strName,CString strSex,CString strAge,CString strPace);
	bool CheckID(CString strID,bool bAddData);
	int  QueryandChangeRecordByID(CStringArray& tablename,CString strID,CString strName,CString strSex,CString strAge,CString strPace);
	void SetPopedom();
	CString GetExePath();
	void InitAllTable();
	void CheckTableByName(CString tablename);
	CString FormatTable(CStringArray& tablearray);
	bool CheckTableName(CString tablename);
	void UpdateListDataEx(CString strID,int iSubItem);


};

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_IDENTITYCARDQUERYDLG_H__48A52101_09FF_4281_A6EA_7E0E93F94351__INCLUDED_)