From 28161a2db7a593c30ca53e5c1e59103cd7591fe7 Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期一, 27 四月 2026 09:47:32 +0800
Subject: [PATCH] 1

---
 WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs |   16 ++++++++--------
 1 files changed, 8 insertions(+), 8 deletions(-)

diff --git a/WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs b/WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs
index 16259de..5cb826b 100644
--- a/WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs
+++ b/WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs
@@ -23,7 +23,7 @@
         SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
 
 
-        #region 鍒嗛〉鍒楄〃
+        #region 鍛樺伐绛惧埌璁板綍鍗� 鍒嗛〉鍒楄〃
         [Route("Sc_EmployeeSignInNoteBillController/GetListPage")]
         [HttpGet]
         public object GetListPage(string sWhere, string user)
@@ -95,7 +95,7 @@
 
 
 
-                ds = oCN.RunProcReturn("select a.*,b.HUnitID from h_v_Gy_MaterialPackingRelationList_Edit a left JOIN Gy_Material b on a.HMaterID=b.HItemID where HDefaultSendPackFlag=1 and 瀹℃牳浜�='' and  HMaterID in (" + ListMaterial + ")", "锘縣_v_Gy_MaterialPackingRelationList");
+                ds = oCN.RunProcReturn("select a.*,b.HUnitID from h_v_Gy_MaterialPackingRelationList_Edit a left JOIN Gy_Material b on a.HMaterID=b.HItemID where HDefaultSendPackFlag=1 and ISNULL(瀹℃牳浜�,'')<>'' and  HMaterID in (" + ListMaterial + ")", "锘縣_v_Gy_MaterialPackingRelationList");
 
 
                 //娣诲姞鍒楀悕
@@ -126,7 +126,7 @@
         #endregion
 
 
-        #region  淇濆瓨/缂栬緫
+        #region 鍛樺伐绛惧埌璁板綍鍗�   淇濆瓨/缂栬緫
 
         [Route("Sc_EmployeeSignInNoteBillController/SaveBill")]
         [HttpPost]
@@ -237,7 +237,7 @@
         #endregion
 
 
-        #region[缂栬緫鏃惰幏鍙栨暟鎹甝
+        #region[鍛樺伐绛惧埌璁板綍鍗� 缂栬緫鏃惰幏鍙栨暟鎹甝
         [Route("Sc_EmployeeSignInNoteBillController/Sc_EmployeeSignInNoteBilldetail")]
         [HttpGet]
         public ApiResult<DataSet> Sc_EmployeeSignInNoteBilldetail(string HID)
@@ -356,7 +356,7 @@
         {
             DataSet ds = oCN.RunProcReturn("select  * from h_v_Gy_EquipFileBill_KeyDown_PDA where 鏉″舰鐮�= '" + HBarCode+"'", "h_v_Gy_EquipFileBill_KeyDown_PDA");    
 
-            if (ds != null || ds.Tables.Count > 0)
+            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
             {
                     objJsonResult.code = "1";
                     objJsonResult.count = 1;
@@ -381,7 +381,7 @@
         {
             DataSet ds = oCN.RunProcReturn("exec  h_p_SB_HEquipHMould_Query '" + HInterID + "'", "h_p_SB_HEquipHMould_Query");
 
-            if (ds != null || ds.Tables.Count > 0)
+            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
             {
                 objJsonResult.code = "1";
                 objJsonResult.count = 1;
@@ -406,7 +406,7 @@
         {
             DataSet ds = oCN.RunProcReturn("exec  h_p_Sc_ICMOBillStatus_Tmp_QD '" + HInterID + "'", "h_p_Sc_ICMOBillStatus_Tmp_QD");
 
-            if (ds != null || ds.Tables.Count > 0)
+            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
             {
                 objJsonResult.code = "1";
                 objJsonResult.count = 1;
@@ -419,7 +419,7 @@
             {
                 objJsonResult.code = "0";
                 objJsonResult.count = 0;
-                objJsonResult.Message = "褰撳墠璁惧鏃犳ā鍏蜂俊鎭紒";
+                objJsonResult.Message = "褰撳墠璁惧鏃犲伐鍗曚俊鎭紒";
                 objJsonResult.data = null;
                 return objJsonResult;
             }

--
Gitblit v1.9.1