private long m_lngAddPropertyValue(clsUnitPropertyValue_VO p_objVO) { long lngRes = 0; string strSQL = @"INSERT INTO t_aid_lis_unit_property_value(PROPERTY_ID_CHR, VLAUE_ID_CHR,VLAUE_VCHR,INUSE_FLAG_NUM) VALUES (?, ?, ?, ?)" ; try { System.Data.IDataParameter[] objDPArr = null; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(4, out objDPArr); string strNewID = null; objHRPSvc.m_lngGenerateNewID("t_aid_lis_unit_property_value", "VLAUE_ID_CHR", out strNewID); if (strNewID == null || strNewID == "") { throw new Exception("不能分配ID"); } p_objVO.m_strVALUE_ID_CHR = strNewID; objDPArr[0].Value = p_objVO.m_strPROPERTY_ID_CHR; objDPArr[1].Value = p_objVO.m_strVALUE_ID_CHR; objDPArr[2].Value = p_objVO.m_strVLAUE_VCHR; objDPArr[3].Value = p_objVO.m_intINUSE_FLAG_NUM; long lngRecEff = -1; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objDPArr); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); throw objEx; } return(lngRes); }
public long m_lngUpdate(System.Security.Principal.IPrincipal p_objPrincipal, clsLisWorkGroupVO p_objWorkGroup) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdWorkGroupSvc", "m_lngUpdate"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"UPDATE T_BSE_LIS_WORKGROUP SET WORKGROUP_NAME_VCHR=?, SUMMARY_VCHR=?, STATUS_INT=? WHERE WORKGROUP_SEQ_INT=? " ; try { System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr( p_objWorkGroup.m_strName, p_objWorkGroup.m_strSummary, (int)p_objWorkGroup.m_enmStatus, p_objWorkGroup.m_intSeq ); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr); 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_mthGetReportInfo(System.Security.Principal.IPrincipal p_objPrincipal, string str, out clsReportMain_VO[] objResult) { long lngRes = 0; objResult = null; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReportMaintenanceSvc", "m_mthGetReportInfo"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "Select * From T_AID_RPT_DEF "; 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 clsReportMain_VO[dtResult.Rows.Count]; for (int i1 = 0; i1 < objResult.Length; i1++) { objResult[i1] = new clsReportMain_VO(); objResult[i1].strReportID = dtResult.Rows[i1]["RPTID_CHR"].ToString().Trim(); objResult[i1].strReportName = dtResult.Rows[i1]["RPTNAME_CHR"].ToString().Trim(); } } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long InsertNewRow(System.Security.Principal.IPrincipal p_objPrincipal, string p_strRoleId, string p_strApllyType, string p_strOperatorId, out string p_strSeq) { long lngRes = 0; p_strSeq = GetNextSeq("SEQ_CHECKDEPT_ROLE"); clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsCheckDeptRoleSvc", "clsCheckDeptRoleSvc"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"INSERT INTO T_OPR_CHECKDEPT_ROLE (SEQ_INT, ROLEID_CHR, APPLY_TYPE_INT, LASTOPERATORID_CHR, LASTOPERATE_DAT ) VALUES (?, ?, ?, ?, Sysdate)"; try { System.Data.IDataParameter[] objLisAddItemRefArr = null; objHRPSvc.CreateDatabaseParameter(4, out objLisAddItemRefArr); //Please change the datetime and reocrdid objLisAddItemRefArr[0].Value = Convert.ToInt32(p_strSeq); objLisAddItemRefArr[1].Value = p_strRoleId; objLisAddItemRefArr[2].Value = Convert.ToInt16(p_strApllyType); objLisAddItemRefArr[3].Value = p_strOperatorId; //往表增加记录 objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRes, objLisAddItemRefArr); 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_lngGetDeviceCheckGroupList(System.Security.Principal.IPrincipal p_objPrincipal, string strDeviceId, out DataTable p_dtbDeviceCheckGroupList) { long lngRes = 0; p_dtbDeviceCheckGroupList = null; string strSQL = @"SELECT DISTINCT g.groupid_chr, g.groupname_vchr FROM t_aid_lis_check_group g, t_aid_lis_check_group_detail gd, (SELECT device_model_id_chr, check_item_id_chr FROM t_bse_lis_check_item_dev_item WHERE (check_item_id_chr, device_check_item_id_chr, device_model_id_chr, modify_dat ) IN ( SELECT check_item_id_chr, device_check_item_id_chr, device_model_id_chr, MAX (modify_dat) FROM t_bse_lis_check_item_dev_item GROUP BY check_item_id_chr, device_check_item_id_chr, device_model_id_chr)) di, t_bse_lis_device d WHERE g.groupid_chr = gd.groupid_chr AND gd.check_item_id_chr = di.check_item_id_chr AND di.device_model_id_chr = d.device_model_id_chr AND d.deviceid_chr = '" + strDeviceId + "'"; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtbDeviceCheckGroupList); objHRPSvc.Dispose(); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。 } return(lngRes); }
public long m_lngAddNewINSCOPAY(System.Security.Principal.IPrincipal p_objPrincipal, clsInsPay_VO p_objRecord, out string p_strRecordID) { long lngRes = 0; p_strRecordID = ""; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngAddNewINSCOPAY"); if (lngRes < 0) //没有使用的权限 { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); //返回一最大的计划号 lngRes = objHRPSvc.lngGenerateID(4, "COPAYID_CHR", "T_AID_INSCOPAY", out p_strRecordID); if (lngRes < 0) { return(lngRes); } string strSQL = "INSERT INTO T_AID_INSCOPAY (COPAYID_CHR,COPAYNAME_CHR,PRECENT_DEC,USERCODE_CHR,REMARK_VCHR,PLANID_CHR) VALUES ('" + p_strRecordID + "','" + p_objRecord.m_strCOPAYNAME_CHR + "','" + p_objRecord.m_dblPRECENT_DEC + "','" + p_objRecord.m_strUSERCODE_CHR + "','" + p_objRecord.m_strREMARK_VCHR + "','" + p_objRecord.m_strPLANID_CHR + "')"; string strSQL2 = "insert into t_aid_InsChargeItem (PRECENT_DEC,ITEMID_CHR,COPAYID_CHR) " + " select 100 as PRECENT_DEC, ItemID_chr,'" + p_strRecordID + "' as COPAYID_CHR from t_bse_ChargeItem "; try { lngRes = objHRPSvc.DoExcute(strSQL); lngRes = objHRPSvc.DoExcute(strSQL2); 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_lngGetCheckCategory(System.Security.Principal.IPrincipal p_objPrincipal, out clsCheckCategory_VO[] p_objResultArr) { long lngRes = 0; p_objResultArr = new clsCheckCategory_VO[0]; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAdvis2120Svc", "m_lngGetCheckCategory"); if (lngRes < 0) { return(-1); } lngRes = 0; string strSQL = @"select check_category_id_chr,check_category_desc_vchr from t_bse_lis_check_category"; 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 clsCheckCategory_VO[dtbResult.Rows.Count]; for (int i1 = 0; i1 < p_objResultArr.Length; i1++) { p_objResultArr[i1] = new clsCheckCategory_VO(); p_objResultArr[i1].m_strCheck_Category_ID = dtbResult.Rows[i1]["check_category_id_chr"].ToString().Trim(); p_objResultArr[i1].m_strCheck_Category_Name = dtbResult.Rows[i1]["check_category_desc_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_lngGetCheckItemApplGroupRelationByApplUserGroupID(System.Security.Principal.IPrincipal p_objPrincipal, string strApplUserGroupID, out DataTable dtbCheckItem) { long lngRes = 0; dtbCheckItem = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngGetCheckItemApplGroupRelationByApplUserGroupID"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT t4.* FROM t_aid_lis_appuser_group t1, t_aid_lis_appuser_group_detail t2, t_aid_lis_apply_unit_detail t3, t_bse_lis_check_item t4 WHERE t1.user_group_id_chr = t2.user_group_id_chr AND t2.apply_unit_id_chr = t3.apply_unit_id_chr AND t3.check_item_id_chr = t4.check_item_id_chr AND t1.user_group_id_chr IN ( SELECT t2.child_user_group_id_chr FROM t_aid_lis_appuser_group_relate t2 START WITH user_group_id_chr = '" + strApplUserGroupID + @"' CONNECT BY PRIOR child_user_group_id_chr = user_group_id_chr)" ; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbCheckItem); objHRPSvc.Dispose(); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_mthUpdateReportInfo(System.Security.Principal.IPrincipal p_objPrincipal, string strID, clsReportMain_VO obj_VO, bool flag) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReportMaintenanceSvc", "m_mthUpdateReportInfo"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = "update T_AID_RPT_DEF set RPTID_CHR =?,RPTNAME_CHR =? where RPTID_CHR =?"; try { System.Data.IDataParameter[] objLisAddItemRefArr = null; objHRPSvc.CreateDatabaseParameter(3, out objLisAddItemRefArr); objLisAddItemRefArr[0].Value = obj_VO.strReportID; //p_objRecord.m_strAPPID_CHR; objLisAddItemRefArr[1].Value = obj_VO.strReportName; objLisAddItemRefArr[2].Value = strID; long lngRecEff = -1; //往表增加记录 lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objLisAddItemRefArr); if (flag) { strSQL = "update T_AID_RPT_GOP_DEF set RPTID_CHR = '" + obj_VO.strReportID + "' where RPTID_CHR = '" + strID + "'"; lngRes = objHRPSvc.DoExcute(strSQL); strSQL = "update T_AID_RPT_GOP_RLA set RPTID_CHR = '" + obj_VO.strReportID + "' where RPTID_CHR = '" + strID + "'"; 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_lngFindRegChargeTypeList(System.Security.Principal.IPrincipal p_objPrincipal, out clsRegchargeType_VO[] p_objResultArr) { p_objResultArr = new clsRegchargeType_VO[0]; long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc", "m_lngFindRegChargeTypeList"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT * FROM t_bse_registerchargetype order by CHARGEID_CHR "; 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 clsRegchargeType_VO[dtbResult.Rows.Count]; for (int i1 = 0; i1 < p_objResultArr.Length; i1++) { p_objResultArr[i1] = new clsRegchargeType_VO(); p_objResultArr[i1].m_strCHARGEID_CHR = dtbResult.Rows[i1]["CHARGEID_CHR"].ToString().Trim(); p_objResultArr[i1].m_strCHARGENAME_CHR = dtbResult.Rows[i1]["CHARGENAME_CHR"].ToString().Trim(); p_objResultArr[i1].m_strMEMO_VCHR = dtbResult.Rows[i1]["MEMO_VCHR"].ToString().Trim(); p_objResultArr[i1].m_strCHARGENO_VCHR = dtbResult.Rows[i1]["CHARGENO_VCHR"].ToString().Trim(); p_objResultArr[i1].m_strISUSING_NUM = dtbResult.Rows[i1]["ISUSING_NUM"].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_lngGetStorageRack(System.Security.Principal.IPrincipal p_objPrincipal, string p_strStoreName, out DataTable m_dtbStorageRack) { m_dtbStorageRack = new DataTable(); m_dtbStorageRack.Columns.Add("storagerackid_chr"); m_dtbStorageRack.Columns.Add("storagerackname_vchr"); long lngRes = 0; //权限控制,clsPrivilegeHandleService为权限处理服务类 com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService(); lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsDrugStorageQuery_SVC", "m_lngGetStorageRack"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"select a.storagerackid_chr, a.storagerackname_vchr from t_ms_storagerackset a left join t_bse_medstore b on b.medstoreid_chr = a.storageid_chr and a.typeid_int = 2 where b.medstorename_vchr = ? order by a.storagerackid_chr"; try { IDataParameter[] objDPArr = null; objHRPSvc.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = p_strStoreName; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref m_dtbStorageRack, objDPArr); 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_lngDeleWinque(System.Security.Principal.IPrincipal p_objPrincipal, clsmedstorewinque p_objRecord) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc", "m_lngAddNew"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); if (lngRes < 0) { return(lngRes); } string strDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); string strSQL = @"delete t_opr_medstorewinque where medstoreid_chr = ? and windowid_chr = ? and outpatrecipeid_chr = ? and windowtype_int = ?"; try { System.Data.IDataParameter[] paramArr = null; objHRPSvc.CreateDatabaseParameter(4, out paramArr); paramArr[0].Value = p_objRecord.m_strMEDSTOREID_CHR; paramArr[1].Value = p_objRecord.m_strWINDOWID_CHR; paramArr[2].Value = p_objRecord.m_strOUTPATRECIPEID_CHR; paramArr[3].Value = p_objRecord.m_intWINDOWTYPE_INT; long lngRecordsAffected = -1; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordsAffected, paramArr); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long GetEmpIdByCode(System.Security.Principal.IPrincipal p_objPrincipal, string p_strEmpCode, 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 EMPID_CHR, LASTNAME_VCHR from T_BSE_EMPLOYEE where EMPNO_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(1, out arrParams); arrParams[0].Value = p_strEmpCode; 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); }
/// <summary> /// 根据处方查询是否已经发药完成 /// </summary> /// <param name="p_strRecNo">处方号</param> /// <param name="p_dtbResult"></param> /// <returns></returns> public long m_lngQuerySendMed(string p_strRecNo, out DataTable p_dtbResult) { long lngRes = -1; p_dtbResult = null; try { clsOPSelectChargeItemSvc objSvc = (com.digitalwave.iCare.middletier.HIS.clsOPSelectChargeItemSvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsOPSelectChargeItemSvc)); lngRes = objSvc.m_lngQuerySendMed(p_strRecNo, out p_dtbResult); objSvc.Dispose(); objSvc = null; } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogError("m_lngQuerySendMed连接中间件错误:" + objEx.Message); objLogger = null; } return(lngRes); }
public long m_lngDelYBInfo(string strlsh0) { long lngRes = 0; string[] strSqlList = new string[2]; strSqlList[0] = @"delete from zy_zydjb0 where zylsh0 = " + strlsh0; strSqlList[1] = @"delete from zy_yzbjb0 where zylsh0 = " + strlsh0; try { com.digitalwave.iCare.middletier.TSZZYHRPServiceYB.clsTSYBHRPService objYBSvc = new com.digitalwave.iCare.middletier.TSZZYHRPServiceYB.clsTSYBHRPService(); lngRes = objYBSvc.DoExcute(strSqlList); objYBSvc.Dispose(); } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetDeviceModelNameByDeviceID(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable dtbAllDeciveName) { long lngRes = 0; string strSQL = @"SELECT t1.deviceid_chr, t2.device_model_desc_vchr FROM t_bse_lis_device t1, t_bse_lis_device_model t2 WHERE t1.device_model_id_chr = t2.device_model_id_chr" ; dtbAllDeciveName = null; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbAllDeciveName); objHRPSvc.Dispose(); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。 } return(lngRes); }
public long m_lngQueryAllDevType(System.Security.Principal.IPrincipal p_objPrincipal, out System.Data.DataTable p_dtbDevType) { long lngRes = 0; p_dtbDevType = null; string strSQL = @"SELECT device_category_id_chr, device_category_name_vchr FROM t_bse_lis_device_category" ; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtbDevType); objHRPSvc.Dispose(); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_mthGetWindowName(out DataTable dtbResult) { dtbResult = null; long lngRes = -1; string SQL = @"select t.windowid_chr,t.windowname_vchr, t.rowid from t_bse_medstorewin t"; try { clsHRPTableService objSvc = new clsHRPTableService(); lngRes = objSvc.lngGetDataTableWithoutParameters(SQL, ref dtbResult); objSvc.Dispose(); objSvc = null; } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
/// <summary> /// 查询诊疗项目是否已经做好 /// </summary> /// <param name="p_strRecNo">处方号</param> /// <param name="p_strOrderDicId">诊疗项目id</param> /// <param name="p_intType">1-检验表 2-检查表</param> /// <param name="p_dtbResult"></param> /// <returns></returns> public long m_lngQueryDiagnosisItemStatus(string p_strRecNo, string p_strOrderDicId, int p_intType, out DataTable p_dtbResult) { long lngRes = -1; p_dtbResult = null; try { clsRecipeConfirmQuerySvc objSvc = (com.digitalwave.iCare.middletier.HIS.clsRecipeConfirmQuerySvc)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsRecipeConfirmQuerySvc)); lngRes = objSvc.m_lngQueryDiagnosisItemStatus(p_strRecNo, p_strOrderDicId, p_intType, out p_dtbResult); objSvc.Dispose(); objSvc = null; } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogError("m_lngQueryDiagnosisItemStatus连接中间件错误:" + objEx.Message); objLogger = null; } return(lngRes); }
public long m_lngGetFeeAndMedSortRel(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable p_outDtResult) { p_outDtResult = new DataTable(); 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); } p_outDtResult = new DataTable(); com.digitalwave.iCare.middletier.HRPService.clsHRPTableService obj = new clsHRPTableService(); string strSQL = @"SELECT a.*, k.itemcatid_chr,k.outmedstoreid_chr,k.inmedstoreid_chr,k.itemcatname_vchr,k.medstorename_vchr,k.medstorename_vchr1 FROM t_aid_medicinetype a LEFT JOIN (SELECT b.ITEMCATID_CHR,b.OUTMEDSTOREID_CHR,b.INMEDSTOREID_CHR, c.itemcatname_vchr, d.medstorename_vchr, f.medstorename_vchr AS medstorename_vchr1,b.medicinetypeid_chr FROM t_aid_chargemderla b, t_bse_chargeitemcat c, t_bse_medstore d, t_bse_medstore f WHERE b.itemcatid_chr = c.itemcatid_chr AND b.outmedstoreid_chr = d.medstoreid_chr(+) AND b.inmedstoreid_chr = f.medstoreid_chr(+)) k ON a.medicinetypeid_chr = k.medicinetypeid_chr "; try { lngRes = obj.lngGetDataTableWithoutParameters(strSQL, ref p_outDtResult); } catch (Exception ee) { com.digitalwave.Utility.clsLogText objLogErr = new clsLogText(); objLogErr.LogError(ee); } return(lngRes); }
public long GetICDByDeaCode(System.Security.Principal.IPrincipal p_objPrincipal, string p_strDeaCode, 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", "GetICDByDeaCode"); if (lngRes < 0) { return(-1); } string strSQL = @" SELECT T_AID_ICD10.ICDCODE_CHR, T_AID_ICD10.ICDNAME_VCHR, T_AID_ICD10.PYCODE_CHR, T_AID_ICD10.WBCODE_CHR, T_AID_ICD10.JXCODE_CHR, T_OPR_YBDEADEFICD10.DEACODE_CHR FROM T_AID_ICD10, T_OPR_YBDEADEFICD10 WHERE ( T_AID_ICD10.ICDCODE_CHR = T_OPR_YBDEADEFICD10.ICDCODE_CHR ) AND T_OPR_YBDEADEFICD10.DEACODE_CHR = '" + p_strDeaCode + "'"; 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_lngDoUpdPatientPayTypeByID(System.Security.Principal.IPrincipal p_objPrincipal, clstPatientPaytype_VO objResult) { long lngRes = 0; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngDoUpdPatientPayTypeByID"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "UPDate t_bse_patientPaytype Set " + "PAYTYPENAME_VCHR='" + objResult.m_strPAYTYPENAME_VCHR + "' " + ", MEMO_VCHR='" + objResult.m_strMEMO_VCHR + "' " + ", PAYLIMIT_MNY='" + objResult.m_strPAYLIMIT_MNY + "' " + ", PAYFLAG_DEC='" + objResult.m_strPAYFLAG_DEC + "' " + ", PAYPERCENT_DEC='" + objResult.m_strPAYPERCENT_DEC + "' " + ", PAYTYPENO_VCHR='" + objResult.m_strPAYTYPENO_VCHR + "' " + ", COPAYID_CHR='" + objResult.m_strCOPAYID_CHR + "' " + ", CHARGEPERCENT_DEC='" + objResult.m_strCHARGEPERCENT_DEC + "' " + ", COALITIONRECIPEFLAG_INT='" + objResult.m_strCOALITIONRECIPEFLAG_INT + "' " + ",INTERNALFLAG_INT=" + objResult.m_intINTERNALFLAG_INT + ",BIHLIMITRATE_DEC=" + objResult.m_strBIHLIMITRATE_DEC + " Where PAYTYPEID_CHR='" + objResult.m_strPAYTYPEID_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 m_lngGetBadChargePrepayByRegID(string RegID, out decimal PrepayTotalSum) { long lngRes = 0; string SQL = @"select sum(b.money_dec) as totalsum from t_opr_bih_charge a, t_opr_bih_prepay b where a.chargeno_chr = b.chargeno_chr and a.status_int = 1 and a.class_int = 3 and a.registerid_chr = ?"; PrepayTotalSum = 0; DataTable dt = new DataTable(); try { clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] ParamArr = null; objHRPSvc.CreateDatabaseParameter(1, out ParamArr); //((OracleParameter)ParamArr[0]).OracleDbType = OracleDbType.Char; ParamArr[0].Value = RegID; lngRes = objHRPSvc.lngGetDataTableWithParameters(SQL, ref dt, ParamArr); if (lngRes > 0 && dt.Rows.Count == 1) { if (dt.Rows[0][0].ToString().Trim() != "") { PrepayTotalSum = Convert.ToDecimal(dt.Rows[0][0].ToString()); } } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetINSCOMPANYDataArr(System.Security.Principal.IPrincipal p_objPrincipal, out clsInsCompany_VO[] p_objResultArr) { p_objResultArr = new clsInsCompany_VO[0]; long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc", "m_lngGetINSCOMPANYDataArr"); if (lngRes < 0) { return(-1); } string strSQL = @"select companyid_chr, companyname_chr, usercode_chr, remark_vchr from t_aid_inscompany order by companyid_chr"; 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 clsInsCompany_VO[dtbResult.Rows.Count]; for (int i1 = 0; i1 < p_objResultArr.Length; i1++) { p_objResultArr[i1] = new clsInsCompany_VO(); p_objResultArr[i1].m_strCOMPANYID_CHR = dtbResult.Rows[i1]["COMPANYID_CHR"].ToString().Trim(); p_objResultArr[i1].m_strCOMPANYNAME_CHR = dtbResult.Rows[i1]["COMPANYNAME_CHR"].ToString().Trim(); p_objResultArr[i1].m_strUSERCODE_CHR = dtbResult.Rows[i1]["USERCODE_CHR"].ToString().Trim(); p_objResultArr[i1].m_strREMARK_VCHR = dtbResult.Rows[i1]["REMARK_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_lngFindChargeItemCatList(System.Security.Principal.IPrincipal p_objPrincipal, out clsCharegeItemCat_VO[] objResult) { long lngRes = 0; objResult = new clsCharegeItemCat_VO[0]; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsChargeItemSvc", "m_lngDoAddNewChargeItem"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "Select itemcatid_chr sID,itemcatname_vchr sName From t_bse_chargeitemcat "; try { DataTable dtResult = new DataTable(); com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtResult); if (lngRes > 0 && dtResult.Rows.Count > 0) { objResult = new clsCharegeItemCat_VO[dtResult.Rows.Count]; for (int i1 = 0; i1 < objResult.Length; i1++) { objResult[i1] = new clsCharegeItemCat_VO(); objResult[i1].m_strItemCatID = dtResult.Rows[i1][0].ToString().Trim(); objResult[i1].m_strItemCatName = dtResult.Rows[i1][1].ToString().Trim(); } } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_mthGetInHospitalIDByCardID(string strCardID, string strEx, out DataTable dt, int Flag) { long lngRes = 0; dt = new DataTable(); string strSQL = ""; if (Flag == 1) //用卡号查询 { strSQL = @" SELECT b.registerid_chr, c.lastname_vchr, c.sex_chr, TO_CHAR (SYSDATE, 'yyyy') - TO_CHAR (c.birth_dat, 'yyyy') age FROM t_bse_patientcard a, t_opr_bih_register b, t_bse_patient c WHERE a.patientid_chr = b.patientid_chr AND a.status_int = 1 AND a.patientid_chr = c.patientid_chr(+) AND a.patientcardid_chr = '" + strCardID + "'"; } else //用住院号查询 { strSQL = @"SELECT b.registerid_chr, c.lastname_vchr, c.sex_chr, TO_CHAR (SYSDATE, 'yyyy') - TO_CHAR (c.birth_dat, 'yyyy') age FROM t_opr_bih_register b, t_bse_patient c WHERE b.patientid_chr = c.patientid_chr(+) and b.STATUS_INT =1 AND b.registerid_chr = '" + strCardID + "'"; } try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objService = new clsHRPTableService(); lngRes = objService.DoGetDataTable(strSQL, ref dt); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
// /// <summary> // /// 根据级别返回科室(intLevel=1时为一级科室) // /// </summary> // /// <param name="p_objPrincipal"></param> // /// <param name="intLevel"></param> // /// <param name="objDep"></param> // /// <returns></returns> // public long lng_getParentDep(System.Security.Principal.IPrincipal p_objPrincipal,int intLevel,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","lng_getParentDep"); // if(lngRes < 0) //没有使用的权限 // { // return -1; // } //// string strSQL="Select Distinct a.parentdeptid_chr,b.deptname_vchr From T_BSE_DEPTANDDEPT a,T_BSE_DEPTDESC b " + //// " Where a.parentdeptid_chr=b.deptid_chr(+) And b.status_int=1 And a.levels_int="+intLevel+" "; // string strSQL=@"select * from T_BSE_DEPTDESC"; // 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]["parentdeptid_chr"].ToString().Trim(); // objDep[i1].strDeptName=dtbResult.Rows[i1]["DEPTNAME_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_lngGetOPDeptForPlan(System.Security.Principal.IPrincipal p_objPrincipal, out System.Data.DataTable dt) { dt = new DataTable(); long lngRes = 0; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsOPDoctorPlanSvc", "m_lngGetOPDeptListByDate"); if (lngRes < 0) //没有使用的权限 { return(-1); } // string strSQL="Select a.OPDEPT_CHR,b.DEPTNAME_VCHR From t_opr_OPDoctorPlan a,t_bse_DeptBaseInfo b " + // " Where a.PLANDATE_DAT=to_date('"+strDate+"','yyyy-mm-dd') And a.planperiod_chr='"+strPerio+"' And " + // "a.OPDEPT_CHR=b.DEPTID_CHR(+) Group By a.OPDEPT_CHR,b.DEPTNAME_VCHR "; string strSQL = @"select * from T_BSE_DEPTDESC where INPATIENTOROUTPATIENT_INT=0"; // DateTime sDate=Convert.ToDateTime(strDate); // System.Data.IDataParameter[] objPar=clsIDataParameterCreator.s_objConstructIDataParameterArr(new object[]{sDate,strPerio}); 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) { dt = dtbResult; } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetAllApplUserGroupRelation(System.Security.Principal.IPrincipal p_objPrincipal, out clsApplUserGroupRelation_VO[] p_objResultArr) { long lngRes = 0; p_objResultArr = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngGetCheckItemInApplGroupDetailByApplUserGroupID"); if (lngRes < 0) { return(-1); } string strSQL = @"SELECT * FROM T_AID_LIS_APPUSER_GROUP_RELATE"; try { DataTable dtbResult = null; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); if (lngRes > 0 && dtbResult != null && dtbResult.Rows.Count > 0) { p_objResultArr = new clsApplUserGroupRelation_VO[dtbResult.Rows.Count]; for (int i = 0; i < p_objResultArr.Length; i++) { p_objResultArr[i] = new clsApplUserGroupRelation_VO(); p_objResultArr[i].strUserGroupID = dtbResult.Rows[i]["USER_GROUP_ID_CHR"].ToString().Trim(); p_objResultArr[i].strChildUserGroupID = dtbResult.Rows[i]["CHILD_USER_GROUP_ID_CHR"].ToString().Trim(); } } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public DataTable GetTodayRegInfo(string recipeId) { string Sql = string.Empty; DataTable dt = new DataTable(); try { Sql = @"select a.serno, a.deptcode, a.doctcode, a.subscribeno, c.lastname_vchr as patName, c.idcard_chr as idNo, c.sex_chr as sex, c.homephone_vchr as contactTel, d.patientcardid_chr as cardNo from opRegPlatformLog a inner join t_opr_outpatientrecipe b on a.recipeid = b.outpatrecipeid_chr inner join t_bse_patient c on b.patientid_chr = c.patientid_chr inner join t_bse_patientcard d on b.patientid_chr = d.patientid_chr where a.recipeid = ?"; clsHRPTableService svc = new clsHRPTableService(); IDataParameter[] parm = null; svc.CreateDatabaseParameter(1, out parm); parm[0].Value = recipeId; svc.lngGetDataTableWithParameters(Sql, ref dt, parm); svc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(dt); }
public long m_lngGetPrjBseInfo(System.Security.Principal.IPrincipal p_objPrincipal, string p_strMedSort, out System.Data.DataTable p_outdtResult) { long lngRes = 0; p_outdtResult = new System.Data.DataTable(); clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS", "m_lngGetPrjBseInfo"); if (lngRes < 0) { return(-1); } string strSQL = @"select a.ITEMID_CHR , a.ITEMNAME_VCHR ,a.ITEMPYCODE_CHR, a.ITEMENGNAME_VCHR,a.ITEMWBCODE_CHR,a.ITEMCODE_VCHR ,a.ITEMSPEC_VCHR ,c.NOQTYFLAG_INT from t_bse_chargeitem a , t_bse_chargeitemcat b , t_bse_medicine c where a.IFSTOP_INT =0 and a.ITEMSRCID_VCHR = c.medicineid_chr(+) and a.ITEMCATID_CHR = b.itemcatid_chr(+)" ; if (p_strMedSort != "") { strSQL += p_strMedSort; } strSQL += " order by a.ITEMCODE_VCHR"; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_outdtResult); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }