using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BLL
{
    public static class ArchitectureReportService
    {
        /// <summary>
        /// 建筑行业能源节约与生态环境保护汇总表
        /// </summary>
        /// <param name="ArchitectureReportId">建筑行业能源节约与生态环境保护汇总表Id</param>
        /// <returns>建筑行业能源节约与生态环境保护汇总表</returns>
        public static Model.Environmental_ArchitectureReport GetArchitectureReportByArchitectureReportId(string ArchitectureReportId)
        {
            return Funs.DB.Environmental_ArchitectureReport.FirstOrDefault(e => e.ArchitectureReportId == ArchitectureReportId);
        }

        /// <summary>
        /// 建筑行业能源节约与生态环境保护汇总表
        /// </summary>
        /// <param name="unitId">单位Id</param>
        /// <param name = "year" > 年度 </ param >
        /// <param name="month">月份</param>
        /// <returns>建筑行业能源节约与生态环境保护汇总表</returns>
        public static Model.Environmental_ArchitectureReport GetArchitectureReportByUnitIdAndYearAndQuarters(string unitId, int year, int Quarters)
        {
            return Funs.DB.Environmental_ArchitectureReport.FirstOrDefault(e => e.UnitId == unitId && e.Quarters == Quarters && e.Year == year);
        }

        /// <summary>
        /// 根据单位Id获取建筑行业能源节约与生态环境保护汇总表集合
        /// </summary>
        /// <param name="UnitId">单位Id</param>
        /// <returns>建筑行业能源节约与生态环境保护汇总表集合</returns>
        public static List<Model.View_Environmental_ArchitectureReport> GetArchitectureReportsByUnitId(string UnitId)
        {
            return (from x in Funs.DB.View_Environmental_ArchitectureReport where x.UnitId == UnitId orderby x.FillingDate descending select x).ToList();
        }

        /// <summary>
        /// 增加建筑行业能源节约与生态环境保护汇总表
        /// </summary>
        /// <param name="ArchitectureReport">建筑行业能源节约与生态环境保护汇总表实体</param>
        public static void AddArchitectureReport(Model.Environmental_ArchitectureReport ArchitectureReport)
        {
            Model.Environmental_ArchitectureReport newArchitectureReport = new Model.Environmental_ArchitectureReport
            {
                ArchitectureReportId = ArchitectureReport.ArchitectureReportId,
                Year = ArchitectureReport.Year,
                Quarters = ArchitectureReport.Quarters,
                UnitId = ArchitectureReport.UnitId,
                FillingDate = ArchitectureReport.FillingDate,
                DutyPerson = ArchitectureReport.DutyPerson,
                FillingMan = ArchitectureReport.FillingMan,
                UpState = ArchitectureReport.UpState,
            };

            Funs.DB.Environmental_ArchitectureReport.InsertOnSubmit(newArchitectureReport);
            Funs.DB.SubmitChanges();
        }

        /// <summary>
        /// 修改建筑行业能源节约与生态环境保护汇总表
        /// </summary>
        /// <param name="ArchitectureReport">建筑行业能源节约与生态环境保护汇总表实体</param>
        public static void UpdateArchitectureReport(Model.Environmental_ArchitectureReport ArchitectureReport)
        {
            Model.Environmental_ArchitectureReport newArchitectureReport = Funs.DB.Environmental_ArchitectureReport.FirstOrDefault(e => e.ArchitectureReportId == ArchitectureReport.ArchitectureReportId);
            if (newArchitectureReport != null)
            {
                newArchitectureReport.Year = ArchitectureReport.Year;
                newArchitectureReport.Quarters = ArchitectureReport.Quarters;
                newArchitectureReport.UnitId = ArchitectureReport.UnitId;
                newArchitectureReport.FillingDate = ArchitectureReport.FillingDate;
                newArchitectureReport.DutyPerson = ArchitectureReport.DutyPerson;
                newArchitectureReport.UpState = ArchitectureReport.UpState;

                Funs.DB.SubmitChanges();
            }
        }

        /// <summary>
        /// 根据Id获取数据
        /// </summary>
        /// <param name="ArchitectureReportId"></param>
        public static void DeleteArchitectureReportByArchitectureReportId(string ArchitectureReportId)
        {
            Model.Environmental_ArchitectureReport newArchitectureReport = Funs.DB.Environmental_ArchitectureReport.FirstOrDefault(e => e.ArchitectureReportId == ArchitectureReportId);
            if (newArchitectureReport != null)
            {
                Funs.DB.Environmental_ArchitectureReport.DeleteOnSubmit(newArchitectureReport);
                Funs.DB.SubmitChanges();
            }
        }

        /// <summary>
        /// 根据报表单位，报表时间判断是否存在
        /// </summary>
        /// <param name="Id">Id</param>
        /// <returns></returns>
        public static Model.Environmental_ArchitectureReport GetArchitectureReportByUnitIdDate(string unitId, int year, int Quarters)
        {
            return Funs.DB.Environmental_ArchitectureReport.FirstOrDefault(e => e.UnitId == unitId && e.Year == year && e.Quarters == Quarters);
        }

        /// <summary>
        /// 根据报表单位，报表年份获取对应集合
        /// </summary>
        /// <param name="Id">Id</param>
        /// <returns></returns>
        public static List<Model.Environmental_ArchitectureReport> GetArchitectureReportByUnitIdYear(string unitId, int year)
        {
            return (from x in Funs.DB.Environmental_ArchitectureReport where x.UnitId == unitId && x.Year == year select x).ToList();
        }
    }
}