From 466e6a2a0f3363cadaf24296c9285a57aafc078a Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期一, 11 七月 2022 13:58:03 +0800 Subject: [PATCH] nothing --- 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