?? empmandlg.cpp
字號:
// 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 "FamilyManDlg.h"
#include "ExpManDlg.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)
ON_BN_CLICKED(IDC_TRANSFER_BUTTON, OnTransferButton)
ON_BN_CLICKED(IDC_FAMILY_BUTTON, OnFamilyButton)
ON_BN_CLICKED(IDC_EXP_BUTTON, OnExpButton)
//}}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.GetUser_type() != 1)
{
GetDlgItem(IDC_ADD_BUTTON)->EnableWindow(FALSE);
GetDlgItem(IDC_MODI_BUTTON)->EnableWindow(FALSE);
GetDlgItem(IDC_DEL_BUTTON)->EnableWindow(FALSE);
GetDlgItem(IDC_TRANSFER_BUTTON)->EnableWindow(FALSE);
GetDlgItem(IDC_EXP_BUTTON)->EnableWindow(FALSE);
GetDlgItem(IDC_FAMILY_BUTTON)->EnableWindow(FALSE);
}
//裝入部門信息
dep.Load_dep();
//添加根節(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);
//設(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)
{
//使用遞歸方法將部門添加到TreeView控件中
int i;
HTREEITEM m_child;
//依次訪問dep對象中的部門數(shù)組，查找滿足條件的記錄添加到Tree控件中
for(i=0; i<dep.a_UpperId.GetSize(); i++)
{
//@@@@ 打開a_UpperId數(shù)組中等于UpperId的元素
//@@@@ 表明此元素為當前根節(jié)點的子節(jié)點，因此將其添加到Tree控件中，新節(jié)點為m_child
//@@@@ 使用SetItemData()函數(shù)將部門編號值也保存在新節(jié)點中
//@@@@ 以新節(jié)點為根節(jié)點，再次遞歸調(diào)用AddtoTree()函數(shù)，將其子節(jié)點添加到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控件中讀取部門編號信息
int iDepId;
HTREEITEM node;
node = m_tree.GetSelectedItem();
iDepId = m_tree.GetItemData(node);
//根據(jù)部門編號設(shè)置SELECT語句
CString cDepId;
cDepId.Format("%d", iDepId);
CString cSource = "SELECT Emp_Id, Emp_Name AS 姓名, Sex AS 性別,";
cSource += " Political_Party AS 政治面貌, Culture_Level 文化程度, Position AS 崗位,";
cSource += " Title AS 職務(wù) FROM Employees WHERE Dep_Id=" + cDepId;
//讀取員工狀態(tài)值，并根據(jù)它生成SELECT語句的條件
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; //用于保存當前節(jié)點
node = m_tree.GetSelectedItem(); //取得當前節(jié)點值
int iDepId;
iDepId = m_tree.GetItemData(node);
if (iDepId == 0) //不能在根節(jié)點添加員工
{
MessageBox("請選擇部門");
return;
}
CEmpEditDlg dlg;
//初始化變量
dlg.EmpId = 0; //員工編號為0，表示添加
dlg.DepId = iDepId; //部門編號
dlg.cSex = "男"; //性別初始化為男
int iState; //根據(jù)當前的員工狀態(tài)設(shè)置編輯對話框中的員工狀態(tài)
iState = m_combo.GetCurSel();
if (iState == 0)
dlg.iState = 1;
else
dlg.iState = iState;
//添加員工時，將日期控件設(shè)置為當天
CTime t = CTime::GetCurrentTime();
dlg.m_Birth = t;
dlg.m_HireDate = t;
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("請選擇要修改的記錄!");
return;
}
//讀取選擇員工的記錄
CEmployees emp;
emp.GetData(m_datagrid.GetItem(0));
//將員工數(shù)據(jù)讀取到編輯對話框中
CEmpEditDlg dlg;
dlg.EmpId = emp.GetEmp_Id();
dlg.EmpName = emp.GetEmp_Name();
dlg.DepId = emp.GetDep_Id();
dlg.UpperId = emp.GetUpperId();
dlg.m_EmpName = emp.GetEmp_Name();
dlg.cSex = emp.GetSex();
dlg.m_Nation = emp.GetNationality();
//設(shè)置日期數(shù)據(jù)
int yy=atoi(emp.GetBirth().Left(4));
int mm=atoi(emp.GetBirth().Mid(6,2));
int dd=atoi(emp.GetBirth().Right(2));
CTime t(yy,mm,dd,0,0,0);
dlg.m_Birth = t;
dlg.m_Marital = emp.GetMarital_Condition();
dlg.m_Political = emp.GetPolitical_Party();
dlg.m_Culture = emp.GetCulture_Level();
dlg.m_Family = emp.GetFamily_Place();
dlg.m_Badge = emp.GetBadgeId();
dlg.m_Idcard = emp.GetId_Card();
dlg.m_Office = emp.GetOffice_phone();
dlg.m_Mobile = emp.GetMobile();
dlg.m_File = emp.GetFiles_Keep_Org();
dlg.m_Hukou = emp.GetHukou();
//設(shè)置日期數(shù)據(jù)
yy=atoi(emp.GetHireDate().Left(4));
mm=atoi(emp.GetHireDate().Mid(6,2));
dd=atoi(emp.GetHireDate().Right(2));
CTime tt(yy,mm,dd,0,0,0);
dlg.m_HireDate = tt;
dlg.m_Position = emp.GetPosition();
dlg.m_Title = emp.GetTitle();
CString cId;
cId.Format("%d", emp.GetUpperId());
dlg.m_Upper = emp.GetName(cId);
dlg.m_Contract = emp.GetContract_Duration();
dlg.iState = emp.GetState();
dlg.m_Memo = emp.GetMemo();
dlg.m_Fillperson = emp.GetFillin_Person();
dlg.m_Filltime = emp.GetFillin_Time();
if (dlg.DoModal() == IDOK)
Refresh_Data();
}
void CEmpManDlg::OnDelButton()
{
// TODO: Add your control notification handler code here
if (m_Adodc.GetRecordset().GetEof())
{
MessageBox("請選擇要刪除的記錄!");
return;
}
//讀取選擇員工的記錄
if (MessageBox("是否刪除當前記錄？","請確認", MB_YESNO) == IDYES)
{
CEmployees emp;
emp.sql_delete(m_datagrid.GetItem(0));
Refresh_Data();
}
}
void CEmpManDlg::OnTransferButton()
{
// TODO: Add your control notification handler code here
if (m_Adodc.GetRecordset().GetEof())
{
MessageBox("請選擇記錄!");
return;
}
//讀取選擇員工的記錄
CEmployees emp;
emp.GetData(m_datagrid.GetItem(0));
CString cDepId;
cDepId.Format("%d", emp.GetDep_Id());
CDepartments dep;
dep.GetData(cDepId);
//將員工數(shù)據(jù)讀取到調(diào)轉(zhuǎn)對話框中
CTransferDlg dlg;
dlg.m_Old = dep.GetDep_name();
dlg.DepId = emp.GetDep_Id();
dlg.cEmpId = m_datagrid.GetItem(0);
if (dlg.DoModal() == IDOK)
Refresh_Data();
}
void CEmpManDlg::OnFamilyButton()
{
// TODO: Add your control notification handler code here
if (m_Adodc.GetRecordset().GetEof())
{
MessageBox("請選擇記錄!");
return;
}
//讀取選擇員工的記錄
CFamilyManDlg dlg;
dlg.iEmpId = atoi(m_datagrid.GetItem(0));
dlg.m_EmpName = m_datagrid.GetItem(1);
dlg.DoModal();
}
void CEmpManDlg::OnExpButton()
{
// TODO: Add your control notification handler code here
if (m_Adodc.GetRecordset().GetEof())
{
MessageBox("請選擇記錄!");
return;
}
//讀取選擇員工的記錄
CExpManDlg dlg;
dlg.iEmpId = atoi(m_datagrid.GetItem(0));
dlg.m_EmpName = m_datagrid.GetItem(1);
dlg.DoModal();
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -