com.huiyou.Web/admin/order_print.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using com.huiyou.Web.tools;
using com.huiyou.Bll;
using System.Data;
using com.huiyou.Common;
using System.Web.UI.HtmlControls;

namespace com.huiyou.Web.admin
{
    public partial class order_print : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!AdminLoginHelper.AdminEnter()) return;

            if (!Page.IsPostBack)
            {
                BindData();
            }
        }

        private void BindData()
        {
            string orderId = Request["orderId"];

            var order = OrderHeadService.GetById(Convert.ToInt32(orderId));
            var user = UserService.GetById(order.UserId);
            var factory = FactoryService.GetById(order.FactoryId);
            var courier = CourierService.GetById(order.CourierId);

            lrOrderNo.Text = order.OrderNo;
            lrCreateTime.Text = order.CreateTime.ToString("yyyy-MM-dd HH:mm");
            lrUser.Text = user.TrueName + " " + user.Phone;
            lrTotalAmount.Text = order.TotalAmount.ToString();
            lrFreight.Text = order.Freight.ToString();
            lrRealPay.Text = order.RealPay.ToString();
            lrPayType.Text = HtmlHelper.FormatPayType(order.PayType);
            lrAddress.Text = AreaService.GetProvinceName(order.ProvinceId)
                + AreaService.GetCityName(order.CityId) + AreaService.GetRegionName(order.RegionId) + order.Address 
                + " " + order.ReceiverName + " " + order.ReceiverPhone;
            //lrFactory.Text = factory.FactoryName;
            lrCourier.Text = courier.TrueName + "(" + courier.Phone + ")";
            lrMemo.Text = order.Memo;

            string sql = "select T1.*,T2.ProductNo,T2.ProductName,T3.CategoryName Cat1Name,T4.CategoryName Cat2Name," + Environment.NewLine;
            sql += "T5.CategoryName Cat3Name,dbo.FormatProductSpec(T1.SpecId) SpecName" + Environment.NewLine;
            sql += "from tb_OrderLine T1" + Environment.NewLine;
            sql += "inner join tb_Product T2 on T1.ProductId=T2.Id" + Environment.NewLine;
            sql += "inner join tb_ProductCategory T3 on T2.Cat1Id=T3.Id" + Environment.NewLine;
            sql += "inner join tb_ProductCategory T4 on T2.Cat2Id=T4.Id" + Environment.NewLine;
            sql += "left join tb_ProductCategory T5 on T2.Cat3Id=T5.Id" + Environment.NewLine;
            sql += "where T1.OrderId=" + orderId + Environment.NewLine;

            DataTable dt = DBHelper.SelectDataSet(sql).Tables[0];