public long GetSpecialDisease(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable p_dtResult)
{
long lngRes = 0;
p_dtResult = new DataTable();
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsPrepayQuerySvc", "GetSpecialDisease");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @" select deacode_chr, deadesc_vchr, yearmoney_int, sort_int, status_int, note_vchr from t_opr_ybspecialtypedisease order by deacode_chr";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = 0;
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtResult);
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_lngCommitForce(System.Security.Principal.IPrincipal p_objPrincipal, DataTable p_outDatatable)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsKillLockSVC", "m_lngCommitForce");
if (lngRes < 0)//权限
{
return(-1);
}
StringBuilder strSQL = new StringBuilder(@"commit force ");
try
{
string m_strTemp = string.Empty;
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
for (int i = 0; i < p_outDatatable.Rows.Count; i++)
{
m_strTemp = string.Empty;
m_strTemp = "'" + p_outDatatable.Rows[i]["local_tran_id"].ToString() + "'";
strSQL.Append(m_strTemp);
objHRPSvc.DoExcute(strSQL.ToString());
strSQL = new StringBuilder(@"commit force ");
}
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_lngUpdate(System.Security.Principal.IPrincipal p_objPrincipal,
clsLisQCConcentrationVO p_objQCConcentration)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngUpdate");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
try
{
System.Data.IDataParameter[] objODPArr = GetUpdateDataParameterArr(p_objQCConcentration);
long lngRecEff = -1;
//往表增加记录
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(m_strUpdateSql, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
public long m_lngUPDateFeeList(System.Security.Principal.IPrincipal objPri,
clsPatRegFee_VO clsVO)
{
com.digitalwave.security.clsPrivilegeHandleService clsSec = new clsPrivilegeHandleService();
long lngRes = clsSec.m_lngCheckCallPrivilege(objPri, "com.digitalwave.iCare.middletier.HIS.clsOPDoctorSvc", "m_lngFindWaitDiagList");
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = @"UPDate t_opPatRegAmount Set regfee=?,diagfee=?
Where registertypeid_chr=? And paytypeid_chr=?";
System.Data.IDataParameter[] objPara = clsIDataParameterCreator.s_objConstructIDataParameterArr
(new object[] { clsVO.m_decRegFee, clsVO.m_decDiagFee, clsVO.m_strRegisterTypeID, clsVO.m_strPayTypeID });
try
{
long lngRec = 0;
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService HRPSvc = new clsHRPTableService();
lngRes = HRPSvc.lngExecuteParameterSQL(strSQL, ref lngRec, objPara);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
lngRes = -2;
}
return(lngRes);
}
public long m_lngKillSessionByID(System.Security.Principal.IPrincipal p_objPrincipal, DataTable p_outDatatable)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsKillLockSVC", "m_lngKillSessionByID");
if (lngRes < 0)//权限
{
return(-1);
}
StringBuilder strSQL = new StringBuilder(@"alter system kill session '[compression]'");
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string m_strTemp;
for (int i = 0; i < p_outDatatable.Rows.Count; i++)
{
m_strTemp = string.Empty;
m_strTemp = p_outDatatable.Rows[i]["sid"].ToString() + "," + p_outDatatable.Rows[i]["SERIAL#"].ToString();
strSQL = strSQL.Replace("[compression]", m_strTemp);
objHRPSvc.DoExcute(strSQL.ToString());
strSQL = new StringBuilder(@"alter system kill session '[compression]'");
}
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_lngGetSampleGroupUnitByApplUnitID(System.Security.Principal.IPrincipal p_objPrincipal, string p_strApplUnitID,
out DataTable p_dtbResult)
{
long lngRes = 0;
p_dtbResult = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsSampleGroupSvc", "m_lngGetSampleGroupUnitByApplUnitID");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT * FROM T_AID_LIS_SAMPLE_GROUP_UNIT WHERE APPLY_UNIT_ID_CHR = '" + p_strApplUnitID + @"'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtbResult);
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_mthGetManiReportData(System.Security.Principal.IPrincipal p_objPrincipal, DateTime date, DateTime date2, out System.Data.DataTable dt, out System.Data.DataTable dt2)
{
dt = new DataTable();
dt2 = new DataTable();
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReckoningReport", "m_lngFindByDateReport");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
//and a.RECORDEMP_CHR=d.empid_chr(+)
string strSQL = "select a.OUTPATRECIPEID_CHR,c.lastname_vchr PatientName,a.CREATEDATE_DAT \"" + "date" + "\"" + @",e.invoiceno_vchr invoiceNo,c.difficulty_vchr difficultyNo,case when A.RECIPEFLAG_INT=1 then 5.00 else 0 end as RegisterCost,'' CheckSelfPay,
'' CheckChargeUp,'' CureSelfPay,'' CureChargeUp,'' MedicineSelfPay, '' MedicineChargeUp,d.lastname_vchr Operator,a.RECIPEFLAG_INT,e.STATUS_INT,e.seqid_chr
from T_OPR_OUTPATIENTRECIPE A,T_BSE_PATIENT c,T_BSE_EMPLOYEE D,T_OPR_OUTPATIENTRECIPEINV E, t_bse_patientPaytype f
where a.PSTAUTS_INT =2
and a.paytypeid_chr=f.paytypeid_chr(+)
and f.INTERNALFLAG_INT =3
and a.CREATEDATE_DAT BETWEEN TO_DATE('" + date.ToString("yyyy-MM-dd 00:00:00") + "','yyyy-mm-dd hh24:mi:ss') " +
@" AND TO_DATE('" + date2.ToString("yyyy-MM-dd 23:59:59") + @"','yyyy-mm-dd hh24:mi:ss')
and a.patientid_chr =c.patientid_chr(+)
AND e.OPREMP_CHR = d.empid_chr(+)
and a.outpatrecipeid_chr=e.OUTPATRECIPEID_CHR(+) and e.balanceflag_int=1";
string strSQL2 = @"select A.OUTPATRECIPEID_CHR,a.SELFPAY,a.CHARGEUP,b.GROUPID_CHR,a.SEQID_CHR from (
select a.outpatrecipeid_chr,sum(b.tolprice_mny*b.discount_dec) as SelfPay,sum(b.tolprice_mny*(1-b.discount_dec)) as chargeUp,C.ITEMOPINVTYPE_CHR,e.SEQID_CHR
from T_OPR_OUTPATIENTRECIPE A,T_OPR_OPRECIPEITEMDE B ,T_BSE_CHARGEITEM C,t_bse_patientpaytype f, T_OPR_OUTPATIENTRECIPEINV e
WHERE a.pstauts_int = 2
AND a.paytypeid_chr = f.paytypeid_chr(+)
AND f.internalflag_int = 3
and a.outpatrecipeid_chr =e.outpatrecipeid_chr(+)
and a.CREATEDATE_DAT BETWEEN TO_DATE('" + date.ToString("yyyy-MM-dd 00:00:00") + "','yyyy-mm-dd hh24:mi:ss') " +
@" AND TO_DATE('" + date2.ToString("yyyy-MM-dd 23:59:59") + @"','yyyy-mm-dd hh24:mi:ss')
and a.outpatrecipeid_chr=B.outpatrecipeid_chr(+)
and b.itemid_chr=c.itemid_chr(+)
and e.balanceflag_int=1
group by a.outpatrecipeid_chr,ITEMOPINVTYPE_CHR,SEQID_CHR) A,
(
select rptid_chr,groupid_chr,typeid_chr,flag_int
from t_aid_rpt_gop_rla
where rptid_chr = '0044' and flag_int = 2) b
where a.ITEMOPINVTYPE_CHR =b.TYPEID_CHR(+) order by 1,5";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dt);
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL2, ref dt2);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetCMUsageInformation(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable m_objTable)
{
long lngRes = 0;
m_objTable = null;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsCmCookingMethodItemGroupSvc", "m_lngGetCMUsageInformation");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = @"select * from t_aid_cmcookingmethod";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref m_objTable);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngUpdApplUserGroup(System.Security.Principal.IPrincipal p_objPrincipal, string p_strHasChildGroup,
string p_strApplUserGroupID)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngUpdApplUserGroup");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"UPDATE t_aid_lis_appuser_group
SET has_child_group = '" + p_strHasChildGroup + @"'
WHERE user_group_id_chr = '" + p_strApplUserGroupID + @"'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDeleteRecipeFrequencyByID(System.Security.Principal.IPrincipal p_objPrincipal, string strID)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngDeleteRecipeFrequencyByID");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "Delete t_aid_recipefreq " +
" Where FREQID_CHR='" + strID + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDelRelationItemInformationByID(System.Security.Principal.IPrincipal p_objPrincipal, string m_strRowNo, string m_strUsageID, string m_strItemID)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsCmCookingMethodItemGroupSvc", "m_lngDelRelationItemInformationByID");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = @"delete T_AID_CMCOOKINGMETHODITEMGROUP A where A.rowno_chr='" + m_strRowNo + "'and A.usageid_chr='" + m_strUsageID + "' and A.itemid_chr='" + m_strItemID + "'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngIsUseingPAYTYPE(System.Security.Principal.IPrincipal p_objPrincipal, string p_strID, string p_strIsUseing)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegTypeSvc", "m_lngIsUseingPAYTYPE");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDATE t_bse_patientPaytype SET " +
"ISUSING_NUM = '" + p_strIsUseing + "' " +
"WHERE PAYTYPEID_CHR = '" + p_strID + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDoUpdRegChargeTypeByID(System.Security.Principal.IPrincipal p_objPrincipal, clsRegchargeType_VO objResult)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngDoUpdRegChargeTypeByID");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDate t_bse_registerchargetype Set " +
"CHARGENAME_CHR='" + objResult.m_strCHARGENAME_CHR + "' " +
", MEMO_VCHR='" + objResult.m_strMEMO_VCHR + "' " +
", CHARGENO_VCHR='" + objResult.m_strCHARGENO_VCHR + "' " +
" Where CHARGEID_CHR='" + objResult.m_strCHARGEID_CHR + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long GetICD(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable p_dtResult)
{
long lngRes = 0;
p_dtResult = new DataTable();
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsPrepayQuerySvc", "GetICD");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @" select jxcode_chr, wbcode_chr, pycode_chr, icdname_vchr, icdcode_chr, icdcat_chr from t_aid_icd10 order by icdcode_chr";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = 0;
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtResult);
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_lngDelete(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdQCRulesSvc", "m_lngDelete");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = @"DELETE T_BSE_LIS_QCRULES WHERE RULE_SEQ_INT = ?";
try
{
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
p_intSeq);
long lngRecEff = -1;
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
public long m_lngDelApplUserGroup(System.Security.Principal.IPrincipal p_objPrincipal, string strApplUserGroupID)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngDelApplUserGroup");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"DELETE FROM t_aid_lis_appuser_group WHERE USER_GROUP_ID_CHR = '" + strApplUserGroupID + "'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
long lngRecEff = -1;
lngRes = objHRPSvc.DoExcuteForDelete(strSQL, ref lngRecEff);
if (lngRecEff > -1)
{
lngRes = 1;
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDoAddNewUsageType(System.Security.Principal.IPrincipal p_objPrincipal, string p_usageID, string p_usageType)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngDoAddNewUsageType");
if (lngRes < 0)//没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = "INSERT INTO t_opr_setusage (USAGEID_CHR,TYPE_INT) VALUES ('" + p_usageID + "'," + p_usageType + ")";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
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_lngGetAllUserGroupApplUnitID(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable dtbApplUnit)
{
long lngRes = 0;
dtbApplUnit = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngAddApplUserRelation");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT DISTINCT apply_unit_id_chr FROM t_aid_lis_appuser_group_detail";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbApplUnit);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngUpBALANCEFLAG(System.Security.Principal.IPrincipal p_objPrincipal, string p_strName, string finddate)
{
long lngRes = 1;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReckoningReport", "m_lngUpBALANCEFLAG");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDATE t_opr_outpatientrecipeinv SET balanceflag_int = 1 " +
"WHERE balanceflag_int = 0 and INVDATE_DAT like to_date('" + finddate + "','yyyy-MM-dd') and OPREMP_CHR = '" + p_strName.Trim() + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDoAddNewModule(System.Security.Principal.IPrincipal p_objPrincipal, string p_strModuleName, string p_strEngName, string p_strPYCode, string p_strWBCode, out string p_strID)
{
long lngRes = 0;
p_strID = "";
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsUsageSvc", "m_lngDoAddNewModule");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
lngRes = objHRPSvc.lngGenerateID(4, "MODULEID_CHR", "T_SYS_MODULE", out p_strID);
if (lngRes < 0)
{
return(-1);
}
string strSQL = "INSERT INTO T_SYS_MODULE (MODULEID_CHR, MODULENAME_CHR, ENGNAME_CHR, PYCODE_CHR, WBCODE_CHR) VALUES " +
" ('" + p_strID + "' , '" + p_strModuleName + "', '" + p_strEngName + "', '" + p_strPYCode + "', '" + p_strWBCode + "')";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngFindFeeList(System.Security.Principal.IPrincipal objPri,
ref DataTable dtResult)
{
com.digitalwave.security.clsPrivilegeHandleService clsSec = new clsPrivilegeHandleService();
long lngRes = clsSec.m_lngCheckCallPrivilege(objPri, "com.digitalwave.iCare.middletier.HIS.clsOPDoctorSvc", "m_lngFindWaitDiagList");
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = @"Select a.registertypeid_chr,a.paytypeid_chr,a.regfee,a.diagfee,
b.registertypename_vchr,c.paytypename_vchr from t_opPatRegAmount a,
t_bse_registertype b,t_bse_patientpaytype c
Where a.registertypeid_chr=b.registertypeid_chr
And a.paytypeid_chr=c.paytypeid_chr";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService HRPSvc = new clsHRPTableService();
lngRes = HRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtResult);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
lngRes = -2;
}
return(lngRes);
}
public long m_lngDoUpdModuleByID(System.Security.Principal.IPrincipal p_objPrincipal, clsHISModuleDef_VO objResult)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsHISInfoDefineSvc", "m_lngDoUpdModuleByID");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDATE T_SYS_MODULE SET " +
"MODULENAME_CHR = '" + objResult.m_strModuleName + "', " +
"ENGNAME_CHR = '" + objResult.m_strEngName + "', " +
"PYCODE_CHR = '" + objResult.m_strPYCode + "', " +
"WBCODE_CHR = '" + objResult.m_strWBCode + "' " +
"WHERE MODULEID_CHR = '" + objResult.m_strModuleID + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetTextListData(System.Security.Principal.IPrincipal p_objPrincipal, string p_strSQL, out DataTable p_dtbResult)
{
p_dtbResult = new DataTable();
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc", "m_lngGetTurnInPatienList");
if (lngRes < 0)
{
return(-1);
}
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(p_strSQL, ref p_dtbResult);
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_lngFindLoginInfoList(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable dtbResult)
{
long lngRes = 0;
dtbResult = new DataTable();
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.baseInfo.clsHISInfoDefineSvc", "m_lngFindLoginInfoList");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "SELECT IDX_INT, MACNAME_VCHR, MAC_VCHR, LOGTIME_DAT, EXITTIME_DAT, T_SYS_ROLE.NAME_VCHR, FIRSTNAME_VCHR, LASTNAME_VCHR FROM T_SYS_LOG LEFT JOIN T_SYS_ROLE ON T_SYS_LOG.ROLID_CHR = T_SYS_ROLE.ROLEID_CHR LEFT JOIN T_BSE_EMPLOYEE ON T_SYS_LOG.EMPID_CHR = T_BSE_EMPLOYEE.EMPID_CHR ORDER BY IDX_INT";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetTableDba2pcpending(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable p_outDatatable)
{
long lngRes = 0;
p_outDatatable = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsKillLockSVC", "m_lngGetTableDba2pcpending");
if (lngRes < 0)//权限
{
return(-1);
}
string strSQL = @"select * from dba_2pc_pending where state not in('forced rollback','forced commit')";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_outDatatable);
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_lngDelAllLoginInfo(System.Security.Principal.IPrincipal p_objPrincipal)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.baseInfo.clsHISInfoDefineSvc", "m_lngDelAllErrorLog");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "DELETE T_SYS_LOG";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetVLocked_Object(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable p_outDatatable)
{
long lngRes = 0;
p_outDatatable = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsKillLockSVC", "m_lngGetVLocked_Object");
if (lngRes < 0)//权限
{
return(-1);
}
string strSQL = @"select * from V$LOCKED_OBJECT";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_outDatatable);
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_lngDoUpdHospitalInfo(System.Security.Principal.IPrincipal p_objPrincipal, clsHISInfoDefine_VO objResult)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsHISInfoDefineSvc", "m_lngDoUpdHospitalInfo");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDate t_bse_hospitalinfo Set " +
"HOSPITAL_NAME_CHR='" + objResult.m_strHOSPITAL_NAME_CHR + "' " +
", ADDRESS_VCHR='" + objResult.m_strADDRESS_VCHR + "' " +
", PHONE_NUMBER_CHR='" + objResult.m_strPHONE_NUMBER_CHR + "' " +
", PHONE_NUMBER2_CHR='" + objResult.m_strPHONE_NUMBER2_CHR + "' " +
", ZIP_CHR='" + objResult.m_strZIP_CHR + "' " +
", MEMO_VCHR='" + objResult.m_strMEMO_VCHR + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDelete(System.Security.Principal.IPrincipal p_objPrincipal, int p_intQCBatchSeq,
int p_intConcentrationSeq)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngDelete");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
try
{
System.Data.IDataParameter[] objODPArr =
clsPublicSvc.m_objConstructIDataParameterArr(p_intQCBatchSeq, p_intConcentrationSeq);
long lngRecEff = -1;
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(m_strDeleteSql, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
public long m_lngStstemSeting(System.Security.Principal.IPrincipal p_objPrincipal, out System.Data.DataTable p_tabReport)
{
string strSQL;
p_tabReport = new DataTable();
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReckoningReport", "m_lngStstemSeting");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
strSQL = "select setid_chr, setname_vchr, setdesc_vchr, setstatus_int, moduleid_chr from t_sys_setting order by setid_chr";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_tabReport);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
