From d2566b35bf5e917374d7556119d42cd404f16335 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期五, 20 五月 2022 23:07:28 +0800 Subject: [PATCH] 开班+墙咔 --- WebAPI/WebServer.cs | 29 +++++++++++++++++++++++++++++ 1 files changed, 29 insertions(+), 0 deletions(-) diff --git a/WebAPI/WebServer.cs b/WebAPI/WebServer.cs index 897c588..9e2f5af 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(); @@ -7972,5 +7994,12 @@ return dal.GetKf_ICStockBillList(sHBillType, HMaker, HOrgID); } + //杩斿洖缂撳瓨鍒楄〃鏌ヨ宸蹭笂浼犲垪琛ㄤ俊鎭� + public DataSet GetQueryBillUpdateLoad_Json(string BillType, string HBillNo, string HSourceBillNo) + { + DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View(); + return dal.GetKf_ICStockBillQueryList(BillType, HBillNo, HSourceBillNo); + } + } } \ No newline at end of file -- Gitblit v1.9.1