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); }