/// <summary>
/// 设备列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ActionResult DerviceList(ReportDeviceQueryModel query, Int32?keywords)
{
Int32 year = DateTime.Now.Year;
if (keywords != null)
{
year = (Int32)keywords;
}
using (var db = new MbContext())
{
query.deviceData = db.Device
.Include(t => t.UseCompany)
.Include(t => t.Brand)
.Include(t => t.Brand.Manufacturer)
.Include(t => t.Area)
.Include(t => t.Category)
.Where(t => t.UseCompanyId == CurrentUser.User.UseCompanyId).ToList();
query.deviceCount = db.MainOrder
.Where(t => t.UseCompanyId == CurrentUser.User.UseCompanyId && t.CreateTime.Year == year && t.DeviceId > 0)
.GroupBy(t => t.DeviceId)
.Select(t => new {
deviceId = t.Key,
num = t.Count().ToString()
}).ToDictionary(x => x.deviceId, x => x.num);
//设备数量
query.PageInfo.TotalCount = query.deviceData.Count();
}
return(View(query));
}
public void DerviceListTest()
{
ReportDeviceQueryModel query = new ReportDeviceQueryModel();
string UseCompanyId = "636065437685331832";
using (var db = new MbContext())
{
var device = db.Device
.Include(t => t.UseCompany)
.Include(t => t.Brand)
.Include(t => t.Brand.Manufacturer)
.Include(t => t.Area)
.Include(t => t.Category)
.Where(t => t.UseCompanyId == UseCompanyId).ToList();
var result = db.MainOrder
.Where(t => t.UseCompanyId == UseCompanyId)
.GroupBy(t => t.DeviceId)
.Select(t => new
{
deviceId = t.Key,
num = t.Count().ToString()
}).ToList().ToDictionary(x => x.deviceId, x => x.num);;
}
}
