customerinfosearch.cs

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

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

namespace bookShop.classLib.dataLayer
{
	/// <summary>
	/// CustomerInfoSearch 的摘要说明。
	/// </summary>
	public class CustomerInfoSearch
	{
		private string customerID;
		private string customerName;
		public CustomerInfoSearch(string customerID,string customerName)
		{
			this.customerID=customerID;
			this.customerName=customerName;
		}
		public DataSet Search()
		{
			DataSetDBConnect ds=new DataSetDBConnect("table");
			ds.StrSQL="select * from Customer where ";
			int conditionCount=0;
			if(customerID!=String.Empty)
			{
				ds.StrSQL+="CustomerID='"+customerID+"' ";
				conditionCount++;
			}
			if(customerName!=String.Empty)
			{
				if(conditionCount>0)
					ds.StrSQL+="and ";
				ds.StrSQL+="CustomerName='"+customerName+"'";
				conditionCount++;
			}
			ds.Do();
			ds.Close();
			return ds.ObjDataSet;			
		}
	}
}