| | |
| | | { |
| | | try |
| | | { |
| | | List<Dt_PurchaseOrderDetail> purchaseOrderDetails = BaseDal.QueryData(x => x.WarehouseId == warehouseId && x.PurchaseDetailStatus != PurchaseOrderDetailStatusEnum.Received.ObjToInt()); |
| | | List<Dt_PurchaseOrderDetail> purchaseOrderDetails = BaseDal.QueryData(x => x.WarehouseId == warehouseId && x.PurchaseDetailStatus != PurchaseOrderDetailStatusEnum.Received.ObjToInt() && x.PurchaseDetailStatus != PurchaseOrderDetailStatusEnum.Closed.ObjToInt()); |
| | | List<string> MaterielCodes = purchaseOrderDetails.Select(x => x.MaterielCode).ToList(); |
| | | MaterielCodes = MaterielCodes.Distinct().ToList(); |
| | | return WebResponseContent.Instance.OK(data: MaterielCodes); |
| | |
| | | { |
| | | try |
| | | { |
| | | List<Dt_PurchaseOrderDetail> purchaseOrderDetails = BaseDal.QueryData(x => x.MaterielCode == materielCode && x.PurchaseDetailStatus != PurchaseOrderDetailStatusEnum.Received.ObjToInt()); |
| | | List<Dt_PurchaseOrderDetail> purchaseOrderDetails = BaseDal.QueryData(x => x.MaterielCode == materielCode && x.PurchaseDetailStatus != PurchaseOrderDetailStatusEnum.Received.ObjToInt()&& x.PurchaseDetailStatus!=PurchaseOrderDetailStatusEnum.Closed.ObjToInt()); |
| | | List<int> PurchaseOrderIds = purchaseOrderDetails.Select(x => x.PurchaseOrderId).ToList(); |
| | | List<Dt_PurchaseOrder> purchaseOrders = BaseDal.Db.Queryable<Dt_PurchaseOrder>().Where(x => PurchaseOrderIds.Contains(x.Id)).ToList(); |
| | | List<string> PurchaseOrderNos = purchaseOrders.Select(x => x.PurchaseOrderNo).ToList(); |