user.cpp

书友会短信发送系统由基础信息模块、短信管理模块、短信投票模块、系统管理模块等几部分组成。

// User.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CUser dialog


CUser::CUser(CWnd* pParent /*=NULL*/)
	: CDialog(CUser::IDD, pParent)
{
	//{{AFX_DATA_INIT(CUser)
	m_Name = _T("");
	m_Pwd1 = _T("");
	m_Pwd2 = _T("");
	//}}AFX_DATA_INIT
}


void CUser::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CUser)
	DDX_Control(pDX, IDC_LIST1, m_Icon);
	DDX_Text(pDX, IDC_EDIT1, m_Name);
	DDX_Text(pDX, IDC_EDIT2, m_Pwd1);
	DDX_Text(pDX, IDC_EDIT3, m_Pwd2);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CUser, CDialog)
	//{{AFX_MSG_MAP(CUser)
	ON_COMMAND(ID_ADD, OnAdd)
	ON_COMMAND(ID_MOD, OnMod)
	ON_COMMAND(ID_DEL, OnDel)
	ON_COMMAND(ID_EXIT, OnExit)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CUser message handlers

BOOL CUser::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//创建图像列表
	m_ImageList.Create(32,32,ILC_COLOR24|ILC_MASK,1,1);
	//向图像列表中添加图标
	m_ImageList.Add(AfxGetApp()->LoadIcon(IDI_ICON7));
	m_ImageList.Add(AfxGetApp()->LoadIcon(IDI_ICON8));
	m_ImageList.Add(AfxGetApp()->LoadIcon(IDI_ICON9));
	m_ImageList.Add(AfxGetApp()->LoadIcon(IDI_ICON11));
	m_ToolBar.CreateEx(this, TBSTYLE_FLAT, WS_CHILD | WS_VISIBLE | CBRS_TOP   
		| CBRS_TOOLTIPS |CBRS_FLYBY | CBRS_SIZE_DYNAMIC);
	//关联图像列表
	m_ToolBar.GetToolBarCtrl().SetImageList(&m_ImageList);
	m_ToolBar.SetButtons(NULL, 4); //共4个按钮
	// 设置每个工具按钮文字
	m_ToolBar.SetButtonInfo(0, ID_ADD, TBSTYLE_BUTTON, 1);
	m_ToolBar.SetButtonText(0, "添加");
	m_ToolBar.SetButtonInfo(1, ID_MOD, TBSTYLE_BUTTON, 2);
	m_ToolBar.SetButtonText(1, "修改");
	m_ToolBar.SetButtonInfo(2, ID_DEL, TBSTYLE_BUTTON, 3);
	m_ToolBar.SetButtonText(2, "删除");
	m_ToolBar.SetButtonInfo(3, ID_EXIT, TBSTYLE_BUTTON, 0);
	m_ToolBar.SetButtonText(3, "退出");
	m_ToolBar.SetSizes(CSize(50,50), CSize(32,32)); //设置按钮的大小
	//显示工具栏窗口
	RepositionBars(AFX_IDW_CONTROLBAR_FIRST,AFX_IDW_CONTROLBAR_LAST,0);

	m_IconList.Create(32,32,ILC_COLOR24|ILC_MASK,1,0);	//创建列表视图窗口
	m_IconList.Add(AfxGetApp()->LoadIcon(IDI_ICON6)); 	//向图像列表中添加图标
	m_Icon.SetImageList(&m_ImageList,LVSIL_NORMAL);		//将图像列表关联到列表视图控件中
	AddToList();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CUser::OnAdd()
{
	UpdateData(TRUE);
	ADOConn m_ADOConn;       //ADOConn类对象
	m_ADOConn.OnInitADOConn(); //连接数据库
	CString sql;
	if(m_Name.IsEmpty() || m_Pwd1.IsEmpty() || m_Pwd2.IsEmpty())
	{
		MessageBox("用户名和密码不能为空！");
		return;
	}
	if(m_Pwd1 != m_Pwd2)
	{
		MessageBox("两次输入密码不同，请重新输入！");
		m_Pwd1 = m_Pwd2 = "";
		UpdateData(FALSE);
		return;
	}
	sql.Format("insert into tb_user(用户名,用户密码)values('%s','%s')",m_Name,m_Pwd1);
	m_ADOConn.ExecuteSQL((_bstr_t)sql);
	m_ADOConn.ExitConnect();
	m_Icon.DeleteAllItems();
	AddToList();
}

void CUser::OnMod()
{
	UpdateData(TRUE);
	ADOConn m_ADOConn;       //ADOConn类对象
	m_ADOConn.OnInitADOConn(); //连接数据库
	CString sql;
	if(m_Name.IsEmpty() || m_Pwd1.IsEmpty() || m_Pwd2.IsEmpty())
	{
		MessageBox("用户名和密码不能为空！");
		return;
	}
	if(m_Pwd1 != m_Pwd2)
	{
		MessageBox("两次输入密码不同，请重新输入！");
		m_Pwd1 = m_Pwd2 = "";
		UpdateData(FALSE);
		return;
	}
	sql.Format("update tb_user set 用户密码='%s' where \
		用户名='%s'",m_Pwd1,m_Name);
	m_ADOConn.ExecuteSQL((_bstr_t)sql);
	m_ADOConn.ExitConnect();
	m_Icon.DeleteAllItems();
	AddToList();
}

void CUser::OnDel()
{
	ADOConn m_ADOConn;       //ADOConn类对象
	m_ADOConn.OnInitADOConn(); //连接数据库
	CString sql;
	if(m_Name.IsEmpty())
	{
		MessageBox("用户名不能为空！");
		return;
	}
	sql.Format("delete from tb_user where 用户名='%s'",m_Name);
	m_ADOConn.ExecuteSQL((_bstr_t)sql);
	m_ADOConn.ExitConnect();
	m_Icon.DeleteAllItems();
	AddToList();
}

void CUser::OnExit()
{
	CDialog::OnCancel();
}

void CUser::AddToList()
{
	ADOConn m_ADOConn;       // ADOConn类对象
	m_ADOConn.OnInitADOConn(); //连接数据库
	CString sql;
	int i = 0;
	sql.Format("select * from tb_user");                         //设置查询语句
	m_ADOConn.m_pRecordset = m_ADOConn.GetRecordSet((_bstr_t)sql); //查询
	while(!m_ADOConn.m_pRecordset->adoEOF)
	{
		//向列表视图控件中插入行
		m_Icon.InsertItem(i,(char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("用户名"),0);
		m_ADOConn.m_pRecordset->MoveNext(); //将记录集指针移动到下一条记录
		i++;
	}
	m_ADOConn.ExitConnect(); //断开数据库连接
}

void CUser::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int pos = m_Icon.GetSelectionMark();
	m_Name  = m_Icon.GetItemText(pos,0);
	ADOConn m_ADOConn;       // ADOConn类对象
	m_ADOConn.OnInitADOConn(); //连接数据库
	CString sql;
	sql.Format("select * from tb_user where 用户名='%s'",m_Name);                         //设置查询语句
	m_ADOConn.m_pRecordset = m_ADOConn.GetRecordSet((_bstr_t)sql); //查询
	if(!m_ADOConn.m_pRecordset->adoEOF)
	{
		//向列表视图控件中插入行
		m_Pwd1 = (char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("用户密码");
	}
	m_ADOConn.ExitConnect(); //断开数据库连接
	UpdateData(FALSE);
	*pResult = 0;
}