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("合法登入!"); }