| | |
| | | //using SqlSugar.Extensions; |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | |
| | | { |
| | | return BaseDal.QueryFirst(x => SerialNumbers.Contains(x.SerialNumber)) != null; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®æ¹æ¬¡å·ååæ®å·è·ååºåæç»ä¿¡æ¯ |
| | | /// </summary> |
| | | /// <param name="OrderNo">订åå·</param> |
| | | /// <param name="BatchNo">æ¹æ¬¡å·</param> |
| | | /// <returns></returns> |
| | | public Dt_StockInfoDetail Get_StockInfoDetail(string OrderNo, string BatchNo = null) |
| | | public Dt_StockInfoDetail? Get_StockInfoDetail(string OrderNo, string BatchNo = null) |
| | | { |
| | | Dt_StockInfoDetail stockInfoDetail = null; |
| | | Dt_StockInfoDetail? stockInfoDetail = null; |
| | | if (BatchNo != null) |
| | | { |
| | | stockInfoDetail = BaseDal.QueryFirst(x => x.OrderNo == OrderNo && x.BatchNo == BatchNo && (x.Status == StockStatusEmun.å
¥åºä¸.ObjToInt() || x.Status == StockStatusEmun.å·²å
¥åº.ObjToInt())); |
| | | stockInfoDetail = BaseDal.QueryData(x => x.OrderNo == OrderNo && x.BatchNo.Contains(BatchNo) && (x.Status == StockStatusEmun.å
¥åºä¸.ObjToInt() || x.Status == StockStatusEmun.å·²å
¥åº.ObjToInt())).OrderByDescending(x => x.ModifyDate).FirstOrDefault(); |
| | | } |
| | | else |
| | | { |
| | | stockInfoDetail = BaseDal.QueryFirst(x => x.OrderNo == OrderNo && (x.Status == StockStatusEmun.å
¥åºä¸.ObjToInt() || x.Status == StockStatusEmun.å·²å
¥åº.ObjToInt())); |
| | | stockInfoDetail = BaseDal.QueryData(x => x.OrderNo == OrderNo && (x.Status == StockStatusEmun.å
¥åºä¸.ObjToInt() || x.Status == StockStatusEmun.å·²å
¥åº.ObjToInt())).OrderByDescending(x => x.ModifyDate).FirstOrDefault(); |
| | | } |
| | | return stockInfoDetail; |
| | | } |