HPManage/WorkManage/MarkOut/MarkOutQuery.aspx.cs

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

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

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

public partial class WorkManage_MarkOut_MarkOutQuery : PageBase
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            try
            {
                btnExcel.Visible = RoleControl("|1212_6|");//导出权限
                txtEnd.Attributes.Add("readonly", "true");
                txtStart.Attributes.Add("readonly", "true");
                DateTime now = DateTime.Now;
                DateTime dtFist = new DateTime(now.Year, now.Month, 1);
                txtStart.Value = dtFist.ToShortDateString();
                txtEnd.Value = DateTime.Now.ToShortDateString();
                Common.commad.BindDropDownList1(BillTypeTable("1"), ddlBillType, "ID", "BTName");//单据类型表
                DataBindData();
            }
            catch (Exception ex)
            {
                Common.WriteLog.CreateLog(ex, "WorkManage_MarkOut_MarkOutQuery", "Page_Load", Session["TrueName"].ToString());
            }
        }
    }
    //主表数据
    protected void DataBindData()
    {
        try
        {
            BLL.MarkOutInfor UserList = new BLL.MarkOutInfor();
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" MarkONumber like '%" + txtProInNumber.Value.Trim() + "%' and  MOState<>2 and MOBZ<>3 ");
            if (txtProduct.Value.Trim() != "")//产品
            {
                string product = ConvertMateID(txtProduct.Value.Trim());
                if (product != "") strSql.Append(" and ProductID in (" + product + ")");
                else strSql.Append(" and ProductID=0 ");
            }
            if (txtBusUnitsID.Value.Trim() != "") //客户
            {
                string BusUnits = ConvertToBOUID(txtBusUnitsID.Value.Trim());
                if (BusUnits != "") strSql.Append(" and CostomerID in (" + BusUnits + ")");
                else strSql.Append(" and CostomerID=0 ");
            }
            if (ddlBillType.SelectedValue != "0")
            {
                strSql.Append(" and BillType=" + ddlBillType.SelectedValue.ToString());
            }
            if (ddlBZ.SelectedValue != "-1")
            {
                strSql.Append(" and MOBZ=" + ddlBZ.SelectedValue);
            }
            if (ddlMIILoss.SelectedValue != "-1")
            {
                strSql.Append(" and MOLoss=" + ddlMIILoss.SelectedValue);