// OCIExampleDlg.h : header file
//
#include "CInsertDlg.h"

#if !defined(AFX_OCIEXAMPLEDLG_H__0E848200_58C2_432F_BB46_CD6953E269AE__INCLUDED_)
#define AFX_OCIEXAMPLEDLG_H__0E848200_58C2_432F_BB46_CD6953E269AE__INCLUDED_

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

/////////////////////////////////////////////////////////////////////////////
// COCIExampleDlg dialog
#include "oci.h"
#include "ConectDlg.h"

class COCIExampleDlg : public CDialog
{
// Construction
public:
	COCIExampleDlg(CWnd* pParent = NULL);	// standard constructor
    virtual ~COCIExampleDlg();

// Dialog Data
	//{{AFX_DATA(COCIExampleDlg)
	enum { IDD = IDD_OCIEXAMPLE_DIALOG };
	CComboBox	m_comConFNameCtrl;
	CComboBox	m_comboCtrl;
	CListCtrl	m_listCtrl;
	CListBox	m_listTablename;
	CString	m_strTablename;
	CString	m_strFieldName;
	CString	m_strcondition;
	CString	m_strFieldVal;
	CString	m_strConFName;
	CString	m_strConFVal;
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(COCIExampleDlg)
	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(COCIExampleDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnButConnectdb();
	afx_msg void OnBTableselectok();
	afx_msg void OnButQuery();
	afx_msg void OnButDelete();
	afx_msg void OnButUpdate();
	afx_msg void OnButInsert();
	afx_msg void OnSize(UINT nType, int cx, int cy);
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
public:
	void SaveInsertData(int row,int col,CString strColVal[]);
	void ErrorProc(dvoid *err, sword status);
	//代碼4.1.1:
	OCIEnv        *envhp;//環境句柄
	OCIServer     *srvhp;//服務器句柄
	OCISvcCtx     *svchp;//服務環境句柄
	OCIError      *errhp;//錯誤句柄
	OCISession    *authp;//會話句柄
	OCIStmt       *stmthp;//語句句柄
	OCIDescribe   *dschp;//描述句柄
	//代碼4.4.1:
	OCIDefine *defhp[20];//定義句柄
	OCIBind   *bidhp[20];//綁定句柄
	OCIParam *colhp;     //參數描述符
	ub2 collen[30]; //列長度
	ub2 coltype[30];//列類型 
    //存放SELECT語句選中的列數據
	text* colbuf[30];
	sb2 ind[30];//指示符變量
	//代碼5
	//存儲表的字段名稱
	CString ColName[50];
	//存儲字段的的數據類型
	CString ColType[50];
	//存儲表的字段值
	CString ColVal[50][500];
	//字段的數目
	int ColumnNumbers;
	//所選中表的名稱
	CString TableName;
	//8.1
	CCInsertDlg  *InsertDlg;
	//字段的總長度
	int iprecision[50];
	//字段的小數位數
    int      iscale[5];
	//
	int IsSizeInsertDlg;
	
		/*
	  ub1       precision;  //typedef unsigned char  ub1;                   
	  sb1       scale;  //typedef   signed char  sb1;  
   

  */

};

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

#endif // !defined(AFX_OCIEXAMPLEDLG_H__0E848200_58C2_432F_BB46_CD6953E269AE__INCLUDED_)