public List <DB_MC_PATIENT_INFO> GetPatListByID(JWT_Form_Body form)
{
string actionName = "GetPatListByID";
List <DB_MC_PATIENT_INFO> pList = new List <DB_MC_PATIENT_INFO>();
Dapper.DynamicParameters dp = new Dapper.DynamicParameters();
string sql = "SELECT * FROM " + DB_TABLE_NAME.DB_MC_PATIENT_INFO + " WHERE 1=1 ";
if (!string.IsNullOrWhiteSpace(form.site_id))
{
sql += " AND SITE_ID =@SITE_ID";
dp.Add("SITE_ID", form.site_id);
}
if (!string.IsNullOrWhiteSpace(form.hosp_id))
{
sql += " AND HOSP_KEY LIKE @HOSP_KEY";
dp.Add("HOSP_KEY", form.hosp_id + '%');
}
pList = DBLink.DBA.getSqlDataTable <DB_MC_PATIENT_INFO>(sql, dp);
pList.ForEach(x => {
x.EXPECTED_ARRIVAL_DATETIME = !string.IsNullOrWhiteSpace(x.EXPECTED_ARRIVAL_DATETIME) ? Function_Library.getDateString(DateTime.Parse(x.EXPECTED_ARRIVAL_DATETIME), DATE_FORMAT.yyyy_MM_dd_HHmm) : "";
x.SELECTION_DATETIME = !string.IsNullOrWhiteSpace(x.SELECTION_DATETIME) ? Function_Library.getDateString(DateTime.Parse(x.SELECTION_DATETIME), DATE_FORMAT.yyyy_MM_dd_HHmm) : "";
});
return(pList);
}
public List <DB_MC_PATIENT_INFO> GetPatListAll(JWT_Form_Body form)
{
string actionName = "GetPatListAll";
List <DB_MC_PATIENT_INFO> pList = new List <DB_MC_PATIENT_INFO>();
string sql = "SELECT * FROM " + DB_TABLE_NAME.DB_MC_PATIENT_INFO;
pList = DBLink.DBA.getSqlDataTable <DB_MC_PATIENT_INFO>(sql);
return(pList);
}
public List <VIEW_MC_HOSP_INFO> GetHospList(JWT_Form_Body form)
{
List <VIEW_MC_HOSP_INFO> pList = Newtonsoft.Json.JsonConvert.DeserializeObject <List <VIEW_MC_HOSP_INFO> >(Newtonsoft.Json.JsonConvert.SerializeObject(MvcApplication.hospList.ToList()));
string actionName = "GetHospList";
pList.ForEach(x => {
x.hosp_desc = x.HOSP_KEY;
x.hosp_name = x.HOSP_NAME;
x.hosp_class = x.DIVISION.Trim();
x.hosp_city = x.CITY;
x.hosp_injury = x.CITY;
x.hosp_ranking = x.NEW_RANKING;
x.hosp_erbed = x.ORIGINAL_RANKING;
});
return(pList);
}
public Dictionary <string, DB_MC_SOURCE_LIST> GetHospListDTLByID(JWT_Form_Body form)
{
Dictionary <string, DB_MC_SOURCE_LIST> dic = new Dictionary <string, DB_MC_SOURCE_LIST>();
string actionName = "GetHospListDTLByID";
List <DB_MC_SOURCE_LIST> pList = new List <DB_MC_SOURCE_LIST>();
Dapper.DynamicParameters dp = new Dapper.DynamicParameters();
string sql = "SELECT * FROM " + DB_TABLE_NAME.DB_MC_SOURCE_LIST + " WHERE DATASTATUS = '1' AND SITE_ID =@SITE_ID";
dp.Add("SITE_ID", form.site_id);
pList = DBLink.DBA.getSqlDataTable <DB_MC_SOURCE_LIST>(sql, dp);
foreach (DB_MC_SOURCE_LIST item in pList)
{
dic.Add(item.HOSP_KEY, item);
}
return(dic);
}
public List <DB_MC_HOSP_INFO> HospInfoList(JWT_Form_Body form)
{
List <DB_MC_HOSP_INFO> pList = new List <DB_MC_HOSP_INFO>();
return(pList);
}
public string JwtAuthCheck(JWT_Form_Body form)
{
return("合法登入!");
}