datadlg.cpp

内容包括从VC++的基本范例到项目开发的许多典型的例子。是VC++初学者不可多得的好资料

// DataDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ExMIS.h"
#include "DataDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDataDlg dialog

//状态栏,字符串
static UINT indicators[] =
{
	IDS_STATUS_DATA,		//添加的自定义自符串
	ID_SEPARATOR,           // status line indicator
	ID_INDICATOR_CAPS,
	ID_INDICATOR_NUM,
	ID_INDICATOR_SCRL,
	IDS_STATUS_SPACE,				//加空格
};

CDataDlg::CDataDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDataDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDataDlg)
	m_strCollege = _T("");
	m_strSex = _T("");
	m_strClass = _T("");
	m_strID = _T("");
	m_strName = _T("");
	m_strNativePlace = _T("");
	m_timeBirthday = 0;
	//}}AFX_DATA_INIT
    //导入的图标是横向连到一起的，创建CImageList时指定20象素为宽截取出来
	m_TreeBootImage.Create (IDB_BITMAP_TREE,20,1,ILC_COLOR32);  //以20象素为宽截取图标
}


void CDataDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDataDlg)
	DDX_Control(pDX, IDC_DATE_BIRTHDAY, m_ctrlBirthday);
	DDX_Control(pDX, IDC_COMBO_COLLEGE, m_ctrlCollege);
	DDX_Control(pDX, IDC_TREE, m_ctrlTree);
	DDX_Control(pDX, IDC_LIST, m_ctrlList);
	DDX_CBString(pDX, IDC_COMBO_COLLEGE, m_strCollege);
	DDX_CBString(pDX, IDC_COMBO_SEX, m_strSex);
	DDX_Text(pDX, IDC_EDIT_CLASS, m_strClass);
	DDX_Text(pDX, IDC_EDIT_ID, m_strID);
	DDX_Text(pDX, IDC_EDIT_NAME, m_strName);
	DDX_Text(pDX, IDC_EDIT_NATIVEPLACE, m_strNativePlace);
	DDX_DateTimeCtrl(pDX, IDC_DATE_BIRTHDAY, m_timeBirthday);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDataDlg, CDialog)
	//{{AFX_MSG_MAP(CDataDlg)
	ON_NOTIFY(TVN_SELCHANGED, IDC_TREE, OnSelchangedTree)
	ON_COMMAND(ID_ITEM_ADD, OnItemAdd)
	ON_COMMAND(ID_ITEM_DELETE, OnItemDelete)
	ON_COMMAND(ID_ITEM_EDIT, OnItemEdit)
	ON_COMMAND(ID_ITEM_HELP, OnItemHelp)
	ON_COMMAND(ID_ITEM_QUIT, OnItemQuit)
	ON_COMMAND(ID_ITEM_SAVE, OnItemSave)
	ON_COMMAND(ID_ITEM_SEARCH, OnItemSearch)
	ON_NOTIFY(NM_CLICK, IDC_LIST, OnClickList)
	ON_COMMAND(ID_ITEM_REFRESH, OnItemRefresh)
	ON_NOTIFY(LVN_COLUMNCLICK, IDC_LIST, OnColumnclickList)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDataDlg message handlers

BOOL CDataDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	//添加工具栏和状态栏
	CRect	rect;
	GetClientRect(rect);	
	m_wndToolBar.Create(this);
	m_wndToolBar.LoadToolBar(IDR_MENU_DATA);
	m_wndToolBar.MoveWindow(0,0,rect.right,48);

	m_wndStatusBar.Create(this);
	m_wndStatusBar.SetIndicators(indicators,sizeof(indicators)/sizeof(UINT));
	m_wndStatusBar.SetPaneStyle(2,SBPS_STRETCH);
	m_wndStatusBar.MoveWindow(0,rect.bottom-20,rect.right,20);

	//初始化树形控件,设置图标
	m_ctrlTree.SetImageList(&m_TreeBootImage,TVSIL_NORMAL);	
	//设置列表控件的样式
	m_ctrlList.ModifyStyle(0,LVS_REPORT|LVS_SHOWSELALWAYS|LVS_SINGLESEL);
	m_ctrlList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);	
	m_pRS.ADOOpen();           //打开数据集	
	CDataDlg::OnItemRefresh(); //调用刷新记录事件全部重新填充

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

//刷新所有记录,主要是让树控件刷新
void CDataDlg::OnItemRefresh()
 {
	m_strSQL="SELECT * FROM StudentTab";	//暂存SQL语句,供排序时使用
	m_pRS.ADOExcute(m_strSQL);
	AddTreeNodes();  //添加院系、班级到树控件中
	AddListItems();	//添加学生到列表中
    //往院系下拉框中填充院系表已经有的院系，以便用户选择。
	MyRecordSet rs; 	//为院系控件添加院系列表,此处建立了一个临时的RecordSet实例
	rs.ADOOpen(m_pRS.m_strDBType);                    //打开数据连接
	rs.ADOExcute("SELECT CollegeID FROM CollegeTab");   //提取数据集
	while(!rs.ADOEOF())
	{
		m_ctrlCollege.AddString(rs.GetFieldString(0));
		rs.MoveNext();
	}
	rs.ADOConnectionClose();	//释放资源
}

void CDataDlg::AddTreeNodes(){
	m_ctrlTree.DeleteAllItems();	       //删除所有结点控件中的项目
	//添加根结点即学生表的信息
	hRootItem=m_ctrlTree.InsertItem("学生基本信息",0,2,TVI_ROOT,TVI_LAST);
	m_pRS.MoveFirst();		       //指向第一条
	while(!m_pRS.ADOEOF())
	{
		//如此院系不在根节点中，则添加院系到根节点中
		HTREEITEM hCollege=AddDistinctNode(hRootItem,m_pRS.GetFieldString("CollegeID"));
		//如此院的班级不在院系节点的子节点中，则添加 
		HTREEITEM hClass=AddDistinctNode(hCollege,m_pRS.GetFieldString("StuClass"));		
		m_pRS.MoveNext();
	}
}

//如果该值[strValue],在指定结点的子结点中不存在，则将此值添加到其子结点中；
HTREEITEM	CDataDlg::AddDistinctNode(HTREEITEM hParent,CString strValue)
{
	HTREEITEM hItem=m_ctrlTree.GetChildItem(hParent);
	while(hItem)
	{
		CString strItemText = m_ctrlTree.GetItemText(hItem);
		if(strItemText == strValue)
	return hItem;	//已经存在该值的子结点，则返回
		hItem = m_ctrlTree.GetNextSiblingItem(hItem);
	}
	//遍历了所有子结点，没有找到该值，则添加并返回
	return m_ctrlTree.InsertItem(strValue,1,2,hParent,TVI_LAST);
}
void CDataDlg::AddListItems()
{
	//清列表框的头,列,行
	int nCount=0;
	CHeaderCtrl *pHeaderCtrl=m_ctrlList.GetHeaderCtrl();
	if(pHeaderCtrl!=NULL)
		nCount=pHeaderCtrl->GetItemCount();
	for(int i=0;i<nCount;i++)
		m_ctrlList.DeleteColumn(0);
	m_ctrlList.DeleteAllItems();
	//取出字段名显示到列表头中
	for(i=0;i<m_pRS.nFieldCols;i++)
	{
		m_ctrlList.InsertColumn(i,m_pRS.GetFieldName(i),LVCFMT_LEFT,110);
	}
	//取出字段值放到列表行中
	int nItem=0;
	while(!m_pRS.ADOEOF()){
		m_ctrlList.InsertItem(nItem,m_pRS.GetFieldString(0));
		for(int i=1;i<m_pRS.nFieldCols;i++)
			m_ctrlList.SetItemText(nItem,i,m_pRS.GetFieldString(i));	
		m_pRS.MoveNext();
	}
}

//单击树形控件的某个结点后
void CDataDlg::OnSelchangedTree(NMHDR* pNMHDR, LRESULT* pResult)
{
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;	
	*pResult = 0;
	HTREEITEM hSelItem=m_ctrlTree.GetSelectedItem();	//取得当前选中的节点

	HTREEITEM hParentItem=m_ctrlTree.GetParentItem(hSelItem); 	//取得选中节点的父节点	
	//通过父节点判断选中的的是根节点,还是学院二级子节点，按不同情况写SQL语句的条件
	CString strSql,str,strCondition;	//SQL语句
	strSql="SELECT * FROM StudentTab";
	if(hParentItem!=NULL)
	{
		HTREEITEM hOldParent=m_ctrlTree.GetParentItem(hParentItem);
		if(hOldParent!=NULL)
		{
			//选中的是班级结点,添加院系条件和班级条件
			strCondition.Format(" Where CollegeID='%s' AND StuClass='%s'",m_ctrlTree.GetItemText(hParentItem),m_ctrlTree.GetItemText(hSelItem));  //此为一行
		}
		else
		{
			//选中的是院系结点,添加院系条件
			strCondition.Format(" Where CollegeID='%s'",m_ctrlTree.GetItemText(hSelItem));
		}	
	}
	else
	{
		strCondition="";  //选中的是根节结点，没有过滤条件
	}
	strSql+=strCondition;  //为SQL加上筛选条件, 
	m_strSQL=strSql;	    //将SQL语句暂存, 以供排序(单击列表控件列时)使用；	
	m_pRS.ADOExcute(strSql);  //提取数据集
	AddListItems();            //重新填充列表控件
}
//当单击列表控件某一行后，在详细信息中显示
void CDataDlg::OnClickList(NMHDR* pNMHDR, LRESULT* pResult)
 {
	int i=m_ctrlList.GetSelectionMark();     //取得该行
    //将值赋给控件变量
	m_strID=m_ctrlList.GetItemText(i,0);
	m_strName=m_ctrlList.GetItemText(i,1);
	m_strSex=m_ctrlList.GetItemText(i,2);
	m_timeBirthday=m_pRS.StringToTime(m_ctrlList.GetItemText(i,3));  //字符类型转化为时间类型
	m_strNativePlace=m_ctrlList.GetItemText(i,4);
	m_strClass=m_ctrlList.GetItemText(i,5);
	m_strCollege=m_ctrlList.GetItemText(i,6);	
	UpdateData(false);	  //将变量显示到界面上
	*pResult = 0;
}
//当单击列表控件某一列后按列排序
void CDataDlg::OnColumnclickList(NMHDR* pNMHDR, LRESULT* pResult) {
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	*pResult = 0;
	//单击表头列时排序,可有两种方法,一种是比较调整所有对应行的值排序，较为麻烦
	//这里使用了获取列名并重新填充的方法
	//获取表头列中的文字,由于没有直接的函数,所以需要分两步
	//取得选中的列索引:Info.iSubItem,行索引为:Info.iItem
	CPoint   pt;   
	::GetCursorPos(&pt);
	m_ctrlList.ScreenToClient(&pt);   
	LVHITTESTINFO Info;   
	Info.pt = pt;   
	Info.flags = LVHT_ABOVE;
	m_ctrlList.SubItemHitTest(&Info);	
	//取得列头中的值即:col.pszText
	LVCOLUMN   col;	
	col.mask=LVCF_TEXT;   
	col.cchTextMax =20;
	char   buff[20];   
	col.pszText=buff;
	m_ctrlList.GetColumn(Info.iSubItem,&col);	
	//耶得值之后,为SQL语句增加排序条件,并重新填充
	CString strSQL=m_strSQL+" ORDER BY "+col.pszText;
	m_pRS.ADOExcute(strSQL);   //提取数据集
	AddListItems();              //重新填充列表控件
}

//查找数据事件
void CDataDlg::OnItemSearch()
{
	UpdateData(true);
	//查找指定学号的项,并放入列表框中
	m_pRS.ADOExcute("SELECT * FROM StudentTab WHERE StuID='"+m_strID+"'");
	AddListItems();
	UpdateData(false);
}
//清空输入框的值,准备增加记录
void CDataDlg::OnItemAdd() 
{
	m_strID="";
	m_strName="";
	m_strSex="";
	m_strNativePlace="";
	m_strClass="";
	m_strCollege="";
	UpdateData(false);
}
//保存增加的记录
void CDataDlg::OnItemSave()
{
	UpdateData(true);
	CString sql;
	sql.Format("INSERT INTO StudentTab(StuID,StuName,CollegeID,StuNativePlace,StuClass,StuSex,StuBirthday) Values('%s','%s','%s','%s','%s','%s','%s')",
	m_strID,m_strName,m_strCollege,m_strNativePlace,m_strClass,m_strSex,m_pRS.TimeToString(m_timeBirthday));               //从sql开始此处为一行
	if(m_pRS.ADOExcuteNoQuery(sql)==1)
	{	
		AfxMessageBox("增加记录成功!");
		//增加完记录后,马上在列表中显示;
		int n=m_ctrlList.GetItemCount();
		n=m_ctrlList.InsertItem(n,m_strID);
		m_ctrlList.SetItemText(n,1,m_strName);
		m_ctrlList.SetItemText(n,2,m_strSex);		
		m_ctrlList.SetItemText(n,3,m_pRS.TimeToString(m_timeBirthday));
		m_ctrlList.SetItemText(n,4,m_strNativePlace);
		m_ctrlList.SetItemText(n,5,m_strClass);
		m_ctrlList.SetItemText(n,6,m_strCollege);
	}
	else
	{
		AfxMessageBox("增加记录失败,可能是重复的学号!");
	}
}
//保存编辑事件
void CDataDlg::OnItemEdit() 
{	
	UpdateData(true);
	CString sql;
	sql.Format("UPDATE StudentTab SET StuID='%s',StuName='%s',CollegeID='%s',StuNativePlace='%s',StuClass='%s',StuSex='%s',StuBirthday='%s' WHERE StuId='%s'", 		m_strID,m_strName,m_strCollege,m_strNativePlace,m_strClass,m_strSex,m_pRS.TimeToString(m_timeBirthday),m_strID);     //此处为一行
	if(m_pRS.ADOExcuteNoQuery(sql)==1)
	{	
		AfxMessageBox("编辑记录成功!");
		m_pRS.ADOExcute(m_strSQL);  //编辑完记录后,用暂存的SQL的语句刷新显示
		AddListItems();
	}
	else
	{
		AfxMessageBox("编辑记录失败!");
	}
}
// 删除事件，由于删除操作不可恢复，因此要紧慎实现
void CDataDlg::OnItemDelete()
 {
	if(m_ctrlList.GetSelectionMark()<0)
	{
		AfxMessageBox("请先选中要删除的项!");
		return;
	}
	if(AfxMessageBox("您确认要删除吗?",MB_OKCANCEL)==IDOK)
	{
		UpdateData(true);
		CString sql;
		sql.Format("DELETE * FROM StudentTab WHERE StuID='%s'",m_strID);
		if(m_pRS.ADOExcuteNoQuery(sql)==1)
		{	
			AfxMessageBox("删除记录成功!");
			//删除列表项中造中的记录			
			m_ctrlList.DeleteItem(m_ctrlList.GetSelectionMark());
		}
		else
		{
			AfxMessageBox("删除记录失败!");
		}
	}
}



void CDataDlg::OnItemHelp() 
{	//调帮助文档
	ShellExecute(NULL,NULL,_T("HELP.hlp"),NULL,NULL,SW_SHOW);
}

void CDataDlg::OnItemQuit() 
{	//返回一个DoModel的值退出
	CDialog::OnOK();
}