| | |
| | | decimal messageId = 0; |
| | | string taskCode = ""; |
| | | |
| | | // 根据条码查询XB_RACKING_TASK_SYXT_LOG表,查询max(PALLETCODE) |
| | | var maxPalletCode = Db.Queryable<XbRackingTaskSyxtLog>() |
| | | .Where(x => x.ItemBarcode == barcode) |
| | | .Max(x => x.PalletCode); |
| | | |
| | | try |
| | | { |
| | | // 1. 查询该条码对应的库存信息,按物料和批号汇总 |
| | |
| | | { |
| | | taskCode = taskCode, |
| | | taskType = "1", |
| | | palletCode = firstStock.StackCode ?? "", |
| | | palletCode = maxPalletCode ?? "", |
| | | widthType = "180", |
| | | station = "3" |
| | | }; |
| | |
| | | CreateDate = DateTime.Now, |
| | | TaskCode = taskCode, |
| | | TaskType = "立库出库请求", |
| | | PalletCode = firstStock.StackCode, |
| | | PalletCode = maxPalletCode, |
| | | WidthType = 180, |
| | | MaterialName = firstStock.ItemName, |
| | | MaterialCode = firstStock.ItemNo, |