// Client.h: interface for the CClient class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_CLIENT_H__C210C883_216F_4A4E_BB2F_F034570AA92F__INCLUDED_)
#define AFX_CLIENT_H__C210C883_216F_4A4E_BB2F_F034570AA92F__INCLUDED_

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

class CClient  
{
private:
	int Cid;
	CString Cname;
	int Ctype;
	CString Contact;
	CString Address;
	CString Postcode;
	CString Phone;
	CString Fax;
	CString Memo;
public:
	CClient();
	virtual ~CClient();
	//設置和讀取成員變量值
	int GetCid();
	void SetCid(int iCid);
	CString GetCname();
	void SetCname(CString cCname);
	int GetCtype();
	void SetCtype(int iCtype);
	CString GetContact();
	void SetContact(CString cContact);
	CString GetAddress();
	void SetAddress(CString cAddress);
	CString GetPostcode();
	void SetPostcode(CString cPostcode);
	CString GetPhone();
	void SetPhone(CString cPhone);
	CString GetFax();
	void SetFax(CString cFax);
	CString GetMemo();
	void SetMemo(CString cMemo);
	//數據庫操作
	int HaveName(CString cCname); //判斷指定的客戶名是否在數據庫中
	void sql_insert();
	void sql_update(CString cCid);
	void sql_delete(CString cCid);
	//根據員工編號讀取所有字段值
	void GetData(CString cCid);
};

#endif // !defined(AFX_CLIENT_H__C210C883_216F_4A4E_BB2F_F034570AA92F__INCLUDED_)