// QueryDlg.cpp : implementation file
//

#include "stdafx.h"
#include "GSMTest.h"
#include "QueryDlg.h"
#include "winsock.h"
#include <mysql.h>
#include "database.h"
#include "Querylist.h"
//#include "data.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CQueryDlg dialog


CQueryDlg::CQueryDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CQueryDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CQueryDlg)
	m_date = _T("");
	m_place = _T("");
	m_shape = _T("");
	//}}AFX_DATA_INIT
}


void CQueryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQueryDlg)
	DDX_Text(pDX, IDC_EDIT_DATE, m_date);
	DDX_Text(pDX, IDC_EDIT_PLACE, m_place);
	DDX_Text(pDX, IDC_EDIT_SHAPE, m_shape);
	DDX_Text(pDX, IDC_TRANSID, m_year);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQueryDlg, CDialog)
	//{{AFX_MSG_MAP(CQueryDlg)
	ON_BN_CLICKED(IDC_PUT, OnPut)
	ON_BN_CLICKED(IDC_DATE, OnDatequery)
	ON_BN_CLICKED(IDC_PLACEB, OnPlacebquery)
	ON_BN_CLICKED(IDC_SHAPE, OnShapequery)
	ON_BN_CLICKED(IDC_YEAR_DATE, OnYearDatequery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQueryDlg message handlers

void CQueryDlg::OnPut() 
{
	// TODO: Add your control notification handler code here
/*	CDatabase1 database;
	database.ConnectDB();
		//AfxMessageBox("連接服務器成功!");			
		
		CString charset="set charset gb2312;";//使之正常顯示中文,或用set character_set_results=gb2312;
		database.ExecuteSQL(charset,charset.GetLength());//執行語句.

		Data_Param result;	
		CString def;
		
		result.tab_name="trans_info";
		result.select_exp="TRANS_TEL";
			def.Format("trans_tel=%s",m_sTansID);

		result.where_def=def.GetBuffer(30);
		
		if(database.SelectAll(&result))
		{
            MYSQL_ROW row=database.GetRecord();
			CString telnum=row[0];
		}*/
	   UpdateData(TRUE); //賦值 
      CQuerylist dlg;
      dlg.year=m_year;
	  dlg.k=1;
	  dlg.DoModal();
	  



	
}

void CQueryDlg::OnDatequery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE); //賦值 
      CQuerylist dlg;
      dlg.year=m_date;
	  dlg.k=2;
	  dlg.DoModal();
	
}

void CQueryDlg::OnPlacebquery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE); //賦值 
      CQuerylist dlg;
      dlg.year=m_place;
	  dlg.k=5;
	  dlg.DoModal();
	
}

void CQueryDlg::OnShapequery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE); //賦值 
      CQuerylist dlg;
      dlg.year=m_shape;
	  dlg.k=4;
	  dlg.DoModal();
	
}

void CQueryDlg::OnYearDatequery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE); //賦值 
      CQuerylist dlg;
      dlg.year="年"+m_year+"月"+m_date+"日";
	  dlg.k=3;
	  dlg.DoModal();
	
}