//显示
public OrderPages GetOrder(string orderno, string paystate, int pageindex, int pagesize = 2)
{
int count = 0;
List <OrderInfo> orderlist = new List <OrderInfo>();
if (orderno == null)
{
orderno = "";
}
if (paystate != null)//判断是否有效
{
orderlist = _rent.GetOrder(u => u.OrderNo.Contains(orderno) & u.PayState == paystate, u => u.OrderNo, pageindex, pagesize, out count);
}
else
{
orderlist = _rent.GetOrder(u => u.OrderNo.Contains(orderno), u => u.OrderNo, pageindex, pagesize, out count);
}
var list = from s in orderlist
join a in _boothManager.ShowBooAucalInfo() on s.BooAucaId equals a.Id
join b in _boothManager.ShowBoo() on a.BooId equals b.Id
join m in _market.ShowMarket() on b.MarkId equals m.Id
select new OrderPage()
{
Id = s.Id,
OrderNo = s.OrderNo,
BooNo = b.BooNo,
MarkName = m.MarkName,
RenPrice = s.RenPrice,
CashMoney = s.CashMoney,
PayState = s.PayState,
CreateTime = b.CreateTime,
ZCreateTime = a.CreateTime,
ZEndTime = a.EndTime
};
OrderPages orderPages = new OrderPages {
OrderList = list.ToList(), Count = count
};
return(orderPages);
}
//三表联查 摊位表 市场表 摊位竞拍
public List <BooAucalInfoAndUser> ShowAll()
{
List <BooAucalnfo> list = _boothManager.ShowBooAucalInfo();
var lists = (from s in list
join a in _boothManager.ShowBoo() on s.BooId equals a.Id
join b in _marketBll.ShowUserInfo() on a.LessId equals b.Id
select new BooAucalInfoAndUser
{
Id = s.Id,
BooTitle = a.BooTitle,
CreateTime = s.CreateTime,
EndTime = s.EndTime,
Count = _marketBll.ShowUserInfo().Count,
UserName = b.UserName,
FinishPrice = s.FinishPrice,
OrderState = s.OrderState,
CashMoneyState = s.CashMoneyState,
BooAucaState = s.BooAucaState,
BooId = a.Id
}).ToList();
return(lists);
}