kaoqinsumdlg.cpp

企业之间的竞争主要体现在三个方面：产品市场的竞争、资金市场的竞争和人才市场的竞争。在网络经济的环境下

// KaoqinSumDlg.cpp : implementation file
//

#include "stdafx.h"
#include "renshi.h"
#include "KaoqinSumDlg.h"
#include "bumenseldlg.h"


#include "control\Columns.h"
#include "control\Column.h"
#include "control\_recordset.h"


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

/////////////////////////////////////////////////////////////////////////////
// CKaoqinSumDlg dialog


CKaoqinSumDlg::CKaoqinSumDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CKaoqinSumDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CKaoqinSumDlg)
	m_BumenName = _T("");
	//}}AFX_DATA_INIT
}


void CKaoqinSumDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CKaoqinSumDlg)
	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_BumenName);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CKaoqinSumDlg, CDialog)
	//{{AFX_MSG_MAP(CKaoqinSumDlg)
	ON_BN_CLICKED(IDC_SETDEP_BUTTON, OnSetBumenButton)
	ON_CBN_SELCHANGE(IDC_YEAR_COMBO, OnSelchangeYearCombo)
	ON_CBN_SELCHANGE(IDC_MONTH_COMBO, OnSelchangeMonthCombo)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKaoqinSumDlg message handlers

void CKaoqinSumDlg::Refresh_Data()
{
	CString cSource;
	CString cBumenID;
	cBumenID.Format("%d", iBumenID);
	//读取月份信息
	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 yg_Name AS 员工姓名, SumQq AS 全勤天数, SumCc AS 出差天数,";
	cSource += " SumBj AS 病假天数, SumSj AS 事假天数, SumKg AS 旷工天数,";
	cSource += " SumFdxj AS 法定休假, SumNxj AS 年休假数, SumDxj AS 倒休假数,";
	cSource += " SumCd AS 迟到时间, SumZt AS 早退时间, SumOt1 AS 一类加班,";
	cSource += " SumOt2 AS 二类加班, SumOt3 AS 三类加班";
	cSource += " FROM v_KaoqinSum WHERE CheckMonth = '";
	cSource += cYear + "-" + cMonth + "' AND BumenID=" + cBumenID;

	m_adodc.SetRecordSource(cSource);
	m_adodc.Refresh();

	m_datagrid.GetColumns().GetItem((_variant_t)long(0)).SetWidth(0);
	m_datagrid.GetColumns().GetItem((_variant_t)long(1)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(2)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(3)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(4)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(5)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(6)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(7)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(8)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(9)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(10)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(11)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(12)).SetWidth(50);
	m_datagrid.GetColumns().GetItem((_variant_t)long(13)).SetWidth(50);

}

BOOL CKaoqinSumDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	CTime t = CTime::GetCurrentTime();  //读取当前系统日期
	int iYear, iMonth;
	iYear = t.GetYear();	
	iMonth = t.GetMonth();

	m_year.SetCurSel(iYear - 2000);
	m_month.SetCurSel(iMonth - 1);
	
	Refresh_Data();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CKaoqinSumDlg::OnSetBumenButton() 
{
	CBumenSelDlg dlg;
	//打开选择部门对话框
	dlg.DoModal();
	//从对话框中读取选择部门的信息
	iBumenID = dlg.BumenID;
	m_BumenName = dlg.BumenName;
	UpdateData(FALSE);
	//根据选择的部门信息，刷新表格数据
	Refresh_Data();	
	
}

void CKaoqinSumDlg::OnSelchangeYearCombo() 
{
	Refresh_Data();		
	
}

void CKaoqinSumDlg::OnSelchangeMonthCombo() 
{
	Refresh_Data();		
}