public ActionResult GetBillOfLadingListA() { var pl = _unit.ExpBillOfLadingRepository.Get().Select(ob => new { ob.BLID, ob.BLNo, ob.RefBLNo, ob.Shipper, ShipperCode = ob.Shipper == null ? "" : _unit.SysBuyerRepository.GetByID(ob.Shipper).BuyerCode, ShipperName = ob.Shipper == null ? "" : _unit.SysBuyerRepository.GetByID(ob.Shipper).BuyerName, BLDate = string.Format("{0:dd/MM/yyyy}", ob.BLDate), ob.CIID, CINo = ob.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).CINo, CIRefNo = ob.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).CIRefNo, CIDate = ob.CIID == null ? "" : string.Format("{0:dd/MM/yyyy}", _unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).CIDate), OrdDeliveryMode = ob.CIID == null ? "" : DalCommon.ReturnOrderDeliveryMode( _unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).OrdDeliveryMode), ShipmentFrom = ob.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).ShipmentFrom, ShipmentTo = ob.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(ob.CIID).ShipmentTo, RecordStatus = ob.CIID == null ? "" : DalCommon.ReturnRecordStatus(_unit.ExpBillOfLadingRepository.GetByID(ob.BLID).RecordStatus) }).ToList(); return(Json(pl.OrderByDescending(ob => ob.BLID), JsonRequestBehavior.AllowGet)); }
public ActionResult GetComInv() { var comInv = _unit.ExpCommercialInvoiceRepository.Get().ToList(); var result = comInv.Select(inv => new { inv.CIID, inv.CINo, inv.CIRefNo, CIDate = string.Format("{0:dd/MM/yyyy}", inv.CIDate), OrdDeliveryMode = DalCommon.ReturnOrderDeliveryMode(inv.OrdDeliveryMode), RecordStatus = DalCommon.ReturnRecordStatus(inv.RecordStatus) }); return(Json(result.OrderByDescending(ob => ob.CIID), JsonRequestBehavior.AllowGet)); }
public ActionResult GetBolById(long id) { var bol = _unit.ExpBillOfLadingRepository.GetByID(id); var result = new { bol.BLID, bol.BLNo, bol.RefBLNo, BLDate = string.Format("{0:dd/MM/yyyy}", bol.BLDate), bol.CIID, CINo = bol.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(bol.CIID).CINo, CIRefNo = bol.CIID == null ? "" : _unit.ExpCommercialInvoiceRepository.GetByID(bol.CIID).CIRefNo, OrdDeliveryMode = bol.CIID == null ? "" : DalCommon.ReturnOrderDeliveryMode( _unit.ExpCommercialInvoiceRepository.GetByID(bol.CIID).OrdDeliveryMode), CIDate = bol.CIID == null ? "" : string.Format("{0:dd/MM/yyyy}", _unit.ExpCommercialInvoiceRepository.GetByID(bol.CIID).CIDate), //bol.PLID, //PLNo = bol.PLID == null ? "" : _unit.ExpPackingListRepository.GetByID(bol.PLID).PLNo, ShippedOnBoardDate = string.Format("{0:dd/MM/yyyy}", bol.ShippedOnBoardDate), ExpectedArrivalTime = string.Format("{0:dd/MM/yyyy}", bol.ExpectedArrivalTime), bol.Shipper, ShipperName = bol.Shipper == null ? "" : _unit.SysBuyerRepository.GetByID(bol.Shipper).BuyerName, bol.ShipmentMode, bol.VesselName, bol.VoyageNo, bol.TransShipmentPort, TransShipmentPortName = bol.TransShipmentPort == null ? "" : _unit.SysPortRepository.GetByID(bol.TransShipmentPort).PortName, bol.ShipmentPort, ShipmentPortName = bol.ShipmentPort == null ? "" : _unit.SysPortRepository.GetByID(bol.ShipmentPort).PortName, bol.BLNote, bol.RecordStatus, Container = _unit.ExpBillOfLadingContainerRepository.Get().Where(ob => ob.BLID == bol.BLID).Select(cont => new { cont.BLCcntID, cont.BLID, cont.ContainerNo, cont.ContainerType, cont.SealNo, cont.PackageQty, cont.GrossWeight, cont.Measurement }).ToList() }; return(Json(result, JsonRequestBehavior.AllowGet)); }