Hl.WebMain/AdmPage/BizPrintDocument/PartXsthData.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 PartXsthData : System.Web.UI.Page
    {
        public DataModel.BizServicePartOrderSaleReturn ThisInfo = null;
        public DataModel.BizServicePartOrderSale       SaleInfo = null;
        public DataModel.BizCustomerInfo               KehuInfo = 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(SaleInfo.CustomerName) + "\",");
                returnData.AppendLine("    \"PAddress\":\"" + JsonHelper.FilterCharJson(KehuInfo.ContactAddress) + "\",");//地址
                returnData.AppendLine("    \"PPhone\":\"" + JsonHelper.FilterCharJson(KehuInfo.ContactFixed + (KehuInfo.ContactPhone == "" ? "" : ("|" + KehuInfo.ContactPhone))) + "\",");//电话
                returnData.AppendLine("    \"PFax\":\"" + JsonHelper.FilterCharJson(KehuInfo.ContactFixed) + "\",");//传真
                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_buying_price"
                              + ",(PartPrice*PartCount) As parts_money"
                              + ",(Select Top 1 WarehouseNo From BizServicePartStock Where BizServicePartStock.PartId=BizServicePartOrderSaleReturnDetail.Id And AdmShopId=BizServicePartOrderSaleReturnDetail.AdmShopId) As bin_location"
                              + "";
                string tbJoin = "Left Join BizServicePart On BizServicePart.Id=BizServicePartOrderSaleReturnDetail.PartId";
                DataTable dt1 = DataBll.BizServicePartOrderSaleReturnDetail.Select("", fields, tbJoin, "And OrderSaleReturnId=" + ThisInfo.Id, "Order By BizServicePartOrderSaleReturnDetail.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.BizServicePartOrderSaleReturn.Select(DataConvert.ToInt(Request["Id"], 0));
            SaleInfo = ThisInfo == null ? null : DataBll.BizServicePartOrderSale.Select(ThisInfo.OrderSaleId);
            KehuInfo = SaleInfo == null ? null : DataBll.BizCustomerInfo.Select(SaleInfo.CustomerId);
        }
    }
}