// Kaoqin.h
/*********************************************************************/
#if !defined _KAOQIN_
#define _KAOQIN_

#pragma once

/*********************************************************************/
class CKaoqin  
{
private:
	CString		CheckDate;
	int		yg_ID;
	float	qqDays;
	float	ccDays;
	float	bjDays;
	float	sjDays;
	float	kgDays;
	float	fdxjDays;
	float	nxjDays;
	float	dxjDays;
	int		cdMinutes;
	int		ztMinutes;
	float	ot1Days;
	float	ot2Days;
	float	ot3Days;
	CString Memo;

public:
	CKaoqin();
	virtual ~CKaoqin();

public:	
	CString		GetCheckDate();
	void		SetCheckDate(CString cDate);
	int			Getyg_ID();
	void		Setyg_ID(int iyg_ID);
	float		GetqqDays();
	void		SetqqDays(float fqqDays);
	float		GetccDays();
	void		SetccDays(float fccDays);
	float		GetbjDays();
	void		SetbjDays(float fbjDays);
	float		GetsjDays();
	void		SetsjDays(float fsjDays);
	float		GetkgDays();
	void		SetkgDays(float fkgDays);
	float		GetfdxjDays();
	void		SetfdxjDays(float ffdxjDays);
	float		GetnxjDays();
	void		SetnxjDays(float fnxjDays);
	float		GetdxjDays();
	void		SetdxjDays(float fdxjDays);
	int			GetcdMinutes();
	void		SetcdMinutes(int icdMinutes);
	int			GetztMinutes();
	void		SetztMinutes(int iztMinutes);
	float		Getot1Days();
	void		Setot1Days(float fot1Days);
	float		Getot2Days();
	void		Setot2Days(float fot2Days);
	float		Getot3Days();
	void		Setot3Days(float fot3Days);
	CString		GetMemo();
	void		SetMemo(CString cMemo);

	//數據庫操作
	int		HaveRecord(CString cCheckDate, CString cyg_ID); //判斷指定員工/日期的考勤記錄是否存在
	void	sql_insert(); 
	void	sql_update(CString cCheckDate, CString cyg_ID);
	void	sql_delete(CString cCheckDate, CString cyg_ID);
	void	sql_deleteByYg(CString cyg_ID);
};


/*********************************************************************/
#endif