private void dataTableView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
QcModifyNotice item = this.dataTableView1.Rows[e.RowIndex].Tag as QcModifyNotice;
if (item == null)
{
return;
}
List <MedicalQcMsg> lstMedicalQcMsg = null;
short shRet = MedicalQcMsgAccess.Instance.GetMedicalQcMsgs(item.MODIFY_NOTICE_ID, ref lstMedicalQcMsg);
if (lstMedicalQcMsg == null || lstMedicalQcMsg.Count <= 0)
{
return;
}
int rowIndex = 0;
if (string.IsNullOrEmpty(lstMedicalQcMsg[0].TOPIC_ID))
{
return;
}
}
/// <summary>
/// 新增整改通知书
/// </summary>
private void InsertModifyNotice(QcModifyNotice qcModifyNotice)
{
if (MessageBoxEx.ShowConfirm("评分结果将以消息形式发送到医生工作台，确认发送通知书吗？") != DialogResult.OK)
{
return;
}
qcModifyNotice.MODIFY_NOTICE_ID = qcModifyNotice.MakeID();
qcModifyNotice.MODIFY_PERIOD = this.cbo_MODIFY_PERIOD.Text;
qcModifyNotice.MODIFY_REMARK = this.rtb_MODIFY_REMARK.Text;
qcModifyNotice.MODIFY_SCORE = float.Parse(this.lbl_MODIFY_SCORE.Text);
qcModifyNotice.NOTICE_TIME = DateTime.Parse(this.lbl_NOTICE_TIME.Text);
qcModifyNotice.PATIENT_ID = SystemParam.Instance.PatVisitInfo.PATIENT_ID;
qcModifyNotice.PATIENT_NAME = SystemParam.Instance.PatVisitInfo.PATIENT_NAME;
qcModifyNotice.QC_DEPT_CODE = SystemParam.Instance.UserInfo.DEPT_CODE;
qcModifyNotice.QC_DEPT_NAME = SystemParam.Instance.UserInfo.DEPT_NAME;
qcModifyNotice.QC_LEVEL = SystemData.QcLevel.GetCodeByMrStatus(SystemParam.Instance.PatVisitInfo.MR_STATUS);
qcModifyNotice.QC_MAN = SystemParam.Instance.UserInfo.USER_NAME;
qcModifyNotice.QC_MAN_ID = SystemParam.Instance.UserInfo.USER_ID;
qcModifyNotice.RECEIVER = SystemParam.Instance.PatVisitInfo.INCHARGE_DOCTOR;
qcModifyNotice.RECEIVER_ID = SystemParam.Instance.PatVisitInfo.INCHARGE_DOCTOR_ID;
qcModifyNotice.RECEIVER_DEPT_CODE = SystemParam.Instance.PatVisitInfo.DEPT_CODE;
qcModifyNotice.RECEIVER_DEPT_NAME = SystemParam.Instance.PatVisitInfo.DEPT_NAME;
qcModifyNotice.VISIT_ID = SystemParam.Instance.PatVisitInfo.VISIT_ID;
qcModifyNotice.VISIT_NO = SystemParam.Instance.PatVisitInfo.VISIT_NO;
qcModifyNotice.NOTICE_STATUS = SystemData.NotifyStatus.Sended;
short shRet = QcModifyNoticeAccess.Instance.Insert(qcModifyNotice);
//新增质检信息 更新人工质控结果 新增
foreach (DataGridViewRow item in this.dataTableView1.Rows)
{
QcCheckResult qcCheckResult = item.Tag as QcCheckResult;
qcCheckResult.MODIFY_NOTICE_ID = qcModifyNotice.MODIFY_NOTICE_ID;
MedicalQcMsg medicalQcMsg = item.Cells[this.col_MSG_ID.Index].Tag as MedicalQcMsg;
UserInfo userInfo = item.Cells[this.col_INCHARGE_DOCTOR.Index].Tag as UserInfo;
if (userInfo != null)
{
qcCheckResult.DEPT_CODE = userInfo.DEPT_CODE;
qcCheckResult.DEPT_IN_CHARGE = userInfo.DEPT_NAME;
qcCheckResult.INCHARGE_DOCTOR = userInfo.USER_NAME;
qcCheckResult.INCHARGE_DOCTOR_ID = userInfo.USER_ID;
}
if (medicalQcMsg == null)
{
medicalQcMsg = this.ToQcMsg(qcCheckResult);
shRet = MedicalQcMsgAccess.Instance.Insert(medicalQcMsg);
}
qcCheckResult.MSG_ID = medicalQcMsg.MSG_ID;
shRet = QcCheckResultAccess.Instance.Update(qcCheckResult);
}
if (shRet == SystemData.ReturnValue.OK)
{
MessageBoxEx.ShowMessage("发送成功");
this.lbl_NOTICE_STATUS.Text = SystemData.NotifyStatus.GetCnName(qcModifyNotice.NOTICE_STATUS);
this.lbl_NOTICE_STATUS.ForeColor = Color.Blue;
this.herenButton1.Text = "修改整改通知单";
}
}
private void dataTableView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
QcModifyNotice qcModifyNotice = this.dataTableView1.Rows[e.RowIndex].Tag as QcModifyNotice;
if (qcModifyNotice == null)
{
return;
}
PatVisitInfo patVisitInfo = new PatVisitInfo();
patVisitInfo.PATIENT_ID = qcModifyNotice.PATIENT_ID;
patVisitInfo.VISIT_ID = qcModifyNotice.VISIT_ID;
this.MainForm.SwitchPatient(patVisitInfo);
}
private void DeleteQcModifyNotice(QcModifyNotice qcModifyNotice)
{
if (MessageBoxEx.ShowConfirm("您确定删除该条整改通知书吗？") == DialogResult.OK)
{
short shRet = QcModifyNoticeAccess.Instance.Delete(qcModifyNotice.MODIFY_NOTICE_ID);
if (shRet == SystemData.ReturnValue.OK)
{
List <MedicalQcMsg> lstMedicalQcMsg = null;
shRet = MedicalQcMsgAccess.Instance.GetMedicalQcMsgs(qcModifyNotice.MODIFY_NOTICE_ID, ref lstMedicalQcMsg);
foreach (var item in lstMedicalQcMsg)
{
MedicalQcMsgAccess.Instance.Delete(item.MSG_ID);
}
MessageBoxEx.ShowMessage("删除操作成功");
this.dataTableView1.Rows.RemoveAt(dataTableView1.SelectedRows[0].Index);
this.dataTableView2.Rows.Clear();
}
}
}
private void herenButton1_Click(object sender, EventArgs e)
{
try
{
if (m_QcModifyNotice == null)
{
m_QcModifyNotice = new QcModifyNotice();
}
if (m_QcModifyNotice.NOTICE_STATUS == SystemData.NotifyStatus.Draft)
{
this.InsertModifyNotice(m_QcModifyNotice);
}
else
{
this.UpdateModifyNotice(m_QcModifyNotice);
}
}
catch (Exception ex)
{
MessageBoxEx.ShowMessage("操作失败", (ex.ToString()));
}
}
private void dataTableView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
QcModifyNotice item = this.dataTableView1.Rows[e.RowIndex].Tag as QcModifyNotice;
if (item == null)
{
return;
}
if (e.ColumnIndex == col_1_btnDelete.Index)
{
this.DeleteQcModifyNotice(item);
return;
}
this.dataTableView2.Rows.Clear();
List <MedicalQcMsg> lstMedicalQcMsg = null;
short shRet = MedicalQcMsgAccess.Instance.GetMedicalQcMsgs(item.MODIFY_NOTICE_ID, ref lstMedicalQcMsg);
if (lstMedicalQcMsg == null || lstMedicalQcMsg.Count <= 0)
{
return;
}
int rowIndex = 0;
foreach (var medicalQcMsg in lstMedicalQcMsg)
{
rowIndex = this.dataTableView2.Rows.Add();
DataTableViewRow row = this.dataTableView2.Rows[rowIndex];
row.Cells[this.col_2_DoctorComment.Index].Value = medicalQcMsg.DOCTOR_COMMENT;
row.Cells[this.col_2_doctorInCharge.Index].Value = medicalQcMsg.DOCTOR_IN_CHARGE;
row.Cells[this.col_2_Point.Index].Value = medicalQcMsg.POINT;
row.Cells[this.col_2_QA_EVENT_TYPE.Index].Value = medicalQcMsg.QA_EVENT_TYPE;
row.Cells[this.col_2_QcMsgDict.Index].Value = medicalQcMsg.MESSAGE;
row.Cells[this.col_2_ERROR_COUNT.Index].Value = medicalQcMsg.ERROR_COUNT;
row.Cells[this.col_2_MSG_STATUS.Index].Value = SystemData.MsgStatus.GetCnMsgState(medicalQcMsg.MSG_STATUS);
if (medicalQcMsg.MSG_STATUS == SystemData.MsgStatus.Modified)
{
row.Cells[this.col_2_MSG_STATUS.Index].Style.ForeColor = Color.Blue;
}
else if (medicalQcMsg.MSG_STATUS == SystemData.MsgStatus.Pass)
{
row.Cells[this.col_2_MSG_STATUS.Index].Style.ForeColor = Color.Green;
}
else if (medicalQcMsg.MSG_STATUS == SystemData.MsgStatus.UnCheck)
{
row.Cells[this.col_2_MSG_STATUS.Index].Style.ForeColor = Color.Red;
}
else if (medicalQcMsg.MSG_STATUS == SystemData.MsgStatus.Checked)
{
row.Cells[this.col_2_MSG_STATUS.Index].Style.ForeColor = Color.Yellow;
}
if (medicalQcMsg.ASK_DATE_TIME != SystemParam.Instance.DefaultTime)
{
row.Cells[this.col_2_AskDateTime.Index].Value = medicalQcMsg.ASK_DATE_TIME.ToString("yyyy-MM-dd HH:mm");
}
row.Selected = false;
row.Tag = medicalQcMsg;
}
this.dataTableView2.Rows[0].Selected = true;
if (string.IsNullOrEmpty(lstMedicalQcMsg[0].TOPIC_ID))
{
return;
}
}
/// <summary>
/// 更新一条整改通知单
/// </summary>
/// <param name="timeQCRule">自动核查规则配置信息</param>
/// <returns>SystemData.ReturnValue</returns>
public short Update(QcModifyNotice qcModifyNotice)
{
if (qcModifyNotice == null)
{
LogManager.Instance.WriteLog("", new string[] { "" }
, new object[] { qcModifyNotice }, "参数不能为空");
return(SystemData.ReturnValue.PARAM_ERROR);
}
if (base.MedQCAccess == null)
{
return(SystemData.ReturnValue.PARAM_ERROR);
}
StringBuilder sbField = new StringBuilder();
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.MODIFY_PERIOD, qcModifyNotice.MODIFY_PERIOD);
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.MODIFY_REMARK, qcModifyNotice.MODIFY_REMARK);
sbField.AppendFormat("{0}={1},"
, SystemData.QcModifyNoticeTable.MODIFY_SCORE, qcModifyNotice.MODIFY_SCORE);
sbField.AppendFormat("{0}={1},"
, SystemData.QcModifyNoticeTable.NOTICE_STATUS, qcModifyNotice.NOTICE_STATUS);
sbField.AppendFormat("{0}={1},"
, SystemData.QcModifyNoticeTable.NOTICE_TIME, base.MedQCAccess.GetSqlTimeFormat(qcModifyNotice.NOTICE_TIME));
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.PATIENT_ID, qcModifyNotice.PATIENT_ID);
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.PATIENT_NAME, qcModifyNotice.PATIENT_NAME);
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.QC_DEPT_CODE, qcModifyNotice.QC_DEPT_CODE);
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.QC_DEPT_NAME, qcModifyNotice.QC_DEPT_NAME);
sbField.AppendFormat("{0}={1},"
, SystemData.QcModifyNoticeTable.QC_LEVEL, qcModifyNotice.QC_LEVEL);
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.QC_MAN, qcModifyNotice.QC_MAN);
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.QC_MAN_ID, qcModifyNotice.QC_MAN_ID);
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.RECEIVER, qcModifyNotice.RECEIVER);
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.RECEIVER_DEPT_CODE, qcModifyNotice.RECEIVER_DEPT_CODE);
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.RECEIVER_DEPT_NAME, qcModifyNotice.RECEIVER_DEPT_NAME);
sbField.AppendFormat("{0}='{1}',"
, SystemData.QcModifyNoticeTable.VISIT_ID, qcModifyNotice.VISIT_ID);
sbField.AppendFormat("{0}='{1}'"
, SystemData.QcModifyNoticeTable.VISIT_NO, qcModifyNotice.VISIT_NO);
string szCondition = string.Format("{0}='{1}'", SystemData.QcModifyNoticeTable.MODIFY_NOTICE_ID, qcModifyNotice.MODIFY_NOTICE_ID);
string szSQL = string.Format(SystemData.SQL.UPDATE, SystemData.DataTable.QC_MODIFY_NOTICE, 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);
}
/// <summary>
/// 获取所有自动核查结果信息列表
/// </summary>
/// <param name="lstQcCheckResults"></param>
/// <returns>SystemData.ReturnValue</returns>
public short GetQcModifyNotice(string szPatientID, string szVisitID, ref QcModifyNotice qcModifyNotice)
{
if (base.MedQCAccess == null)
{
return(SystemData.ReturnValue.PARAM_ERROR);
}
StringBuilder sbField = new StringBuilder();
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.MODIFY_NOTICE_ID);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.MODIFY_PERIOD);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.MODIFY_REMARK);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.MODIFY_SCORE);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.MODIFY_TIME);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.NOTICE_STATUS);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.NOTICE_TIME);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.PATIENT_ID);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.PATIENT_NAME);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.QC_DEPT_CODE);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.QC_DEPT_NAME);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.QC_LEVEL);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.QC_MAN);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.QC_MAN_ID);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.RECEIVER);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.RECEIVER_DEPT_CODE);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.RECEIVER_DEPT_NAME);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.RECEIVER_ID);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.VISIT_ID);
sbField.AppendFormat("{0}", SystemData.QcModifyNoticeTable.VISIT_NO);
string szCondition = string.Format("1=1");
if (!string.IsNullOrEmpty(szPatientID) && !string.IsNullOrEmpty(szVisitID))
{
szCondition = string.Format("{0} AND {1} = '{2}' AND {3}='{4}'"
, szCondition
, SystemData.QcCheckResultTable.PATIENT_ID
, szPatientID
, SystemData.QcCheckResultTable.VISIT_ID
, szVisitID);
}
string szSQL = string.Format(SystemData.SQL.SELECT_WHERE
, sbField.ToString(), SystemData.DataTable.QC_MODIFY_NOTICE, 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 (qcModifyNotice == null)
{
qcModifyNotice = new QcModifyNotice();
}
for (int i = 0; i < dataReader.FieldCount; i++)
{
if (dataReader.IsDBNull(i))
{
continue;
}
switch (dataReader.GetName(i))
{
case SystemData.QcModifyNoticeTable.MODIFY_NOTICE_ID:
qcModifyNotice.MODIFY_NOTICE_ID = dataReader.GetValue(i).ToString();
break;
case SystemData.QcModifyNoticeTable.MODIFY_PERIOD:
qcModifyNotice.MODIFY_PERIOD = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.MODIFY_REMARK:
qcModifyNotice.MODIFY_REMARK = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.MODIFY_SCORE:
qcModifyNotice.MODIFY_SCORE = float.Parse(dataReader.GetValue(i).ToString());
break;
case SystemData.QcModifyNoticeTable.NOTICE_STATUS:
qcModifyNotice.NOTICE_STATUS = int.Parse(dataReader.GetValue(i).ToString());
break;
case SystemData.QcModifyNoticeTable.NOTICE_TIME:
qcModifyNotice.NOTICE_TIME = dataReader.GetDateTime(i);
break;
case SystemData.QcModifyNoticeTable.PATIENT_ID:
qcModifyNotice.PATIENT_ID = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.QC_DEPT_CODE:
qcModifyNotice.QC_DEPT_CODE = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.QC_DEPT_NAME:
qcModifyNotice.QC_DEPT_NAME = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.QC_LEVEL:
qcModifyNotice.QC_LEVEL = int.Parse(dataReader.GetValue(i).ToString());
break;
case SystemData.QcModifyNoticeTable.QC_MAN:
qcModifyNotice.QC_MAN = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.QC_MAN_ID:
qcModifyNotice.QC_MAN_ID = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.RECEIVER:
qcModifyNotice.RECEIVER = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.RECEIVER_DEPT_CODE:
qcModifyNotice.RECEIVER_DEPT_CODE = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.RECEIVER_DEPT_NAME:
qcModifyNotice.RECEIVER_DEPT_NAME = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.VISIT_ID:
qcModifyNotice.VISIT_ID = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.VISIT_NO:
qcModifyNotice.VISIT_NO = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.RECEIVER_ID:
qcModifyNotice.RECEIVER_ID = dataReader.GetString(i);
break;
default: 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); }
}
/// <summary>
/// 获取整改通知书
/// </summary>
/// <param name="lstQcCheckResults"></param>
/// <returns>SystemData.ReturnValue</returns>
public short GetQcModifyNotices(DateTime dtNoticeTimeBegin, DateTime dtNoticeTimeEnd, string szDeptCode, string szUserID, string szPatientID, string szPatientName, ref List <QcModifyNotice> lstQcModifyNotices)
{
if (base.MedQCAccess == null)
{
return(SystemData.ReturnValue.PARAM_ERROR);
}
StringBuilder sbField = new StringBuilder();
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.MODIFY_NOTICE_ID);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.MODIFY_PERIOD);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.MODIFY_REMARK);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.MODIFY_SCORE);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.MODIFY_TIME);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.NOTICE_STATUS);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.NOTICE_TIME);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.PATIENT_ID);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.PATIENT_NAME);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.QC_DEPT_CODE);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.QC_DEPT_NAME);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.QC_LEVEL);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.QC_MAN);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.QC_MAN_ID);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.RECEIVER);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.RECEIVER_DEPT_CODE);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.RECEIVER_DEPT_NAME);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.RECEIVER_ID);
sbField.AppendFormat("{0},", SystemData.QcModifyNoticeTable.VISIT_ID);
sbField.AppendFormat("{0}", SystemData.QcModifyNoticeTable.VISIT_NO);
string szCondition = string.Format("1=1");
szCondition = string.Format("{0} AND {1} >= {2} AND {1} <= {3}"
, szCondition
, SystemData.QcModifyNoticeTable.NOTICE_TIME
, base.MedQCAccess.GetSqlTimeFormat(dtNoticeTimeBegin)
, base.MedQCAccess.GetSqlTimeFormat(dtNoticeTimeEnd));
if (!string.IsNullOrEmpty(szDeptCode))
{
szCondition = string.Format("{0} AND {1}='{2}'"
, szCondition
, SystemData.QcModifyNoticeTable.RECEIVER_DEPT_CODE
, szDeptCode);
}
if (!string.IsNullOrEmpty(szUserID))
{
szCondition = string.Format("{0} AND {1}='{2}'"
, szCondition
, SystemData.QcModifyNoticeTable.QC_MAN_ID
, szUserID);
}
if (!string.IsNullOrEmpty(szPatientID))
{
szCondition = string.Format("{0} AND {1} like '%{2}%'"
, szCondition
, SystemData.QcModifyNoticeTable.PATIENT_ID
, szPatientID);
}
if (!string.IsNullOrEmpty(szPatientName))
{
szCondition = string.Format("{0} AND {1} like '%{2}%'"
, szCondition
, SystemData.QcModifyNoticeTable.PATIENT_NAME
, szPatientName);
}
string szOrderBy = string.Format("{0}", SystemData.QcModifyNoticeTable.NOTICE_TIME);
string szSQL = string.Format(SystemData.SQL.SELECT_WHERE_ORDER_ASC
, sbField.ToString(), SystemData.DataTable.QC_MODIFY_NOTICE, szCondition, szOrderBy);
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 (lstQcModifyNotices == null)
{
lstQcModifyNotices = new List <QcModifyNotice>();
}
do
{
QcModifyNotice qcModifyNotice = new QcModifyNotice();
for (int i = 0; i < dataReader.FieldCount; i++)
{
if (dataReader.IsDBNull(i))
{
continue;
}
switch (dataReader.GetName(i))
{
case SystemData.QcModifyNoticeTable.MODIFY_NOTICE_ID:
qcModifyNotice.MODIFY_NOTICE_ID = dataReader.GetValue(i).ToString();
break;
case SystemData.QcModifyNoticeTable.MODIFY_PERIOD:
qcModifyNotice.MODIFY_PERIOD = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.MODIFY_REMARK:
qcModifyNotice.MODIFY_REMARK = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.MODIFY_SCORE:
qcModifyNotice.MODIFY_SCORE = float.Parse(dataReader.GetValue(i).ToString());
break;
case SystemData.QcModifyNoticeTable.NOTICE_STATUS:
qcModifyNotice.NOTICE_STATUS = int.Parse(dataReader.GetValue(i).ToString());
break;
case SystemData.QcModifyNoticeTable.NOTICE_TIME:
qcModifyNotice.NOTICE_TIME = dataReader.GetDateTime(i);
break;
case SystemData.QcModifyNoticeTable.PATIENT_ID:
qcModifyNotice.PATIENT_ID = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.PATIENT_NAME:
qcModifyNotice.PATIENT_NAME = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.QC_DEPT_CODE:
qcModifyNotice.QC_DEPT_CODE = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.QC_DEPT_NAME:
qcModifyNotice.QC_DEPT_NAME = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.QC_LEVEL:
qcModifyNotice.QC_LEVEL = int.Parse(dataReader.GetValue(i).ToString());
break;
case SystemData.QcModifyNoticeTable.QC_MAN:
qcModifyNotice.QC_MAN = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.QC_MAN_ID:
qcModifyNotice.QC_MAN_ID = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.RECEIVER:
qcModifyNotice.RECEIVER = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.RECEIVER_DEPT_CODE:
qcModifyNotice.RECEIVER_DEPT_CODE = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.RECEIVER_DEPT_NAME:
qcModifyNotice.RECEIVER_DEPT_NAME = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.VISIT_ID:
qcModifyNotice.VISIT_ID = dataReader.GetString(i);
break;
case SystemData.QcModifyNoticeTable.VISIT_NO:
qcModifyNotice.VISIT_NO = dataReader.GetString(i);
break;
default: break;
}
}
lstQcModifyNotices.Add(qcModifyNotice);
} while (dataReader.Read());
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); }
}
/// <summary>
/// 修改整改通知书
/// </summary>
private void UpdateModifyNotice(QcModifyNotice qcModifyNotice)
{
qcModifyNotice.MODIFY_PERIOD = this.cbo_MODIFY_PERIOD.Text;
qcModifyNotice.MODIFY_REMARK = this.rtb_MODIFY_REMARK.Text;
qcModifyNotice.MODIFY_SCORE = float.Parse(this.lbl_MODIFY_SCORE.Text);
qcModifyNotice.NOTICE_TIME = DateTime.Parse(this.lbl_NOTICE_TIME.Text);
qcModifyNotice.PATIENT_ID = SystemParam.Instance.PatVisitInfo.PATIENT_ID;
qcModifyNotice.QC_DEPT_CODE = SystemParam.Instance.UserInfo.DEPT_CODE;
qcModifyNotice.QC_DEPT_NAME = SystemParam.Instance.UserInfo.DEPT_NAME;
qcModifyNotice.QC_LEVEL = SystemData.QcLevel.GetCodeByMrStatus(SystemParam.Instance.PatVisitInfo.MR_STATUS);
qcModifyNotice.QC_MAN = SystemParam.Instance.UserInfo.USER_NAME;
qcModifyNotice.QC_MAN_ID = SystemParam.Instance.UserInfo.USER_ID;
qcModifyNotice.RECEIVER = SystemParam.Instance.PatVisitInfo.INCHARGE_DOCTOR;
qcModifyNotice.RECEIVER_ID = SystemParam.Instance.PatVisitInfo.INCHARGE_DOCTOR_ID;
qcModifyNotice.RECEIVER_DEPT_CODE = SystemParam.Instance.PatVisitInfo.DEPT_CODE;
qcModifyNotice.RECEIVER_DEPT_NAME = SystemParam.Instance.PatVisitInfo.DEPT_NAME;
qcModifyNotice.VISIT_ID = SystemParam.Instance.PatVisitInfo.VISIT_ID;
qcModifyNotice.VISIT_NO = SystemParam.Instance.PatVisitInfo.VISIT_NO;
qcModifyNotice.NOTICE_STATUS = SystemData.NotifyStatus.Sended;
qcModifyNotice.NOTICE_TIME = SysTimeHelper.Instance.Now;
short shRet = QcModifyNoticeAccess.Instance.Update(qcModifyNotice);
//更新人工质控和质检信息 更新人工质控责任医生和责任科室，同步更新反馈消息
foreach (DataGridViewRow item in this.dataTableView1.Rows)
{
QcCheckResult qcCheckResult = item.Tag as QcCheckResult;
qcCheckResult.MODIFY_NOTICE_ID = qcModifyNotice.MODIFY_NOTICE_ID;
MedicalQcMsg medicalQcMsg = item.Cells[this.col_MSG_ID.Index].Tag as MedicalQcMsg;
UserInfo userInfo = item.Cells[this.col_INCHARGE_DOCTOR.Index].Tag as UserInfo;
if (userInfo != null)
{
qcCheckResult.DEPT_CODE = userInfo.DEPT_CODE;
qcCheckResult.DEPT_IN_CHARGE = userInfo.DEPT_NAME;
qcCheckResult.INCHARGE_DOCTOR = userInfo.USER_NAME;
qcCheckResult.INCHARGE_DOCTOR_ID = userInfo.USER_ID;
}
if (medicalQcMsg == null)
{
medicalQcMsg = this.ToQcMsg(qcCheckResult);
shRet = MedicalQcMsgAccess.Instance.Insert(medicalQcMsg);
item.Cells[this.col_MSG_ID.Index].Tag = medicalQcMsg;
}
else
{
if (userInfo != null)
{
medicalQcMsg.DEPT_STAYED = userInfo.DEPT_CODE;
medicalQcMsg.DEPT_NAME = userInfo.DEPT_NAME;
medicalQcMsg.DOCTOR_IN_CHARGE = userInfo.USER_NAME;
medicalQcMsg.DOCTOR_IN_CHARGE_ID = userInfo.USER_ID;
shRet = MedicalQcMsgAccess.Instance.Update(medicalQcMsg);
}
}
qcCheckResult.MSG_ID = medicalQcMsg.MSG_ID;
shRet = QcCheckResultAccess.Instance.Update(qcCheckResult);
}
if (shRet == SystemData.ReturnValue.OK)
{
MessageBoxEx.ShowMessage("修改成功");
this.lbl_NOTICE_STATUS.Text = SystemData.NotifyStatus.GetCnName(qcModifyNotice.NOTICE_STATUS);
this.lbl_NOTICE_TIME.Text = this.m_QcModifyNotice.NOTICE_TIME.ToString("yyyy-MM-dd HH:mm");
this.lbl_NOTICE_STATUS.ForeColor = Color.Blue;
}
this.Tag = qcModifyNotice;
}
