po03.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.Linq;
using VinciBusinessLogic.BusinessLogic;
using BRISDataAccess.DataAccess;
using VinciDataAccess.Entity;
using VinciDataAccess.DataAccess;

public partial class Web_Order_PO03 :BasePage
{
    private OrdersBL _ordersBL = new OrdersBL();    
    private OrdersStore _orderStore = new OrdersStore();
    private Common myCn = new Common();
    private string sqlStr = "SELECT * FROM Orders WHERE TransportInfoInputerID IS NULL AND StorehouseAccepterID IS NOT NULL AND OrderCreaterID IS NOT NULL";
    private string strWhere = "";    
    private BasePage _basepage = new BasePage();
    private OrdersCollection _ordersCollection = new OrdersCollection();
    private CustomersBL _customersBL = new CustomersBL();
    private WebService.VinciService _vinviService = new WebService.VinciService();
    protected void Page_Load(object sender, EventArgs e)
    {
        Master.UserData = UserData;       
        this.OrderSearch1.IsVisibleSearch = true;
        this.OrderSearch1.IsResult = true;
        this.OrderSearch1.IsStoreHourseEnabled = true;
        this.OrderSearch1.IsSearch =false;
        this.OrderSearch1.PageTitle = "待出货订单预览";
        this.OrderSearch1.EmployeeID = UserData.EmployeeID;
        this.OrderSearch1.State = 1;
        this.OrderSearch1.OrderState = "待出货";
        if (this.OrderSearch1.IsResult)
        {
            this.searchBtn.Visible = true;
            ViewOrders();
        }
        if (!this.OrderSearch1.IsResult)
        {
            this.panel2.Visible = false;
            this.panel2.Enabled = false;
            this.searchBtn.Visible = false;
        }                                                                                                                                                                                                                                                                                                                             
      
    
    }
    private void SearchOrders()
    {
        try
        {
            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 != "01/01/2000 0:00:00") || (this.OrderSearch1.CreateOrderEndTime != Convert.ToString(DateTime.Now.Date)))
                {
                    strWhere += " AND OrderDate BETWEEN '" + this.OrderSearch1.CreatOrderStartTime + "' AND '" + this.OrderSearch1.CreateOrderEndTime + "'";                   
                }
                if ((this.OrderSearch1.StoreHourseStartTime != "01/01/2000 0:00:00") || (this.OrderSearch1.StoreHourseEndTime != Convert.ToString(DateTime.Now.Date)))
                {
                    strWhere += " AND StorehouseReadyDate BETWEEN '" + this.OrderSearch1.StoreHourseStartTime + "' AND '" + this.OrderSearch1.StoreHourseEndTime+"'";
                }
                if (this.OrderSearch1.OrgID.ToString() != "-1")
                {
                    strWhere += " AND OrgID=" + this.OrderSearch1.OrgID.ToString();
                }
            }
            strWhere+= " ORDER BY OrderDate Desc";
            sqlStr += strWhere;           
        }
        catch (Exception ex)
        {
            ///
            ////////////////////////////
            ///
        }
    }
    #region Create the first Bind
    private void ViewOrders()
    {

        try
        {
            if (!this.OrderSearch1.IsSearch)
            {
                this.message.Visible = false;
                _ordersCollection = _ordersBL.GetOutOrderList();

            }
            else
            {
                this.message.Visible = false;
                _ordersCollection = null;
                int _currentTabRows = this.searchTable.Rows.Count;
                for (int i = 1; i <= _currentTabRows; i++)
                {
                    if (this.searchTable.Rows.Count > 1)
                    {
                        this.searchTable.Rows.RemoveAt(1);
                    }
                }
                _ordersCollection = _ordersBL.GetSearchOrders(sqlStr);
            }
            if (_ordersCollection.Count == 0)
            {
                this.message.Visible = true;
                this.message.Text = "对不起,无订单相关记录!<a href='PO06.aspx'>新建订单</a>";

            }
            else
            {
                foreach (OrdersEntity order in _ordersCollection)
                {
                    TableRow tr = new TableRow();                   
                    TableCell tdCustomerID = new TableCell();
                    tdCustomerID.Text = _customersBL.GetCustomerName(order.CustomerID).ToString();
                    TableCell tdOrderCreaterID = new TableCell();
                    tdOrderCreaterID.Text = _vinviService.GetEmployeeName(order.OrderCreaterID, Convert.ToInt32(order.OrderCreaterID), _basepage.Ticket, out _basepage.error_Message);
                    TableCell tdPeiID = new TableCell();
                    tdPeiID.Text = _vinviService.GetEmployeeName(order.StorehouseAccepterID, Convert.ToInt32(order.StorehouseAccepterID), _basepage.Ticket, out _basepage.error_Message);
                    //TableCell tdTransport = new TableCell();
                    //tdTransport.Text = myCn.StringNullToEmpty(order.Carrier);
                    //TableCell tdReciver = new TableCell();
                    //tdReciver.Text = myCn.StringNullToEmpty(order.Receiver);
                    //TableCell tdClose = new TableCell();
                    //tdClose.Text = myCn.IntToString(order.OrderCloseAccepterID);
                    TableCell tdCreateTime = new TableCell();
                    tdCreateTime.Text = order.OrderDate.ToString();
                    //TableCell tdPeiTime = new TableCell();
                    //tdPeiTime.Text = myCn.DateTimeToString(order.StorehouseReadyDate);
                    //TableCell tdTransportTime = new TableCell();
                    //tdTransportTime.Text = myCn.DateTimeToString(order.TransportDate);
                    //TableCell tdOkTime = new TableCell();
                    //tdOkTime.Text = myCn.DateTimeToString(order.RequiredDate);
                    //TableCell tdCloseTime = new TableCell();
                    //tdCloseTime.Text = myCn.DateTimeToString(order.OrderCloseDate);
                    TableCell tdFen = new TableCell();
                    tdFen.Text = myCn.StringNullToEmpty(_vinviService.GetOrganizationInfo(order.OrgID, order.OrgID, _basepage.Ticket, out _basepage.error_Message).OrgName);
                    //TableCell tdBtn = new TableCell();
                    //tdBtn.Text = "<a href='PO07.aspx?OrderID=" + order.OrderID + "'></a>";
                    TableCell tdState = new TableCell();
                    tdState.Text = "待出货";
                    TableCell tdOrderID = new TableCell();
                    //tdOrderID.Text = "<a href='PO07.aspx?OrderID=" + order.OrderID.ToString() + "'>" + order.OrderID.ToString() + "</a>";
                    tdOrderID.Text = "<a href='#' onclick=" + "\"" + "javascript:window.open('PO07.aspx?OrderID=" + order.OrderID.ToString() + "','_blank', 'Width=600px,Height=400px,scrollbars=yes');" + "\">" + "<span style='font-size:9pt;text-decoration:none;color:red;'><strong>" + "详细信息" + "</strong></a>";                    
                    tr.Cells.Add(tdCustomerID);
                    tr.Cells.Add(tdOrderCreaterID);
                    tr.Cells.Add(tdPeiID);
                    //tr.Cells.Add(tdTransport);
                    //tr.Cells.Add(tdReciver);
                    //tr.Cells.Add(tdClose);
                    tr.Cells.Add(tdCreateTime);
                    //tr.Cells.Add(tdPeiTime);
                    //tr.Cells.Add(tdTransportTime);
                    //tr.Cells.Add(tdOkTime);
                    //tr.Cells.Add(tdCloseTime);
                    tr.Cells.Add(tdFen);
                    tr.Cells.Add(tdState);
                    tr.Cells.Add(tdOrderID);
                    this.searchTable.Rows.Add(tr);                 
                }
            }


        }
        catch (Exception ex)
        {
            ///
            ////////////////////////////
            ///
        }

    }
    #endregion
    protected void searchBtn_Click(object sender, EventArgs e)
    {
        this.OrderSearch1.IsSearch = true;
        SearchOrders();
        ViewOrders();
       


    }
   
}