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