JCK.Web/common/open/openCUSTOMS.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

namespace JCK.Web.common.open
{
    public partial class openCUSTOMS : System.Web.UI.Page
    {
        protected string keywords;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                rptBind();
            }
        }

        #region 数据绑定=================================
        private void rptBind()
        {

            DAL.DAL_CUSTOMS bll = new DAL.DAL_CUSTOMS();

            this.keywords = txtKeywords.Text;
            string where = " 1=1 ";
            if (keywords != "")
            {
                where += " and (CUSTOMS like '%'+@keywords+'%' or CU_NAME like '%'+@keywords+'%') ";
            }

            SqlParameter[] p_op = { 
                                      new SqlParameter("keywords",keywords)
                                      };
            DataTable dt = bll.GetList(where, p_op).Tables[0];

            pager_rpt.PageSize = 10;
            PagedDataSource pds = new PagedDataSource();
            pager_rpt.RecordCount = dt.Rows.Count;

            pds.DataSource = dt.DefaultView;
            pds.CurrentPageIndex = pager_rpt.CurrentPageIndex - 1;
            pds.PageSize = pager_rpt.PageSize;
            pds.AllowPaging = true;

            rptList.DataSource = pds;
            rptList.DataBind();
        }
        #endregion

        //分页
        protected void pager_rpt_PageChanged(object sender, EventArgs e)
        {
            rptBind();
        }