using HL_FristAidPlatform_Help;
using HL_FristAidPlatform_IDataBase;
using HL_FristAidPlatform_Models;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HL_FristAidPlatform_DataBase
{
    public class T_Service_Trauma_AssessmentDB: BaseDB, IT_Service_Trauma_Assessment
    {
        public SqlSugarClient db = GetClient();
        #region  ISSAIS数据
        /// <summary>
        /// 根据患者GUID和ISSGUID查询ISS报表打印数据
        /// </summary>
        /// <param name="patientGuid"></param>
        /// <returns></returns>
        public ISSAISScoreReportModel GetISSAISModelByPatientGuid(string patientGuid, string ISSGUID)
        {
            var ISSAISModel = db.Queryable<T_Service_Trauma_ISSAIS, T_Service_Trauma_HeadAIS, T_Service_Trauma_FaceAIS, T_Service_Trauma_ChestAIS, T_Service_Trauma_LimbsAIS, T_Service_Trauma_AbdominalAIS, T_Service_Trauma_SurfaceOthersAIS>((ISSAIS, HeadAIS, FaceAIS, ChestAIS, LimbsAIS, AbdominalAIS, SurfaceOthersAIS) => new JoinQueryInfos(
                                 JoinType.Left, ISSAIS.GUID == HeadAIS.ISSGUID, //左连接 左链接 左联
                                 JoinType.Left, HeadAIS.ISSGUID == FaceAIS.ISSGUID,
                                 JoinType.Left, FaceAIS.ISSGUID == ChestAIS.ISSGUID,
                                 JoinType.Left, ChestAIS.ISSGUID == LimbsAIS.ISSGUID,
                                 JoinType.Left, LimbsAIS.ISSGUID == AbdominalAIS.ISSGUID,
                                 JoinType.Left, AbdominalAIS.ISSGUID == SurfaceOthersAIS.ISSGUID,
                                 JoinType.Left, SurfaceOthersAIS.ISSGUID == ISSAIS.GUID))
                            .Where((ISSAIS, HeadAIS, FaceAIS, ChestAIS, LimbsAIS, AbdominalAIS, SurfaceOthersAIS) => ISSAIS.GUID == ISSGUID && ISSAIS.PatientGuid == patientGuid)
                            .Select((ISSAIS, HeadAIS, FaceAIS, ChestAIS, LimbsAIS, AbdominalAIS, SurfaceOthersAIS) =>
                            new ISSAISScoreReportModel
                            {
                                HeadAIS = HeadAIS.HeadAISSum,
                                FaceAIS = FaceAIS.FaceAISSum,
                                ChestAIS = ChestAIS.ChestAISSum,
                                LimbsAIS = LimbsAIS.LimbsAISSum,
                                AbdominalAIS = AbdominalAIS.AbdominalAISSum,
                                SurfaceOthersAIS = SurfaceOthersAIS.SurfaceOthersAISSum,
                                ISS = ISSAIS.ISS,
                                CreationDate = ISSAIS.CreationDate
                            }).First();

            return ISSAISModel;
        }
        /// <summary>
        /// 根据患者GUID查询数据
        /// </summary>
        /// <param name="patientGuid"></param>
        /// <returns></returns>
        public T_Service_Trauma_ISSAIS GetISSAISByPatientGuid(string patientGuid, string ISSGUID)
        {
            return db.Queryable<T_Service_Trauma_ISSAIS>().Where(it => it.PatientGuid == patientGuid && it.GUID == ISSGUID).OrderBy(it => it.CreationDate, OrderByType.Desc).First();
        }
        /// <summary>
        /// 根据患者GUID查询数据
        /// </summary>
        /// <param name="patientGuid"></param>
        /// <returns></returns>
        public T_Service_Trauma_ISSAIS GetFirstISSAISByPatientGuid(string patientGuid)
        {
            return db.Queryable<T_Service_Trauma_ISSAIS>().Where(it => it.PatientGuid == patientGuid).OrderBy(it => it.CreationDate, OrderByType.Desc).First();
        }
        /// <summary>
        /// 根据患者GUID查询数据
        /// </summary>
        /// <param name="patientGuid"></param>
        /// <returns></returns>
        public T_Service_Trauma_ISSAIS GetISSAISByGUID(string GUID)
        {
            return db.Queryable<T_Service_Trauma_ISSAIS>().First(it => it.GUID == GUID);
        }

        /// <summary>
        /// 根据患者GUID查询数据列表
        /// </summary>
        /// <param name="patientGuid"></param>
        /// <returns></returns>
        public List<T_Service_Trauma_ISSAIS> GetISSAISListByPatientGuid(string patientGuid)
        {
            return db.Queryable<T_Service_Trauma_ISSAIS>().Where(it => it.PatientGuid == patientGuid).OrderBy(i => i.CreationDate, OrderByType.Desc).ToList();
        }

        /// <summary>
        /// 插入一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public T_Service_Trauma_ISSAIS ADDISSAIS(T_Service_Trauma_ISSAIS model)
        {
            return db.Insertable(model).IgnoreColumns(ignoreNullColumn: true).ExecuteReturnEntity();
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateISSAIS(T_Service_Trauma_ISSAIS model)
        {
            return db.Updateable(model).ExecuteCommand() == 0 ? false : true;
        }

        #endregion


        #region 创伤评估头部
        /// <summary>
        /// 插入一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public T_Service_Trauma_HeadAIS ADDHeadAIS(T_Service_Trauma_HeadAIS model)
        {
            return db.Insertable(model).IgnoreColumns(ignoreNullColumn: true).ExecuteReturnEntity();
        }
        
        /// <summary>
        /// 更新一条数据
        /// </summary>
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateHeadAIS(T_Service_Trauma_HeadAIS model)
        {
            return db.Updateable(model).ExecuteCommand() == 0 ? false : true;
        }
        /// <summary>
        /// 根据患者GUID查询数据
        /// </summary>
        /// <param name="patientGuid"></param>
        /// <returns></returns>
        public T_Service_Trauma_HeadAIS GetHeadAISByPatientGuid(string patientGuid,string ISSGUID)
        {
            return db.Queryable<T_Service_Trauma_HeadAIS>().First(it => it.PatientGuid == patientGuid && it.ISSGUID == ISSGUID);
        }
        #endregion

        #region 创伤评估面部
        /// <summary>
        /// 插入一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public T_Service_Trauma_FaceAIS ADDFaceAIS(T_Service_Trauma_FaceAIS model)
        {
            return db.Insertable(model).IgnoreColumns(ignoreNullColumn: true).ExecuteReturnEntity();
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateFaceAIS(T_Service_Trauma_FaceAIS model)
        {
            return db.Updateable(model).ExecuteCommand() == 0 ? false : true;
        }
        /// <summary>
        /// 根据患者GUID查询数据
        /// </summary>
        /// <param name="patientGuid"></param>
        /// <returns></returns>
        public T_Service_Trauma_FaceAIS GetFaceAISByPatientGuid(string patientGuid, string ISSGUID)
        {
            return db.Queryable<T_Service_Trauma_FaceAIS>().First(it => it.PatientGuid == patientGuid && it.ISSGUID == ISSGUID);
        }
        #endregion

        #region 创伤评估胸部、胸椎、横隔AIS评分
        /// <summary>
        /// 插入一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public T_Service_Trauma_ChestAIS ADDChestAIS(T_Service_Trauma_ChestAIS model)
        {
            return db.Insertable(model).IgnoreColumns(ignoreNullColumn: true).ExecuteReturnEntity();
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateChestAIS(T_Service_Trauma_ChestAIS model)
        {
            return db.Updateable(model).ExecuteCommand() == 0 ? false : true;
        }
        /// <summary>
        /// 根据患者GUID查询数据
        /// </summary>
        /// <param name="patientGuid"></param>
        /// <returns></returns>
        public T_Service_Trauma_ChestAIS GetChestAISByPatientGuid(string patientGuid, string ISSGUID)
        {
            return db.Queryable<T_Service_Trauma_ChestAIS>().First(it => it.PatientGuid == patientGuid && it.ISSGUID == ISSGUID);
        }
        #endregion

        #region 创伤评估四肢盆骨臀部AIS评分
        /// <summary>
        /// 插入一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public T_Service_Trauma_LimbsAIS ADDLimbsAIS(T_Service_Trauma_LimbsAIS model)
        {
            return db.Insertable(model).IgnoreColumns(ignoreNullColumn: true).ExecuteReturnEntity();
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateLimbsAIS(T_Service_Trauma_LimbsAIS model)
        {
            return db.Updateable(model).ExecuteCommand() == 0 ? false : true;
        }
        /// <summary>
        /// 根据患者GUID查询数据
        /// </summary>
        /// <param name="patientGuid"></param>
        /// <returns></returns>
        public T_Service_Trauma_LimbsAIS GetLimbsAISByPatientGuid(string patientGuid, string ISSGUID)
        {
            return db.Queryable<T_Service_Trauma_LimbsAIS>().First(it => it.PatientGuid == patientGuid && it.ISSGUID == ISSGUID);
        }
        #endregion

        #region 创伤评估腹盆腔腰椎AIS评分
        /// <summary>
        /// 插入一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public T_Service_Trauma_AbdominalAIS ADDAbdominalAIS(T_Service_Trauma_AbdominalAIS model)
        {
            return db.Insertable(model).IgnoreColumns(ignoreNullColumn: true).ExecuteReturnEntity();
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateAbdominalAIS(T_Service_Trauma_AbdominalAIS model)
        {
            return db.Updateable(model).ExecuteCommand() == 0 ? false : true;
        }
        /// <summary>
        /// 根据患者GUID查询数据
        /// </summary>
        /// <param name="patientGuid"></param>
        /// <returns></returns>
        public T_Service_Trauma_AbdominalAIS GetAbdominalAISByPatientGuid(string patientGuid, string ISSGUID)
        {
            return db.Queryable<T_Service_Trauma_AbdominalAIS>().First(it => it.PatientGuid == patientGuid && it.ISSGUID == ISSGUID);
        }
        #endregion

        #region 创伤评估体表其他评分
        /// <summary>
        /// 插入一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public T_Service_Trauma_SurfaceOthersAIS ADDSurfaceOthersAIS(T_Service_Trauma_SurfaceOthersAIS model)
        {
            return db.Insertable(model).IgnoreColumns(ignoreNullColumn: true).ExecuteReturnEntity();
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateSurfaceOthersAIS(T_Service_Trauma_SurfaceOthersAIS model)
        {
            return db.Updateable(model).ExecuteCommand() == 0 ? false : true;
        }
        /// <summary>
        /// 根据患者GUID查询数据
        /// </summary>
        /// <param name="patientGuid"></param>
        /// <returns></returns>
        public T_Service_Trauma_SurfaceOthersAIS GetSurfaceOthersAISByPatientGuid(string patientGuid, string ISSGUID)
        {
            return db.Queryable<T_Service_Trauma_SurfaceOthersAIS>().First(it => it.PatientGuid == patientGuid && it.ISSGUID == ISSGUID);
        }
        #endregion

    }
}