// cdwDlg.cpp : implementation file
//

#include "stdafx.h"
#include "cdw.h"
#include "cdwDlg.h"
#include "JISONG.h"
#include "bgzhuangtai.h"
#include "bgcx.h"
#include "AdoConnect.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCdwDlg dialog

CCdwDlg::CCdwDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCdwDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCdwDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CCdwDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCdwDlg)
		// NOTE: the ClassWizard will add DDX and DDV calls here
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CCdwDlg, CDialog)
	//{{AFX_MSG_MAP(CCdwDlg)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	ON_BN_CLICKED(IDC_JISONG, OnJisong)
	ON_BN_CLICKED(IDC_CHAXUNBG, OnChaxunbg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCdwDlg message handlers

BOOL CCdwDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	// Add "About..." menu item to system menu.

	// IDM_ABOUTBOX must be in the system command range.
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);

	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		CString strAboutMenu;
		strAboutMenu.LoadString(IDS_ABOUTBOX);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}

	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE  unless you set the focus to a control
}

void CCdwDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
	{
		CAboutDlg dlgAbout;
		dlgAbout.DoModal();
	}
	else
	{
		CDialog::OnSysCommand(nID, lParam);
	}
}

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.

void CCdwDlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // device context for painting

		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// Draw the icon
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

// The system calls this to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CCdwDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}

void CCdwDlg::OnButton2() 
{
	// TODO: Add your control notification handler code here
	
}

void CCdwDlg::OnJisong() 
{
	CJISONG jisong;
	int num;
	CString s;
	
	srand(time(0)); //初始化 
	num = rand(); //產生0--32767之間的隨機數
	s.Format("%d",num);
	if(IDOK==jisong.DoModal())
	{
		if(jisong.m_name==""||jisong.m_time==""||jisong.m_addfrom==""||jisong.m_addto=="")
		{	
			MessageBox("基礎信息不能為空","提示");
		}
		else{
		try{
			CAdoConnect connect;
			connect.OnInitDBConnect();
			CString sql;
			_bstr_t vSQL;
			vSQL="select * from bginfo where 包裹名稱='"+jisong.m_name+"'";
			_RecordsetPtr pRecordset;

			pRecordset=connect.GetRecordSet(vSQL);
			sql.Format("insert into bginfo (包裹名稱,寄送時間,寄送地點,送達地點,包裹編號) \
					values('%s','%s','%s','%s',%d)",jisong.m_name,jisong.m_time,jisong.m_addfrom,jisong.m_addto,num); //注冊成功寫入數據庫
			if(connect.ExecuteSQL((_bstr_t)sql))
			{
				
				MessageBox("寄送 成功您的包裹編號為："+s+"你可以根據此號碼查詢您的包裹！請您牢記！","提示");
			}
				connect.ExitConnect();
				
		}
	catch(...)
	{
		MessageBox("操作失敗");
		CDialog::OnOK();
		return;
	}
		}
	}
	
}

void CCdwDlg::OnChaxunbg() 
{
	Cbgzhuangtai zt;
	Cbgcx bgcx;
	int ran;
	if(IDOK==bgcx.DoModal())
	{
		if(bgcx.m_inbgnum==0)
			MessageBox("請輸入號碼");
		else{
			ran=bgcx.m_inbgnum%10;
			try{
					CAdoConnect adoconnect;
				adoconnect.OnInitDBConnect();
				CString vSQL;
				CString str;
				vSQL.Format("select * from bginfo where 包裹編號=%d",bgcx.m_inbgnum);
				_RecordsetPtr pRecordset;
				pRecordset=adoconnect.GetRecordSet((_bstr_t)vSQL);
				CString s;
				
				if(pRecordset->adoEOF==-1) 
					{
						AfxMessageBox("該包裹不存在，請確認您輸入的編號！");
						//adoconnect.ExitConnect();
						return;
					}
				else if(ran==0)
				{
					s=(LPCTSTR)(_bstr_t)pRecordset->GetCollect("包裹名稱");

					zt.m_bgzt="對不起您的包裹"+s+"處于延誤中！請您耐心等待，我們會盡快處理！";
					zt.DoModal();
				}
				else if(1<=ran&&ran<=4)
				{
					s=(LPCTSTR)(_bstr_t)pRecordset->GetCollect("包裹名稱");
					zt.m_bgzt="您的包裹"+s+"正在寄送途中！請您耐心等待！";
				zt.DoModal();
				}
				else if(5<=ran&&ran<=9)

				{
					s=(LPCTSTR)(_bstr_t)pRecordset->GetCollect("包裹名稱");
					CString str;
					str=(LPCTSTR)(_bstr_t)pRecordset->GetCollect("送達地點");
					zt.m_bgzt="您的包裹"+s+"已送達目的地"+str;
					zt.DoModal();
				}
						
			
			adoconnect.ExitConnect();
		
	}
	catch(...)
		{
			MessageBox("操作失敗");
			return;
		}
		}
	}
	
}