// DutyEditdlg.cpp : implementation file
//

#include "stdafx.h"
#include "GSMTest.h"
#include "DutyEditdlg.h"

#include <winsock.h>
#include <mysql.h>
#include "database.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDutyEditdlg dialog


CDutyEditdlg::CDutyEditdlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDutyEditdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDutyEditdlg)
	m_strName = _T("");
	m_strRemark = _T("");
	m_strTel = _T("");
	//}}AFX_DATA_INIT
}


void CDutyEditdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDutyEditdlg)
	DDX_Text(pDX, IDC_NAME, m_strName);
	DDV_MaxChars(pDX, m_strName, 20);
	DDX_Text(pDX, IDC_REMARK, m_strRemark);
	DDV_MaxChars(pDX, m_strRemark, 200);
	DDX_Text(pDX, IDC_TEL, m_strTel);
	DDV_MaxChars(pDX, m_strTel, 15);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDutyEditdlg, CDialog)
	//{{AFX_MSG_MAP(CDutyEditdlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDutyEditdlg message handlers

void CDutyEditdlg::OnOK() 
{
	UpdateData(TRUE);

	m_strName.Replace("\'","");
	m_strTel.Replace("\'","");
	if(m_strName=="")
	{
		AfxMessageBox("請填寫姓名!");
		return;
	}
	if(m_strTel=="")
	{
		AfxMessageBox("請填寫手機號!");
		return;
	}
	CDatabase1 database;	
	
	
	if(!database.ConnectDB())
	{	
		AfxMessageBox("連接服務器失敗!");
		return;
	}
	
	CString charset="set names 'gb2312'";//使之正常顯示中文,或用set character_set_results=gb2312;
	database.ExecuteSQL(charset,charset.GetLength());//執行語句.
	CString sSQL;
	if(m_sOption=="add")
	{
		//增加
		sSQL.Format("insert into duty_info (duty_name,duty_tel,Remark) values('%s','%s','%s')",
			m_strName,m_strTel,m_strRemark);

		if(!database.ExecuteSQL(sSQL,sSQL.GetLength()))
		{
			AfxMessageBox("插入數據失敗!");
			return;
		}
	}
	if(m_sOption=="edit")
	{
		
		sSQL.Format("update duty_info set duty_tel='%s',duty_name='%s',Remark='%s' where duty_id='%s'",
			m_strTel,m_strName,m_strRemark,m_strID);

		if(!database.ExecuteSQL(sSQL,sSQL.GetLength()))
		{
			AfxMessageBox("編輯信息失敗!");
			return;
		}
	}
	CDialog::OnOK();
}

BOOL CDutyEditdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	if(m_sOption=="edit")
	{
		UpdateData(FALSE);
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}