Hl.WebMain/AdmPage/BizPrintDocument/PartCgrkData.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 Hl.Code;
using System.Text;
using System.Data;

namespace Hl.WebMain.AdmPage.BizPrintDocument
{
    public partial class PartCgdData : System.Web.UI.Page
    {
        public DataModel.BizServicePartOrderPurchase ThisInfo = null;
        public DataModel.BizSupplierInfo MgysInfo = 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("    \"PAddress\":\"" + JsonHelper.FilterCharJson(MgysInfo.ContactAddress) + "\",");//地址
                returnData.AppendLine("    \"PPhone\":\"" + JsonHelper.FilterCharJson(MgysInfo.ContactFixed + (MgysInfo.ContactPhone == "" ? "" : ("|" + MgysInfo.ContactPhone))) + "\",");//电话
                returnData.AppendLine("    \"PFax\":\"" + JsonHelper.FilterCharJson(MgysInfo.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("    \"PRemark\":\"" + JsonHelper.FilterCharJson(ThisInfo.OrderNote) + "\",");//票据类型
                returnData.AppendLine("    \"PBillType\":\"" + JsonHelper.FilterCharJson(ThisInfo.BillTypeNo) + "\",");//制单员
                returnData.AppendLine("    \"PPayType\":\"" + JsonHelper.FilterCharJson(ThisInfo.PaymentNo) + "\",");//付款方式
                returnData.AppendLine("    \"PPurchaseor\":\"" + JsonHelper.FilterCharJson(ThisInfo.QuoterNo) + " KM\",");//采购员
                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"
                              + ",BizServicePart.LastestBuyingPrice As latest_buying_price"
                              + ",PartCount As parts_quantity"
                              + ",PartPrice As parts_buying_price"
                              + ",(PartPrice*PartCount) As parts_money"
                              + ",PartFlowNote As flow_direction"
                              + ",PartLocation As bin_location"
                              + "";
                string tbJoin = "Left Join BizServicePart On BizServicePart.Id=BizServicePartOrderPurchaseDetail.PartId";
                DataTable dt1 = DataBll.BizServicePartOrderPurchaseDetail.Select("", fields, tbJoin, "And OrderPurchaseId=" + ThisInfo.Id, "Order By BizServicePartOrderPurchaseDetail.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.BizServicePartOrderPurchase.Select(DataConvert.ToInt(Request["Id"], 0));