everlight.eap/backend/DllEapBll/RA/DataBoardController.cs

using Cksoft.Data;
using Cksoft.Data.Repository;
using Cksoft.Unity;
using DllEapDal.RA;
using DllEapEntity.Dtos;
using DllEapEntity.OFILM;
using DllEapEntity.RA;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ChartDto = DllEapEntity.OFILM.ChartDto;

namespace DllEapBll.RA
{
    /// <summary>
    /// RA实验室数据看板
    /// </summary>
    [Route("eap/api/[controller]/[action]")]
    [ApiController]
    [Authorize]
    public class DataBoardController : ControllerBase
    {
        
        [HttpGet]

        public LayuiModel<Center<MachineShort>> Get(DateTime? time, string fcode, string factory, string status,string fname)
        {
            using (IDatabase db = DbFactory.Base("RA"))
            {
                var dal = new DataBoardDal(db);
                //Dictionary<string, string> da =new Dictionary<string, string>();
                var da = new List<Center<Params>>();

                double ds = 0;
                DateTime date;
                if (!time.HasValue)
                {
                    date = DateTime.Now;
                }
                else
                {
                    date = time.Value;
                }
                IEnumerable<Center<MachineShort>> data = dal.Get(date, fcode, factory, status, fname, ref da, ref ds);

                return new LayuiModel<Center<MachineShort>>()
                {
                    code = 1,
                    data = data,
                    extraObject = da

                };
            }
        }
            [HttpGet]
            public List<Center<Center<ArrayList>>> GetTemp(DateTime? time, string Fcode)
            {
                using (IDatabase db = DbFactory.Base("RA"))
                {
                    var dal = new DataBoardDal(db);
                    if (!time.HasValue)
                    {
                        time = DateTime.Now;
                    }
                    string start = time.Value.ToString("yyyy-MM-dd 00:00:00");
                    string end;
                    if (DateTime.Now.Subtract(time.Value).TotalDays < 1)
                    {
                        end = DateTime.Now.AddMinutes(1).ToString("yyyy-MM-dd HH:mm:00");
                    }
                    else
                    {

                        end = time.Value.AddDays(1).ToString("yyyy-MM-dd 00:00:00");
                    }
                    return dal.GetTemp(start, end, Fcode);
                }
            }
                   
        [HttpGet]
        public ChartDto GetAlarm(DateTime? time, string Fcode)
        {
            using (IDatabase db = DbFactory.Base("RA"))
            {
                var dal = new DataBoardDal(db);
                var dic = new Dictionary<string, string>();
                return dal.GetAlarm(time, Fcode, ref dic);

            }
           
        }
        [HttpGet]
        public LayuiModel<MachineBase> GetBase(DateTime? time, string Fcode)
        {
            using (IDatabase db = DbFactory.Base("RA"))
            {
                var dal = new DataBoardDal(db);
                return dal.GetBase(time, Fcode);
            }
                
        }
        [HttpGet]
        public EapResponse GetStatus(DateTime? time, string Fcode)
        {
            using (IDatabase db = DbFactory.Base("RA"))
            {
                DateTime date;
                var res = new EapResponse { Code = 1, Msg = string.Empty };
                if (!time.HasValue)
                {
                    date = DateTime.Now;
                }
                else
                {
                    date = time.Value;
                }
                var dal = new DataBoardDal(db);
                List<StatusRatio> d = new List<StatusRatio>();
                var datas = dal.GetStatus(date, Fcode, out d);
                if (datas == null || datas.Count() <= 0)
                {
                    res.Code = -1;
                    res.Msg = "";
                    return res;
                }
                res.Data = datas;
                return res;
            }
                
        }
        [HttpGet]
        public EapResponse GetStatusRatio(DateTime? time, string Fcode)
        {
            using (IDatabase db = DbFactory.Base("RA"))
            {
                DateTime date;
                var res = new EapResponse { Code = 1, Msg = string.Empty };
                if (!time.HasValue)
                {
                    date = DateTime.Now;
                }
                else
                {
                    date = time.Value;
                }
                var dal = new DataBoardDal(db);
                List<StatusRatio> datas = new List<StatusRatio>();
                dal.GetStatus(date, Fcode, out datas);
                if (datas == null || datas.Count() <= 0)
                {
                    res.Code = -1;
                    res.Msg = "";
                    return res;
                }
                res.Data = datas;
                return res;
            }
              
        }
        [HttpGet]
        public LayuiModel<AlarmDetails> GetAlarmDetails(DateTime? time, string Fcode)
        {
            using (IDatabase db = DbFactory.Base("RA"))
            {
                DateTime date;
                var res = new LayuiModel<AlarmDetails> { code = 1, msg = string.Empty };
                if (!time.HasValue)
                {
                    date = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
                }
                else
                {
                    date = time.Value;
                }
                var dal = new DataBoardDal(db);

                var datas = dal.GetAlarmDetails(date, Fcode);
                if (datas == null || datas.Count() <= 0)
                {
                    res.code = -1;
                    res.msg = "";
                    return res;
                }
                res.data = datas;
                return res;
            }
               
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="start">开始时间</param>
        /// <param name="end">结束时间</param>
        /// <param name="fcode">设备ID</param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        [HttpGet]
        public LayuiModel<TempDetail> GetTempDetail(DateTime? start, DateTime? end,string fcode, int pageIndex = 1, int pageSize = 20)
        {
            using (IDatabase db = DbFactory.Base("RA"))
            {
                if (string.IsNullOrEmpty(fcode))
                {
                    fcode = "GDW0001";
                }
                if (!end.HasValue)
                {
                    end = DateTime.Now;
                }
                end = end.Value > DateTime.Now ? DateTime.Now : end.Value;
                if (!start.HasValue)
                {
                    start = Convert.ToDateTime(end.Value.ToString("D"));
                }

                var dal = new DataBoardDal(db);
                return dal.GetTempDetail(start.Value, end.Value, fcode, pageIndex, pageSize);
            }
               
        }
    }
}