| | |
| | | //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"; |