Esempio n. 1
0
        public int Update(ExamModel model)
        {
            Mapper.CreateMap <ExamModel, ExamMaster>();
            ExamMaster objUser = Dbcontext.ExamMasters.SingleOrDefault(m => m.EID == model.EID);

            objUser = Mapper.Map(model, objUser);
            return(Dbcontext.SaveChanges());
        }
Esempio n. 2
0
 public ExamModel getByID(int id)
 {
     try
     {
         Mapper.CreateMap <ExamMaster, ExamModel>();
         ExamMaster objCityMaster = Dbcontext.ExamMasters.Where(m => m.EID == id).SingleOrDefault();
         ExamModel  objCityItem   = Mapper.Map <ExamModel>(objCityMaster);
         return(objCityItem);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 3
0
 public int Insert(ExamModel model)
 {
     try
     {
         Mapper.CreateMap <ExamModel, ExamMaster>();
         ExamMaster objUser = Mapper.Map <ExamMaster>(model);
         Dbcontext.ExamMasters.Add(objUser);
         return(Dbcontext.SaveChanges());
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 4
0
        private void ExamList_SelectionChanged(object sender, EventArgs e)
        {
            if (this.ExamList.SelectedRows.Count <= 0)
            {
                this.txtReportDetial.Clear();
                return;
            }
            this.ShowStatusMessage("正在下载检查报告,请稍候...");
            GlobalMethods.UI.SetCursor(this, Cursors.WaitCursor);

            ExamMaster examInfo = (ExamMaster)this.ExamList.SelectedRows[0].Tag;

            if (examInfo != null)
            {
                this.LoadExamReportDetial(examInfo.EXAM_ID);
            }

            this.ShowStatusMessage(null);
            GlobalMethods.UI.SetCursor(this, Cursors.Default);
        }
Esempio n. 5
0
        /// <summary>
        /// 根据病人ID和就诊号,获取该次住院的检查信息列表
        /// </summary>
        /// <param name="szPatientID">病人编号</param>
        /// <param name="nVisitID">就诊号</param>
        /// <param name="lstExamInfo">检查信息列表</param>
        /// <returns>SystemData.ReturnValue</returns>
        public short GetInpExamList(string szPatientID, string szVisitID, ref List <ExamMaster> lstExamInfo)
        {
            if (GlobalMethods.Misc.IsEmptyString(szPatientID) || GlobalMethods.Misc.IsEmptyString(szVisitID))
            {
                LogManager.Instance.WriteLog("EMRDBAccess.GetInpExamList", "查询参数为空!");
                return(SystemData.ReturnValue.PARAM_ERROR);
            }

            if (base.MedQCAccess == null)
            {
                return(SystemData.ReturnValue.PARAM_ERROR);
            }

            if (lstExamInfo == null)
            {
                lstExamInfo = new List <ExamMaster>();
            }
            else
            {
                lstExamInfo.Clear();
            }

            string szField = string.Format("{0},{1},{2},{3},{4},{5},{6}"
                                           , SystemData.ExamMasterView.EXAM_ID, SystemData.ExamMasterView.SUBJECT
                                           , SystemData.ExamMasterView.REQUEST_TIME, SystemData.ExamMasterView.REQUEST_DOCTOR
                                           , SystemData.ExamMasterView.RESULT_STATUS, SystemData.ExamMasterView.REPORT_TIME
                                           , SystemData.ExamMasterView.REPORT_DOCTOR);
            string szTable     = SystemData.DataView.EXAM_MASTER;
            string szCondition = string.Format("{0}='{1}' AND {2}='{3}'"
                                               , SystemData.ExamMasterView.PATIENT_ID, szPatientID, SystemData.ExamMasterView.VISIT_ID, szVisitID);
            string szExamField = SystemData.ExamMasterView.REQUEST_TIME;
            string szSQL       = string.Format(SystemData.SQL.SELECT_WHERE_ORDER_ASC, szField, szTable, szCondition, szExamField);

            IDataReader dataReader = null;

            try
            {
                dataReader = base.MedQCAccess.ExecuteReader(szSQL, CommandType.Text);
                if (dataReader == null || dataReader.IsClosed || !dataReader.Read())
                {
                    return(SystemData.ReturnValue.RES_NO_FOUND);
                }
                do
                {
                    ExamMaster examInfo = new ExamMaster();
                    for (int i = 0; i < dataReader.FieldCount; i++)
                    {
                        if (dataReader.IsDBNull(i))
                        {
                            continue;
                        }
                        switch (dataReader.GetName(i))
                        {
                        case SystemData.ExamMasterView.EXAM_ID:
                            examInfo.EXAM_ID = dataReader.GetString(i);
                            break;

                        case SystemData.ExamMasterView.PATIENT_ID:
                            examInfo.PATIENT_ID = dataReader.GetString(i);
                            break;

                        case SystemData.ExamMasterView.REPORT_DOCTOR:
                            examInfo.REPORT_DOCTOR = dataReader.GetString(i);
                            break;

                        case SystemData.ExamMasterView.REPORT_TIME:
                            examInfo.REPORT_TIME = dataReader.GetDateTime(i);
                            break;

                        case SystemData.ExamMasterView.REQUEST_DOCTOR:
                            examInfo.REQUEST_DOCTOR = dataReader.GetString(i);
                            break;

                        case SystemData.ExamMasterView.REQUEST_TIME:
                            examInfo.REQUEST_TIME = dataReader.GetDateTime(i);
                            break;

                        case SystemData.ExamMasterView.RESULT_STATUS:
                            examInfo.RESULT_STATUS = dataReader.GetString(i);
                            break;

                        case SystemData.ExamMasterView.SUBJECT:
                            examInfo.SUBJECT = dataReader.GetString(i);
                            break;

                        case SystemData.ExamMasterView.VISIT_ID:
                            examInfo.VISIT_ID = dataReader.GetString(i);
                            break;

                        default:  break;
                        }
                    }
                    lstExamInfo.Add(examInfo);
                } while (dataReader.Read());
                return(SystemData.ReturnValue.OK);
            }
            catch (Exception ex)
            {
                LogManager.Instance.WriteLog("EMRDBAccess.GetInpExamList", new string[] { "szSQL" }, new object[] { szSQL }, "查询检查列表时出现异常!", ex);
                return(SystemData.ReturnValue.EXCEPTION);
            }
            finally { base.MedQCAccess.CloseConnnection(false); }
        }
Esempio n. 6
0
        /// <summary>
        /// 加载检查列表
        /// </summary>
        private void LoadExamList()
        {
            this.ExamList.SuspendLayout();
            this.ExamList.Rows.Clear();
            this.ExamList.ResumeLayout();

            if (SystemParam.Instance.PatVisitInfo == null)
            {
                return;
            }

            string            szPatientID = SystemParam.Instance.PatVisitInfo.PATIENT_ID;
            string            szVisitID   = SystemParam.Instance.PatVisitInfo.VISIT_ID;
            List <ExamMaster> lstExamInfo = null;

            if (GlobalMethods.Misc.IsEmptyString(szPatientID) || GlobalMethods.Misc.IsEmptyString(szVisitID))
            {
                return;
            }

            short shRet = ExamMasterAccess.Instance.GetInpExamList(szPatientID, szVisitID, ref lstExamInfo);

            if (shRet != SystemData.ReturnValue.OK &&
                shRet != SystemData.ReturnValue.RES_NO_FOUND &&
                shRet != SystemData.ReturnValue.CANCEL)
            {
                MessageBoxEx.Show("检查记录下载失败!");
                return;
            }

            if (lstExamInfo == null || lstExamInfo.Count <= 0)
            {
                return;
            }

            this.ExamList.SuspendLayout();
            for (int index = lstExamInfo.Count - 1; index >= 0; index--)
            {
                ExamMaster examInfo = lstExamInfo[index];
                if (examInfo == null)
                {
                    continue;
                }

                int             nRowIndex = this.ExamList.Rows.Add();
                DataGridViewRow row       = this.ExamList.Rows[nRowIndex];
                row.Tag = examInfo;
                if (examInfo.RESULT_STATUS == "确认报告" &&
                    SystemParam.Instance.LocalConfigOption.IsOpenPrintPacs)
                {
                    ExamResult examResultInfo = null;
                    shRet = ExamResultAccess.Instance.GetExamResultInfo(examInfo.EXAM_ID, ref examResultInfo);
                    if (!string.IsNullOrEmpty(examResultInfo.FILE_PATH))
                    {
                        row.Cells[this.colFilePath.Index].Value = Properties.Resources.pdf;
                        row.Cells[this.colFilePath.Index].Tag   = examResultInfo;
                    }
                }
                row.Cells[this.colExamClass.Index].Value = examInfo.SUBJECT;
                if (examInfo.REQUEST_TIME != examInfo.DefaultTime)
                {
                    row.Cells[this.colRequestTime.Index].Value = examInfo.REQUEST_TIME.ToString("yyyy-MM-dd");
                }
                row.Cells[this.colRequestDoctor.Index].Value = examInfo.REQUEST_DOCTOR;
                if (examInfo.REPORT_TIME != examInfo.DefaultTime)
                {
                    row.Cells[this.colReportTime.Index].Value = examInfo.REPORT_TIME.ToString("yyyy-MM-dd");
                }
                row.Cells[this.colReportDoctor.Index].Value = examInfo.REPORT_DOCTOR;
                row.Cells[this.colResultStatus.Index].Value = examInfo.RESULT_STATUS;
            }
            this.ExamList.ResumeLayout();
        }