public List <FabricQCGradeTestsViewModel> GetForSPP(string no)
{
IQueryable <FabricQCGradeTestsViewModel> data;
if (string.IsNullOrEmpty(no))
{
data = from qc in _repository.GetDbSet().AsNoTracking()
join dp in _dpSPPRepository.ReadAll()
on qc.DyeingPrintingAreaInputProductionOrderId equals dp.Id
select new FabricQCGradeTestsViewModel
{
OrderNo = qc.ProductionOrderNo,
OrderQuantity = dp.Balance
};
}
else
{
data = from fabricqc in _repository.GetDbSet().AsNoTracking()
join fabricgt in _fgtRepository.GetDbSet().AsNoTracking() on fabricqc.Id equals fabricgt.FabricQualityControlId
join dp in _dpSPPRepository.ReadAll()
on fabricqc.DyeingPrintingAreaInputProductionOrderId equals dp.Id
where fabricqc.ProductionOrderNo == no
select new FabricQCGradeTestsViewModel
{
OrderNo = fabricqc.ProductionOrderNo,
OrderQuantity = dp.Balance,
Grade = fabricgt.Grade
};
}
return(data.AsNoTracking().ToList());
}
public ListResult <InputInspectionMaterialProductionOrderViewModel> ReadProductionOrders(int page, int size, string filter, string order, string keyword)
{
var query = _productionOrderRepository.ReadAll();
List <string> SearchAttributes = new List <string>()
{
"ProductionOrderNo"
};
query = QueryHelper <DyeingPrintingAreaInputProductionOrderModel> .Search(query, SearchAttributes, keyword);
Dictionary <string, object> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(filter);
query = QueryHelper <DyeingPrintingAreaInputProductionOrderModel> .Filter(query, FilterDictionary);
Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(order);
query = QueryHelper <DyeingPrintingAreaInputProductionOrderModel> .Order(query, OrderDictionary);
var data = query.Skip((page - 1) * size).Take(size).Select(s => new InputInspectionMaterialProductionOrderViewModel()
{
Id = s.Id,
Balance = s.Balance,
BalanceRemains = s.BalanceRemains,
InputQuantity = s.InputQuantity,
Buyer = s.Buyer,
CartNo = s.CartNo,
BuyerId = s.BuyerId,
Color = s.Color,
Construction = s.Construction,
HasOutputDocument = s.HasOutputDocument,
IsChecked = s.IsChecked,
Motif = s.Motif,
PackingInstruction = s.PackingInstruction,
MaterialWidth = s.MaterialWidth,
FinishWidth = s.FinishWidth,
Material = new Material()
{
Id = s.MaterialId,
Name = s.MaterialName
},
YarnMaterial = new CommonViewModelObjectProperties.YarnMaterial()
{
Id = s.YarnMaterialId,
Name = s.YarnMaterialName
},
ProcessType = new CommonViewModelObjectProperties.ProcessType()
{
Id = s.ProcessTypeId,
Name = s.ProcessTypeName
},
Grade = s.Grade,
MaterialConstruction = new MaterialConstruction()
{
Name = s.MaterialConstructionName,
Id = s.MaterialConstructionId
},
ProductionOrder = new ProductionOrder()
{
Id = s.ProductionOrderId,
No = s.ProductionOrderNo,
Type = s.ProductionOrderType
},
Unit = s.Unit,
UomUnit = s.UomUnit,
DateIn = s.DateIn,
DateOut = s.DateOut,
MaterialOrigin = s.MaterialOrigin
});
return(new ListResult <InputInspectionMaterialProductionOrderViewModel>(data.ToList(), page, size, query.Count()));
}
public ListResult <InputShippingProductionOrderViewModel> ReadProductionOrders(int page, int size, string filter, string order, string keyword)
{
var query = _productionOrderRepository.ReadAll();
List <string> SearchAttributes = new List <string>()
{
"ProductionOrderNo"
};
query = QueryHelper <DyeingPrintingAreaInputProductionOrderModel> .Search(query, SearchAttributes, keyword);
Dictionary <string, object> FilterDictionary = JsonConvert.DeserializeObject <Dictionary <string, object> >(filter);
query = QueryHelper <DyeingPrintingAreaInputProductionOrderModel> .Filter(query, FilterDictionary);
Dictionary <string, string> OrderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(order);
query = QueryHelper <DyeingPrintingAreaInputProductionOrderModel> .Order(query, OrderDictionary);
var data = query.Skip((page - 1) * size).Take(size).Select(s => new InputShippingProductionOrderViewModel()
{
Id = s.Id,
DeliveryOrder = new DeliveryOrderSales()
{
Id = s.DeliveryOrderSalesId,
No = s.DeliveryOrderSalesNo
},
DeliveryOrderRetur = new DeliveryOrderRetur()
{
Id = s.DeliveryOrderReturId,
No = s.DeliveryOrderReturNo
},
ProductionOrder = new ProductionOrder()
{
Id = s.ProductionOrderId,
No = s.ProductionOrderNo,
OrderQuantity = s.ProductionOrderOrderQuantity,
Type = s.ProductionOrderType
},
MaterialWidth = s.MaterialWidth,
FinishWidth = s.FinishWidth,
Material = new Material()
{
Id = s.MaterialId,
Name = s.MaterialName
},
MaterialConstruction = new MaterialConstruction()
{
Name = s.MaterialConstructionName,
Id = s.MaterialConstructionId
},
ProcessType = new CommonViewModelObjectProperties.ProcessType()
{
Id = s.ProcessTypeId,
Name = s.ProcessTypeName
},
YarnMaterial = new CommonViewModelObjectProperties.YarnMaterial()
{
Id = s.YarnMaterialId,
Name = s.YarnMaterialName
},
Remark = s.Remark,
CartNo = s.CartNo,
Buyer = s.Buyer,
BuyerId = s.BuyerId,
Construction = s.Construction,
Color = s.Color,
Motif = s.Motif,
PackingType = s.PackagingType,
Grade = s.Grade,
QtyPacking = s.PackagingQty,
InputQtyPacking = s.InputPackagingQty,
Packing = s.PackagingUnit,
Qty = s.Balance,
InputQuantity = s.InputQuantity,
UomUnit = s.UomUnit,
PackingLength = s.PackagingLength,
HasOutputDocument = s.HasOutputDocument,
ProductSKUId = s.ProductSKUId,
FabricSKUId = s.FabricSKUId,
ProductSKUCode = s.ProductSKUCode,
HasPrintingProductSKU = s.HasPrintingProductSKU,
ProductPackingId = s.ProductPackingId,
FabricPackingId = s.FabricPackingId,
ProductPackingCode = s.ProductPackingCode,
HasPrintingProductPacking = s.HasPrintingProductPacking,
DateIn = s.DateIn
});
return(new ListResult <InputShippingProductionOrderViewModel>(data.ToList(), page, size, query.Count()));
}
public List <InputAvalTransformationProductionOrderViewModel> GetInputAvalProductionOrders(string avalType)
{
var productionOrders = _inputProductionOrderRepository.ReadAll().OrderByDescending(s => s.LastModifiedUtc)
.Where(s => s.Area == DyeingPrintingArea.GUDANGAVAL && !s.HasOutputDocument && !s.DyeingPrintingAreaInput.IsTransformedAval && s.AvalType == avalType);
var data = productionOrders.Select(s => new InputAvalTransformationProductionOrderViewModel()
{
Id = s.Id,
Machine = s.Machine,
ProductionOrder = new ProductionOrder()
{
Id = s.ProductionOrderId,
No = s.ProductionOrderNo,
OrderQuantity = s.ProductionOrderOrderQuantity,
Type = s.ProductionOrderType
},
MaterialWidth = s.MaterialWidth,
FinishWidth = s.FinishWidth,
Material = new Material()
{
Id = s.MaterialId,
Name = s.MaterialName
},
MaterialConstruction = new MaterialConstruction()
{
Name = s.MaterialConstructionName,
Id = s.MaterialConstructionId
},
ProcessType = new CommonViewModelObjectProperties.ProcessType()
{
Id = s.ProcessTypeId,
Name = s.ProcessTypeName
},
YarnMaterial = new CommonViewModelObjectProperties.YarnMaterial()
{
Id = s.YarnMaterialId,
Name = s.YarnMaterialName
},
Buyer = s.Buyer,
BuyerId = s.BuyerId,
Construction = s.Construction,
Color = s.Color,
Motif = s.Motif,
Unit = s.Unit,
UomUnit = s.UomUnit,
InputId = s.DyeingPrintingAreaInputId,
AvalType = s.AvalType,
BonNo = s.DyeingPrintingAreaInput.BonNo,
CartNo = s.CartNo,
Quantity = s.Balance,
InputQuantity = s.Balance,
ProductSKUId = s.ProductSKUId,
FabricSKUId = s.FabricSKUId,
ProductSKUCode = s.ProductSKUCode,
HasPrintingProductSKU = s.HasPrintingProductSKU,
ProductPackingId = s.ProductPackingId,
FabricPackingId = s.FabricPackingId,
ProductPackingCode = s.ProductPackingCode,
HasPrintingProductPacking = s.HasPrintingProductPacking
});
return(data.ToList());
}