HPManage/WorkManage/SaleOut/SaleOutQuery.aspx.cs

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

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

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

public partial class WorkManage_SaleOut_SaleOutQuery : PageBase
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            try
            {
                btnExcel.Visible = RoleControl("|1232_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("3"), ddlBillType, "ID", "BTName");//单据类型表
                DataBindData();
            }
            catch (Exception ex)
            {
                Common.WriteLog.CreateLog(ex, "WorkManage_SaleOut_SaleOutQuery", "Page_Load", Session["TrueName"].ToString());
            }
        }
    }
    //主表数据
    protected void DataBindData()
    {
        try
        {
            BLL.SaleOutInfor UserList = new BLL.SaleOutInfor();
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" SaleONumber like '%" + txtSaleOutNumber.Value.Trim() + "%' and  SOState<>2 and SOBZ<>3 ");
            if (ddlBZ.SelectedValue != "-1")
            {
                strSql.Append(" and SOBZ=" + ddlBZ.SelectedValue);
            }
            if (txtStart.Value.Trim() != "" && txtEnd.Value.Trim() != "")
            {
                strSql.Append(" and SaleOTime between '" + txtStart.Value.Trim() + "' and '" + txtEnd.Value.Trim() + "'");
            }
            if (ddlBillType.SelectedValue != "0")
            {
                strSql.Append(" and BillType=" + ddlBillType.SelectedValue.ToString());
            }
            if (ddlMIILoss.SelectedValue != "-1")
            {
                strSql.Append(" and SOLoss=" + ddlMIILoss.SelectedValue);
            }
            if (txtBusUnitsID.Value.Trim() != "") //客户
            {
                string BusUnits = ConvertToBOUID(txtBusUnitsID.Value.Trim());
                if (BusUnits != "") strSql.Append(" and BusUnitsID in (" + BusUnits + ")");
                else strSql.Append(" and BusUnitsID=0 ");
            }
            DataSet ds_userinfor = UserList.GetList(500, strSql.ToString(), "SaleONumber desc");