From bf43b2754aa2e3bcb36c9a8dd050cad07849e421 Mon Sep 17 00:00:00 2001 From: yxj <1qaz@123> Date: 星期二, 29 三月 2022 14:59:07 +0800 Subject: [PATCH] 增加瑞与祺服务器文件IP地址 --- 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