using HL_FristAidPlatform_Help;
using HL_FristAidPlatform_IDataBase;
using HL_FristAidPlatform_Models;
using SqlSugar;
using System;

namespace HL_FristAidPlatform_DataBase
{
    public class T_Service_FirstAid_AssistantExaminationDB : BaseDB, IT_Service_FirstAid_AssistantExamination
    {
        public SqlSugarClient db = GetClient();

        /// <summary>
        /// 新增或更新专科检查
        /// </summary>
        public bool UpdateOrInsert(AssistantExaminationModel model)
        {
            bool res = false;
            if (!string.IsNullOrEmpty(model.AssistantExamination.GUID))
            {
                db.Updateable(model.AssistantExamination).IgnoreColumns(ignoreAllNullColumns: true).IgnoreColumns(it => new { it.CreateUser }).ExecuteCommand();
                if (model.AssistantExamination.DeathTime == null)
                    db.Updateable<T_Service_FirstAid_AssistantExamination>().SetColumns(it => new T_Service_FirstAid_AssistantExamination { DeathTime = null }).Where(it => it.GUID == model.AssistantExamination.GUID).ExecuteCommand();
                res = true;
            }
            else if (!string.IsNullOrEmpty(model.PatientGUID) && string.IsNullOrEmpty(model.AssistantExamination.GUID))
            {

                model.AssistantExamination.GUID = Guid.NewGuid().ToString();
                model.AssistantExamination.PatientGUID = model.PatientGUID;
                db.Insertable(model.AssistantExamination).IgnoreColumns(ignoreNullColumn: true).ExecuteCommand();
                res = true;
            }
            return res;
        }

        /// <summary>
        /// 获取 患者的专科检查新
        /// </summary>
        /// <param name="guid"></param>
        /// <returns></returns>
        public T_Service_FirstAid_AssistantExamination GetAssistantExaminationInfo(string guid)
        {
            return db.Queryable<T_Service_FirstAid_AssistantExamination>().Where(i => i.PatientGUID == guid).First();
        }

    }
}