From f3e1b2eac8a806b3ae8d5a8854d694204e2468ad Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期五, 25 三月 2022 10:58:44 +0800
Subject: [PATCH] 墙咔装箱2.0

---
 WebAPI/WebServer.cs |   22 ++++++++++++++++++++++
 1 files changed, 22 insertions(+), 0 deletions(-)

diff --git a/WebAPI/WebServer.cs b/WebAPI/WebServer.cs
index 897c588..042e936 100644
--- a/WebAPI/WebServer.cs
+++ b/WebAPI/WebServer.cs
@@ -3841,6 +3841,28 @@
             }
         }
 
+        //鏍规嵁鎵樻潯鐮�  鑾峰彇鏉$爜妗f鍒楄〃鍞竴鐮佷俊鎭�
+        public DataSet GetBarCode(string HBarCode)
+        {
+            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+            //
+            try
+            {
+                DataSet DS = oCn.RunProcReturn("select HBarCode,HQty from Sc_PackUnionBillSub where HBarCode_Pack ='" + HBarCode.ToString() + "'", "Sc_PackUnionBillSub", ref DBUtility.ClsPub.sExeReturnInfo);
+                //DataSet DS = oCn.RunProcReturn("Select * from h_v_Sc_AssemblyBill Where HInterID=" + HInterID.ToString() + " and HBillType='" + sBillType + "' " + sWhere, "h_v_Sc_AssemblyBill", ref DBUtility.ClsPub.sExeReturnInfo);
+                if (DS.Tables[0].Rows.Count == 0)
+                    return null;
+                else
+                {
+                    return DS;
+                }
+            }
+            catch (Exception e)
+            {
+                throw (e);
+            }
+        }
+
         public DataSet GetHBW(long HBadType)
         {
             SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();

--
Gitblit v1.9.1