showtable.cs

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

using System;
using System.Data;
using System.Configuration;
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;
using WebService;

/// <summary>
/// ShowTable の概要の説明です
/// </summary>
public class ShowTable
{//Minter

    OrdersBL ordersBL = new OrdersBL();
    CustomersBL customersBL = new CustomersBL();
    VinciService vinciService = new VinciService();
    string error_Message = string.Empty;
    string ticket;

    //OrdersEntity order = new OrdersEntity();

    //public OrdersEntity Order
    //{
    //    get { return order; }
    //    set { order = value; }
    //}
    User userData = new User();

    public User UserData
    {
        get { return userData; }
        set { userData = value; }
    }

    public string Ticket
    {
        get { return ticket; }
        set { ticket = value; }
    }
    string linkString = string.Empty;
    public string LinkString
    {
        get { return linkString; }
        set { linkString = value; }
    }
    public ShowTable(string ticket, User userData)
    {
        Ticket = ticket;
        UserData = userData;
        //
        // TODO: コンストラクタ ロジックをここに追加します



        //
    }
    /// <summary>
    /// 传入一个Order集合与表名 订单状态



    /// </summary>
    /// <param name="data"></param>
    /// <param name="list"></param>
    /// <param name="orderState"></param>
    public void AddDataToRows(ref Table data, OrdersCollection list, string orderState)
    {
        int count = 0;
        foreach (OrdersEntity order in list)
        {
            TableCell tdOrderID = GetStringCell("<a href='#' class=\"SuperLink\" onclick=\"javascript:showModalDialog('../.." + PageNames.m_strPO07 + "?OrderID=" + order.OrderID + "','_blank', 'dialogHeight:600px;center:yes;status:yes');" + "\">" + order.OrderID + "</a>");//订单ID

            TableCell tdCustmoerName = GetStringCell(ordersBL.GetCustomersCompanyName(order.CustomerID));//客户名称
            tdCustmoerName.ToolTip = GetOrderDetail(order.OrderID);//ToolTipx显示商品一览




            TableCell tdOrderDate = GetStringCell(DateTostring(order.OrderDate));//建立时间
            tdOrderDate.ToolTip = vinciService.GetEmployeeName(order.OrderCreaterID, UserData.EmployeeID, Ticket, out error_Message);//ToolTip显示建立者




            TableCell tdStoreReadyDate = GetStringCell(DateTostring(order.StorehouseReadyDate));//配货时间
            tdStoreReadyDate.ToolTip = vinciService.GetEmployeeName(order.StorehouseAccepterID, UserData.EmployeeID, Ticket, out error_Message);//ToolTip显示配货者




            TableCell tdCarrier = GetStringCell(order.Carrier);//发货者




            TableCell tdConfirmName = GetStringCell(vinciService.GetEmployeeName(order.ReceiveInfoInputerID, UserData.EmployeeID, Ticket, out error_Message));//确认者




            TableCell tdCloseName = GetStringCell(vinciService.GetEmployeeName(order.OrderCloseAccepterID, UserData.EmployeeID, Ticket, out error_Message));//关闭者



            TableCell tdOrderState = GetStringCell(orderState);//订单状态



            TableCell[] cells = { tdOrderID, tdCustmoerName, 
                                  tdOrderDate, tdStoreReadyDate,
                                  tdCarrier, tdConfirmName, 
                                  tdCloseName, tdOrderState 
                                };
            TableRow tr = MakeRow(cells);
            if (count % 2 == 0)
                tr.Attributes.Add("Class", "LineItem");
            else
                tr.Attributes.Add("Class", "LineItem1");
            data.Rows.Add(tr);
            count++;
        }
    }
    private string GetOrderDetail(int orderID)//返回订单详细信息text
    {
        string result = string.Empty;
        OrderDetailsEntity orderDetailsEntity = ordersBL.GetOrderDetailInfoOnePar(orderID);
        decimal total = (Convert.ToDecimal(orderDetailsEntity.UnitPrice) * Convert.ToDecimal(orderDetailsEntity.Discount) * Convert.ToInt32(orderDetailsEntity.Quantity));
        result += "商品名: " + customersBL.GetCustomerName(orderDetailsEntity.ProductID) + Environment.NewLine;//改成商品名



        result += "单  价: " + orderDetailsEntity.UnitPrice + Environment.NewLine;
        result += "折  扣: " + orderDetailsEntity.Discount + Environment.NewLine;
        result += "数  量: " + orderDetailsEntity.Quantity + Environment.NewLine;
        result += "总  价: " + total.ToString() + Environment.NewLine;
        return result;

    }

    /// <summary>
    /// 返回表名
    /// </summary>
    /// <param name="tableName"></param>
    /// <returns></returns>
    public TableRow SetTableName(string tableName)
    {
        TableCell TableName = GetStringCell(tableName);
        TableName.Font.Size = 10;
        TableName.ForeColor = System.Drawing.Color.CadetBlue;
        TableName.ColumnSpan = 8;
        TableName.Font.Bold = true;
        TableRow tr = new TableRow();
        tr.Cells.Add(TableName);
        return tr;
    }
    /// <summary>
    /// 返回表标题行
    /// </summary>
    /// <returns></returns>
    public TableRow GetHeadRow()
    {
        TableCell tdOrderID = GetStringCell("订单ID");
        TableCell tdCustmoerName = GetStringCell("客户名称");
        TableCell tdOrderDate = GetStringCell("建立时间");
        TableCell tdStoreReadyDate = GetStringCell("配货时间");

        TableCell tdCarrier = GetStringCell("发货者");
        TableCell tdConfirmName = GetStringCell("确认者");

        TableCell tdCloseName = GetStringCell("关闭者");
        TableCell tdOrderState = GetStringCell("订单状态");
        TableCell[] cells = {   tdOrderID, tdCustmoerName, 
                                tdOrderDate, tdStoreReadyDate,
                                tdCarrier, tdConfirmName, 
                                tdCloseName, tdOrderState 
                            };
        TableRow headRow = MakeRow(cells);
        headRow.Font.Size = 10;
        headRow.Attributes.Add("Class", "Header");
        //headRow.Font.Bold = true;
        return headRow;
    }
    /// <summary>
    /// 返回空行
    /// </summary>
    /// <returns></returns>
    public TableRow GetEmptyRow()
    {
        TableCell empty = new TableCell();
        empty.Text = "<br/><br/>";
        empty.ColumnSpan = 8;
        //empty.RowSpan = 2;

        TableRow emptyRow = new TableRow();
        emptyRow.Cells.Add(empty);
        //TableRow emptyRow = new TableRow();
        emptyRow.Font.Size = 10;
        emptyRow.Font.Bold = true;
        return emptyRow;
    }

    private TableCell GetStringCell(string text)//返回Text类型单元格
    {
        TableCell temp = new TableCell();
        temp.Text = text;
        temp.HorizontalAlign = HorizontalAlign.Center;
        return temp;
    }
    private TableCell GetStringToolTipCell(string text, string toolTip)//返回Text与ToolTip类型单元格
    {
        TableCell temp = new TableCell();
        temp.Text = text;
        temp.ToolTip = toolTip;
        temp.HorizontalAlign = HorizontalAlign.Center;
        return temp;
    }
    private TableRow MakeRow(TableCell[] cells)
    {
        TableRow tr = new TableRow();
        foreach (TableCell cell in cells)
        {
            if (cell != null)
                tr.Cells.Add(cell);
        }
        return tr;
    }
    private string DateTostring(Nullable<DateTime> date)
    {
        if (date != null)
        {
            int year = Convert.ToDateTime(date).Year;
            if (year > 1949 && year <= DateTime.Now.Year)
            {
                return Convert.ToDateTime(date).ToShortDateString();
            }
        }
        return "";
    }
}