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