// Product.h: interface for the CProduct class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_PRODUCT_H__E6828943_39AF_495B_933D_3C48FEFF42ED__INCLUDED_)
#define AFX_PRODUCT_H__E6828943_39AF_495B_933D_3C48FEFF42ED__INCLUDED_

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

class CProduct  
{
private:
	int Pid;
	CString Pname;
	int TypeId;
	CString Pstyle;
	CString Punit;
	float Pprice;
	int Plow;
	int Phigh;
	int Valid;
	int AlarmDays;
public:
	CProduct();
	virtual ~CProduct();
	//設置和讀取成員變量
	int GetPid();
	void SetPid(int iPid);
	CString GetPname();
	void SetPname(CString cPname);
	int GetTypeId();
	void SetTypeId(int iTypeId);
	CString GetPstyle();
	void SetPstyle(CString cPstyle);
	CString GetPunit();
	void SetPunit(CString cPunit);
	float GetPprice();
	void SetPprice(float fPprice);
	int GetPlow();
	void SetPlow(int iPlow);
	int GetPhigh();
	void SetPhigh(int iPhigh);
	int GetValid();
	void SetValid(int iValid);
	int GetAlarmDays();
	void SetAlarmDays(int iAlarmDays);

	//數據庫操作
	int HaveName(CString cPname); //判斷指定的產品名稱是否在數據庫中
	int HaveType(CString cTypeId);  //判斷表中是否存在指定的產品類別
	void sql_insert();
	void sql_update(CString cPid);
	void sql_delete(CString cPid);
	//讀取所有字段值
	void GetData(CString cPid);

};

#endif // !defined(AFX_PRODUCT_H__E6828943_39AF_495B_933D_3C48FEFF42ED__INCLUDED_)