From 6548e683b4a80582930b687fb4dcdd07a77ea813 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期三, 14 十二月 2022 08:34:25 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/simoer_jiekou
---
zymes/OperationService/zymes_RealessPrdMoReport.cs | 34 +++++++++++++++++++++++++++++++++-
1 files changed, 33 insertions(+), 1 deletions(-)
diff --git a/zymes/OperationService/zymes_RealessPrdMoReport.cs b/zymes/OperationService/zymes_RealessPrdMoReport.cs
index 966e2d5..ba6a7ec 100644
--- a/zymes/OperationService/zymes_RealessPrdMoReport.cs
+++ b/zymes/OperationService/zymes_RealessPrdMoReport.cs
@@ -185,7 +185,39 @@
Entity entity = this.BusinessInfo.GetEntity("FEntity");//鑾峰彇鏄庣粏淇℃伅
foreach (var billObj in e.DataEntitys)
{
- var sql = $"exec zymes_RealessPrdMoReport {billObj["Id"]} ";
+ //var sql = $"exec zymes_RealessPrdMoReport {billObj["Id"]} ";
+ 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
+,0 HOWNERTYPEID,0 HISENTRUST,0 HSTOCKINORGID,0 HOWNERID,0 HCHECKPRODUCT,'' HQAIP,0 HCOSTRATE,0 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
+from T_PRD_MORPT a with(nolock)
+Where a.FID={id}
+";
DataSet ds = DBServiceHelper.ExecuteDataSet(Context, sql);
DataTable maindt = ds.Tables[1];
DataTable subdt = ds.Tables[0];
--
Gitblit v1.9.1