using HL_FristAidPlatform_Help;
using HL_FristAidPlatform_IDataBase;
using HL_FristAidPlatform_Models;
using Newtonsoft.Json;
using SqlSugar;
using System.Data;

namespace HL_FristAidPlatform_DataBase
{
    /// <summary>
    /// 120急救信息
    /// </summary>
    public class T_Service_120FirstAidDB : BaseDB, IT_Service_120FirstAid
    {
        public SqlSugarClient db = GetClient();

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public T_Service_120FirstAid Add(T_Service_120FirstAid model)
        {
            return db.Insertable(model).IgnoreColumns(it => new { it.ID }).ExecuteReturnEntity();
        }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(T_Service_120FirstAid model)
        {
            return db.Updateable(model).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommand() == 0 ? false : true;
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(long ID)
        {
            return db.Deleteable<T_Service_120FirstAid>(ID).ExecuteCommand() == 0 ? false : true;
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        /// <param name="pageIndex">起始页</param>
        /// <param name="pageSize">每页大小</param>
        /// <param name="hospitalGuid">所属院区GUID</param>
        /// <param name="startTime">开始时间(创建)</param>
        /// <param name="endTime">结束时间(创建)</param>
        /// <param name="status">任务状态1：派发任务；2：已出发；3：到达现场；4：离开现场；5：任务完成 -1：查询全部</param>
        /// <param name="keyWord">关键词</param>
        /// <returns></returns>
        public string GetPageList(int pageIndex, int pageSize, string hospitalGuid, string startTime, string endTime, int status, string keyWord)
        {
            string StrWhere = string.Empty;

            #region 所属院区
            if (!string.IsNullOrEmpty(hospitalGuid.Trim()))
            {
                StrWhere += " AND b.HospitalGuid = '" + hospitalGuid + "'";
            }
            #endregion

            #region 任务状态1：派发任务；2：已出发；3：到达现场；4：离开现场；5：任务完成
            if (status > -1)
            {
                StrWhere += "And b.EmergencyState =" + status;
            }
            #endregion

            #region 关键词
            if (!string.IsNullOrEmpty(keyWord.Trim()))
            {
                StrWhere += " AND(b.Name LIKE '%" + keyWord + "%' OR b.MobilePhone LIKE '%" + keyWord + "%' OR b.IdentityCard LIKE '%" + keyWord + "%' OR b.Attack_Address LIKE '%" + keyWord + "%' OR d.PlateNumber LIKE '%" + keyWord + "%' OR e.Code LIKE '%" + keyWord + "%' OR b.EqmtNo LIKE '%" + keyWord + "%')";
            }
            #endregion

            string SqlStr = string.Format(@"SELECT b.ID,a.PatientGuid,a.[GUID],b.Name,b.Age,c.GenderName,b.MobilePhone,b.Attack_Address,a.CallHelpTime,a.DiseaseTime,b.IdentityCard,d.PlateNumber,e.Code,b.EqmtNo AS EquipmentNumber,b.Note,a.SendAmbulanceTime,a.AmbulanceDepartureTime,a.ArrivalTime,a.LeaveTime,a.ArrivesHospitalTime,a.CreationDate,b.Creator,b.Creator,b.RegisterTime,f.Name AS HospitalName,a.Property,a.[Status]
                FROM T_Service_120FirstAid a
                LEFT JOIN T_Service_Patient b ON a.PatientGuid=b.[GUID]
                LEFT JOIN T_Base_Gender c ON c.GenderCode=b.Gender
                LEFT JOIN T_Base_Ambulance d ON b.AmbulanceGuid=d.[GUID]
                LEFT JOIN T_Base_WristStrap e ON b.WristStrapID=e.ID
                LEFT JOIN T_Base_Hospital f ON b.HospitalGuid=f.[GUID]
                WHERE b.RegisterTime BETWEEN '{0}' AND '{1}' AND a.DeleteFlag=0 {2} order by a.ID DESC", startTime, endTime, StrWhere);

            DataTable dt = db.Ado.GetDataTable(SqlStr);
            string items = "";

            if (dt.Rows.Count > 0)
            {
                foreach (DataRow item in dt.Rows)
                {
                    string row = "";
                    for (int i = 0; i < dt.Columns.Count; i++)
                    {
                        row += JsonConvert.SerializeObject(dt.Columns[i].ColumnName) + ":";
                        row += JsonConvert.SerializeObject(item[i]) + ",";
                    }
                    row = row.Remove(row.Length - 1);
                    items += "{" + row + "}" + ",";

                }
                items = items.Remove(items.Length - 1);
            }
            items = "[" + items + "]";
            return items;
        }

        /// <summary>
        /// 获得前几行数据
        /// </summary>
        public T_Service_120FirstAid Get(long id)
        {
            return db.Queryable<T_Service_120FirstAid>().First(it => it.ID == id);
        }

        /// <summary>
        /// 根据患者编号(GUID)+所属报表类型 获取数据信息
        /// </summary>
        /// <param name="patientGuid">病人编号(GUID)</param>
        /// <returns></returns>
        public TableModel<T_Service_120FirstAid> GetByPatientGuid(string patientGuid)
        {
            TableModel<T_Service_120FirstAid> t = new TableModel<T_Service_120FirstAid>();

            var listMode = db.Queryable<T_Service_120FirstAid>().Where(it => it.PatientGuid == patientGuid && it.DeleteFlag == 0)
          .Select(it => new T_Service_120FirstAid
          {
              ID = it.ID,
              GUID = it.GUID,
              PatientGuid = it.PatientGuid,
              DiseaseTime = it.DiseaseTime,
              TimeOfOnset = it.TimeOfOnset,
              OnsetTimeInterval = it.OnsetTimeInterval,
              CallHelpTime = it.CallHelpTime,
              Property = it.Property,
              Status = it.Status,
              Summary = it.Summary,
              DeleteFlag = it.DeleteFlag,
              CreationDate = it.CreationDate,
              CreatorID = it.CreatorID,
              Creator = it.Creator,
              EditTime = it.EditTime,
              EditorID = it.EditorID,
              Editor = it.Editor,
          }).OrderBy(it => it.ID, OrderByType.Desc).ToList();

            t.Code = 0;
            t.TotalNumber = listMode.Count;
            t.Data = listMode;
            t.Msg = "成功";
            return t;
        }

        /// <summary>
        /// 获取急救调度任务单信息
        /// </summary>
        /// <param name="patientGuid">患者编号(GUID)</param>
        /// <returns></returns>
        public string GetDispatchOrderInfo(string patientGuid)
        {
            string SqlStr = string.Format(@"SELECT a.PatientGuid,a.[GUID],b.Name,b.Age,c.GenderName,b.MobilePhone,b.Attack_Address,a.CallHelpTime,a.DiseaseTime,b.IdentityCard,d.PlateNumber as AmbulanceNumber,e.Code as WristStrapNumber,b.EqmtNo AS EquipmentNumber,b.Note,a.SendAmbulanceTime,a.CreationDate,b.Creator,f.Name AS HospitalName
                FROM T_Service_120FirstAid a
                LEFT JOIN T_Service_Patient b ON a.PatientGuid=b.[GUID]
                LEFT JOIN T_Base_Gender c ON c.GenderCode=b.Gender
                LEFT JOIN T_Base_Ambulance d ON b.AmbulanceGuid=d.[GUID]
                LEFT JOIN T_Base_WristStrap e ON b.WristStrapID=e.ID
                LEFT JOIN T_Base_Hospital f ON b.HospitalGuid=f.[GUID]
                WHERE a.PatientGuid='{0}' AND a.DeleteFlag=0 AND b.DeleteFlag=0", patientGuid);

            DataTable dt = db.Ado.GetDataTable(SqlStr);
            string items = "";

            if (dt.Rows.Count > 0)
            {
                foreach (DataRow item in dt.Rows)
                {
                    string row = "";
                    for (int i = 0; i < dt.Columns.Count; i++)
                    {
                        row += JsonConvert.SerializeObject(dt.Columns[i].ColumnName) + ":";
                        row += JsonConvert.SerializeObject(item[i]) + ",";
                    }
                    row = row.Remove(row.Length - 1);
                    items += "{" + row + "}" + ",";

                }
                items = items.Remove(items.Length - 1);
            }
            items = "[" + items + "]";
            return items;
        }
    }
}