internal void m_txtSPECREMARKFindItem(string strFindCode, ListView lvwList)
{
DataTable m_dtSpcMessage = new DataTable();
long lngRes = m_objServer.m_lngGetSPECREMARKMessage(out m_dtSpcMessage);
if (lngRes > 0 && m_dtSpcMessage.Rows.Count > 0)
{
clsSpecreMark_VO[] m_objSpecreMark_VO = new clsSpecreMark_VO[m_dtSpcMessage.Rows.Count];
for (int i = 0; i < m_dtSpcMessage.Rows.Count; i++)
{
m_objSpecreMark_VO[i] = new clsSpecreMark_VO();
m_objSpecreMark_VO[i].m_strREMARKID_CHR = m_dtSpcMessage.Rows[i]["REMARKID_CHR"].ToString().Trim();
m_objSpecreMark_VO[i].m_strREMARKNAME_VCHR = m_dtSpcMessage.Rows[i]["REMARKNAME_VCHR"].ToString().Trim();
m_objSpecreMark_VO[i].m_strUSERCODE_VCHR = m_dtSpcMessage.Rows[i]["USERCODE_VCHR"].ToString().Trim();
ListViewItem lvi = lvwList.Items.Add(m_objSpecreMark_VO[i].m_strUSERCODE_VCHR);
lvi.SubItems.Add(m_objSpecreMark_VO[i].m_strREMARKNAME_VCHR);
lvi.Tag = m_objSpecreMark_VO[i].m_strREMARKID_CHR;
}
}
}
/// <summary>
/// 取消特别注释
/// </summary>
internal void DelData()
{
clsSpecreMark_VO m_objSpecreMark_VO = new clsSpecreMark_VO();
if (this.m_objViewer.m_txtREMARK.Tag != null)
{
m_objSpecreMark_VO = (clsSpecreMark_VO)this.m_objViewer.m_txtREMARK.Tag;
if (!m_objSpecreMark_VO.m_strSEQ_INT.ToString().Trim().Equals(""))
{
m_objSpecreMark_VO.m_strCANCELERID_CHR = this.m_objViewer.LoginInfo.m_strEmpID;
long lngReg = m_objManager.m_lngSaveDelPatientSPECREMARK(m_objSpecreMark_VO);
if (lngReg > 0)
{
MessageBox.Show("操作成功!", "提示框", MessageBoxButtons.OK, MessageBoxIcon.Information);
bindtheTextBox(m_strCurrentRegisterID);
//刷新左边信息
this.m_objViewer.ucPatientInfo1.m_mthFind(this.m_objViewer.zyh, 2);
m_strCurrentRegisterID = this.m_objViewer.ucPatientInfo1.RegisterID;
/*<===============================*/
}
}
}
}
/// <summary>
/// 保存特别注释
/// </summary>
internal void SaveData()
{
#region 判断
clsSpecreMark_VO Info_VO = null;
long lngReg = m_objManager.m_lngGetPatientSPECREMARK(m_strCurrentRegisterID, out Info_VO);
if (lngReg > 0)
{
if (this.m_objViewer.m_txtREMARK.Tag == null && Info_VO != null)
{
MessageBox.Show("当前病人的特注信息已被修改，请退出系统重新登录。", "警告", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
}
#endregion
clsSpecreMark_VO m_objSpecreMark_VO = new clsSpecreMark_VO();
if (this.m_objViewer.m_txtREMARK.Tag != null)
{
m_objSpecreMark_VO = (clsSpecreMark_VO)this.m_objViewer.m_txtREMARK.Tag;
if (m_objSpecreMark_VO.m_strSEQ_INT.ToString().Trim().Equals(""))
{
m_objSpecreMark_VO.m_strCREATORID_CHR = this.m_objViewer.LoginInfo.m_strEmpID;
m_objSpecreMark_VO.m_strREMARKNAME_VCHR = this.m_objViewer.m_txtREMARK.Text.Trim();
m_objSpecreMark_VO.m_strREGISTERID_CHR = m_strCurrentRegisterID;
m_objSpecreMark_VO.m_strDec_vchr = this.m_objViewer.m_txtDes.Text.Trim();
if (this.m_objViewer.m_ckbChargeCtl.Checked == true)
{
m_objSpecreMark_VO.m_intCHARGECTL_INT = 1;
}
else
{
m_objSpecreMark_VO.m_intCHARGECTL_INT = 0;
}
if (m_objSpecreMark_VO.m_strREMARKID_CHR.ToString().Trim().Equals(""))
{
MessageBox.Show("请先选择特别注释类型!", "提示框", MessageBoxButtons.OK, MessageBoxIcon.Question);
return;
}
if (m_objSpecreMark_VO.m_strREMARKNAME_VCHR.ToString().Trim().Equals(""))
{
MessageBox.Show("特注内容不能为空！", "提示框", MessageBoxButtons.OK, MessageBoxIcon.Question);
return;
}
lngReg = m_objManager.m_lngSaveNewPatientSPECREMARK(m_objSpecreMark_VO);
//m_objSpecreMark_VO.m_intSTATUS_INT = 1;
//m_objSpecreMark_VO.m_intCHARGECTL_INT = 0;
//保存变动日志
SaveEditLog();
}
else
{
m_objSpecreMark_VO.m_strREGISTERID_CHR = m_strCurrentRegisterID;
m_objSpecreMark_VO.m_strREMARKNAME_VCHR = this.m_objViewer.m_txtREMARK.Text.Trim();
m_objSpecreMark_VO.m_strDec_vchr = this.m_objViewer.m_txtDes.Text.Trim();
if (m_objSpecreMark_VO.m_strREMARKNAME_VCHR.ToString().Trim().Equals(""))
{
MessageBox.Show("特注内容不能为空！", "提示框", MessageBoxButtons.OK, MessageBoxIcon.Question);
return;
}
if (this.m_objViewer.m_ckbChargeCtl.Checked == true)
{
m_objSpecreMark_VO.m_intCHARGECTL_INT = 1;
}
else
{
m_objSpecreMark_VO.m_intCHARGECTL_INT = 0;
}
lngReg = m_objManager.m_lngSaveUpdatePatientSPECREMARK(m_objSpecreMark_VO);
//保存变动日志
SaveEditLog();
}
if (lngReg > 0)
{
MessageBox.Show("操作成功!", "提示框", MessageBoxButtons.OK, MessageBoxIcon.Information);
bindtheTextBox(m_strCurrentRegisterID);
//刷新左边信息
m_objViewer.ucPatientInfo1.m_mthFind(this.m_objViewer.zyh, 2);
m_strCurrentRegisterID = m_objViewer.ucPatientInfo1.RegisterID;
/*<===============================*/
}
}
}
public long m_lngGetPatientSPECREMARK(System.Security.Principal.IPrincipal p_objPrincipal, string m_strRegisterID, out clsSpecreMark_VO m_objSpecreMark_VO)
{
long lngRes = 0;
DataTable m_dtResult = new DataTable();
m_objSpecreMark_VO = new clsSpecreMark_VO();
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsSpecreMarkSvc", "m_lngGetPatientSPECREMARK");
if (lngRes < 0)
{
return(-1);
}
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = 0;
//读取当前 普通住院号头标识
// string strSQL = @"
// SELECT a.des_vchr,b.*
// FROM
// t_opr_bih_register a,
// (select * from t_opr_bih_patspecremark where STATUS_INT=1 and registerid_chr=?) b
// where a.registerid_chr=b.registerid_chr(+)
// and
// a.registerid_chr=?
// ";
string strSQL = @"
SELECT a.des_vchr,
b.SEQ_INT,
b.REGISTERID_CHR,
b.REMARKID_CHR,
b.REMARKNAME_VCHR,
b.START_DAT,
b.END_DAT,
b.STATUS_INT,
b.CHARGECTL_INT,
b.CREATORID_CHR,
b.CREAT_DAT
FROM
t_opr_bih_register a,
t_opr_bih_patspecremark b
where a.registerid_chr=b.registerid_chr(+) and
b.STATUS_INT = 1 and
a.registerid_chr = ? ";
System.Data.IDataParameter[] arrParams = null;
objHRPSvc.CreateDatabaseParameter(1, out arrParams);
arrParams[0].Value = m_strRegisterID;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref m_dtResult, arrParams);
if (lngRes > 0 && m_dtResult.Rows.Count > 0)
{
m_objSpecreMark_VO.m_strSEQ_INT = m_dtResult.Rows[0]["SEQ_INT"].ToString().Trim();
m_objSpecreMark_VO.m_strREMARKID_CHR = m_dtResult.Rows[0]["REMARKID_CHR"].ToString().Trim();
m_objSpecreMark_VO.m_strREMARKNAME_VCHR = m_dtResult.Rows[0]["REMARKNAME_VCHR"].ToString().Trim();
m_objSpecreMark_VO.m_strDec_vchr = m_dtResult.Rows[0]["des_vchr"].ToString().Trim();
m_objSpecreMark_VO.m_intCHARGECTL_INT = Convert.ToInt16(m_dtResult.Rows[0]["CHARGECTL_INT"].ToString().Trim());
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngSaveDelPatientSPECREMARK(System.Security.Principal.IPrincipal p_objPrincipal, clsSpecreMark_VO m_objSpecreMark_VO)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsSpecreMarkSvc", "m_lngSaveDelPatientSPECREMARK");
if (lngRes < 0)
{
return(-1);
}
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = 0;
string strSQL = "";
strSQL = @"
update T_OPR_BIH_PATSPECREMARK set CANCELERID_CHR = ?, CANCEL_DAT = sysdate, STATUS_INT = 0
where SEQ_INT = ? ";
System.Data.IDataParameter[] arrParams = null;
objHRPSvc.CreateDatabaseParameter(2, out arrParams);
arrParams[0].Value = m_objSpecreMark_VO.m_strCANCELERID_CHR;
arrParams[1].Value = m_objSpecreMark_VO.m_strSEQ_INT;
long lngAff = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngAff, arrParams);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngSaveUpdatePatientSPECREMARK(System.Security.Principal.IPrincipal p_objPrincipal, clsSpecreMark_VO m_objSpecreMark_VO)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsSpecreMarkSvc", "m_lngSaveUpdatePatientSPECREMARK");
if (lngRes < 0)
{
return(-1);
}
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = 0;
string strSQL = "";
strSQL = @"
update T_OPR_BIH_PATSPECREMARK set REMARKID_CHR = ?, REMARKNAME_VCHR = ?, CHARGECTL_INT = ?
where SEQ_INT = ?
";
System.Data.IDataParameter[] arrParams = null;
objHRPSvc.CreateDatabaseParameter(4, out arrParams);
arrParams[0].Value = m_objSpecreMark_VO.m_strREMARKID_CHR;
arrParams[1].Value = m_objSpecreMark_VO.m_strREMARKNAME_VCHR;
arrParams[2].Value = m_objSpecreMark_VO.m_intCHARGECTL_INT;
arrParams[3].Value = m_objSpecreMark_VO.m_strSEQ_INT;
long lngAff = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngAff, arrParams);
strSQL = @"update t_opr_bih_register set des_vchr = ?
where registerid_chr = ?";
System.Data.IDataParameter[] arrParams2 = null;
objHRPSvc.CreateDatabaseParameter(2, out arrParams2);
arrParams2[0].Value = m_objSpecreMark_VO.m_strDec_vchr;
arrParams2[1].Value = m_objSpecreMark_VO.m_strREGISTERID_CHR;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngAff, arrParams2);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
internal long m_lngSaveDelPatientSPECREMARK(clsSpecreMark_VO m_objSpecreMark_VO)
{
com.digitalwave.iCare.middletier.HIS.clsSpecreMarkSvc objSvc = (com.digitalwave.iCare.middletier.HIS.clsSpecreMarkSvc)
com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsSpecreMarkSvc));
return(objSvc.m_lngSaveDelPatientSPECREMARK(objPrincipal, m_objSpecreMark_VO));
}