booklist.aspx.cs

2007年华中科技大学数据库课程设计参考程序[图书销售系统]+报告

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Collections.Generic;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using OnlineBookSell.BLLFactory;
using OnlineBookSell.Model;
using OnlineBookSell.IBLL;
using OnlineBookSell.DBUtility;


public partial class ljian_admin_book_booklist : System.Web.UI.Page
{
    public IBookClassBLL ibookclassdll = BLLFactory.getInstance().createBookClassBLL();
    public IBookBLL ibookdll = BLLFactory.getInstance().createBookBLL();

    public static IList<BookInfo> booklist = new List<BookInfo>();

    private static int pageindex = 1;
    private static int pagesize = 10;
    private static int totalpages = 0;
    private static int pagecount = 0;
    protected override void OnInit(EventArgs e)
    {
        base.OnInit(e);
        rep.ItemCommand += new RepeaterCommandEventHandler(sale_ItemCommand);

    }

    protected void sale_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        String id = ((LinkButton)e.CommandSource).ToolTip;

      
            for (int i = 0; i < booklist.Count; i++)
            {
                if (booklist[i].Id.ToString() == id)
                {
                    if (ibookdll.DeleteBook(Convert.ToInt32(id)))
                    {
                        booklist.Remove(booklist [i]);
                        rep.DataSource = booklist;
                        rep.DataBind();
                    }

                }
            }
            // System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.jiesuan, this.jiesuan.GetType(), "success", "alert('"+id+"!');", true);
        
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            class1.Items.Add(new ListItem("所有类别图书", "-1"));
            IList<BookClass> class1list = ibookclassdll.GetBookClassByParentId(0);
            foreach (BookClass bc in class1list)
            {
                class1.Items.Add(new ListItem(bc.Classname, bc.Classid.ToString()));
            }



            chubanshe.Items.Add(new ListItem("所有出版社", ""));
            using (SqlDataReader r = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, "select * from BookConcern"))
            {
                if (r.Read())
                {
                    chubanshe.Items.Add(new ListItem(r["conName"].ToString(), r["conName"].ToString()));
                }
            }





            int bookclass1 = -1, bookclass2 = -1;
            
            


            //按条件获取软件并分页显示

            booklist = ibookdll.SearchBook("", "", "", "", Convert.ToDateTime("1900-01-01"), Convert.ToDateTime("2100-01-01"), -1, -1, bookclass1, bookclass2, -1, 1, pagesize);

            pagecount = ibookdll.SearchBook("", "", "", "", Convert.ToDateTime("1900-01-01"), Convert.ToDateTime("2100-01-01"), -1, -1, bookclass1, bookclass2, -1, 1, pagesize, 1);

            rep.DataSource = booklist;
            rep.DataBind();

            pageindex = 1;
            if (pagecount <= pagesize)
                totalpages = 1;
            else
            {
                if (pagecount % pagesize != 0)
                    totalpages = pagecount / pagesize + 1;
                else
                    totalpages = pagecount / pagesize;
            }
            ye.Text = "总共&nbsp;" + pagecount + "&nbsp;本书";
            yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;
            shang.Enabled = false;
            shouye.Enabled = false;
            if (totalpages == 1)
            {
                xia.Enabled = false;
                weiye.Enabled = false;
            }


        }
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        DateTime dtmin = Convert.ToDateTime("1900-01-01");
        DateTime dtmax = Convert.ToDateTime("2100-01-01");
        if (pmin.Text.Trim() != "")
            dtmin = Convert.ToDateTime(pmin.Text.Trim());
        if (pmax.Text.Trim() != "")
            dtmax = Convert.ToDateTime(pmax.Text.Trim());

        float jiage1 = -1, jiage2 = -1;
        if (jiagemin.Text.Trim() != "")
            jiage1 = Convert.ToSingle(jiagemin.Text.Trim());
        if (jiagemax.Text.Trim() != "")
            jiage2 = Convert.ToSingle(jiagemax.Text.Trim());

        booklist = ibookdll.SearchBook(bookname.Text.Trim(), isbn.Text.Trim(), zuozhe.Text.Trim(), chubanshe.SelectedItem.Value, dtmin, dtmax, jiage1, jiage2, Convert.ToInt32(class1.SelectedValue), -1, -1, pageindex, pagesize);

        pagecount = ibookdll.SearchBook(bookname.Text.Trim(), isbn.Text.Trim(), zuozhe.Text.Trim(), chubanshe.SelectedItem.Value, dtmin, dtmax, jiage1, jiage2, Convert.ToInt32(class1.SelectedValue), -1, -1, pageindex, pagesize, 1);

        rep.DataSource = booklist;
        rep.DataBind();

        pageindex = 1;
        if (pagecount <= pagesize)
            totalpages = 1;
        else
        {
            if (pagecount % pagesize != 0)
                totalpages = pagecount / pagesize + 1;
            else
                totalpages = pagecount / pagesize;
        }
        ye.Text = "总共&nbsp;" + pagecount + "&nbsp;本书";
        yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;
        shang.Enabled = false;
        shouye.Enabled = false;
        if (totalpages == 1)
        {
            xia.Enabled = false;
            weiye.Enabled = false;
        }

      
    }
    
    protected void binddata()
    {
        DateTime dtmin = Convert.ToDateTime("1900-01-01");
        DateTime dtmax = Convert.ToDateTime("2100-01-01");
        if (pmin.Text.Trim() != "")
            dtmin = Convert.ToDateTime(pmin.Text.Trim());
        if (pmax.Text.Trim() != "")
            dtmax = Convert.ToDateTime(pmax.Text.Trim());

        float jiage1 = -1, jiage2 = -1;
        if (jiagemin.Text.Trim() != "")
            jiage1 = Convert.ToSingle(jiagemin.Text.Trim());
        if (jiagemax.Text.Trim() != "")
            jiage2 = Convert.ToSingle(jiagemax.Text.Trim());

        booklist = ibookdll.SearchBook(bookname.Text.Trim(), isbn.Text.Trim(), zuozhe.Text.Trim(), chubanshe.SelectedItem.Value, dtmin, dtmax, jiage1, jiage2, Convert.ToInt32(class1.SelectedValue), -1, -1, pageindex, pagesize);

        rep.DataSource = booklist;
        rep.DataBind();
    }
    protected void shouye_Click(object sender, EventArgs e)
    {
        pageindex = 1;
        shang.Enabled = false;
        shouye.Enabled = false;
        xia.Enabled = true;
        weiye.Enabled = true;
        yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;
        binddata();
    }

    protected void shang_Click(object sender, EventArgs e)
    {
        xia.Enabled = true;
        weiye.Enabled = true;
        pageindex -= 1;



        binddata();

        yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;
        if (pageindex == 1)
        {
            shang.Enabled = false;
            shouye.Enabled = false;
        }
        else
        {
            shang.Enabled = true;
            shouye.Enabled = true;
        }
    }
    protected void xia_Click(object sender, EventArgs e)
    {
        shang.Enabled = true;
        shouye.Enabled = true;
        pageindex += 1;
        yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;


        binddata();


        if (totalpages == pageindex)
        {
            xia.Enabled = false;
            weiye.Enabled = false;
        }
        else
        {
            xia.Enabled = true;
            weiye.Enabled = true;
        }
    }
    protected void weiye_Click(object sender, EventArgs e)
    {
        pageindex = totalpages;
        xia.Enabled = false;
        weiye.Enabled = false;
        shang.Enabled = true;
        shouye.Enabled = true;
        binddata();
        yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;
    }

    protected void go_Click(object sender, EventArgs e)
    {
        if (jiye.Text.Trim() != pageindex.ToString() && Convert.ToInt32(jiye.Text.Trim()) <= totalpages)
        {
            shang.Enabled = true;
            shouye.Enabled = true;
            xia.Enabled = true;
            weiye.Enabled = true;
            if (jiye.Text.Trim() != "")
            {
                pageindex = Convert.ToInt32(jiye.Text.Trim());
                binddata();
                yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;
                if (pageindex == 1)
                {
                    shang.Enabled = false;
                    shouye.Enabled = false;
                    xia.Enabled = true;
                    weiye.Enabled = true;
                }
                if (pageindex == totalpages)
                {
                    xia.Enabled = false;
                    weiye.Enabled = false;
                    shang.Enabled = true;
                    shouye.Enabled = true;
                }
            }
        }
    }



}