/// <summary>
/// 查询今日一共多少条报警消息
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public Task <IApiResult> GetMessageCount(P_Message.P_MessageCount arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
using (DAL.CarRentEntities db = new CarRentEntities())
{
var query = from m in db.ExceptionMessage
join d in db.Devices
on m.DeviceID equals d.DeviceID
join u in db.Users
on d.UserID equals u.UserID
where m.Deleted == 0 && m.Created > arg.start && m.Created < arg.end
select new R_Message.GetMessageListPage_Result.GetMessageListPage_List
{
Created = m.Created ?? default(DateTime),
DeviceName = d.DeviceName,
UserID = u.UserID,
UserName = u.UserName,
ExceptionID = m.ExceptionID,
PhoneNum = d.PhoneNum,
Message = m.Message,
SerialNumber = d.SerialNumber
};
var count = query.Count();
ar.result = new
{
todaycount = count
};
}
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.code = StatusCode.error;
ar.message = ex.Message;
}
return ar;
}));
}
public async Task <IApiResult> GetMessageCount([FromUri] P_Message.P_MessageCount pars)
{
return(await ApiAsync(pars, new BLL.MessageManager.Message().GetMessageCount));
}
