// OCIExampleDlg.h : header file
//
#include <oci.h>
//{{AFX_INCLUDES()
#include "msflexgrid.h"
//}}AFX_INCLUDES

#if !defined(AFX_OCIEXAMPLEDLG_H__30463110_E105_4F33_A30F_32C45790C83E__INCLUDED_)
#define AFX_OCIEXAMPLEDLG_H__30463110_E105_4F33_A30F_32C45790C83E__INCLUDED_

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

/////////////////////////////////////////////////////////////////////////////
// COCIExampleDlg dialog

class COCIExampleDlg : public CDialog
{
// Construction
public:
	OCIEnv		*envhp;		//環(huán)境句柄
	OCIServer	*srvhp;		//服務(wù)器句柄
	OCISvcCtx	*svchp;		//服務(wù)環(huán)垅句柄
	OCIError	*errhp;		//錯(cuò)誤句柄
	OCISession	*authp;		//會(huì)話句柄
	OCIStmt 	*stmthp;	//語(yǔ)句句柄
	OCIDescribe *dschp;		//描述句柄
	
	OCIDefine	*defhp[20];		//定義句柄
	OCIBind		*bidhp [20];		//綁定句柄
	OCIParam	*colhp;			//列句柄
	ub2			collen[30];		//列長(zhǎng)度
	ub2			coltype [30];		//列類(lèi)型
	text		*colbuf[30];  		//存放SELECT語(yǔ)句選中的列數(shù)據(jù)
	sb2			ind[30];			//指示符變量
	//存儲(chǔ)表的字段名稱(chēng)
	CString ColName [50];		//存儲(chǔ)表的字段名稱(chēng)
	CString CoIType [50];		//存儲(chǔ)字段的的數(shù)據(jù)類(lèi)型
	CString ColVal [50][100];	//存儲(chǔ)表的字段值
	text textSQL[1024];     
	ub4			col_num;		//存放SELECT語(yǔ)句選中的列數(shù)

	sword status;               //存放函數(shù)執(zhí)行后的返回代碼
	CString SQL;                //存儲(chǔ)SQL語(yǔ)句
	COCIExampleDlg(CWnd* pParent = NULL);	// standard constructor

// Dialog Data
	//{{AFX_DATA(COCIExampleDlg)
	enum { IDD = IDD_OCIEXAMPLE_DIALOG };
	CComboBox	m_CombolCondition;
	CComboBox	m_CombolFieldName;
	CMSFlexGrid	m_grid;
	CString	m_strUserName;
	CString	m_strServerName;
	CString	m_strPassword;
	int		m_english;
	CString	m_name;
	int		m_politics;
	int		m_speciality1;
	int		m_speciality2;
	int		m_totalscore;
	int		m_sortStyle;
	CString	m_strFiledvalue;
	//}}AFX_DATA

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

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(COCIExampleDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnButtonConnect();
	afx_msg void OnDestroy();
	afx_msg void OnButtonExit();
	afx_msg void OnClickMsflexgrid();
	afx_msg void OnButtonAdd();
	afx_msg void OnChangeEditEnglish();
	afx_msg void OnChangeEditPolitics();
	afx_msg void OnChangeEditSpeciality1();
	afx_msg void OnChangeEditSpeciality2();
	afx_msg void OnButtonModify();
	afx_msg void OnButtonDelete();
	afx_msg void OnRadioAsc();
	afx_msg void OnRadioDesc();
	afx_msg void OnButtonSort();
	afx_msg void OnButtonQuery();
	DECLARE_EVENTSINK_MAP()
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
private:
	void Init_condition();
	void Init_OCI();
	void Init_Grid();
	void ErrorProc(dvoid *err, sword status);
};

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

#endif // !defined(AFX_OCIEXAMPLEDLG_H__30463110_E105_4F33_A30F_32C45790C83E__INCLUDED_)