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_SpecialityCheckUpDB : BaseDB, IT_Service_FirstAid_SpecialityCheckUp
    {
        public SqlSugarClient db = GetClient();

        /// <summary>
        /// 新增或更新专科检查
        /// </summary>
        public bool UpdateOrInsert(SpecialityCheckUpModel model)
        {
            bool res = false;
            if (!string.IsNullOrEmpty(model.SpecialityCheckUp.GUID))
            {
                db.Updateable(model.SpecialityCheckUp).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommand();
                res = true;
            }
            else if (!string.IsNullOrEmpty(model.PatientGUID) && string.IsNullOrEmpty(model.SpecialityCheckUp.GUID))
            {

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

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