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_Base_DiagnosisAndTriageGoDB : BaseDB, IT_Base_DiagnosisAndTriageGo
    {
        public SqlSugarClient db = GetClient();
        #region 分诊去向
        /// <summary>
        /// 获取分诊去向列表
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public List<T_Base_TriageGo> GetTriageGoList()
        {
            return db.Queryable<T_Base_TriageGo>().Where(it => it.DeleteFlag == 0).ToList();
        }

        /// <summary>
        /// 根据ID获取实体
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public T_Base_TriageGo GetTriageGoById(long id)
        {
            return db.Queryable<T_Base_TriageGo>().Where(i => i.ID == id && i.DeleteFlag == 0).First();
        }

        /// <summary>
        /// 获取所有科室
        /// </summary>
        /// <param name="systemId"></param>
        /// <returns></returns>
        public List<T_Base_TriageGo> GetTriageGoList(string name, long systemId)
        {
            return db.Queryable<T_Base_TriageGo>().Where(i => i.DeleteFlag == 0)
                .WhereIF(!SqlFunc.IsNullOrEmpty(name), i => i.Name.Contains(name))
                .WhereIF(systemId > 0, i => i.SystemModuleID == systemId).ToList();
        }

        /// <summary>
        /// 根据Name SystemModuleID 获取实体
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public T_Base_TriageGo GetTriageGoByName(string name, long systemId)
        {
            return db.Queryable<T_Base_TriageGo>().Where(i => i.Name == name && i.SystemModuleID == systemId).First();
        }

        /// <summary>
        /// 保存分诊科室
        /// </summary>
        /// <param name="department"></param>
        /// <returns></returns>
        public bool SaveTriageGo(T_Base_TriageGo department)
        {
            return db.Insertable(department).IgnoreColumns(ignoreNullColumn: true).ExecuteCommand() == 1 ? true : false;
        }

        /// <summary>
        /// 修改分诊科室
        /// </summary>
        /// <param name="department"></param>
        /// <returns></returns>
        public bool UpdateTriageGo(T_Base_TriageGo department)
        {
            return db.Updateable(department).UpdateColumns(i => new { i.Name }).Where(i => i.GUID == department.GUID).ExecuteCommand() == 1 ? true : false;
        }


        #endregion


        #region 印象诊断
        public List<T_Base_ImpressionDiagnosis> GetImpressionDiagnosisList()
        {
            return db.Queryable<T_Base_ImpressionDiagnosis>().Where(it => it.DeleteFlag == 0).ToList();
        }

        /// <summary>
        /// 根据ID获取实体
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public T_Base_ImpressionDiagnosis GetImpressionDiagnosisById(long id)
        {
            return db.Queryable<T_Base_ImpressionDiagnosis>().Where(i => i.ID == id && i.DeleteFlag == 0).First();
        }


        public List<T_Base_ImpressionDiagnosis> GetImpressionDiagnosisList(string name, long systemId)
        {
            return db.Queryable<T_Base_ImpressionDiagnosis>().Where(i => i.DeleteFlag == 0)
                .WhereIF(!SqlFunc.IsNullOrEmpty(name), i => i.Name == name)
                .WhereIF(systemId > 0, i => i.SystemModuleID == systemId).ToList();
        }


        /// <summary>
        /// 根据Name SystemModuleID 获取实体
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public T_Base_ImpressionDiagnosis GetImpressionDiagnosisByName(string name, long systemId)
        {
            return db.Queryable<T_Base_ImpressionDiagnosis>().Where(i => i.Name == name && i.SystemModuleID == systemId).First();
        }


        /// <summary>
        /// 保存印象诊断
        /// </summary>
        /// <param name="department"></param>
        /// <returns></returns>
        public bool SaveImpressionDiagnosis(T_Base_ImpressionDiagnosis department)
        {
            return db.Insertable(department).IgnoreColumns(ignoreNullColumn: true).ExecuteCommand() == 1 ? true : false;
        }
        /// <summary>
        /// 修改印象诊断
        /// </summary>
        /// <param name="department"></param>
        /// <returns></returns>
        public bool UpdateImpressionDiagnosis(T_Base_ImpressionDiagnosis department)
        {
            return db.Updateable(department).UpdateColumns(i => new { i.Name }).Where(i => i.GUID == department.GUID).ExecuteCommand() == 1 ? true : false;
        }

        #endregion








    }
}