stumandlg.cpp

VC++做的学校收费管理系统,很有参考价值,附上源码与说明文档.

// StuManDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ChargeManage.h"
#include "StuManDlg.h"
#include "StuEditDlg.h"
#include "Student.h"
#include "DepInfo.h"
#include "UserInfo.h"
#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
#include "_Recordset.h"

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

extern CUserInfo curUser;

/////////////////////////////////////////////////////////////////////////////
// CStuManDlg dialog


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


void CStuManDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CStuManDlg)
	DDX_Control(pDX, IDC_TREE1, m_tree);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_Datagrid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CStuManDlg, CDialog)
	//{{AFX_MSG_MAP(CStuManDlg)
	ON_NOTIFY(TVN_SELCHANGED, IDC_TREE1, OnSelchangedTree1)
	ON_BN_CLICKED(IDC_ADD_BUTTON, OnAddButton)
	ON_BN_CLICKED(IDC_MODI_BUTTON, OnModiButton)
	ON_BN_CLICKED(IDC_DEL_BUTTON, OnDelButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CStuManDlg message handlers

BOOL CStuManDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//权限控制，如果不是管理员则添加、修改和删除按钮置灰
	if (curUser.UserType != 1)
	{
		GetDlgItem(IDC_ADD_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_MODI_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_DEL_BUTTON)->EnableWindow(FALSE);
	}

	//装入院系信息
	dep.LoadDep();

	//添加根节点
	m_treeImageList.Create(16,16,FALSE,1,0);  //创建CImageList控件
	//装入ICON资源
	HICON hIcon = ::LoadIcon(AfxGetResourceHandle(), MAKEINTRESOURCE(IDI_ICON1));
	m_treeImageList.Add(hIcon);  //将ICON资源添加到CImageList控件中
	//将CImageList控件与Tree控件相关联	
	m_tree.SetImageList(&m_treeImageList, LVSIL_NORMAL);
	m_root = m_tree.InsertItem("院系信息");  //添加根节点
	//调用AddtoTree() 函数，将所有院系信息添加到Tree控件中	
	AddtoTree(m_root, 0);
	m_tree.Expand(m_root, TVE_EXPAND); //展开根节点
	//选中根节点
	m_tree.SelectItem(m_root);

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

void CStuManDlg::RefreshData()
{
	UpdateData(TRUE);

	//从Tree控件中读取院系编号信息
	int iDepId;
	HTREEITEM node;
	node = m_tree.GetSelectedItem();
	iDepId = m_tree.GetItemData(node);

	//根据院系编号设置SELECT语句
	CString cDepId;
	cDepId.Format("%d", iDepId);

	// 设置SELECT语句
	CString cSource = "SELECT s.StuId, s.Name AS 姓名, s.Sex AS 性别, p.Name AS 专业名称,"
		" s.ClassName AS 班级名称, s.iYear AS 入学年度,s.IdCard AS 身份证号,  "
		" s.ZhuSu AS 是否住宿,s.CunChe AS 是否存车, s.PinKun AS 贫困生, s.TeKun AS 特困生"
		",s.DepId,s.SpeId,s.FillinPerson,s.FillinTime "
		" FROM Student s, Speciality p, DepInfo d WHERE s.DepId = d.DepId AND s.SpeId = p.SpeId";

	// 若选择的不是根节点
	if(m_tree.GetItemData(node) != 0)		// 不是根节点
	{
		// 第2级节点
		if(m_tree.GetItemData(m_tree.GetParentItem(node)) != 0)
		{
			cSource += " AND d.DepId = " + cDepId;
		}
		// 第1级节点
		else
		{
			cSource += " AND (d.UID = " + cDepId + " OR d.DepId = " + cDepId + ")";
		}
	}

	//刷新ADO Data控件的记录源
	m_Adodc.SetRecordSource(cSource);
	m_Adodc.Refresh();
	
	//设置列宽度
	_variant_t vIndex;
	vIndex = long(0);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(1);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(2);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(30);
	vIndex = long(3);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(70);
	vIndex = long(4);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(5);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(50);
	vIndex = long(6);  //身份证号
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(80);
	vIndex = long(7);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(50);
	vIndex = long(8);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(50);
	vIndex = long(9);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(40);
	vIndex = long(10);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(40);
	vIndex = long(11);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(12);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(13);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(14);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
}

void CStuManDlg::AddtoTree(HTREEITEM m_node, int UpperId)
{
	//使用递归方法将院系添加到TreeView控件中
	int i;
	HTREEITEM m_child;

	//依次访问dep对象中的院系数组，查找满足条件的记录添加到Tree控件中
	for(i=0; i<dep.a_UID.GetSize(); i++)
	{
		//@@@@ 打开a_UID数组中等于UpperId的元素
		//@@@@ 表明此元素为当前根节点的子节点，因此将其添加到Tree控件中，新节点为m_child
		//@@@@ 使用SetItemData()函数将院系编号值也保存在新节点中
		//@@@@ 以新节点为根节点，再次递归调用AddtoTree()函数，将其子节点添加到Tree控件中
		if (UpperId == atoi(dep.a_UID.GetAt(i)))
		{
			m_child = m_tree.InsertItem(dep.a_DepName.GetAt(i), m_node);
			m_tree.SetItemData(m_child, atol(dep.a_DepId.GetAt(i)));
			AddtoTree(m_child, atoi(dep.a_DepId.GetAt(i)));
		}
	}
}

// 选择院系
void CStuManDlg::OnSelchangedTree1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	RefreshData();

	*pResult = 0;
}

// 添加按钮
void CStuManDlg::OnAddButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);

	HTREEITEM node;  // 用于保存当前节点
	node = m_tree.GetSelectedItem(); //取得当前节点值
	int iDepId;
	iDepId = m_tree.GetItemData(node);
	if (iDepId == 0)  // 不能在根节点添加学生
	{
		MessageBox("请选择院系");
		return;
	}
	// 在系级单位添加学生信息
	if(iDepId != 0)		// 不是根节点
	{
		if(m_tree.GetItemData(m_tree.GetParentItem(node)) == 0)
		{
			MessageBox("应该在系级单位添加学生信息");
			return;
		}
	}
	
	CStuEditDlg dlg;
	// 初始化变量
	dlg.cStuId = "";		// 学生编号为""，表示添加
	dlg.DepId = iDepId;		// 院系编号
	dlg.SpeId = 0;			// 专业信息
	dlg.cSex = "男";		// 性别初始化为男
	dlg.m_Year = 2006;
	// 设置为当天
	CTime CurrentTime = CTime::GetCurrentTime();
	dlg.m_FillinTime = CurrentTime.Format("%Y-%m-%d");
	dlg.m_FillinPerson = curUser.UserName;
	if (dlg.DoModal() == IDOK)
		RefreshData();
}

// 修改按钮
void CStuManDlg::OnModiButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);

	if (m_Adodc.GetRecordset().GetEof())
	{
		MessageBox("请选择要修改的记录!");
		return;
	}

	// 读取选择学生的记录
	CStudent cur;
	cur.GetInfo(m_Datagrid.GetItem(0));

	// 将学生数据读取到编辑对话框中
	CStuEditDlg dlg;
	dlg.cStuId = m_Datagrid.GetItem(0);
	dlg.Name = m_Datagrid.GetItem(1);
	dlg.DepId = atol(m_Datagrid.GetItem(11));
	dlg.SpeId = atol(m_Datagrid.GetItem(12));

	dlg.m_name = m_Datagrid.GetItem(1);
	dlg.cSex = m_Datagrid.GetItem(2);
	dlg.cSpe = m_Datagrid.GetItem(3);
	dlg.m_ClassName = m_Datagrid.GetItem(4);
	dlg.m_Year = atoi(m_Datagrid.GetItem(5));
	dlg.m_IdCard = m_Datagrid.GetItem(6);
	if(m_Datagrid.GetItem(7) == "是")
		dlg.m_ZhuSu = true;
	else
		dlg.m_ZhuSu = false;
	if(m_Datagrid.GetItem(8) == "是")
		dlg.m_CunChe = true;
	else
		dlg.m_CunChe = false;
	if(m_Datagrid.GetItem(9) == "是")
		dlg.m_PinKun = true;
	else
		dlg.m_PinKun = false;
	if(m_Datagrid.GetItem(10) == "是")
		dlg.m_TeKun = true;
	else
		dlg.m_TeKun = false;
	dlg.m_FillinPerson = m_Datagrid.GetItem(13);
	dlg.m_FillinTime = m_Datagrid.GetItem(14);

	if (dlg.DoModal() == IDOK)
		RefreshData();
}

// 删除按钮
void CStuManDlg::OnDelButton() 
{
	// TODO: Add your control notification handler code here
	if (m_Adodc.GetRecordset().GetEof())
	{
		MessageBox("请选择要删除的记录!");
		return;
	}

	//读取选择学生的记录
	if (MessageBox("是否删除当前记录？","请确认", MB_YESNO) == IDYES)
	{
		CStudent cur;
		cur.SqlDelete(m_Datagrid.GetItem(0));
		RefreshData();
	}	
}