private Models.InfoData MapData(DataTable dt) { Models.InfoData result = new Models.InfoData(); result.BedId = (int)dt.Rows[0]["BedId"]; result.PatientId = dt.Rows[0]["PatientId"].ToString(); result.Division = dt.Rows[0]["DivisionName"].ToString(); result.DivisionId = dt.Rows[0]["DivisionId"].ToString(); result.PatientIdNo = dt.Rows[0]["PatientIdNo"].ToString(); result.PatientBirth = dt.Rows[0]["PatientBirth"].ToString(); result.PatientInICU = dt.Rows[0]["PatientInICU"].ToString(); result.PatientAdmdt = dt.Rows[0]["PatientAdmdt"].ToString(); result.PatientWeight = dt.Rows[0]["PatientWeight"].ToString(); result.PatientHeight = dt.Rows[0]["PatientHeight"].ToString(); result.PatientName = dt.Rows[0]["PatientName"].ToString(); result.DoctorName = dt.Rows[0]["DoctorName"].ToString(); result.NurseName = dt.Rows[0]["NurseName"].ToString(); return(result); }
/// <summary> /// GetPatientData /// </summary> /// <param name="data"></param> /// <returns></returns> public Models.InfoData GetPatientData(Models.InfoData data) { DataTable dt = new DataTable(); string sql = @"SELECT pai.patient_bed as BedId, pai.patient_hisid as PatientId, pai.patient_division as DivisionId , di.division_ename as DivisionName, pai.PATEINT_ID as PatientIdNo, CONVERT(char(10),pai.patient_birth,126) as PatientBirth, CONVERT(char(10),pai.patient_inicu,126) as PatientInICU, CONVERT(char(10),pai.patient_admdt,126) as PatientAdmdt, pai.patient_weight as PatientWeight, pai.PATTIENT_HEIGHT as PatientHeight, pai.patient_name as PatientName, pai.patient_doctor_id as DoctorId, doi.doctor_name as DoctorName, ul.user_name as NurseName FROM PATIENT_INFO pai INNER JOIN DIVISION_INFO di ON pai.PATIENT_DIVISION = di.division_id INNER JOIN doctor_info doi on pai.patient_doctor_id = doi.doctor_id INNER JOIN user_login ul on pai.PATIENT_NURSE_ID_1 = ul.user_id Where patient_hisid = @PatientId"; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@PatientId", data.PatientId)); SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd); sqlAdapter.Fill(dt); conn.Close(); } return(MapData(dt)); }
public List <Models.InfoData> GetInfoByCondtioin(Models.InfoData data) { DataTable dt = new DataTable(); string sql = @"SELECT pai.patient_bed as BedId, pai.patient_division as DivisionId , di.division_ename as DivisionName, pai.patient_hisid as PatientID, pai.patient_name as PatientName, pai.patient_doctor_id as DoctorId, doi.doctor_name as DoctorName, ul.user_name as NurseName FROM PATIENT_INFO pai INNER JOIN DIVISION_INFO di ON pai.PATIENT_DIVISION = di.division_id INNER JOIN doctor_info doi on pai.patient_doctor_id = doi.doctor_id INNER JOIN user_login ul on pai.PATIENT_NURSE_ID_1 = ul.user_id WHERE (pai.patient_hisid LIKE ('%'+@PatientId+'%') OR @PatientId='' )AND (pai.patient_division LIKE ('%'+@DivisionId+'%') OR @DivisionId='')AND (pai.patient_doctor_id LIKE ('%'+@DoctorId+'%') OR @DoctorId='' ) ORDER BY pai.patient_bed"; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@DivisionId", data.DivisionId == null ? string.Empty : data.DivisionId)); cmd.Parameters.Add(new SqlParameter("@DoctorId", data.DoctorId == null ? string.Empty : data.DoctorId)); cmd.Parameters.Add(new SqlParameter("@PatientId", data.PatientId == null ? string.Empty : data.PatientId)); SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd); sqlAdapter.Fill(dt); conn.Close(); } return(this.MapBookDataToListForSearch(dt)); }
public JsonResult GetPatientData(Models.InfoData data) { return(Json(this.infoservice.GetPatientData(data))); }
/// <summary> /// getsearchgrid /// </summary> /// <param name="data"></param> /// <returns></returns> public JsonResult GetGridData(Models.InfoData data) { return(Json(this.infoservice.GetInfoByCondtioin(data))); }