using?System;
using?System.Collections;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Web;
using?System.Web.SessionState;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.HtmlControls;
using?System.Configuration?;
using?System.Data?.SqlClient?;

namespace?BMS
{
	///?

	///?AdvancedSearch?的摘要說明。
	///?

	public?class?AdvancedSearch?:?System.Web.UI.Page
	{
		protected?System.Web.UI.WebControls.Hyperlink?Hyperlink1;
		protected?System.Web.UI.WebControls.TextBox?tbx_bid;
		protected?System.Web.UI.WebControls.TextBox?tbx_bname;
		protected?System.Web.UI.WebControls.TextBox?tbx_bauthor;
		protected?System.Web.UI.WebControls.TextBox?tbx_bisbn;
		protected?System.Web.UI.WebControls.TextBox?tbx_bpress;
		protected?System.Web.UI.WebControls.Button?btn_search;
		protected?System.Web.UI.WebControls.TextBox?tbx_btheme;
		protected?System.Web.UI.WebControls.DataGrid?dgd_booklist;
	
		private?void?Page_Load（object?sender?System.EventArgs?e）
		{
			if（!IsPostBack）?BindGrid（）;
		}

		#region?Web?Form?Designer?generated?code
		override?protected?void?OnInit（EventArgs?e）
		{
			//
			//?CODEGEN：該調(diào)用是?ASP.NET?Web?窗體設(shè)計(jì)器所必需的。
			//
			InitializeComponent（）;
			base.OnInit（e）;
		}
		
		///?

		///?設(shè)計(jì)器支持所需的方法?-?不要使用代碼編輯器修改
		///?此方法的內(nèi)容。
		///?

		private?void?InitializeComponent（）
		{????
			this.btn_search.Click?+=?new?System.EventHandler（this.btn_search_Click）;
			this.Load?+=?new?System.EventHandler（this.Page_Load）;

		}
		#endregion


		public?void?DataGrid_Page（object?senderDataGridPageChangedEventArgs?E）
		{
			dgd_booklist.CurrentPageIndex?=E.NewPageIndex?;
			BindGrid（）;
		}
		public?void?BindGrid（）
		{	//從文件Web.config中讀取連接字符串
			string?strconn=?ConfigurationSettings.AppSettings[“dsn“];
			//連接本地計(jì)算機(jī)的LMS數(shù)據(jù)庫
			SqlConnection?cn=?new?SqlConnection?（strconn）;
			//創(chuàng)建帶篩子的SQL語句
			string?mysql=“select?*?from?book?where?1=1“;
			//對控建進(jìn)行篩選
			if?（tbx_bid.Text?.ToString?（）!=““）//如果“書號”有輸入
			{
			try
				{
				?mysql=mysql+“?and?bid=“+Convert.ToInt32?（tbx_bid.Text?.ToString?（））;
				}
			?catch
				{	
				Response.Write?（“書號輸入有誤!“）;
				Response.End（）;
				}
			}
			if?（tbx_bname.Text?.ToString?（）!=““）//如果“書名”有輸入
			{
				mysql=mysql+“?and?bname?like?‘%“+tbx_bname.Text?.ToString?（）+“%‘“;
			}
			if?（tbx_bauthor.Text?.ToString?（）!=““）//如果“書作者”有輸入
			{
				mysql=mysql+“?and?bauthor?like?‘%“+tbx_bauthor.Text?.ToString?（）+“%‘“;
			}
			if?（tbx_bisbn.Text?.ToString?（）!=““）//如果“書ISBN”有輸入
			{
				mysql=mysql+“?and?bisbn=‘“+tbx_bisbn.Text?.ToString?（）+“‘“;
			}
			if?（tbx_bpress.Text?.ToString?（）!=““）//如果“書出版社”有輸入
			{
				mysql=mysql+“?and?bpress?like?‘%“+tbx_bpress.Text?.ToString?（）+“%‘“;
			}
			if?（tbx_btheme.Text?.ToString?（）!=““）//如果“主題詞”有輸入
			{
				mysql=mysql+“?and?btheme?like?‘%“+tbx_btheme.Text?.ToString?（）+“%‘“;
			}
			//創(chuàng)建SqlDataAdapter對象調(diào)用視圖
			SqlDataAdapter?da=new

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????1065472??2004-09-01?12:32??chap06\Database\LMS

?????目錄??????????0??2005-12-21?10:30??chap06\Database

?????文件???????3347??2004-09-01?12:32??chap06\LMS\acn98.gif

?????文件???????5408??2004-09-01?12:32??chap06\LMS\AdvancedSearch.aspx

?????文件???????3447??2004-09-01?12:32??chap06\LMS\AdvancedSearch.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap06\LMS\AdvancedSearch.aspx.resx

?????文件???????7401??2004-09-01?12:32??chap06\LMS\AdvancedSearchForReader.aspx

?????文件???????3481??2004-09-01?12:32??chap06\LMS\AdvancedSearchForReader.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap06\LMS\AdvancedSearchForReader.aspx.resx

?????文件???????2102??2004-09-01?12:32??chap06\LMS\AssemblyInfo.cs

?????文件??????49152??2005-12-21?10:44??chap06\LMS\bin\LMS.dll

?????文件?????120320??2005-12-21?10:44??chap06\LMS\bin\LMS.pdb

?????目錄??????????0??2005-12-21?10:30??chap06\LMS\bin

?????文件???????6984??2004-09-01?12:32??chap06\LMS\BookAdd.aspx

?????文件???????5791??2004-09-01?12:32??chap06\LMS\BookAdd.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap06\LMS\BookAdd.aspx.resx

?????文件??????11118??2004-09-01?12:32??chap06\LMS\BookClassify.aspx

?????文件???????1029??2004-09-01?12:32??chap06\LMS\BookClassify.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap06\LMS\BookClassify.aspx.resx

?????文件???????8120??2004-09-01?12:32??chap06\LMS\BookDetail.aspx

?????文件???????3938??2004-09-01?12:32??chap06\LMS\BookDetail.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap06\LMS\BookDetail.aspx.resx

?????文件???????5456??2004-09-01?12:32??chap06\LMS\BookManage.aspx

?????文件???????3345??2004-09-01?12:32??chap06\LMS\BookManage.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap06\LMS\BookManage.aspx.resx

?????文件???????7328??2004-09-01?12:32??chap06\LMS\BookModify.aspx

?????文件???????6870??2004-09-01?12:32??chap06\LMS\BookModify.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap06\LMS\BookModify.aspx.resx

?????文件???????4294??2004-09-01?12:32??chap06\LMS\BookSearch.aspx

?????文件???????1056??2004-09-01?12:32??chap06\LMS\BookSearch.aspx.cs

............此處省略69個(gè)文件信息