| | |
| | | .Where(it => it.InsDate.Value.ToString("yyyy-MM-dd") == DateTime.Now.ToString("yyyy-MM-dd") |
| | | && it.Status == 0 |
| | | && it.TransctionNo == transactionNo |
| | | && it.CbillNo == itemBarcodeDetails.BillNo |
| | | && it.BillTypeId == billTypeId |
| | | && it.TaskNo == itemBarcodeDetails.BillNo |
| | | && it.DepotsCode == mesDepost.DepotCode) |
| | | .Select(it => new |
| | | { |
| | |
| | | Status = 0, |
| | | ReceiveOrgId = inventory.ReceiveOrgId, |
| | | InType = "采购入库", |
| | | TaskNo = itemBarcodeDetails.BillNo |
| | | //WorkNo = itemBarcodeDetails.WorkNo |
| | | }).IgnoreColumns(true).ExecuteCommand(); |
| | | } |
| | |
| | | Remark = itemBarcodeDetails.Memo, |
| | | EbelnK3id = detail.EbelnK3id, |
| | | LineK3id = detail.LineK3id, |
| | | DepotId = depotCode2 |
| | | DepotId = depotCode2, |
| | | itemDabid = itemBarcodeDetails.AboutGuid.ToString() |
| | | }).IgnoreColumns(true).ExecuteCommand(); |
| | | else |
| | | db.Updateable<MesInvItemInCItems>() |
| | |
| | | EbelnK3id = itemBarcodeDetails.EbelnK3id, |
| | | LineK3id = itemBarcodeDetails.LineK3id, |
| | | ItemId = itemBarcodeDetails.ItemId, |
| | | DepotId = depotCode2 |
| | | DepotId = depotCode2, |
| | | itemDabid = itemBarcodeDetails.AboutGuid.ToString() |
| | | }).IgnoreColumns(true).ExecuteCommand(); |
| | | else |
| | | // 存在时更新数量 |