public ForeExhibitionDetailViewPage ForeOtherApplication(string id) { ForeExhibitionDetailViewPage xx = new ForeExhibitionDetailViewPage(); var ForeOtherApplication1 = ( from a in db.Trade join y in db.TradeExamine on a.TradeID equals y.TradeID where a.TradeState == TradeState1.Online join x in db.UsersInfo on y.UserID equals x.UserID where y.TradeID == id select new ForeExhibitionDetailViewPage1 { TradeID = a.TradeID, TradePeopleNum = (from b in db.Trade join c in db.TradeExamine on b.TradeID equals c.TradeID where b.TradeID == a.TradeID select b.TradeID).Count(), CompanyName = x.CompanyName, EnglishName = x.EnglishName, TradeArea = y.TradeArea, TradeTitle = a.TradeTitle, }).ToList(); //var TradePeopleNum = ForeOtherApplication1.GroupBy(a => a.TradeID).Count().ToString(); xx.aa = ForeOtherApplication1; return(xx); }
public ForeExhibitionDetailViewPage TradeDetail(string id) { Trade TradeInfo = new Trade(); ForeExhibitionDetailViewPage xx = new ForeExhibitionDetailViewPage(); TradeInfo = db.Trade.Find(id); if (TradeInfo == null) { return(xx); } xx.TradeID = TradeInfo.TradeID; xx.TradeTitle = TradeInfo.TradeTitle; xx.TradeImg = TradeInfo.TradeImg; xx.TradeAddress = TradeInfo.TradeAddress; xx.TradeIntroduction = TradeInfo.TradeIntroduction; xx.TradeContact = TradeInfo.TradeContact; xx.Fax = TradeInfo.Fax; xx.ContactPhone = TradeInfo.ContactPhone; xx.TradeInfo = TradeInfo.TradeInfo; xx.TradeTime = TradeInfo.TradeTime; return(xx); }