// 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;
}