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

public partial class PO02 :BasePage
{
    Common com = new Common();
    OrdersBL ordersBL = new OrdersBL(); 
    protected void Page_Load(object sender, EventArgs e)
    {
        Master.UserData = UserData;
        this.OrderSearch1.IsVisibleSearch = true;
        this.OrderSearch1.State = 0;
        this.OrderSearch1.EmployeeID = UserData.EmployeeID; ;
        this.OrderSearch1.OrderState = "待备贷";
        if (!Page.IsPostBack)
        {

            ////初始化页面，绑定前5条订单数据
            OrdersCollection ordersCollection = new OrdersCollection();
            ordersCollection = ordersBL.GetStorehouseOrdersList();
            //if (this.OrderSearch1.CreatOrderStartTime.ToString=DateTime.Today.ToString())
            //{
            //    this.OrderSearch1.CreatOrderStartTime = "01-01-22";
            //}

            GetSurelyOrders(ordersCollection);
        }
        else
        {
            OrdersCollection ordersCollection = new OrdersCollection();
            ordersCollection = ordersBL.GetStorehouseOrdersList();
            GetSurelyOrders(ordersCollection);
        }

    }
    private void GetSurelyOrders(OrdersCollection ordersCollection)
    {
        WebService.EmployeesEntity _employeesEntity = new WebService.EmployeesEntity();
        WebService.VinciService _webService = new WebService.VinciService();
        this.MessageLable.Visible = false;
        int _tabRows = SeachTable.Rows.Count;
        for (int i = 0; i <= _tabRows; i++)
        {
            if (SeachTable.Rows.Count > 1 )
            {
                SeachTable.Rows.RemoveAt(1);
            }
        }
        if (ordersCollection.Count>0)
        {
            foreach (OrdersEntity order in ordersCollection)
            {
                string customersCompanyName = ordersBL.GetCustomersCompanyName(order.CustomerID);
                //string orderCreaterName =_webService.GetEmployeeName(order.OrderCreaterID, order.OrderCreaterID, Ticket, out error_Message);
                string orderCreaterName = _webService.GetEmployeeName(order.OrderCreaterID,1, Ticket, out error_Message);
                string orgName = _webService.GetOrgName(order.OrgID, order.OrgID, Ticket, out error_Message);
                TableRow tr = new TableRow();
               
                TableCell tdCustomerID = new TableCell();
                tdCustomerID.Text = customersCompanyName;
                //TableCell tdEmployeeID = new TableCell();
                //tdEmployeeID.Text = employeesName;
                TableCell tdOrderCreaterID = new TableCell();
                tdOrderCreaterID.Text = orderCreaterName;
                TableCell tdOrderDate = new TableCell();
                tdOrderDate.Text = com.StringNullToEmpty(order.OrderDate.ToString());
                TableCell tdRequiredDate = new TableCell();
                tdRequiredDate.Text = com.StringNullToEmpty(order.OrderNote);                
                TableCell tdOrgName = new TableCell();
                tdOrgName.Text = orgName;
                TableCell tdState = new TableCell();
                tdState.Text = "待备贷";
                TableCell tdOrderID = new TableCell();
                tdOrderID.Text = "<a href='#' onclick=" + "\"" + "javascript:showModalDialog('PO07.aspx?OrderID=" + order.OrderID.ToString() + "','_blank', 'dialogWidth:600px;dialogHeight:800px;center:yes;status:yes');" + "\">" + "<span style='font-size:9pt;text-decoration:none;color:red;'>" + "详细信息" + "</a>"; 
                
                tr.Cells.Add(tdCustomerID);
                //tr.Cells.Add(tdEmployeeID);
                tr.Cells.Add(tdOrderCreaterID);
                tr.Cells.Add(tdOrderDate);
                tr.Cells.Add(tdRequiredDate);                
                tr.Cells.Add(tdOrgName);
                tr.Cells.Add(tdState);
                tr.Cells.Add(tdOrderID);
                this.SeachTable.Rows.Add(tr);
            }
        }
        else
        {
            this.MessageLable.Visible = true;
            MessageLable.Text = "没有检索到待备贷订单";
        }
    }
    //将用户选择的查询项变为查询语句
    private string GetSqlStr()
    {
        string orderID = this.OrderSearch1.OrderID.ToString();
        if(orderID=="")
        {
            orderID="%";
        }
        else {};
        int customerID = this.OrderSearch1.CustomerID;
        int orderCreateID = this.OrderSearch1.OrderCreateID;
        string beginDate = this.OrderSearch1.CreatOrderStartTime;
        string endDate = this.OrderSearch1.CreateOrderEndTime.ToString();
        int orgID = this.OrderSearch1.OrgID;
        string strSql = com.GetSqlStr(orderID, customerID, orderCreateID, beginDate, endDate, orgID);
        return strSql;
        
    }
    //按条件搜索待备贷订单
    protected void Search_Click(object sender, EventArgs e)
    {
        OrdersCollection ordersCollection = new OrdersCollection();
        ordersCollection = ordersBL.GetSearchOrders(GetSqlStr());
        this.la.Text = GetSqlStr().ToString();
        GetSurelyOrders(ordersCollection);        
    }
}