public List <TradeDetailInfo> GetTradeDetailInfo(string tid) { List <TradeDetailInfo> lst = new List <TradeDetailInfo>(); using (b2b_sysEntities ctx = new b2b_sysEntities()) { var query = from c in ctx.TradeDetail join p in ctx.itemnew on c.numiid equals p.ID where c.tid == tid select new TradeDetailInfo { num = c.num, numiid = c.numiid, oid = c.oid, outeriid = c.outeriid, outerskuid = c.outerskuid, picurl = p.logo, price = c.price.Value, skuid = c.skuid.Value, tid = c.tid, tile = c.title }; lst = query.ToList(); } return(lst); }
public Trade GetSingleOrder(string tid) { using (b2b_sysEntities ctx = new b2b_sysEntities()) { Trade trade = ctx.Trade.FirstOrDefault(c => c.tid == tid); trade.details = GetTradeDetailInfo(tid); return(trade); } }