um_adddlg.cpp

库存管理系统

// UM_ADDDlg.cpp : implementation file
//

#include "stdafx.h"
#include "库存管理系统.h"
#include "UM_ADDDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CUM_ADDDlg dialog


CUM_ADDDlg::CUM_ADDDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CUM_ADDDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CUM_ADDDlg)
	m_identify = _T("");
	m_confirm = _T("");
	m_id = _T("");
	m_password = _T("");
	_Conn = ((CMyApp *)AfxGetApp())->m_nConnection;
	//}}AFX_DATA_INIT
}


void CUM_ADDDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CUM_ADDDlg)
	DDX_CBString(pDX, IDC_COMBO1, m_identify);
	DDX_Text(pDX, UM_ADD_CONFIRM_EDIT, m_confirm);
	DDX_Text(pDX, UM_ADD_ID_EDIT, m_id);
	DDX_Text(pDX, UM_ADD_PASSWORD_EDIT, m_password);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CUM_ADDDlg message handlers

void CUM_ADDDlg::OnOK() 
{
	// TODO: Add extra validation here
	//更新数据
	UpdateData(TRUE);
	//检测是否填满信息
	if(m_id == _T("")||m_password == _T("") ||m_confirm == _T("")|| m_identify == _T(""))
		MessageBox("所填资料不完整,请重新填写!","错误",MB_ICONWARNING|MB_OK);
	else
	{
	try{
		_RecordsetPtr _Record;
		_Record.CreateInstance("ADODB.Recordset");
		CString strSql="select * from 用户 where ID ='" + m_id + "'"; 
		_variant_t ra;
		BSTR bstrSQL = strSql.AllocSysString(); 
		// 执行SQL语句得到一个记录集把其指针赋值给m_pRecordset 
		_Record = _Conn->Execute(bstrSQL,&ra,adCmdText);
		long total=0;
		while(! _Record->adoEOF)
		{total++;
		_Record->MoveNext();
		}
		if(total != 0)
		{
			MessageBox("此用户名已存在,请重新输入用户名!","错误",MB_ICONWARNING|MB_OK);
			m_id = _T("");
			UpdateData(FALSE);
		}
		else 
		{
			if(m_password == m_confirm)//检测两次密码填写是否一致
			{
				int confirmadd;
				confirmadd = MessageBox("该用户名未被使用,确定要添加该用户吗?","注册",MB_OKCANCEL|MB_ICONWARNING);
				if(confirmadd == 1)
				{
				 _CommandPtr _Comm;
				 _Comm.CreateInstance("ADODB.Command");
				 _Comm->ActiveConnection = _Conn;
				 CString la;
				 la="insert into 用户(ID,PassWord,Position) values ('"+m_id+"','"+m_password+"','"+m_identify+"');";
				 _Comm->CommandText=_bstr_t(la);
				 _Comm->Execute(NULL,NULL,adCmdText);
				 MessageBox("用户名注册完毕!","注册",MB_ICONWARNING|MB_OK);

				}
				
				m_id = _T("");
				m_password = _T("");
				m_confirm = _T("");
				UpdateData(FALSE);
				
			}
		    else 
			{MessageBox("两次填入的密码不一致,请重新填写!","Error",MB_OK|MB_ICONERROR);
			m_password = _T("");
			m_confirm = _T("");
			UpdateData(FALSE);
			}
		}
	}
		catch(_com_error &e)
		{
			::AfxMessageBox( e.Description());
		}
	}
}