lackbook.cs

来自「这是一个编好的网上书店系统」· CS 代码 · 共 129 行

using System;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using RobertSoft.BookStore.DBClass;

namespace RobertSoft.BookStore
{
	/// <summary>
	/// LackBook 的摘要说明。
	/// </summary>
	public class LackBook : DBBaseClass
	{
		private string strBookName;
		private string strAuthor;
		private string strPublisher;
		private string strUserName;
	
		#region "properties of LackBook"
	
		public string BookName
		{
			get
			{
				return strBookName;
			}
			set
			{
				strBookName = value;
			}	
		}

		public string Author
		{
			get
			{
				return strAuthor;
			}
			set
			{
				strAuthor = value;
			}	
		}

		public string Publisher
		{
			get
			{
				return strPublisher;
			}
			set
			{
				strPublisher = value;
			}	
		}

		public string UserName
		{
			get
			{
				return strUserName;
			}
			set
			{
				strUserName = value;
			}	
		}
		#endregion

		public LackBook()
		{
			
		}

		/// <summary>
		/// add unavailable books. set Name、Publisher.
		/// </summary>		
		public void Add()
		{
			if(IsExist())
			{
				throw new Exception("该书已经登记过了。谢谢！");
			}
			else
			{
				string strSQL = "Insert into [LackBookRegister] (UserName,BookName,Publisher,Author,RegisterDate) Values('"
					+ this.UserName + "',"
					+ "'" + this.BookName + "',"
					+ "'" + this.Publisher + "',"
					+ "'" + this.Author + "',"
					+ "'" + DateTime.Now.ToString() + "')";				

				try
				{
					ExecuteSQLCmd(strSQL);				
				}
				catch
				{
					throw new Exception("登记失败！");
				}			
			}			
		}

		
		/// <summary>
		/// if the books exist
		/// </summary>
		/// <returns>return bool，if exist then set true，otherwise false</returns>
		public bool IsExist()
		{
			string strSQL = "Select ID from [LackBookRegister] Where BookName='"
				+ this.BookName + "' And Publisher='" + this.Publisher +"'";

			try
			{
				ExecuteSQLForValue(strSQL);
				return true;
			}
			catch
			{
				return false;
			}

		}


	}
}