?? evamandlg.cpp
字號:
// EvaManDlg.cpp : implementation file
//
#include "stdafx.h"
#include "HrSys.h"
#include "EvaManDlg.h"
#include "EvaEditDlg.h"
#include "DepSelDlg.h"
#include "_recordset.h"
#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
extern CUsers curUser;
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CEvaManDlg dialog
CEvaManDlg::CEvaManDlg(CWnd* pParent /*=NULL*/)
: CDialog(CEvaManDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CEvaManDlg)
m_DepName = _T("");
//}}AFX_DATA_INIT
}
void CEvaManDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CEvaManDlg)
DDX_Control(pDX, IDC_YEAR_COMBO, m_year);
DDX_Control(pDX, IDC_MONTH_COMBO, m_month);
DDX_Control(pDX, IDC_ADODC1, m_adodc);
DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
DDX_Text(pDX, IDC_DEPNAME_STATIC, m_DepName);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CEvaManDlg, CDialog)
//{{AFX_MSG_MAP(CEvaManDlg)
ON_BN_CLICKED(IDC_SET_BUTTON, OnSetButton)
ON_BN_CLICKED(IDC_SETDEP_BUTTON, OnSetdepButton)
ON_CBN_SELCHANGE(IDC_MONTH_COMBO, OnSelchangeMonthCombo)
ON_CBN_SELCHANGE(IDC_YEAR_COMBO, OnSelchangeYearCombo)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CEvaManDlg message handlers
void CEvaManDlg::Refresh_Data()
{
CString cSource;
CString cDepId;
cDepId.Format("%d", iDepId);
//讀取月份信息
CString cYear, cMonth;
int index;
index = m_year.GetCurSel();
m_year.GetLBText(index, cYear);
index = m_month.GetCurSel();
m_month.GetLBText(index, cMonth);
cSource = "SELECT e.Emp_Id, e.Emp_Name AS 員工姓名, ISNULL(v.ZtEva,'') AS 總體評價, ISNULL(v.jlReason,'') AS 獎勵事由,";
cSource += " ISNULL(v.jlAmount,0) AS 獎勵金額, ISNULL(v.cfReason,'') AS 處罰事由, ISNULL(v.cfAmount,0) AS 處罰金額,";
cSource += " ISNULL(v.Memo,'') AS 備注信息 FROM Employees e, Evaluation v WHERE e.Emp_Id*=v.Emp_Id";
cSource += " AND v.EvaMonth='" + cYear + "-" + cMonth + "' AND Dep_Id=" + cDepId;
m_adodc.SetRecordSource(cSource);
m_adodc.Refresh();
//設置列寬度
_variant_t vIndex;
vIndex = long(0);
m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
}
BOOL CEvaManDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
//權限控制,如果不是系統管理員則設置置灰
if (curUser.GetUser_type() != 1)
GetDlgItem(IDC_SET_BUTTON)->EnableWindow(FALSE);
CTime t = CTime::GetCurrentTime(); //讀取當前系統日期
int iYear, iMonth;
iYear = t.GetYear();
iMonth = t.GetMonth();
m_year.SetCurSel(iYear - 2000);
m_month.SetCurSel(iMonth - 1);
UpdateData(FALSE);
Refresh_Data();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CEvaManDlg::OnSetButton()
{
// TODO: Add your control notification handler code here
if (m_adodc.GetRecordset().GetEof())
{
MessageBox("請選擇員工記錄");
return;
}
//讀取月份信息
CString cYear, cMonth;
int index;
index = m_year.GetCurSel();
m_year.GetLBText(index, cYear);
index = m_month.GetCurSel();
m_month.GetLBText(index, cMonth);
CEvaEditDlg dlg;
dlg.m_Month = cYear + "-" + cMonth; //考評月份
dlg.iEmpId = atoi(m_datagrid.GetItem(0)); //考評員工編號
dlg.m_EmpName = m_datagrid.GetItem(1); //考評員工姓名
dlg.m_Zt = m_datagrid.GetItem(2); //總體評價
dlg.m_jlReason = m_datagrid.GetItem(3); //獎勵事由
dlg.m_jlAmount = atoi(m_datagrid.GetItem(4)); //獎勵金額
dlg.m_cfReason = m_datagrid.GetItem(5); //處罰事由
dlg.m_cfAmount = atoi(m_datagrid.GetItem(6)); //處罰金額
dlg.m_Memo = m_datagrid.GetItem(7); //備注
if (dlg.DoModal() == IDOK)
Refresh_Data();
}
void CEvaManDlg::OnSetdepButton()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
//打開選擇部門對話框
CDepSelDlg dlg;
dlg.DoModal();
//從對話框中讀取選擇部門的信息
iDepId = dlg.DepId;
m_DepName = dlg.DepName;
UpdateData(FALSE);
//根據選擇的部門信息,刷新表格數據
Refresh_Data();
}
void CEvaManDlg::OnSelchangeMonthCombo()
{
// TODO: Add your control notification handler code here
Refresh_Data();
}
void CEvaManDlg::OnSelchangeYearCombo()
{
// TODO: Add your control notification handler code here
Refresh_Data();
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -