bookssalesearch.cs

来自「.NET编写的小型图书管理系统,里面有详细说明,源码,发布软件包和数据库文件,本」· CS 代码 · 共 26 行

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

namespace bookShop.classLib.dataLayer
{
	/// <summary>
	/// BooksSaleSearch 的摘要说明。
	/// </summary>
	public class BooksSaleSearch
	{
		private string bookNo;
		public BooksSaleSearch(string bookNo)
		{
			this.bookNo=bookNo;
		}
		public DataSet Search()
		{
			DataSetDBConnect ds=new DataSetDBConnect("table");
			ds.StrSQL="select Sale.BookNo,BookName,SaleNo,SaleTime,Quantity,CustomerType,CustomerID from Book,Sale where Book.BookNo='"+bookNo+"' and Sale.BookNo=Book.BookNo";
			ds.Do();
			ds.Close();
			return ds.ObjDataSet;
		}
	}
}