Admin/M_BookList.aspx.cs

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

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

namespace TicketNet.Admin{

    public partial  class M_BookList : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            DAL.Function.CheckState();
            if (!IsPostBack)
            {
                BindBookType();

                string sqlstr = " where 1=1 ";
                if (Request["barcode"] != null && Request["barcode"].ToString() != "")
                {
                    sqlstr += "  and barcode like '%" + Request["barcode"].ToString() + "%'";
                    barcode.Text = Request["barcode"].ToString();
                }
                if (Request["bookName"] != null && Request["bookName"].ToString() != "")
                {
                    sqlstr += "  and bookName like'%" + Request["bookName"].ToString() + "%'";
                    bookName.Text = Request["bookName"].ToString();
                }
                if (Request["bookTypeId"] != null && Request["bookTypeId"].ToString() != "0")
                {
                    sqlstr += "  and bookTypeId=" + Request["bookTypeId"].ToString();
                    bookTypeId.SelectedValue = Request["bookTypeId"].ToString();
                }
               
                HWhere.Value = sqlstr;
                BindData("");
                HWhere.Value = sqlstr;
                BindData("");
            }
        }

        private void BindBookType()
        {
            bookTypeId.DataSource = BLL.bllBookType.getAllBookType();

            bookTypeId.DataTextField = "typeName";
            bookTypeId.DataValueField = "typeId";
            bookTypeId.DataBind();
            ListItem li = new ListItem("=请选择=", "0");
            bookTypeId.Items.Add(li);
            bookTypeId.SelectedValue = "0";
        }