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

namespace BLL
{
    public static class ProjectArchitectureReportService
    {
        /// <summary>
        /// 建筑行业能源节约与生态环境保护汇总表
        /// </summary>
        /// <param name="ArchitectureReportId">建筑行业能源节约与生态环境保护汇总表Id</param>
        /// <returns>建筑行业能源节约与生态环境保护汇总表</returns>
        public static Model.Environmental_ProjectArchitectureReport GetArchitectureReportByArchitectureReportId(string ArchitectureReportId)
        {
            return Funs.DB.Environmental_ProjectArchitectureReport.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_ProjectArchitectureReport GetArchitectureReportByProjectIdAndYearAndQuarters(string projectId, int year, int Quarters)
        {
            return Funs.DB.Environmental_ProjectArchitectureReport.FirstOrDefault(e => e.ProjectId == projectId && e.Quarters == Quarters && e.Year == year);
        }

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

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

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

        /// <summary>
        /// 修改建筑行业能源节约与生态环境保护汇总表
        /// </summary>
        /// <param name="ArchitectureReport">建筑行业能源节约与生态环境保护汇总表实体</param>
        public static void UpdateArchitectureReport(Model.Environmental_ProjectArchitectureReport ArchitectureReport)
        {
            Model.Environmental_ProjectArchitectureReport newArchitectureReport = Funs.DB.Environmental_ProjectArchitectureReport.FirstOrDefault(e => e.ArchitectureReportId == ArchitectureReport.ArchitectureReportId);
            if (newArchitectureReport != null)
            {
                newArchitectureReport.Year = ArchitectureReport.Year;
                newArchitectureReport.Quarters = ArchitectureReport.Quarters;
                newArchitectureReport.ProjectId = ArchitectureReport.ProjectId;
                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_ProjectArchitectureReport newArchitectureReport = Funs.DB.Environmental_ProjectArchitectureReport.FirstOrDefault(e => e.ArchitectureReportId == ArchitectureReportId);
            if (newArchitectureReport != null)
            {
                Funs.DB.Environmental_ProjectArchitectureReport.DeleteOnSubmit(newArchitectureReport);
                Funs.DB.SubmitChanges();
            }
        }

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

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