public async Task <IApiResult> GetCarRequestList(int userid)
{
P_Users.P_UsersByUserID pars = new P_Users.P_UsersByUserID()
{
userid = userid
};
return(await ApiAsync(pars, new BLL.DeviceManager.Device().GetCarRequest));
}
public Task <IApiResult> GetCarRequest(P_Users.P_UsersByUserID arg)
{
return(Task.Run(() =>
{
IApiResult hr = new IApiResult();
using (CarRentEntities db = new CarRentEntities())
{
var dev = from d in db.Devices
join lr in db.LeaseRecord
on d.DeviceID equals lr.DeviceID
where lr.Status == 1 && d.Status == 0 //Status (1:已租，0:未租)
select new { lr.LeaseID, d.DeviceID, d.DeviceName, d.SerialNumber, lr.UserPhone, lr.Created, lr.Status };
var list = dev.ToList();
hr.result = list;
hr.message = $"查询到了{list.Count}条数据.";
}
return hr;
}));
}
