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

namespace BLL
{
   public static class APICheckService
    {
        /// <summary>
        /// 保存检查信息
        /// </summary>
        /// <param name="addItem"></param>
        public static void SaveCheckInfo(Model.CheckItem addItem)
        {
            using (Model.HJGLDB db = new Model.HJGLDB(Funs.ConnString))
            {
                Model.Check_CheckList newP = new Model.Check_CheckList
                {
                    CheckId = BLL.Funs.GetNewID(),
                    ProjectArea = addItem.ProjectArea,
                    CheckArea = addItem.CheckArea,
                    Checker = addItem.Checker,
                    CheckDate = addItem.CheckDate,
                    CheckDef = addItem.CheckDef,
                    IsPass = addItem.IsPass,
                    CheckUrl = addItem.CheckUrl,
                    Flag = addItem.Flag
          
                };
                db.Check_CheckList.InsertOnSubmit(newP);
                db.SubmitChanges();
            }

        }

        /// <summary>
        /// 更新复检信息
        /// </summary>
        /// <param name="checkItem"></param>
        public static void UpdateReCheckInfo(Model.CheckItem checkItem)
        {
            using (Model.HJGLDB db = new Model.HJGLDB(Funs.ConnString))
            {
                Model.Check_CheckList check= db.Check_CheckList.FirstOrDefault(e => e.CheckId == checkItem.CheckId);
                if (check != null)
                {
                    check.ReCheckDate = checkItem.ReCheckDate;
                    check.ReChecker = checkItem.ReChecker;
                    check.ReCheckResult = checkItem.ReCheckResult;
                    check.ReCheckUrl = checkItem.ReCheckUrl;

                    db.SubmitChanges();
                }
                
            }

        }

        /// <summary>
        /// 获取项目区域的检查列表
        /// </summary>
        /// <param name="projectArea">项目区域</param>
        /// <returns></returns>
        public static List<Model.CheckItem> GetCheckList(string projectArea)
        {
            using (Model.HJGLDB db = new Model.HJGLDB(Funs.ConnString))
            {
                var getDataInfo = (from x in db.View_Check_CheckList
                                   
                                   where x.ProjectArea == projectArea
                                   select new Model.CheckItem
                                   {
                                       CheckId = x.CheckId,
                                       ProjectArea = x.ProjectArea,
                                       CheckArea = x.CheckArea,
                                       Checker = x.Checker,
                                       CheckName=x.CheckName,
                                       CheckDate = x.CheckDate,
                                       CheckDef = x.CheckDef,
                                       IsPass = x.IsPass,
                                       CheckUrl = x.CheckUrl,
                                       ReCheckDate = x.ReCheckDate,
                                       ReChecker = x.ReChecker,
                                       ReCheckName=x.ReCheckName,
                                       ReCheckResult = x.ReCheckResult,
                                       ReCheckUrl = x.ReCheckUrl,
                                       Flag = x.Flag
                                   }).ToList();
                return getDataInfo;
            }
        }

        /// <summary>
        /// 根据主建获取检查信息
        /// </summary>
        /// <param name="checkId">主建</param>
        /// <returns></returns>
        public static Model.CheckItem GetCheckInfo(string checkId)
        {
            using (Model.HJGLDB db = new Model.HJGLDB(Funs.ConnString))
            {
                var getDataInfo = (from x in db.View_Check_CheckList
                                   where x.CheckId == checkId
                                   select new Model.CheckItem
                                   {
                                       CheckId = x.CheckId,
                                       ProjectArea = x.ProjectArea,
                                       CheckArea = x.CheckArea,
                                       Checker = x.Checker,
                                       CheckName=x.CheckName,
                                       CheckDate = x.CheckDate,
                                       CheckDef = x.CheckDef,
                                       IsPass = x.IsPass,
                                       CheckUrl = x.CheckUrl,
                                       ReCheckDate = x.ReCheckDate,
                                       ReChecker = x.ReChecker,
                                       ReCheckName=x.ReCheckName,
                                       ReCheckResult = x.ReCheckResult,
                                       ReCheckUrl = x.ReCheckUrl,
                                       Flag = x.Flag
                                   }).FirstOrDefault();
                return getDataInfo;
            }
        }
    }
}