?? chargeitemmandlg.cpp

?? VC++做的學(xué)校收費管理系統(tǒng),很有參考價值,附上源碼與說明文檔.
?? CPP
字號:
// ChargeItemManDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ChargeManage.h"
#include "ChargeItemManDlg.h"
#include "ChargeItemEditDlg.h"
#include "ChargeItem.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;

/////////////////////////////////////////////////////////////////////////////
// CChargeItemManDlg dialog


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


void CChargeItemManDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChargeItemManDlg)
	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(CChargeItemManDlg, CDialog)
	//{{AFX_MSG_MAP(CChargeItemManDlg)
	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()

/////////////////////////////////////////////////////////////////////////////
// CChargeItemManDlg message handlers

BOOL CChargeItemManDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();

	// TODO: Add extra initialization here
	//權(quán)限控制，如果不是管理員則添加、修改和刪除按鈕置灰
	if (curUser.UserType != 1)
	{
		GetDlgItem(IDC_ADD_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_MODI_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_DEL_BUTTON)->EnableWindow(FALSE);
	}

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

	//添加根節(jié)點
	m_treeImageList.Create(16,16,FALSE,1,0);  //創(chuàng)建CImageList控件
	//裝入ICON資源
	HICON hIcon = ::LoadIcon(AfxGetResourceHandle(), MAKEINTRESOURCE(IDI_ICON1));
	m_treeImageList.Add(hIcon);  //將ICON資源添加到CImageList控件中
	//將CImageList控件與Tree控件相關(guān)聯(lián)	
	m_tree.SetImageList(&m_treeImageList, LVSIL_NORMAL);
	m_root = m_tree.InsertItem("院系信息");  //添加根節(jié)點
	//調(diào)用AddtoTree() 函數(shù)，將所有院系信息添加到Tree控件中	
	AddtoTree(m_root, 0);
	m_tree.Expand(m_root, TVE_EXPAND); //展開根節(jié)點
	//選中根節(jié)點
	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 CChargeItemManDlg::RefreshData()
{
	UpdateData(TRUE);

	//從Tree控件中讀取院系編號信息
	int iDepId;
	HTREEITEM node;
	node = m_tree.GetSelectedItem();
	iDepId = m_tree.GetItemData(node);

	//根據(jù)院系編號設(shè)置SELECT語句
	CString cDepId;
	cDepId.Format("%d", iDepId);

	// 設(shè)置SELECT語句
	CString cSource = "SELECT c.ItemId, c.SpeId,s.Name AS 專業(yè)名稱,c.iYear AS 學(xué)年,"
		"(c.Tuition+c.Incidental+c.MacTimeFee+c.Insurance+c.DormFee"
		"+c.BicycleFee+c.BookFee+c.FileFee)  AS 合計,c.Tuition AS 學(xué)費,"
		" c.Incidental AS 雜費, c.MacTimeFee AS 機時費, c.Insurance AS 保險費,"
		" c.DormFee AS 住宿費, c.BicycleFee AS 存車費, c.BookFee AS 書費,"
		" c.FileFee AS 資料費 FROM ChargeItem c, Speciality s, DepInfo d "
		" WHERE s.DepId = d.DepId AND c.SpeId = s.SpeId";

	// 若選擇的不是根節(jié)點
	if(m_tree.GetItemData(node) != 0)		// 不是根節(jié)點
	{
		// 第2級節(jié)點
		if(m_tree.GetItemData(m_tree.GetParentItem(node)) != 0)
		{
			cSource += " AND s.DepId = " + cDepId;
		}
		// 第1級節(jié)點
		else
		{
			cSource += " AND (d.UID = " + cDepId + " OR s.DepId = " + cDepId + ")";
		}
	}
	//刷新ADO Data控件的記錄源
	m_Adodc.SetRecordSource(cSource);
	m_Adodc.Refresh();	
	//設(shè)置列寬度
	_variant_t vIndex;
	vIndex = long(0);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(1);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(2);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(80);
	vIndex = long(3);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(30);
	vIndex = long(4);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(50);
	vIndex = long(5);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(40);
	vIndex = long(6);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(40);
	vIndex = long(7);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(40);
	vIndex = long(8);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(40);
	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(40);
	vIndex = long(12);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(40);
}

void CChargeItemManDlg::AddtoTree(HTREEITEM m_node, int UpperId)
{
	//使用遞歸方法將院系添加到TreeView控件中
	long i;
	HTREEITEM m_child;

	//依次訪問dep對象中的院系數(shù)組，查找滿足條件的記錄添加到Tree控件中
	for(i=0; i<dep.a_UID.GetSize(); i++)
	{
		//@@@@ 打開a_UID數(shù)組中等于UpperId的元素
		//@@@@ 表明此元素為當(dāng)前根節(jié)點的子節(jié)點，因此將其添加到Tree控件中，新節(jié)點為m_child
		//@@@@ 使用SetItemData()函數(shù)將院系編號值也保存在新節(jié)點中
		//@@@@ 以新節(jié)點為根節(jié)點，再次遞歸調(diào)用AddtoTree()函數(shù)，將其子節(jié)點添加到Tree控件中
		if (UpperId == atol(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, atol(dep.a_DepId.GetAt(i)));
		}
	}
}

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

	*pResult = 0;
}

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

	HTREEITEM node;  // 用于保存當(dāng)前節(jié)點
	node = m_tree.GetSelectedItem(); //取得當(dāng)前節(jié)點值
	long iDepId;
	iDepId = m_tree.GetItemData(node);
	if (iDepId == 0)  // 不能在根節(jié)點添加收費信息
	{
		MessageBox("請選擇院系");
		return;
	}
	// 在系級單位添加收費信息
	if(iDepId != 0)		// 不是根節(jié)點
	{
		if(m_tree.GetItemData(m_tree.GetParentItem(node)) == 0)
		{
			MessageBox("應(yīng)該在系級單位添加收費信息");
			return;
		}
	}
	
	CChargeItemEditDlg dlg;
	// 初始化變量
	dlg.cItemId = "";
	dlg.DepId = iDepId;		// 院系編號
	dlg.SpeId = 0;			// 專業(yè)編號
	dlg.m_Year = 2006;
	dlg.m_tuition = 0.0;
	dlg.m_incidental = 0.0;
	dlg.m_MacTimeFee = 0.0;
	dlg.m_insurance = 0.0;
	dlg.m_DormFee = 0.0;
	dlg.m_BicycleFee = 0.0;
	dlg.m_BookFee = 0.0;
	dlg.m_FileFee = 0.0;
	dlg.m_total = 0.0;

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

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

	if (m_Adodc.GetRecordset().GetEof())
	{
		MessageBox("請選擇要修改的記錄!");
		return;
	}

	// 讀取選擇學(xué)生的記錄
	CChargeItem cur;
	cur.GetInfo(m_Datagrid.GetItem(0));
	// 將收費信息讀取到編輯對話框中
	CChargeItemEditDlg dlg;
	dlg.cItemId = m_Datagrid.GetItem(0);
	dlg.SpeId = atol(m_Datagrid.GetItem(1));
	dlg.cSpe = m_Datagrid.GetItem(2);
	dlg.m_Year = atoi(m_Datagrid.GetItem(3));
	dlg.m_total = atof(m_Datagrid.GetItem(4));
	dlg.m_tuition = atof(m_Datagrid.GetItem(5));
	dlg.m_incidental = atof(m_Datagrid.GetItem(6));
	dlg.m_MacTimeFee = atof(m_Datagrid.GetItem(7));
	dlg.m_insurance = atof(m_Datagrid.GetItem(8));
	dlg.m_DormFee = atof(m_Datagrid.GetItem(9));
	dlg.m_BicycleFee = atof(m_Datagrid.GetItem(10));
	dlg.m_BookFee = atof(m_Datagrid.GetItem(11));
	dlg.m_FileFee = atof(m_Datagrid.GetItem(12));

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

// 刪除按鈕
void CChargeItemManDlg::OnDelButton() 
{
	// TODO: Add your control notification handler code here
	if (m_Adodc.GetRecordset().GetEof())
	{
		MessageBox("請選擇要刪除的記錄!");
		return;
	}

	//讀取選擇收費記錄
	if (MessageBox("是否刪除當(dāng)前記錄？","請確認(rèn)", MB_YESNO) == IDYES)
	{
		// 判斷收費記錄中是否使用了此編號

		CChargeItem cur;
		cur.SqlDelete(m_Datagrid.GetItem(0));
		RefreshData();
	}	
}
?? 文件大小 1924 K
?? 上傳用戶 zxyxwd6
?? 所屬分類教育系統(tǒng)應(yīng)用
??? 相關(guān)標(biāo)簽

#VC #收費 #價值 #管理系統(tǒng)
?? 快捷鍵說明

復(fù)制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? chargeitemmandlg.cpp

?? 快捷鍵說明
