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_RealessPrdMoReport.cs | 58 +++++++++++++++++++++++++++++-----------------------------
1 files changed, 29 insertions(+), 29 deletions(-)
diff --git a/zymes/OperationService/zymes_RealessPrdMoReport.cs b/zymes/OperationService/zymes_RealessPrdMoReport.cs
index 3e3997e..ff146a8 100644
--- a/zymes/OperationService/zymes_RealessPrdMoReport.cs
+++ b/zymes/OperationService/zymes_RealessPrdMoReport.cs
@@ -192,36 +192,36 @@
var id = billObj["Id"].ToString();
string sql = string.Empty;
sql = $@"
-/*dialect*/
-SELECT
-a.FID AS HInterID,a.FENTRYID as HENTRYID,a.FMATERIALID as HMaterID,m.FNUMBER HMaterNumber
-,a.FFINISHQTY as HQty,a.FUNITID as HUnitID,u.FNUMBER HUnitNumber,a.FHRWORKTIME HTimes,0 HSourceID
-,0 HQtyMust,0 HWorkerID,'' HWorkerNumber,0 HBadCount,0 HWasterQty
-,'' HCloseMan,'false' HCloseType,'CLOUD瀵煎叆' HRemark
-,a.FSRCINTERID as HSourceInterID,a.FSRCENTRYID as HSourceEntryID,a.FSRCBILLNO as HSourceBillNo,a.FSRCBILLTYPE as HSourceBillType,0 HRelationQty,0 as HRelationMoney
-,0 HSeOrderInterID,0 HSeOrderEntryID,'' HSeOrderBillNo
-,a.FMOID HICMOInterID,a.FMOBILLNO HICMOBillNo, '' HBarCode
-,FOWNERTYPEID HOWNERTYPEID,0 HISENTRUST,FSTOCKINORGID HSTOCKINORGID,FOWNERID HOWNERID,FCHECKPRODUCT HCHECKPRODUCT,'' HQAIP,FCOSTRATE HCOSTRATE,FISBACKFLUSH HISBACKFLUSH
-,'' HREQSRC,'' HREQBILLNO,0 HREQBILLID,0 HREQENTRYSEQ,0 HREQENTRYID,a.FMOENTRYID HMOMAINENTRYID,0 HSTOCKINQUASELQTY
-,a.FPRODUCTTYPE HPRODUCTTYPE,a.FPROJECTNO HPROJECTNO,a.FMOENTRYSEQ HICMOENTRYSEQ,a.FSEQ as HSEQ,null HPRODUCEDATE,null HEXPIRYDATE,a.FBASEUNITID HBASEUNITID,isnull(a.FWORKSHOPID,0) HDEPTID
-,a.FSHIFTGROUPID HGroupID,'' HDESCRIPTION,'' HSourceNumber,0 HQPQty,a.FMOENTRYID HICMOEntryID
-,0 HWHID,0 HSPID,a.FLOT_TEXT as HBatchNo,a.FAUXPROPID as HAuxPropID,a.FMTONO as HMTONo,0 as HPlanMode,a.FID as HERPInterID,a.FENTRYID as HERPEntryID
-from T_PRD_MORPTENTRY a with(nolock)
-inner join T_PRD_MORPTENTRY_A aa with(nolock) on a.FENTRYID=aa.FENTRYID
-left join T_BD_MATERIAL m on a.FMATERIALID=m.FMATERIALID
-left join T_BD_UNIT u on a.FUNITID=u.FUNITID
-Where a.FID={id}
+ /*dialect*/
+ SELECT
+ a.FID AS HInterID,a.FENTRYID as HENTRYID,a.FMATERIALID as HMaterID,m.FNUMBER HMaterNumber
+ ,a.FFINISHQTY as HQty,a.FUNITID as HUnitID,u.FNUMBER HUnitNumber,a.FHRWORKTIME HTimes,0 HSourceID
+ ,0 HQtyMust,0 HWorkerID,'' HWorkerNumber,0 HBadCount,0 HWasterQty
+ ,'' HCloseMan,'false' HCloseType,'CLOUD瀵煎叆' HRemark
+ ,a.FSRCINTERID as HSourceInterID,a.FSRCENTRYID as HSourceEntryID,a.FSRCBILLNO as HSourceBillNo,a.FSRCBILLTYPE as HSourceBillType,0 HRelationQty,0 as HRelationMoney
+ ,0 HSeOrderInterID,0 HSeOrderEntryID,'' HSeOrderBillNo
+ ,a.FMOID HICMOInterID,a.FMOBILLNO HICMOBillNo, '' HBarCode
+ ,FOWNERTYPEID HOWNERTYPEID,0 HISENTRUST,FSTOCKINORGID HSTOCKINORGID,FOWNERID HOWNERID,FCHECKPRODUCT HCHECKPRODUCT,'' HQAIP,FCOSTRATE HCOSTRATE,FISBACKFLUSH HISBACKFLUSH
+ ,'' HREQSRC,'' HREQBILLNO,0 HREQBILLID,0 HREQENTRYSEQ,0 HREQENTRYID,a.FMOENTRYID HMOMAINENTRYID,0 HSTOCKINQUASELQTY
+ ,a.FPRODUCTTYPE HPRODUCTTYPE,a.FPROJECTNO HPROJECTNO,a.FMOENTRYSEQ HICMOENTRYSEQ,a.FSEQ as HSEQ,null HPRODUCEDATE,null HEXPIRYDATE,a.FBASEUNITID HBASEUNITID,isnull(a.FWORKSHOPID,0) HDEPTID
+ ,a.FSHIFTGROUPID HGroupID,'' HDESCRIPTION,'' HSourceNumber,0 HQPQty,a.FMOENTRYID HICMOEntryID
+ ,0 HWHID,0 HSPID,a.FLOT_TEXT as HBatchNo,a.FAUXPROPID as HAuxPropID,a.FMTONO as HMTONo,0 as HPlanMode,a.FID as HERPInterID,a.FENTRYID as HERPEntryID
+ from T_PRD_MORPTENTRY a with(nolock)
+ inner join T_PRD_MORPTENTRY_A aa with(nolock) on a.FENTRYID=aa.FENTRYID
+ left join T_BD_MATERIAL m on a.FMATERIALID=m.FMATERIALID
+ left join T_BD_UNIT u on a.FUNITID=u.FUNITID
+ Where a.FID={id}
-select
-'3711' HBillType,'3711' HBillSubType,a.FID HInterID,a.FbillNo HBillNo,a.FDATE HDate,a.FCREATORID HMaker,getdate() HMakeDate
-,YEAR(GETDATE()) HYear,MONTH(GETDATE()) HPeriod,'CLOUD瀵煎叆' HRemark,0 HEMPID,'' HEmpNumber
-,0 HGroupID,0 HDeptID,'' HDeptNumber,'' HMainSourceBillNo,0 HMainSourceInterID,0 HMainSourceEntryID,0 HMainSourceBillType
-,a.FAPPROVERID HChecker,a.FAPPROVEDATE HCheckDate,a.FAPPROVERID FAPPROVERID,a.FAPPROVEDATE HUpDateDate,'' HDeleteMan,null HDeleteDate,0 HPrintQty,'' HCheckType
-,a.FID HERPInterID,a.FBILLTYPE HERPBillType,FPRDORGID HPRDORGID,o.FNUMBER as HOrganNumber
-from T_PRD_MORPT a with(nolock)
-left join T_ORG_Organizations o with(nolock) on a.FPRDORGID=o.FORGID
-Where a.FID={id}
-";
+ select
+ '3711' HBillType,'3711' HBillSubType,a.FID HInterID,a.FbillNo HBillNo,a.FDATE HDate,a.FCREATORID HMaker,getdate() HMakeDate
+ ,YEAR(GETDATE()) HYear,MONTH(GETDATE()) HPeriod,'CLOUD瀵煎叆' HRemark,0 HEMPID,'' HEmpNumber
+ ,0 HGroupID,0 HDeptID,'' HDeptNumber,'' HMainSourceBillNo,0 HMainSourceInterID,0 HMainSourceEntryID,0 HMainSourceBillType
+ ,a.FAPPROVERID HChecker,a.FAPPROVEDATE HCheckDate,a.FAPPROVERID FAPPROVERID,a.FAPPROVEDATE HUpDateDate,'' HDeleteMan,null HDeleteDate,0 HPrintQty,'' HCheckType
+ ,a.FID HERPInterID,a.FBILLTYPE HERPBillType,FPRDORGID HPRDORGID,o.FNUMBER as HOrganNumber
+ from T_PRD_MORPT a with(nolock)
+ left join T_ORG_Organizations o with(nolock) on a.FPRDORGID=o.FORGID
+ Where a.FID={id}
+ ";
DataSet ds = DBServiceHelper.ExecuteDataSet(Context, sql);
DataTable maindt = ds.Tables[1];
DataTable subdt = ds.Tables[0];
--
Gitblit v1.9.1