MESWMS-WEBS.git

			@@ -9,6 +9,7 @@
			using System.Data.SqlClient;
			using System.Globalization;
			using Newtonsoft.Json;
			using Newtonsoft.Json.Linq;

			namespace CLOUDWEB
			{
			@@ -29,6 +30,281 @@
			return "Hello World";
			}


			#region 通过WEBAPI同步金蝶云数据至本地

			#region 单据同步

			#region 生产领料单同步根据单据号同步

			[WebMethod]
			public bool GetWebAPIToLocal_MateOut(string HBillNo, string HBillType, string HMaker, ref string sErrMsg)
			{
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();

			//从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码
			if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
			{
			sErrMsg = Pub_Class.ClsPub.sExeReturnInfo;
			return false;
			}

			//获取CLOUD账号密码
			string HReturn;
			string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
			string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;
			string dbId = Pub_Class.ClsPub.sCLOUDAcc;
			ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
			bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);

			if (bLogin)
			{
			//查看单据
			string sJson = "{\"CreateOrgId\":0,\"Number\":\"" + HBillNo + "\"}";
			var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.View",
			new object[] { "PRD_PickMtrl", sJson });
			var _saveObj = JObject.Parse(result);

			//判断数据是否获取成功
			if (_saveObj.SelectToken("Result.ResponseStatus.IsSuccess")?.ToString().ToUpper() != "TRUE")
			{
			HReturn = result.ToString();
			//反序列化json数据
			var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn);
			//接收金蝶报错信息
			var strErrorMsg = string.Empty;
			//遍历获取报错信息
			foreach (var item in retModel.Result.ResponseStatus.Errors)
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "同步单据失败！" + strErrorMsg;
			return false;
			}
			else
			{
			Int64 HInterID = 0;

			//获取单据ID，本地表中已存在当前单据，获取当前单据ID，不存在则获取最大单据ID
			DataSet dsID = oCn.RunProcReturn(" select HInterID from Kf_ICStockBillMain with(nolock) where HBillNo= '" + HBillNo + "' and HBillType= '" + HBillType + "'", "Kf_ICStockBillMain");
			if (dsID == null \|\| dsID.Tables[0].Rows.Count == 0)
			{
			HInterID = DBUtility.ClsPub.CreateBillID_Prod(HBillType, ref sErrMsg);
			}
			else
			{
			HInterID = DBUtility.ClsPub.isLong(dsID.Tables[0].Rows[0]["HInterID"]);
			oCn.RunProc("Delete from Kf_ICStockBillMain where HInterID=" + HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
			oCn.RunProc("Delete from Kf_ICStockBillSub where HInterID=" + HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
			}

			//主表数据赋值
			var MainData = new
			{
			HInterID = HInterID,
			HYear = DateTime.Now.Year,
			HPeriod = DateTime.Now.Month,
			HBillNo = _saveObj.SelectToken("Result.Result.BillNo")?.ToString() ?? "",
			HBillType = HBillType,
			HBillSubType = HBillType,
			HMainSourceBillType = "",
			HDate = _saveObj.SelectToken("Result.Result.Date")?.ToString(),
			HSupID = 0,
			HWHID = 0,
			HSCWHID = 0,
			HEmpID = 0,
			HManagerID = 0,
			HSecManagerID = _saveObj.SelectToken("Result.Result.PickerId_Id")?.ToString() ?? "0",
			HKeeperID = _saveObj.SelectToken("Result.Result.FSTOCKERID_Id")?.ToString() ?? "0",
			HDeptID = 0,
			HCurID = _saveObj.SelectToken("Result.Result.CurrId_Id")?.ToString() ?? "0",
			HCurNumber = _saveObj.SelectToken("Result.Result.CurrId.Number")?.ToString() ?? "",
			HSeOrderBillNo = "",
			HExplanation = "WebAPI导入",
			HRemark = "",
			HInnerBillNo = "",
			HRedBlueFlag = 0,
			HBillStatus = _saveObj.SelectToken("Result.Result.ApproverId_Id")?.ToString() == "0" ? 1 : 2,
			HMaker = _saveObj.SelectToken("Result.Result.CreatorId.Name")?.ToString() ?? "",
			HMakeDate = _saveObj.SelectToken("Result.Result.CreateDate")?.ToString(),
			HChecker = _saveObj.SelectToken("Result.Result.ApproverId.Name")?.ToString() ?? "",
			HCheckDate = _saveObj.SelectToken("Result.Result.ApproveDate")?.ToString(),
			HUpDater = _saveObj.SelectToken("Result.Result.ModifierId.Name")?.ToString() ?? "",
			HUpDateDate = _saveObj.SelectToken("Result.Result.ModifyDate")?.ToString(),
			HDeleteMan = _saveObj.SelectToken("Result.Result.CANCELER.Name")?.ToString() ?? "",
			HDeleteDate = _saveObj.SelectToken("Result.Result.CancelDate")?.ToString(),
			HOWNERID = _saveObj.SelectToken("Result.Result.OwnerId_Id")?.ToString() ?? "0",
			HOWNERTYPEID = _saveObj.SelectToken("Result.Result.OwnerTypeId")?.ToString() ?? "",
			HERPInterID = _saveObj.SelectToken("Result.Result.Id")?.ToString() ?? "0",
			HERPBillType = _saveObj.SelectToken("Result.Result.BillType_Id")?.ToString() ?? "",
			HERPBillNo = _saveObj.SelectToken("Result.Result.BillNo")?.ToString() ?? "",
			HPRDORGID = _saveObj.SelectToken("Result.Result.PrdOrgId_Id")?.ToString() ?? "0",
			HSTOCKORGID = _saveObj.SelectToken("Result.Result.StockOrgId_Id")?.ToString() ?? "0",
			};

			//插入主表
			oCn.RunProc("Insert Into Kf_ICStockBillMain " +
			"(HInterID,HYear,HPeriod,HBillNo,HBillType,HBillSubType" +
			",HMainSourceBillType,HDate,HSupID,HWHID,HSCWHID,HEmpID" +
			",HManagerID,HSecManagerID,HKeeperID,HDeptID,HCurID,HCurNumber" +
			",HSeOrderBillNo,HExplanation,HRemark,HInnerBillNo,HRedBlueFlag,HBillStatus" +
			",HMaker,HMakeDate,HChecker,HCheckDate" +
			",HUpDater,HUpDateDate,HDeleteMan,HDeleteDate" +
			",HOWNERID,HOWNERTYPEID,HERPInterID,HERPBillType,HERPBillNo" +
			",HPRDORGID,HSTOCKORGID" +
			") " +
			" values(" + MainData.HInterID.ToString() + "," + MainData.HYear.ToString() + "," + MainData.HPeriod.ToString() + ",'" + MainData.HBillNo + "','" + MainData.HBillType + "','" + MainData.HBillSubType + "'" +
			",'" + MainData.HMainSourceBillType + "','" + MainData.HDate + "'," + MainData.HSupID.ToString() + "," + MainData.HWHID.ToString() + "," + MainData.HSCWHID.ToString() + "," + MainData.HEmpID.ToString() +
			", " + MainData.HManagerID.ToString() + "," + MainData.HSecManagerID.ToString() + "," + MainData.HKeeperID.ToString() + "," + MainData.HDeptID.ToString() + "," + MainData.HCurID.ToString() + ",'" + MainData.HCurNumber + "'" +
			",'" + MainData.HSeOrderBillNo + "','" + MainData.HExplanation + "','" + MainData.HRemark + "','" + MainData.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(MainData.HRedBlueFlag) + "," + MainData.HBillStatus.ToString() +
			",'" + MainData.HMaker + "','" + MainData.HMakeDate + "','" + MainData.HChecker + "'," + (MainData.HCheckDate == "" ? "NULL" : "'" + MainData.HCheckDate + "'") +
			",'" + MainData.HUpDater + "'," + (MainData.HUpDateDate == "" ? "NULL" : "'" + MainData.HUpDateDate + "'") + ",'" + MainData.HDeleteMan + "'," + (MainData.HDeleteDate == "" ? "NULL" : "'" + MainData.HDeleteDate + "'") +
			", " + MainData.HOWNERID.ToString() + ",'" + MainData.HOWNERTYPEID + "'," + MainData.HERPInterID.ToString() + ",'" + MainData.HERPBillType + "','" + MainData.HERPBillNo + "'" +
			", " + MainData.HPRDORGID.ToString() + "," + MainData.HSTOCKORGID.ToString() +
			") ");

			//子表数据赋值
			var dataArr = _saveObj.SelectToken("Result.Result.Entity") as JArray;

			if (dataArr != null)
			{
			foreach (var oSub in dataArr)
			{
			var SubData = new
			{
			HInterID = HInterID,
			HEntryID = oSub.SelectToken("Id")?.ToString() ?? "0",
			HMTONo = oSub.SelectToken("MTONO")?.ToString() ?? "",
			HPlanMode = 0,
			HRemark = "",
			HExpressNumber = "",
			HMaterID = oSub.SelectToken("MaterialId_Id")?.ToString() ?? "0",
			HUnitID = oSub.SelectToken("UnitId_Id")?.ToString() ?? "0",
			HBatchNo = oSub.SelectToken("Lot_Text")?.ToString() ?? "",
			HPropertyID = oSub.SelectToken("AuxPropId_Id")?.ToString() ?? "0",
			HWHID = oSub.SelectToken("StockId_Id")?.ToString() ?? "0",
			HSPID = oSub.SelectToken("StockLocId_Id")?.ToString() ?? "0",
			HSCWHID = 0,
			HSCSPID = 0,
			HQtyMust = oSub.SelectToken("AppQty")?.ToString() ?? "0",
			HQty = oSub.SelectToken("ActualQty")?.ToString() ?? "0",
			HPrice = oSub.SelectToken("FPrice")?.ToString() ?? "0",
			HMoney = oSub.SelectToken("FAmount")?.ToString() ?? "0",
			HTaxPrice = oSub.SelectToken("FPrice")?.ToString() ?? "0",
			HTaxRate = 1,
			HTaxMoney = oSub.SelectToken("FAmount")?.ToString() ?? "0",
			HRelationQty = oSub.SelectToken("SelPrcdReturnQty")?.ToString() ?? "0",
			HRelationMoney = 0,
			HSourceInterID = oSub.SelectToken("SrcInterId")?.ToString() ?? "0",
			HSourceEntryID = oSub.SelectToken("SrcEnteryId")?.ToString() ?? "0",
			HSourceBillNo = oSub.SelectToken("SrcBillNo")?.ToString() ?? "",
			HSourceBillType = oSub.SelectToken("SrcBillType")?.ToString() ?? "",
			HERPInterID = _saveObj.SelectToken("Result.Result.Id")?.ToString() ?? "0",
			HERPEntryID = oSub.SelectToken("Id")?.ToString() ?? "0",
			HERPBillNo_Sub = "",
			HPOOrderInterID = 0,
			HPOOrderEntryID = 0,
			HPOOrderBillNo = "",
			HSeOrderInterID = 0,
			HSeOrderEntryID = 0,
			HSeOrderBillNo = "",
			HICMOInterID = oSub.SelectToken("MoId")?.ToString() ?? "0",
			HICMOEntryID = oSub.SelectToken("MoEntryId")?.ToString() ?? "0",
			HICMOBillNo = oSub.SelectToken("MoBillNo")?.ToString() ?? "",
			HWWOrderInterID = 0,
			HWWOrderEntryID = 0,
			HWWOrderBillNo = "",
			HProduceDate = oSub.SelectToken("ProduceDate")?.ToString(),
			HExpiryDate = oSub.SelectToken("ExpiryDate")?.ToString(),
			HOWNERID = oSub.SelectToken("OwnerId_Id")?.ToString() ?? "0",
			HOWNERTYPEID = oSub.SelectToken("OwnerTypeId")?.ToString() ?? "",
			HKEEPERID = oSub.SelectToken("KeeperId_Id")?.ToString() ?? "0",
			HKEEPERTYPEID = oSub.SelectToken("KeeperTypeId")?.ToString() ?? "",
			HBASEUNITID = oSub.SelectToken("BaseUnitId_Id")?.ToString() ?? "0",
			HPROJECTNO = oSub.SelectToken("ProjectNo")?.ToString() ?? "",
			HSTOCKSTATUSID = oSub.SelectToken("StockStatusId_Id")?.ToString() ?? "0",
			HSTOCKSTATUSNumber = oSub.SelectToken("StockStatusId.Number")?.ToString() ?? "",
			HOPERID = oSub.SelectToken("OperId")?.ToString() ?? "0",
			HPROCESSID = oSub.SelectToken("ProcessId_Id")?.ToString() ?? "0",
			HPROCESSNumber = oSub.SelectToken("ProcessId.Number")?.ToString() ?? "",
			HWORKSHOPID = oSub.SelectToken("WorkShopId_Id")?.ToString() ?? "0",
			HRESERVETYPE = oSub.SelectToken("ReserveType")?.ToString() ?? "",
			HPARENTOWNERTYPEID = oSub.SelectToken("ParentOwnerTypeId")?.ToString() ?? "",
			HPARENTOWNERID = oSub.SelectToken("ParentOwnerId_Id")?.ToString() ?? "0",
			HICMOEntrySEQ = oSub.SelectToken("MoEntrySeq")?.ToString() ?? "0",
			HPPBOMENTRYID = oSub.SelectToken("PPBomEntryId")?.ToString() ?? "0",
			HPPBOMBILLNO = oSub.SelectToken("PPBomBillNo")?.ToString() ?? "",
			HSEQ = oSub.SelectToken("Seq")?.ToString() ?? "0",
			HSRCBIZBILLTYPE = oSub.SelectToken("SRCBIZBILLTYPE")?.ToString() ?? "",
			HSRCBIZBILLNO = oSub.SelectToken("SRCBIZBILLNO")?.ToString() ?? "",
			HSRCBIZINTERID = oSub.SelectToken("SRCBIZINTERID")?.ToString() ?? "0",
			HSRCBIZENTRYID = oSub.SelectToken("SRCBIZENTRYID")?.ToString() ?? "0",
			HSRCBIZENTRYSEQ = oSub.SelectToken("SRCBIZENTRYSEQ")?.ToString() ?? "0",
			HWORKCENTERID = oSub.SelectToken("WorkCenterId_Id")?.ToString() ?? "0",
			HWORKCENTERNumber = oSub.SelectToken("WorkCenterId.Number")?.ToString() ?? "",
			HOPTQUEUE = oSub.SelectToken("OptQueue")?.ToString() ?? "",
			HOPTPLANBILLNO = oSub.SelectToken("OptPlanBillNo")?.ToString() ?? "",
			HOPTPLANBILLID = oSub.SelectToken("OptPlanBillId")?.ToString() ?? "0",
			HOPTDETAILID = oSub.SelectToken("OptDetailId")?.ToString() ?? "0",
			HREQSRC = oSub.SelectToken("ReqSrc")?.ToString() ?? "",
			HREQBILLNO = oSub.SelectToken("ReqBillNo")?.ToString() ?? "",
			HREQBILLID = oSub.SelectToken("ReqBillId")?.ToString() ?? "0",
			HREQENTRYSEQ = oSub.SelectToken("ReqEntrySeq")?.ToString() ?? "0",
			HREQENTRYID = oSub.SelectToken("ReqEntryId")?.ToString() ?? "0",
			HPARENTMATERIALID = oSub.SelectToken("ParentMaterialId_Id")?.ToString() ?? "0",
			};

			//插入子表
			oCn.RunProc("Insert Into Kf_ICStockBillSub " +
			"(HInterID,HEntryID,HMTONo,HPlanMode,HRemark,HExpressNumber" +
			",HMaterID,HUnitID,HBatchNo,HPropertyID,HWHID,HSPID" +
			",HSCWHID,HSCSPID,HQtyMust,HQty,HPrice,HMoney" +
			",HTaxPrice,HTaxRate,HTaxMoney,HRelationQty,HRelationMoney" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
			",HERPInterID,HERPEntryID,HERPBillNo_Sub" +
			",HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" +
			",HICMOInterID,HICMOEntryID,HICMOBillNo,HWWOrderInterID,HWWOrderEntryID,HWWOrderBillNo" +
			",HProduceDate,HExpiryDate,HOWNERID,HOWNERTYPEID,HKEEPERID,HKEEPERTYPEID" +
			",HBASEUNITID,HPROJECTNO,HSTOCKSTATUSID,HOPERID,HPROCESSID,HWORKSHOPID" +
			",HRESERVETYPE,HPARENTOWNERTYPEID,HPARENTOWNERID,HICMOEntrySEQ,HPPBOMENTRYID,HPPBOMBILLNO" +
			",HSEQ,HSRCBIZBILLTYPE,HSRCBIZBILLNO,HSRCBIZINTERID,HSRCBIZENTRYID,HSRCBIZENTRYSEQ" +
			",HWORKCENTERID,HOPTQUEUE,HOPTPLANBILLNO,HOPTPLANBILLID,HOPTDETAILID,HREQSRC" +
			",HREQBILLNO,HREQBILLID,HREQENTRYSEQ,HREQENTRYID,HPARENTMATERIALID" +
			",HSTOCKSTATUSNumber,HPROCESSNumber,HWORKCENTERNumber" +
			") " +
			" values(" + SubData.HInterID.ToString() + "," + SubData.HEntryID.ToString() + ",'" + SubData.HMTONo + "'," + SubData.HPlanMode.ToString() + ",'" + SubData.HRemark + "','" + SubData.HExpressNumber + "'" +
			", " + SubData.HMaterID.ToString() + "," + SubData.HUnitID.ToString() + ",'" + SubData.HBatchNo + "'," + SubData.HPropertyID.ToString() + "," + SubData.HWHID.ToString() + "," + SubData.HSPID.ToString() +
			", " + SubData.HSCWHID.ToString() + "," + SubData.HSCSPID.ToString() + "," + SubData.HQtyMust.ToString() + "," + SubData.HQty.ToString() + "," + SubData.HPrice.ToString() + "," + SubData.HMoney.ToString() +
			", " + SubData.HTaxPrice.ToString() + "," + SubData.HTaxRate.ToString() + "," + SubData.HTaxMoney.ToString() + "," + SubData.HRelationQty.ToString() + "," + SubData.HRelationMoney.ToString() +
			", " + SubData.HSourceInterID.ToString() + "," + SubData.HSourceEntryID.ToString() + ",'" + SubData.HSourceBillNo + "','" + SubData.HSourceBillType + "'" +
			", " + SubData.HERPInterID.ToString() + "," + SubData.HERPEntryID.ToString() + ",'" + SubData.HERPBillNo_Sub + "'" +
			", " + SubData.HPOOrderInterID.ToString() + "," + SubData.HPOOrderEntryID.ToString() + ",'" + SubData.HPOOrderBillNo + "'," + SubData.HSeOrderInterID.ToString() + "," + SubData.HSeOrderEntryID.ToString() + ",'" + SubData.HSeOrderBillNo + "'" +
			", " + SubData.HICMOInterID.ToString() + "," + SubData.HICMOEntryID.ToString() + ",'" + SubData.HICMOBillNo + "'," + SubData.HWWOrderInterID.ToString() + "," + SubData.HWWOrderEntryID.ToString() + ",'" + SubData.HWWOrderBillNo + "'" +
			", " + (SubData.HProduceDate == "" ? "NULL" : "'" + SubData.HProduceDate + "'") + "," + (SubData.HExpiryDate == "" ? "NULL" : "'" + SubData.HExpiryDate + "'") + "," + SubData.HOWNERID.ToString() + ",'" + SubData.HOWNERTYPEID + "'," + SubData.HKEEPERID.ToString() + ",'" + SubData.HKEEPERTYPEID + "'" +
			", " + SubData.HBASEUNITID.ToString() + ",'" + SubData.HPROJECTNO + "'," + SubData.HSTOCKSTATUSID.ToString() + "," + SubData.HOPERID.ToString() + "," + SubData.HPROCESSID.ToString() + "," + SubData.HWORKSHOPID.ToString() +
			",'" + SubData.HRESERVETYPE + "','" + SubData.HPARENTOWNERTYPEID + "'," + SubData.HPARENTOWNERID.ToString() + "," + SubData.HICMOEntrySEQ.ToString() + "," + SubData.HPPBOMENTRYID.ToString() + ",'" + SubData.HPPBOMBILLNO + "'" +
			", " + SubData.HSEQ.ToString() + ",'" + SubData.HSRCBIZBILLTYPE + "','" + SubData.HSRCBIZBILLNO + "'," + SubData.HSRCBIZINTERID.ToString() + "," + SubData.HSRCBIZENTRYID.ToString() + "," + SubData.HSRCBIZENTRYSEQ.ToString() +
			", " + SubData.HWORKCENTERID.ToString() + ",'" + SubData.HOPTQUEUE + "','" + SubData.HOPTPLANBILLNO + "'," + SubData.HOPTPLANBILLID.ToString() + "," + SubData.HOPTDETAILID.ToString() + ",'" + SubData.HREQSRC + "'" +
			",'" + SubData.HREQBILLNO + "'," + SubData.HREQBILLID.ToString() + "," + SubData.HREQENTRYSEQ.ToString() + "," + SubData.HREQENTRYID.ToString() + "," + SubData.HPARENTMATERIALID.ToString() +
			",'" + SubData.HSTOCKSTATUSNumber + "','" + SubData.HPROCESSNumber + "','" + SubData.HWORKCENTERNumber + "'" +
			") ");
			}
			}
			return true;
			}
			}
			else
			{
			sErrMsg = "同步单据失败！金蝶云登录失败！";
			return false;
			}
			}

			#endregion

			#endregion

			#endregion

			#region 基础资料

			@@ -16480,7 +16756,7 @@
			}

			//辅助属性
			if (oSystemParameterMain.WMS_CampanyName == "凯贝奈特") //系统参数客户定制化名称空白为通用
			if (oSystemParameterMain.WMS_CampanyName == "凯贝奈特" \|\| oSystemParameterMain.WMS_CampanyName == "兴达") //系统参数客户定制化名称空白为通用
			{
			sJson_FAUXPROPID = " \"FAUXPROPID\":{\"FAUXPROPID__FF100001\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID"]) + "\"}},";
			}
			@@ -19253,7 +19529,7 @@
			}

			//辅助属性
			if (oSystemParameterMain.WMS_CampanyName == "凯贝奈特") //系统参数客户定制化名称空白为通用
			if (oSystemParameterMain.WMS_CampanyName == "凯贝奈特" \|\| oSystemParameterMain.WMS_CampanyName == "兴达") //系统参数客户定制化名称空白为通用
			{
			sJson_FAUXPROPID = " \"FAUXPROPID\":{\"FAUXPROPID__FF100001\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID"]) + "\"}},";
			}
			@@ -21193,21 +21469,20 @@
			return false;
			}
			}
			//else if (sHSourceType == "1204") //生产领料单
			//{
			// if (SaveMateOutBackBill_MateOut_CLD(oMain, sHSourceType, oSystemParameterMain, ref sErrMsg))
			// {
			// //"保存成功！";
			// sErrMsg = "保存成功！" + oMain.HBillNo;
			// return true;
			// }
			// else
			// {
			// //"保存失败！";
			// sErrMsg = "单据号：" + oMain.HBillNo + "，单据ID：" + oMain.HInterID + "；" + sErrMsg;
			// return false;
			// }
			//}
			else if (sHSourceType == "1204") //生产领料单
			{
			if (SaveMateOutBackBill_MateOut_CLD(oMain, sHSourceType, oSystemParameterMain, ref sErrMsg))
			{
			//"保存成功！";
			return true;
			}
			else
			{
			//"保存失败！";
			sErrMsg = "单据号：" + oMain.HBillNo + "，单据ID：" + oMain.HInterID + "；" + sErrMsg;
			return false;
			}
			}
			else
			{
			sErrMsg = "单据号：" + oMain.HBillNo + "，单据ID：" + oMain.HInterID + "；错误的源单类型";
			@@ -21669,6 +21944,429 @@
			}
			}


			/// <summary>
			/// 生产退料单（源单：生产领料单）
			/// </summary>
			/// <param name="oMain"></param>
			/// <param name="sErrMsg"></param>
			/// <returns></returns>
			public bool SaveMateOutBackBill_MateOut_CLD(Model.ClsKf_ICStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
			{
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			string sRemark = "";
			//从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码
			if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
			{
			sErrMsg = Pub_Class.ClsPub.sExeReturnInfo;
			return false;
			}

			//获取CLOUD账号密码
			string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
			string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;

			//从用户表获取用户绑定金蝶账号
			DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
			if (ds11 == null \|\| ds11.Tables[0].Rows.Count == 0)
			{
			}
			else
			{
			sCLOUDUseName = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserName"]);
			sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]);
			}

			string HReturn;
			ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
			string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
			bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);

			sRemark = sRemark + " ；获取验证CLOUD账号密码" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			try
			{
			//判断会计期是否合理
			string s = "";
			int sYear = 0;
			int sPeriod = 0;

			if (oSystemParameterMain.Kf_MateOutBackBill_BillDateMode.ToUpper() == "N") //系统参数单据日期是否取界面递入日期
			{
			oMain.HDate = DateTime.Today;
			}

			if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(oMain.HDate, ref sYear, ref sPeriod, ref s) == false)
			{
			sErrMsg = s;
			return false;
			}
			oMain.HYear = sYear;
			oMain.HPeriod = sPeriod;

			oCn.BeginTran();
			//生成出入库单据
			//插入子表
			oCn.RunProc("EXEC h_p_Kf_MateOutBackBillSub_Insert_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + sHSourceType + "'");
			//插入主表
			oCn.RunProc("Insert Into Kf_ICStockBillMain " +
			"(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMainSourceBillType" +
			",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
			",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" +
			",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" +
			",HSTOCKORGID,HOWNERID" +
			") " +
			" values('1244','1244'," + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HDate.ToShortDateString() + "','" + oMain.HMainSourceBillType + "'" +
			", " + oMain.HYear.ToString() + "," + oMain.HPeriod.ToString() + ",'" + oMain.HRemark + "','" + oMain.HMaker + "',getdate()" +
			", " + oMain.HSupID.ToString() + "," + oMain.HWHID.ToString() + "," + oMain.HSCWHID.ToString() + "," + oMain.HEmpID.ToString() + "," + oMain.HManagerID.ToString() + "," + oMain.HSecManagerID.ToString() +
			", " + oMain.HKeeperID.ToString() + "," + oMain.HDeptID.ToString() + ",'" + oMain.HExplanation + "','" + oMain.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(oMain.HRedBlueFlag) +
			", " + oMain.HSTOCKORGID.ToString() + "," + oMain.HOWNERID.ToString() +
			") ");
			//更新关联数量
			oCn.RunProc("exec h_p_Kf_UpDateRelation_MateOutToMateOutBack_Add " + oMain.HInterID.ToString());

			sRemark = sRemark + " ；生成出入库单据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			//根据TMP表返回信息
			DataSet Ds;
			if (oSystemParameterMain.WMS_CloudMode.ToUpper() == "N") //系统参数是否为私有云模式(N为公有云模式，Y为私有云模式)
			{
			Ds = oCn.RunProcReturn("exec h_p_Kf_GetMateOutBackBill_MateOut_PUBCLD_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'", "h_p_Kf_GetMateOutBackBill_MateOut_PUBCLD_New");
			sRemark = sRemark + " ；公有云模式";
			}
			else
			{
			Ds = oCn.RunProcReturn("exec h_p_Kf_GetMateOutBackBill_MateOut_CLD_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'", "h_p_Kf_GetMateOutBackBill_MateOut_CLD_New");
			sRemark = sRemark + " ；私有云模式";
			}
			if (Ds == null \|\| Ds.Tables[0].Rows.Count == 0 \|\| Ds.Tables[1].Rows.Count == 0)
			{
			sErrMsg = "获取子表信息失败！";
			oCn.RollBack();
			return false;
			}
			else
			{
			string sJson_MainCustom = ""; //主表自定义字段
			string sJson_Date = ""; //单据日期
			sJson_MainCustom = Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["MainCustom"]);

			if (oSystemParameterMain.Kf_MateOutBackBill_BillDateMode.ToUpper() == "Y") //系统参数单据日期是否取界面递入日期
			{
			sJson_Date = "\"FDATE\":\"" + oMain.HDate.ToShortDateString() + "\",";
			}
			else
			{
			sJson_Date = "\"FDATE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FDATE"]) + "\",";
			}

			string sJson_Main = "{\"Creator\":\"\",\"NeedUpDateFields\":[],\"NeedReturnFields\":[],\"IsDeleteEntry\":\"True\",\"SubSystemId\":\"\",\"IsVerifyBaseDataField\":\"false\", " +
			"\"IsEntryBatchFill\":\"True\",\"ValidateFlag\":\"True\",\"NumberSearch\":\"True\",\"InterationFlags\":\"\"," +
			"\"Model\": { \"FBILLNO\":\"" + oMain.HBillNo + "\"," +
			//\"FID\":\"0\",
			"\"FBillType\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FBillType"]) + "\"}," +
			sJson_Date +
			"\"FStockOrgId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FStockOrgId"]) + "\"}," +
			"\"FPrdOrgId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FPrdOrgId"]) + "\"}," +
			"\"FOwnerTypeId0\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FOwnerTypeId0"]) + "\"," +
			//\"FOwnerId0\":{\"FNumber\":\"\"},
			"\"FReturnerId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FReturnerId"]) + "\"}," +
			"\"FSTOCKERID\":{\"FNAME\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSTOCKERID"]) + "\"}," +
			//\"FDescription\":\"\",
			"\"FCurrId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FCurrId"]) + "\"}," +
			"\"FIsCrossTrade\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FIsCrossTrade"]) + "\"," +
			"\"FVmiBusiness\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FVmiBusiness"]) + "\"," +
			"\"FIsOwnerTInclOrg\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FIsOwnerTInclOrg"]) + "\"," +
			//\"FScanBox\":\"\",
			//\"FSourceType\":\"\",
			sJson_MainCustom +
			"\"FEntity\": [ ";
			string sJson_Entry = "";
			for (int i = 0; i < Ds.Tables[1].Rows.Count; i++)
			{
			if (sJson_Entry != "")
			{
			sJson_Entry = sJson_Entry + " , ";
			}
			string sJson_BatchNo = "";
			string sJson_StockPlace = "";
			string sJson_FAUXPROPID = "";
			string sJson_FProduceDate = ""; //生产日期
			string sJson_FExpiryDate = ""; //有效期至
			string sJson_SubCustom = ""; //子表自定义字段

			//子表自定义字段
			sJson_SubCustom = Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["SubCustom"]);

			//是否启用批次管理
			if (Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["HISBATCHMANAGE"]) == "1")
			{
			sJson_BatchNo = " \"FLOT\": {\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FLOT"]) + "\"}, \"FLOT_TEXT\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FLOT"]) + "\" , ";
			}
			else
			{
			sJson_BatchNo = "";
			}

			//是否启用保质期控制
			if (Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FISKFPERIOD"]) == "1")
			{
			sJson_FProduceDate = " \"FProduceDate\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FProduceDate"]) + "\",";
			sJson_FExpiryDate = " \"FExpiryDate\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FExpiryDate"]) + "\",";
			}
			else
			{
			sJson_FProduceDate = "";
			sJson_FExpiryDate = "";
			}

			//辅助属性
			sJson_FAUXPROPID = " \"FAUXPROPID\":{\"FAUXPROPID__FF100002\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID"]) + "\"}},";

			//仓位
			if (Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) == "")
			{
			sJson_StockPlace = "";
			}
			else
			{
			sJson_StockPlace = Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) + "\"}},";
			}

			sJson_Entry = sJson_Entry + "{" +
			//\"FEntryID\":\"0\",
			"\"FMaterialId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMaterialId"]) + "\"}," +
			"\"FUnitID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FUnitID"]) + "\"}," +
			"\"FAPPQty\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAPPQty"]) + "\"," +
			"\"FQty\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FQty"]) + "\"," +
			"\"FReturnType\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FReturnType"]) + "\"," +
			//\"FReturnReason\":{\"FNumber\":\"\"},
			"\"FStockId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockId"]) + "\"}," +
			sJson_StockPlace +
			sJson_BatchNo +
			//\"FEntrtyMemo\":\"\",
			"\"FSrcBillType\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSrcBillType"]) + "\"," +
			"\"FSrcBillNo\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSrcBillNo"]) + "\"," +
			"\"FEntrySrcEntrySeq\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntrySrcEntrySeq"]) + "\"," +
			"\"FPPBomBillNo\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPPBomBillNo"]) + "\"," +
			"\"FProcessId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FProcessId"]) + "\"}," +
			"\"FParentMaterialId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FParentMaterialId"]) + "\"}," +
			"\"FPPBOMEntryId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPPBOMEntryId"]) + "\"," +
			"\"FMoId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMoId"]) + "\"," +
			//\"FConsome\":\"\",
			"\"FReserveType\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FReserveType"]) + "\"," +
			"\"FBASESTOCKQTY\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBASESTOCKQTY"]) + "\"," +
			"\"FMoBillNo\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMoBillNo"]) + "\"," +
			"\"FEntryVmiBusiness\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntryVmiBusiness"]) + "\"," +
			"\"FOptQueue\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOptQueue"]) + "\"," +
			"\"FOptPlanBillNo\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOptPlanBillNo"]) + "\"," +
			"\"FOptPlanBillId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOptPlanBillId"]) + "\"," +
			"\"FWorkCenterId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FWorkCenterId"]) + "\"}," +
			"\"FOptDetailId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOptDetailId"]) + "\"," +
			"\"FMoEntryId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMoEntryId"]) + "\"," +
			//\"FEquipmentId\":{\"FNUMBER\":\"\"},
			"\"FMoEntrySeq\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMoEntrySeq"]) + "\"," +
			sJson_FAUXPROPID +
			"\"FStockUnitId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockUnitId"]) + "\"}," +
			"\"FStockAppQty\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockAppQty"]) + "\"," +
			"\"FSecUnitId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSecUnitId"]) + "\"}," +
			//\"FSecStockQty\":\"0\",
			"\"FStockQty\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockQty"]) + "\"," +
			"\"FMtoNo\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMtoNo"]) + "\"," +
			"\"FProjectNo\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FProjectNo"]) + "\"," +
			"\"FStockStatusId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockStatusId"]) + "\"}," +
			"\"FKeeperTypeId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FKeeperTypeId"]) + "\"," +
			"\"FKeeperId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FKeeperId"]) + "\"}," +
			"\"FOperId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOperId"]) + "\"," +
			"\"FBomId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBomId"]) + "\"}," +
			//\"FSelRePickedQty\":\"0\",
			"\"FBaseUnitId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBaseUnitId"]) + "\"}," +
			"\"FBaseAppQty\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBaseAppQty"]) + "\"," +
			//\"FBaseSelRePickedQty\":\"0\",
			"\"FBaseQty\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBaseQty"]) + "\"," +
			"\"FOwnerTypeId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOwnerTypeId"]) + "\"," +
			"\"FOwnerId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOwnerId"]) + "\"}," +
			"\"FEntrySrcEnteryId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntrySrcEnteryId"]) + "\"," +
			"\"FEntrySrcInterId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntrySrcInterId"]) + "\"," +
			sJson_FProduceDate +
			sJson_FExpiryDate +
			"\"FWorkShopId1\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FWorkShopId1"]) + "\"}," +
			"\"FParentOwnerTypeId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FParentOwnerTypeId"]) + "\"," +
			"\"FParentOwnerId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FParentOwnerId"]) + "\"}," +
			"\"FSrcBizBillType\":{\"FNAME\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSrcBizBillType"]) + "\"}," +
			"\"FSrcBizBillNo\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSrcBizBillNo"]) + "\"," +
			"\"FSrcBizInterId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSrcBizInterId"]) + "\"," +
			"\"FSrcBizEntryId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSrcBizEntryId"]) + "\"," +
			"\"FSrcBizEntrySeq\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSrcBizEntrySeq"]) + "\"," +
			//
			"\"FSNUnitID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSNUnitID"]) + "\"}," +
			"\"FReqSrc\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FReqSrc"]) + "\"," +
			"\"FReqBillNo\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FReqBillNo"]) + "\"," +
			"\"FReqBillId\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FReqBillId"]) + "," +
			"\"FReqEntrySeq\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FReqEntrySeq"]) + "," +
			"\"FReqEntryId\":" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FReqEntryId"]) + "," +
			"\"FisFX\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FisFX"]) + "\"," +
			"\"FIsUpdateQty\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FIsUpdateQty"]) + "\"," +
			sJson_SubCustom +

			//\"FSerialSubEntity\":[{\"FDetailID\":\"0\",
			//\"FSerialNo\":\"\",
			//\"FSerialId\":{\"FNumber\":\"\"},
			//\"FSerialNote\":\"\"}]

			"\"FEntity_Link\": [ { " +
			"\"FEntity_Link_FFlowId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntity_Link_FFlowId"]) + "\"," +
			"\"FEntity_Link_FFlowLineId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntity_Link_FFlowLineId"]) + "\"," +
			"\"FEntity_Link_FRuleId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntity_Link_FRuleId"]) + "\"," +
			"\"FEntity_Link_FSTableName\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntity_Link_FSTableName"]) + "\"," +
			"\"FEntity_Link_FSBillId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntity_Link_FSBillId"]) + "\"," +
			"\"FEntity_Link_FBASEQTYOLD\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntity_Link_FBASEQTYOLD"]) + "\"," +
			"\"FEntity_Link_FSId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FEntity_Link_FSId"]) + "\"" +
			" } ]," +
			" \"FBFLowId\":{\"FID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBFLowId"]) + "\"}}";
			}
			string sJson_End = " ] }}";
			string sJson = sJson_Main + sJson_Entry + sJson_End;

			sRemark = sRemark + " ；获取CLOUD单据API递入值" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			//生成金蝶云单据
			if (bLogin)
			{
			var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save",
			new object[] { "PRD_ReturnMtrl", sJson });

			sRemark = sRemark + " ；生成CLOUD单据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			//生成单据后更新自定义字段
			oCn.RunProc("exec h_p_Sc_UpDateSelfFildMateOutBack '" + oMain.HBillNo + "','" + sHSourceType + "'");

			sRemark = sRemark + " ；生成单据后回填字段信息" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			HReturn = result.ToString();

			if (HReturn.Contains("\"IsSuccess\":false") == true)
			{
			//反序列化json数据
			var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn);
			//接收金蝶报错信息
			var strErrorMsg = string.Empty;
			//遍历获取报错信息
			foreach (var item in retModel.Result.ResponseStatus.Errors)
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成生产退料单失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("生成生产退料单（源单：生产领料单）失败！" + HReturn + sJson); //写入txt文本
			oCn.RollBack();
			return false;
			}
			else
			{
			sRemark = sRemark + sJson;
			oCn.Commit();
			}
			}
			else
			{
			sErrMsg = "生成生产退料单失败！金蝶云登录失败！";
			oCn.RollBack();
			return false;
			}
			}
			}
			catch (Exception e)
			{
			LogService.Write("生成回滚" + e.Message + sRemark);
			sErrMsg = "生成生产退料单失败！" + e.Message;
			oCn.RollBack();
			return false;
			}

			if (oSystemParameterMain.Kf_MateOutBackBill_AutoCheck.ToUpper() == "Y") //系统参数自动审核
			{
			//审核WMS单据
			oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + oMain.HMaker + "',HCheckDate=getdate(),HBillStatus=2 where HInterID= " + oMain.HInterID.ToString());

			//提交、审核金蝶云单据
			HReturn = "";
			string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
			var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit",
			new object[] { "PRD_ReturnMtrl", sJson2 });

			sRemark = sRemark + " ；提交CLOUD单据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
			var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit",
			new object[] { "PRD_ReturnMtrl", sJson3 });

			sRemark = sRemark + " ；审核CLOUD单据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			HReturn = result2.ToString() + "," + result3.ToString();

			if (HReturn.Contains("\"IsSuccess\":false") == true)
			{
			//反序列化json数据
			var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(result3);
			//接收金蝶报错信息
			var strErrorMsg = string.Empty;
			//遍历获取报错信息
			foreach (var item in retModel.Result.ResponseStatus.Errors)
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成生产退料单成功，审核单据失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("审核单据失败" + sRemark + HReturn);
			return true;
			}
			else
			{
			LogService.Write("生成并审核生产退料单（源单：生产领料单）成功！" + sRemark);
			sErrMsg = "生成并审核生产退料单成功！单据号为：" + oMain.HBillNo;
			return true;
			}
			}
			else if (oSystemParameterMain.Kf_MateOutBackBill_AutoSubmit.ToUpper() == "Y") //系统参数自动提交
			{
			//提交金蝶云单据
			HReturn = "";
			string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
			var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit",
			new object[] { "PRD_ReturnMtrl", sJson2 });

			sRemark = sRemark + " ；提交CLOUD单据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			HReturn = result2.ToString();

			if (HReturn.Contains("\"IsSuccess\":false") == true)
			{
			//反序列化json数据
			var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn);
			//接收金蝶报错信息
			var strErrorMsg = string.Empty;
			//遍历获取报错信息
			foreach (var item in retModel.Result.ResponseStatus.Errors)
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成生产退料单成功，提交单据失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("提交单据失败" + sRemark + HReturn);
			return true;
			}
			else
			{
			LogService.Write("生成并提交生产退料单（源单：生产领料单）成功！" + sRemark);
			sErrMsg = "生成并提交生产退料单成功！单据号为：" + oMain.HBillNo;
			return true;
			}
			}
			else
			{
			LogService.Write("生成生产退料单（源单：生产领料单）成功！" + sRemark);
			sErrMsg = "生成生产退料单成功！单据号为：" + oMain.HBillNo;
			return true;
			}
			}

			#endregion

			@@ -31048,9 +31746,9 @@

			#endregion

			#region 外购退料外购入库（红字） *
			#region 采购退料采购入库（红字） *

			//生成外购退料单
			//生成采购退料单
			[WebMethod]
			public bool set_SavePOStockInBackBill_New(Model.ClsKf_ICStockBillMain oMain, string sHSourceType, ref string sErrMsg)
			{
			@@ -31123,7 +31821,7 @@
			}
			}

			sErrMsg = "保存外购退料单失败！" + sErrMsg;
			sErrMsg = "保存采购退料单失败！" + sErrMsg;
			return false;
			}

			@@ -31321,9 +32019,9 @@

			#endregion

			#region 外购退料CLOUD 外购入库（红字） *New
			#region 采购退料CLOUD 采购入库（红字） *New

			//生成外购退料单
			//生成采购退料单
			[WebMethod]
			public bool set_SavePOStockInBackBill_CLD_New(Model.ClsKf_ICStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
			{
			@@ -31355,6 +32053,20 @@
			return false;
			}
			}
			else if (sHSourceType == "1201") //采购入库单
			{
			if (SavePOStockInBackBill_POStockIn_CLD_New(oMain, sHSourceType, oSystemParameterMain, ref sErrMsg))
			{
			//"保存成功！";
			return true;
			}
			else
			{
			//"保存失败！";
			sErrMsg = "单据号：" + oMain.HBillNo + "，单据ID：" + oMain.HInterID + "；" + sErrMsg;
			return false;
			}
			}
			else
			{
			sErrMsg = "单据号：" + oMain.HBillNo + "，单据ID：" + oMain.HInterID + "；错误的源单类型";
			@@ -31363,7 +32075,7 @@
			}

			/// <summary>
			/// 外购退料单（源单：采购订单）
			/// 采购退料单（源单：采购订单）
			/// </summary>
			/// <param name="oMain"></param>
			/// <param name="sErrMsg"></param>
			@@ -31719,8 +32431,8 @@
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成外购退料单失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("生成外购退料单（源单：采购订单）失败！" + HReturn + sJson); //写入txt文本
			sErrMsg = "生成采购退料单失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("生成采购退料单（源单：采购订单）失败！" + HReturn + sJson); //写入txt文本
			oCn.RollBack();
			return false;
			}
			@@ -31732,7 +32444,7 @@
			}
			else
			{
			sErrMsg = "生成外购退料单失败！金蝶云登录失败！";
			sErrMsg = "生成采购退料单失败！金蝶云登录失败！";
			oCn.RollBack();
			return false;
			}
			@@ -31741,7 +32453,7 @@
			catch (Exception e)
			{
			LogService.Write("生成回滚" + e.Message + sRemark);
			sErrMsg = "生成外购退料单失败！" + e.Message;
			sErrMsg = "生成采购退料单失败！" + e.Message;
			oCn.RollBack();
			return false;
			}
			@@ -31781,15 +32493,15 @@
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成外购退料单成功，审核单据失败！金蝶云提示：" + strErrorMsg;
			sErrMsg = "生成采购退料单成功，审核单据失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("审核单据失败" + sRemark + HReturn);
			oCn.RollBack();
			return true;
			}
			else
			{
			LogService.Write("生成并审核外购退料单（源单：采购订单）成功！" + sRemark);
			sErrMsg = "生成并审核外购退料单成功！单据号为：" + oMain.HBillNo;
			LogService.Write("生成并审核采购退料单（源单：采购订单）成功！" + sRemark);
			sErrMsg = "生成并审核采购退料单成功！单据号为：" + oMain.HBillNo;
			oCn.Commit();
			return true;
			}
			@@ -31797,7 +32509,7 @@
			catch (Exception e)
			{
			LogService.Write("审核回滚" + sRemark + HReturn);
			sErrMsg = "审核外购退料单失败！" + e.Message;
			sErrMsg = "审核采购退料单失败！" + e.Message;
			oCn.RollBack();
			return false;
			}
			@@ -31828,15 +32540,15 @@
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成外购退料单成功，提交单据失败！金蝶云提示：" + strErrorMsg;
			sErrMsg = "生成采购退料单成功，提交单据失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("提交单据失败" + sRemark + HReturn);
			oCn.RollBack();
			return true;
			}
			else
			{
			LogService.Write("生成并提交外购退料单（源单：采购订单）成功！" + sRemark);
			sErrMsg = "生成并提交外购退料单成功！单据号为：" + oMain.HBillNo;
			LogService.Write("生成并提交采购退料单（源单：采购订单）成功！" + sRemark);
			sErrMsg = "生成并提交采购退料单成功！单据号为：" + oMain.HBillNo;
			oCn.Commit();
			return true;
			}
			@@ -31844,22 +32556,22 @@
			catch (Exception e)
			{
			LogService.Write("提交回滚" + sRemark + HReturn);
			sErrMsg = "提交外购退料单失败！" + e.Message;
			sErrMsg = "提交采购退料单失败！" + e.Message;
			oCn.RollBack();
			return false;
			}
			}
			else
			{
			LogService.Write("生成外购退料单（源单：采购订单）成功！" + sRemark);
			sErrMsg = "生成外购退料单成功！单据号为：" + oMain.HBillNo;
			LogService.Write("生成采购退料单（源单：采购订单）成功！" + sRemark);
			sErrMsg = "生成采购退料单成功！单据号为：" + oMain.HBillNo;
			return true;
			}
			}


			/// <summary>
			/// 外购退料单（源单：退料通知单）
			/// 采购退料单（源单：退料通知单）
			/// </summary>
			/// <param name="oMain"></param>
			/// <param name="sErrMsg"></param>
			@@ -32068,7 +32780,7 @@
			}

			//辅助属性
			if (oSystemParameterMain.WMS_CampanyName == "凯贝奈特") //系统参数客户定制化名称空白为通用
			if (oSystemParameterMain.WMS_CampanyName == "凯贝奈特" \|\| oSystemParameterMain.WMS_CampanyName == "兴达") //系统参数客户定制化名称空白为通用
			{
			sJson_FAUXPROPID = " \"FAUXPROPID\":{\"FAUXPROPID__FF100001\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID"]) + "\"}},";
			}
			@@ -32203,8 +32915,8 @@
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成外购退料单失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("生成外购退料单（源单：退料通知单）失败！" + HReturn + sJson); //写入txt文本
			sErrMsg = "生成采购退料单失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("生成采购退料单（源单：退料通知单）失败！" + HReturn + sJson); //写入txt文本
			oCn.RollBack();
			return false;
			}
			@@ -32216,7 +32928,7 @@
			}
			else
			{
			sErrMsg = "生成外购退料单失败！金蝶云登录失败！";
			sErrMsg = "生成采购退料单失败！金蝶云登录失败！";
			oCn.RollBack();
			return false;
			}
			@@ -32225,7 +32937,7 @@
			catch (Exception e)
			{
			LogService.Write("生成回滚" + e.Message + sRemark);
			sErrMsg = "生成外购退料单失败！" + e.Message;
			sErrMsg = "生成采购退料单失败！" + e.Message;
			oCn.RollBack();
			return false;
			}
			@@ -32265,15 +32977,15 @@
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成外购退料单成功，审核单据失败！金蝶云提示：" + strErrorMsg;
			sErrMsg = "生成采购退料单成功，审核单据失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("审核单据失败" + sRemark + HReturn);
			oCn.RollBack();
			return true;
			}
			else
			{
			LogService.Write("生成并审核外购退料单（源单：退料通知单）成功！" + sRemark);
			sErrMsg = "生成并审核外购退料单成功！单据号为：" + oMain.HBillNo;
			LogService.Write("生成并审核采购退料单（源单：退料通知单）成功！" + sRemark);
			sErrMsg = "生成并审核采购退料单成功！单据号为：" + oMain.HBillNo;
			oCn.Commit();
			return true;
			}
			@@ -32281,7 +32993,7 @@
			catch (Exception e)
			{
			LogService.Write("审核回滚" + sRemark + HReturn);
			sErrMsg = "审核外购退料单失败！" + e.Message;
			sErrMsg = "审核采购退料单失败！" + e.Message;
			oCn.RollBack();
			return false;
			}
			@@ -32312,15 +33024,15 @@
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成外购退料单成功，提交单据失败！金蝶云提示：" + strErrorMsg;
			sErrMsg = "生成采购退料单成功，提交单据失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("提交单据失败" + sRemark + HReturn);
			oCn.RollBack();
			return true;
			}
			else
			{
			LogService.Write("生成并提交外购退料单（源单：退料通知单）成功！" + sRemark);
			sErrMsg = "生成并提交外购退料单成功！单据号为：" + oMain.HBillNo;
			LogService.Write("生成并提交采购退料单（源单：退料通知单）成功！" + sRemark);
			sErrMsg = "生成并提交采购退料单成功！单据号为：" + oMain.HBillNo;
			oCn.Commit();
			return true;
			}
			@@ -32328,15 +33040,481 @@
			catch (Exception e)
			{
			LogService.Write("提交回滚" + sRemark + HReturn);
			sErrMsg = "提交外购退料单失败！" + e.Message;
			sErrMsg = "提交采购退料单失败！" + e.Message;
			oCn.RollBack();
			return false;
			}
			}
			else
			{
			LogService.Write("生成外购退料单（源单：退料通知单）成功！" + sRemark);
			sErrMsg = "生成外购退料单成功！单据号为：" + oMain.HBillNo;
			LogService.Write("生成采购退料单（源单：退料通知单）成功！" + sRemark);
			sErrMsg = "生成采购退料单成功！单据号为：" + oMain.HBillNo;
			return true;
			}
			}


			/// <summary>
			/// 采购退料单（源单：采购入库单）
			/// </summary>
			/// <param name="oMain"></param>
			/// <param name="sErrMsg"></param>
			/// <returns></returns>
			public bool SavePOStockInBackBill_POStockIn_CLD_New(Model.ClsKf_ICStockBillMain oMain, string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain, ref string sErrMsg)
			{
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			string sRemark = "";
			//从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码
			if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
			{
			sErrMsg = Pub_Class.ClsPub.sExeReturnInfo;
			return false;
			}

			//获取CLOUD账号密码
			string sCLOUDUseName = Pub_Class.ClsPub.sCLOUDUseName;
			string sCLOUDPsd = Pub_Class.ClsPub.sCLOUDPsd;

			//从用户表获取用户绑定金蝶账号
			DataSet ds11 = oCn.RunProcReturn("exec h_p_API_GetCloudUserByLoginUser '" + oMain.HMaker + "'", "h_p_API_GetCloudUserByLoginUser");
			if (ds11 == null \|\| ds11.Tables[0].Rows.Count == 0)
			{
			}
			else
			{
			sCLOUDUseName = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserName"]);
			sCLOUDPsd = DBUtility.ClsPub.isStrNull(ds11.Tables[0].Rows[0]["HCloudUserPsd"]);
			}

			string HReturn;
			ApiClient client = new ApiClient(Pub_Class.ClsPub.sCLOUDUrl);
			string dbId = Pub_Class.ClsPub.sCLOUDAcc; //AotuTest117
			bool bLogin = client.Login(dbId, sCLOUDUseName, sCLOUDPsd, 2052);

			sRemark = sRemark + " ；获取验证CLOUD账号密码" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			try
			{
			//判断会计期是否合理
			string s = "";
			int sYear = 0;
			int sPeriod = 0;

			if (oSystemParameterMain.Kf_POStockInBackBill_BillDateMode.ToUpper() == "N") //系统参数单据日期是否取界面递入日期
			{
			oMain.HDate = DateTime.Today;
			}

			if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(oMain.HDate, ref sYear, ref sPeriod, ref s) == false)
			{
			sErrMsg = s;
			return false;
			}
			oMain.HYear = sYear;
			oMain.HPeriod = sPeriod;

			oCn.BeginTran();
			//生成出入库单据
			//插入子表
			oCn.RunProc("EXEC h_p_Kf_POStockInBackBillSub_Insert_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + sHSourceType + "'");
			//插入主表
			oCn.RunProc("Insert Into Kf_ICStockBillMain " +
			"(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMainSourceBillType" +
			",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
			",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" +
			",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" +
			",HSTOCKORGID,HOWNERID" +
			") " +
			" values('1239','1239'," + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "','" + oMain.HDate.ToShortDateString() + "','" + oMain.HMainSourceBillType + "'" +
			", " + oMain.HYear.ToString() + "," + oMain.HPeriod.ToString() + ",'" + oMain.HRemark + "','" + oMain.HMaker + "',getdate()" +
			", " + oMain.HSupID.ToString() + "," + oMain.HWHID.ToString() + "," + oMain.HSCWHID.ToString() + "," + oMain.HEmpID.ToString() + "," + oMain.HManagerID.ToString() + "," + oMain.HSecManagerID.ToString() +
			", " + oMain.HKeeperID.ToString() + "," + oMain.HDeptID.ToString() + ",'" + oMain.HExplanation + "','" + oMain.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(oMain.HRedBlueFlag) +
			", " + oMain.HSTOCKORGID.ToString() + "," + oMain.HOWNERID.ToString() +
			") ");
			//更新关联数量
			oCn.RunProc("exec h_p_Kf_UpDateRelation_POStockInToPOStockInBack_Add " + oMain.HInterID.ToString());

			sRemark = sRemark + " ；生成出入库单据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			//根据TMP表返回信息
			DataSet Ds;
			if (oSystemParameterMain.WMS_CloudMode.ToUpper() == "N") //系统参数是否为私有云模式(N为公有云模式，Y为私有云模式)
			{
			Ds = oCn.RunProcReturn("exec h_p_Kf_GetPOStockInBackBill_POStockIn_PUBCLD_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'", "h_p_Kf_GetPOStockInBackBill_POStockIn_PUBCLD_New");
			sRemark = sRemark + " ；公有云模式";
			}
			else
			{
			Ds = oCn.RunProcReturn("exec h_p_Kf_GetPOStockInBackBill_POStockIn_CLD_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillNo + "'", "h_p_Kf_GetPOStockInBackBill_POStockIn_CLD_New");
			sRemark = sRemark + " ；私有云模式";
			}
			if (Ds == null \|\| Ds.Tables[0].Rows.Count == 0 \|\| Ds.Tables[1].Rows.Count == 0)
			{
			sErrMsg = "获取子表信息失败！";
			oCn.RollBack();
			return false;
			}
			else
			{
			string sJson_MainCustom = ""; //主表自定义字段
			string sJson_Date = ""; //单据日期
			sJson_MainCustom = Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["MainCustom"]);

			if (oSystemParameterMain.Kf_POStockInBackBill_BillDateMode.ToUpper() == "Y") //系统参数单据日期是否取界面递入日期
			{
			sJson_Date = "\"FDATE\":\"" + oMain.HDate.ToShortDateString() + "\",";
			}
			else
			{
			sJson_Date = "\"FDATE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FDATE"]) + "\",";
			}

			string sJson_Main = "{\"Creator\":\"\",\"NeedUpDateFields\":[],\"NeedReturnFields\":[],\"IsDeleteEntry\":\"True\",\"SubSystemId\":\"\",\"IsVerifyBaseDataField\":\"false\", " +
			"\"IsEntryBatchFill\":\"True\",\"ValidateFlag\":\"True\",\"NumberSearch\":\"True\",\"InterationFlags\":\"\"," +
			"\"Model\": { \"FBILLNO\":\"" + oMain.HBillNo + "\"," +
			//\"FID\":\"0\",
			"\"FBillTypeID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FBillTypeID"]) + "\"}," +
			//\"FBillNo\":\"\",
			sJson_Date +
			"\"FMRTYPE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FMRTYPE"]) + "\"," +
			"\"FMRMODE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FMRMODE"]) + "\"," +
			"\"FStockOrgId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FStockOrgId"]) + "\"}," +
			"\"FMRDeptId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FMRDeptId"]) + "\"}," +
			"\"FSTOCKERGROUPID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSTOCKERGROUPID"]) + "\"}," +
			"\"FCorrespondOrgId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FCorrespondOrgId"]) + "\"}," +
			"\"FSTOCKERID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSTOCKERID"]) + "\"}," +
			//"\"FMRREASON\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FMRREASON"]) + "\"}," +
			"\"FRequireOrgId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FRequireOrgId"]) + "\"}," +
			"\"FPurchaseOrgId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FPurchaseOrgId"]) + "\"}," +
			"\"FPURCHASEDEPTID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FPURCHASEDEPTID"]) + "\"}," +
			"\"FPURCHASERGROUPID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FPURCHASERGROUPID"]) + "\"}," +
			"\"FPURCHASERID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FPURCHASERID"]) + "\"}," +
			"\"FSupplierID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSupplierID"]) + "\"}," +
			//\"FDESCRIPTION\":\"\",
			"\"FACCEPTORID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FACCEPTORID"]) + "\"}," +
			"\"FAcceptAddress\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FAcceptAddress"]) + "\"," +
			"\"FSettleId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSettleId"]) + "\"}," +
			"\"FCHARGEID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FCHARGEID"]) + "\"}," +
			"\"FOwnerTypeIdHead\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FOwnerTypeIdHead"]) + "\"," +
			"\"FOwnerIdHead\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FOwnerIdHead"]) + "\"}," +
			//\"FScanPoint\":{\"FNUMBER\":\"\"},
			//\"FConfirmerId\":{\"FUserID\":\"\"},
			//\"FConfirmDate\":\"1900-01-01\",
			//\"FScanBox\":\"\",
			//\"FCDateOffsetUnit\":\"\",
			//\"FCDateOffsetValue\":\"0\",
			"\"FAcceptorContactID\":{\"FCONTACTNUMBER\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FAcceptorContactID"]) + "\"}," +
			//
			"\"FREPLENISHMODE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FREPLENISHMODE"]) + "\"," +
			"\"FBusinessType\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FBusinessType"]) + "\"," +
			sJson_MainCustom +

			"\"FPURMRBFIN\":{" +
			//\"FEntryId\":\"0\",
			"\"FSettleOrgId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSettleOrgId"]) + "\"}," +
			"\"FSETTLETYPEID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSETTLETYPEID"]) + "\"}," +
			"\"FSettleCurrId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FSettleCurrId"]) + "\"}," +
			"\"FPAYCONDITIONID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FPAYCONDITIONID"]) + "\"}," +
			"\"FIsIncludedTax\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FIsIncludedTax"]) + "\"," +
			"\"FPriceTimePoint\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FPriceTimePoint"]) + "\"," +
			//\"FPRICELISTID\":{\"FNumber\":\"\"},
			"\"FDISCOUNTLISTID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FDISCOUNTLISTID"]) + "\"}," +
			"\"FLOCALCURRID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FLOCALCURRID"]) + "\"}," +
			"\"FEXCHANGETYPEID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FEXCHANGETYPEID"]) + "\"}," +
			"\"FEXCHANGERATE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FEXCHANGERATE"]) + "\"," +
			"\"FPAYORGID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FPAYORGID"]) + "\"}," +
			"\"FISPRICEEXCLUDETAX\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["FISPRICEEXCLUDETAX"]) + "\"}," +
			"\"FPURMRBENTRY\": [ ";
			string sJson_Entry = "";
			for (int i = 0; i < Ds.Tables[1].Rows.Count; i++)
			{
			if (sJson_Entry != "")
			{
			sJson_Entry = sJson_Entry + " , ";
			}
			string sJson_BatchNo = "";
			string sJson_StockPlace = "";
			string sJson_FProduceDate = ""; //生产日期
			string sJson_FExpiryDate = ""; //有效期至
			string sJson_FAUXPROPID = "";
			string sJson_SubCustom = ""; //子表自定义字段

			//子表自定义字段
			sJson_SubCustom = Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["SubCustom"]);

			//是否启用批次管理
			if (Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["HISBATCHMANAGE"]) == "1")
			{
			sJson_BatchNo = " \"FLOT\": {\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FLOT"]) + "\"}, \"FLOT_TEXT\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FLOT"]) + "\" , ";
			}
			else
			{
			sJson_BatchNo = "";
			}

			//是否启用保质期控制
			if (Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FISKFPERIOD"]) == "1")
			{
			sJson_FProduceDate = " \"FProduceDate\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FProduceDate"]) + "\",";
			sJson_FExpiryDate = " \"FExpiryDate\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FExpiryDate"]) + "\",";
			}
			else
			{
			sJson_FProduceDate = "";
			sJson_FExpiryDate = "";
			}

			//辅助属性
			sJson_FAUXPROPID = " \"FAUXPROPID\":{\"FAUXPROPID__FF100002\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID"]) + "\"}},";

			//仓位
			if (Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) == "")
			{
			sJson_StockPlace = "";
			}
			else
			{
			sJson_StockPlace = Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockLocId"]) + "\"}},";
			}

			sJson_Entry = sJson_Entry + "{" +
			//\"FEntryID\":\"0\",
			"\"FRowType\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FRowType"]) + "\"," +
			"\"FMATERIALID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMATERIALID"]) + "\"}," +
			"\"FMaterialDesc\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMaterialDesc"]) + "\"," +
			"\"FParentMatId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FParentMatId"]) + "\"}," +
			"\"FProjectNo\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FProjectNo"]) + "\"," +
			"\"FUnitID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FUnitID"]) + "\"}," +
			"\"FRMREALQTY\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FRMREALQTY"]) + "\"," +
			"\"FREPLENISHQTY\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FREPLENISHQTY"]) + "\"," +
			"\"FKEAPAMTQTY\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FKEAPAMTQTY"]) + "\"," +
			"\"FPRICEUNITID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPRICEUNITID"]) + "\"}," +
			"\"FSTOCKID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSTOCKID"]) + "\"}," +
			sJson_StockPlace +
			"\"FStockStatusId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FStockStatusId"]) + "\"}," +
			"\"FNOTE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FNOTE"]) + "\"," +
			"\"FTaxCombination\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FTaxCombination"]) + "\"}," +
			"\"FPrice\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPrice"]) + "\"," +
			"\"FBaseUnitPrice\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBaseUnitPrice"]) + "\"," +
			"\"FExtAuxUnitId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FExtAuxUnitId"]) + "\"}," +
			//\"FExtAuxUnitQty\":\"0\",
			"\"FREQTRACENO\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FREQTRACENO"]) + "\"," +
			"\"FIsReceiveUpdateStock\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FIsReceiveUpdateStock"]) + "\"," +
			//\"FInvoicedJoinQty\":\"0\",
			"\"FGiveAway\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FGiveAway"]) + "\"," +
			"\"FPriceBaseQty\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPriceBaseQty"]) + "\"," +
			//\"FSetPriceUnitID\":{\"FNumber\":\"\"},
			"\"FCarryUnitId\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FCarryUnitId"]) + "\"}," +
			"\"FSysPrice\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSysPrice"]) + "\"," +
			"\"FCarryQty\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FCarryQty"]) + "\"," +
			"\"FCarryBaseQty\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FCarryBaseQty"]) + "\"," +
			"\"FPOORDERENTRYID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPOORDERENTRYID"]) + "\"," +
			"\"FBILLINGCLOSE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBILLINGCLOSE"]) + "\"," +
			"\"FPriceListEntry\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPriceListEntry"]) + "\"}," +
			sJson_FAUXPROPID +
			//\"FRMMUSTQTY\":\"0\",
			"\"FBOMID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBOMID"]) + "\"}," +
			"\"FSupplierLot\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSupplierLot"]) + "\"," +
			sJson_BatchNo +
			sJson_FProduceDate +
			sJson_FExpiryDate +
			//\"FAUXUNITQTY\":\"0\",
			"\"FENTRYTAXRATE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FENTRYTAXRATE"]) + "\"," +
			"\"FDISCOUNTRATE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FDISCOUNTRATE"]) + "\"," +
			"\"FTAXPRICE\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FTAXPRICE"]) + "\"," +
			"\"FIsStock\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FIsStock"]) + "\"," +
			//\"FChargeProjectID\":{\"FNumber\":\"\"},
			"\"FMtoNo\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FMtoNo"]) + "\"," +
			//
			//"\"FCONTRACTNO\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FCONTRACTNO"]) + "\"," +
			"\"FORDERNO\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FORDERNO"]) + "\"," +
			"\"FPRICECOEFFICIENT\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPRICECOEFFICIENT"]) + "\"," +
			"\"FOWNERTYPEID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOWNERTYPEID"]) + "\"," +
			"\"FOWNERID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FOWNERID"]) + "\"}," +
			"\"FKeeperTypeId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FKeeperTypeId"]) + "\"," +
			"\"FKEEPERID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FKEEPERID"]) + "\"}," +
			"\"FAUXUNITID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXUNITID"]) + "\"}," +
			"\"FBASEUNITID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBASEUNITID"]) + "\"}," +
			"\"FSNUNITID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSNUNITID"]) + "\"}," +
			"\"FPRILSTENTRYID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPRILSTENTRYID"]) + "\"," +
			"\"FSRCBIZUNITID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSRCBIZUNITID"]) + "\"}," +
			"\"FSRCBILLTYPEID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSRCBILLTYPEID"]) + "\"," +
			"\"FSRCBILLNO\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSRCBILLNO"]) + "\"," +
			"\"FSrcSeq\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSrcSeq"]) + "\"," +
			"\"FPURBASENUM\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPURBASENUM"]) + "\"," +
			"\"FSTOCKBASEDEN\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSTOCKBASEDEN"]) + "\"," +
			"\"FCostPrice\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FCostPrice"]) + "\"," +
			sJson_SubCustom +

			//\"FEntryPruCost\":[{\"FDetailID\":\"0\"}],

			"\"FTaxDetailSubEntity\":[{" +
			//\"FDetailID\":\"0\",
			"\"FTAXRATEID\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FTAXRATEID"]) + "\"}," +
			"\"FTaxRate\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FTaxRate"]) + "\"," +
			"\"FTAXAMOUNT\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FTAXAMOUNT"]) + "\"," +
			"\"FCOSTPERCENT\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FCOSTPERCENT"]) + "\"," +
			"\"FTaxCostAmount\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FTaxCostAmount"]) + "\"," +
			"\"FVAT\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FVAT"]) + "\"," +
			"\"FSellerWithholding\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FSellerWithholding"]) + "\"," +
			"\"FBuyerWithholding\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBuyerWithholding"]) + "\"" +
			" } ]," +

			//\"FSerialSubEntity\":[{\"FDetailID\":\"0\",
			//\"FSerialNo\":\"\",
			//\"FSerialNote\":\"\"}]

			"\"FPURMRBENTRY_Link\": [ { " +
			"\"FPURMRBENTRY_Link_FFlowId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPURMRBENTRY_Link_FFlowId"]) + "\"," +
			"\"FPURMRBENTRY_Link_FFlowLineId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPURMRBENTRY_Link_FFlowLineId"]) + "\"," +
			"\"FPURMRBENTRY_Link_FRuleId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPURMRBENTRY_Link_FRuleId"]) + "\"," +
			"\"FPURMRBENTRY_Link_FSTableName\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPURMRBENTRY_Link_FSTableName"]) + "\"," +
			"\"FPURMRBENTRY_Link_FSBillId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPURMRBENTRY_Link_FSBillId"]) + "\"," +
			"\"FPURMRBENTRY_Link_FBASEUNITQTYOLD\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPURMRBENTRY_Link_FBASEUNITQTYOLD"]) + "\"," +
			"\"FPURMRBENTRY_Link_FCARRYBASEQTYOLD\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPURMRBENTRY_Link_FCARRYBASEQTYOLD"]) + "\"," +
			"\"FPURMRBENTRY_Link_FSId\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FPURMRBENTRY_Link_FSId"]) + "\"" +
			" } ]," +
			" \"FBFLowId\":{\"FID\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FBFLowId"]) + "\"}}";
			}
			string sJson_End = " ] }}";
			string sJson = sJson_Main + sJson_Entry + sJson_End;

			sRemark = sRemark + " ；获取CLOUD单据API递入值" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			//生成金蝶云单据
			if (bLogin)
			{
			var result = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save",
			new object[] { "PUR_MRB", sJson });

			sRemark = sRemark + " ；生成CLOUD单据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			//生成单据后更新自定义字段
			oCn.RunProc("exec h_p_Sc_UpDateSelfFildPOStockInBack '" + oMain.HBillNo + "','" + sHSourceType + "'");

			sRemark = sRemark + " ；生成单据后回填字段信息" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			HReturn = result.ToString();

			if (HReturn.Contains("\"IsSuccess\":false") == true)
			{
			//反序列化json数据
			var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn);
			//接收金蝶报错信息
			var strErrorMsg = string.Empty;
			//遍历获取报错信息
			foreach (var item in retModel.Result.ResponseStatus.Errors)
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成采购退料单失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("生成采购退料单（源单：采购入库单）失败！" + HReturn + sJson); //写入txt文本
			oCn.RollBack();
			return false;
			}
			else
			{
			sRemark = sRemark + sJson;
			oCn.Commit();
			}
			}
			else
			{
			sErrMsg = "生成采购退料单失败！金蝶云登录失败！";
			oCn.RollBack();
			return false;
			}
			}
			}
			catch (Exception e)
			{
			LogService.Write("生成回滚" + e.Message + sRemark);
			sErrMsg = "生成采购退料单失败！" + e.Message;
			oCn.RollBack();
			return false;
			}

			if (oSystemParameterMain.Kf_POStockInBackBill_AutoCheck.ToUpper() == "Y") //系统参数自动审核
			{
			//审核WMS单据
			oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + oMain.HMaker + "',HCheckDate=getdate(),HBillStatus=2 where HInterID= " + oMain.HInterID.ToString());

			//提交、审核金蝶云单据
			HReturn = "";
			string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
			var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit",
			new object[] { "PUR_MRB", sJson2 });

			sRemark = sRemark + " ；提交CLOUD单据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			string sJson3 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
			var result3 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit",
			new object[] { "PUR_MRB", sJson3 });

			sRemark = sRemark + " ；审核CLOUD单据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			HReturn = result2.ToString() + "," + result3.ToString();

			if (HReturn.Contains("\"IsSuccess\":false") == true)
			{
			//反序列化json数据
			var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(result3);
			//接收金蝶报错信息
			var strErrorMsg = string.Empty;
			//遍历获取报错信息
			foreach (var item in retModel.Result.ResponseStatus.Errors)
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成采购退料单成功，审核单据失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("审核单据失败" + sRemark + HReturn);
			return true;
			}
			else
			{
			LogService.Write("生成并审核采购退料单（源单：采购入库单）成功！" + sRemark);
			sErrMsg = "生成并审核采购退料单成功！单据号为：" + oMain.HBillNo;
			return true;
			}
			}
			else if (oSystemParameterMain.Kf_POStockInBackBill_AutoSubmit.ToUpper() == "Y") //系统参数自动提交
			{
			//提交金蝶云单据
			HReturn = "";
			string sJson2 = "{\"CreateOrgId\":0,\"Numbers\":[\"" + oMain.HBillNo + "\"]}";
			var result2 = client.Execute<string>("Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit",
			new object[] { "PUR_MRB", sJson2 });

			sRemark = sRemark + " ；提交CLOUD单据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");

			HReturn = result2.ToString();

			if (HReturn.Contains("\"IsSuccess\":false") == true)
			{
			//反序列化json数据
			var retModel = JsonConvert.DeserializeObject<KingdeeResponse>(HReturn);
			//接收金蝶报错信息
			var strErrorMsg = string.Empty;
			//遍历获取报错信息
			foreach (var item in retModel.Result.ResponseStatus.Errors)
			{
			strErrorMsg += item.Message + "\r\n";
			};
			sErrMsg = "生成采购退料单成功，提交单据失败！金蝶云提示：" + strErrorMsg;
			LogService.Write("提交单据失败" + sRemark + HReturn);
			return true;
			}
			else
			{
			LogService.Write("生成并提交采购退料单（源单：采购入库单）成功！" + sRemark);
			sErrMsg = "生成并提交采购退料单成功！单据号为：" + oMain.HBillNo;
			return true;
			}
			}
			else
			{
			LogService.Write("生成采购退料单（源单：采购入库单）成功！" + sRemark);
			sErrMsg = "生成采购退料单成功！单据号为：" + oMain.HBillNo;
			return true;
			}
			}
			@@ -33611,7 +34789,7 @@
			}

			//辅助属性
			if (oSystemParameterMain.WMS_CampanyName == "凯贝奈特") //系统参数客户定制化名称空白为通用
			if (oSystemParameterMain.WMS_CampanyName == "凯贝奈特" \|\| oSystemParameterMain.WMS_CampanyName == "兴达") //系统参数客户定制化名称空白为通用
			{
			sJson_FAUXPROPID = " \"FAUXPROPID\":{\"FAUXPROPID__FF100001\":{\"FNumber\":\"" + Pub_Class.ClsPub.isStrNull(Ds.Tables[1].Rows[i]["FAUXPROPID"]) + "\"}},";
			}
			@@ -54847,6 +56025,7 @@
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			Model.ClsKf_ICStockBill_WMS oBar = new Model.ClsKf_ICStockBill_WMS();
			Int64 sMulSourceFlag = 0; //多源单标志（0为非多源单模式，1为多源单模式）
			Int64 sHSourceFlag = 1; //是否重新同步源单信息（1为同步，0为不同步）

			//获取系统参数
			Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
			@@ -54859,6 +56038,35 @@
			if (oSystemParameter.omodel.Kf_MateOutBackBill_MulSourceBill.ToUpper() == "Y") //系统参数生产退料单-多源单模式
			{
			sMulSourceFlag = 1;

			//判断源单是否已存在缓存列表中
			DataSet dsSource = oCn.RunProcReturn(" select 1 from KF_PonderationBillMain_Temp with(nolock) where HInterID= " + HInterID.ToString() + " and HBillType= '" + HBillType + "' and HSourceBillNo= '" + HSourceBillNo + "' and HQtyMust<>0 ", "KF_PonderationBillMain_Temp");
			if (dsSource == null \|\| dsSource.Tables[0].Rows.Count == 0)
			{
			sHSourceFlag = 1;
			}
			else
			{
			sHSourceFlag = 0;
			}
			}

			//重新同步源单信息
			if (sHSourceFlag == 1)
			{
			if (oSystemParameter.omodel.WMS_CloudMode.ToUpper() == "N") //系统参数是否为私有云模式(N为公有云模式，Y为私有云模式)
			{
			if(HSourceBillType== "1204")
			{
			//生产领料单
			GetWebAPIToLocal_MateOut(HSourceBillNo, HSourceBillType, HMaker, ref sErrMsg);
			}
			}
			else
			{
			//私有云模式
			oCn.RunProc("exec h_p_WMS_ERPSourceBillToLocal '" + HSourceBillNo + "','" + HSourceBillType + "'");
			}
			}

			//将源单信息存入条码出入库临时表
			@@ -57672,6 +58880,32 @@
			return oBar;
			}
			}
			else if (HBillType == "1239")
			{
			//采购退料单
			oBar = get_SourceBarCode_POStockInBack(HInterID, HBillNo, HBillType, HSourceBillNo, HSourceBillType, HMaker, HStockOrgID, ref sErrMsg);
			if (oBar == null)
			{
			return null;
			}
			else
			{
			return oBar;
			}
			}
			else if (HBillType == "1244")
			{
			//生产退料单
			oBar = get_SourceBarCode_MateOutBack(HInterID, HBillNo, HBillType, HSourceBillNo, HSourceBillType, HMaker, HStockOrgID, ref sErrMsg);
			if (oBar == null)
			{
			return null;
			}
			else
			{
			return oBar;
			}
			}
			else
			{
			sErrMsg = "单据类型错误！";