Hl.WebMain/AdmPage/BizPrintDocument/PartCgthData.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 PartCgthData : System.Web.UI.Page
    {
        public DataModel.BizServicePartOrderPurchaseReturn ThisInfo = null;
        public DataModel.BizServicePartOrderPurchase       CgrkInfo = 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(CgrkInfo.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.ReturnDate.ToString("yyyy-MM-dd HH:mm:ss")) + "\",");//单据时间
                returnData.AppendLine("    \"PSerialNO\":\"" + JsonHelper.FilterCharJson("No." + ThisInfo.OrderCode) + "\",");//单据号
                returnData.AppendLine("    \"PRemark\":\"" + JsonHelper.FilterCharJson(CgrkInfo.OrderNote) + "\",");//票据类型
                returnData.AppendLine("    \"PBillType\":\"" + JsonHelper.FilterCharJson(CgrkInfo.BillTypeNo) + "\",");//制单员
                returnData.AppendLine("    \"PPayType\":\"" + JsonHelper.FilterCharJson(CgrkInfo.PaymentNo) + "\",");//付款方式
                returnData.AppendLine("    \"PPurchaseor\":\"" + JsonHelper.FilterCharJson(CgrkInfo.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"
                              + "";
                string tbJoin = "Left Join BizServicePart On BizServicePart.Id=BizServicePartOrderPurchaseReturnDetail.PartId";
                DataTable dt1 = DataBll.BizServicePartOrderPurchaseReturnDetail.Select("", fields, tbJoin, "And OrderPurchaseReturnId=" + ThisInfo.Id, "Order By BizServicePartOrderPurchaseReturnDetail.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.BizServicePartOrderPurchaseReturn.Select(DataConvert.ToInt(Request["Id"], 0));
            CgrkInfo =ThisInfo==null?null:DataBll.BizServicePartOrderPurchase.Select(ThisInfo.OrderPurchaseId);