k3CRM/BaseDataInfo/BaseDataQuery.aspx.cs

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

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
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.IO;
using Common;

namespace k3CRM.BaseDataInfo
{
    public partial class BaseDataQuery : BasePage
    {

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                ValidatePermissionPage(3);
                this.binddrpType();
                this.BindData("");
            }
        }
        protected void AspNetPager1_PageChanged(object sender, EventArgs e)
        {
            this.BindData(this.getstrfilter());
        }
        /// <summary>
        /// 分页绑定
        /// </summary>
        private void BindData(string strfilter)
        {
            DAL.dalBaseData dal = new DAL.dalBaseData();
            DataTable mydt = dal.getItemList(strfilter);
            AspNetPager1.RecordCount = mydt.Rows.Count;
            PagedDataSource pd = new PagedDataSource();
            pd.AllowPaging = true;
            pd.PageSize = AspNetPager1.PageSize;
            pd.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
            pd.DataSource = mydt.DefaultView;
            rptUserInfo.DataSource = pd;
            rptUserInfo.DataBind();
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string strfilter = " and FClassID=" + drptype.Items[drptype.SelectedIndex].Value.ToString() + " ";
            this.BindData(strfilter);
        }
        /// <summary>
        /// 绑定类别
        /// </summary>
        private void binddrpType()
        {
            //绑定dropdownlist
            string strsqltext = "SELECT FItemClassID,FNumber,FName,FDeleted FROM t_ItemClassCRM WHERE FItemClassID<>3   ";
            DAL.dalTools dalTol = new DAL.dalTools();