Select.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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;

namespace SCard
{
	/// <summary>
	/// Select 的摘要说明。
	/// </summary>
	public partial class Select : System.Web.UI.Page
	{
    
		protected void Page_Load(object sender, System.EventArgs e)
		{
			 if( !IsPostBack )
            {
                setSelectClass();//绑定类别
                
                if( Request.QueryString["class"] != null && Request.QueryString["text"] != null )//在主页传过来的搜索的类型和二手书名
                {
                    string strClass = Request.QueryString["class"].ToString();
                    string strText = Request.QueryString["text"].ToString();

                    strClass = CleanString.htmlInputText( strClass );
                    strText = CleanString.htmlInputText( Server.UrlDecode(strText) );
                    
                    CData();//分类列表绑定
                    getSelectResult(strClass, strText);//查询
                }    
            }
		}

        private void CData()//分类列表绑定
        {
            DBConn myDB = new DBConn();
            string sql = "select * from Category";
            CRepeater.DataSource = myDB.getDataReader( sql );
            CRepeater.DataBind();
            myDB.Close();
        }

        private void setSelectClass()//绑定 类别选框
        {
            DBConn myDB = new DBConn();
            string mySql = "select CID,CName from Category order by CID desc";
            ddlClass.DataSource  = myDB.getDataReader( mySql );
            ddlClass.DataTextField = "CName";
            ddlClass.DataValueField = "CID";
            ddlClass.DataBind();
            myDB.Close();
            
            ddlClass.Items.Insert(0,new ListItem("所有分类","-1"));
        }