private void dataTableView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
RecPrintLog recPrintLog = this.dataTableView1.Rows[e.RowIndex].Tag as RecPrintLog;
if (e.ColumnIndex == this.colEdit.Index)
{
if (recPrintLog.DISCHARGE_TIME != recPrintLog.DefaultTime)
{
this.txt_DISCHARGE_TIME.Text = recPrintLog.DISCHARGE_TIME.ToString("yyyy-MM-dd HH:mm");
}
txt_MONEY.Text = recPrintLog.MONEY.ToString();
txt_PATIENT_ID.Text = recPrintLog.PATIENT_ID;
txt_PATIENT_IDENTIFICATION.Text = recPrintLog.PATIENT_ID_NO;
txt_PATIENT_NAME.Text = recPrintLog.PATIENT_NAME;
txt_PRINT_IDENTIFICATION.Text = recPrintLog.PRINT_ID_NO;
if (!string.IsNullOrEmpty(recPrintLog.PRINT_CONTENT))
{
foreach (var item in this.p_PRINT_CONTENT.Controls)
{
var chk = item as MetroCheckBox;
if (chk == null)
{
continue;
}
chk.Checked = false;
if (recPrintLog.PRINT_CONTENT.IndexOf(chk.Text) >= 0)
{
chk.Checked = true;
}
}
}
txt_RELATIONSHIP_PATIENT.Text = recPrintLog.RELATIONSHIP_PATIENT;
txt_REMARKS.Text = recPrintLog.REMARKS;
this.Tag = recPrintLog;
}
else if (e.ColumnIndex == this.colDelete.Index)
{
if (MessageBoxEx.ShowConfirm("确定删除吗？") != DialogResult.OK)
{
return;
}
short shRet = RecPrintLogAccess.Instance.Delete(recPrintLog.PRINT_ID);
if (shRet == SystemData.ReturnValue.OK)
{
this.dataTableView1.Rows.RemoveAt(e.RowIndex);
}
else
{
MessageBoxEx.ShowError("删除失败");
}
}
}
/// <summary>
/// 更新一条整改通知单
/// </summary>
/// <param name="timeQCRule">自动核查规则配置信息</param>
/// <returns>SystemData.ReturnValue</returns>
public short Update(RecPrintLog recPrintLog)
{
if (recPrintLog == null)
{
LogManager.Instance.WriteLog("", new string[] { "" }
, new object[] { recPrintLog }, "参数不能为空");
return(SystemData.ReturnValue.PARAM_ERROR);
}
if (base.MedQCAccess == null)
{
return(SystemData.ReturnValue.PARAM_ERROR);
}
StringBuilder sbField = new StringBuilder();
sbField.AppendFormat("{0}={1},"
, SystemData.RecPrintLogTable.DISCHARGE_TIME, base.MedQCAccess.GetSqlTimeFormat(recPrintLog.DISCHARGE_TIME));
sbField.AppendFormat("{0}={1},"
, SystemData.RecPrintLogTable.INVOICE, recPrintLog.INVOICE ? 1 : 0);
sbField.AppendFormat("{0}={1},"
, SystemData.RecPrintLogTable.MONEY, recPrintLog.MONEY);
sbField.AppendFormat("{0}='{1}',"
, SystemData.RecPrintLogTable.PATIENT_ID, recPrintLog.PATIENT_ID);
sbField.AppendFormat("{0}='{1}',"
, SystemData.RecPrintLogTable.PATIENT_ID_NO, recPrintLog.PATIENT_ID_NO);
sbField.AppendFormat("{0}='{1}',"
, SystemData.RecPrintLogTable.PATIENT_NAME, recPrintLog.PATIENT_NAME);
sbField.AppendFormat("{0}='{1}',"
, SystemData.RecPrintLogTable.PRINT_CONTENT, recPrintLog.PRINT_CONTENT);
sbField.AppendFormat("{0}='{1}',"
, SystemData.RecPrintLogTable.PRINT_ID, recPrintLog.PRINT_ID);
sbField.AppendFormat("{0}='{1}',"
, SystemData.RecPrintLogTable.PRINT_ID_NO, recPrintLog.PRINT_ID_NO);
sbField.AppendFormat("{0}='{1}',"
, SystemData.RecPrintLogTable.PRINT_NAME, recPrintLog.PRINT_NAME);
sbField.AppendFormat("{0}={1},"
, SystemData.RecPrintLogTable.PRINT_TIME, base.MedQCAccess.GetSqlTimeFormat(recPrintLog.PRINT_TIME));
sbField.AppendFormat("{0}='{1}',"
, SystemData.RecPrintLogTable.RELATIONSHIP_PATIENT, recPrintLog.RELATIONSHIP_PATIENT);
sbField.AppendFormat("{0}='{1}',"
, SystemData.RecPrintLogTable.REMARKS, recPrintLog.REMARKS);
sbField.AppendFormat("{0}='{1}',"
, SystemData.RecPrintLogTable.VISIT_ID, recPrintLog.VISIT_ID);
sbField.AppendFormat("{0}='{1}'"
, SystemData.RecPrintLogTable.VISIT_NO, recPrintLog.VISIT_NO);
string szCondition = string.Format("{0}='{1}'", SystemData.RecPrintLogTable.PRINT_ID, recPrintLog.PRINT_ID);
string szSQL = string.Format(SystemData.SQL.UPDATE, SystemData.DataTable.REC_PRINT_LOG, 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 GetRecPrintLog(string szPrintID, ref RecPrintLog RecPrintLog)
{
if (base.MedQCAccess == null)
{
return(SystemData.ReturnValue.PARAM_ERROR);
}
StringBuilder sbField = new StringBuilder();
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.DISCHARGE_TIME);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.INVOICE);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.MONEY);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.PATIENT_ID);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.PATIENT_ID_NO);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.PATIENT_NAME);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.PRINT_CONTENT);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.PRINT_ID);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.PRINT_ID_NO);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.PRINT_NAME);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.PRINT_TIME);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.RELATIONSHIP_PATIENT);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.REMARKS);
sbField.AppendFormat("{0},", SystemData.RecPrintLogTable.VISIT_ID);
sbField.AppendFormat("{0}", SystemData.RecPrintLogTable.VISIT_NO);
string szCondition = string.Format("1=1");
if (!string.IsNullOrEmpty(szPrintID))
{
szCondition = string.Format("{0} AND {1} = '{2}'"
, szCondition
, SystemData.RecPrintLogTable.PRINT_ID
, szPrintID);
}
string szSQL = string.Format(SystemData.SQL.SELECT_WHERE
, sbField.ToString(), SystemData.DataTable.REC_PRINT_LOG, 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 (RecPrintLog == null)
{
RecPrintLog = new RecPrintLog();
}
for (int i = 0; i < dataReader.FieldCount; i++)
{
if (dataReader.IsDBNull(i))
{
continue;
}
switch (dataReader.GetName(i))
{
case SystemData.RecPrintLogTable.DISCHARGE_TIME:
RecPrintLog.DISCHARGE_TIME = dataReader.GetDateTime(i);
break;
case SystemData.RecPrintLogTable.INVOICE:
RecPrintLog.INVOICE = dataReader.GetValue(i).ToString() == "1";
break;
case SystemData.RecPrintLogTable.MONEY:
RecPrintLog.MONEY = float.Parse(dataReader.GetValue(i).ToString());
break;
case SystemData.RecPrintLogTable.PATIENT_ID:
RecPrintLog.PATIENT_ID = dataReader.GetString(i);
break;
case SystemData.RecPrintLogTable.PATIENT_ID_NO:
RecPrintLog.PATIENT_ID_NO = dataReader.GetValue(i).ToString();
break;
case SystemData.RecPrintLogTable.PATIENT_NAME:
RecPrintLog.PATIENT_NAME = dataReader.GetString(i);
break;
case SystemData.RecPrintLogTable.VISIT_ID:
RecPrintLog.VISIT_ID = dataReader.GetString(i);
break;
case SystemData.RecPrintLogTable.VISIT_NO:
RecPrintLog.VISIT_NO = dataReader.GetString(i);
break;
case SystemData.RecPrintLogTable.PRINT_CONTENT:
RecPrintLog.PRINT_CONTENT = dataReader.GetString(i);
break;
case SystemData.RecPrintLogTable.PRINT_ID:
RecPrintLog.PRINT_ID = dataReader.GetString(i);
break;
case SystemData.RecPrintLogTable.PRINT_ID_NO:
RecPrintLog.PRINT_ID_NO = dataReader.GetString(i);
break;
case SystemData.RecPrintLogTable.PRINT_NAME:
RecPrintLog.PRINT_NAME = dataReader.GetString(i);
break;
case SystemData.RecPrintLogTable.PRINT_TIME:
RecPrintLog.PRINT_TIME = dataReader.GetDateTime(i);
break;
case SystemData.RecPrintLogTable.RELATIONSHIP_PATIENT:
RecPrintLog.RELATIONSHIP_PATIENT = dataReader.GetString(i);
break;
case SystemData.RecPrintLogTable.REMARKS:
RecPrintLog.REMARKS = 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); }
}
private void btnSave_Click(object sender, EventArgs e)
{
RecPrintLog recPrintLog = this.Tag as RecPrintLog;
if (recPrintLog == null)
{
recPrintLog = new RecPrintLog();
}
recPrintLog.DISCHARGE_TIME = SystemParam.Instance.PatVisitInfo.DISCHARGE_TIME;
if (this.rbtn_INVOICE1.Checked)
{
recPrintLog.INVOICE = true;
}
else
{
recPrintLog.INVOICE = false;
}
if (!string.IsNullOrEmpty(txt_MONEY.Text.Trim()))
{
recPrintLog.MONEY = float.Parse(this.txt_MONEY.Text.Trim());
}
StringBuilder sbPrintContent = new StringBuilder();
foreach (Control item in this.p_PRINT_CONTENT.Controls)
{
MetroCheckBox chk = item as MetroCheckBox;
if (chk == null)
{
continue;
}
if (chk.Checked)
{
sbPrintContent.Append(chk.Text + "|");
}
}
recPrintLog.PRINT_CONTENT = sbPrintContent.ToString();
recPrintLog.PATIENT_ID = txt_PATIENT_ID.Text;
recPrintLog.PATIENT_ID_NO = txt_PATIENT_IDENTIFICATION.Text;
recPrintLog.PATIENT_NAME = txt_PATIENT_NAME.Text;
recPrintLog.PRINT_ID_NO = txt_PRINT_IDENTIFICATION.Text.Trim();
recPrintLog.PRINT_NAME = txt_PRINT_NAME.Text;
recPrintLog.PRINT_TIME = DateTime.Now;
recPrintLog.RELATIONSHIP_PATIENT = txt_RELATIONSHIP_PATIENT.Text;
recPrintLog.REMARKS = txt_REMARKS.Text;
recPrintLog.VISIT_ID = SystemParam.Instance.PatVisitInfo.VISIT_ID;
recPrintLog.VISIT_NO = SystemParam.Instance.PatVisitInfo.VISIT_NO;
short shRet = SystemData.ReturnValue.OK;
if (!string.IsNullOrEmpty(recPrintLog.PRINT_ID))
{
shRet = RecPrintLogAccess.Instance.Update(recPrintLog);
}
else
{
recPrintLog.PRINT_ID = recPrintLog.MakeID();
shRet = RecPrintLogAccess.Instance.Insert(recPrintLog);
}
if (shRet != SystemData.ReturnValue.OK)
{
MessageBoxEx.ShowError("操作失败");
return;
}
MessageBoxEx.ShowMessage("保存成功");
this.GetGridData();
}
