kaoqinview.cpp

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

// KaoqinView.cpp : implementation file
//

#include "stdafx.h"
#include "renshi.h"
#include "KaoqinView.h"
#include "MainFrm.h"
#include "KaoqinEditDlg.h"
#include "BumenSelDlg.h"
#include "KaoqinSumDlg.h"

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

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

/////////////////////////////////////////////////////////////////////////////
// CKaoqinView
extern CAdmin g_curAdmin;
extern CRenshiApp theApp;

IMPLEMENT_DYNCREATE(CKaoqinView, CFormView)

CKaoqinView::CKaoqinView()
	: CFormView(CKaoqinView::IDD)
{
	//{{AFX_DATA_INIT(CKaoqinView)
	m_date = 0;
	m_BumenName = _T("");
	//}}AFX_DATA_INIT
}

CKaoqinView::~CKaoqinView()
{
}

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


BEGIN_MESSAGE_MAP(CKaoqinView, CFormView)
	//{{AFX_MSG_MAP(CKaoqinView)
	ON_WM_DESTROY()
	ON_BN_CLICKED(IDC_SET_BUTTON, OnSetButton)
	ON_BN_CLICKED(IDC_SETDEP_BUTTON, OnSetBumenButton)
	ON_NOTIFY(DTN_DATETIMECHANGE, IDC_DATETIMEPICKER1, OnDatetimechangeDatetimepicker1)
	ON_BN_CLICKED(IDC_SUM_BUTTON, OnSumButton)
	ON_WM_SIZE()
	ON_BN_CLICKED(IDC_BUTTON_XML, OnButtonXml)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKaoqinView diagnostics

#ifdef _DEBUG
void CKaoqinView::AssertValid() const
{
	CFormView::AssertValid();
}

void CKaoqinView::Dump(CDumpContext& dc) const
{
	CFormView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CKaoqinView message handlers

void CKaoqinView::OnDestroy() 
{
	CFormView::OnDestroy();
	
	((CMainFrame*)AfxGetMainWnd())->m_pKaoqinView=NULL;
	delete ((CMainFrame*)AfxGetMainWnd())->m_pKaoqinView;
	
}

void CKaoqinView::Refresh_Data()
{
	UpdateData(TRUE);

	CString cSource;
	CString cBumenID;
	cBumenID.Format("%d", iBumenID);

	cSource = "SELECT e.yg_ID, e.yg_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 Yuangong e, Kaoqin c WHERE e.yg_ID*=c.yg_ID AND c.CheckDate='";
	cSource += m_date.Format("%Y-%m-%d") + "' AND e.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);
}

void CKaoqinView::OnInitialUpdate() 
{
	CFormView::OnInitialUpdate();

	m_cp.SetParent(this);
	m_cp.AddControl(IDC_DATAGRID1,CP_RESIZE_H|CP_RESIZE_V);
	
	//权限控制，如果不是系统管理员则设置和月度考勤按钮置灰
	if (g_curAdmin.GetUserType() != 1)
	{
		GetDlgItem(IDC_SET_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_SUM_BUTTON)->EnableWindow(FALSE);
	}
	CTime t = CTime::GetCurrentTime();  //读取当前系统日期
	m_date = t;
	iBumenID = 0;
	m_BumenName = "";
	
	UpdateData(FALSE);
	Refresh_Data();	

	
}

void CKaoqinView::OnSetButton() 
{
	if (m_adodc.GetRecordset().GetEof())
	{
		MessageBox("请选择员工记录");
		return;
	}
	CKaoqinEditDlg dlg;
	dlg.m_Date = m_date.Format("%Y-%m-%d");  //考勤日期
	dlg.iYgID = atoi(m_datagrid.GetItem(0)); //考勤员工编号
	dlg.m_YgName = 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 CKaoqinView::OnSetBumenButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	//打开选择部门对话框
	CBumenSelDlg dlg;
	dlg.DoModal();
	//从对话框中读取选择部门的信息
	iBumenID = dlg.BumenID;
	m_BumenName = dlg.BumenName;
	UpdateData(FALSE);
	//根据选择的部门信息，刷新表格数据
	Refresh_Data();	
}

void CKaoqinView::OnDatetimechangeDatetimepicker1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	Refresh_Data();		
	
	*pResult = 0;
}

void CKaoqinView::OnSumButton() 
{
	CKaoqinSumDlg dlg;
	dlg.iBumenID = iBumenID;
	dlg.m_BumenName = m_BumenName;
	dlg.DoModal();
	
}

void CKaoqinView::OnSize(UINT nType, int cx, int cy) 
{
	CFormView::OnSize(nType, cx, cy);
	

	m_cp.MoveControls();
	
}

void CKaoqinView::OnButtonXml() 
{
	UpdateData(TRUE);

	CString cSource;
	CString cBumenID;
	cBumenID.Format("%d", iBumenID);

	cSource = "SELECT e.yg_ID, e.yg_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 Yuangong e, Kaoqin c WHERE e.yg_ID*=c.yg_ID AND c.CheckDate='";
	cSource += m_date.Format("%Y-%m-%d") + "'";
	if(! this->m_BumenName.IsEmpty())
		cSource=cSource+ "AND e.BumenID=" + cBumenID;
	

	_RecordsetPtr pRS =theApp.m_ado.GetRS(cSource);		//执行SQL语句获取记录集
	

	char BASED_CODE szFilter[] = "XML Files (*.xml)|*.xml|All Files (*.*)|*.*||";
	CFileDialog dlg(FALSE,"XML",m_BumenName.IsEmpty()?"所有部门考勤信息":m_BumenName+"考勤信息",  OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT,szFilter);
	if (dlg.DoModal() == IDOK)
	{
		try
		{
			pRS->Save(_bstr_t(dlg.GetPathName()), adPersistXML);
		}
		catch (_com_error e)
		{
			TRACE(_T("Warning: Save 发生异常. 错误信息: %s; 文件: %s; 行: %d\n"), e.ErrorMessage(), __FILE__, __LINE__);
		} 

	}	
}