通过WEBAPI同步发货通知单方法，增加根据客户小卫同步自定义字段至本地表；全部通过WEBAPI同步金蝶云单据方法中增加根据单据号删除本地单据

yxj

2025-11-06 3b4d225f87ee286e3b11b47581383fae8c689307

通过WEBAPI同步发货通知单方法，增加根据客户小卫同步自定义字段至本地表；全部通过WEBAPI同步金蝶云单据方法中增加根据单据号删除本地单据

 CLOUDWEB/WebService1.asmx.cs

@@ -79,6 +79,8 @@
                        strErrorMsg += item.Message + "\r\n";
                    };
                    sErrMsg = "同步单据失败！" + strErrorMsg;
                    //根据单据号，删除本地数据
                    oCn.RunProc("Delete from Sc_ICMOBillMain where HBillNo='" + HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    return false;
                }
                else
@@ -135,7 +137,8 @@
                        HISREWORK = _saveObj.SelectToken("Result.Result.IsRework")?.ToString().ToUpper() == "TRUE" ? 1 : 0,
                    };

                    //根据单据ID，删除本地数据
                    //根据单据号、单据ID，删除本地数据
                    oCn.RunProc("Delete from Sc_ICMOBillMain where HBillNo='" + MainData.HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from Sc_ICMOBillMain where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from Sc_ICMOBillSub where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);

@@ -328,6 +331,8 @@
                        strErrorMsg += item.Message + "\r\n";
                    };
                    sErrMsg = "同步单据失败！" + strErrorMsg;
                    //根据单据号，删除本地数据
                    oCn.RunProc("Delete from Cg_POOrderBillMain where HBillNo='" + HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    return false;
                }
                else
@@ -396,7 +401,8 @@
                        HISPRICEEXCLUDETAX = _saveObj.SelectToken("Result.Result.POOrderFinance[0].FISPRICEEXCLUDETAX")?.ToString().ToUpper() == "TRUE" ? 1 : 0,
                    };

                    //根据单据ID，删除本地数据
                    //根据单据号、单据ID，删除本地数据
                    oCn.RunProc("Delete from Cg_POOrderBillMain where HBillNo='" + MainData.HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from Cg_POOrderBillMain where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from Cg_POOrderBillSub where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);

@@ -556,6 +562,14 @@
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();

            //获取系统参数
            string sCampanyName = "";   //客户定制化名称
            Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
            if (oSystemParameter.ShowBill(ref sErrMsg) == true)
            {
                sCampanyName = oSystemParameter.omodel.WMS_CampanyName;  //系统参数  客户定制化名称     空白为通用
            }

            //从配置文件获取 CLOUD网址、账套信息、登录用户、登录密码
            if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo))
            {
@@ -593,6 +607,8 @@
                        strErrorMsg += item.Message + "\r\n";
                    };
                    sErrMsg = "同步单据失败！" + strErrorMsg;
                    //根据单据号，删除本地数据
                    oCn.RunProc("Delete from Xs_SeOutStockbillMain where HBillNo='" + HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    return false;
                }
                else
@@ -670,11 +686,22 @@
                        HEXCHANGERATE = _saveObj.SelectToken("Result.Result.SAL_DELIVERYNOTICEFIN[0].ExchangeRate")?.ToString() ?? "0",
                        HISINCLUDEDTAX = _saveObj.SelectToken("Result.Result.SAL_DELIVERYNOTICEFIN[0].IsIncludedTax")?.ToString().ToUpper() == "TRUE" ? 1 : 0,
                        HISPRICEEXCLUDETAX = _saveObj.SelectToken("Result.Result.SAL_DELIVERYNOTICEFIN[0].IsPriceExcludeTax")?.ToString().ToUpper() == "TRUE" ? 1 : 0,
                        F_XLBH_Base_apv = _saveObj.SelectToken("Result.Result.F_XLBH_Base_apv.Number")?.ToString() ?? "",   //小卫    收货仓库
                    };

                    //根据单据ID，删除本地数据
                    //根据单据号、单据ID，删除本地数据
                    oCn.RunProc("Delete from Xs_SeOutStockbillMain where HBillNo='" + MainData.HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from Xs_SeOutStockbillMain where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from Xs_SeOutStockbillSub where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);

                    //定义客户主表自定义字段
                    string MainCustom1 = "";
                    string MainCustom2 = "";
                    if (sCampanyName == "小卫")
                    {
                        MainCustom1 = ",F_XLBH_Base_apv";
                        MainCustom2 = ",'" + MainData.F_XLBH_Base_apv + "'";
                    }

                    //插入主表
                    oCn.RunProc("Insert Into Xs_SeOutStockbillMain " +
@@ -691,6 +718,7 @@
                    ",HRECCONTACTID,HRECCONTACTNumber,HRECCONTACTName,HRECEIPTCONDITIONID,HRECEIPTCONDITIONNumber,HCORRESPONDORGID" +
                    ",HCARRIAGENO,HSTOCKERNumber,HSALESMANNumber,HLOCALCURRNumber,HSETTLECURRNumber,HEXCHANGETYPENumber" +
                    ",HSETTLETYPENumber" +
                      MainCustom1+
                    ") " +
                    " values(" + MainData.HInterID.ToString() + "," + MainData.HYear.ToString() + "," + MainData.HPeriod.ToString() + ",'" + MainData.HBillType + "','" + MainData.HBillSubType + "','" + MainData.HDate + "'" +
                    ",'" + MainData.HBillNo + "'," + MainData.HBillStatus.ToString() +
@@ -705,6 +733,7 @@
                    ", " + MainData.HRECCONTACTID.ToString() + ",'" + MainData.HRECCONTACTNumber + "','" + MainData.HRECCONTACTName + "'," + MainData.HRECEIPTCONDITIONID.ToString() + ",'" + MainData.HRECEIPTCONDITIONNumber + "'," + MainData.HCORRESPONDORGID.ToString() +
                    ",'" + MainData.HCARRIAGENO + "','" + MainData.HSTOCKERNumber + "','" + MainData.HSALESMANNumber + "','" + MainData.HLOCALCURRNumber + "','" + MainData.HSETTLECURRNumber + "','" + MainData.HEXCHANGETYPENumber + "'" +
                    ",'" + MainData.HSETTLETYPENumber + "'" +
                      MainCustom2 +
                    ") ");

                    //子表数据赋值
@@ -866,6 +895,8 @@
                        strErrorMsg += item.Message + "\r\n";
                    };
                    sErrMsg = "同步单据失败！" + strErrorMsg;
                    //根据单据号，删除本地数据
                    oCn.RunProc("Delete from Xs_SeOutStockBackBillMain where HBillNo='" + HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    return false;
                }
                else
@@ -941,7 +972,8 @@
                        HISPRICEEXCLUDETAX = _saveObj.SelectToken("Result.Result.SAL_RETURNNOTICEFIN[0].IsPriceExcludeTax")?.ToString().ToUpper() == "TRUE" ? 1 : 0,
                    };

                    //根据单据ID，删除本地数据
                    //根据单据号、单据ID，删除本地数据
                    oCn.RunProc("Delete from Xs_SeOutStockBackBillMain where HBillNo='" + MainData.HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from Xs_SeOutStockBackBillMain where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from Xs_SeOutStockBackbillSub where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);

@@ -1139,6 +1171,8 @@
                        strErrorMsg += item.Message + "\r\n";
                    };
                    sErrMsg = "同步单据失败！" + strErrorMsg;
                    //根据单据号，删除本地数据
                    oCn.RunProc("Delete from Sc_PPBomBillMain where HBillNo='" + HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    return false;
                }
                else
@@ -1181,7 +1215,8 @@
                        HICMOEntrySEQ = _saveObj.SelectToken("Result.Result.MOEntrySeq")?.ToString() ?? "0",
                    };

                    //根据单据ID，删除本地数据
                    //根据单据号、单据ID，删除本地数据
                    oCn.RunProc("Delete from Sc_PPBomBillMain where HBillNo='" + MainData.HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from Sc_PPBomBillMain where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from Sc_PPBomBillSub where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);

@@ -1352,6 +1387,8 @@
                        strErrorMsg += item.Message + "\r\n";
                    };
                    sErrMsg = "同步单据失败！" + strErrorMsg;
                    //根据单据号，删除本地数据
                    oCn.RunProc("Delete from WW_PPBomBillMain where HBillNo='" + HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    return false;
                }
                else
@@ -1399,7 +1436,8 @@
                        HREQSRC = _saveObj.SelectToken("Result.Result.ReqSrc")?.ToString() ?? "",
                    };

                    //根据单据ID，删除本地数据
                    //根据单据号、单据ID，删除本地数据
                    oCn.RunProc("Delete from WW_PPBomBillMain where HBillNo='" + MainData.HBillNo + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from WW_PPBomBillMain where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
                    oCn.RunProc("Delete from WW_PPBomBillSub where HInterID=" + MainData.HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);

@@ -1558,6 +1596,8 @@
                        strErrorMsg += item.Message + "\r\n";
                    };
                    sErrMsg = "同步单据失败！" + strErrorMsg;
                    //根据单据号，删除本地数据
                    oCn.RunProc("Delete from Kf_ICStockBillMain where HBillNo='" + HBillNo + "' and HBillType='" + HBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    return false;
                }
                else
@@ -1573,6 +1613,8 @@
                    else
                    {
                        HInterID = DBUtility.ClsPub.isLong(dsID.Tables[0].Rows[0]["HInterID"]);
                        //根据单据号、单据ID，删除本地数据
                        oCn.RunProc("Delete from Kf_ICStockBillMain where HBillNo='" + HBillNo + "' and HBillType='" + HBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                        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);
                    }
@@ -1872,6 +1914,8 @@
                        strErrorMsg += item.Message + "\r\n";
                    };
                    sErrMsg = "同步单据失败！" + strErrorMsg;
                    //根据单据号，删除本地数据
                    oCn.RunProc("Delete from Kf_ICStockBillMain where HBillNo='" + HBillNo + "' and HBillType='" + HBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                    return false;
                }
                else
@@ -1887,6 +1931,8 @@
                    else
                    {
                        HInterID = DBUtility.ClsPub.isLong(dsID.Tables[0].Rows[0]["HInterID"]);
                        //根据单据号、单据ID，删除本地数据
                        oCn.RunProc("Delete from Kf_ICStockBillMain where HBillNo='" + HBillNo + "' and HBillType='" + HBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                        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);
                    }