// ChargeManDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ChargeManage.h"
#include "ChargeManDlg.h"
#include "ChargeEdiDlg.h"
#include "StuCharge.h"
#include "DepInfo.h"
#include "Speciality.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;

/////////////////////////////////////////////////////////////////////////////
// CChargeManDlg dialog


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


void CChargeManDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChargeManDlg)
	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(CChargeManDlg, CDialog)
	//{{AFX_MSG_MAP(CChargeManDlg)
	ON_NOTIFY(TVN_SELCHANGED, IDC_TREE1, OnSelchangedTree1)
	ON_BN_CLICKED(IDC_CHARGE_BUTTON, OnChargeButton)
	ON_BN_CLICKED(IDC_RECHARGE_BUTTON, OnRechargeButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CChargeManDlg message handlers

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

	// TODO: Add extra initialization here
	//權限控制，如果不是管理員則添加、修改和刪除按鈕置灰
	if (curUser.UserType != 1)
	{
		GetDlgItem(IDC_CHARGE_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_RECHARGE_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 CChargeManDlg::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 c.ChgId,c.StuId,s.Name AS 學生姓名, c.ChargeDate AS 收費日期,"
		"c.iYear AS 學年, c.Should_Tuition AS 應交學費, c.Fact_Tuition AS 實交學費, "
		"(c.Should_Tuition-c.Fact_Tuition) AS 所欠學費,"
		" c.Should_Incidental AS 應交雜費, c.Fact_Incidental AS 實交雜費,"
		"(c.Should_Incidental-c.Fact_Incidental) AS 所欠雜費,"
		" c.Should_MacTimeFee AS 應交機時費, c.Fact_MacTimeFee AS 實交機時費,"
		"(c.Should_MacTimeFee-c.Fact_MacTimeFee) AS 所欠機時費,"
		" c.Should_Insurance AS 應交保險費, c.Fact_Insurance AS 實交保險費,"
		"(c.Should_Insurance-c.Fact_Insurance) AS 所欠保險費,"
		" c.Should_DormFee AS 應交住宿費, c.Fact_DormFee AS 實交住宿費,"
		"(c.Should_DormFee-c.Fact_DormFee) AS 所欠住宿費,"
		" c.Should_BicycleFee AS 應交存車費, c.Fact_BicycleFee AS 實交存車費,"
		"(c.Should_BicycleFee-c.Fact_BicycleFee) AS 所欠存車費,"
		" c.Should_BookFee AS 應交書費, c.Fact_BookFee AS 實交書費,"
		"(c.Should_BookFee-c.Fact_BookFee) AS 所欠書費,"
		" c.Should_FileFee AS 應交資料費, c.Fact_FileFee AS 實交資料費, "
		"(c.Should_FileFee-c.Fact_FileFee) AS 所欠資料費,"
		" c.Should_Total AS 應交合計, c.Fact_Total AS 實交合計,"
		"(c.Should_Total-c.Fact_Total) AS 所欠合計, c.Memo AS 備注"
		" FROM StuCharge c, Student s, DepInfo d WHERE c.StuId = s.StuId AND s.DepId = d.DepId";

	// 若選擇的不是根節點
	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(0);
	for(int i=2; i<32; i++)
	{
		vIndex = long(i);
		m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	}
	vIndex = long(32);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(100);
}

void CChargeManDlg::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 CChargeManDlg::OnSelchangedTree1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	RefreshData();

	*pResult = 0;
}

void CChargeManDlg::OnChargeButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);

	CChargeEdiDlg dlg;
	// 初始化變量
	dlg.cId = "";			// 表示添加
	dlg.cStuId = "";			// 學生編號
	dlg.cSpeId = "";			// 專業編號
	dlg.m_Year = 2006;
	dlg.m_name = "無姓名";
	dlg.m_dep = "無部門";
	dlg.m_speciality = "無專業";
	dlg.m_pre = 0.0;
	dlg.m_cur = 0.0;
	dlg.m_lack = 0.0;

	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_memo = "";
	
	if (dlg.DoModal() == IDOK)
		RefreshData();
}
// 補交費用
void CChargeManDlg::OnRechargeButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);

	if (m_Adodc.GetRecordset().GetEof())
	{
		MessageBox("請選擇要修改的記錄!");
		return;
	}
	// 如果費用都繳完，則不需要補交
	if (atol(m_Datagrid.GetItem(31)) == 0)
	{
		MessageBox("費用已繳清，不用補交任何費用!");
		return;
	}
	HTREEITEM node;  // 用于保存當前節點
	node = m_tree.GetSelectedItem(); //取得當前節點值
	CString DepName;
	DepName = m_tree.GetItemText(node);

	CChargeEdiDlg dlg;
	// 初始化變量
	dlg.cId = m_Datagrid.GetItem(0);
	dlg.cStuId = m_Datagrid.GetItem(1);			// 學生編號
	dlg.m_name = m_Datagrid.GetItem(2);
	// 專業信息
	CSpeciality spe;
	// 院系信息
	dlg.m_dep = spe.GetDepName(m_Datagrid.GetItem(1));
	spe.GetInfo(m_Datagrid.GetItem(1));
	dlg.m_speciality = spe.Name;
	dlg.m_Year = atoi(m_Datagrid.GetItem(4));
	dlg.m_total = atol(m_Datagrid.GetItem(29));
	dlg.m_pre = atol(m_Datagrid.GetItem(30));
	dlg.m_cur = atol(m_Datagrid.GetItem(31));
	dlg.m_lack = atol(m_Datagrid.GetItem(31));
	
	dlg.m_tuition = atol(m_Datagrid.GetItem(7));
	dlg.m_incidental = atol(m_Datagrid.GetItem(10));
	dlg.m_MacTimeFee = atol(m_Datagrid.GetItem(13));
	dlg.m_insurance = atol(m_Datagrid.GetItem(16));
	dlg.m_DormFee = atol(m_Datagrid.GetItem(19));
	dlg.m_BicycleFee = atol(m_Datagrid.GetItem(22));
	dlg.m_BookFee = atol(m_Datagrid.GetItem(25));
	dlg.m_FileFee = atol(m_Datagrid.GetItem(28));

	dlg.m_memo = m_Datagrid.GetItem(32);

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