customerhistoryinfosearch.cs

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

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

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