po05.aspx.cs

简单的cI真的是很简单 你想要就下载吧

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using VinciDataAccess.DataAccess;
using VinciDataAccess.Entity;
using VinciBusinessLogic.BusinessLogic;


public partial class Web_Order_PO05 : BasePage
{
    string searchMessage = "抱歉！您搜索的订单不存在";

    private OrdersStore _ordersStore = new OrdersStore();
    public OrdersBL _ordersBL = new OrdersBL();//orderBL层
    OrdersCollection _orderList = new OrdersCollection();//order集合
    private string sqlStr = "select * from Orders where OrderCloseAccepterID IS null AND ReceiveInfoInputerID IS not null ";
    private string strWhere = "";

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Master.UserData = UserData;
            Master.Ticket = Ticket;

        }
        this.OrderSearch1.IsVisibleSearch = true;   //面初始加载时搜索控件隐藏
        this.OrderSearch1.IsResult = true;           //将开始搜索按钮不可见
        this.OrderSearch1.IsCloseEnabled = true;
        this.OrderSearch1.IsSearch = false;
        this.OrderSearch1.PageTitle = "待关闭订单一览";
        this.OrderSearch1.EmployeeID = UserData.EmployeeID;
        this.OrderSearch1.State = 3;
        this.OrderSearch1.OrderState = "待关闭";
        if (_orderList.Count<0)
            MakeTable(_orderList);
    }

    private void MakeTable(OrdersCollection _orderList)
    {
        needCloseOrderList.Rows.Clear();
        ShowTable showTable = new ShowTable(Ticket, UserData);
        needCloseOrderList.Rows.Add(showTable.SetTableName("待关闭的订单"));
        needCloseOrderList.Rows.Add(showTable.GetHeadRow());
        showTable.AddDataToRows(ref  needCloseOrderList, _orderList, "待关闭");
    }
    #region
    /// <summary>
    /// serch order
    /// </summary>
    /// <returns></returns>
    private void GetorderCollection()
    {
        try
        {
            int _orgID = UserData.OrgID;

            int _orderNum = _ordersBL.GetNeedCloseOrdersNum(_orgID);

            if (_orderNum > 0)
            {
                showMessage.Text = "";
            }
            else
            {
                showMessage.Text = searchMessage;
                this.showMessage.ForeColor = System.Drawing.Color.Brown;
            }

            _orderList = _ordersBL.GetSearchOrders(SearchOrders());
            if (_orderList.Count > 0)
            {
                showMessage.Text = "";
            }
            else
            {
                showMessage.Text = searchMessage;
                this.showMessage.ForeColor = System.Drawing.Color.Brown;
            }
        }
        catch (Exception ex)
        {
            showMessage.Text = ex.Message;
        }
    }
    #endregion
    #region
    public string SearchOrders()
    {
        if (strWhere == "")
        {
            if (this.OrderSearch1.OrderID != "")
            {
                strWhere += "AND OrderID like '%" + this.OrderSearch1.OrderID + "%'";
            }
            if (this.OrderSearch1.OrderID == "")
            {
                strWhere += "AND OrderID LIKE '%' ";
            }
            if (Convert.ToString(this.OrderSearch1.CustomerID) != "0")
            {
                strWhere += " AND CustomerID=" + this.OrderSearch1.CustomerID;
            }
            if (Convert.ToString(this.OrderSearch1.OrderCreateID) != "0")
            {
                strWhere += " AND OrderCreaterID=" + this.OrderSearch1.OrderCreateID;
            }
            if (Convert.ToString(this.OrderSearch1.StorehouseAccepterID) != "0")
            {
                strWhere += " AND StorehouseAccepterID=" + this.OrderSearch1.StorehouseAccepterID;
            }
            if ((this.OrderSearch1.CreatOrderStartTime != Convert.ToString(DateTime.Now.Date)) || (this.OrderSearch1.CreateOrderEndTime != Convert.ToString(DateTime.Now.Date)))
            {
                strWhere += " AND OrderDate BETWEEN '" + this.OrderSearch1.CreatOrderStartTime + "' AND '" + this.OrderSearch1.CreateOrderEndTime + "'";
            }
            if ((this.OrderSearch1.StoreHourseStartTime != Convert.ToString(DateTime.Now.Date)) || (this.OrderSearch1.StoreHourseEndTime != Convert.ToString(DateTime.Now.Date)))
            {
                strWhere += " AND StorehouseReadyDate BETWEEN '" + this.OrderSearch1.StoreHourseStartTime + "' AND '" + this.OrderSearch1.StoreHourseEndTime;
            }
            if ((this.OrderSearch1.SendStartTime != Convert.ToString(DateTime.Now.Date)) || (this.OrderSearch1.SendEndTime != Convert.ToString(DateTime.Now.Date)))
            {
                strWhere += " AND TransportDate BETWEEN '" + this.OrderSearch1.SendStartTime + "' AND '" + this.OrderSearch1.SendEndTime;
            }
            if ((this.OrderSearch1.CloseStartTime != Convert.ToString(DateTime.Now.Date)) || (this.OrderSearch1.CloseEndTime != Convert.ToString(DateTime.Now.Date)))
            {
                strWhere += " AND RequiredDate BETWEEN '" + this.OrderSearch1.CloseStartTime + "' AND '" + this.OrderSearch1.CloseEndTime;
            }
            if (this.OrderSearch1.OrgID.ToString() != "-1")
            {
                strWhere += " AND OrgID=" + this.OrderSearch1.OrgID.ToString();
            }
        }
        sqlStr += strWhere;
        this.OrderSearch1.SqlStr = sqlStr;
        return sqlStr;
    }
    #endregion
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        GetorderCollection();
        MakeTable(_orderList);
    }
    protected void LinkButton_AllNeedClose_Click(object sender, EventArgs e)
    {
        _orderList = _ordersBL.GetNeedCloseOrders(UserData.OrgID);
        MakeTable(_orderList);
    }
}