// Pingjia.h: interface for the CPingjia class.
/*********************************************************************/

#if !defined _PING_JIA_H_
#define _PING_JIA_H_

#pragma once

/*********************************************************************/
class CPingjia  
{
private:
	CString		EvaMonth;
	int			yg_ID;
	CString		ztEva;
	CString		jlReason;
	int			jlAmount;
	CString		cfReason;
	int			cfAmount;
	CString		Memo;


public:
	CPingjia();
	virtual ~CPingjia();

public:
	CString	 GetEvaMonth();
	void	 SetEvaMonth(CString cEvaMonth);
	int		 Getyg_ID();
	void	 Setyg_ID(int iyg_ID);
	CString  GetztEva();
	void	 SetztEva(CString cztEva);
	CString  GetjlReason();
	void	 SetjlReason(CString cjlReason);
	int		 GetjlAmount();
	void	 SetjlAmount(int ijlAmount);
	CString  GetcfReason();
	void	 SetcfReason(CString ccfReason);
	int	     GetcfAmount();
	void	 SetcfAmount(int icfAmount);
	CString  GetMemo();
	void     SetMemo(CString cMemo);
	
	//數據庫操作
	int		HaveRecord(CString cEvaMonth, CString cyg_ID); //判斷指定員工/月份的考評記錄是否存在
	void	sql_insert();  
	void	sql_update(CString cEvaMonth, CString cyg_ID);
	void	sql_delete(CString cEvaMonth, CString cyg_ID);
	void	sql_deleteByYg(CString cyg_ID);

};


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