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("催送提醒发送成功"); }