[HttpGet]
//详情
public async Task<ActionResult<BTL.Zuzhangyitianzuowanxiangmu>> ShowDe(int tid)
{
BTL.Zuzhangyitianzuowanxiangmu st = (from s in MeeTingContext.Matnr
join p in MeeTingContext.Material on s.MaterialType equals p.MaterialTypeId
join d in MeeTingContext.Typedong on s.MaterialUses equals d.Tid
join e in MeeTingContext.OrderTable on s.asdf equals e.OrId
join t in MeeTingContext.Appr on s.ApprovalStatus equals t.ApprovalId
where s.Matnrid.Equals(tid)
select new BTL.Zuzhangyitianzuowanxiangmu
{
Tname=d.Tname,
MATNRBian = s.MATNRBian,
NameMaterial = s.NameMaterial,
MaterialTypeName = p.MaterialTypeName,
Price = s.Price,
StockQty = s.StockQty,
DateAdded = s.DateAdded,
OrderId = e.OrderId,
Consignee = e.Consignee,
ConsigneePhone = e.ConsigneePhone,
ConsigneeAddress = e.ConsigneeAddress,
Remarks = e.Remarks,
ApprovalName=t.ApprovalName,
Matnrid=s.Matnrid
}
).ToList().FirstOrDefault();
return await Task.Run(() => { return st; });
}