HPManage/ReportManage/MarkIn/MarkInDetail.aspx.cs

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

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

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

public partial class ReportManage_MarkIn_MarkInDetail : PageBase
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            try
            {
                btnExcel.Visible = RoleControl("|1302_6|");//导出权限
                Common.commad.BindDropDownList1(BillTypeTable("1"), ddlBillType, "ID", "BTName");//单据类型表
                if (Request.QueryString["BusUnitsID"] != null)
                {
                    hidBusUnitsID.Value = Request.QueryString["BusUnitsID"].ToString();
                    txtBusUnitsID.Value = ConvertToBOUName(Request.QueryString["BusUnitsID"].ToString());
                    hidMateID.Value = Request.QueryString["MateID"].ToString();
                    txtMateID.Value = ConvertMateName(Request.QueryString["MateID"].ToString());
                    ddlBillType.SelectedValue = Request.QueryString["BillType"].ToString();
                }
                DataBindData();
            }
            catch (Exception ex)
            {
                Common.WriteLog.CreateLog(ex, "ReportManage_MarkIn_MarkInDetail", "Page_Load", Session["TrueName"].ToString());
            }
        }
    }
    //主表数据
    protected void DataBindData()
    {
        try
        {
            DataTable dt = DataTable;
            AddPages(rpt, AspNetPager1, dt);
        }
        catch (Exception ex)
        {
            Common.WriteLog.CreateLog(ex, "ReportManage_MarkIn_MarkInDetail", "DataBindData", Session["TrueName"].ToString());
        }
    }

    private DataTable DataTable
    {
        get
        {
            BLL.MarkInSubInfor UserList = new BLL.MarkInSubInfor();
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" MIISState<>2 and MIIBZ<>3 ");
            strSql.Append(" and MarkINumber like '%" + txtProInNumber.Value.Trim() + "%' ");
            if (Request.QueryString["Year"] != null)
            {
                if (Request.QueryString["Year"].ToString() != "0")
                    strSql.Append(" and SUBSTRING(CONVERT(varchar(100),MarkITime, 23),1,4)=" + Request.QueryString["Year"].ToString());
            }
            if (Request.QueryString["Month"] != null)