Example #1
0
        private void dataTableView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (e.RowIndex < 0)
            {
                return;
            }
            DataGridViewRow row        = this.dataTableView1.Rows[e.RowIndex];
            RecMrBatch      recMrBatch = this.dataTableView1.Rows[e.RowIndex].Tag as RecMrBatch;

            if (e.ColumnIndex == this.colReceive.Index)
            {
                if (recMrBatch.RECEIVE_TIME != recMrBatch.DefaultTime)
                {
                    if (MessageBoxEx.ShowConfirm("纸质病历批次已接收,是否重新接收") != DialogResult.OK)
                    {
                        return;
                    }
                }
                else
                {
                    if (MessageBoxEx.ShowConfirm("确认接收吗?") != DialogResult.OK)
                    {
                        return;
                    }
                }
                recMrBatch.RECEIVE_DEPT_CODE   = SystemParam.Instance.UserInfo.DEPT_CODE;
                recMrBatch.RECEIVE_DEPT_NAME   = SystemParam.Instance.UserInfo.DEPT_NAME;
                recMrBatch.RECEIVE_DOCTOR_ID   = SystemParam.Instance.UserInfo.USER_ID;
                recMrBatch.RECEIVE_DOCTOR_NAME = SystemParam.Instance.UserInfo.USER_NAME;
                recMrBatch.RECEIVE_TIME        = SysTimeHelper.Instance.Now;
                short shRet = RecMrBatchAccess.Instance.Update(recMrBatch);
                if (shRet != SystemData.ReturnValue.OK)
                {
                    MessageBoxEx.ShowMessage("操作失败");
                    return;
                }
                row.Cells[this.col_RECEIVE_DOCTOR_NAME.Index].Value = recMrBatch.RECEIVE_DOCTOR_NAME;
                row.Cells[this.col_RECEIVE_TIME.Index].Value        = recMrBatch.RECEIVE_TIME.ToString("yyyy-MM-dd HH:mm");
                MessageBoxEx.ShowMessage("操作成功");
            }
        }
Example #2
0
        private void btnSend_Click(object sender, EventArgs e)
        {
            if (this.txt_BATCH_NO.Text.Trim() != string.Empty)
            {
                MessageBoxEx.ShowMessage("批次号已经生成,请刷新页面后重试");
                return;
            }
            if (this.txt_WORKER_ID.Text.Trim() == string.Empty || this.txt_WORKER_NAME.Text.Trim() == string.Empty)
            {
                MessageBoxEx.ShowMessage("请输入工人信息");
                return;
            }
            RecMrBatch recMrBatch = new RecMrBatch();

            recMrBatch.BATCH_NO         = recMrBatch.MakeBatchNo(SystemParam.Instance.UserInfo.DEPT_CODE);
            recMrBatch.INP_NOS          = string.Join("|", m_lstPatVisit.Select(m => m.INP_NO).ToArray());
            recMrBatch.MR_COUNT         = this.m_lstPatVisit.Count;
            recMrBatch.PAPER_COUNT      = this.m_paperCount++;
            recMrBatch.SEND_DEPT_CODE   = SystemParam.Instance.UserInfo.DEPT_CODE;
            recMrBatch.SEND_DEPT_NAME   = SystemParam.Instance.UserInfo.DEPT_NAME;
            recMrBatch.SEND_DOCTOR_ID   = SystemParam.Instance.UserInfo.USER_ID;
            recMrBatch.SEND_DOCTOR_NAME = SystemParam.Instance.UserInfo.USER_NAME;
            recMrBatch.SEND_TIME        = SysTimeHelper.Instance.Now;
            recMrBatch.VISIT_NOS        = string.Join("|", m_lstPatVisit.Select(m => m.VISIT_NO).ToArray());
            recMrBatch.WORKER_ID        = this.txt_WORKER_ID.Text;
            recMrBatch.WORKER_NAME      = this.txt_WORKER_NAME.Text;
            short shRet = RecMrBatchAccess.Instance.Insert(recMrBatch);

            if (shRet != SystemData.ReturnValue.OK)
            {
                MessageBoxEx.ShowError("无法正常发送");
                return;
            }
            MessageBoxEx.ShowMessage("发送成功");
            this.txt_BATCH_NO.Text = recMrBatch.BATCH_NO;
        }
Example #3
0
        /// <summary>
        /// 更新一条整改通知单
        /// </summary>
        /// <param name="timeQCRule">自动核查规则配置信息</param>
        /// <returns>SystemData.ReturnValue</returns>
        public short Update(RecMrBatch recMrBatch)
        {
            if (recMrBatch == null)
            {
                LogManager.Instance.WriteLog("", new string[] { "" }
                                             , new object[] { recMrBatch }, "参数不能为空");
                return(SystemData.ReturnValue.PARAM_ERROR);
            }
            if (base.MedQCAccess == null)
            {
                return(SystemData.ReturnValue.PARAM_ERROR);
            }
            StringBuilder sbField = new StringBuilder();

            sbField.AppendFormat("{0}='{1}',"
                                 , SystemData.RecMrBatchTable.INP_NOS, recMrBatch.INP_NOS);
            sbField.AppendFormat("{0}={1},"
                                 , SystemData.RecMrBatchTable.MR_COUNT, recMrBatch.MR_COUNT);
            sbField.AppendFormat("{0}={1},"
                                 , SystemData.RecMrBatchTable.PAPER_COUNT, recMrBatch.PAPER_COUNT);
            sbField.AppendFormat("{0}='{1}',"
                                 , SystemData.RecMrBatchTable.RECEIVE_DEPT_CODE, recMrBatch.RECEIVE_DEPT_CODE);
            sbField.AppendFormat("{0}='{1}',"
                                 , SystemData.RecMrBatchTable.RECEIVE_DEPT_NAME, recMrBatch.RECEIVE_DEPT_NAME);
            sbField.AppendFormat("{0}='{1}',"
                                 , SystemData.RecMrBatchTable.RECEIVE_DOCTOR_ID, recMrBatch.RECEIVE_DOCTOR_ID);
            sbField.AppendFormat("{0}='{1}',"
                                 , SystemData.RecMrBatchTable.RECEIVE_DOCTOR_NAME, recMrBatch.RECEIVE_DOCTOR_NAME);
            sbField.AppendFormat("{0}={1},"
                                 , SystemData.RecMrBatchTable.RECEIVE_TIME, base.MedQCAccess.GetSqlTimeFormat(recMrBatch.RECEIVE_TIME));
            sbField.AppendFormat("{0}='{1}',"
                                 , SystemData.RecMrBatchTable.REMARK, recMrBatch.REMARK);
            sbField.AppendFormat("{0}={1},"
                                 , SystemData.RecMrBatchTable.SEND_DEPT_CODE, recMrBatch.SEND_DEPT_CODE);
            sbField.AppendFormat("{0}='{1}',"
                                 , SystemData.RecMrBatchTable.SEND_DEPT_NAME, recMrBatch.SEND_DEPT_NAME);
            sbField.AppendFormat("{0}='{1}',"
                                 , SystemData.RecMrBatchTable.SEND_DOCTOR_ID, recMrBatch.SEND_DOCTOR_ID);
            sbField.AppendFormat("{0}='{1}',"
                                 , SystemData.RecMrBatchTable.SEND_DOCTOR_NAME, recMrBatch.SEND_DOCTOR_NAME);
            sbField.AppendFormat("{0}={1},"
                                 , SystemData.RecMrBatchTable.SEND_TIME, base.MedQCAccess.GetSqlTimeFormat(recMrBatch.SEND_TIME));
            sbField.AppendFormat("{0}='{1}',"
                                 , SystemData.RecMrBatchTable.VISIT_NOS, recMrBatch.VISIT_NOS);
            sbField.AppendFormat("{0}='{1}',"
                                 , SystemData.RecMrBatchTable.WORKER_ID, recMrBatch.WORKER_ID);
            sbField.AppendFormat("{0}='{1}'"
                                 , SystemData.RecMrBatchTable.WORKER_NAME, recMrBatch.WORKER_NAME);
            string szCondition = string.Format("{0}='{1}'", SystemData.RecMrBatchTable.BATCH_NO, recMrBatch.BATCH_NO);
            string szSQL       = string.Format(SystemData.SQL.UPDATE, SystemData.DataTable.REC_MR_BATCH, sbField.ToString(), szCondition);
            int    nCount      = 0;

            try
            {
                nCount = base.MedQCAccess.ExecuteNonQuery(szSQL, CommandType.Text);
            }
            catch (Exception ex)
            {
                LogManager.Instance.WriteLog("", new string[] { "szSQL" }, new object[] { szSQL }, ex);
                return(SystemData.ReturnValue.EXCEPTION);
            }
            if (nCount <= 0)
            {
                LogManager.Instance.WriteLog("", new string[] { "szSQL" }, new object[] { szSQL }, "SQL语句执行后返回0!");
                return(SystemData.ReturnValue.EXCEPTION);
            }
            return(SystemData.ReturnValue.OK);
        }
Example #4
0
        /// <summary>
        /// 获取所有自动核查结果信息列表
        /// </summary>
        /// <param name="lstQcCheckResults"></param>
        /// <returns>SystemData.ReturnValue</returns>
        public short GetRecMrBatch(string szBatchNo, ref RecMrBatch RecMrBatch)
        {
            if (base.MedQCAccess == null)
            {
                return(SystemData.ReturnValue.PARAM_ERROR);
            }

            StringBuilder sbField = new StringBuilder();

            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.BATCH_NO);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.INP_NOS);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.MR_COUNT);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.PAPER_COUNT);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.RECEIVE_DEPT_CODE);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.RECEIVE_DEPT_NAME);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.RECEIVE_DOCTOR_ID);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.RECEIVE_DOCTOR_NAME);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.RECEIVE_TIME);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.REMARK);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.SEND_DEPT_CODE);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.SEND_DEPT_NAME);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.SEND_DOCTOR_ID);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.SEND_DOCTOR_NAME);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.SEND_TIME);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.VISIT_NOS);
            sbField.AppendFormat("{0},", SystemData.RecMrBatchTable.WORKER_ID);
            sbField.AppendFormat("{0}", SystemData.RecMrBatchTable.WORKER_NAME);
            string szCondition = string.Format("1=1");

            if (!string.IsNullOrEmpty(szBatchNo))
            {
                szCondition = string.Format("{0} AND {1} = '{2}'"
                                            , szCondition
                                            , SystemData.RecMrBatchTable.BATCH_NO
                                            , szBatchNo);
            }
            string szSQL = string.Format(SystemData.SQL.SELECT_WHERE
                                         , sbField.ToString(), SystemData.DataTable.REC_MR_BATCH, szCondition);

            IDataReader dataReader = null;

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

                    case SystemData.RecMrBatchTable.INP_NOS:
                        RecMrBatch.INP_NOS = dataReader.GetString(i);
                        break;

                    case SystemData.RecMrBatchTable.MR_COUNT:
                        RecMrBatch.MR_COUNT = int.Parse(dataReader.GetValue(i).ToString());
                        break;

                    case SystemData.RecMrBatchTable.PAPER_COUNT:
                        RecMrBatch.PAPER_COUNT = int.Parse(dataReader.GetValue(i).ToString());
                        break;

                    case SystemData.RecMrBatchTable.RECEIVE_DEPT_CODE:
                        RecMrBatch.RECEIVE_DEPT_CODE = dataReader.GetValue(i).ToString();
                        break;

                    case SystemData.RecMrBatchTable.RECEIVE_DEPT_NAME:
                        RecMrBatch.RECEIVE_DEPT_NAME = dataReader.GetString(i);
                        break;

                    case SystemData.RecMrBatchTable.RECEIVE_DOCTOR_ID:
                        RecMrBatch.RECEIVE_DOCTOR_ID = dataReader.GetString(i);
                        break;

                    case SystemData.RecMrBatchTable.RECEIVE_DOCTOR_NAME:
                        RecMrBatch.RECEIVE_DOCTOR_NAME = dataReader.GetString(i);
                        break;

                    case SystemData.RecMrBatchTable.RECEIVE_TIME:
                        RecMrBatch.RECEIVE_TIME = dataReader.GetDateTime(i);
                        break;

                    case SystemData.RecMrBatchTable.REMARK:
                        RecMrBatch.REMARK = dataReader.GetString(i);
                        break;

                    case SystemData.RecMrBatchTable.SEND_DEPT_CODE:
                        RecMrBatch.SEND_DEPT_CODE = dataReader.GetString(i);
                        break;

                    case SystemData.RecMrBatchTable.SEND_DEPT_NAME:
                        RecMrBatch.SEND_DEPT_NAME = dataReader.GetString(i);
                        break;

                    case SystemData.RecMrBatchTable.SEND_DOCTOR_ID:
                        RecMrBatch.SEND_DOCTOR_ID = dataReader.GetString(i);
                        break;

                    case SystemData.RecMrBatchTable.SEND_DOCTOR_NAME:
                        RecMrBatch.SEND_DOCTOR_NAME = dataReader.GetString(i);
                        break;

                    case SystemData.RecMrBatchTable.SEND_TIME:
                        RecMrBatch.SEND_TIME = dataReader.GetDateTime(i);
                        break;

                    case SystemData.RecMrBatchTable.VISIT_NOS:
                        RecMrBatch.VISIT_NOS = dataReader.GetString(i);
                        break;

                    case SystemData.RecMrBatchTable.WORKER_ID:
                        RecMrBatch.WORKER_ID = dataReader.GetString(i);
                        break;

                    case SystemData.RecMrBatchTable.WORKER_NAME:
                        RecMrBatch.WORKER_NAME = dataReader.GetString(i);
                        break;
                    }
                }

                return(SystemData.ReturnValue.OK);
            }
            catch (Exception ex)
            {
                LogManager.Instance.WriteLog("", new string[] { "szSQL" }, new object[] { szSQL }, ex);
                return(SystemData.ReturnValue.EXCEPTION);
            }
            finally { base.MedQCAccess.CloseConnnection(false); }
        }