public void PomeloMysqlTest()
{
using var db = new NewShipContext(new DbContextOptions <NewShipContext>());
var query = from ow in db.ow_surcharge
join dtl in db.ow_surcharge_detail.Where(q => q.DELETE_MARK == false) on ow.OW_SURCHARGE_ID equals dtl.OW_SURCHARGE_ID into dtls
where ow.CARRIER_ID == 9001 &&
ow.OW_SURCHARGE_ID == 21
select new OwSurchargeBrief
{
Id = ow.OW_SURCHARGE_ID,
EffectiveDate = ow.EFFECTIVE_DATE,
ExpirationDate = ow.EXPIRATION_DATE,
OwType = ow.OW_TYPE,
PolId = ow.POL_ID,
RouteId = ow.ROUTE_ID,
Remark = ow.REMARK,
Details = dtls.Select(q => new OwSurchargeDetailBrief
{
Id = q.OW_SURCHARGE_DETAIL_ID,
BeginWeight = q.BEGIN_WEIGHT,
EndWeight = q.END_WEIGHT,
Remark = q.REMARK,
Surcharge = q.SURCHARGE_AMOUNT,
ContaSizeType = q.CONTA_SIZETYPE,
})
};
var result = query.ToList().FirstOrDefault();
}
public void PomeloMysqlTest3()
{
using var db = new NewShipContext(new DbContextOptions <NewShipContext>());
var query = from ow in db.ow_surcharge
where ow.CARRIER_ID == 9001 &&
ow.OW_SURCHARGE_ID == 21
select new OwSurchargeBrief
{
Id = ow.OW_SURCHARGE_ID,
EffectiveDate = ow.EFFECTIVE_DATE,
ExpirationDate = ow.EXPIRATION_DATE,
OwType = ow.OW_TYPE,
PolId = ow.POL_ID,
RouteId = ow.ROUTE_ID,
Remark = ow.REMARK,
Details = db.ow_surcharge_detail.Where(q => q.DELETE_MARK == false && q.OW_SURCHARGE_ID == ow.OW_SURCHARGE_ID).Select(q => new OwSurchargeDetailBrief
{
Id = q.OW_SURCHARGE_DETAIL_ID,
BeginWeight = q.BEGIN_WEIGHT,
EndWeight = q.END_WEIGHT,
Remark = q.REMARK,
Surcharge = q.SURCHARGE_AMOUNT,
ContaSizeType = q.CONTA_SIZETYPE,
}),
ApplyToPods = db.ow_surcharge_port.Where(q => q.DELETE_MARK == false && q.OW_SURCHARGE_ID == ow.OW_SURCHARGE_ID).Select(q => new OwSurchargePortBrief
{
Id = q.OW_SURCHARGE_PORT_ID,
Pod = new SimpleLocation
{
LocationId = q.POD_ID
}
}),
ApplyToSchedules = db.ow_surcharge_schedule.Where(q => q.DELETE_MARK == false && q.OW_SURCHARGE_ID == ow.OW_SURCHARGE_ID).Select(q => new OwSurchargeScheduleBrief
{
Id = q.OW_SURCHARGE_SCHEDULEL_ID,
Etd = q.ETD,
ScheduleId = q.SCHEDULE_ID,
VesselVoyage = q.VESSELVOY,
})
};
var result = query.ToList().FirstOrDefault();
}
