logindlg.cpp

用VC++和SQL做的仓库管理系统

// LoginDlg.cpp : implementation file
//

#include "stdafx.h"
#include "stock.h"
#include "LoginDlg.h"
#include "ado_sql.h"

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

/////////////////////////////////////////////////////////////////////////////
// LoginDlg dialog


LoginDlg::LoginDlg(CWnd* pParent /*=NULL*/)
	: CDialog(LoginDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(LoginDlg)
	//}}AFX_DATA_INIT
}


void LoginDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(LoginDlg)
	DDX_Control(pDX, IDC_EDIT2, m_editUser);
	DDX_Control(pDX, IDC_EDIT1, m_editPWD);
	//}}AFX_DATA_MAP
	 
}


BEGIN_MESSAGE_MAP(LoginDlg, CDialog)
	//{{AFX_MSG_MAP(LoginDlg)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDCANCEL, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// LoginDlg message handlers

void LoginDlg::OnButton1() 
{
	// TODO: Add your control notification handler code here
	CString strUser,strPSWD;
	ado_sql a;
	CString strSQL;
	strSQL.Format("select * from Sevice_manager");
	if(!a.OpenRecordset(strSQL))
	{
		AfxMessageBox(_T("获得数据源失败！"));
		return;
	}
	BOOL bool1=FALSE;
	CString struser,strpwd;
	m_editUser.GetWindowTextA(struser);
	m_editPWD.GetWindowTextA(strpwd);
	while(!a.RdSetOperate.adoEOF())
	{
		if(a.RdSetOperate.GetItemValue(0)==struser&&a.RdSetOperate.GetItemValue(1)==strpwd)
		{
			this->ShowWindow(FALSE);
			bool1=TRUE;
			break;
		}
		a.RdSetOperate.MoveNext();
	}
	if(!bool1)
	{
		AfxMessageBox(_T("输入错误！"));
		return;
	}
	
	OnOK();
}



void LoginDlg::OnButton2() 
{
OnCancel();

}


BOOL LoginDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	
	//m_editUser.GetWindowText(strUser);
	//m_editPWD.GetWindowText(strPSWD);
	if(ado_sql::InitSQLServer("CZYZOE","stockroom","sa","123"))
		this->SetWindowText("连接成功！");
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void LoginDlg::OnButton4() 
{
	CString strUser,strPSWD;
	ado_sql a;
	CString strSQL;
	strSQL.Format("select * from Sevice_user");
	if(!a.OpenRecordset(strSQL))
	{
		AfxMessageBox(_T("获得数据源失败！"));
		return;
	}
	BOOL bool1=FALSE;
	while(!a.RdSetOperate.adoEOF())
	{
		if(a.RdSetOperate.GetItemValue(0)==strUser&&a.RdSetOperate.GetItemValue(1)==strPSWD)
		{
			this->ShowWindow(FALSE);
			bool1=TRUE;
			break;
		}
		a.RdSetOperate.MoveNext();
	}
	if(!bool1)
	{
		AfxMessageBox(_T("输入错误！"));
		return;
	}
	
}