From 5ce30510e4067a3cba5d76c16d27a10f2322cbe4 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期四, 14 十二月 2023 17:14:38 +0800 Subject: [PATCH] 新增生产汇报单同步字段-不良数量、报废数量、批号,新增产量汇报单反写关联字段 --- WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs | 22 +++++++++++----------- 1 files changed, 11 insertions(+), 11 deletions(-) diff --git a/WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs b/WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs index 8f391a6..0f9d62f 100644 --- a/WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs +++ b/WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs @@ -892,17 +892,17 @@ public static DataSet Sc_GetMESProductReportBillList(string sWhere) { - string sql = string.Format(@"select a.HInterID, a.HBillNo,a.HDate,a.HBillType,a.HBillStatus,a.HMaterID,m.HNumber HMaterCode,m.HName HMaterName,m.HModel HMaterSpec - ,a.HSourceID,s.HNumber HSourceCode,s.HName HSourceName,a.HGroupID,g.HNumber HGroupCode,g.HName HGroupName - ,a.HWorkManID,e.HName HWorkManName,a.HMaker,a.HMakeDate, a.HReportType - ,a.HQty,a.HICMOBillNo,a.HICMOInterID,a.HICMOEntryID - ,a.HSourceInterID,a.HSourceEntryID,a.HSourceBillNo, a.HSourceBillType - from Sc_ICMOBillWorkQtyStatus_Tmp a - left join Gy_Material m on a.HMaterID=m.hitemid - left join Gy_Source s on a.HSourceID=s.HItemID - left join Gy_Group g on a.HGroupID=g.HItemID - left join Gy_Employee e on a.HWorkManID=e.HItemID " + sWhere + " and HRelationInterID='0'"); - return new SQLHelper.ClsCN().RunProcReturn(sql, "Sc_ICMOBillWorkQtyStatus_Tmp"); + string sql = ""; + if (sWhere != null && sWhere != "") + { + sql = "select * from h_v_Sc_ICMOBillWorkQtyTmpList_ReportingPlatform " + sWhere; + } + else + { + sql = "select * from h_v_Sc_ICMOBillWorkQtyTmpList_ReportingPlatform " ; + } + + return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_ICMOBillWorkQtyTmpList_ReportingPlatform"); } #endregion -- Gitblit v1.9.1