public TradeExamineViewPage TradeInfoDetail(string id) { TradeExamineViewPage xx = new TradeExamineViewPage(); var TradeExamineDetail1 = (from a in db.Trade join b in db.TradeExamine on a.TradeID equals b.TradeID join c in db.UsersInfo on b.UserID equals c.UserID where b.TradeID == id select new TradeExamineViewPage1 { TradeID = id, TradeTitle = a.TradeTitle, TradeTime = a.TradeTime, TradeAddress = a.TradeAddress, TradeIntroduction = a.TradeIntroduction, TradeInfo = a.TradeInfo, TradeContact = a.TradeContact, TradeArea = b.TradeArea, CompanyID = c.CompanyID, CompanyName = c.CompanyName, TradeExamineState = b.TradeExamineState, TradeExamineTime = b.TradeExamineTime, TradeExamineID = b.TradeExamineID, TradeDocument = b.TradeDocument, }).ToList(); var TradeInfo = db.Trade.Where(a => a.TradeID == id).ToList(); xx.axax = TradeInfo; xx.aa = TradeExamineDetail1; return(xx); }
public TradeExamineViewPage Index(string searchString, string Year, int?page) { TradeExamineViewPage xx = new TradeExamineViewPage(); int pageNumber; int pageSizeNum; int ItemNum; int pageNum; var TradeExamine1 = ( from a in db.Trade where a.TradeState == TradeState1.Online select new TradeExamineViewPage1 { 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(), TradeTitle = a.TradeTitle, TradeTime = a.TradeTime, TradeAddress = a.TradeAddress, TradeImg = a.TradeImg, TradeState = a.TradeState, TradeContact = a.TradeContact, TradeInfo = a.TradeInfo, }).ToList(); if (!String.IsNullOrEmpty(searchString)) { TradeExamine1 = TradeExamine1.Where(s => s.TradeTitle.Contains(searchString)).ToList(); } if (!String.IsNullOrEmpty(Year)) { TradeExamine1 = TradeExamine1.Where(s => s.TradeTime.Value.Year.ToString() == Year).ToList(); } var TradePeopleNum = TradeExamine1.GroupBy(a => a.TradeID).Count().ToString(); pageSizeNum = 5; //每页显示多少条 ItemNum = TradeExamine1.Count(); //数据总数 pageNum = (ItemNum % pageSizeNum) == 0 ? (ItemNum / pageSizeNum) : (ItemNum / pageSizeNum) + 1; //总页数 if (page == 4) { pageNumber = pageNum; } else { pageNumber = page ?? 1; } TradeExamine1 = TradeExamine1.OrderBy(x => x.TradeExamineID).Skip((pageNumber - 1) * pageSizeNum).Take(pageSizeNum).ToList(); xx.aa = TradeExamine1; xx.pageNumber = pageNumber; xx.pageNumx = pageNum; xx.ItemNum = ItemNum.ToString(); xx.searchString = searchString; xx.Year = Year; return(xx); }
public TradeExamineViewPage daochu() { TradeExamineViewPage xx = new TradeExamineViewPage(); var MessageInfo1 = (from a in db.Trade join b in db.TradeExamine on a.TradeID equals b.TradeID join c in db.UsersInfo on b.UserID equals c.UserID select new TradeExamineViewPage1 { CompanyName = c.CompanyName, TradeAddress = a.TradeAddress }).ToList(); xx.aa = MessageInfo1; return(xx); }
public TradeExamineViewPage IndexDetail(int?page) { TradeExamineViewPage xx = new TradeExamineViewPage(); return(xx); }