From 06bf635016c8cdd691fac8cda56d6b50915a4996 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期四, 18 五月 2023 08:44:32 +0800
Subject: [PATCH] 流转卡、生产订单、工序进站单、工序出站单只能自己删除自己的单据。(所有模块,做个系统参数,删除人和制单人必须一致) 流转卡列表批量删除批量删除(会误操作),删除的时候先根据生产订单去过滤

---
 WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs b/WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs
index faa72bb..76a04e3 100644
--- a/WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs
+++ b/WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs
@@ -648,7 +648,7 @@
         public DataTable getInfodatanow(string hsoucreID)
         {
             SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
-            string sql = $" select HMacAddr, runStu, countAll from Gy_Source t1  left join HX_LIOTsys..Info_data_now t2 on t1.HMacAddr = t2.hid where t1.hitemid={hsoucreID}";
+            string sql = $" select HMacAddr, isnull(runStu,'')runStu, isnull(countAll,0)countAll from Gy_Source t1  left join HX_LIOTsys..Info_data_now t2 on t1.HMacAddr = t2.hid where t1.hitemid={hsoucreID}";
             DataTable dt = oCn.RunProcReturn(sql, "dt").Tables[0];
             return dt;
         }

--
Gitblit v1.9.1