dbmanagerdlg.h

利用OLEDB以数据库的方式打开Excell文件

// DBManagerDlg.h : header file
//
//{{AFX_INCLUDES()
#include "rsgrid1.h"
//}}AFX_INCLUDES

#if !defined(AFX_DBMANAGERDLG_H__F0A3B8BD_9006_4558_A0E5_46EEFC3029DA__INCLUDED_)
#define AFX_DBMANAGERDLG_H__F0A3B8BD_9006_4558_A0E5_46EEFC3029DA__INCLUDED_

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

/////////////////////////////////////////////////////////////////////////////
// CDBManagerDlg dialog

#include "catsets.h"
#include "NewListBox.h"
#include "bulkset.h"
#include "datadlg.h"


class CDBManagerDlg : public CDialog
{
// Construction
public:
	CDBManagerDlg(CWnd* pParent = NULL);	// standard constructor
	CDatabase * m_assure_company_pCDataBase;
// Dialog Data
	//{{AFX_DATA(CDBManagerDlg)
	enum { IDD = IDD_DBMANAGER_DIALOG };
	CComboBox	m_feiyong;
	CComboBox	m_assure_company;
	CNewListBox	m_ListCtrl2;
	CListCtrl	m_ListCorrespond;
	CNewListBox	m_ListCtrl;
	CString	m_csSQL;
	CString	m_csListValue;
	CRsGrid	m_RsGridResult;
	CRsGrid	m_RsGridView;
	CString	m_phone_num;
	CRsGrid	m_RsGridView2;
	CString	m_phone_user_name;
	//}}AFX_DATA
	CDatabase   m_Database;
	CTables*    m_pTableset;
	CColumns*   m_pColumnset;
	CDynamicBulkSet * m_pDynamicBulkSet;
	int m_item;
	CString     m_csFieldName;
	CString     m_csFieldType;
	CString     m_csFieldLength;
	CString     m_csFinalData;
	int         m_iMaxFieldLength;
	CString     m_csMaxFieldLength;

	CString GetDSN();
	void	FetchColumnInfo(CString lpszName,CRsGrid &m_RsGridView);
	BOOL    FetchTableInfo();
	int     GetProfileValue(LPCTSTR lpszSection,LPCTSTR lpszItem);
	BOOL    ShowSQLData();
	void    OpenSQLResult( CString csSQL );
//	int  buf[200];
	CStringArray  buf;
	CString m_kuming;
	CString m_biaoming;
    #define kuming "whole";
	#define biaoming "whole";
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CDBManagerDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);	// DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CDBManagerDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg BOOL OnOpenDb();
	afx_msg void OnEditShowata();
	afx_msg void OnSelchangeListDb();
	afx_msg void OnButView1();
	afx_msg void OnButView2();
	afx_msg void OnButView3();
	afx_msg void OnButView4();
	afx_msg void OnExecute();
	virtual void OnCancel();
	virtual void OnOK();
	afx_msg void OnCancelMode();
	afx_msg void OnOpenConfig();
	afx_msg void OnLButtonUpRsgridctrlResult(long nFlags, long lRow, long lCol);
	afx_msg void OnLButtonDBClickRsgridctrlResult(long nFlags, long lRow, long lCol);
	afx_msg void OnGridEditedRsgridctrlResult(long iRow, long iCol, LPCTSTR lpszData);
	afx_msg void OnButton1();
	afx_msg void OnClickLISTCorrespond(NMHDR* pNMHDR, LRESULT* pResult);
	afx_msg void OnSelchangeLISTCorrespond();
	afx_msg void OnTempToWhole();
	afx_msg void OnAddtolist();
	afx_msg void OnDELETEList();
	afx_msg void OnRButtonDBClickRsgridctrlResult(long nFlags, long lRow, long lCol);
	afx_msg void OnButtonHelp();
	afx_msg void OnSelchangeListDb2();
	afx_msg void OnButton2();
	afx_msg void OnButtonQuery();
	afx_msg void OnUpdatetotal();
	DECLARE_EVENTSINK_MAP()
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

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

#endif // !defined(AFX_DBMANAGERDLG_H__F0A3B8BD_9006_4558_A0E5_46EEFC3029DA__INCLUDED_)