cgetsqlfromdbdlg.h

自定义格式读取mysql数据库记录。用于批量处理mysql数据库。

// 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();
};