/// <summary>
/// 根据用户编号返回归还单信息,用户编号为空则返回全部
/// </summary>
/// <param name="userId">用户编号</param>
/// <returns></returns>
public DataTable GetRtoByUserId(string userId)
{
var list = _assReturnOrderRepository.GetByUserID(userId).AsNoTracking();
var result = from returnOrder in list
join user in _SMOSECDbContext.coreUsers on returnOrder.RETURNER equals user.USER_ID
join location in _SMOSECDbContext.AssLocations on returnOrder.LOCATIONID equals location.LOCATIONID
select new
{
Rtoid = returnOrder.RTOID,
LocationName = location.NAME,
Returndate = returnOrder.RETURNDATE,
Returner = user.USER_NAME
};
return(LINQToDataTable.ToDataTable(result));
}
/// <summary>
/// 根据用户编号返回归还单信息,用户编号为空则返回全部
/// </summary>
/// <param name="userId">用户编号</param>
/// <param name="LocationId">区域编号</param>
/// <returns></returns>
public DataTable GetRtoByUserId(string userId, string LocationId)
{
var list = _assReturnOrderRepository.GetByUserID(userId).AsNoTracking();
if (!string.IsNullOrEmpty(LocationId))
{
list = list.Where(a => a.LOCATIONID == LocationId);
}
var result = from returnOrder in list
join user in _SMOSECDbContext.coreUsers on returnOrder.HANDLEMAN equals user.USER_ID
join location in _SMOSECDbContext.AssLocations on returnOrder.LOCATIONID equals location.LOCATIONID
select new
{
Rtoid = returnOrder.RTOID,
LocationName = location.NAME,
Returndate = returnOrder.RETURNDATE,
HandleMan=user.USER_NAME
};
return LINQToDataTable.ToDataTable(result);
}