// Departments.h: interface for the CDepartments class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_DEPARTMENTS_H__6292F95D_B274_43B1_9F6D_99566E02F034__INCLUDED_)
#define AFX_DEPARTMENTS_H__6292F95D_B274_43B1_9F6D_99566E02F034__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

class CDepartments  
{
private:
	int DeptId;
	CString DeptName;
public:
	CDepartments();
	virtual ~CDepartments();

	//讀取和設置成員變量
	void SetDeptId(int iDeptId);
	int GetDeptId();
	void SetDeptName(CString cDeptName);
	CString GetDeptName();

	// 是否存在某個部門名稱
	int HaveName(CString cDeptName);
	// 插入新的部門
	void sql_Insert();
	// 更新部門信息
	void sql_Update(CString cDeptId);
	// 刪除部門
	void sql_Delete(CString cDeptId);
};

#endif // !defined(AFX_DEPARTMENTS_H__6292F95D_B274_43B1_9F6D_99566E02F034__INCLUDED_)