item.cpp

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

// Item.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CItem dialog


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


void CItem::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CItem)
	DDX_Control(pDX, IDC_LIST2, m_Grid);
	DDX_Control(pDX, IDC_LIST1, m_Icon);
	DDX_Control(pDX, IDC_EDIT3, m_Text);
	DDX_Control(pDX, IDC_EDIT2, m_Name);
	DDX_Control(pDX, IDC_EDIT1, m_ID);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CItem message handlers

BOOL CItem::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_ICON10));
	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, 5); //共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_SAVE, TBSTYLE_BUTTON, 3);
	m_ToolBar.SetButtonText(2, "保存");
	m_ToolBar.SetButtonInfo(3, ID_DEL, TBSTYLE_BUTTON, 4);
	m_ToolBar.SetButtonText(3, "删除");
	m_ToolBar.SetButtonInfo(4, ID_EXIT, TBSTYLE_BUTTON, 0);
	m_ToolBar.SetButtonText(4, "退出");
	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);		//将图像列表关联到列表视图控件中

	//设置列表视图的扩展风格
	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); //设置表头
	m_Grid.InsertColumn(3,"投票时间",LVCFMT_LEFT,100,3); //设置表头
	m_ID.EnableWindow(FALSE);
	m_Name.EnableWindow(FALSE);
	m_Text.EnableWindow(FALSE);

	CString sql,ph,id;
	sql.Format("select * from tb_item"); //设置SQL语句
	ADOConn m_ADOConn;       // ADOConn对象
	m_ADOConn.OnInitADOConn(); //连接数据库
	m_ADOConn.m_pRecordset = m_ADOConn.GetRecordSet((_bstr_t)sql); //根据SQL语句进行查询
	int i=0;
	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++;
	}

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

void CItem::OnAdd()
{
	CString sql,ph,id;
	sql.Format("select * from tb_item"); //设置SQL语句
	ADOConn m_ADOConn;       // ADOConn对象
	m_ADOConn.OnInitADOConn(); //连接数据库
	m_ADOConn.m_pRecordset = m_ADOConn.GetRecordSet((_bstr_t)sql); //根据SQL语句进行查询
	if(!m_ADOConn.m_pRecordset->adoEOF) //判断是否有符合条件的记录
	{
		while(!m_ADOConn.m_pRecordset->adoEOF)
		{
			ph = (char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("项目编号"); //获得数据表中的项目编号
			m_ADOConn.m_pRecordset->MoveNext(); //将记录集指针移动到下一条记录
		}
		id.Format("Item%03d",atoi(ph.Right(3))+1); //将获得的做大记录加1生成新的项目编号
	}
	else//如果没有符合的记录
		id.Format("Item001"); //则项目编号为Item001
	m_ADOConn.ExitConnect();        //关闭记录集并断开数据库连接
	m_Insert = TRUE;
	m_ID.SetWindowText(id);
	m_Name.SetWindowText("");
	m_Text.SetWindowText("");
	m_Name.EnableWindow(TRUE);
	m_Text.EnableWindow(TRUE);
}

void CItem::OnMod()
{
	m_Name.EnableWindow(TRUE);
	m_Text.EnableWindow(TRUE);
	m_Insert = FALSE;
}

void CItem::OnSave()
{
	CString id,name,text;
	m_ID.GetWindowText(id); //获取编辑框中的数据
	m_Name.GetWindowText(name); //获取编辑框中的数据
	m_Text.GetWindowText(text); //获取编辑框中的数据
	if(id.IsEmpty() || name.IsEmpty() || text.IsEmpty())
	{
		MessageBox("项目信息不能为空！");
		return;
	}
	ADOConn m_ADOConn;                   // ADOConn类对象
	m_ADOConn.OnInitADOConn();            //连接数据库
	CString sql;
	if(m_Insert)
	{
		sql.Format("insert into tb_item(项目编号,项目名称,项目描述)\
			values('%s','%s','%s')",id,name,text);
	}
	else
	{
		sql.Format("update tb_item set 项目名称='%s',项目描述='%s'\
			where 项目编号='%s'",name,text,id);
	}
	m_ADOConn.ExecuteSQL((_bstr_t)sql); //运行SQL语句添加记录
	m_ADOConn.ExitConnect();          //断开数据库连接
	m_Icon.InsertItem(m_Icon.GetItemCount(),name,0);
}

void CItem::OnDel()
{
	CString sql,name;
	int pos = m_Icon.GetSelectionMark();
	name	= m_Icon.GetItemText(pos,0);
	GetRecordset(name);
	ADOConn m_ADOConn;
	m_ADOConn.OnInitADOConn();	
	sql.Format("delete from tb_item where 项目名称='%s'",name);
	m_ADOConn.ExecuteSQL((_bstr_t)sql);
	sql.Format("delete from tb_ballot where 项目编号='%s'",m_id);
	m_ADOConn.ExecuteSQL((_bstr_t)sql);
	m_ADOConn.ExitConnect();
	m_Grid.DeleteItem(pos);
}

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

void CItem::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	CString sql,name;
	int pos = m_Icon.GetSelectionMark();
	m_name	= m_Icon.GetItemText(pos,0);
	GetRecordset(m_name);
	ADOConn m_ADOConn;
	m_ADOConn.OnInitADOConn();
	m_ID.SetWindowText(m_id);
	m_Name.SetWindowText(m_name);
	m_Text.SetWindowText(m_text);
	int i=0;
	sql.Format("select * from tb_ballot where 项目编号='%s'",m_id);
	m_ADOConn.m_pRecordset = m_ADOConn.GetRecordSet((_bstr_t)sql); //根据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_Grid.SetItemText(i,3,(char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("投票时间"));
		i++;
		m_ADOConn.m_pRecordset->MoveNext();
	}
	m_ADOConn.ExitConnect();
	*pResult = 0;
}

void CItem::GetRecordset(CString name)
{
	CString sql;
	ADOConn m_ADOConn;
	m_ADOConn.OnInitADOConn();
	sql.Format("select * from tb_item where 项目名称='%s'",name);
	m_ADOConn.m_pRecordset = m_ADOConn.GetRecordSet((_bstr_t)sql); //根据SQL语句进行查询
	if(!m_ADOConn.m_pRecordset->adoEOF)
	{
		m_id   = (char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("项目编号"); //获得数据表中的项目编号
		m_text = (char*)(_bstr_t)m_ADOConn.m_pRecordset->GetCollect("项目描述");
	}
	m_ADOConn.ExitConnect();
}