我在代码
List<实体名> list = new List<实体名>();
try
{
//查询xx表中的工位号与xx表中的对应的数据
var v = sortingEntity.表名.Where(a => a.station == null).Where(s => s.dps_date == time).Distinct();
foreach (var item in v)
{
var vlist = (from ss in wmsEntity.表名1
from sa in wmsEntity.表名2
where ss.SC_sendlines == sa.SL_id && ss.SC_code == item.comm_no
orderby ss.SC_name, sa.SL_name
select new 实体名
{
orderbarcode = item.orderbarcode,
ordercode = item.ordercode,
dps_time = item.dps_time,
Community = ss.SC_name,
Line = sa.SL_name
}
).ToList().Distinct();
list.Add(); }