ModelManage/SaleManage/StoreManage/OrderStoreQuery.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_StoreManage_OrderStoreQuery : PageBase
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            btnExcel.Visible = RoleControl("|1151_6|");//导出权限
            //BtnPrint.Visible = RoleControl("|1151_7|");//打印权限
            txtEnd.Attributes.Add("readonly", "true");
            txtStart.Attributes.Add("readonly", "true");
            DataBindData();
        }
    }
    //主表数据
    protected void DataBindData()
    {
        try
        {
            BLL.SCountInfor UserList = new BLL.SCountInfor();
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" SCountInfor.OrderNumber like '%" + txtOrderNumber.Value.Trim() + "%' and  OIState<>2 ");
            if (ddlBZ.SelectedValue != "-1")
            {
                strSql.Append(" and SOBZ=" + ddlBZ.SelectedValue);
            }
            if (txtStart.Value.Trim() != "" && txtEnd.Value.Trim() != "")
            {
                strSql.Append(" and OrderTime between '" + txtStart.Value.Trim() + "' and '" + DateTime.Parse(txtEnd.Value.Trim()).AddDays(1) + "'");
            }
            strSql.Append(" and SCountSubInfor.OrderModel like '%" + txtModelType.Value + "%'");
            DataSet ds_userinfor = UserList.GetList(50, strSql.ToString(), "SCountInfor.OrderNumber asc");
            DataTable dt = ds_userinfor.Tables[0];
            AddPages(rpt, AspNetPager1, dt);
        }
        catch (Exception ex)
        {
            Common.WriteLog.CreateLog(ex, "SaleManage_StoreManage_OrderStoreQuery", "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)
    {