checkmandlg.cpp

一个完整的人事管理信息系统

// CheckManDlg.cpp : implementation file
//

#include "stdafx.h"
#include "HrSys.h"
#include "CheckManDlg.h"
#include "DepSelDlg.h"
#include "CheckEditDlg.h"
#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
#include "_recordset.h"
#include "SumCheckDlg.h"

extern CUsers curUser;

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

/////////////////////////////////////////////////////////////////////////////
// CCheckManDlg dialog


CCheckManDlg::CCheckManDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCheckManDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCheckManDlg)
	m_date = 0;
	m_DepName = _T("");
	//}}AFX_DATA_INIT
}


void CCheckManDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCheckManDlg)
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_date);
	DDX_Text(pDX, IDC_DEPNAME_STATIC, m_DepName);
	DDX_Control(pDX, IDC_ADODC1, m_adodc);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCheckManDlg, CDialog)
	//{{AFX_MSG_MAP(CCheckManDlg)
	ON_BN_CLICKED(IDC_SETDEP_BUTTON, OnSetdepButton)
	ON_BN_CLICKED(IDC_SET_BUTTON, OnSetButton)
	ON_BN_CLICKED(IDC_SUM_BUTTON, OnSumButton)
	ON_NOTIFY(DTN_DATETIMECHANGE, IDC_DATETIMEPICKER1, OnDatetimechangeDatetimepicker1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCheckManDlg message handlers
void CCheckManDlg::Refresh_Data()
{
	UpdateData(TRUE);

	CString cSource;
	CString cDepId;
	cDepId.Format("%d", iDepId);

	cSource = "SELECT e.Emp_Id, e.Emp_Name AS 员工姓名, ISNULL(c.qqDays,0) AS 全勤天数,";
	cSource += " ISNULL(c.ccDays,0) AS 出差天数, ISNULL(c.bjDays,0) AS 病假天数,";
	cSource += " ISNULL(c.sjDays,0) AS 事假天数, ISNULL(c.kgDays,0) AS 旷工天数,";
	cSource += " ISNULL(c.fdxjDays,0) AS 法定休假天数, ISNULL(c.nxjDays,0) AS 年休假天数,";
	cSource += " ISNULL(c.dxjDays,0) AS 倒休假天数, ISNULL(c.cdMinutes,0) AS 迟到时间,";
	cSource += " ISNULL(c.ztMinutes,0) AS 早退时间, ISNULL(c.ot1Days,0) AS 一类加班天数,";
	cSource += " ISNULL(c.ot2Days,0) AS 二类加班天数, ISNULL(c.ot3Days,0) AS 三类加班天数,";
	cSource += " ISNULL(c.Memo, '') AS 备注信息";
	cSource += " FROM Employees e, Checkin c WHERE e.Emp_Id*=c.Emp_Id AND c.CheckDate='";
	cSource += m_date.Format("%Y-%m-%d") + "' AND e.Dep_Id=" + cDepId;
	
	m_adodc.SetRecordSource(cSource);
	m_adodc.Refresh();

	//设置列宽度
	_variant_t vIndex;
	vIndex = long(0);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
}

BOOL CCheckManDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//权限控制，如果不是系统管理员则设置和月度考勤按钮置灰
	if (curUser.GetUser_type() != 1)
	{
		GetDlgItem(IDC_SET_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_SUM_BUTTON)->EnableWindow(FALSE);
	}
	CTime t = CTime::GetCurrentTime();  //读取当前系统日期
	m_date = t;
	iDepId = 0;
	m_DepName = "";
	
	UpdateData(FALSE);
	Refresh_Data();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCheckManDlg::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 CCheckManDlg::OnSetButton() 
{
	// TODO: Add your control notification handler code here
	if (m_adodc.GetRecordset().GetEof())
	{
		MessageBox("请选择员工记录");
		return;
	}
	CCheckEditDlg dlg;
	dlg.m_Date = m_date.Format("%Y-%m-%d");  //考勤日期
	dlg.iEmpId = atoi(m_datagrid.GetItem(0)); //考勤员工编号
	dlg.m_EmpName = m_datagrid.GetItem(1);  //考勤员工姓名
	dlg.qq = atof(m_datagrid.GetItem(2));  //全勤天数
	dlg.cc = atof(m_datagrid.GetItem(3));  //出差天数
	dlg.bj = atof(m_datagrid.GetItem(4));  //病假天数
	dlg.sj = atof(m_datagrid.GetItem(5));  //出差天数
	dlg.kg = atof(m_datagrid.GetItem(6));  //出差天数
	dlg.fdxj = atof(m_datagrid.GetItem(7));  //出差天数
	dlg.nxj = atof(m_datagrid.GetItem(8));  //出差天数
	dlg.dxj = atof(m_datagrid.GetItem(9));  //出差天数
	dlg.m_cd = atof(m_datagrid.GetItem(10));  //出差天数
	dlg.m_zt = atof(m_datagrid.GetItem(11));  //出差天数
	dlg.ot1 = atof(m_datagrid.GetItem(12));  //出差天数
	dlg.ot2 = atof(m_datagrid.GetItem(13));  //出差天数
	dlg.ot3 = atof(m_datagrid.GetItem(14));  //出差天数
	dlg.m_Memo = m_datagrid.GetItem(15);  //出差天数
	if (dlg.DoModal() == IDOK)
		Refresh_Data();
}

void CCheckManDlg::OnSumButton() 
{
	// TODO: Add your control notification handler code here
	CSumCheckDlg dlg;
	dlg.iDepId = iDepId;
	dlg.m_DepName = m_DepName;
	dlg.DoModal();
}

void CCheckManDlg::OnDatetimechangeDatetimepicker1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	Refresh_Data();		
	*pResult = 0;
}