//反填 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); }