生产退料扫描源单调用方法修改，增加通过WEBAPI同步金蝶云生产领料单至本地数据库功能

yxj

2025-09-30 4155a946a0993ed14aa9f1953378c45b0772d3b7

生产退料扫描源单调用方法修改，增加通过WEBAPI同步金蝶云生产领料单至本地数据库功能

 CLOUDWEB/WebService1.asmx.cs

@@ -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  基础资料

@@ -55749,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();
@@ -55761,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 + "'");
                }
            }

            //将源单信息存入条码出入库临时表