bookssearch.cs

.NET编写的小型图书管理系统,里面有详细说明,源码,发布软件包和数据库文件,本人本科时设计编写

using System;
using System.Data;
using bookShop.classLib.dbLib;

namespace bookShop.classLib.dataLayer
{
	/// <summary>
	/// BookSearch 的摘要说明。
	/// </summary>
	public class BooksSearch
	{
		private string bookNo;
		private string bookName;
		private string author;
		private string publishingHouse;
		public BooksSearch(string bookNo,string bookName,string author,string publishingHouse)
		{
			this.bookNo=bookNo;
			this.bookName=bookName;
			this.author=author;
			this.publishingHouse=publishingHouse;
		}
		public DataSet Search()
		{
			DataSetDBConnect ds=new DataSetDBConnect("table");
			ds.StrSQL="select * from Book where ";
			int conditionCount=0;
			if(bookNo!=String.Empty)
			{
				ds.StrSQL+="BookNo='"+bookNo+"' ";
				conditionCount++;
			}
			if(bookName!=String.Empty)
			{
				if(conditionCount>0)
					ds.StrSQL+="and ";
				ds.StrSQL+="BookName='"+bookName+"' ";
				conditionCount++;
			}
			if(author!=String.Empty)
			{
				if(conditionCount>0)
					ds.StrSQL+="and ";
				ds.StrSQL+="Author='"+author+"' ";
				conditionCount++;
			}
			if(publishingHouse!=String.Empty)
			{
				if(conditionCount>0)
					ds.StrSQL+="and ";
				ds.StrSQL+="PublishingHouse='"+publishingHouse+"' ";
				conditionCount++;
			}
			ds.Do();
			ds.Close();
			return ds.ObjDataSet;
		}
	}
}