remotedbdlg.h

访问远程数据库MS SQLServer实例

// RemoteDBDlg.h : header file
//

#if !defined(AFX_REMOTEDBDLG_H__033E01E8_E320_4157_BF19_F34072DCC529__INCLUDED_)
#define AFX_REMOTEDBDLG_H__033E01E8_E320_4157_BF19_F34072DCC529__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
///////////////////////////////////////////////////////////////////
typedef	struct Ora2AccessParam {
	CString oraODBC;
	CString accessODBC;
	CString sampleID;
	int timeInterval;
	int sampleType;	
	int proID;
	CString tableName;
	CString yuanYeSampleID;
	CString cFenSampleID;
	int iGroup;
	int connectDelay;
	int retryCount;
	HWND caller;
} TransferParam;
DWORD WINAPI ThreadProc(LPVOID pvparam);
HANDLE CreateOra2AccessThread(LPVOID ora2AccessParam,HANDLE hThread);



/////////////////////////////////////////////////////////////////////////////
// CRemoteDBDlg dialog

class CRemoteDBDlg : public CDialog
{
// Construction
public:
	void ListQueryData(CString str);
	int m_nItem;
	_RecordsetPtr m_pRecordset,m_pRecordsetMod,m_pRecordsetQuery;
	void ListData();
	void InitListCtrl();
	CRemoteDBDlg(CWnd* pParent = NULL);	// standard constructor

// Dialog Data
	//{{AFX_DATA(CRemoteDBDlg)
	enum { IDD = IDD_REMOTEDB_DIALOG };
	CEdit	m_ctrTerm2;
	CComboBox	m_ctrOper;
	CButton	m_BModifyData;
	CButton	m_BDelData;
	CListCtrl	m_Data;
	CString	m_Age;
	CString	m_Name;
	CString	m_Sex;
	CString	m_Item;
	CString	m_Oper;
	CString	m_Term;
	CString	m_Term2;
	CString	m_Hour;
	//}}AFX_DATA
	HANDLE hThread;//Oracle
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CRemoteDBDlg)
	public:
	virtual BOOL DestroyWindow();
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);	// DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CRemoteDBDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnClose();
	afx_msg void OnClickData(NMHDR* pNMHDR, LRESULT* pResult);
	afx_msg void OnDeldata();
	afx_msg void OnInsertdata();
	afx_msg void OnModifydata();
	afx_msg void OnDelalldata();
	afx_msg void OnListdata();
	afx_msg void OnSelendokItem();
	afx_msg void OnSelendokOper();
	afx_msg void OnQuery();
	afx_msg void OnImport();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

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

#endif // !defined(AFX_REMOTEDBDLG_H__033E01E8_E320_4157_BF19_F34072DCC529__INCLUDED_)