Esempio n. 1
0
        public short UpdateClinicWorklist(ClinicWorklist model, string operFlag)
        {
            string szDoctorID = string.Empty;

            if (base.MedQCAccess == null)
            {
                return(SystemData.ReturnValue.PARAM_ERROR);
            }
            DbParameter[] pmi = new DbParameter[15];
            pmi[0]  = new DbParameter("operFlag", operFlag);
            pmi[1]  = new DbParameter("rcount", 0, ParameterDirection.Output);
            pmi[2]  = new DbParameter("WORKLIST_ID_1", model.WORKLIST_ID);
            pmi[3]  = new DbParameter("WORKLIST_TYPE_1", model.WORKLIST_TYPE);
            pmi[4]  = new DbParameter("CREATE_TIME_1", model.CREATE_TIME);
            pmi[5]  = new DbParameter("CREATE_DEPT_1", model.CREATE_DEPT);
            pmi[6]  = new DbParameter("CREATE_STAFF_1", model.CREATE_STAFF);
            pmi[7]  = new DbParameter("WORKLIST_CONTENT_1", model.WORKLIST_CONTENT);
            pmi[8]  = new DbParameter("TARGET_DEPT_1", model.TARGET_DEPT);
            pmi[9]  = new DbParameter("TARGET_STAFF_1", model.TARGET_STAFF);
            pmi[10] = new DbParameter("EXEC_DEPT_1", model.EXEC_DEPT);
            pmi[11] = new DbParameter("EXEC_STAFF_1", model.EXEC_STAFF);
            pmi[12] = new DbParameter("EXEC_TIME_1", model.EXEC_TIME);
            pmi[13] = new DbParameter("EXEC_INDICATOR_1", model.EXEC_INDICATOR);
            pmi[14] = new DbParameter("PARAMETER_1", model.PARAMETER);
            int nResult = 0;
            int rcount  = 0;

            try
            {
                nResult = base.MedQCAccess.ExecuteNonQuery("UPDATE_CLINIC_WORKLIST", CommandType.StoredProcedure, ref pmi);
                rcount  = int.Parse(pmi[1].Value.ToString());
            }
            catch (Exception ex)
            {
                LogManager.Instance.WriteLog("", ex);
                return(SystemData.ReturnValue.EXCEPTION);
            }
            finally { base.MedQCAccess.CloseConnnection(false); }
            return(rcount <= 0 ? SystemData.ReturnValue.OTHER_ERROR : SystemData.ReturnValue.OK);
        }
        private void btnWarningArchive_Click(object sender, EventArgs e)
        {
            if (this.dataGridView1.SelectedRows.Count <= 0)
            {
                return;
            }
            PatVisitInfo patVisitInfo = this.dataGridView1.SelectedRows[0].Tag as PatVisitInfo;

            if (patVisitInfo == null)
            {
                MessageBoxEx.ShowMessage("催送提醒发送失败");
                return;
            }
            short          shRet          = SystemData.ReturnValue.OK;
            ClinicWorklist clinicWorklist = new ClinicWorklist();

            clinicWorklist.CREATE_DEPT      = SystemParam.Instance.UserInfo.DEPT_CODE;
            clinicWorklist.CREATE_STAFF     = SystemParam.Instance.UserInfo.USER_ID;
            clinicWorklist.CREATE_TIME      = SysTimeHelper.Instance.Now;
            clinicWorklist.TARGET_DEPT      = patVisitInfo.DEPT_CODE;
            clinicWorklist.WORKLIST_TYPE    = SystemData.WorklistType.病案;
            clinicWorklist.PARAMETER        = string.Format("visitNo={0}", patVisitInfo.VISIT_NO);
            clinicWorklist.TARGET_STAFF     = patVisitInfo.INCHARGE_DOCTOR_ID;
            clinicWorklist.WORKLIST_CONTENT = string.Format("{0}提醒{1}尽快将患者{2}的病历送到病案室"
                                                            , SystemParam.Instance.UserInfo.USER_NAME
                                                            , patVisitInfo.DEPT_NAME
                                                            , patVisitInfo.PATIENT_NAME
                                                            );
            shRet = ClinicWorklistAccess.Instance.UpdateClinicWorklist(clinicWorklist, SystemData.OperFlag.INSERT);
            if (shRet != SystemData.ReturnValue.OK)
            {
                MessageBoxEx.ShowMessage("催送提醒发送失败");
                return;
            }
            MessageBoxEx.ShowMessage("催送提醒发送成功");
        }