query.h

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

//{{AFX_INCLUDES()
#include "rsgrid1.h"
//}}AFX_INCLUDES
#if !defined(AFX_QUERY_H__6A557F66_E402_4051_A2A6_0FC4494559F4__INCLUDED_)
#define AFX_QUERY_H__6A557F66_E402_4051_A2A6_0FC4494559F4__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
// QUERY.h : header file
//
#include "DBManagerDlg.h"
/////////////////////////////////////////////////////////////////////////////
// CQUERY dialog

class CQUERY : public CDialog
{
// Construction
public:
	CQUERY(CWnd* pParent = NULL);   // standard constructor
	CDatabase * m_query_pCDataBase;
	CDatabase * m_QueryDataBase;
	CDynamicBulkSet * m_pDynamicBulkSet;
	
	int m_item;
	int m_item_del;
	int m_iCount_begin;
	int m_iCount_begin_commision;
	int m_iCount_begin_use;

	int m_iCount_end;
	int m_iCount_end_commision;
	int m_iCount_end_use;

	int m_iCount_sel_begin;
	int m_iCount_sel_begin_commision;
	int m_iCount_sel_begin_use;

	
	int m_iCount_sel_end;
	int m_iCount_sel_end_commision;
	int m_iCount_sel_end_use;

	int m_iCount_chazhi;
	int m_iCount_chazhi_use;
	int m_iCount_chazhi_commision;

	CString m_csBegin_all;
	CString m_csBegin;
	CString m_csEnd_all;
	CString m_csEnd;
	CString m_csLianxi;

	CString m_csMobileNum;
	int		m_iMoney;
	CString m_csMoney;
	CString m_csContentZiduan;
	BOOL m_bFlag_end;
	BOOL m_bFlag_end_use;
	BOOL m_bFlag_end_commision;

	CString csContent_list;
	CStringArray csarrayConetent_list;
	// Dialog Data
	//{{AFX_DATA(CQUERY)
	enum { IDD = IDD_DIALOG3 };
	CComboBox	m_EndUse;
	CComboBox	m_EndCommision;
	CComboBox	m_BeginUse;
	CComboBox	m_BeginCommision;
	CListCtrl	m_list_ziduan;
	CListCtrl	m_list_all_ziduan;
	CComboBox	m_endtime;
	CComboBox	m_begintime;
	CComboBox	m_person_lianxi;
	CRsGrid	m_list_showdata;
	CString	m_MobileNum;
	CString	m_MobileNum2;
	long	m_sUseMoney;
	long	m_sCommisionMoney;
	//}}AFX_DATA
	#define biaoming "whole";

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

// Implementation
protected:

	// Generated message map functions
	//{{AFX_MSG(CQUERY)
	virtual BOOL OnInitDialog();
	afx_msg void OnItemchangedListAllZiduan(NMHDR* pNMHDR, LRESULT* pResult);
	afx_msg void OnClickListAllZiduan(NMHDR* pNMHDR, LRESULT* pResult);
	afx_msg void OnButtonAdd();
	afx_msg void OnItemchangedListZiduan(NMHDR* pNMHDR, LRESULT* pResult);
	afx_msg void OnSelchangeComboBegintime();
	afx_msg void OnSelchangeComboEndtime();
	afx_msg void OnSelchangeComboPersonLianxi();
	afx_msg void OnButtonQianfei();
	afx_msg void OnButton3();
	afx_msg void OnButton6();
	afx_msg void OnButtonRuwang();
	afx_msg void OnButtonUse();
	afx_msg void OnEditchangeComboBegintimeUse();
	afx_msg void OnEditchangeComboEndtimeUse();
	afx_msg void OnEditchangeComboBegintimeCommision();
	afx_msg void OnEditchangeComboEndtimeCommision();
	afx_msg void OnButtonCommision();
	afx_msg void OnSelchangeComboBegintimeUse();
	afx_msg void OnSelchangeComboEndtimeUse();
	afx_msg void OnSelchangeComboEndtimeCommision();
	afx_msg void OnSelchangeComboBegintimeCommision();
	afx_msg void OnLButtonUpRsgridctrlShowdata(long nFlags, long lRow, long lCol);
	virtual void OnCancel();
	afx_msg void OnButtonPrint();
	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_QUERY_H__6A557F66_E402_4051_A2A6_0FC4494559F4__INCLUDED_)