178 lines
7.4 KiB
C#
178 lines
7.4 KiB
C#
|
using HL_FristAidPlatform_Help;
|
|||
|
using HL_FristAidPlatform_IDataBase;
|
|||
|
using HL_FristAidPlatform_Models;
|
|||
|
using SqlSugar;
|
|||
|
using System.Collections.Generic;
|
|||
|
|
|||
|
namespace HL_FristAidPlatform_DataBase
|
|||
|
{
|
|||
|
/// <summary>
|
|||
|
/// 胸痛首次医疗接触
|
|||
|
/// </summary>
|
|||
|
public class T_Service_ChestPain_FirstMedicalReceptionDB : BaseDB, IT_Service_ChestPain_FirstMedicalReception
|
|||
|
{
|
|||
|
public SqlSugarClient db = GetClient();
|
|||
|
|
|||
|
/// <summary>
|
|||
|
/// 增加一条数据
|
|||
|
/// </summary>
|
|||
|
public T_Service_ChestPain_FirstMedicalReception Add(T_Service_ChestPain_FirstMedicalReception model)
|
|||
|
{
|
|||
|
return db.Insertable(model).ExecuteReturnEntity();
|
|||
|
}
|
|||
|
|
|||
|
/// <summary>
|
|||
|
/// 更新一条数据
|
|||
|
/// </summary>
|
|||
|
public bool Update(T_Service_ChestPain_FirstMedicalReception model)
|
|||
|
{
|
|||
|
return db.Updateable(model).ExecuteCommand() == 0 ? false : true;
|
|||
|
}
|
|||
|
|
|||
|
/// <summary>
|
|||
|
/// 只更新指定字段
|
|||
|
/// 更新肌钙蛋白cTnI值 患者编号+cTnI值
|
|||
|
/// </summary>
|
|||
|
/// <param name="model"></param>
|
|||
|
/// <returns></returns>
|
|||
|
public int UpdateCTnI(T_Service_ChestPain_FirstMedicalReception model)
|
|||
|
{
|
|||
|
return db.Updateable(model).UpdateColumns(it => new { it.CTnI_Value, it.CTnI_Unit, it.CTnI_Status }).ExecuteCommand();
|
|||
|
}
|
|||
|
|
|||
|
/// <summary>
|
|||
|
/// 删除一条数据
|
|||
|
/// </summary>
|
|||
|
public bool Delete(long ID)
|
|||
|
{
|
|||
|
return db.Deleteable<T_Service_ChestPain_FirstMedicalReception>(it => it.ID == ID).ExecuteCommand() == 0 ? false : true; ;
|
|||
|
}
|
|||
|
|
|||
|
/// <summary>
|
|||
|
/// 获得数据列表
|
|||
|
/// </summary>
|
|||
|
public TableModel<T_Service_ChestPain_FirstMedicalReception> GetPageList(int pageIndex, int pageSize)
|
|||
|
{
|
|||
|
int total = 0;
|
|||
|
List<T_Service_ChestPain_FirstMedicalReception> data = db.Queryable<T_Service_ChestPain_FirstMedicalReception>().Where(it => it.DeleteFlag == 0).ToPageList(pageIndex, pageSize, ref total);
|
|||
|
TableModel<T_Service_ChestPain_FirstMedicalReception> t = new TableModel<T_Service_ChestPain_FirstMedicalReception>();
|
|||
|
t.Code = 0;
|
|||
|
t.PageCount = data.Count;
|
|||
|
t.TotalNumber = total;
|
|||
|
t.Data = data;
|
|||
|
t.Msg = "成功";
|
|||
|
return t;
|
|||
|
}
|
|||
|
|
|||
|
/// <summary>
|
|||
|
/// 获得前几行数据
|
|||
|
/// </summary>
|
|||
|
public T_Service_ChestPain_FirstMedicalReception Get(long ID)
|
|||
|
{
|
|||
|
return db.Queryable<T_Service_ChestPain_FirstMedicalReception>().First(it => it.ID == ID);
|
|||
|
}
|
|||
|
|
|||
|
/// <summary>
|
|||
|
/// 根据患者编号(GUID) 获取数据信息
|
|||
|
/// </summary>
|
|||
|
/// <param name="patientGuid">病人编号(GUID)</param>
|
|||
|
/// <returns></returns>
|
|||
|
public TableModel<T_Service_ChestPain_FirstMedicalReception> GetByPatientGuid(string patientGuid)
|
|||
|
{
|
|||
|
TableModel<T_Service_ChestPain_FirstMedicalReception> t = new TableModel<T_Service_ChestPain_FirstMedicalReception>();
|
|||
|
|
|||
|
var listMode = db.Queryable<T_Service_ChestPain_FirstMedicalReception>().Where(it => it.PatientGuid == patientGuid && it.DeleteFlag == 0)
|
|||
|
.Select(it => new T_Service_ChestPain_FirstMedicalReception
|
|||
|
{
|
|||
|
ID = it.ID,
|
|||
|
GUID = it.GUID,
|
|||
|
PatientGuid = it.PatientGuid,
|
|||
|
First_Organization = it.First_Organization,
|
|||
|
First_Organization_Name = it.First_Organization_Name,
|
|||
|
First_Doctor_Name = it.First_Doctor_Name,
|
|||
|
First_Organization_Time = it.First_Organization_Time,
|
|||
|
OutHospital_ECG_Time = it.OutHospital_ECG_Time,
|
|||
|
InHospital_ECG_Time = it.InHospital_ECG_Time,
|
|||
|
ECG_Diagnose_Time = it.ECG_Diagnose_Time,
|
|||
|
Is_Remote_Ecgtran = it.Is_Remote_Ecgtran,
|
|||
|
Remote_Ecgtran_Time = it.Remote_Ecgtran_Time,
|
|||
|
Remote_Ecgtran_Type = it.Remote_Ecgtran_Type,
|
|||
|
Be_Conscious_Of = it.Be_Conscious_Of,
|
|||
|
Breathe = it.Breathe,
|
|||
|
Pulse = it.Pulse,
|
|||
|
Heart_Rate = it.Heart_Rate,
|
|||
|
Blood_Pressure = it.Blood_Pressure,
|
|||
|
Killip_Level = it.Killip_Level,
|
|||
|
Troponin_Sampling_Time = it.Troponin_Sampling_Time,
|
|||
|
Troponin_Report_Time = it.Troponin_Report_Time,
|
|||
|
CTnI_Value = it.CTnI_Value,
|
|||
|
CTnI_Unit = it.CTnI_Unit,
|
|||
|
CTnI_Status = it.CTnI_Status,
|
|||
|
CTnT_Value = it.CTnT_Value,
|
|||
|
CTnT_Unit = it.CTnT_Unit,
|
|||
|
CTnT_Status = it.CTnT_Status,
|
|||
|
Cr_Value = it.Cr_Value,
|
|||
|
Cr_Unit = it.Cr_Unit,
|
|||
|
Acs_Delivery_Time = it.Acs_Delivery_Time,
|
|||
|
Aspirin_Dose = it.Aspirin_Dose,
|
|||
|
Aspirin_Dose_Type = it.Aspirin_Dose_Type,
|
|||
|
Acs_Drug_Dose = it.Acs_Drug_Dose,
|
|||
|
Is_Anticoagulation = it.Is_Anticoagulation,
|
|||
|
Anticoagulation_Time = it.Anticoagulation_Time,
|
|||
|
Anticoagulation_Drug = it.Anticoagulation_Drug,
|
|||
|
Anticoagulation_Unit = it.Anticoagulation_Unit,
|
|||
|
Is_Thrombolytic_Screening = it.Is_Thrombolytic_Screening,
|
|||
|
Is_Thrombolytic_Therapy = it.Is_Thrombolytic_Therapy,
|
|||
|
Is_Direct = it.Is_Direct,
|
|||
|
Thrombolytic_Site = it.Thrombolytic_Site,
|
|||
|
Start_Agree_Time = it.Start_Agree_Time,
|
|||
|
Sign_Agree_Time = it.Sign_Agree_Time,
|
|||
|
Throm_Start_Time = it.Throm_Start_Time,
|
|||
|
Throm_End_Time = it.Throm_End_Time,
|
|||
|
Start_Radiography_Time = it.Start_Radiography_Time,
|
|||
|
Throm_Drug_Type = it.Throm_Drug_Type,
|
|||
|
Throm_Drug_Code = it.Throm_Drug_Code,
|
|||
|
Is_Repatency = it.Is_Repatency,
|
|||
|
Grace_Code = it.Grace_Code,
|
|||
|
Grace_CodeText = it.Grace_CodeText,
|
|||
|
Is_Arrest = it.Is_Arrest,
|
|||
|
Is_Change = it.Is_Change,
|
|||
|
Is_Rise = it.Is_Rise,
|
|||
|
Grace_Value = it.Grace_Value,
|
|||
|
Risk_Lamination = it.Risk_Lamination,
|
|||
|
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>
|
|||
|
/// 根据where条件查询列表
|
|||
|
/// </summary>
|
|||
|
/// <param name="where"></param>
|
|||
|
/// <returns></returns>
|
|||
|
public TableModel<Patient_FirstMedicalReception> GetModelByReport(string where)
|
|||
|
{
|
|||
|
string sql = "select a.Name,a.CreationDate,b.Is_Remote_Ecgtran from T_Service_Patient a join T_Service_ChestPain_FirstMedicalReception b on a.GUID=b.PatientGuid WHERE a.DeleteFlag = 0 and " + where + "";
|
|||
|
List<Patient_FirstMedicalReception> data = db.Ado.SqlQuery<Patient_FirstMedicalReception>(sql);
|
|||
|
TableModel<Patient_FirstMedicalReception> t = new TableModel<Patient_FirstMedicalReception>();
|
|||
|
t.Code = 0;
|
|||
|
t.PageCount = data.Count;
|
|||
|
t.TotalNumber = data.Count;
|
|||
|
t.Data = data;
|
|||
|
t.Msg = "成功";
|
|||
|
return t;
|
|||
|
}
|
|||
|
}
|
|||
|
}
|