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); }