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_mthDelectYBSpecialTypeDiseaseByDiseaseCode(System.Security.Principal.IPrincipal p_objPrincipal, string m_strDiseCode)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsYBSpecialTypeDisease_SVC", "m_mthDelectYBSpecialTypeDiseaseByDiseaseCode");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"delete from T_OPR_YBSPECIALTYPEDISEASE A where A.deacode_chr='" + m_strDiseCode + "'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
if (lngRes > 0)
{
//删除该疾病代码对应的icd码记录
strSQL = @"delete from t_opr_ybdeadeficd10 A where A.deacode_chr='" + m_strDiseCode + "'";
lngRes = objHRPSvc.DoExcute(strSQL);
//删除该疾病代码对应的收费项目记录
strSQL = @"delete from t_opr_ybdeadefchargeitem A where A.deacode_chr='" + m_strDiseCode + "'";
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_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_lngDoModifyChargeItemUsageGroup(System.Security.Principal.IPrincipal p_objPrincipal, clsChargeItemUsageGroup_VO objResult)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsCmCookingMethodItemGroupSvc", "m_lngDoModifyChargeItemUsageGroup");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
if (lngRes < 0)
{
return(-1);
}
string strSQL = "UPDate t_aid_cmcookingmethoditemgroup set "
+ "QTY_DEC=" + objResult.m_strUNITPRICE
+ ",CLINICTYPE_INT=" + objResult.m_intCLINICTYPE_INT.ToString()
+ ",BIHQTY_DEC=" + objResult.m_dblBIHQTY_DEC.ToString()
+ ",BIHTYPE_INT=" + objResult.m_intBIHTYPE_INT.ToString()
+ ",itemid_chr='" + objResult.m_strItemID
+ "',CONTINUEUSETYPE_INT=" + objResult.m_intCONTINUEUSETYPE_INT.ToString()
+ " Where TRIM(usageid_chr)='" + objResult.m_strUsageID.Trim() + "' and TRIM(itemid_chr)='" + objResult.m_strTOTALPRICE.Trim() + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objSvc = new clsHRPTableService();
lngRes = objSvc.DoExcute(strSQL);
if (lngRes > 0)
{
if (objResult.m_intFlag == 1)
{
strSQL = "UPDate t_aid_cmcookingmethoditemgroup set "
+ "itemid_chr='" + objResult.m_strItemID
+ "' Where TRIM(usageid_chr) <>'" + objResult.m_strUsageID.Trim() + "' and TRIM(itemid_chr)='" + objResult.m_strTOTALPRICE.Trim() + "' ";
lngRes = objSvc.DoExcute(strSQL);
}
}
objSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngSaveFeeAndMedSortRel(System.Security.Principal.IPrincipal p_objPrincipal, DataTable p_dtRelation, DataTable p_dtDel)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS", "m_mthFindWMedicineByID");
if (lngRes < 0)
{
return(-1);
}
if (p_dtRelation == null)
{
return(1);
}
string strSQL = "";
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService obj = new clsHRPTableService();
strSQL = @" delete t_aid_chargemderla ";
try
{
lngRes = obj.DoExcute(strSQL);
}
catch (Exception ee)
{
lngRes = -1;
com.digitalwave.Utility.clsLogText objLogErr = new clsLogText();
objLogErr.LogError(ee);
}
for (int i = 0; i < p_dtRelation.Rows.Count; i++)
{
strSQL = @"insert into t_aid_chargemderla
(itemcatid_chr, medicinetypeid_chr,OUTMEDSTOREID_CHR,INMEDSTOREID_CHR)
values
('" + p_dtRelation.Rows[i]["itemcatid_chr"].ToString() + "', '" + p_dtRelation.Rows[i]["medicinetypeid_chr"].ToString() + "','" + p_dtRelation.Rows[i]["OUTMEDSTOREID_CHR"].ToString() + "','" + p_dtRelation.Rows[i]["INMEDSTOREID_CHR"].ToString() + "')";
try
{
lngRes = obj.DoExcute(strSQL);
}
catch (Exception ee)
{
lngRes = -1;
com.digitalwave.Utility.clsLogText objLogErr = new clsLogText();
objLogErr.LogError(ee);
}
}
return(lngRes);
}
public long m_lngKillSessionByID(System.Security.Principal.IPrincipal p_objPrincipal, DataTable p_outDatatable)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsKillLockSVC", "m_lngKillSessionByID");
if (lngRes < 0)//权限
{
return(-1);
}
StringBuilder strSQL = new StringBuilder(@"alter system kill session '[compression]'");
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string m_strTemp;
for (int i = 0; i < p_outDatatable.Rows.Count; i++)
{
m_strTemp = string.Empty;
m_strTemp = p_outDatatable.Rows[i]["sid"].ToString() + "," + p_outDatatable.Rows[i]["SERIAL#"].ToString();
strSQL = strSQL.Replace("[compression]", m_strTemp);
objHRPSvc.DoExcute(strSQL.ToString());
strSQL = new StringBuilder(@"alter system kill session '[compression]'");
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngUpBALANCEFLAG(System.Security.Principal.IPrincipal p_objPrincipal, string p_strName, string finddate)
{
long lngRes = 1;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReckoningReport", "m_lngUpBALANCEFLAG");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDATE t_opr_outpatientrecipeinv SET balanceflag_int = 1 " +
"WHERE balanceflag_int = 0 and INVDATE_DAT like to_date('" + finddate + "','yyyy-MM-dd') and OPREMP_CHR = '" + p_strName.Trim() + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDelReportGroup(System.Security.Principal.IPrincipal p_objPrincipal, string strReportGroupID)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsCheckGroupSvc", "m_lngDelReportGroup");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"DELETE FROM t_aid_lis_report_group WHERE report_group_id_chr = '" + strReportGroupID + "'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
// long lngRecEff = -1;
lngRes = objHRPSvc.DoExcute(strSQL); //,ref lngRecEff);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngSaverMedicineType(System.Security.Principal.IPrincipal p_objPrincipal, clsMS_MedicineTypeVisionmSet[] objMedicineType)
{
long lngRes = 0;
string strSQL;
try
{
strSQL = @"delete from t_ms_medicinetypevisionmset";
clsHRPTableService objHRPServ = new clsHRPTableService();
objHRPServ.DoExcute(strSQL);
if (objMedicineType == null || objMedicineType.Length == 0)
{
return(1);
}
strSQL = @"insert into t_ms_medicinetypevisionmset (medicinetypeid_vchr,lotno_int,validperiod_int) values (?,?,?)";
long lngEff = -1;
if (clsHRPTableService.bytDatabase_Selector != (byte)clsHRPTableService.enumDatabase_Selector.bytOracle)
{
IDataParameter[] objLisAddItemRefArr = null;
for (int iOr = 0; iOr < objMedicineType.Length; iOr++)
{
objHRPServ.CreateDatabaseParameter(3, out objLisAddItemRefArr);
objLisAddItemRefArr[0].Value = objMedicineType[iOr].m_strMedicineTypeid;
objLisAddItemRefArr[1].Value = objMedicineType[iOr].m_intLotno;
objLisAddItemRefArr[2].Value = objMedicineType[iOr].m_intValidperiod;
lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objLisAddItemRefArr);//往表增加记录
}
}
else
{
DbType[] dbTypes = new DbType[] { DbType.String, DbType.Int32, DbType.Int32 };
object[][] objValues = new object[3][];
int intItemCount = objMedicineType.Length;
for (int j = 0; j < objValues.Length; j++)
{
objValues[j] = new object[intItemCount];//初始化
}
for (int iOr = 0; iOr < intItemCount; iOr++)
{
objValues[0][iOr] = objMedicineType[iOr].m_strMedicineTypeid;
objValues[1][iOr] = objMedicineType[iOr].m_intLotno;
objValues[2][iOr] = objMedicineType[iOr].m_intValidperiod;
}
lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes);
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
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_lngSetSampleGroupPrintOrder(System.Security.Principal.IPrincipal p_objPrincipal, clsSampleGroup_VO p_objRecord)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsReportGroupSvc", "m_lngSetSampleGroupPrintOrder");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"UPDATE t_aid_lis_sample_group
SET print_seq_int = '" + p_objRecord.intPRINT_SEQ_INT + @"'
WHERE sample_group_id_chr = '" + p_objRecord.strSampleGroupID + @"'";
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); //要在LogError方法中抛出异常。
}
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 UpdataPrintFlagById(string p_bookID)
{
long lngRes = 0;
string strSQLUpdate;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//System.Data.IDataParameter[] objLisAddItemRefArr = null;
strSQLUpdate = @"UPDATE T_OPR_BIH_ORDER_BOOKING SET
PRINT_FLAG = '1'
WHERE BOOKID_INT in (" + p_bookID + ")";
lngRes = objHRPSvc.DoExcute(strSQLUpdate);
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_lngDelRelationItemInformationByID(System.Security.Principal.IPrincipal p_objPrincipal, string m_strRowNo, string m_strUsageID, string m_strItemID)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsCmCookingMethodItemGroupSvc", "m_lngDelRelationItemInformationByID");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = @"delete T_AID_CMCOOKINGMETHODITEMGROUP A where A.rowno_chr='" + m_strRowNo + "'and A.usageid_chr='" + m_strUsageID + "' and A.itemid_chr='" + m_strItemID + "'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDoUpdRegChargeTypeByID(System.Security.Principal.IPrincipal p_objPrincipal, clsRegchargeType_VO objResult)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngDoUpdRegChargeTypeByID");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDate t_bse_registerchargetype Set " +
"CHARGENAME_CHR='" + objResult.m_strCHARGENAME_CHR + "' " +
", MEMO_VCHR='" + objResult.m_strMEMO_VCHR + "' " +
", CHARGENO_VCHR='" + objResult.m_strCHARGENO_VCHR + "' " +
" Where CHARGEID_CHR='" + objResult.m_strCHARGEID_CHR + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngModifyStstemSeting(System.Security.Principal.IPrincipal p_objPrincipal, string p_strID, string p_strStatus, string p_strModuleID)
{
string strSQL;
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReckoningReport", "m_lngModifyStstemSeting");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
strSQL = "UPDATE t_sys_setting " +
"SET setstatus_int = " + p_strStatus + " " +
"WHERE setid_chr = '" + p_strID + "'" + " and MODULEID_CHR='" + p_strModuleID + "'";
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 lngDeleteByPrimaryKey(IPrincipal p_objPrincipal, int p_Id)
{
long lngRes = -1;
clsHRPTableService HRPSvc = new clsHRPTableService();
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsBillSvc", "lngDeleteByPrimaryKey");
if (lngRes < 0)
{
return(-1);
}
string strSQL = "DELETE FROM t_bse_bill WHERE billid_int= '" + p_Id.ToString() + "'";
try
{
lngRes = HRPSvc.DoExcute(strSQL);
HRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngCommitForce(System.Security.Principal.IPrincipal p_objPrincipal, DataTable p_outDatatable)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsKillLockSVC", "m_lngCommitForce");
if (lngRes < 0)//权限
{
return(-1);
}
StringBuilder strSQL = new StringBuilder(@"commit force ");
try
{
string m_strTemp = string.Empty;
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
for (int i = 0; i < p_outDatatable.Rows.Count; i++)
{
m_strTemp = string.Empty;
m_strTemp = "'" + p_outDatatable.Rows[i]["local_tran_id"].ToString() + "'";
strSQL.Append(m_strTemp);
objHRPSvc.DoExcute(strSQL.ToString());
strSQL = new StringBuilder(@"commit force ");
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_mthSaveData(System.Security.Principal.IPrincipal p_objPrincipal, string strItemID, string strSourceID, string strSourceName, string strSourceCatID, string strCatName)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsChargeItemSvc", "m_mthSaveData");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDate T_BSE_CHARGEITEM Set " +
"ITEMSRCID_VCHR='" + strSourceID.Trim() + "'," +
"ITEMSRCTYPE_INT='" + strSourceCatID.Trim() + "'," +
"ITEMSRCNAME_VCHR='" + strSourceName.Trim() + "'," +
"ITEMSRCTYPENAME_VCHR='" + strCatName.Trim() + "' " +
" Where ITEMID_CHR='" + strItemID + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_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 long m_lngUpdApplUserGroup(System.Security.Principal.IPrincipal p_objPrincipal, string p_strHasChildGroup,
string p_strApplUserGroupID)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngUpdApplUserGroup");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"UPDATE t_aid_lis_appuser_group
SET has_child_group = '" + p_strHasChildGroup + @"'
WHERE user_group_id_chr = '" + p_strApplUserGroupID + @"'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngModifyReportGroup(System.Security.Principal.IPrincipal p_objPrincipal, ref clsReportGroup_VO objReportGroupVO)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsCheckGroupSvc", "m_lngModifyReportGroup");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"UPDATE t_aid_lis_report_group
SET report_group_name_vchr = '" + objReportGroupVO.strReportGroupName + @"',
py_code_chr = '" + objReportGroupVO.strPYCode + @"',
print_title_vchr = '" + objReportGroupVO.strPrintTitle + @"',
wb_code_chr = '" + objReportGroupVO.strWBCode + @"',
assist_code01_chr = '" + objReportGroupVO.strAssistCode01 + @"',
assist_code02_chr = '" + objReportGroupVO.strAssistCode02 + @"',
print_category_id_chr = '" + objReportGroupVO.strPrintCategoryID + @"'
WHERE report_group_id_chr = '" + objReportGroupVO.strReportGroupID + @"'";
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_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_lngDoAddNewModule(System.Security.Principal.IPrincipal p_objPrincipal, string p_strModuleName, string p_strEngName, string p_strPYCode, string p_strWBCode, out string p_strID)
{
long lngRes = 0;
p_strID = "";
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsUsageSvc", "m_lngDoAddNewModule");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
lngRes = objHRPSvc.lngGenerateID(4, "MODULEID_CHR", "T_SYS_MODULE", out p_strID);
if (lngRes < 0)
{
return(-1);
}
string strSQL = "INSERT INTO T_SYS_MODULE (MODULEID_CHR, MODULENAME_CHR, ENGNAME_CHR, PYCODE_CHR, WBCODE_CHR) VALUES " +
" ('" + p_strID + "' , '" + p_strModuleName + "', '" + p_strEngName + "', '" + p_strPYCode + "', '" + p_strWBCode + "')";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_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_lngDoUpdModuleByID(System.Security.Principal.IPrincipal p_objPrincipal, clsHISModuleDef_VO objResult)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsHISInfoDefineSvc", "m_lngDoUpdModuleByID");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDATE T_SYS_MODULE SET " +
"MODULENAME_CHR = '" + objResult.m_strModuleName + "', " +
"ENGNAME_CHR = '" + objResult.m_strEngName + "', " +
"PYCODE_CHR = '" + objResult.m_strPYCode + "', " +
"WBCODE_CHR = '" + objResult.m_strWBCode + "' " +
"WHERE MODULEID_CHR = '" + objResult.m_strModuleID + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_mthSaveData(System.Security.Principal.IPrincipal p_objPrincipal, string strItemID, string strSourceID)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsChargeItemSvc", "m_mthSaveData");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDate T_BSE_MEDICINE Set MEDICINESTDID_CHR='" + strSourceID.Trim() + "' Where MEDICINEID_CHR='" + strItemID.Trim() + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDelAllLoginInfo(System.Security.Principal.IPrincipal p_objPrincipal)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.baseInfo.clsHISInfoDefineSvc", "m_lngDelAllErrorLog");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "DELETE T_SYS_LOG";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDoAddNewUsageType(System.Security.Principal.IPrincipal p_objPrincipal, string p_usageID, string p_usageType)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngDoAddNewUsageType");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = "INSERT INTO t_opr_setusage (USAGEID_CHR,TYPE_INT) VALUES ('" + p_usageID + "'," + p_usageType + ")";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDoUpdHospitalInfo(System.Security.Principal.IPrincipal p_objPrincipal, clsHISInfoDefine_VO objResult)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsHISInfoDefineSvc", "m_lngDoUpdHospitalInfo");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDate t_bse_hospitalinfo Set " +
"HOSPITAL_NAME_CHR='" + objResult.m_strHOSPITAL_NAME_CHR + "' " +
", ADDRESS_VCHR='" + objResult.m_strADDRESS_VCHR + "' " +
", PHONE_NUMBER_CHR='" + objResult.m_strPHONE_NUMBER_CHR + "' " +
", PHONE_NUMBER2_CHR='" + objResult.m_strPHONE_NUMBER2_CHR + "' " +
", ZIP_CHR='" + objResult.m_strZIP_CHR + "' " +
", MEMO_VCHR='" + objResult.m_strMEMO_VCHR + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}