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_lngDoUpdRegTypeByID(System.Security.Principal.IPrincipal p_objPrincipal, clsRegType_VO objResult) { long lngRes = 0; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegTypeSvc", "m_lngDoUpdRegTypeByID"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "UPDATE T_BSE_REGISTERTYPE SET " + "REGISTERTYPENAME_VCHR = '" + objResult.m_strRegTypeName + "', " + "MEMO_VCHR = '" + objResult.m_strRegTypeMemo + "', " + "REGISTERTYPENO_VCHR = '" + objResult.m_strRegTypeNo + "', " + "ISDOCTOR_NUM = '" + objResult.m_strIsDoctor + "' ," + "URGENCY_INT = '" + objResult.m_strIsUrgency + "' " + //xigui.peng 添加 "WHERE REGISTERTYPEID_CHR = '" + objResult.m_strRegTypeID + "' "; 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_lngDoUpdMethodByID(System.Security.Principal.IPrincipal p_objPrincipal, clsCookMethod_VO objResult) { long lngRes = 0; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegTypeSvc", "m_lngDoUpdMethodByID"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "UPDATE T_AID_CMCOOKINGMETHOD SET " + "COOKINGMETHODNAME_VCHR = '" + objResult.m_strCookMethodName + "', " + "MNEMONIC_CHR = '" + objResult.m_strMNemonic + "' " + "WHERE COOKINGMETHODID_CHR = '" + objResult.m_strCookMethodID + "' "; 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_lngUpdateDeviceResult(clsDeviceReslutVO[] arrDeviceResult) //{ //} public long m_lngUpdateDeviceResult(clsDeviceReslutVO deviceResult) { long lngRes = 0; string sql = @" update t_opr_lis_result set RESULT_VCHR=?,DEVICE_CHECK_ITEM_NAME_VCHR=?,UNIT_VCHR=?,DEVICE_SAMPLEID_CHR=? where IDX_INT=? "; System.Data.IDataParameter[] updateParameters = clsPublicSvc.m_objConstructIDataParameterArr ( deviceResult.m_strResult, deviceResult.m_strDeviceCheckItemName, deviceResult.m_strUnit, deviceResult.m_strDeviceSampleID, deviceResult.m_strIdx ); clsHRPTableService objHRPSvc = new clsHRPTableService(); try { System.Data.IDataParameter[] objODPArr = updateParameters; long lngRecEff = -1; lngRes = objHRPSvc.lngExecuteParameterSQL(sql, ref lngRecEff, updateParameters); objHRPSvc.Dispose(); } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
public long m_mthAddNewReportInfo2(System.Security.Principal.IPrincipal p_objPrincipal, clsReportDetail_VO obj_VO) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReportMaintenanceSvc", "m_mthAddNewReportInfo2"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = "INSERT INTO T_AID_RPT_GOP_DEF (RPTID_CHR,GROUPID_CHR,GROUPNAME_CHR) VALUES (?,?,?)"; 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.strGroupID; objLisAddItemRefArr[2].Value = obj_VO.strGroupName; long lngRecEff = -1; //往表增加记录 lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objLisAddItemRefArr); objHRPSvc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
private long m_lngAddNewAppUnitItem(clsLisAppUnitItemVO unitItemRelation) { long lngRes = 0; long lngReff = 0; #region == SQL == string sql = @"insert into t_opr_lis_app_unit_item ( application_id_chr, check_item_id_chr, apply_unit_id_chr ) values ( ?, ?, ?) "; #endregion clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] arrParams = null; objHRPSvc.CreateDatabaseParameter(3, out arrParams); try { arrParams[0].Value = unitItemRelation.m_strAPPLICATION_ID_CHR; arrParams[1].Value = unitItemRelation.m_strCHECK_ITEM_ID_CHR; arrParams[2].Value = unitItemRelation.m_strAPPLY_UNIT_ID_CHR; //往表增加记录 lngRes = objHRPSvc.lngExecuteParameterSQL(sql, ref lngReff, arrParams); objHRPSvc.Dispose(); } catch (Exception objEx) { new clsLogText().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, 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_intSeq); long lngRecEff = -1; lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(m_strDeleteSql, 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_lngFind(string applicationId, out clsChargeStatusVO chargeStatusVO) { long lngRes = 0; DataTable dt = null; chargeStatusVO = null; string strSQL = @"select * from t_opr_attachrelation where attachid_vchr=? "; try { clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPSvc.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = applicationId; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dt, objDPArr); if (lngRes > 0 && dt != null && dt.Rows.Count != 0) { chargeStatusVO = ConstructVO(dt.Rows[0]); } objHRPSvc.Dispose(); } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq, out clsLisQCDataVO p_objQCData) { long lngRes = 0; p_objQCData = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdQCBatchConcentrationSvc", "m_lngFind"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); try { System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(p_intSeq); DataTable dtbResult = null; lngRes = 0; lngRes = objHRPSvc.lngGetDataTableWithParameters(m_strFindSql, ref dtbResult, objODPArr); objHRPSvc.Dispose(); if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0) { p_objQCData = new clsLisQCDataVO(); this.ConstructVO(dtbResult.Rows[0], ref p_objQCData); } } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
public long m_lngDeleteMultiUnit(clsMultiunit_drug_VO p_objVO) { string strSQL = @"delete from t_bse_itemmultiunit_drug a where a.itemid_chr = ? and a.unit_vchr= ? and a.package_dec= ?"; long lngRes = -1; long lngAffter = -1; //DataTable dtbValue = new DataTable(); try { clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] ParamArr = null; objHRPSvc.CreateDatabaseParameter(3, out ParamArr); ParamArr[0].Value = p_objVO.m_strItemId; ParamArr[1].Value = p_objVO.m_strUnit; ParamArr[2].DbType = DbType.Int16; ParamArr[2].Value = p_objVO.m_intPackage; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngAffter, ParamArr); //lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbValue, 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_lngAddMultiUnit(clsMultiunit_drug_VO p_objVO) { string strSQL = @"insert into t_bse_itemmultiunit_drug a (a.itemid_chr, a.unit_vchr, a.package_dec, a.curruseflag_int, status_int ) values (?, ?, ?, ?, ? ) "; long lngRes = -1; long recordAffect = 0; try { clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] ParamArr = null; objHRPSvc.CreateDatabaseParameter(5, out ParamArr); ParamArr[0].Value = p_objVO.m_strItemId.Trim(); ParamArr[1].Value = p_objVO.m_strUnit.Trim(); ParamArr[2].DbType = DbType.Int16; ParamArr[2].Value = p_objVO.m_intPackage; ParamArr[3].DbType = DbType.Int16; ParamArr[3].Value = p_objVO.m_intCurruseFlag_Int; ParamArr[4].Value = p_objVO.m_intStauts; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref recordAffect, 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_lngSetAllCurruseFlag_0ByItemId(string p_strMedicineId) { long lngRes = -1; string strSQL = @"update t_bse_itemmultiunit_drug set curruseflag_int=0 where itemid_chr=?"; long lngAffect = -1; try { clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] ParamArr = null; objHRPSvc.CreateDatabaseParameter(1, out ParamArr); ParamArr[0].Value = p_strMedicineId; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngAffect, 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_mthSearchDept(string strStoreid, out DataTable dtDept) { dtDept = new DataTable(); long lngRes = 0; StringBuilder strSQL = new StringBuilder(""); try { strSQL.Append(@"select a.instoragedept_chr deptid_chr from t_aid_outindeptrelation a where a.outstoragedept_chr=?"); clsHRPTableService objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPServ.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = strStoreid; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL.ToString(), ref dtDept, objDPArr); objHRPServ.Dispose(); objHRPServ = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_mthGetStoreName(bool p_blnIsDrugStore, out DataTable p_dtbStoreName) { p_dtbStoreName = new DataTable(); long lngRes = 0; StringBuilder strSQL = new StringBuilder(""); try { if (p_blnIsDrugStore) { strSQL.Append(@"select t.deptid_chr,t.medstorename_vchr from t_bse_medstore t"); } else { strSQL.Append(@"select distinct t.deptid_chr,t.medicineroomname medstorename_vchr from t_ms_medicinestoreroomset t"); } clsHRPTableService objHRPServ = new clsHRPTableService(); lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL.ToString(), ref p_dtbStoreName); objHRPServ.Dispose(); objHRPServ = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngModifyINSCOPAY(System.Security.Principal.IPrincipal p_objPrincipal, clsInsPay_VO objResult) { long lngRes = 0; //权限类 clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); //检查是否有使用些函数的权限 lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngModifyINSCOPAY"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "UPDate T_AID_INSCOPAY Set " + "COPAYNAME_CHR='" + objResult.m_strCOPAYNAME_CHR + "' " + ", PRECENT_DEC='" + objResult.m_dblPRECENT_DEC + "' " + ", USERCODE_CHR='" + objResult.m_strUSERCODE_CHR + "' " + ", REMARK_VCHR='" + objResult.m_strREMARK_VCHR + "' " + ", PLANID_CHR='" + objResult.m_strPLANID_CHR + "' " + " Where COPAYID_CHR='" + objResult.m_strCOPAYID_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_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, out clsLisQCDataVO[] p_objResultArr) { long lngRes = 0; p_objResultArr = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngFind"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); try { DataTable dtbResult = null; lngRes = 0; lngRes = objHRPSvc.lngGetDataTableWithoutParameters(m_strFindAllSql, ref dtbResult); objHRPSvc.Dispose(); if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0) { p_objResultArr = ConstructVOArr(dtbResult); } } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
public long m_lngDelINSCOPAY(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_lngDelINSCOPAY"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "Delete T_AID_INSCOPAY " + " Where COPAYID_CHR='" + strID + "' "; string strSQL2 = "Delete t_aid_InsChargeItem " + " Where COPAYID_CHR='" + strID + "' "; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.DoExcute(strSQL); if (lngRes > 0) { lngRes = objHRPSvc.DoExcute(strSQL2); } objHRPSvc.Dispose(); } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngComputationByScope(string p_strScope, out DataTable p_dtResultTable) { long lngRes = -1; p_dtResultTable = new DataTable(); string strSQL = @"select t.scope_chr, t.catid_chr, t.catname_vchr, t.type_int, t.compexp_vchr, t.dispctl_vchr, t.prtclt_vchr, t.status_int from t_bse_defchargecat t where t.scope_chr = ?"; clsHRPTableService objHRPSvc = new clsHRPTableService(); IDataParameter[] ParamArr = null; objHRPSvc.CreateDatabaseParameter(1, out ParamArr); ParamArr[0].Value = p_strScope; try { lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtResultTable, 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_mthGetAllMedStore(out DataTable m_objTable) { long lngRes = -1; m_objTable = new DataTable(); string strSql = @"select t.medstoreid_chr, t.medstorename_vchr, t.deptid_chr, t.medstoretype_int, t.medicnetype_int, t.urgence_int from t_bse_medstore t"; try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSql, ref m_objTable); objHRPSvc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngUpdate(System.Security.Principal.IPrincipal p_objPrincipal, clsLisConcentrationVO QCBatch) { 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(QCBatch); 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_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq, out clsLisQCSamplelotVO p_objQCSamplelot) { long lngRes = 0; p_objQCSamplelot = null; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngFind"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); try { System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(p_intSeq); DataTable dtbResult = null; lngRes = 0; lngRes = objHRPSvc.lngGetDataTableWithParameters(m_strFindSql, ref dtbResult, objODPArr); objHRPSvc.Dispose(); if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0) { p_objQCSamplelot = new clsLisQCSamplelotVO(); this.ConstructVO(dtbResult.Rows[0], ref p_objQCSamplelot); } } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetAdjustmentSeriesid(System.Security.Principal.IPrincipal p_objPrincipal, long m_lngMainSeq, out long m_lngDSMainSeq) { DataTable p_dtbValue = null; long lngRes = 0; m_lngDSMainSeq = 0; try { string strSQL = @"select a.seriesid_int from t_ds_adjustprice a where a.msseriesid_int=?"; clsHRPTableService objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPServ.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = m_lngMainSeq; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref p_dtbValue, objDPArr); objHRPServ.Dispose(); objHRPServ = null; if (lngRes > 0 && p_dtbValue.Rows.Count > 0) { m_lngDSMainSeq = Convert.ToInt64(p_dtbValue.Rows[0]["seriesid_int"]); } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(lngRes); }
public long m_lngGetAccountPeriod(System.Security.Principal.IPrincipal p_objPrincipal, string m_strDrugStoreid, out DataTable p_dtbAccountData) { p_dtbAccountData = null; long lngRes = 0; try { string strSQL = @"select t.accountid_chr, t.starttime_dat, t.endtime_dat, t.transfertime_dat, t.comment_vchr, t.drugstoreid_chr, t.seriesid_int from t_ds_accountperiod t where t.drugstoreid_chr = ? order by t.accountid_chr"; clsHRPTableService objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPServ.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = m_strDrugStoreid; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref p_dtbAccountData, objDPArr); objHRPServ.Dispose(); objHRPServ = null; } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.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.clsTmdCheckMethodSvc", "m_lngDelete"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"DELETE T_BSE_LIS_CHECKMETHOD WHERE METHOD_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_mthDeleteReportByID2(System.Security.Principal.IPrincipal p_objPrincipal, string strID, string strReportID) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReportMaintenanceSvc", "m_mthDeleteReportByID2"); if (lngRes < 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = "delete T_AID_RPT_GOP_DEF where GROUPID_CHR ='" + strID + "' and RPTID_CHR ='" + strReportID + "'"; try { lngRes = objHRPSvc.DoExcute(strSQL); strSQL = "delete T_AID_RPT_GOP_RLA where RPTID_CHR ='" + strReportID + "' and GROUPID_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_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisCheckMethodVO p_objCheckMethod, out int p_intSeq) { long lngRes = 0; p_intSeq = -1; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdCheckMethodSvc", "m_lngInsert"); if (lngRes <= 0) { return(-1); } com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); string strSQL = @"INSERT INTO T_BSE_LIS_CHECKMETHOD( METHOD_SEQ_INT, CHECKMETHOD_NAME_VCHR, PYCODE_VCHR, WBCODE_VCHR ) VALUES ( ?, ? ,? ,?)"; try { lngRes = 0; lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_CHECKMETHOD", "METHOD_SEQ_INT", out p_intSeq); if (lngRes <= 0) { return(-1); } lngRes = 0; System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr( p_intSeq, p_objCheckMethod.m_strName, p_objCheckMethod.m_strPycode, p_objCheckMethod.m_strWbcode ); long lngRecEff = -1; //往表增加记录 lngRes = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr); objHRPSvc.Dispose(); if (lngRes > 0) { p_objCheckMethod.m_intSeq = p_intSeq;//给VO赋值ID } else { p_intSeq = -1; } } catch (Exception objEx) { new clsLogText().LogError(objEx); } return(lngRes); }
public long m_lngIsUseing(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_lngIsUseing"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "UPDATE T_BSE_REGISTERTYPE SET " + "ISUSING_NUM = '" + p_strIsUseing + "' " + "WHERE REGISTERTYPEID_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 DateTime m_dtmGetServerDate() { long lngRes = 0; System.DateTime datResult = System.DateTime.Now; string strSQL = @"SELECT sysdate FROM dual" ; System.Data.DataTable dtbResult = new System.Data.DataTable(); try { com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult); if (lngRes > 0 && dtbResult != null) { datResult = System.DateTime.Parse(dtbResult.Rows[0]["sysdate"].ToString()); } objHRPSvc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } return(datResult); }
public long m_lngDelMethodByID(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.clsRegTypeSvc", "m_lngDelMethodByID"); if (lngRes < 0) //没有使用的权限 { return(-1); } string strSQL = "DELETE T_AID_CMCOOKINGMETHOD " + "WHERE COOKINGMETHODID_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_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); }