memberin.cpp

偶作的毕业设计程序

// MemberIn.cpp : implementation file
//

#include "stdafx.h"
#include "SoftDocSystem.h"
#include "MemberIn.h"
#include "SoftDocSystemDlg.h"
#include "Rrypt.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CMemberIn dialog
extern int CheckNewUser;
extern int PublicUserType;
extern CString PublicUserName;

CMemberIn::CMemberIn(CWnd* pParent /*=NULL*/)
	: CDialog(CMemberIn::IDD, pParent)
{
	//{{AFX_DATA_INIT(CMemberIn)
	m_User = _T("");
	m_Pwd1 = _T("");
	m_Pwd2 = _T("");
	m_Name = _T("");
	m_Addr = _T("");
	m_PostNum = _T("");
	m_Context = _T("");
	//}}AFX_DATA_INIT
}


void CMemberIn::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CMemberIn)
	DDX_Text(pDX, IDC_EDIT1, m_User);
	DDX_Text(pDX, IDC_EDIT2, m_Pwd1);
	DDX_Text(pDX, IDC_EDIT3, m_Pwd2);
	DDX_Text(pDX, IDC_EDIT4, m_Name);
	DDX_Text(pDX, IDC_EDIT5, m_Addr);
	DDX_Text(pDX, IDC_EDIT6, m_PostNum);
	DDX_Text(pDX, IDC_EDIT7, m_Context);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CMemberIn, CDialog)
	//{{AFX_MSG_MAP(CMemberIn)
	ON_BN_CLICKED(IDOK, OnInput)
	ON_WM_DESTROY()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CMemberIn message handlers

void CMemberIn::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}

void CMemberIn::OnInput() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	if(m_User==""){AfxMessageBox("请输入用户名");return;}
	//if(m_Pwd1==""){AfxMessageBox("请输入密码");return;}
	//if(m_Pwd2==""){AfxMessageBox("请输入确认密码");return;}
	if(m_Name==""){AfxMessageBox("请输入姓名");return;}
	if(m_Addr==""){AfxMessageBox("请输入部门名称");return;}
	if(m_PostNum==""){AfxMessageBox("请输入电话号码");return;}
	if(m_Pwd1!=m_Pwd2){AfxMessageBox("你两次输入的密码不一致，请重新输入1");return;}
	//核对输入用户名是否重叠
	int IsNo=0;
	CString Mysql_;
	_RecordsetPtr Myset;
	Myset.CreateInstance (__uuidof(Recordset));
	Mysql_.Format("SELECT 用户名 FROM UserInfo WHERE 用户名 = '%s'",m_User);
	_bstr_t Mysql=Mysql_;
	_bstr_t source=m_strSource;
	try{
		Myset->Open (Mysql,source,adOpenDynamic,adLockOptimistic,adCmdText);
	}
	catch(_com_error& e)
	{AfxMessageBox(e.ErrorMessage ());
	return;}
	while(!Myset->adoEOF ){
		IsNo+=1;
		Myset->MoveNext();
}
	Myset->Close();
if(IsNo>0){AfxMessageBox("对不起，你输入的用户名已有人使用，清重新输入用户名!");return;}
	//Next

CString str1,str3,UserSecret;
if(m_Pwd1.IsEmpty ())UserSecret=_T("RX67YM3482C");
else
UserSecret=CCrypt::Encrypt (m_Pwd1,376);
CTime tm=CTime::GetCurrentTime ();
str1=tm.Format ("%Y-%m-%d");
CString sql_;
sql_.Format ("INSERT INTO UserInfo (用户名,密码,姓名,部门,联系电话,登记时间,详细信息) VALUES('%s','%s','%s','%s','%s','%s','%s')",m_User,UserSecret,m_Name,m_Addr,m_PostNum,str1,m_Context);
_bstr_t sql=sql_;
try{
	m_DBCnt->Execute (sql,NULL,adCmdText);}
catch (_com_error &e){
	   AfxMessageBox(e.ErrorMessage()); 
	   CheckNewUser=0;
	   return;}
if(m_Log.Setup (m_DBCnt))
		m_Log.Addlog (m_User,"登录新用户",m_Name);//操作日志

CString str2;
str2.Format ("Dear %s，你的信息已成功登录，我们将竭尽所能为你服务！",m_User);
CheckNewUser=10;
PublicUserType=2;
PublicUserName.Format ("'%s'",m_User);
AfxMessageBox(str2);
}

BOOL CMemberIn::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CheckNewUser=0;
	((CEdit*)GetDlgItem(IDC_EDIT1))->SetLimitText(20);//限制字长
	((CEdit*)GetDlgItem(IDC_EDIT2))->SetLimitText(30);
	((CEdit*)GetDlgItem(IDC_EDIT2))->SetLimitText(30);
	((CEdit*)GetDlgItem(IDC_EDIT4))->SetLimitText(20);
	((CEdit*)GetDlgItem(IDC_EDIT5))->SetLimitText(30);
	((CEdit*)GetDlgItem(IDC_EDIT5))->SetLimitText(20);

	 CSoftDocSystemApp* myApp=(CSoftDocSystemApp*)AfxGetApp();
	 CString source_;
	 source_.Format ("driver={SQL Server};server=%s;database=SoftDocument",myApp->ConnectServer);
	_bstr_t source=source_;
	_bstr_t pwd=myApp->ConnectPwd;
	_bstr_t user=myApp->ConnectUser;
	HRESULT hr;
	try{
		hr = m_DBCnt.CreateInstance(_uuidof(Connection));
		if(SUCCEEDED(hr))
			hr = m_DBCnt->Open(source, user, pwd, 16);
		if(SUCCEEDED(hr))
			m_fConnected = TRUE;
		else 
			m_fConnected = FALSE;
	}
	catch (_com_error &e){
		MessageBox(e.ErrorMessage()); 
		m_fConnected = FALSE;
	}
	if(!m_fConnected) MessageBox("ADO数据源初始化失败！");
	else  m_strSource = (char * )source;	
	return TRUE;  // return TRUE unless you set the focus to a control
	// EXCEPTION: OCX Property Pages should return FALSE
}
int CMemberIn::DoModal() 
{
	// TODO: Add your specialized code here and/or call the base class
	
	return CDialog::DoModal();
}

void CMemberIn::OnDestroy() 
{
   
	CDialog::OnDestroy();
	
	// TODO: Add your message handler code here
		if(m_DBCnt->GetState()==adStateOpen)
		m_DBCnt->Close();
}