From 766ca8c6bfe27bc5d025ebf04ccdfb807ea65662 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期五, 27 五月 2022 19:13:56 +0800
Subject: [PATCH] 完善
---
WebAPI/WebServer.cs | 42 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 42 insertions(+), 0 deletions(-)
diff --git a/WebAPI/WebServer.cs b/WebAPI/WebServer.cs
index 897c588..72f7147 100644
--- a/WebAPI/WebServer.cs
+++ b/WebAPI/WebServer.cs
@@ -3841,6 +3841,28 @@
}
}
+ //鏍规嵁鎵樻潯鐮� 鑾峰彇鏉＄爜妗ｆ鍒楄〃鍞竴鐮佷俊鎭�
+ 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();
@@ -4349,6 +4371,19 @@
return bll.GetKf_PonderationBillMain_Temp(HInterID, sBillType,sWhere,ref DBUtility.ClsPub.sExeReturnInfo);
//DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
//return dal.GetInfoByID_View(HInterID, sBillType, sWhere);
+ }
+
+ public bool Get_CheckQtyByBarCode(string sBarcode, long HWHID, long HSPID, long HAuxPropID, string sBatchNo, string HMTONo, double sQty, ref double sRelQty)
+ {
+ DAL.ClsKF_PonderationBillMain_Temp_View dal = new DAL.ClsKF_PonderationBillMain_Temp_View();
+ if (dal.CheckQtyByBarCode(sBarcode, HWHID, HSPID, HAuxPropID, sBatchNo, HMTONo, sQty, ref sRelQty))
+ {
+ return true;
+ }
+ else
+ {
+ return false;
+ }
}
public DataSet GetSPInfoByIDandHWHIDandOrg(long sItemID, long sHWHID, long HUSEORGID, ref string sErrMsg)
@@ -7972,5 +8007,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