// EmpManDlg.cpp : implementation file
//

#include "stdafx.h"
#include "HrSys.h"
#include "EmpManDlg.h"
#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
#include "EmpEditDlg.h"
#include "_recordset.h"
#include "Employees.h"
//#include "TransferDlg.h"
#include "Departments.h"
#include "Users.h"

extern CUsers curUser;

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

/////////////////////////////////////////////////////////////////////////////
// CEmpManDlg dialog


CEmpManDlg::CEmpManDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CEmpManDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CEmpManDlg)
	//}}AFX_DATA_INIT
}


void CEmpManDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEmpManDlg)
	DDX_Control(pDX, IDC_TYPE_COMBO, m_combo);
	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(CEmpManDlg, CDialog)
	//{{AFX_MSG_MAP(CEmpManDlg)
	ON_CBN_SELCHANGE(IDC_TYPE_COMBO, OnSelchangeTypeCombo)
	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()

/////////////////////////////////////////////////////////////////////////////
// CEmpManDlg message handlers

BOOL CEmpManDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//權(quán)限控制，如果不是系統(tǒng)管理員則添加、修改和刪除按鈕置灰
	if (curUser.UserType.Find("系統(tǒng)管理員") < 0)
	{
		GetDlgItem(IDC_ADD_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_MODI_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_DEL_BUTTON)->EnableWindow(FALSE);
	}
	//裝入部門(mén)信息
	dep.Load_dep();
	
	//添加根節(jié)點(diǎn)
	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("部門(mén)信息");  //添加根節(jié)點(diǎn)
	//調(diào)用AddtoTree() 函數(shù)，將所有部門(mén)信息添加到Tree控件中	
	AddtoTree(m_root, 0);
	m_tree.Expand(m_root, TVE_EXPAND); //展開(kāi)根節(jié)點(diǎn)
	//選中根節(jié)點(diǎn)
	m_tree.SelectItem(m_root);

	//設(shè)置員工狀態(tài)屬性
	m_combo.SetCurSel(0);

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

void CEmpManDlg::AddtoTree(HTREEITEM m_node, int UpperId)
{
	//使用遞歸方法將部門(mén)添加到TreeView控件中
	int i;
	HTREEITEM m_child;
	//依次訪(fǎng)問(wèn)dep對(duì)象中的部門(mén)數(shù)組，查找滿(mǎn)足條件的記錄添加到Tree控件中
	for(i=0; i<dep.a_UpperId.GetSize(); i++)
	{
		//@@@@ 打開(kāi)a_UpperId數(shù)組中等于UpperId的元素
		//@@@@ 表明此元素為當(dāng)前根節(jié)點(diǎn)的子節(jié)點(diǎn)，因此將其添加到Tree控件中，新節(jié)點(diǎn)為m_child
		//@@@@ 使用SetItemData()函數(shù)將部門(mén)編號(hào)值也保存在新節(jié)點(diǎn)中
		//@@@@ 以新節(jié)點(diǎn)為根節(jié)點(diǎn)，再次遞歸調(diào)用AddtoTree()函數(shù)，將其子節(jié)點(diǎn)添加到Tree控件中
		if (UpperId == atoi(dep.a_UpperId.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 CEmpManDlg::Refresh_Data()
{
	UpdateData(TRUE);
	//從Tree控件中讀取部門(mén)編號(hào)信息
	int iDepId;
	HTREEITEM node;
	node = m_tree.GetSelectedItem();
	iDepId = m_tree.GetItemData(node);
	//根據(jù)部門(mén)編號(hào)設(shè)置SELECT語(yǔ)句
	CString cDepId;
	cDepId.Format("%d", iDepId);
	CString cSource = "SELECT EmpId, EmpName AS 姓名, Sex AS 性別,";
	cSource += " Political_Party AS 政治面貌, Culture_Level 文化程度, Position1 AS 崗位,";
	cSource	+= " Title AS 職務(wù) FROM Employees WHERE DepId=" + cDepId;

	//讀取員工狀態(tài)值，并根據(jù)它生成SELECT語(yǔ)句的條件
	int iType = m_combo.GetCurSel();
	CString cType;
	cType.Format("%d", iType);
	if (iType > 0)
		cSource += " AND State=" + cType;
	//刷新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(50);
	vIndex = long(2);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(30);
	vIndex = long(3);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(57);
	vIndex = long(4);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(5);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(6);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
}

void CEmpManDlg::OnSelchangeTypeCombo() 
{
	// TODO: Add your control notification handler code here
	Refresh_Data();
}

void CEmpManDlg::OnSelchangedTree1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	Refresh_Data();

	*pResult = 0;
}

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

	HTREEITEM node;  //用于保存當(dāng)前節(jié)點(diǎn)
	node = m_tree.GetSelectedItem(); //取得當(dāng)前節(jié)點(diǎn)值
	int iDepId;
	iDepId = m_tree.GetItemData(node);
	if (iDepId == 0)  //不能在根節(jié)點(diǎn)添加員工
	{
		MessageBox("請(qǐng)選擇部門(mén)");
		return;
	}

	CEmpEditDlg dlg;
	//初始化變量
	dlg.EmpId = 0;  //員工編號(hào)為0，表示添加
	dlg.DepId = iDepId; //部門(mén)編號(hào)
	dlg.cSex = "男";  //性別初始化為男
	int iState;  //根據(jù)當(dāng)前的員工狀態(tài)設(shè)置編輯對(duì)話(huà)框中的員工狀態(tài)
	iState = m_combo.GetCurSel();
	if (iState == 0)
		dlg.iState = 1;
	else
		dlg.iState = iState;
	
	//添加員工時(shí)，將日期控件設(shè)置為當(dāng)天
	CTime t = CTime::GetCurrentTime();
	dlg.m_Birth = t;
	dlg.m_HireDate = t;
	dlg.m_Filltime = t.Format("%Y-%m-%d");
	dlg.m_Fillperson = curUser.UserName;
	if (dlg.DoModal() == IDOK)
		Refresh_Data();
}

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

	if (m_Adodc.GetRecordset().GetEof())
	{
		MessageBox("請(qǐng)選擇要修改的記錄!");
		return;
	}
	//讀取選擇員工的記錄
	CEmployees emp;
	emp.GetData(m_datagrid.GetItem(0));
	//將員工數(shù)據(jù)讀取到編輯對(duì)話(huà)框中
	CEmpEditDlg dlg;
	dlg.EmpId = emp.EmpId;
	dlg.EmpName = emp.EmpName;
	dlg.DepId = emp.DepId;
	dlg.UpperId = emp.UpperId;

	dlg.m_EmpName = emp.EmpName;
	dlg.cSex = emp.Sex;
	dlg.m_Nation = emp.Nationality;
	//設(shè)置日期數(shù)據(jù)
	int yy=atoi(emp.Birth.Left(4));
	int mm=atoi(emp.Birth.Mid(6,2));
	int dd=atoi(emp.Birth.Right(2));
	CTime t(yy,mm,dd,0,0,0);
	dlg.m_Birth = t;
	dlg.m_Marital = emp.Marital_Condition;
	dlg.m_Political = emp.Political_Party;
	dlg.m_Culture = emp.Culture_Level;
	dlg.m_Family = emp.Family_Place;
	dlg.m_Badge = emp.BadgeId;
	dlg.m_Idcard = emp.Id_Card;
	dlg.m_Office = emp.Office_phone;
	dlg.m_Mobile = emp.Mobile;
	dlg.m_File = emp.Files_Keep_Org;
	dlg.m_Hukou = emp.Hukou;

  //設(shè)置日期數(shù)據(jù)
	yy=atoi(emp.HireDate.Left(4));
	mm=atoi(emp.HireDate.Mid(6,2));
	dd=atoi(emp.HireDate.Right(2));
	CTime tt(yy,mm,dd,0,0,0);
	dlg.m_HireDate = tt;
	
	dlg.m_Position = emp.Position;
	dlg.m_Title = emp.sTitle;
	CString cId;
	cId.Format("%d", emp.UpperId);
	dlg.m_Upper = emp.GetName(cId);
	dlg.iState = emp.State;
	dlg.m_Memo = emp.Memo;
	dlg.m_Fillperson = emp.Fillin_Person;
	dlg.m_Filltime = emp.Fillin_Time;

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

void CEmpManDlg::OnDelButton() 
{
	// TODO: Add your control notification handler code here
	if (m_Adodc.GetRecordset().GetEof())
	{
		MessageBox("請(qǐng)選擇要?jiǎng)h除的記錄!");
		return;
	}
	//讀取選擇員工的記錄
	if (MessageBox("是否刪除當(dāng)前記錄？","請(qǐng)確認(rèn)", MB_YESNO) == IDYES)
	{
		CEmployees emp;
		emp.sql_delete(m_datagrid.GetItem(0));
		Refresh_Data();
	}	
}