From 52843c5560ea2e91b8f79c7ce28b762aadf3ee7a Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期四, 30 六月 2022 12:26:29 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/POStockInBillController.cs | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/POStockInBillController.cs b/WebAPI/Controllers/POStockInBillController.cs index 1d55230..e180af3 100644 --- a/WebAPI/Controllers/POStockInBillController.cs +++ b/WebAPI/Controllers/POStockInBillController.cs @@ -1232,13 +1232,13 @@ //PDA閿�鍞嚭搴撴暣鎵樺垹闄� [Route("POStockInBillList/SellOutBillSDeleCode")] [HttpGet] - public object SellOutBillSDeleCode(string HBarCode) + public object SellOutBillSDeleCode(string HBarCode,string HInterID) { try { //鏍规嵁鏉$爜鍦ㄦ潯鐮佹。妗堜腑鎵惧埌瀵瑰簲鐨勬墭鏉$爜锛屽啀鍦ㄤ复鏃惰〃涓垹闄よ鎵樻潯鐮佺殑鍏ㄩ儴璁板綍 - string sql = string.Format(@"delete from KF_PonderationBillMain_Temp where HBillType=1205 and - HBarCode_Pack=(select HBarcodeNo from Gy_BarCodeBill where HBarCode='"+ HBarCode + "')"); + string sql = string.Format(@"delete from KF_PonderationBillMain_Temp where HBillType=1205 and HInterID=" + HInterID + " and HBarCode" + + " in (select HBarCode from Gy_BarCodeBill where HBarCode_Pack = (select HBarCode_Pack from Gy_BarCodeBill where HBarCode = '"+ HBarCode + "'))"); oCn.RunProc(sql); objJsonResult.code = "1"; -- Gitblit v1.9.1