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);
}
