public long m_lngGetApplyUnitInfo(System.Security.Principal.IPrincipal p_objPrincipal, string[] p_strApplyUnitIDArr, out DataTable p_dtbResult) { long lngRes = 0; p_dtbResult = new DataTable(); if (p_strApplyUnitIDArr == null) { return(-1); } clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc", "m_lngGetApplyUnitInfo"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT a.apply_unit_id_chr, a.apply_unit_name_vchr, 'nullvalue' input_group_id_chr FROM t_aid_lis_apply_unit a WHERE a.apply_unit_id_chr IN ('_'*) "; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] objParamArr = null; objHRPSvc.CreateDatabaseParameter(p_strApplyUnitIDArr.Length, out objParamArr); System.Text.StringBuilder sb = new System.Text.StringBuilder(); for (int i = 0; i < p_strApplyUnitIDArr.Length; i++) { sb.Append(",?"); objParamArr[i].Value = p_strApplyUnitIDArr[i]; } strSQL = strSQL.Replace("*", sb.ToString()); try { lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtbResult, objParamArr); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。 lngRes = 0; } return(lngRes); }
public long m_lngGetDeptList(System.Security.Principal.IPrincipal p_objPrincipal, string strDepID, out clsDepartmentVO[] objDep) { objDep = new clsDepartmentVO[0]; long lngRes = 0; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsGetBase", "m_lngGetOPDoctorListByDate"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "select deptid_chr, modify_dat, deptname_vchr, category_int, inpatientoroutpatient_int, operatorid_chr, address_vchr, pycode_chr, attributeid, parentid, createdate_dat, status_int, deactivate_dat, wbcode_chr, code_vchr, extendid_vchr, shortno_chr, stdbed_count_int, putmed_int, usercode_vchr, expertdeptflag_int from t_bse_deptdesc"; if (strDepID != null) { strSQL = strSQL + " And deptid_chr='" + strDepID + "'"; } try { DataTable dtbResult = new DataTable(); com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); objHRPSvc.Dispose(); if (lngRes > 0 && dtbResult.Rows.Count > 0) { objDep = new clsDepartmentVO[dtbResult.Rows.Count]; for (int i1 = 0; i1 < objDep.Length; i1++) { objDep[i1] = new clsDepartmentVO(); objDep[i1].strDeptID = dtbResult.Rows[i1]["DEPTID_CHR"].ToString().Trim(); objDep[i1].strDeptName = dtbResult.Rows[i1]["DEPTNAME_VCHR"].ToString().Trim(); objDep[i1].strCreateDate = dtbResult.Rows[i1]["CREATEDATE_DAT"].ToString().Trim(); if (dtbResult.Rows[i1]["STATUS_INT"].ToString().Trim() != "") { objDep[i1].intStatus = int.Parse(dtbResult.Rows[i1]["STATUS_INT"].ToString().Trim()); } } } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long GetReprintByPrintEmp(System.Security.Principal.IPrincipal p_objPrincipal, string p_strEmpId, string p_strStartDate, string p_strEndDate, 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.clsPrepayCheckoutSvc", "GetReprintByPrintEmp"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT b.BILLTYPE_CHR, b.BILLID_CHR, b.SOURCEBILLNO_VCHR, b.REPPRNBILLNO_VCHR, b.PRINTEMP_CHR, b.PRINTDATE_DAT, b.PRINTSTATUS_INT, a.MONEY_DEC FROM T_OPR_BIH_PREPAY A, T_OPR_BIH_BILLREPEATPRINT B WHERE A.PREPAYID_CHR = B.BILLID_CHR AND B.BILLTYPE_CHR = '1' AND B.PRINTEMP_CHR = ? AND (B.PRINTDATE_DAT BETWEEN ? AND ? ) ORDER BY B.BILLID_CHR"; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = 0; //lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtResult); System.Data.IDataParameter[] arrParams = null; new clsHRPTableService().CreateDatabaseParameter(3, out arrParams); arrParams[0].Value = p_strEmpId; arrParams[1].Value = System.DateTime.Parse(p_strStartDate); arrParams[2].Value = System.DateTime.Parse(p_strEndDate); lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtResult, 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_lngAddReportGroup(System.Security.Principal.IPrincipal p_objPrincipal, ref clsReportGroup_VO objReportGroupVO) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsCheckGroupSvc", "m_lngAddReportGroup"); if (lngRes < 0) { return(-1); } string strSQL = @"INSERT INTO t_aid_lis_report_group (report_group_id_chr, report_group_name_vchr, py_code_chr, print_title_vchr, wb_code_chr, assist_code01_chr, assist_code02_chr, print_category_id_chr ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)" ; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); System.Data.IDataParameter[] objReportGroupArr = null; objHRPSvc.CreateDatabaseParameter(8, out objReportGroupArr); if (objReportGroupVO.strReportGroupID == null) { objReportGroupVO.strReportGroupID = objHRPSvc.m_strGetNewID("t_aid_lis_report_group", "REPORT_GROUP_ID_CHR", 6); } objReportGroupArr[0].Value = objReportGroupVO.strReportGroupID; objReportGroupArr[1].Value = objReportGroupVO.strReportGroupName; objReportGroupArr[2].Value = objReportGroupVO.strPYCode; objReportGroupArr[3].Value = objReportGroupVO.strPrintTitle; objReportGroupArr[4].Value = objReportGroupVO.strWBCode; objReportGroupArr[5].Value = objReportGroupVO.strAssistCode01; objReportGroupArr[6].Value = objReportGroupVO.strAssistCode02; objReportGroupArr[7].Value = objReportGroupVO.strPrintCategoryID; long lngRecEff = -1; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objReportGroupArr); objHRPSvc.Dispose(); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_mthGetAccordRecipeDetail(System.Security.Principal.IPrincipal p_objPrincipal, string ID, out DataTable dt) { dt = new DataTable(); long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS", "m_mthGetAccordRecipeDetail"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT a.*, b.itemname_vchr, b.itemspec_vchr, b.itemcatid_chr, b.ifstop_int, c.usagename_vchr, d.freqname_chr, e.noqtyflag_int, b.itemopinvtype_chr,CASE WHEN b.opchargeflg_int = 1 THEN ROUND (b.itemprice_mny / b.packqty_dec, 4 ) WHEN b.opchargeflg_int = 0 THEN b.itemprice_mny END AS itemprice_mny,b.ITEMCODE_VCHR,b.DOSAGEUNIT_CHR,e.MEDICINEID_CHR,b.ITEMOPUNIT_CHR,a.QTY_DEC,a.DOSETYPE_CHR FROM t_aid_concertrecipedetail a, t_bse_chargeitem b, t_bse_usagetype c, t_aid_recipefreq d, t_bse_medicine e WHERE a.itemid_chr = b.itemid_chr(+) AND a.freqid_chr = d.freqid_chr(+) AND a.dosetype_chr = c.usageid_chr(+) AND b.itemsrcid_vchr = e.medicineid_chr(+) AND a.recipeid_chr = ? order by a.sort_int"; try { clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] ParamArr = null; objHRPSvc.CreateDatabaseParameter(1, out ParamArr); //((OracleParameter)ParamArr[0]).OracleDbType = OracleDbType.Char; ParamArr[0].Value = ID; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dt, 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_lngWindowsWork(System.Security.Principal.IPrincipal p_objPrincipal, string strWindowsID, out bool isWork) { isWork = false; long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc", "m_lngWindowsWork"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); if (lngRes < 0) { return(lngRes); } string strSQL = @"SELECT a.WORKSTATUS_INT FROM t_bse_medstorewin a WHERE a.WINDOWID_CHR = '" + strWindowsID + "'"; DataTable dt = new DataTable(); try { lngRes = objHRPSvc.DoGetDataTable(strSQL, ref dt); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } if (dt.Rows.Count > 0) { try { if (int.Parse(dt.Rows[0]["WORKSTATUS_INT"].ToString()) == 1) { isWork = true; } else { isWork = false; } } catch { isWork = false; } } return(lngRes); }
public long m_lngDoModifyChargeItemUsageGroup(System.Security.Principal.IPrincipal p_objPrincipal, clsChargeItemUsageGroup_VO objResult) { long lngRes = 0; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsCmCookingMethodItemGroupSvc", "m_lngDoModifyChargeItemUsageGroup"); if (lngRes < 0) //没有使用的权限 { return(-1); } if (lngRes < 0) { return(-1); } string strSQL = "UPDate t_aid_cmcookingmethoditemgroup set " + "QTY_DEC=" + objResult.m_strUNITPRICE + ",CLINICTYPE_INT=" + objResult.m_intCLINICTYPE_INT.ToString() + ",BIHQTY_DEC=" + objResult.m_dblBIHQTY_DEC.ToString() + ",BIHTYPE_INT=" + objResult.m_intBIHTYPE_INT.ToString() + ",itemid_chr='" + objResult.m_strItemID + "',CONTINUEUSETYPE_INT=" + objResult.m_intCONTINUEUSETYPE_INT.ToString() + " Where TRIM(usageid_chr)='" + objResult.m_strUsageID.Trim() + "' and TRIM(itemid_chr)='" + objResult.m_strTOTALPRICE.Trim() + "' "; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objSvc = new clsHRPTableService(); lngRes = objSvc.DoExcute(strSQL); if (lngRes > 0) { if (objResult.m_intFlag == 1) { strSQL = "UPDate t_aid_cmcookingmethoditemgroup set " + "itemid_chr='" + objResult.m_strItemID + "' Where TRIM(usageid_chr) <>'" + objResult.m_strUsageID.Trim() + "' and TRIM(itemid_chr)='" + objResult.m_strTOTALPRICE.Trim() + "' "; lngRes = objSvc.DoExcute(strSQL); } } objSvc.Dispose(); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetVSessionByCondition(System.Security.Principal.IPrincipal p_objPrincipal, ArrayList m_objArrayList, 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_lngGetVSessionByCondition"); if (lngRes < 0)//权限 { return(-1); } StringBuilder strSQL = new StringBuilder(@"select a.sid,a.serial#,a.audsid from V$SESSION a where a.sid in([condition]) and a.username='******'"); try { string m_strTemp = string.Empty; for (int i = 0; i < m_objArrayList.Count; i++) { m_strTemp += "'" + m_objArrayList[i].ToString() + "'"; if (i <= m_objArrayList.Count - 2) { m_strTemp += ","; } } strSQL = strSQL.Replace("[condition]", m_strTemp); com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL.ToString(), ref p_outDatatable); if (lngRes > 0 && p_outDatatable.Rows.Count > 0) { strSQL = new StringBuilder(@"alter system kill session '[compression]'"); 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_lngGetMedWinByID(System.Security.Principal.IPrincipal p_objPrincipal, string p_WinID, out clsMedSendConfig_VO[] p_objResArr) { long lngRes = 0; p_objResArr = new clsMedSendConfig_VO[0]; DataTable p_dtRes = new DataTable(); clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsMedStoreBseInfoSvc", "m_lngGetMedWinByID"); if (lngRes < 0) { return(-1); } string strSQL = @" select c.seq_int,c.treatwinid_chr,c.givewinid_chr,c.order_int,d.windowname_vchr from T_OPR_MEDSTOREWINRLT c ,T_BSE_MEDSTOREWIN d where c.givewinid_chr=d.windowid_chr(+) and c.treatwinid_chr='" + p_WinID.Trim() + "' order by c.order_int"; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtRes); objHRPSvc.Dispose(); if (lngRes > 0 && p_dtRes != null) { int intRow = p_dtRes.Rows.Count; if (intRow > 0) { p_objResArr = new clsMedSendConfig_VO[intRow]; for (int i = 0; i < intRow; i++) { p_objResArr[i] = new clsMedSendConfig_VO(); p_objResArr[i].m_intSeq = Convert.ToInt32(p_dtRes.Rows[i]["seq_int"].ToString().Trim()); p_objResArr[i].m_TreatWinID_chr = p_dtRes.Rows[i]["treatwinid_chr"].ToString().Trim(); p_objResArr[i].m_GiveWinID_chr = p_dtRes.Rows[i]["givewinid_chr"].ToString().Trim(); p_objResArr[i].m_intOrder = Convert.ToInt32(p_dtRes.Rows[i]["order_int"].ToString().Trim()); p_objResArr[i].m_strGiveWinName = p_dtRes.Rows[i]["windowname_vchr"].ToString().Trim(); } } } } 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); }
public long m_lngGetMedicineTypeData(System.Security.Principal.IPrincipal p_objPrincipal, out clsValue_MedicineType_VO[] p_objData) { p_objData = new clsValue_MedicineType_VO[0]; long lngRes = 0; //权限控制,clsPrivilegeHandleService为权限处理服务类 com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService(); lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.MedicineStoreService.clsStorageRacksetSVC", "m_lngGetMedicineTypeData"); if (lngRes < 0) { return(-1); } //创建COM对象 com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"select medicinetypeid_chr,medicinetypename_vchr from t_aid_medicinetype order by medicinetypeid_chr asc"; DataTable dtbResult = new DataTable(); try { lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); if (lngRes > 0 && dtbResult != null) { p_objData = new clsValue_MedicineType_VO[dtbResult.Rows.Count]; DataRow m_drDataRow = null; clsValue_MedicineType_VO tmp_p_objData = null; for (int i1 = 0; i1 < dtbResult.Rows.Count; i1++) { tmp_p_objData = new clsValue_MedicineType_VO(); m_drDataRow = dtbResult.Rows[i1]; tmp_p_objData.m_strMedicineTypeID = m_drDataRow["medicinetypeid_chr"].ToString(); tmp_p_objData.m_strMedicineTypeName = m_drDataRow["medicinetypename_vchr"].ToString(); p_objData[i1] = tmp_p_objData; } m_drDataRow = null; } objHRPSvc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } objHRPSvc.Dispose(); return(lngRes); }
public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCSamplelotVO p_objQCSamplelot, out int p_intSeq) { long lngRes = 0; p_intSeq = -1; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngInsert"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); try { lngRes = 0; lngRes = objHRPSvc.m_lngGenerateNewID(m_strTableName, m_strPrimaryKey, out p_intSeq); if (lngRes <= 0) { return(-1); } lngRes = 0; System.Data.IDataParameter[] objODPArr = GetInsertDataParameterArr(p_objQCSamplelot, p_intSeq); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(m_strInsertSql, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); if (lngRes > 0) { p_objQCSamplelot.m_intSeq = p_intSeq;//给VO赋值ID } else { p_intSeq = -1; } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetApplUnitByCheckCategory(System.Security.Principal.IPrincipal p_objPrincipal, string p_strCheckCategory, out clsApplUnit_VO[] p_objResultArr) { long lngRes = 0; p_objResultArr = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsApplyUnitSvc", "m_lngGetAllApplUnit"); if (lngRes < 0) { return(-1); } string strSQL = @"select apply_unit_id_chr, apply_unit_name_vchr, other_name_vchr, py_code_chr, assist_code01_chr, wb_code_chr, assist_code02_chr, check_category_id_chr, is_no_food_required_chr, is_physical_exam_required_chr, is_reservation_required_chr, price_num, cost_num, sample_type_id_chr, summary_vchr, outer_check_flag_num, reporthour, SamplingInstr from t_aid_lis_apply_unit where CHECK_CATEGORY_ID_CHR = '" + p_strCheckCategory + @"' ORDER BY apply_unit_id_chr"; DataTable dtbApplUnit = null; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbApplUnit); objHRPSvc.Dispose(); if (lngRes > 0 && dtbApplUnit != null) { if (dtbApplUnit.Rows.Count > 0) { p_objResultArr = new clsApplUnit_VO[dtbApplUnit.Rows.Count]; for (int i = 0; i < dtbApplUnit.Rows.Count; i++) { p_objResultArr[i] = new clsApplUnit_VO(); ConstructApplUnitVO(dtbApplUnit.Rows[i], ref p_objResultArr[i]); } } } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngFindPatientPayTypeList(System.Security.Principal.IPrincipal p_objPrincipal, out clstPatientPaytype_VO[] p_objResultArr) { p_objResultArr = new clstPatientPaytype_VO[0]; long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc", "m_lngFindPatientPayTypeList"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT p.*,PLANNAME_CHR FROM t_bse_patientPaytype p left join T_AID_INSPLAN i on p.COPAYID_CHR =i.PLANID_CHR order by PAYTYPENO_VCHR"; try { DataTable dtbResult = new DataTable(); com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); objHRPSvc.Dispose(); if (lngRes > 0 && dtbResult.Rows.Count > 0) { p_objResultArr = new clstPatientPaytype_VO[dtbResult.Rows.Count]; for (int i1 = 0; i1 < p_objResultArr.Length; i1++) { p_objResultArr[i1] = new clstPatientPaytype_VO(); p_objResultArr[i1].m_strPAYTYPEID_CHR = dtbResult.Rows[i1]["PAYTYPEID_CHR"].ToString().Trim(); p_objResultArr[i1].m_strPAYTYPENAME_VCHR = dtbResult.Rows[i1]["PAYTYPENAME_VCHR"].ToString().Trim(); p_objResultArr[i1].m_strMEMO_VCHR = dtbResult.Rows[i1]["MEMO_VCHR"].ToString().Trim(); p_objResultArr[i1].m_strPAYLIMIT_MNY = dtbResult.Rows[i1]["PAYLIMIT_MNY"].ToString().Trim(); p_objResultArr[i1].m_strPAYFLAG_DEC = dtbResult.Rows[i1]["PAYFLAG_DEC"].ToString().Trim(); p_objResultArr[i1].m_strPAYPERCENT_DEC = dtbResult.Rows[i1]["PAYPERCENT_DEC"].ToString().Trim(); p_objResultArr[i1].m_strPAYTYPENO_VCHR = dtbResult.Rows[i1]["PAYTYPENO_VCHR"].ToString().Trim(); p_objResultArr[i1].m_strISUSING_NUM = dtbResult.Rows[i1]["ISUSING_NUM"].ToString().Trim(); p_objResultArr[i1].m_strCOPAYID_CHR = dtbResult.Rows[i1]["PLANNAME_CHR"].ToString().Trim(); p_objResultArr[i1].m_strCHARGEPERCENT_DEC = dtbResult.Rows[i1]["CHARGEPERCENT_DEC"].ToString().Trim(); p_objResultArr[i1].m_intINTERNALFLAG_INT = Convert.ToInt16(dtbResult.Rows[i1]["INTERNALFLAG_INT"].ToString().Trim()); p_objResultArr[i1].m_strCOALITIONRECIPEFLAG_INT = dtbResult.Rows[i1]["COALITIONRECIPEFLAG_INT"].ToString().Trim(); p_objResultArr[i1].m_strBIHLIMITRATE_DEC = dtbResult.Rows[i1]["BIHLIMITRATE_DEC"].ToString().Trim(); } } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngSaveFeeAndMedSortRel(System.Security.Principal.IPrincipal p_objPrincipal, DataTable p_dtRelation, DataTable p_dtDel) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS", "m_mthFindWMedicineByID"); if (lngRes < 0) { return(-1); } if (p_dtRelation == null) { return(1); } string strSQL = ""; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService obj = new clsHRPTableService(); strSQL = @" delete t_aid_chargemderla "; try { lngRes = obj.DoExcute(strSQL); } catch (Exception ee) { lngRes = -1; com.digitalwave.Utility.clsLogText objLogErr = new clsLogText(); objLogErr.LogError(ee); } for (int i = 0; i < p_dtRelation.Rows.Count; i++) { strSQL = @"insert into t_aid_chargemderla (itemcatid_chr, medicinetypeid_chr,OUTMEDSTOREID_CHR,INMEDSTOREID_CHR) values ('" + p_dtRelation.Rows[i]["itemcatid_chr"].ToString() + "', '" + p_dtRelation.Rows[i]["medicinetypeid_chr"].ToString() + "','" + p_dtRelation.Rows[i]["OUTMEDSTOREID_CHR"].ToString() + "','" + p_dtRelation.Rows[i]["INMEDSTOREID_CHR"].ToString() + "')"; try { lngRes = obj.DoExcute(strSQL); } catch (Exception ee) { lngRes = -1; com.digitalwave.Utility.clsLogText objLogErr = new clsLogText(); objLogErr.LogError(ee); } } return(lngRes); }
public long m_lngGetDictListFor(System.Security.Principal.IPrincipal p_objPrincipal, string p_strDictKind, out clsAIDDICT_VO[] p_objResultArr) { long lngRes = 0; p_objResultArr = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsDictSvc", "m_lngGetDictListFor"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT * FROM t_aid_dict WHERE trim(dictid_chr) <> '0' AND dictkind_chr = '" + p_strDictKind + "'"; try { DataTable dtbResult = new DataTable(); com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); objHRPSvc.Dispose(); if (lngRes > 0 && dtbResult.Rows.Count > 0) { p_objResultArr = new clsAIDDICT_VO[dtbResult.Rows.Count]; for (int i1 = 0; i1 < p_objResultArr.Length; i1++) { p_objResultArr[i1] = new clsAIDDICT_VO(); p_objResultArr[i1].m_strJXCODE_CHR = dtbResult.Rows[i1]["JXCODE_CHR"].ToString().Trim(); p_objResultArr[i1].m_strWBCODE_CHR = dtbResult.Rows[i1]["WBCODE_CHR"].ToString().Trim(); p_objResultArr[i1].m_strPYCODE_CHR = dtbResult.Rows[i1]["PYCODE_CHR"].ToString().Trim(); p_objResultArr[i1].m_strDICTNAME_VCHR = dtbResult.Rows[i1]["DICTNAME_VCHR"].ToString().Trim(); p_objResultArr[i1].m_strDICTID_CHR = dtbResult.Rows[i1]["DICTID_CHR"].ToString().Trim(); p_objResultArr[i1].m_strDICTKIND_CHR = dtbResult.Rows[i1]["DICTKIND_CHR"].ToString().Trim(); p_objResultArr[i1].m_strDICTSEQID_CHR = dtbResult.Rows[i1]["DICTSEQID_CHR"].ToString().Trim(); } } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetApplUnitBySampleGroupID(System.Security.Principal.IPrincipal p_objPrincipal, string p_strSampleGroupID, out clsLisSampleGroupUnit_VO[] p_objResultArr) { long lngRes = 0; p_objResultArr = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsSampleGroupSvc", "m_lngGetApplUnitBySampleGroupID"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT a.*, b.apply_unit_name_vchr FROM t_aid_lis_sample_group_unit a, t_aid_lis_apply_unit b WHERE a.apply_unit_id_chr = b.apply_unit_id_chr" ; if (p_strSampleGroupID != null && p_strSampleGroupID != "") { strSQL += @" AND a.sample_group_id_chr = '" + p_strSampleGroupID + @"'"; } try { DataTable dtbResult = new DataTable(); com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); objHRPSvc.Dispose(); if (lngRes > 0 && dtbResult != null && dtbResult.Rows.Count > 0) { p_objResultArr = new clsLisSampleGroupUnit_VO[dtbResult.Rows.Count]; for (int i = 0; i < p_objResultArr.Length; i++) { p_objResultArr[i] = new clsLisSampleGroupUnit_VO(); p_objResultArr[i].m_strAPPLY_UNIT_DESC_VCHR = dtbResult.Rows[i]["apply_unit_name_vchr"].ToString().Trim(); p_objResultArr[i].m_strAPPLY_UNIT_ID_CHR = dtbResult.Rows[i]["apply_unit_id_chr"].ToString().Trim(); p_objResultArr[i].m_strSAMPLE_GROUP_ID_CHR = dtbResult.Rows[i]["sample_group_id_chr"].ToString().Trim(); } } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetSpecialRemarkDicByCondition(System.Security.Principal.IPrincipal p_objPrincipal, string m_strConditionIndex, string m_strSearchContent, out DataTable m_objTable) { long m_lngRes = -1; m_objTable = new DataTable(); clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); m_lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.BIHOrderServer.clsSpecialRemarkDicService", "m_lngGetSpecialRemarkDicByCondition"); if (m_lngRes < 0) { return(-1); } string m_strSQL = @"SELECT A.remarkid_chr, A.remarkname_vchr, A.usercode_vchr,case when A.chargectl_int=0 then '²»ÔÊÐí' when A.chargectl_int=1 then 'ÔÊÐí' end as chargectl_status FROM t_bse_bih_specremark A "; switch (m_strConditionIndex.Trim()) { case "0": m_strSQL += " where A.remarkid_chr like'%" + m_strSearchContent.Trim() + "'order by A.remarkid_chr"; break; case "1": m_strSQL += " where A.remarkname_vchr like'%" + m_strSearchContent.Trim() + "%'order by A.remarkid_chr"; break; case "2": m_strSQL += " where A.usercode_vchr like'%" + m_strSearchContent.Trim() + "%'order by A.remarkid_chr"; break; case "3": if (m_strSearchContent.Trim() == "ÔÊÐí") { m_strSQL += "where A.chargectl_int=1 order by A.remarkid_chr"; } else if (m_strSearchContent.Trim() == "²»ÔÊÐí") { m_strSQL += "where A.chargectl_int=0 order by A.remarkid_chr"; } break; default: break; } try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService m_objHRP = new clsHRPTableService(); m_lngRes = m_objHRP.lngGetDataTableWithoutParameters(m_strSQL, ref m_objTable); } catch (Exception ex) { string strTmp = ex.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(ex); } return(m_lngRes); }
public long m_lngFindAllUsage( System.Security.Principal.IPrincipal p_objPrincipal, out clsUsageType_VO[] p_objResultArr, string strEx) { p_objResultArr = new clsUsageType_VO[0]; long lngRes = 0; //权限控制 com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService(); lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsGetBase", "m_lngFindAllUsage"); if (lngRes < 0) { return(-1); } DataTable dtbResult = new DataTable(); string strSQL = "SELECT * FROM t_bse_usagetype WHERE usercode_chr LIKE '" + strEx + "%' OR pycode_vchr LIKE '" + strEx + "%' OR wbcode_vchr LIKE '" + strEx + "%' ORDER BY scope_int, usercode_chr"; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); objHRPSvc.Dispose(); if (lngRes > 0 && dtbResult.Rows.Count > 0) { p_objResultArr = new clsUsageType_VO[dtbResult.Rows.Count]; for (int i1 = 0; i1 < p_objResultArr.Length; i1++) { p_objResultArr[i1] = new clsUsageType_VO(); p_objResultArr[i1].m_intScope = Convert.ToInt32(dtbResult.Rows[i1]["scope_int"].ToString()); p_objResultArr[i1].m_strUsageID = dtbResult.Rows[i1]["USAGEID_CHR"].ToString().Trim(); p_objResultArr[i1].m_strUsageName = dtbResult.Rows[i1]["USAGENAME_VCHR"].ToString().Trim(); p_objResultArr[i1].m_strUsageCode = dtbResult.Rows[i1]["USERCODE_CHR"].ToString().Trim(); p_objResultArr[i1].m_strUsagePYCODE = dtbResult.Rows[i1]["PYCODE_VCHR"].ToString().Trim(); p_objResultArr[i1].m_strUsageWBCODE = dtbResult.Rows[i1]["WBCODE_VCHR"].ToString().Trim(); p_objResultArr[i1].m_intPutMed = int.Parse(dtbResult.Rows[i1]["PUTMED_INT"].ToString().Trim()) == 0 ? 0 : 1; p_objResultArr[i1].m_intTest = int.Parse(dtbResult.Rows[i1]["TEST_INT"].ToString().Trim()) == 0 ? 0 : 1; p_objResultArr[i1].m_strOPUsageDesc = dtbResult.Rows[i1]["OPUSAGEDESC"].ToString(); } } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetApplyUnitVOByApplyUnitID(System.Security.Principal.IPrincipal p_objPrincipal, string p_strApplyUnitID, out clsApplUnit_VO p_objApplUnit) { long lngRes = 0; p_objApplUnit = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngGetApplyUnitVOByApplyUnitID"); if (lngRes < 0) { return(-1); } string strSQL = @"select apply_unit_id_chr, apply_unit_name_vchr, other_name_vchr, py_code_chr, assist_code01_chr, wb_code_chr, assist_code02_chr, check_category_id_chr, is_no_food_required_chr, is_physical_exam_required_chr, is_reservation_required_chr, price_num, cost_num, sample_type_id_chr, summary_vchr, outer_check_flag_num, reporthour, SamplingInstr from t_aid_lis_apply_unit where apply_unit_id_chr = ?"; try { clsHRPTableService objHRPSvc = new clsHRPTableService(); DataTable dtbResult = null; IDataParameter[] objDPArr = null; objHRPSvc.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = p_strApplyUnitID; lngRes = 0; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr); objHRPSvc.Dispose(); if (lngRes > 0 && dtbResult != null && dtbResult.Rows.Count != 0) { p_objApplUnit = new clsApplUnit_VO(); ConstructApplUnitVO(dtbResult.Rows[0], ref p_objApplUnit); } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetStatiticsData(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable p_dtbResult, string p_strPeriodId) { p_dtbResult = new DataTable(); long lngRes = 0; //权限控制 com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService(); lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsHisMedInOrderStatisticSvc", "m_lngGetStatiticsData"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL; if (p_strPeriodId != "") { strSQL = @"SELECT Ta.docid_vchr, Ta.tolmny_mny, Tb.vendorname_vchr FROM t_opr_storageord Ta, t_bse_vendor Tb, t_bse_period Tc WHERE Ta.vendorid_chr = Tb.vendorid_chr(+) AND Ta.periodid_chr = Tc.periodid_chr AND Tc.PERIODID_CHR = " ; strSQL += "'" + p_strPeriodId + "'"; strSQL += " AND Ta.pstatus_int = 2 AND Ta.sign_int = 1"; } else //选择所有时期 { strSQL = @"SELECT Ta.docid_vchr, Ta.tolmny_mny, Tb.vendorname_vchr FROM t_opr_storageord Ta, t_bse_vendor Tb, t_bse_period Tc WHERE Ta.vendorid_chr = Tb.vendorid_chr(+) AND Ta.periodid_chr = Tc.periodid_chr " ; strSQL += " AND Ta.pstatus_int = 2 AND Ta.sign_int = 1"; } try { lngRes = objHRPSvc.DoGetDataTable(strSQL, ref p_dtbResult); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } objHRPSvc.Dispose(); return(lngRes); }
public long m_lngUpdateQCReport(IPrincipal p_objPrincipal, clsLisQCReportVO QCBatch) { long num = 0L; clsPrivilegeHandleService clsPrivilegeHandleService = new clsPrivilegeHandleService(); num = clsPrivilegeHandleService.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsQCBusiness_Serv", "m_lngUpdateQCReport"); long result; if (num <= 0L) { result = -1L; } else { clsHRPTableService svc = new clsHRPTableService(); try { IDataParameter[] updateDataParameterArr = this.GetUpdateDataParameterArr(QCBatch); long num2 = -1L; num = 0L; string Sql = @"update t_opr_lis_qcreport set qcbatch_seq_int = ?, qcstatus_int = ?, unmatchedrule_vchr = ?, reason_vchr = ?, process_vchr = ?, summary_vchr = ?, report_dat = ?, reportor_id_chr = ?, status_int = ?, modify_dat = ?, report_stats_int = ? where qcreport_seq_int = ? "; num = svc.lngExecuteParameterSQL(Sql, ref num2, updateDataParameterArr); } catch (Exception objEx) { new clsLogText().LogError(objEx); } finally { svc.Dispose(); } result = num; } return(result); }
public long m_mthFindCMRecipeDetail(System.Security.Principal.IPrincipal p_objPrincipal, string ID, out DataTable dt) { dt = new DataTable(); long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS", "m_mthFindCMRecipeDetail"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT a.itemid_chr, a.qty_dec,a.DOSAGEQTY_DEC,a.DOSETYPE_CHR, b.itemname_vchr, b.itemspec_vchr, b.dosageunit_chr, ROUND (b.itemprice_mny / b.packqty_dec, 4) submoney,b.itemengname_vchr, b.packqty_dec, b.itemprice_mny,b.opchargeflg_int,b.dosage_dec, b.insuranceid_chr, b.ITEMOPINVTYPE_CHR,d.usagename_vchr,b.ITEMCODE_VCHR,a.ROWNO_CHR, m.deptprep_int FROM t_aid_concertrecipedetail a, t_bse_chargeitem b, T_BSE_CHARGECATMAP e, T_BSE_USAGETYPE d, t_bse_medicine m WHERE a.itemid_chr = b.itemid_chr(+) AND b.ITEMOPINVTYPE_CHR =e.catid_chr(+) and a.dosetype_chr=d.usageid_chr(+) and e.groupid_chr='0002' and e.INTERNALFLAG_INT=0 and b.ITEMSRCID_VCHR = m.MEDICINEID_CHR(+) AND recipeid_chr = ? order by a.sort_int"; try { clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] ParamArr = null; objHRPSvc.CreateDatabaseParameter(1, out ParamArr); //((OracleParameter)ParamArr[0]).OracleDbType = OracleDbType.Char; ParamArr[0].Value = ID; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dt, 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 GetCheckoutPrepayHis(System.Security.Principal.IPrincipal p_objPrincipal, string p_strOperatorId, string p_strStartDate, string p_strEndDate, 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", "GetCheckoutPrepayHis"); if (lngRes < 0) { return(-1); } string strSQL = @" select BALANCEID_VCHR, BALANCEEMP_CHR, BALANCE_DAT, REMARK_VCHR from T_OPR_BIH_PREPAYBALANCE where BALANCEEMP_CHR = ? and (BALANCE_DAT between ? and ? ) ORDER BY BALANCE_DAT"; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = 0; //lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtResult); System.Data.IDataParameter[] arrParams = null; new clsHRPTableService().CreateDatabaseParameter(3, out arrParams); arrParams[0].Value = p_strOperatorId; arrParams[1].Value = System.DateTime.Parse(p_strStartDate); arrParams[2].Value = System.DateTime.Parse(p_strEndDate); lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtResult, 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_lngMeditionProtectReport(System.Security.Principal.IPrincipal p_objPrincipal, string finddate, string finddateLast, 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_lngMeditionProtectReport"); if (lngRes < 0) //没有使用的权限 { return(-1); } // strSQL=@"SELECT t1.invoiceno_vchr, t1.invdate_dat, t1.balance_dat, t1.TOTALSUM_MNY as TOTALSUM_MNY, //t2.idcard_chr as PATIENTID_CHR, t1.patientname_chr // FROM t_opr_outpatientrecipeinv t1, t_bse_patient t2,t_bse_patientPaytype t3 // WHERE t1.patientid_chr = t2.patientid_chr(+) // and t1.paytypeid_chr=t3.paytypeid_chr(+) // and t3.internalflag_int = 2 //and t1.BALANCE_DAT is not null //AND t1.invdate_dat BETWEEN TO_DATE('"+finddate+"','yyyy-mm-dd hh24:mi:ss') "+ // " AND TO_DATE('"+finddateLast+" 23:59:59','yyyy-mm-dd hh24:mi:ss')"; strSQL = @"SELECT t1.invoiceno_vchr, t1.invdate_dat, t1.balance_dat, t1.TOTALSUM_MNY as TOTALSUM_MNY, t2.idcard_chr as PATIENTID_CHR, t1.patientname_chr FROM t_opr_outpatientrecipeinv t1, t_bse_patient t2 WHERE t1.patientid_chr = t2.patientid_chr(+) AND t1.PAYTYPE_INT=3 and (t1.status_int = 1 or t1.status_int = 3) and t1.BALANCE_DAT is not null AND t1.invdate_dat BETWEEN TO_DATE('" + finddate + "','yyyy-mm-dd hh24:mi:ss') " + " AND TO_DATE('" + finddateLast + " 23:59:59','yyyy-mm-dd hh24:mi:ss') order by t1.invdate_dat"; 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); }
public long m_lngFindAllUsageSet( System.Security.Principal.IPrincipal p_objPrincipal, out clsUsageType_VO[] p_objResultArr) { p_objResultArr = new clsUsageType_VO[0]; long lngRes = 0; //权限控制 com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService(); lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsGetBase", "m_lngFindAllUsageSet"); if (lngRes < 0) { return(-1); } DataTable dtbResult = new DataTable(); string strSQL = "SELECT distinct t1.usageid_chr, t2.usercode_chr, t2.usagename_vchr, t1.type_int " + " FROM t_opr_setusage t1, t_bse_usagetype t2 " + "where t1.usageid_chr=t2.usageid_chr " + "ORDER BY t1.usageid_chr "; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); objHRPSvc.Dispose(); if (lngRes > 0 && dtbResult.Rows.Count > 0) { p_objResultArr = new clsUsageType_VO[dtbResult.Rows.Count]; for (int i1 = 0; i1 < p_objResultArr.Length; i1++) { p_objResultArr[i1] = new clsUsageType_VO(); p_objResultArr[i1].m_strUsageID = dtbResult.Rows[i1]["USAGEID_CHR"].ToString().Trim(); p_objResultArr[i1].m_strUsageName = dtbResult.Rows[i1]["USAGENAME_VCHR"].ToString().Trim(); p_objResultArr[i1].m_strUsageCode = dtbResult.Rows[i1]["USERCODE_CHR"].ToString().Trim(); p_objResultArr[i1].m_strUsageType = dtbResult.Rows[i1]["type_int"].ToString().Trim(); // p_objResultArr[i1].m_strorderid = dtbResult.Rows[i1]["orderid_vchr"].ToString().Trim(); } } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetAllSampleGroupDetail(System.Security.Principal.IPrincipal p_objPrincipal, out clsSampleGroupDetail_VO[] objSampleGroupDetailVOList) { long lngRes = 0; objSampleGroupDetailVOList = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsSampleGroupSvc", "m_lngGetAllSampleGroupDetail"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT t1.sample_group_id_chr, t2.check_item_id_chr, t2.print_seq_int FROM t_aid_lis_sample_group_unit t1, t_aid_lis_apply_unit_detail t2 WHERE t1.apply_unit_id_chr = t2.apply_unit_id_chr ORDER BY sample_group_id_chr, print_seq_int" ; DataTable dtbSampleGroupDetail = null; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbSampleGroupDetail); objHRPSvc.Dispose(); if (lngRes > 0 && dtbSampleGroupDetail != null) { if (dtbSampleGroupDetail.Rows.Count > 0) { if (dtbSampleGroupDetail.Rows.Count > 0) { objSampleGroupDetailVOList = new clsSampleGroupDetail_VO[dtbSampleGroupDetail.Rows.Count]; for (int i = 0; i < dtbSampleGroupDetail.Rows.Count; i++) { objSampleGroupDetailVOList[i] = new clsSampleGroupDetail_VO(); ConstructSampleGroupDetailVO(dtbSampleGroupDetail.Rows[i], ref objSampleGroupDetailVOList[i]); } } } } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。 } 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_lngSaveAll(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCDataVO[] p_objInsertArr, clsLisQCDataVO[] p_objUpdateArr, int[] p_intDelArr, out int[] p_intISeqArr) { p_intISeqArr = null; long lngRes = 0; com.digitalwave.security.clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngSaveAll"); objPrivilege = null; if (lngRes <= 0) { return(lngRes); } if (p_objUpdateArr != null && p_objUpdateArr.Length > 0) { lngRes = m_lngUpdateByArr(p_objPrincipal, p_objUpdateArr); if (lngRes <= 0) { ContextUtil.SetAbort(); } } if (p_objInsertArr != null && p_objInsertArr.Length > 0) { lngRes = m_lngInsertByArr(p_objPrincipal, p_objInsertArr, out p_intISeqArr); if (lngRes <= 0) { p_intISeqArr = null; ContextUtil.SetAbort(); } } if (p_intDelArr != null && p_intDelArr.Length > 0) { lngRes = m_lngDeleteByArr(p_objPrincipal, p_intDelArr); if (lngRes <= 0) { ContextUtil.SetAbort(); } } p_intDelArr = null; p_objInsertArr = null; p_objUpdateArr = null; return(lngRes); }
public long m_mthGetGroupByID(System.Security.Principal.IPrincipal p_objPrincipal, string strID, out clsReportDetail_VO[] objResult) { long lngRes = 0; objResult = null; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReportMaintenanceSvc", "m_mthGetGroupByID"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "Select * From T_AID_RPT_GOP_DEF "; if (strID.Trim() != "") { strSQL += " where RPTID_CHR = '" + strID + "'"; } try { DataTable dtResult = new DataTable(); com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtResult); objHRPSvc.Dispose(); if (lngRes > 0 && dtResult.Rows.Count > 0) { objResult = new clsReportDetail_VO[dtResult.Rows.Count]; for (int i1 = 0; i1 < objResult.Length; i1++) { objResult[i1] = new clsReportDetail_VO(); objResult[i1].strReportID = dtResult.Rows[i1]["RPTID_CHR"].ToString().Trim(); objResult[i1].strGroupID = dtResult.Rows[i1]["GROUPID_CHR"].ToString().Trim(); objResult[i1].strGroupName = dtResult.Rows[i1]["GROUPNAME_CHR"].ToString().Trim(); } } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }