search.cs

来自「网络营销软件的源代码」· CS 代码 · 共 67 行

using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;


namespace WebApplication8.firstPage
{
	/// <summary>
	/// Search 的摘要说明。
	/// </summary>
	public class Search
	{
		SqlConnection searchConnection;
		SqlCommand searchCommand;
		DataSet dataset = new DataSet();
		SqlDataAdapter adapter = new SqlDataAdapter();

		public Search(string c)
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
			searchConnection = new SqlConnection();
			searchCommand = new SqlCommand();

			searchConnection.ConnectionString = c;
			searchConnection.Open();
			searchCommand.Connection = searchConnection;
			adapter.SelectCommand = searchCommand;
		}

		public DataSet siteSearch(string keyword)
		{
			searchCommand.CommandText = "select * from Site where description like '%"+keyword+"%' order by price desc";
			adapter.Fill(dataset);
			return dataset;
		}

		public DataSet newsSearch(string keyword)
		{
			searchCommand.CommandText = "select * from News where body like '%"+keyword+"%'";
			adapter.Fill(dataset);
			return dataset;
		}

		public DataSet adsSearch(string keyword)
		{
			searchCommand.CommandText = "select * from Advertise where description like '%"+keyword+"%'";
			adapter.Fill(dataset);
			return dataset;
		}

		public DataSet goodsSearch(string keyword)
		{
			searchCommand.CommandText = "select * from Product where description like '%"+keyword+"%'";
			adapter.Fill(dataset);
			return dataset;
		}

		public void close()
		{
			searchConnection.Close();
		}
	}
}