//反填
public T GetFanTable <T>(int id, string key)
{
string sql = GetHelper.GetFanSql <T>(id, key);
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <T>(dataSet.Tables[0])[0]);
}
//诊断管理
public List <Disease_records_Model> Get_zdgl()
{
string sql = $"select createtime,sum(_money) Total,count(id) Patients from Disease_records group by createtime";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Disease_records_Model>(dataSet.Tables[0]));
}
/// <summary>
/// 显示表信息
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
public List <T> GetShowTable <T>()
{
string sql = GetHelper.GetShowSql <T>();
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <T>(dataSet.Tables[0]));
}
//诊断列表
public List <Disease_records_Model> Get_Administrationlist(string sickdate)
{
string sql = $"select* from Disease_records join patient on Disease_records.patient_Id = patient.id where Disease_records.createtime = '{sickdate}' ";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Disease_records_Model>(dataSet.Tables[0]));
}
//已接诊
public List <Disease_records_Model> Get_yes()
{
string sql = $"select *from Disease_records join patient on Disease_records.patient_Id=patient.id where seate=1";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Disease_records_Model>(dataSet.Tables[0]));
}
///Bll医生诊断 HCM添加
/// <summary>
/// 获取所属医生的患者资料 是否接诊 未0 已接诊1
/// </summary>
/// <param name="DoctorId">医生 id</param>
/// <param name="seate">是否接诊 未0 已接诊1</param>
/// <returns></returns>
public List <Patient_Model> GetDoctPatiList(int DoctorId, int seate)
{
string sql = $"select * from patient where DoctorId={DoctorId} and seate={seate}";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Patient_Model>(dataSet.Tables[0]));
}
/// <summary>
/// 获取所属医生金额表
/// </summary>
/// <param name="Doctor_ID">医生id</param>
/// <returns></returns>
public List <Doctor_money_Model> GetDoctPatiList(int Doctor_ID)
{
string sql = $"select * from Doctor_money where Doctor_ID={Doctor_ID}";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Doctor_money_Model>(dataSet.Tables[0]));
}
/// <summary>
/// 诊断报告表
/// </summary>
/// <param name="Disease_records_id">诊断记录表ID</param>
/// <returns></returns>
public List <Patient_Model> GetPati_DiagnosisList(int Disease_records_id)
{
string sql = $"select patient.*,describe,diagnosis from patient join Disease_records on patient.id=Disease_records.patient_Id where Disease_records.id={Disease_records_id}";
DataSet dataSet = helper.GetDataSet(sql);
return(GetHelper.DatatableTolist <Patient_Model>(dataSet.Tables[0]));
}
//好评评价
public Disease_records_Model Get_Acclaim(string id)
{
string sql = $"select * from Disease_records join patient on Disease_records.patient_Id=patient.id where Disease_records.id='{id}'";
DataSet dataSet = helper.GetDataSet(sql);
var list = GetHelper.DatatableTolist <Disease_records_Model>(dataSet.Tables[0]);
return(list[0]);
}
//健康档案
public Patient_Model Get_By(string id)
{
string sql = $"select * from patient join Disease_records on Disease_records.patient_Id=patient.id where patient.id='{id}'";
DataSet dataSet = helper.GetDataSet(sql);
var list = GetHelper.DatatableTolist <Patient_Model>(dataSet.Tables[0]);
return(list[0]);
}
/// <summary>
/// 医生绑定的银行卡
/// </summary>
/// <param name="id"></param>
/// <param name="Doctor_ID"></param>
/// <returns></returns>
public List <Doctor_bankcard_Model> GetBindBank(int id, int Doctor_ID)
{
string sql = $"select Doctor_bankcard.* from Doctor_money join Doctor_bankcard on Doctor_money.id = Doctor_bankcard.Doctor_moneyId where Doctor_money.id={id} and Doctor_ID={Doctor_ID}";
DataSet ds = helper.GetDataSet(sql);
List <Doctor_bankcard_Model> list = GetHelper.DatatableTolist <Doctor_bankcard_Model>(ds.Tables[0]);
//Doctor_money_Model doc_money = list[0];
return(list);
}
public List <Doctor_money_Model> GetDoctor_money(int Doctor_ID)
{
string sql = $"select * from Doctor_money where Doctor_ID = {Doctor_ID}";
DataSet ds = helper.GetDataSet(sql);
List <Doctor_money_Model> list = GetHelper.DatatableTolist <Doctor_money_Model>(ds.Tables[0]);
//Doctor_money_Model doc_money = list[0];
return(list);
}
