Hl.WebMain/AdmPage/BizPrintDocument/PartPkckData.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Hl.Code;
using System.Text;
using System.Data;

namespace Hl.WebMain.AdmPage.BizPrintDocument
{
    public partial class PartPkckData : System.Web.UI.Page
    {
        public DataModel.BizServicePartOrderInventory ThisInfo = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                StringBuilder returnData = new StringBuilder();
                #region "开始处理"
                BindModel();
                returnData.AppendLine("{");
                returnData.AppendLine("    \"PSupplier\":\"NO." + JsonHelper.FilterCharJson(ThisInfo.SupplierName) + "\",");//供应商
                returnData.AppendLine("    \"PDate\":\"" + JsonHelper.FilterCharJson(ThisInfo.EnsureDate.ToString("yyyy-MM-dd HH:mm:ss")) + "\",");//单据时间
                returnData.AppendLine("    \"PSerialNO\":\"" + JsonHelper.FilterCharJson("No." + ThisInfo.OrderCode) + "\",");//单据号
                returnData.AppendLine("    \"PRegUser\":\"" + JsonHelper.FilterCharJson(ThisInfo.OperatorNo) + "\",");//制单员
                #region "网格明细"
                string fields = " PartNo As parts_no"
                              + ",BizServicePart.Name As parts_name"
                              + ",BizServicePart.VtypeNo As vehicle_type_name"
                              + ",PartCount As parts_quantity"
                              + ",PartPrice As parts_price"
                              + ",(PartPrice*PartCount) As parts_money"
                              + ",(Select Top 1 WarehouseNo From BizServicePartStock Where BizServicePartStock.PartId=BizServicePartOrderInventoryDetail.Id And AdmShopId=BizServicePartOrderInventoryDetail.AdmShopId) As bin_location"
                              + "";
                string tbJoin = "Left Join BizServicePart On BizServicePart.Id=BizServicePartOrderInventoryDetail.PartId";
                DataTable dt1 = DataBll.BizServicePartOrderInventoryDetail.Select("", fields, tbJoin, "And OrderInventoryId=" + ThisInfo.Id, "Order By BizServicePartOrderInventoryDetail.CreateDate ASC").Tables[0];
                returnData.AppendLine("    \"Table\":" + JsonHelper.GetJsonFromDataTable(dt1) + "");
                #endregion
                returnData.AppendLine("}");
                #endregion
                Response.Write(returnData.ToString());
                Response.End();
            }
        }

        protected void BindModel()
        {
            ThisInfo = DataBll.BizServicePartOrderInventory.Select(DataConvert.ToInt(Request["Id"], 0));
        }
    }
}