| | |
| | | |
| | | } |
| | | #endregion |
| | | |
| | | #region PDA销售出库 |
| | | //PDA销售出库整托删除 |
| | | [Route("POStockInBillList/SellOutBillSDeleCode")] |
| | | [HttpGet] |
| | | public object SellOutBillSDeleCode(string HBarCode,string HInterID) |
| | | { |
| | | try |
| | | { |
| | | //根据条码在条码档案中找到对应的托条码,再在临时表中删除该托条码的全部记录 |
| | | 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"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "整托删除成功!"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有返回任何记录!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | } |
| | | #endregion |
| | | } |
| | | } |