From d06646be7c7dbc7be3a05a9be14e15fcced2bc2c Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期一, 22 九月 2025 17:10:59 +0800
Subject: [PATCH] 优化同步插件
---
zymes/OperationService/zymes_RealessPurPoorder.cs | 67 ++++++++++++++++-----------------
1 files changed, 33 insertions(+), 34 deletions(-)
diff --git a/zymes/OperationService/zymes_RealessPurPoorder.cs b/zymes/OperationService/zymes_RealessPurPoorder.cs
index 7ffbfc6..976b9ec 100644
--- a/zymes/OperationService/zymes_RealessPurPoorder.cs
+++ b/zymes/OperationService/zymes_RealessPurPoorder.cs
@@ -192,38 +192,38 @@
var id = billObj["Id"].ToString();
string sql = string.Empty;
sql = $@"
-/*dialect*/
-select a.FID HInterID,a.FEntryID HEntryID,a.FMATERIALID HMaterID,a.FUnitID HUnitID,a.FQty HQty,isnull(f.FPRICE,0) HPrice,isnull(t.FTAXRATE,0) HTaxRate_TAX,isnull(t.FTAXAMOUNT,0) HTaxMoney_TAX
-,isnull(f.FTAXPRICE,0) HTaxPrice,isnull(f.FDISCOUNTRATE,0) HDiscountRate,0 HRelTaxPrice,isnull(f.FAMOUNT,0) HMoney,isnull(f.FTAXRATE,0) HTaxRate,isnull(f.FTAXAMOUNT,0) HTaxMoney
-,0 HLineTotal,0 HlineTotalBB,d.FDELIVERYDATE HDate,0 HInStockQty,0 HInvoiceQty,a.FNOTE HRemark
-,'' HSeOrderBillNo,0 HSeOrderInterID,0 HSeOrderEntryID,0 HSourceInterID,0 HSourceEntryID,'' HSourceBillNo,'' HSourceBillType
-,isnull(r.FJOINQTY,0) HRelationQty,isnull(r.FSTOCKRETQTY,0) HBackRelationQty,0 HPropertyID,a.FLOT_TEXT HBatChNo,a.FAUXPROPID HAuxPropID,a.FMTONo HMTONo
-,a.FID HERPInterID,a.FEntryID HERPEntryID,a.FSEQ HSEQ,a.FRECEIVEDEPTID HRECEIVEDEPTID,a.FSUPPLIERLOT HSUPPLIERLOT,a.FBOMID HBOMID
-,a.FSTOCKUNITID HSTOCKUNITID,a.FBASEUNITID HBASEUNITID,a.FBFLOWID HBFLOWID,a.FGIVEAWAY HGIVEAWAY,a.FROWTYPE HROWTYPE,a.FBASEUNITQTY HBASEUNITQTY
-,a.FSTOCKBASEQTY HSTOCKBASEQTY,isnull(r.FREQTRACENO,'') HREQTRACENO,isnull(l.FMATERIALDESC,'') HMATERIALDESC,isnull(d.FRECEIVEORGID,0) HRECEIVEORGID,isnull(d.FREQUIREORGID,0) HREQUIREORGID
-,isnull(f.FTAXNETPRICE,0) HTAXNETPRICE,isnull(f.FPRICECOEFFICIENT,0) HPRICECOEFFICIENT,isnull(f.FTAXCOMBINATION,0) HTAXCOMBINATION,isnull(f.FPRICEUNITID,0) HPRICEUNITID,isnull(f.FPRICELISTENTRY,0) HPRICELISTENTRY,isnull(f.FPAYORGID,0) HPAYORGID
-,isnull(fin.FSETTLEMODEID,0) HSETTLEMODEID,isnull(fin.FSETTLECURRID,0) HSETTLECURRID,isnull(fin.FEXCHANGETYPEID,0) HEXCHANGETYPEID,isnull(fin.FPAYCONDITIONID,0) HPAYCONDITIONID,isnull(fin.FEXCHANGERATE,0) HEXCHANGERATE,isnull(fin.FLOCALCURRID,0) HLOCALCURRID
-,isnull(fin.FISINCLUDEDTAX,0) HISINCLUDEDTAX,isnull(fin.FISPRICEEXCLUDETAX,0) HISPRICEEXCLUDETAX,isnull(fin.FSETTLEORGID,0) HSETTLEORGID
-,isnull(t.FTAXRATEID,0) HTAXRATEID,isnull(t.FCOSTPERCENT,0) HCOSTPERCENT,isnull(t.FCOSTAMOUNT,0) HCOSTAMOUNT,isnull(t.FVAT,0) HVAT,isnull(t.FSELLERWITHHOLDING,0) HSELLERWITHHOLDING,isnull(t.FBUYERWITHHOLDING,0) HBUYERWITHHOLDING
-from T_PUR_POORDERENTRY a with(nolock)
-left join T_PUR_POORDERENTRY_D d with(nolock) on a.FENTRYID=d.FENTRYID
-left join T_PUR_POORDERENTRY_R r with(nolock) on a.FENTRYID=r.FENTRYID
-left join T_PUR_POORDERENTRY_F f with(nolock) on a.FENTRYID=f.FENTRYID
-left join T_PUR_POORDERENTRY_TAX t with(nolock) on a.FENTRYID=t.FENTRYID
-left join T_PUR_POORDERENTRY_L l with(nolock) on a.FENTRYID=l.FENTRYID and l.FLOCALEID=2052
-left join T_PUR_POORDERFIN fin with(nolock) on a.FENTRYID=fin.FENTRYID
-Where a.FID={id}
-select a.FID as HInterID,year(a.FDATE) as HYear,month(a.FDATE) as HPeriod,'1102' as HBillType,'1102' as HBillSubType,a.FDate as HDate
-,a.FBillNo as HBillNo,case when a.FAPPROVERID=0 then 1 else 2 end HBillStatus,'' as HAddress,0 as HSSID,a.FDATE as HSSDate,0 as HPSStyleID
-,a.FSUPPLIERID as HSupID,a.F_RCZU_JXS HSupDealerID,0 as HCurID,0 as HExRate,a.FPURCHASERID as HEmpID,0 as HManagerID,a.FPURCHASEDEPTID as HDeptID
-,'CLOUD瀵煎叆' as HExplanation,'CLOUD瀵煎叆' as HRemark,a.FBillNo as HInnerBillNo
-,a.FAPPROVERID as HChecker,a.FAPPROVEDATE as HCheckDate,a.FCREATORID as HMaker,a.FCREATEDATE as HMakeDate
-,a.FID as HERPInterID,a.FBILLTYPEID as HERPBillType,a.FPURCHASEORGID as HPURCHASEORGID,a.FPURCHASERGROUPID as HPURCHASERGROUPID,a.FPROVIDERID as HPROVIDERID,a.FSETTLEID as HSETTLEID
-,a.FCHARGEID as HCHARGEID,a.FBUSINESSTYPE as HBUSINESSTYPE,a.FPROVIDERADDRESS as HPROVIDERADDRESS,isnull(a.FCORRESPONDORGID,0) as HCORRESPONDORGID,a.FPROVIDERCONTACTID as HPROVIDERCONTACTID
-,o.FNUMBER as HOrganNumber
-from T_PUR_POORDER a with(nolock)
-left join T_ORG_Organizations o with(nolock) on a.FPURCHASEORGID=o.FORGID
-Where a.FID={id}
+ /*dialect*/
+ select a.FID HInterID,a.FEntryID HEntryID,a.FMATERIALID HMaterID,a.FUnitID HUnitID,a.FQty HQty,isnull(f.FPRICE,0) HPrice,isnull(t.FTAXRATE,0) HTaxRate_TAX,isnull(t.FTAXAMOUNT,0) HTaxMoney_TAX
+ ,isnull(f.FTAXPRICE,0) HTaxPrice,isnull(f.FDISCOUNTRATE,0) HDiscountRate,0 HRelTaxPrice,isnull(f.FAMOUNT,0) HMoney,isnull(f.FTAXRATE,0) HTaxRate,isnull(f.FTAXAMOUNT,0) HTaxMoney
+ ,0 HLineTotal,0 HlineTotalBB,d.FDELIVERYDATE HDate,0 HInStockQty,0 HInvoiceQty,a.FNOTE HRemark
+ ,'' HSeOrderBillNo,0 HSeOrderInterID,0 HSeOrderEntryID,0 HSourceInterID,0 HSourceEntryID,'' HSourceBillNo,'' HSourceBillType
+ ,isnull(r.FJOINQTY,0) HRelationQty,isnull(r.FSTOCKRETQTY,0) HBackRelationQty,0 HPropertyID,a.FLOT_TEXT HBatChNo,a.FAUXPROPID HAuxPropID,a.FMTONo HMTONo
+ ,a.FID HERPInterID,a.FEntryID HERPEntryID,a.FSEQ HSEQ,a.FRECEIVEDEPTID HRECEIVEDEPTID,a.FSUPPLIERLOT HSUPPLIERLOT,a.FBOMID HBOMID
+ ,a.FSTOCKUNITID HSTOCKUNITID,a.FBASEUNITID HBASEUNITID,a.FBFLOWID HBFLOWID,a.FGIVEAWAY HGIVEAWAY,a.FROWTYPE HROWTYPE,a.FBASEUNITQTY HBASEUNITQTY
+ ,a.FSTOCKBASEQTY HSTOCKBASEQTY,isnull(r.FREQTRACENO,'') HREQTRACENO,isnull(l.FMATERIALDESC,'') HMATERIALDESC,isnull(d.FRECEIVEORGID,0) HRECEIVEORGID,isnull(d.FREQUIREORGID,0) HREQUIREORGID
+ ,isnull(f.FTAXNETPRICE,0) HTAXNETPRICE,isnull(f.FPRICECOEFFICIENT,0) HPRICECOEFFICIENT,isnull(f.FTAXCOMBINATION,0) HTAXCOMBINATION,isnull(f.FPRICEUNITID,0) HPRICEUNITID,isnull(f.FPRICELISTENTRY,0) HPRICELISTENTRY,isnull(f.FPAYORGID,0) HPAYORGID
+ ,isnull(fin.FSETTLEMODEID,0) HSETTLEMODEID,isnull(fin.FSETTLECURRID,0) HSETTLECURRID,isnull(fin.FEXCHANGETYPEID,0) HEXCHANGETYPEID,isnull(fin.FPAYCONDITIONID,0) HPAYCONDITIONID,isnull(fin.FEXCHANGERATE,0) HEXCHANGERATE,isnull(fin.FLOCALCURRID,0) HLOCALCURRID
+ ,isnull(fin.FISINCLUDEDTAX,0) HISINCLUDEDTAX,isnull(fin.FISPRICEEXCLUDETAX,0) HISPRICEEXCLUDETAX,isnull(fin.FSETTLEORGID,0) HSETTLEORGID
+ ,isnull(t.FTAXRATEID,0) HTAXRATEID,isnull(t.FCOSTPERCENT,0) HCOSTPERCENT,isnull(t.FCOSTAMOUNT,0) HCOSTAMOUNT,isnull(t.FVAT,0) HVAT,isnull(t.FSELLERWITHHOLDING,0) HSELLERWITHHOLDING,isnull(t.FBUYERWITHHOLDING,0) HBUYERWITHHOLDING
+ from T_PUR_POORDERENTRY a with(nolock)
+ left join T_PUR_POORDERENTRY_D d with(nolock) on a.FENTRYID=d.FENTRYID
+ left join T_PUR_POORDERENTRY_R r with(nolock) on a.FENTRYID=r.FENTRYID
+ left join T_PUR_POORDERENTRY_F f with(nolock) on a.FENTRYID=f.FENTRYID
+ left join T_PUR_POORDERENTRY_TAX t with(nolock) on a.FENTRYID=t.FENTRYID
+ left join T_PUR_POORDERENTRY_L l with(nolock) on a.FENTRYID=l.FENTRYID and l.FLOCALEID=2052
+ left join T_PUR_POORDERFIN fin with(nolock) on a.FENTRYID=fin.FENTRYID
+ Where a.FID={id}
+ select a.FID as HInterID,year(a.FDATE) as HYear,month(a.FDATE) as HPeriod,'1102' as HBillType,'1102' as HBillSubType,a.FDate as HDate
+ ,a.FBillNo as HBillNo,case when a.FAPPROVERID=0 then 1 else 2 end HBillStatus,'' as HAddress,0 as HSSID,a.FDATE as HSSDate,0 as HPSStyleID
+ ,a.FSUPPLIERID as HSupID,a.F_RCZU_JXS HSupDealerID,0 as HCurID,0 as HExRate,a.FPURCHASERID as HEmpID,0 as HManagerID,a.FPURCHASEDEPTID as HDeptID
+ ,'CLOUD瀵煎叆' as HExplanation,'CLOUD瀵煎叆' as HRemark,a.FBillNo as HInnerBillNo
+ ,a.FAPPROVERID as HChecker,a.FAPPROVEDATE as HCheckDate,a.FCREATORID as HMaker,a.FCREATEDATE as HMakeDate
+ ,a.FID as HERPInterID,a.FBILLTYPEID as HERPBillType,a.FPURCHASEORGID as HPURCHASEORGID,a.FPURCHASERGROUPID as HPURCHASERGROUPID,a.FPROVIDERID as HPROVIDERID,a.FSETTLEID as HSETTLEID
+ ,a.FCHARGEID as HCHARGEID,a.FBUSINESSTYPE as HBUSINESSTYPE,a.FPROVIDERADDRESS as HPROVIDERADDRESS,isnull(a.FCORRESPONDORGID,0) as HCORRESPONDORGID,a.FPROVIDERCONTACTID as HPROVIDERCONTACTID
+ ,o.FNUMBER as HOrganNumber
+ from T_PUR_POORDER a with(nolock)
+ left join T_ORG_Organizations o with(nolock) on a.FPURCHASEORGID=o.FORGID
+ Where a.FID={id}
";
DataSet ds = DBServiceHelper.ExecuteDataSet(Context, sql);
DataTable maindt = ds.Tables[1];
@@ -265,8 +265,7 @@
{
["model"] = model
};
- //LogService.Write("閲囪喘璁㈠崟鍚屾绀轰緥" + JsonConvert.SerializeObject(jsonRoot));
- //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 涓氬姟绔欑偣鍦板潃
+
var client = new RestSharp.RestClient(http);
//鏂板
var requestPost = new RestRequest("Cg_POOrderBill/Cg_POOrderBillSaveApi", Method.POST);
--
Gitblit v1.9.1