// AdminUpload.cpp : implementation file
//

#include "stdafx.h"
#include "ordermanagement.h"
#include "AdminUpload.h"

#include "AdManageDialog.h"
#include "ADOConn.h"


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

/////////////////////////////////////////////////////////////////////////////
// AdminUpload dialog
	ADOConn connd;
		_bstr_t sSQLd;
AdminUpload::AdminUpload(CWnd* pParent /*=NULL*/)
	: CDialog(AdminUpload::IDD, pParent)
{
	//{{AFX_DATA_INIT(AdminUpload)
	m_adID = _T("");
	m_adPwd = _T("");
	//}}AFX_DATA_INIT
}


void AdminUpload::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(AdminUpload)
	DDX_Control(pDX, IDC_EDIT_UPADPWD, m_EditAdPwd);
	DDX_Control(pDX, IDC_EDIT_UPADID, m_EditAdID);
	DDX_Text(pDX, IDC_EDIT_UPADID, m_adID);
	DDX_Text(pDX, IDC_EDIT_UPADPWD, m_adPwd);
	DDX_Control(pDX, IDOK, m_ButLogin);
	DDX_Control(pDX, IDCANCEL, m_Butcancel);
DDX_Control(pDX, IDC_BTN_REWRITE, m_Butrew);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(AdminUpload, CDialog)
	//{{AFX_MSG_MAP(AdminUpload)
	ON_BN_CLICKED(IDC_BTN_REWRITE, OnBtnRewrite)
	ON_WM_TIMER()
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// AdminUpload message handlers
	_RecordsetPtr m_pRecordsetzz;
void AdminUpload::OnBtnRewrite() 
{
	
	m_adPwd = "";
	UpdateData(false);
	m_EditAdID.SetFocus();
	
}

void AdminUpload::OnOK() 
{
	UpdateData(true);							  //更新空件值變量
	if(m_adID.IsEmpty())
	{
		AfxMessageBox("用戶名不能為空,請(qǐng)重新輸入!");
		m_EditAdID.SetFocus();			  //焦點(diǎn)返回用戶名輸入框

	}
	else if(m_adPwd.IsEmpty())
	{
		AfxMessageBox("密碼不能為空,請(qǐng)重新輸入!");
		m_EditAdPwd.SetFocus();			  //焦點(diǎn)返回密碼輸入框

	}
	else 
	{
		int len = m_EditAdPwd.LineLength(); //取得密碼長(zhǎng)度
		if(len <= 6)
		{
			AfxMessageBox("密碼不少于七位,請(qǐng)重新輸入!");
			m_EditAdPwd.SetFocus();		  //焦點(diǎn)返回用戶名輸入框	

		}
		else								  // 核對(duì)用戶名和密碼是否合法
		{
			if(AdminTest())
			{	

				AdManageDialog amagdlg;
		
				CDialog::OnOK();
				amagdlg.DoModal();		
			}
			else 
			{
				OnBtnRewrite() ;
				AfxMessageBox("用戶名或密碼錯(cuò)誤!");
			}
		}
	}	
}

bool AdminUpload::AdminTest()//如果用戶名和密碼正確則返回true
{

	try{
		//如果Concection對(duì)象為空,則重新連接
		if(connd.m_pConn == NULL)
			connd.OnInitADOConn();
	
		//編輯SQ語(yǔ)句

		sSQLd = "SELECT * FROM Admin WHERE AdminID='"+m_adID+"' AND AdminPWD ='"+m_adPwd+"'";
		
		//執(zhí)行SQL語(yǔ)句
	
		m_pRecordsetzz = connd.GetRecordSet(sSQLd);
		if(!connd.m_pRs->adoBOF)
		{
			CString p;
			p="y";
			sSQLd  = "UPDATE Admin SET Astate ='"+ p+"' WHERE AdminID='"+m_adID+"' ";
			connd.ExecuteSQL(sSQLd);


			//connd.ExitConnect();

			return true;
		}
	}
	catch(_com_error e)
	{
		AfxMessageBox(e.Description());
		connd.ExitConnect();
		return false;
	}
	return false; 
}


BOOL AdminUpload::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
m_pic1.SubclassWindow( m_hWnd );
	m_pic1.m_nMessageHandler = CPictureWindow::BackGroundPaint;
	m_pic1.Load("");	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}


HBRUSH AdminUpload::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	//HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
COLORREF backColor = RGB(231, 231, 231); //office 2003背景色 
pDC->SetBkMode(TRANSPARENT);                //設(shè)置控件背景透明 
return CreateSolidBrush(backColor);            //創(chuàng)建背景刷子 	
	// TODO: Return a different brush if the default is not desired
	//return hbr;

	//HBRUSH hbr = CDialog::OnCtlColor(pDC,pWnd,nCtlColor); 
//pDC->SetBkMode(TRANSPARENT);   
//return    (HBRUSH)GetStockObject(NULL_BRUSH);   
}