From e8095e4e781514a34b484d75e9243f763de46182 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期日, 03 三月 2024 16:46:32 +0800
Subject: [PATCH] 工序流转卡：根据用户关联客户显示数据优化
---
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