public static decimal GetTroughNextUnFinished(string throughno, int orderCount)
{
decimal total = 0;
using (Entities entity = new Entities())
{
T_PRODUCE_SORTTROUGH info = SortTroughService.GetFJTroughInfo(10, throughno, 20);
var query = (from item in entity.T_PRODUCE_POKE
// where item.TROUGHNUM == throughno
where item.SORTSTATE != 20 && item.GROUPNO == info.GROUPNO
orderby item.SORTNUM
select item).ToList();
if (query != null)
{
total = query.Take(orderCount).Sum(p => p.POKENUM) ?? 0;
}
return(total);
}
}
public static decimal GetTroughFirstUnFinished(string throughno)
{
decimal total = 0;
using (Entities entity = new Entities())
{
T_PRODUCE_SORTTROUGH info = SortTroughService.GetFJTroughInfo(10, throughno, 20);
var query = (from item in entity.T_PRODUCE_POKE
// where item.TROUGHNUM == throughno
where item.SORTSTATE != 20 && item.GROUPNO == info.GROUPNO orderby item.SORTNUM
select item).FirstOrDefault();
if (query != null)
{
var query2 = (from item in entity.T_PRODUCE_POKE where item.SORTNUM == query.SORTNUM && item.TROUGHNUM == throughno select item).FirstOrDefault();
if (query2 != null)
{
total = query2.POKENUM ?? 0;
}
}
return(total);
}
}