76 lines
2.5 KiB
C#
76 lines
2.5 KiB
C#
using Common.Models.UnqTables;
|
|
using SqlSugar;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using System.Web.Http;
|
|
|
|
namespace Server.Controllers.DataOverviewController
|
|
{
|
|
public class DataViewController : DefaultController
|
|
{
|
|
/// <summary>
|
|
/// 今日数据
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
[HttpPost, ErrorFilter]
|
|
public WebResult GetData()
|
|
{
|
|
//var MaxTimeToday = DateTime.Now; //当前时间
|
|
//var MinTimeToday = Convert.ToDateTime(DateTime.Now.ToString("D").ToString());//当天0点
|
|
|
|
//今日数据
|
|
var Today = DateTime.Now.Date;
|
|
var dataToday = Db.Queryable<DataOverview>().Where(f=>f.CreateTime.Date == Today).First();
|
|
|
|
if (dataToday == null)
|
|
dataToday = new DataOverview();
|
|
|
|
//var MinTimeYesterday = Convert.ToDateTime(DateTime.Now.ToString("D")).AddDays(-1);//昨天0点
|
|
//var MaxTimeYesterday = Convert.ToDateTime(DateTime.Now.ToString("D")).AddSeconds(-1);//昨天23点59分59秒
|
|
|
|
//昨日数据
|
|
var Yesterday = DateTime.Now.AddDays(-1).Date;
|
|
var dataYesterday = Db.Queryable<DataOverview>().Where(f => f.CreateTime.Date == Yesterday).First();
|
|
|
|
if (dataYesterday == null)
|
|
dataYesterday = new DataOverview();
|
|
|
|
return PutData(new {
|
|
Today = dataToday,
|
|
Yesterday = dataYesterday,
|
|
});
|
|
}
|
|
|
|
/// <summary>
|
|
/// 指定范围时间数据
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
[HttpPost, ErrorFilter]
|
|
public WebResult GetDataOverview()
|
|
{
|
|
var MinTime = GetTime("MinTime");
|
|
var MaxTime = GetTime("MaxTime");
|
|
|
|
if (MinTime == DateTime.MinValue) MinTime = DateTime.Now.AddMonths(-2);
|
|
|
|
if (MaxTime == DateTime.MinValue) MaxTime = DateTime.Now;
|
|
|
|
var exp = Expressionable.Create<DataOverview>();
|
|
|
|
exp.And(f => f.CreateTime >= MinTime && f.CreateTime <= MaxTime);
|
|
|
|
var PageIndex = GetInt("PageIndex", true);
|
|
var PageSzie = GetInt("PageSize", true);
|
|
var tNumber = 0;
|
|
|
|
var DataList = Db.Queryable<DataOverview>().Where(exp.ToExpression())
|
|
.ToPageList(PageIndex, PageSzie, ref tNumber);
|
|
|
|
return PutData(new PageResult<DataOverview>(DataList, tNumber, PageSzie, PageIndex));
|
|
}
|
|
}
|
|
}
|