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 | 14 ++++++++++++--
1 files changed, 12 insertions(+), 2 deletions(-)
diff --git a/WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs b/WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs
index af22e2f..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";
@@ -498,6 +500,14 @@
objJsonResult.data = null;
return objJsonResult;
}
+ else if (ds.Tables[0].Rows[0]["HBillStatus"].ToString() != "2")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "瀹℃牳澶辫触!鍘熷洜:婧愬崟鏈浜庡鏍哥姸鎬�!";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
oCN.BeginTran();
//鍙嶅啓婧愬崟鏁版嵁
--
Gitblit v1.9.1