public List <cstPalletInfo> GetPalletInfoBySHNumber(String SHnumber)
{
List <cstPalletInfo> _lspallet = new List <cstPalletInfo>();
//cstPalletInfo palletInfo = new cstPalletInfo();
try
{
var pallet = entx3v6.ExecuteStoreQuery <cstPalletInfo>(@"select p.PalletNumber,p.PrintStatus from palletinfo p join
PalletDetail pd on p.PalletID = pd.palletID
where ShipmentNumber='" + SHnumber + "'group by p.PalletNumber,p.PrintStatus;").ToList();
foreach (var item in pallet)
{
cstPalletInfo _palletInfo = new cstPalletInfo();
_palletInfo.PrintStatus = item.PrintStatus;
_palletInfo.PalletNumber = item.PalletNumber;
//_lspallet
_lspallet.Add(_palletInfo);
}
}
catch (Exception)
{
}
return(_lspallet);
}