book.cpp

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

// Book.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CBook dialog


CBook::CBook(CWnd* pParent /*=NULL*/)
	: CDialog(CBook::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBook)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CBook::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBook)
	DDX_Control(pDX, IDC_LIST1, m_Grid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBook, CDialog)
	//{{AFX_MSG_MAP(CBook)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBook message handlers

BOOL CBook::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//设置列表视图的扩展风格
	m_Grid.SetExtendedStyle(LVS_EX_FLATSB  //扁平风格显示滚动条
		|LVS_EX_FULLROWSELECT         //允许整行选中
		|LVS_EX_HEADERDRAGDROP       //允许整列拖动
		|LVS_EX_ONECLICKACTIVATE      //单击选中项
		|LVS_EX_GRIDLINES);               //画出网格线
	m_Grid.InsertColumn(0,"会员编号",LVCFMT_LEFT,100,0); //设置表头
	m_Grid.InsertColumn(1,"会员姓名",LVCFMT_LEFT,100,1); //设置表头
	m_Grid.InsertColumn(2,"会员电话",LVCFMT_LEFT,100,2); //设置表头
	ADOConn m_ADOConn;       // ADOConn类对象
	m_ADOConn.OnInitADOConn(); //连接数据库
	CString sql;
	int i = 0;
	sql.Format("select * from tb_Associator");                         //设置查询语句
	m_ADOConn.m_pRecordset = m_ADOConn.GetRecordSet((_bstr_t)sql); //查询
	while(!m_ADOConn.m_pRecordset->adoEOF)
	{
		//向列表视图控件中插入行
		m_Grid.InsertItem(i,"");
		//向列表视图控件中插入列
		m_Grid.SetItemText(i,0,(char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("会员编号"));
		m_Grid.SetItemText(i,1,(char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("会员昵称"));
		m_Grid.SetItemText(i,2,(char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("会员电话"));
		m_ADOConn.m_pRecordset->MoveNext(); //将记录集指针移动到下一条记录
		i++;
	}
	m_ADOConn.ExitConnect(); //断开数据库连接
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CBook::OnButton1() 
{
	// TODO: Add your control notification handler code here
	int pos    = m_Grid.GetSelectionMark();
	m_Num      = 1;
	m_Name[0]  = m_Grid.GetItemText(pos,1);
	m_Phone[0] = m_Grid.GetItemText(pos,2);
	CDialog::OnCancel();
}

void CBook::OnButton2() 
{
	// TODO: Add your control notification handler code here
	m_Num = m_Grid.GetItemCount();
	for(int i=0;i<m_Num;i++)
	{
		m_Name[i]  = m_Grid.GetItemText(i,1);
		m_Phone[i] = m_Grid.GetItemText(i,2);
	}
	CDialog::OnCancel();
}