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