addnewbookedit.h

实现基本的图书馆管理系统

// AddNewBookEdit.h: interface for the CAddNewBookEdit class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADDNEWBOOKEDIT_H__B659CA1F_0D46_4AF1_9662_07CF4E384B00__INCLUDED_)
#define AFX_ADDNEWBOOKEDIT_H__B659CA1F_0D46_4AF1_9662_07CF4E384B00__INCLUDED_

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

#include "ADOConn.h"

class CAddNewBookEdit  
{
public:
	
	CString		BookName;
	CString		InlibraryTime;
	CString		BookID;
	CString		Writer;
	CString		Press;
	float		Price;
	int			Total_Amount;
	int			Now_Amount;
public:
	CAddNewBookEdit();
	virtual ~CAddNewBookEdit();

	/////////////////////////////
	CString GetInlibraryTime();
	void SetInlibraryTime(CString cInlibraryTime);
	CString GetBookName();
	void SetBookName(CString cBookName);
	CString GetBookID();	
	void SetBookID(CString cBookID);
	CString GetWriter();
	void SetWriter(CString cWriter);
	CString GetPress();
	void SetPress(CString cPress);
	float	 GetPrice();
	void SetPrice(float fPrice);
	int GetTotal_Amount();	
	void SetTotal_Amount(int iTotal_Amount);
	int GetNow_Amount();	
	void SetNow_Amount(int iNow_Amount);

	//数据库操作
	int HaveName(CString cBookName); //判断指定的书名是否存在

	void sql_insert();
	void sql_update();
	void sql_update_AddNow_Amount();
	void sql_update_DecNow_Amount();

	void GetData(CString cBookId);
};

#endif // !defined(AFX_ADDNEWBOOKEDIT_H__B659CA1F_0D46_4AF1_9662_07CF4E384B00__INCLUDED_)