timesaleinfosearch.cs

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

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

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