public List <VIEW_DB_HOSP_INFO_DTL> GET_HOSP_DATA_DTL(string PATIENT_ID) { RCS_Data.SQLProvider dblink = new RCS_Data.SQLProvider("MC_DbConnection"); List <DB_MC_PATIENT_INFO> patList = new List <DB_MC_PATIENT_INFO>(); Dapper.DynamicParameters dp = new Dapper.DynamicParameters(); string sql = "SELECT * FROM " + DB_TABLE_NAME.DB_MC_PATIENT_INFO + " WHERE PATIENT_ID = @PATIENT_ID AND DATASTATUS = '1'"; dp.Add("PATIENT_ID", PATIENT_ID); patList = dblink.DBA.getSqlDataTable <DB_MC_PATIENT_INFO>(sql, dp); List <VIEW_DB_HOSP_INFO_DTL> pList = new List <VIEW_DB_HOSP_INFO_DTL>(); return(pList); }
public string INSERT_PAT_DATA( string PATIENT_NAME, string PATIENT_ID, string LOCATION, string LATITUDE, string LONGITUDE, string AGE, string GENDER, string CITY, string COUNTRY, string TRIAGE, string EXPECTED_ARRIVAL_DATETIME, string LOGIN_DATETIME, string SELECTION_DATETIME, string HOSP_KEY, string HOSPITAL_SHOW_NAME) { RCS_Data.SQLProvider dblink = new RCS_Data.SQLProvider("MC_DbConnection"); string SITE_ID = RCS_Data.Models.Function_Library.getDateNowString(RCS_Data.Models.DATE_FORMAT.yyyyMMddHHmmssfffff); #region 民眾版 新增 lcoation List <DB_MC_SITE_INFO> sList = new List <DB_MC_SITE_INFO>(); sList.Add(new DB_MC_SITE_INFO() { SITE_ID = SITE_ID, CREATE_DATE = Function_Library.getDateNowString(DATE_FORMAT.yyyy_MM_dd_HHmmss), CREATE_ID = "ws", CREATE_NAME = "ws", MODIFY_DATE = Function_Library.getDateNowString(DATE_FORMAT.yyyy_MM_dd_HHmmss), MODIFY_ID = "ws", MODIFY_NAME = "ws", DATASTATUS = "1", LATITUDE = LATITUDE, LONGITUDE = LONGITUDE, }); dblink.DBA.DBExecInsert <DB_MC_SITE_INFO>(sList); #endregion List <string> msg = new List <string>(); WSresponse rm = new WSresponse(); if (string.IsNullOrWhiteSpace(PATIENT_NAME)) { msg.Add("請輸入病患姓名!"); } if (msg.Count > 0) { rm.success = false; rm.msg = string.Join(",", msg); return(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); } List <DB_MC_PATIENT_INFO> pList = new List <DB_MC_PATIENT_INFO>(); pList.Add(new DB_MC_PATIENT_INFO() { PATIENT_ID = PATIENT_ID, PATIENT_NAME = PATIENT_NAME, SITE_ID = SITE_ID, LOCATION = LOCATION, AGE = AGE, GENDER = GENDER, CITY = CITY, COUNTRY = COUNTRY, TRIAGE = TRIAGE, TRANSPORTATION = "", AMB_ID = "", EXPECTED_ARRIVAL_DATETIME = EXPECTED_ARRIVAL_DATETIME, LOGIN_DATETIME = LOGIN_DATETIME, SELECTION_DATETIME = SELECTION_DATETIME, HOSP_KEY = HOSP_KEY, HOSPITAL_SHOW_NAME = HOSPITAL_SHOW_NAME, CREATE_ID = "ws", CREATE_NAME = "ws", CREATE_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), MODIFY_ID = "ws", MODIFY_NAME = "ws", MODIFY_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), DATASTATUS = "1", }); dblink.DBA.DBExecInsert <DB_MC_PATIENT_INFO>(pList); if (dblink.DBA.hasLastError) { rm.success = false; rm.msg = dblink.DBA.lastError; return(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); } if (msg.Count > 0) { rm.success = false; rm.msg = string.Join(",", msg); return(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); } rm.success = true; rm.msg = "success"; rm.PATIENT_ID = PATIENT_ID; return(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); }
public void SELECT_HOSP_BY_PATIENT_ID(string PATIENT_ID, string HOSP_KEY) { // 指定編碼 Context.Response.HeaderEncoding = Encoding.UTF8; // 加入BOM Context.Response.BinaryWrite(new byte[] { 0xEF, 0xBB, 0xBF }); string actionName = "SELECT_HOSP_BY_PATIENT_ID"; List <string> msg = new List <string>(); WSresponse rm = new WSresponse(); RCS_Data.SQLProvider dblink = new RCS_Data.SQLProvider("MC_DbConnection"); if (string.IsNullOrWhiteSpace(PATIENT_ID)) { msg.Add("沒有傷患編號!無法修改!"); } if (string.IsNullOrWhiteSpace(HOSP_KEY)) { msg.Add("沒有選擇醫院!無法修改!"); } if (msg.Count > 0) { rm.success = false; rm.msg = string.Join(",", msg); Com.Mayaminer.LogTool.SaveLogMessage(this.dblink.DBA.lastError, actionName, this.csName); Context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); // return Newtonsoft.Json.JsonConvert.SerializeObject(rm); } else { List <DB_MC_PATIENT_INFO> pList = dblink.DBA.getSqlDataTable <DB_MC_PATIENT_INFO>(string.Format("SELECT * FROM MC_PATIENT_INFO WHERE PATIENT_ID = '{0}';", PATIENT_ID)); if (pList.Count > 0) { pList[0].HOSP_KEY = HOSP_KEY; pList[0].MODIFY_ID = "SYS"; pList[0].MODIFY_NAME = "SYS"; pList[0].MODIFY_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); pList[0].DATASTATUS = "1"; } dblink.DBA.DBExecUpdate <DB_MC_PATIENT_INFO>(pList); if (dblink.DBA.hasLastError) { rm.success = false; rm.msg = dblink.DBA.lastError; Context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); // return Newtonsoft.Json.JsonConvert.SerializeObject(rm); } else { if (msg.Count > 0) { rm.success = false; rm.msg = string.Join(",", msg); Context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); // return Newtonsoft.Json.JsonConvert.SerializeObject(rm); } else { rm.success = true; rm.msg = "修改醫院成功!"; rm.PATIENT_ID = PATIENT_ID; Context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); // return Newtonsoft.Json.JsonConvert.SerializeObject(rm); } } } }
public string UPDATE_PAT_DATA(string PATIENT_ID, string PATIENT_NAME, string AGE, string GENDER, string CITY, string COUNTRY, string TRIAGE, string EXPECTED_ARRIVAL_DATETIME, string LOGIN_DATETIME, string SELECTION_DATETIME, string HOSP_KEY, string HOSPITAL_SHOW_NAME, string HOSP_TO_PAT_SCORE, string HOSP_TO_PAT_SCORE_LEVEL) { List <string> msg = new List <string>(); WSresponse rm = new WSresponse(); RCS_Data.SQLProvider dblink = new RCS_Data.SQLProvider("MC_DbConnection"); if (string.IsNullOrWhiteSpace(PATIENT_ID)) { msg.Add("沒有傷患編號!無法修改!"); } if (msg.Count > 0) { rm.success = false; rm.msg = string.Join(",", msg); return(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); } List <DB_MC_PATIENT_INFO> pList = dblink.DBA.getSqlDataTable <DB_MC_PATIENT_INFO>(string.Format("SELECT * FROM MC_PATIENT_INFO WHERE PATIENT_ID = '{0}';", PATIENT_ID)); if (pList.Count > 0) { pList[0].PATIENT_ID = dblink.GetFixedStrSerialNumber(); pList[0].PATIENT_NAME = PATIENT_NAME; pList[0].AGE = AGE; pList[0].GENDER = GENDER; pList[0].CITY = CITY; pList[0].COUNTRY = COUNTRY; pList[0].TRIAGE = TRIAGE; pList[0].EXPECTED_ARRIVAL_DATETIME = EXPECTED_ARRIVAL_DATETIME; pList[0].LOGIN_DATETIME = LOGIN_DATETIME; pList[0].SELECTION_DATETIME = SELECTION_DATETIME; pList[0].HOSP_KEY = HOSP_KEY; pList[0].HOSPITAL_SHOW_NAME = HOSPITAL_SHOW_NAME; pList[0].MODIFY_ID = "SYS"; pList[0].MODIFY_NAME = "SYS"; pList[0].MODIFY_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); pList[0].DATASTATUS = "1"; pList[0].HOSP_TO_PAT_SCORE = HOSP_TO_PAT_SCORE; pList[0].HOSP_TO_PAT_SCORE_LEVEL = HOSP_TO_PAT_SCORE_LEVEL; } pList.Add(new DB_MC_PATIENT_INFO() { PATIENT_ID = dblink.GetFixedStrSerialNumber(), PATIENT_NAME = PATIENT_NAME, SITE_ID = "9999", AGE = AGE, GENDER = GENDER, CITY = CITY, COUNTRY = COUNTRY, TRIAGE = TRIAGE, TRANSPORTATION = "", AMB_ID = "", EXPECTED_ARRIVAL_DATETIME = EXPECTED_ARRIVAL_DATETIME, LOGIN_DATETIME = LOGIN_DATETIME, SELECTION_DATETIME = SELECTION_DATETIME, HOSP_KEY = HOSP_KEY, HOSPITAL_SHOW_NAME = HOSPITAL_SHOW_NAME, CREATE_ID = "SYS", CREATE_NAME = "SYS", CREATE_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), MODIFY_ID = "SYS", MODIFY_NAME = "SYS", MODIFY_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), DATASTATUS = "1", ARRIVAL_FLAG = "", GUEST_FLAG = "", HOSP_TO_PAT_SCORE = HOSP_TO_PAT_SCORE, HOSP_TO_PAT_SCORE_LEVEL = HOSP_TO_PAT_SCORE_LEVEL }); dblink.DBA.DBExecInsert <DB_MC_PATIENT_INFO>(pList); if (dblink.DBA.hasLastError) { rm.success = false; rm.msg = dblink.DBA.lastError; return(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); } if (msg.Count > 0) { rm.success = false; rm.msg = string.Join(",", msg); return(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); } rm.success = true; rm.msg = "success"; rm.PATIENT_ID = PATIENT_ID; return(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); }
public void UPDATE_PATDATA(string PATIENT_ID, string PATIENT_NAME, string AGE, string GENDER, string CITY, string COUNTRY, string TRIAGE, string EXPECTED_ARRIVAL_DATETIME, string SELECTION_DATETIME, string HOSP_KEY, string SCORE) { // 指定編碼 Context.Response.HeaderEncoding = Encoding.UTF8; // 加入BOM Context.Response.BinaryWrite(new byte[] { 0xEF, 0xBB, 0xBF }); string actionName = "UPDATE_PAT_DATA"; List <string> msg = new List <string>(); WSresponse rm = new WSresponse(); RCS_Data.SQLProvider dblink = new RCS_Data.SQLProvider("MC_DbConnection"); if (string.IsNullOrWhiteSpace(PATIENT_ID)) { msg.Add("沒有傷患編號!無法修改!"); } if (msg.Count > 0) { rm.success = false; rm.msg = string.Join(",", msg); Com.Mayaminer.LogTool.SaveLogMessage(this.dblink.DBA.lastError, actionName, this.csName); // return Newtonsoft.Json.JsonConvert.SerializeObject(rm); } else { List <DB_MC_PATIENT_INFO> pList = dblink.DBA.getSqlDataTable <DB_MC_PATIENT_INFO>(string.Format("SELECT * FROM MC_PATIENT_INFO WHERE PATIENT_ID = '{0}';", PATIENT_ID)); if (pList.Count > 0) { if (!string.IsNullOrWhiteSpace(PATIENT_NAME)) { pList[0].PATIENT_NAME = PATIENT_NAME; } if (!string.IsNullOrWhiteSpace(AGE)) { pList[0].AGE = AGE; } if (!string.IsNullOrWhiteSpace(GENDER)) { pList[0].GENDER = GENDER; } if (!string.IsNullOrWhiteSpace(CITY)) { pList[0].CITY = CITY; } if (!string.IsNullOrWhiteSpace(COUNTRY)) { pList[0].COUNTRY = COUNTRY; } if (!string.IsNullOrWhiteSpace(TRIAGE)) { pList[0].TRIAGE = TRIAGE; } if (!string.IsNullOrWhiteSpace(EXPECTED_ARRIVAL_DATETIME)) { pList[0].EXPECTED_ARRIVAL_DATETIME = EXPECTED_ARRIVAL_DATETIME; } if (!string.IsNullOrWhiteSpace(SELECTION_DATETIME)) { pList[0].SELECTION_DATETIME = SELECTION_DATETIME; } if (!string.IsNullOrWhiteSpace(HOSP_KEY)) { pList[0].HOSP_KEY = HOSP_KEY; } if (!string.IsNullOrWhiteSpace(SCORE)) { pList[0].SCORE = SCORE; } pList[0].MODIFY_ID = "SYS"; pList[0].MODIFY_NAME = "SYS"; pList[0].MODIFY_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); pList[0].DATASTATUS = "1"; } dblink.DBA.DBExecUpdate <DB_MC_PATIENT_INFO>(pList); if (dblink.DBA.hasLastError) { rm.success = false; rm.msg = dblink.DBA.lastError; Context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); // return Newtonsoft.Json.JsonConvert.SerializeObject(rm); } else { if (msg.Count > 0) { rm.success = false; rm.msg = string.Join(",", msg); Context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); // return Newtonsoft.Json.JsonConvert.SerializeObject(rm); } else { rm.success = true; rm.msg = "success"; rm.PATIENT_ID = PATIENT_ID; Context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rm)); // return Newtonsoft.Json.JsonConvert.SerializeObject(rm); } } } }