admininfodlg.cpp

订单管理系统

// AdminInfoDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ordermanagement.h"
#include "AdminInfoDlg.h"
#include "ADOConn.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// AdminInfoDlg dialog


AdminInfoDlg::AdminInfoDlg(CWnd* pParent /*=NULL*/)
	: CDialog(AdminInfoDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(AdminInfoDlg)
	m_adminID = _T("");
	m_adminPwd = _T("");
	m_newPwd = _T("");
	m_qq = _T("");
	//}}AFX_DATA_INIT
}


void AdminInfoDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(AdminInfoDlg)
	DDX_Control(pDX, IDC_ADMINPWD_NEW_EDIT, m_EditNewPwd);
	DDX_Control(pDX, IDC_ADMINPWD_EDIT, m_EditPwd);
	DDX_Text(pDX, IDC_ADMINID_EDIT, m_adminID);
	DDX_Text(pDX, IDC_ADMINPWD_EDIT, m_adminPwd);
	DDX_Text(pDX, IDC_ADMINPWD_NEW_EDIT, m_newPwd);
	DDX_Text(pDX, IDC_EDIT3, m_qq);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(AdminInfoDlg, CDialog)
	//{{AFX_MSG_MAP(AdminInfoDlg)
	ON_BN_CLICKED(IDC_REWRITE_BTN, OnRewriteBtn)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()
ADOConn zConn;
_bstr_t sSQLz;
////////////////////////////////////////////////////////////////////////////
// AdminInfoDlg message handlers

void AdminInfoDlg::OnRewriteBtn() 
{
m_adminPwd = "";
	m_newPwd = "";
	m_qq="";
	UpdateData(false);
	m_EditPwd.SetFocus();		
}

void AdminInfoDlg::OnOK() 
{
	ADOConn conn;
	_bstr_t sSQL;
	_RecordsetPtr  m_pRecordset;

	UpdateData(true);
	
		if(m_EditNewPwd.LineLength() < 7)
		{
			AfxMessageBox("密码不能位数不够七位！");
		}
		else{
			//如果Concection对象为空,则重新连接
			if(conn.m_pConn == NULL)
				conn.OnInitADOConn();
			
			//编辑数据库操作语句
			sSQL = "SELECT * FROM Admin  WHERE  AdminID='"+m_adminID+"' and AdminPWD='"+m_adminPwd+"'";
			zConn.m_pRs = zConn.GetRecordSet(sSQL);
				if(zConn.m_pRs->adoBOF)
				AfxMessageBox("用户名或原密码不正确！");
			else
			{
				if( m_newPwd!=m_qq)
					{
					AfxMessageBox("确认密码不一致！");
					}
					else 
					{
				if(MessageBox("是否确定更改？","请确认",MB_YESNO) == IDYES)
				{
					//编辑update语句
					sSQL = "UPDATE Admin SET AdminPWD ='"+m_newPwd+"' WHERE AdminID ='"+m_adminID+"'";
					
					//执行语句
					if(conn.ExecuteSQL(sSQL))
						AfxMessageBox("信息修改成功！");
				}

				m_adminID = "";
				m_adminPwd = "";
				m_qq = "";
				m_newPwd = "";

				UpdateData(false);
				conn.ExitConnect();
					}
			}
		CDialog::OnOK();
		}
	
}

HBRUSH AdminInfoDlg::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);                //设置控件背景透明 
return CreateSolidBrush(backColor);            //创建背景刷子 	
	// 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);  
}

BOOL AdminInfoDlg::OnInitDialog() 
{
	
	CDialog::OnInitDialog();
CString p;
p="y";
	sSQLz = "SELECT * FROM Admin  WHERE  Astate='"+p+"'";
			zConn.m_pRs = zConn.GetRecordSet(sSQLz);
	


		zConn.vCID = zConn.m_pRs->GetCollect("AdminID");
		m_adminID  = (char *)(_bstr_t)zConn.vCID;
	UpdateData(false);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}