| | |
| | | /// 获取生产补料单号列表 |
| | | /// </summary> |
| | | /// <returns>补料单号列表</returns> |
| | | public List<string> GetSCBLBillNo() |
| | | public List<string> GetSCBLBillNo(WarehouseQuery query) |
| | | { |
| | | var list = Db.Queryable<MesItemBl>() |
| | | .Where(s => (s.Bl018 ?? false) == true |
| | | && (s.Bl019 ?? false) == false |
| | | && s.Bl008 == "生产补料") |
| | | && s.Bl008 == query.type) |
| | | .Select(s => s.BlNo) |
| | | .ToList(); |
| | | return list; |
| | |
| | | // Mblnr = stockBarcode.Mblnr, |
| | | // Zeile = stockBarcode.Zeile, |
| | | // RohInId = stockBarcode.RohInId, |
| | | // BarcodeStatus = 0, |
| | | // OldQty = query.Num, |
| | | Barcodestatus = false, |
| | | Oldqty = query.Num as long?, |
| | | // Unit = stockBarcode.Unit, |
| | | // WeightUnit = stockBarcode.WeightUnit, |
| | | Factory = stockBarcode.Factory, |
| | |
| | | // MemoBad = stockBarcode.MemoBad, |
| | | ComeFlg = 5, |
| | | // Memo = stockBarcode.Memo, |
| | | SuppId = stockBarcode.SuppId, |
| | | SuppNo = stockBarcode.SuppNo, |
| | | // InsDate = stockBarcode.InsDate, // Added InsDate |
| | | InsDate = stockBarcode.IndepDate, // Added InsDate |
| | | ItemId = stockBarcode.ItemId |
| | | // ItemUnit = stockBarcode.ItemUnit // Added ItemUnit |
| | | }).IgnoreColumns(true).ExecuteCommand(); |
| | |
| | | |
| | | #region 生产超领 |
| | | |
| | | public List<string> GetSccList() |
| | | public List<string> GetSccList(WarehouseQuery query) |
| | | { |
| | | var list = Db.Queryable<MesItemBl>() |
| | | .Where(s => (s.Bl018 ?? false) == true |
| | | && (s.Bl019 ?? false) == false |
| | | && s.Bl008 == "生产超领") |
| | | && s.Bl008 == query.type) |
| | | .Select(s => s.BlNo) |
| | | .ToList(); |
| | | return list; |