课堂笔记

 

Dlbook.ascx页面源代码

< a href='<%#"BookItem.aspx?BookId="+Eval("BookId") %>'>

< asp : Image ID="Image1" runat="server" ImageUrl='<%#"~/Picture/"+Eval("BookImage") %>' />

Default.aspx.cs 页面代码

private SqlDataSource sqlds;

public SqlDataSource Sqlds

    {

        get { return sqlds; }

        set { sqlds = value; }

    }

    protected void Page_Load(object sender, EventArgs e)

    {

        DataList1.DataSource = this.sqlds;

        DataList1.DataBind();

}

Default.aspx 页面

< asp : Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

    <div class="ibook"> 新书上架

    <span style="margin-left:500px;">

    <a href="BookBrief.aspx?opt=1"

            target="_blank"> 更多&gt;&gt;</a>

< uc1 : Dlbook ID="Dlbook1" runat="server" />

    <asp:SqlDataSource ID="SqlDataSource1" runat="server"

    ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

    SelectCommand="SELECT top 4 bookid,bookname,bookimage FROM [BookBrief] order by AddTime Desc"></asp:SqlDataSource>

</ div >

</ asp : Content >

 

 

< asp : Repeater ID="Repeater1" runat="server"DataSourceID="SqlDataSource1">

< ItemTemplate >< asp : HyperLink ID="HyperLink8" runat="server"NavigateUrl=

' <% #"~/BookBrief.aspx?categoryid="+Eval("categoryid") %> '><%#Eval("categoryname")%>

 </asp:HyperLink> </ItemTemplate></asp:Repeater>

BookBrief.aspx页面

< asp : HyperLink ID="HyperLink1" runat="server"

 NavigateUrl='<%# "BookItem.aspx?BookId="+Eval("BookId") %>'

 Text='<%# Eval("BookName") %>' Font-Underline="true" ></asp:HyperLink>

BookBrief.aspx.cs 页面

Label1.Text= ” 当前共有“+

((DataView)this.SqlDataSource1.Select(DataSourceSelectArguments.Empty)).Count.ToString() +

 " 条记录" ;

BookItem.aspx 页面

< asp : ImageButton ID="ImageButton2" ImageUrl= ’ <%# Eval("ItemImage","~/picture/{0}") %>' />

搜索页面

protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());

            conn.Open();

            string gsql = "select * from Item";

            SqlCommand comm = new SqlCommand(gsql, conn);

            SqlDataAdapter ada = new SqlDataAdapter(comm);

            DataSet ds = new DataSet();

            ada.Fill(ds, "Item");

            this.GridView1.DataSource = ds.Tables["Item"];

            this.GridView1.DataBind();

        }

    }

    protected void ckshuming_CheckedChanged(object sender, EventArgs e)

    {

        if (ckshuming.Checked == false)TextBox1.Text = null;

    }

    protected void ckzuozhe_CheckedChanged(object sender, EventArgs e)

    {

        if (ckzuozhe.Checked == false) TextBox1.Text = null;

    }

    protected void ckchubanshe_CheckedChanged(object sender, EventArgs e)

    {

        if (ckchubanshe.Checked == false) TextBox1.Text = null;

    }

    protected void btnok_Click(object sender, EventArgs e)

    {

        SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());

        conn.Open();

        string gsql = "select * from Item";

        if (ckshuming.Checked && ckzuozhe.Checked && ckchubanshe.Checked)

        { gsql = gsql + " where ItemName like '%" + TextBox1.Text + "%' and BookAuthor like '%" + TextBox2.Text + "%' and Publisher like '%" + TextBox3 + "%'"; }

        else if (ckshuming.Checked && ckchubanshe.Checked)

        { gsql = gsql + " where ItemName like '%" + TextBox1.Text + "%' and BookAuthor like '%" + TextBox2.Text + "%'"; }

        else if (ckshuming.Checked && ckzuozhe.Checked)

        { gsql = gsql + " where ItemName like '%" + TextBox1.Text + "%' and Publisher like '%" + TextBox3.Text + "%'"; }

        else if (ckzuozhe.Checked && ckchubanshe.Checked)

        { gsql = gsql + " where BookAuthor like '%" + TextBox2.Text + "%' and Publisher like '%" + TextBox3.Text + "%'"; }

        else if (ckshuming.Checked)

        { gsql = gsql + " where ItemName like '%" + TextBox1.Text + "%'"; }

        else if (ckzuozhe.Checked)

        { gsql = gsql + " where BookAuthor like '%" + TextBox2.Text + "%'"; }

        else if (ckchubanshe.Checked)

        { gsql = gsql + " where Publisher like '%" + TextBox3.Text + "%'"; }

        SqlCommand comm = new SqlCommand(gsql, conn);

        SqlDataAdapter ada = new SqlDataAdapter(comm);

        DataSet ds = new DataSet();

        ada.Fill(ds, "Item");

        this.GridView1.DataSource = ds.Tables["Item"];

        this.GridView1.DataBind();

        Hashtable ht = new Hashtable();

        if (ckshuming.Checked) // 如果按书名查询被勾选

            ht.Add("ItemName", TextBox1.Text.Trim());

 

        if (ckzuozhe.Checked) // 如果按作者查询被勾选

            ht.Add("BookAuthor", TextBox2.Text.Trim());

 

        if (ckchubanshe.Checked) // 如果按出版社查询被勾选

        {

            ht.Add("Publisher", TextBox3.Text.Trim());

        }

    }

    protected void btnrest_Click(object sender, EventArgs e)

    {

        ckshuming.Checked = false;

        ckshuming_CheckedChanged(ckshuming, e);

        ckzuozhe.Checked = false;

        ckzuozhe_CheckedChanged(ckzuozhe, e);

        ckchubanshe.Checked = false;

        ckchubanshe_CheckedChanged(ckchubanshe, e);

}

GetBookBriefByCID 存储过程

ALTER PROCEDURE [dbo].[GetBookBriefByCID]

 (

@CategoryId smallint,@opt smallint

)

AS

if @CategoryId=-1 and @opt=-1

select * from BookBrief

else if

@CategoryId=-1 and @opt=1

select top 100 * from BookBrief order by AddTime desc

else if

@CategoryId=-1 and @opt=2

select * from BookBrief where IsHeadLine='true' order by AddTime desc

else if

@CategoryId=-1 and @opt=3

select * from BookBrief where IsClassic='true' order by AddTime desc

else

select * from BookBrief where CategoryId=@CategoryId