// CGetSqlFromDbDlg.h : 頭文件
//

#pragma once
#include "afxwin.h"
#include "mysql.h"
#include "ProcessDlg.h"


// CCGetSqlFromDbDlg 對話框
class CCGetSqlFromDbDlg : public CDialog
{
// 構造
public:
	CCGetSqlFromDbDlg(CWnd* pParent = NULL);	// 標準構造函數
	~CCGetSqlFromDbDlg();

// 對話框數據
	enum { IDD = IDD_CGETSQLFROMDB_DIALOG };

	protected:
	virtual void DoDataExchange(CDataExchange* pDX);	// DDX/DDV 支持


// 實現
protected:
	HICON m_hIcon;

	// 生成的消息映射函數
	virtual BOOL OnInitDialog();
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	DECLARE_MESSAGE_MAP()
public:
	CEdit m_edtFormat;
	CEdit m_edtFrom;
	CEdit m_edtKey;
	CEdit m_edtPer;
	CEdit m_edtPro;
	CEdit m_edtTable;
	CEdit m_edtTo;
	CButton m_rdoAll;
	CButton m_rdoKey;

private:
	void SwitchInput(void);
	void GetValueFromControl(void);
	CString m_sFormat;
	CString m_sFrom;
	CString m_sKey;
	CString m_sPer;
	CString m_sPro;
	CString m_sTable;
	CString m_sTo;

	MYSQL m_mysql;
	MYSQL_RES *m_pQuery;
	MYSQL_ROW m_row;
	MYSQL_FIELD *m_pField;

	static UINT GetSqlTxt(LPVOID lparam);

	int m_nCols;

	CProcessDlg *m_pDlg;

public:
	afx_msg void OnBnClickedOk();
	afx_msg void OnBnClickedRadioAll();
};