From 54329f0ab6bf4d87d95e37a553ffdf0b14fa4bea Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期四, 08 八月 2024 17:31:07 +0800 Subject: [PATCH] 产品工艺参数清单, 增加 字段 HTechParamClassID int //工艺参数大类(Gy_TechnologyParameterClass) HSNO int //工艺次序 HStdNextTimes money //理论次序间隔 HTechParamIDStd int //对应设定值工艺参数(Gy_TechnologyParameter) (都是非必录),修改出战斗获取模具 --- WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs | 6 +----- 1 files changed, 1 insertions(+), 5 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs index 95f0e3c..1db60e5 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs @@ -3683,11 +3683,7 @@ { try { - string sql = @"SELECT b.HMouldID,c.HMouldNo 妯″叿缂栫爜,c.HName 妯″叿鍚嶇О,c.HModel 妯″叿鍨嬪彿 FROM Sc_ICMOBillStatus_Tmp a LEFT JOIN( - SELECT *, ROW_NUMBER() OVER(PARTITION BY HSourceID ORDER BY HScanDate DESC) AS RowNum FROM Sc_MouldUpperBillSub - ) b ON a.HSourceID = b.HSourceID AND b.RowNum = 1 left join Gy_MouldFileMain c on b.HMouldID = c.HInterID - where b.HMouldID is not null and a.HSourceInterID ='" + HInterID + "' and a.HSourceEntryID ='" + HEntryID + "' and a.HSourceBillNo ='" + HBillNo + "'"; - ds = oCN.RunProcReturn(sql, "Sc_ICMOBillStatus_Tmp"); + ds = oCN.RunProcReturn("exec h_p_StationOutBill_Model '" + HInterID + "','"+ HEntryID + "' ,'" + HBillNo + "'", "h_p_StationOutBill_Model"); if (ds.Tables[0].Rows.Count != 0 && ds != null) { -- Gitblit v1.9.1