76 lines
2.5 KiB
C#
76 lines
2.5 KiB
C#
using HL_FristAidPlatform_Help;
|
|
using HL_FristAidPlatform_IDataBase;
|
|
using HL_FristAidPlatform_Models;
|
|
using SqlSugar;
|
|
using System.Collections.Generic;
|
|
|
|
namespace HL_FristAidPlatform_DataBase
|
|
{
|
|
public class T_Base_DiagnoseDB : BaseDB, IT_Base_Diagnose
|
|
{
|
|
public SqlSugarClient db = GetClient();
|
|
#region 诊断详情表
|
|
/// <summary>
|
|
/// 根据ID获取实体
|
|
/// </summary>
|
|
/// <param name="id"></param>
|
|
/// <returns></returns>
|
|
public T_Base_Diagnose GetDiagnosisDetailById(int id)
|
|
{
|
|
return db.Queryable<T_Base_Diagnose>().Where(i => i.ID == id).First();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据Name 获取实体
|
|
/// </summary>
|
|
/// <param name="id"></param>
|
|
/// <returns></returns>
|
|
public List<T_Base_Diagnose> GetDiagnosisDetailByName(string name)
|
|
{
|
|
List<T_Base_Diagnose> result = null;
|
|
if (!string.IsNullOrEmpty(name))
|
|
{
|
|
result = db.Queryable<T_Base_Diagnose>().Where(i => i.Name.Contains(name) || i.Code.Contains(name) || i.PinyinCode.Contains(name) || i.StrokeCodes.Contains(name)).ToList();
|
|
}
|
|
return result;
|
|
}
|
|
|
|
public List<T_Base_Diagnose> GetDiagnosisDetailAll()
|
|
{
|
|
return db.Queryable<T_Base_Diagnose>().OrderBy(i => i.ID, OrderByType.Asc).ToList();
|
|
}
|
|
/// <summary>
|
|
/// 保存诊断详情
|
|
/// </summary>
|
|
/// <param name="department"></param>
|
|
/// <returns></returns>
|
|
public bool SaveDiagnosisDetail(T_Base_Diagnose department)
|
|
{
|
|
|
|
return db.Insertable(department).IgnoreColumns(it=>new { it.ID}).ExecuteCommand() == 1 ? true : false;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改诊断详情
|
|
/// </summary>
|
|
/// <param name="department"></param>
|
|
/// <returns></returns>
|
|
public bool UpdateDiagnosisDetail(T_Base_Diagnose department)
|
|
{
|
|
return db.Updateable(department).Where(i => i.ID == department.ID).ExecuteCommand() == 1 ? true : false;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除诊断
|
|
/// </summary>
|
|
/// <param name="department"></param>
|
|
/// <returns></returns>
|
|
public bool DeleteDiagnosisDetail(int ID)
|
|
{
|
|
return db.Deleteable<T_Base_Diagnose>().Where(i => i.ID == ID).ExecuteCommand() == 1 ? true : false;
|
|
}
|
|
#endregion
|
|
|
|
}
|
|
}
|