public static void GetSortFinish()
{
using (DZEntities en = new DZEntities())
{
T_UN_POKE_HUNHE hunhe = en.T_UN_POKE_HUNHE.Where(item => item.PULLSTATUS == 1).OrderBy(item => item.SORTNUM).FirstOrDefault();
if (hunhe != null)
{
decimal status = en.T_UN_POKE.Where(item => item.SORTNUM == hunhe.SORTNUM).Select(item => item.STATUS).FirstOrDefault() ?? 0;
if (status == 20)
{
hunhe.PULLSTATUS = 2;
en.SaveChanges();
}
}
}
}
public static bool InsertPokeMixed(List <MixedInfo> infos)
{
using (DZEntities en = new DZEntities())
{
T_UN_POKE_HUNHE tph = new T_UN_POKE_HUNHE();
decimal id = 0;
try
{
id = en.T_UN_POKE_HUNHE.Max(item => item.ID);
}
catch
{
id = 0;
}
foreach (var info in infos)
{
id = id + 1;
if (info.PokeNum > 1)
{
for (int j = 0; j < info.PokeNum; j++)
{
tph = new T_UN_POKE_HUNHE()
{
CIGARETTECODE = info.CigaretteCode,
MACHINESEQ = info.MachineSeq,
PACKMACHINESEQ = info.PackageMachineSeq,
POKEID = info.PokeID,
PULLSTATUS = info.PullStatus,
SENDTASKNUM = info.SendTasNum,
SORTNUM = info.SortNum,
TASKNUM = info.TaskNum,
TROUGHNUM = Convert.ToDecimal(info.ThroughNum),
ID = id
};
en.T_UN_POKE_HUNHE.AddObject(tph);
id = id + 1;
en.SaveChanges();
}
}
else
{
tph = new T_UN_POKE_HUNHE()
{
CIGARETTECODE = info.CigaretteCode,
MACHINESEQ = info.MachineSeq,
PACKMACHINESEQ = info.PackageMachineSeq,
POKEID = info.PokeID,
PULLSTATUS = info.PullStatus,
SENDTASKNUM = info.SendTasNum,
SORTNUM = info.SortNum,
TASKNUM = info.TaskNum,
TROUGHNUM = Convert.ToDecimal(info.ThroughNum),
ID = id
};
en.T_UN_POKE_HUNHE.AddObject(tph);
en.SaveChanges();
}
}
return(en.SaveChanges() > 0);
}
}
