public List <cstStationToatlPacked> GetEachStationPacked(DateTime DateReport)
{
List <cstStationToatlPacked> _lsStationPacked = new List <cstStationToatlPacked>();
try
{
var vStationPacked = from station in lent.Stations
join pack in lent.Packages
on station.StationID equals pack.StationID
where EntityFunctions.TruncateTime(pack.StartTime) == EntityFunctions.TruncateTime(DateReport)
group pack by station.StationID into GStationPack
select new
{
StationID = GStationPack.Key,
StaionName = GStationPack.FirstOrDefault(i => i.Station.StationName != null).Station.StationName,
PackedCount = GStationPack.Count(i => i.PackingStatus == 0),
PartiallyPacked = GStationPack.Count(i => i.PackingStatus == 1)
};
foreach (var item in vStationPacked)
{
cstStationToatlPacked _spacked = new cstStationToatlPacked();
_spacked.StationID = item.StationID;
_spacked.StationName = item.StaionName;
_spacked.TotalPacked = item.PackedCount;
_spacked.PartiallyPacked = item.PartiallyPacked;
_lsStationPacked.Add(_spacked);
}
}
catch (Exception)
{ }
return(_lsStationPacked);
}
public List <cstStationToatlPacked> GetEachStationPacked(DateTime DateReport)
{
List <cstStationToatlPacked> _lsStationPacked = new List <cstStationToatlPacked>();
try
{
var vStationPacked = Service.Get.GetEachStationPacked1(DateReport);
foreach (var item in vStationPacked)
{
cstStationToatlPacked _spacked = new cstStationToatlPacked();
_spacked.StationID = item.StationID;
_spacked.StationName = item.StationName;
_spacked.TotalPacked = item.TotalPacked;
_spacked.PartiallyPacked = item.PartiallyPacked;
_lsStationPacked.Add(_spacked);
}
}
catch (Exception)
{ }
return(_lsStationPacked);
}
