ModelManage/SaleManage/TransManage/TransQuery.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Text;

public partial class SaleManage_TransManage_TransQuery : PageBase
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            btnExcel.Visible = RoleControl("|1162_6|");//导出权限
            //BtnPrint.Visible = RoleControl("|1162_7|");//打印权限
            txtEnd.Attributes.Add("readonly", "true");
            txtStart.Attributes.Add("readonly", "true");
            DataBindData();
        }
    }
    //主表数据
    protected void DataBindData()
    {
        try
        {
            BLL.TransInfor UserList = new BLL.TransInfor();
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" TransInfor.TransNumber like '%" + txtSaleONumber.Value.Trim() + "%' and  TIState<>2 and TIBZ<>3");
            if (ddlBZ.SelectedValue != "-1")
            {
                strSql.Append(" and TIBZ=" + ddlBZ.SelectedValue);
            }
            if (txtStart.Value.Trim() != "" && txtEnd.Value.Trim() != "")
            {
                strSql.Append(" and TransTime between '" + txtStart.Value.Trim() + "' and '" + txtEnd.Value.Trim() + "'");
            }
            strSql.Append(" and SCountSubInfor.OrderModel like '%" + txtModelType.Value + "%'");
            DataSet ds_userinfor = UserList.GetList(50, strSql.ToString(), "TransInfor.TransNumber asc");
            DataTable dt = ds_userinfor.Tables[0];
            AddPages(rpt, AspNetPager1, dt);
        }
        catch (Exception ex)
        {
            Common.WriteLog.CreateLog(ex, "SaleManage_TransManage_TransQuery", "DataBindData", Session["TrueName"].ToString());
        }
    }
    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
        DataBindData();
    }
    //查询
    protected void btnQuery_Click(object sender, EventArgs e)
    {
        DataBindData();
    }
    protected void rpt_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        Label stateLick = (Label)e.Item.FindControl("lblBZ");