| | |
|---|
| | | using System.Data; |
|---|
| | | using System.Data.SqlClient; |
|---|
| | | using System.Threading.Tasks.Dataflow; |
|---|
| | | using Masuit.Tools; |
|---|
| | | using NewPdaSqlServer.DB; |
|---|
| | | using NewPdaSqlServer.Dto.service; |
|---|
| | |
|---|
| | | // 获取补料单明细并校验 |
|---|
| | | var blDetail = Db.Queryable<MesItemBlDetail>() |
|---|
| | | .Where(b => |
|---|
| | | b.Mid == mesItemBl.Id && b.Bld012 == stockBarcode.ItemId) |
|---|
| | | b.Mid == mesItemBl.Id && b.Bld012 == stockBarcode.ItemId && b.Bld007 > b.Bld008) |
|---|
| | | .First(); |
|---|
| | | |
|---|
| | | if (blDetail == null) |
|---|
| | |
|---|
| | | ErpAutoid = womdab.Erpid, |
|---|
| | | PbillNo = query.billNo, |
|---|
| | | ItemId = blDetail.Bld012, |
|---|
| | | DepotId = stockBarcode.DepotsId.ToString(), |
|---|
| | | ItemDabid = womdab.Id, |
|---|
| | | DepotId = stockBarcode.DepotId.ToString(), |
|---|
| | | ItemDabid = blDetail.Id, |
|---|
| | | //AboutGuid = womdab.Id |
|---|
| | | // Unit = blDetail.Bld009, |
|---|
| | | // DepotId = (int)stockBarcode.DepotsId |
|---|
| | | }).IgnoreColumns(true).ExecuteCommand(); |
|---|
| | |
|---|
| | | |
|---|
| | | // 创建 插入日志 |
|---|
| | | var logService = new LogService(); |
|---|
| | | var LogMsg = "[PDA]"+query.Type + "。条码【" +query.barcode+"】 出库单号【"+ outNo +"】"; |
|---|
| | | var LogMsg = "[PDA]"+query.Type + "。条码【" +query.barcode+"】 数量【"+ stockBarcode.Quantity.ToString() + "】 出库单号【"+ outNo +"】"; |
|---|
| | | logService.CreateLog(db,query.userName,wwgd.Id.ToString(), "WW_GD", LogMsg,wwgd.Daa001); |
|---|
| | | |
|---|
| | | return 1; |
|---|
