booksearchresult.aspx.cs

内有图书管理系统数据库 及相关模板文件

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 LMS
{
    //该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

	/// <summary>
	/// BookSearchResult 的摘要说明。
	/// </summary>
	public partial class BookSearchResult : System.Web.UI.Page
	{
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
            if (!IsPostBack)
            {

                BindGrid();
            }
		}

		public void DataGrid_Page(Object sender,DataGridPageChangedEventArgs E)
		{
			dgd_booklist.CurrentPageIndex =E.NewPageIndex ;
			BindGrid();
		}

		public void BindGrid()
		{	//从文件Web.config中读取连接字符串
            string strConn = ConfigurationManager.AppSettings["dsn"];

			//连接本地计算机的LMS数据库
			SqlConnection cn= new SqlConnection (strConn);
			//根据提交上来的表单创建SQL语句
			string booklist="select * from book ";
			string strSearchText=Request.Form ["strSearchText"];
			string match_flag=Request.Form ["match_flag"];
			if(match_flag=="0")//完全匹配
			{
				if (Request.Form ["strSearchType"].ToString ()=="01") //书目编号
				{
					booklist=booklist + "where bid="+ strSearchText;
				}
				else if (Request.Form ["strSearchType"].ToString ()=="02") //题名
				{
					booklist=booklist + "where bname='"+ strSearchText +"'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="03") //作者
				{
					booklist=booklist + "where bauthor='"+ strSearchText +"'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="04") //主题词
				{
					booklist=booklist + "where btheme='"+ strSearchText +"'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="05") //ISBN/ISSN号
				{
					booklist=booklist + "where bISBN='"+ strSearchText +"'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="06") //分类号
				{
					booklist=booklist + "where bgroup='"+ strSearchText +"'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="07") //索取号
				{
					booklist=booklist + "where bindex='"+ strSearchText +"'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="08") //出版社
				{
					booklist=booklist + "where bpress='"+ strSearchText +"'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="09") //丛书名
				{
					booklist=booklist + "where bseriesname='"+ strSearchText +"'";
				}
				else
				{	
					Response.Write ("类型选择错误");
					Response.End() ;
				}
			}
			else if(match_flag=="1")//模糊匹配
			{
				if (Request.Form ["strSearchType"].ToString ()=="01") //书目编号
				{
					booklist=booklist + "where bid ="+ strSearchText;
				}
				else if (Request.Form ["strSearchType"].ToString ()=="02") //题名
				{
					booklist=booklist + "where bname like '%"+ strSearchText +"%'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="03") //作者
				{
					booklist=booklist + "where bauthor like '%"+ strSearchText +"%'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="04") //主题词
				{
					booklist=booklist + "where btheme like '%"+ strSearchText +"%'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="05") //ISBN/ISSN号
				{
					booklist=booklist + "where bISBN like '%"+ strSearchText +"%'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="06") //分类号
				{
					booklist=booklist + "where bgroup like '%"+ strSearchText +"%'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="07") //索取号
				{
					booklist=booklist + "where bindex like '%"+ strSearchText +"%'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="08") //出版社
				{
					booklist=booklist + "where bpress like '%"+ strSearchText +"%'";
				}
				else if (Request.Form ["strSearchType"].ToString ()=="09") //丛书名
				{
					booklist=booklist + "where bseriesname like '%"+ strSearchText +"%'";
				}
				else
				{	
					Response.Write ("类型选择错误");
					Response.End() ;
				}
			}
			//创建SqlDataAdapter对象,调用视图
			SqlDataAdapter da=new SqlDataAdapter (booklist,cn);
			//创建并填充DataSet
			DataSet ds=new DataSet ();
			da.Fill (ds);
			dgd_booklist.DataSource =ds;
			dgd_booklist.DataBind ();
			cn.Close ();
		}
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion

		protected void dgd_booklist_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}
	}
}