count.cpp

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

// Count.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CCount dialog


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


void CCount::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCount)
	DDX_Control(pDX, IDC_EDIT1, m_Text);
	DDX_Control(pDX, IDC_COMBO1, m_Item);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_MSCHART1, m_Chart);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCount, CDialog)
	//{{AFX_MSG_MAP(CCount)
	ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1)
	ON_BN_CLICKED(IDC_BUTEXIT, OnButexit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCount message handlers

BOOL CCount::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CString sql;
	ADOConn m_ADOConn;
	m_ADOConn.OnInitADOConn();
	sql.Format("select * from tb_item");
	m_ADOConn.GetRecordSet((_bstr_t)sql);
	int i=0;
	while(!m_ADOConn.m_pRecordset->adoEOF)
	{
		id[i]   = (char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("项目编号");
		text[i] = (char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("项目描述");
		m_Item.InsertString(i,(char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("项目名称"));
		m_ADOConn.m_pRecordset->MoveNext();
		i++;
	}
	m_Item.SetCurSel(0);
	m_Text.SetWindowText(text[0]);
	sql.Format("select 项目回复,count(项目回复)as 回复数量 from tb_ballot\
		where 项目编号 = '%s' group by 项目回复",id[0]);
	m_Adodc.SetRecordSource(sql);
	m_Adodc.Refresh();

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCount::OnSelchangeCombo1() 
{
	// TODO: Add your control notification handler code here
	int sel = m_Item.GetCurSel();
	m_Text.SetWindowText(text[sel]);
	CString sql;
	sql.Format("select 项目回复,count(项目回复)as 回复数量 from tb_ballot\
		where 项目编号 = '%s' group by 项目回复",id[sel]);
	m_Adodc.SetRecordSource(sql);
	m_Adodc.Refresh();
}

void CCount::OnButexit() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();
}