From bc1dda419b3cef845ed90f6c31c6bda82743e19a Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期四, 07 三月 2024 10:19:16 +0800
Subject: [PATCH] 器具档案列表 增加 左边树形 器具分类，点击分类，根据分类来过滤，方便选择 器具档案里，增加字段 HMouldClass varchar(50) 器具类型 下拉框 （模具、工装、夹具、刀具、检具、周转器具、其他）
---
WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs b/WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs
index e78e6ca..44988ea 100644
--- a/WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs
+++ b/WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs
@@ -488,8 +488,10 @@
}
//妫�鏌ユ簮鍗曟槸鍚﹀瓨鍦�
- string sql = "select * from Sc_ICMOBillSub where HInterID = " + oBill.omodel.HMainSourceInterID + " and HEntryID =" + oBill.omodel.HMainSourceEntryID;
- ds = oCN.RunProcReturn(sql, "Sc_ICMOBillSub");
+ string sql = "select * from Sc_ICMOBillMain as a " +
+ " inner join Sc_ICMOBillSub as b on a.HInterID = b.HInterID " +
+ " where b.HInterID = " + oBill.omodel.HMainSourceInterID + " and b.HEntryID =" + oBill.omodel.HMainSourceEntryID;
+ ds = oCN.RunProcReturn(sql, "Sc_ICMOBill");
if(ds==null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
--
Gitblit v1.9.1