book.cs

一个用csharp做的简单图书管理系统,用sql数据库连接.

using System;
using System.Data;

using Com.LXJ.Example.Book.Data;

namespace Com.LXJ.Example.Book.Business
{
	/// <summary>
	/// Book 的摘要说明。
	/// </summary>
	public class Book
	{
		private int bookId;
		private string bookName;


		public Book()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}


		/// <summary>
		/// 初始化某个记录
		/// </summary>
		/// <param name="_bookId">书编号</param>
		public Book(int _bookId)
		{
			Data.BookForAccess book = new Data.BookForAccess();
			DataRow r = book.Retrive(_bookId);
			bookId = int.Parse(r["BookId"].ToString());
			bookName = r["BookName"].ToString();
		}


		/// <summary>
		/// 新增
		/// </summary>
		/// <returns></returns>
		public bool Create()
		{
			Data.BookForAccess book = new Data.BookForAccess();
			return book.Create(bookName);
		}



		/// <summary>
		/// 更新
		/// </summary>
		/// <returns></returns>
		public bool Update()
		{
			Data.BookForAccess book = new Data.BookForAccess();
			return book.Update(bookId,bookName);
		}



		/// <summary>
		/// 删除
		/// </summary>
		/// <returns></returns>
		public bool Delete()
		{
			Data.BookForAccess book = new Data.BookForAccess();
			return book.Delete(bookId);
		}


		/// <summary>
		/// 取得列表
		/// </summary>
		/// <returns></returns>
		public DataSet List()
		{
			Data.BookForAccess book = new Data.BookForAccess();
			return book.List();
		}


		/*
		 * 下面设置类的属性
		 */


		/// <summary>
		/// 书编号
		/// </summary>
		public int BookId
		{
			get
			{
				return bookId;
			}
			set
			{
				bookId = value;
			}
		}



		/// <summary>
		/// 书名
		/// </summary>
		public string BookName
		{
			get
			{
				return bookName;
			}
			set
			{
				bookName = value;
			}
		}

	}//
}//