public long m_lngVerichDropRecord(System.Security.Principal.IPrincipal p_objPrincipal, int p_Seq, int p_Order)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsMedStoreBseInfoSvc", "m_lngVerichDropRecord");
if (lngRes < 0)
{
return(-1);
}
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService();
string strSQL = @" update T_OPR_MEDSTOREWINQUE set ORDER_INT=? where SEQ_INT=?";
System.Data.IDataParameter[] paramArr = null;
objHRPSvc.CreateDatabaseParameter(2, out paramArr);
paramArr[0].Value = p_Order;
paramArr[1].Value = p_Seq;
long lngRecordsAffected = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordsAffected, paramArr);
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_lngDeleteReportObject(System.Security.Principal.IPrincipal p_objPrincipal,
string p_strApplicationID)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsReportSvc", "m_lngDeleteReportObject");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"DELETE FROM t_opr_lis_report_object
WHERE application_id_chr = ?" ;
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc =
new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService();
IDataParameter[] objDPArr = null;
objHRPSvc.CreateDatabaseParameter(1, out objDPArr);
objDPArr[0].Value = p_strApplicationID;
lngRes = 0;
long lngEff = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr);
return(lngRes);
}
public long m_lngInsertReportObject(System.Security.Principal.IPrincipal p_objPrincipal,
clsReportObject p_objReportObject)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsReportSvc", "m_lngInsertReportObject");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"delete t_opr_lis_report_object a where a.application_id_chr = ?";
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc =
new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService();
IDataParameter[] objDPArr = null;
long lngEff = 0;
objHRPSvc.CreateDatabaseParameter(1, out objDPArr);
objDPArr[0].Value = p_objReportObject.strApplicationID;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr);
if (lngRes <= 0)
{
return(lngRes);
}
strSQL = @"insert into t_opr_lis_report_object
values (?, ?,?)" ;
objHRPSvc.CreateDatabaseParameter(3, out objDPArr);
objDPArr[0].Value = p_objReportObject.strApplicationID;
objDPArr[1].Value = p_objReportObject.bytReportObjectArr;
objDPArr[2].Value = 0;
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr);
return(lngRes);
}
public long m_lngAddMedSendGiveRelation(System.Security.Principal.IPrincipal p_objPrincipal, out int p_intSeq,
clsMedSendConfig_VO p_objWinArr)
{
long lngRes = 0;
p_intSeq = 0; //流水号
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsMedStoreBseInfoSvc", "m_lngAddMedSendGiveRelation");
if (lngRes < 0)
{
return(-1);
}
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService();
p_intSeq = Convert.ToInt32(objHRPSvc.m_strGetNewID("T_OPR_MEDSTOREWINRLT", "SEQ_INT", 6));
string strSQL = @"INSERT INTO T_OPR_MEDSTOREWINRLT
(SEQ_INT, TREATWINID_CHR, GIVEWINID_CHR,
ORDER_INT
)
VALUES (?,?,?,?)" ;
System.Data.IDataParameter[] paramArr = null;
objHRPSvc.CreateDatabaseParameter(4, out paramArr);
paramArr[0].Value = p_intSeq;
paramArr[1].Value = p_objWinArr.m_TreatWinID_chr;
paramArr[2].Value = p_objWinArr.m_GiveWinID_chr;
paramArr[3].Value = p_objWinArr.m_intOrder;
long lngRecordsAffected = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordsAffected, paramArr);
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_lngInsert(clsST360CheckResultVO m_objResult)
{
long lngRes = 0;
string sql = @"
INSERT INTO t_opr_lis_st360_result
(sampleid_int, sampletype_int, boardno_vchr, templateno_int,
check_item_id_int, check_item_name_vchr,
check_item_english_name_vchr, modify_dat, operator_dat,
device_send_dat, resultnum_vchr, resulttext_vchr, status_int,
deviceid_chr, operator_id_chr, summary_vchr,Positive_INT
)
VALUES (?, ?, ?, ?,
?, ?,
?, ?, ?,
?, ?, ?, ?,
?, ?, ?,?
)
";
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService hrpService = new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService();
try
{
System.Data.IDataParameter[] objODPArr = GetInsertDataParameterArr(m_objResult);
long lngRecEff = -1;
//往表增加记录
lngRes = 0;
lngRes = hrpService.lngExecuteParameterSQL(sql, ref lngRecEff, objODPArr);
hrpService.Dispose();
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
public long m_lngHorDropRecord(System.Security.Principal.IPrincipal p_objPrincipal, int p_Seq, string p_WinID, int p_WinType, int p_Order)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsMedStoreBseInfoSvc", "m_lngHorDropRecord");
if (lngRes < 0)
{
return(-1);
}
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService();
string strSQL = @" update T_OPR_MEDSTOREWINQUE a set a.ORDER_INT=?,a.WINDOWID_CHR=? where a.SEQ_INT=?";
System.Data.IDataParameter[] paramArr = null;
objHRPSvc.CreateDatabaseParameter(3, out paramArr);
paramArr[0].Value = p_Order;
paramArr[1].Value = p_WinID;
paramArr[2].Value = p_Seq;
long lngRecordsAffected = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordsAffected, paramArr);
string p_strSQL = "";
if (p_WinType == 0)
{
p_strSQL = @" update t_opr_medrecipesend b set b.SENDWINDOWID=? where b.OUTPATRECIPEID_CHR in (select a.OUTPATRECIPEID_CHR from T_OPR_MEDSTOREWINQUE a where a.SEQ_INT=? )";
paramArr = null;
objHRPSvc.CreateDatabaseParameter(2, out paramArr);
paramArr[0].Value = p_WinID;
paramArr[1].Value = p_Seq;
lngRecordsAffected = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(p_strSQL, ref lngRecordsAffected, paramArr);
}
else if (p_WinType == 1)
{
paramArr = null;
objHRPSvc.CreateDatabaseParameter(2, out paramArr);
paramArr[0].Value = p_WinID;
paramArr[1].Value = p_Seq;
lngRecordsAffected = -1;
p_strSQL = @" update t_opr_medrecipesend b set b.WINDOWID_CHR=? where b.OUTPATRECIPEID_CHR=(select a.outpatrecipeid_chr from T_OPR_MEDSTOREWINQUE a where a.seq_int=?)";
lngRes = objHRPSvc.lngExecuteParameterSQL(p_strSQL, ref lngRecordsAffected, paramArr);
p_strSQL = @" update t_opr_outpatientpwmrecipede b set b.WINDOWID_CHR=? where b.OUTPATRECIPEID_CHR=(select a.outpatrecipeid_chr from T_OPR_MEDSTOREWINQUE a where a.seq_int=?)";
lngRes = objHRPSvc.lngExecuteParameterSQL(p_strSQL, ref lngRecordsAffected, paramArr);
p_strSQL = @" update T_OPR_OUTPATIENTCMRECIPEDE b set b.WINDOWID_CHR=? where b.OUTPATRECIPEID_CHR=(select a.outpatrecipeid_chr from T_OPR_MEDSTOREWINQUE a where a.seq_int=?)";
lngRes = objHRPSvc.lngExecuteParameterSQL(p_strSQL, ref lngRecordsAffected, paramArr);
p_strSQL = @" update T_OPR_OUTPATIENTCHKRECIPEDE b set b.WINDOWID_CHR=? where b.OUTPATRECIPEID_CHR=(select a.outpatrecipeid_chr from T_OPR_MEDSTOREWINQUE a where a.seq_int=?)";
lngRes = objHRPSvc.lngExecuteParameterSQL(p_strSQL, ref lngRecordsAffected, paramArr);
p_strSQL = @" update T_OPR_OUTPATIENTTESTRECIPEDE b set b.WINDOWID_CHR=? where b.OUTPATRECIPEID_CHR=(select a.outpatrecipeid_chr from T_OPR_MEDSTOREWINQUE a where a.seq_int=?)";
lngRes = objHRPSvc.lngExecuteParameterSQL(p_strSQL, ref lngRecordsAffected, paramArr);
p_strSQL = @" update T_OPR_OUTPATIENTOPSRECIPEDE b set b.WINDOWID_CHR=? where b.OUTPATRECIPEID_CHR=(select a.outpatrecipeid_chr from T_OPR_MEDSTOREWINQUE a where a.seq_int=?)";
lngRes = objHRPSvc.lngExecuteParameterSQL(p_strSQL, ref lngRecordsAffected, paramArr);
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}