public long m_lngGetApplyUnitInfo(System.Security.Principal.IPrincipal p_objPrincipal,
string[] p_strApplyUnitIDArr, out DataTable p_dtbResult)
{
long lngRes = 0;
p_dtbResult = new DataTable();
if (p_strApplyUnitIDArr == null)
{
return(-1);
}
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal,
"com.digitalwave.iCare.middletier.LIS.clsInputGroupSvc", "m_lngGetApplyUnitInfo");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT a.apply_unit_id_chr, a.apply_unit_name_vchr,
'nullvalue' input_group_id_chr
FROM t_aid_lis_apply_unit a
WHERE a.apply_unit_id_chr IN ('_'*)
";
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
IDataParameter[] objParamArr = null;
objHRPSvc.CreateDatabaseParameter(p_strApplyUnitIDArr.Length, out objParamArr);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
for (int i = 0; i < p_strApplyUnitIDArr.Length; i++)
{
sb.Append(",?");
objParamArr[i].Value = p_strApplyUnitIDArr[i];
}
strSQL = strSQL.Replace("*", sb.ToString());
try
{
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtbResult, objParamArr);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。
lngRes = 0;
}
return(lngRes);
}
public long m_lngGetDeptList(System.Security.Principal.IPrincipal p_objPrincipal, string strDepID, 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", "m_lngGetOPDoctorListByDate");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "select deptid_chr, modify_dat, deptname_vchr, category_int, inpatientoroutpatient_int, operatorid_chr, address_vchr, pycode_chr, attributeid, parentid, createdate_dat, status_int, deactivate_dat, wbcode_chr, code_vchr, extendid_vchr, shortno_chr, stdbed_count_int, putmed_int, usercode_vchr, expertdeptflag_int from t_bse_deptdesc";
if (strDepID != null)
{
strSQL = strSQL + " And deptid_chr='" + strDepID + "'";
}
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]["DEPTID_CHR"].ToString().Trim();
objDep[i1].strDeptName = dtbResult.Rows[i1]["DEPTNAME_VCHR"].ToString().Trim();
objDep[i1].strCreateDate = dtbResult.Rows[i1]["CREATEDATE_DAT"].ToString().Trim();
if (dtbResult.Rows[i1]["STATUS_INT"].ToString().Trim() != "")
{
objDep[i1].intStatus = int.Parse(dtbResult.Rows[i1]["STATUS_INT"].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 GetReprintByPrintEmp(System.Security.Principal.IPrincipal p_objPrincipal, string p_strEmpId, string p_strStartDate, string p_strEndDate, 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.clsPrepayCheckoutSvc", "GetReprintByPrintEmp");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT b.BILLTYPE_CHR,
b.BILLID_CHR,
b.SOURCEBILLNO_VCHR,
b.REPPRNBILLNO_VCHR,
b.PRINTEMP_CHR,
b.PRINTDATE_DAT,
b.PRINTSTATUS_INT,
a.MONEY_DEC
FROM T_OPR_BIH_PREPAY A,
T_OPR_BIH_BILLREPEATPRINT B
WHERE A.PREPAYID_CHR = B.BILLID_CHR AND
B.BILLTYPE_CHR = '1' AND
B.PRINTEMP_CHR = ? AND
(B.PRINTDATE_DAT BETWEEN ? AND ? ) ORDER BY B.BILLID_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(3, out arrParams);
arrParams[0].Value = p_strEmpId;
arrParams[1].Value = System.DateTime.Parse(p_strStartDate);
arrParams[2].Value = System.DateTime.Parse(p_strEndDate);
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);
}
public long m_lngAddReportGroup(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_lngAddReportGroup");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"INSERT INTO t_aid_lis_report_group
(report_group_id_chr, report_group_name_vchr, py_code_chr,
print_title_vchr, wb_code_chr, assist_code01_chr,
assist_code02_chr, print_category_id_chr
)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)" ;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
System.Data.IDataParameter[] objReportGroupArr = null;
objHRPSvc.CreateDatabaseParameter(8, out objReportGroupArr);
if (objReportGroupVO.strReportGroupID == null)
{
objReportGroupVO.strReportGroupID = objHRPSvc.m_strGetNewID("t_aid_lis_report_group", "REPORT_GROUP_ID_CHR", 6);
}
objReportGroupArr[0].Value = objReportGroupVO.strReportGroupID;
objReportGroupArr[1].Value = objReportGroupVO.strReportGroupName;
objReportGroupArr[2].Value = objReportGroupVO.strPYCode;
objReportGroupArr[3].Value = objReportGroupVO.strPrintTitle;
objReportGroupArr[4].Value = objReportGroupVO.strWBCode;
objReportGroupArr[5].Value = objReportGroupVO.strAssistCode01;
objReportGroupArr[6].Value = objReportGroupVO.strAssistCode02;
objReportGroupArr[7].Value = objReportGroupVO.strPrintCategoryID;
long lngRecEff = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objReportGroupArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_mthGetAccordRecipeDetail(System.Security.Principal.IPrincipal p_objPrincipal, string ID, out DataTable dt)
{
dt = new DataTable();
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS", "m_mthGetAccordRecipeDetail");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT a.*, b.itemname_vchr, b.itemspec_vchr, b.itemcatid_chr, b.ifstop_int,
c.usagename_vchr, d.freqname_chr, e.noqtyflag_int, b.itemopinvtype_chr,CASE
WHEN b.opchargeflg_int = 1
THEN ROUND (b.itemprice_mny / b.packqty_dec,
4
)
WHEN b.opchargeflg_int = 0
THEN b.itemprice_mny
END AS itemprice_mny,b.ITEMCODE_VCHR,b.DOSAGEUNIT_CHR,e.MEDICINEID_CHR,b.ITEMOPUNIT_CHR,a.QTY_DEC,a.DOSETYPE_CHR
FROM t_aid_concertrecipedetail a,
t_bse_chargeitem b,
t_bse_usagetype c,
t_aid_recipefreq d,
t_bse_medicine e
WHERE a.itemid_chr = b.itemid_chr(+)
AND a.freqid_chr = d.freqid_chr(+)
AND a.dosetype_chr = c.usageid_chr(+)
AND b.itemsrcid_vchr = e.medicineid_chr(+) AND a.recipeid_chr = ? order by a.sort_int";
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
IDataParameter[] ParamArr = null;
objHRPSvc.CreateDatabaseParameter(1, out ParamArr);
//((OracleParameter)ParamArr[0]).OracleDbType = OracleDbType.Char;
ParamArr[0].Value = ID;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dt, 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_lngWindowsWork(System.Security.Principal.IPrincipal p_objPrincipal, string strWindowsID, out bool isWork)
{
isWork = false;
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc", "m_lngWindowsWork");
if (lngRes < 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = @"SELECT a.WORKSTATUS_INT
FROM t_bse_medstorewin a
WHERE a.WINDOWID_CHR = '" + strWindowsID + "'";
DataTable dt = new DataTable();
try
{
lngRes = objHRPSvc.DoGetDataTable(strSQL, ref dt);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
if (dt.Rows.Count > 0)
{
try
{
if (int.Parse(dt.Rows[0]["WORKSTATUS_INT"].ToString()) == 1)
{
isWork = true;
}
else
{
isWork = false;
}
}
catch
{
isWork = false;
}
}
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_lngGetVSessionByCondition(System.Security.Principal.IPrincipal p_objPrincipal, ArrayList m_objArrayList, 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_lngGetVSessionByCondition");
if (lngRes < 0)//权限
{
return(-1);
}
StringBuilder strSQL = new StringBuilder(@"select a.sid,a.serial#,a.audsid from V$SESSION a where a.sid in([condition]) and a.username='******'");
try
{
string m_strTemp = string.Empty;
for (int i = 0; i < m_objArrayList.Count; i++)
{
m_strTemp += "'" + m_objArrayList[i].ToString() + "'";
if (i <= m_objArrayList.Count - 2)
{
m_strTemp += ",";
}
}
strSQL = strSQL.Replace("[condition]", m_strTemp);
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL.ToString(), ref p_outDatatable);
if (lngRes > 0 && p_outDatatable.Rows.Count > 0)
{
strSQL = new StringBuilder(@"alter system kill session '[compression]'");
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_lngGetMedWinByID(System.Security.Principal.IPrincipal p_objPrincipal, string p_WinID, out clsMedSendConfig_VO[] p_objResArr)
{
long lngRes = 0;
p_objResArr = new clsMedSendConfig_VO[0];
DataTable p_dtRes = new DataTable();
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsMedStoreBseInfoSvc", "m_lngGetMedWinByID");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @" select c.seq_int,c.treatwinid_chr,c.givewinid_chr,c.order_int,d.windowname_vchr
from T_OPR_MEDSTOREWINRLT c ,T_BSE_MEDSTOREWIN d
where c.givewinid_chr=d.windowid_chr(+) and c.treatwinid_chr='" + p_WinID.Trim() + "' order by c.order_int";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtRes);
objHRPSvc.Dispose();
if (lngRes > 0 && p_dtRes != null)
{
int intRow = p_dtRes.Rows.Count;
if (intRow > 0)
{
p_objResArr = new clsMedSendConfig_VO[intRow];
for (int i = 0; i < intRow; i++)
{
p_objResArr[i] = new clsMedSendConfig_VO();
p_objResArr[i].m_intSeq = Convert.ToInt32(p_dtRes.Rows[i]["seq_int"].ToString().Trim());
p_objResArr[i].m_TreatWinID_chr = p_dtRes.Rows[i]["treatwinid_chr"].ToString().Trim();
p_objResArr[i].m_GiveWinID_chr = p_dtRes.Rows[i]["givewinid_chr"].ToString().Trim();
p_objResArr[i].m_intOrder = Convert.ToInt32(p_dtRes.Rows[i]["order_int"].ToString().Trim());
p_objResArr[i].m_strGiveWinName = p_dtRes.Rows[i]["windowname_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_lngSaveUpdatePatientSPECREMARK(System.Security.Principal.IPrincipal p_objPrincipal, clsSpecreMark_VO m_objSpecreMark_VO)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsSpecreMarkSvc", "m_lngSaveUpdatePatientSPECREMARK");
if (lngRes < 0)
{
return(-1);
}
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = 0;
string strSQL = "";
strSQL = @"
update T_OPR_BIH_PATSPECREMARK set REMARKID_CHR = ?, REMARKNAME_VCHR = ?, CHARGECTL_INT = ?
where SEQ_INT = ?
";
System.Data.IDataParameter[] arrParams = null;
objHRPSvc.CreateDatabaseParameter(4, out arrParams);
arrParams[0].Value = m_objSpecreMark_VO.m_strREMARKID_CHR;
arrParams[1].Value = m_objSpecreMark_VO.m_strREMARKNAME_VCHR;
arrParams[2].Value = m_objSpecreMark_VO.m_intCHARGECTL_INT;
arrParams[3].Value = m_objSpecreMark_VO.m_strSEQ_INT;
long lngAff = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngAff, arrParams);
strSQL = @"update t_opr_bih_register set des_vchr = ?
where registerid_chr = ?";
System.Data.IDataParameter[] arrParams2 = null;
objHRPSvc.CreateDatabaseParameter(2, out arrParams2);
arrParams2[0].Value = m_objSpecreMark_VO.m_strDec_vchr;
arrParams2[1].Value = m_objSpecreMark_VO.m_strREGISTERID_CHR;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngAff, arrParams2);
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_lngGetMedicineTypeData(System.Security.Principal.IPrincipal p_objPrincipal, out clsValue_MedicineType_VO[] p_objData)
{
p_objData = new clsValue_MedicineType_VO[0];
long lngRes = 0;
//权限控制,clsPrivilegeHandleService为权限处理服务类
com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService();
lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.MedicineStoreService.clsStorageRacksetSVC", "m_lngGetMedicineTypeData");
if (lngRes < 0)
{
return(-1);
}
//创建COM对象
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = @"select medicinetypeid_chr,medicinetypename_vchr from t_aid_medicinetype order by medicinetypeid_chr asc";
DataTable dtbResult = new DataTable();
try
{
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult);
if (lngRes > 0 && dtbResult != null)
{
p_objData = new clsValue_MedicineType_VO[dtbResult.Rows.Count];
DataRow m_drDataRow = null;
clsValue_MedicineType_VO tmp_p_objData = null;
for (int i1 = 0; i1 < dtbResult.Rows.Count; i1++)
{
tmp_p_objData = new clsValue_MedicineType_VO();
m_drDataRow = dtbResult.Rows[i1];
tmp_p_objData.m_strMedicineTypeID = m_drDataRow["medicinetypeid_chr"].ToString();
tmp_p_objData.m_strMedicineTypeName = m_drDataRow["medicinetypename_vchr"].ToString();
p_objData[i1] = tmp_p_objData;
}
m_drDataRow = null;
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
objHRPSvc.Dispose();
return(lngRes);
}
public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCSamplelotVO p_objQCSamplelot, out int p_intSeq)
{
long lngRes = 0;
p_intSeq = -1;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngInsert");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
try
{
lngRes = 0;
lngRes = objHRPSvc.m_lngGenerateNewID(m_strTableName, m_strPrimaryKey, out p_intSeq);
if (lngRes <= 0)
{
return(-1);
}
lngRes = 0;
System.Data.IDataParameter[] objODPArr = GetInsertDataParameterArr(p_objQCSamplelot, p_intSeq);
long lngRecEff = -1;
//往表增加记录
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(m_strInsertSql, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
if (lngRes > 0)
{
p_objQCSamplelot.m_intSeq = p_intSeq;//给VO赋值ID
}
else
{
p_intSeq = -1;
}
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetApplUnitByCheckCategory(System.Security.Principal.IPrincipal p_objPrincipal, string p_strCheckCategory,
out clsApplUnit_VO[] p_objResultArr)
{
long lngRes = 0;
p_objResultArr = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsApplyUnitSvc", "m_lngGetAllApplUnit");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"select apply_unit_id_chr, apply_unit_name_vchr, other_name_vchr, py_code_chr,
assist_code01_chr, wb_code_chr, assist_code02_chr,
check_category_id_chr, is_no_food_required_chr,
is_physical_exam_required_chr, is_reservation_required_chr, price_num,
cost_num, sample_type_id_chr, summary_vchr, outer_check_flag_num, reporthour, SamplingInstr
from t_aid_lis_apply_unit
where CHECK_CATEGORY_ID_CHR = '" + p_strCheckCategory + @"' ORDER BY apply_unit_id_chr";
DataTable dtbApplUnit = null;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbApplUnit);
objHRPSvc.Dispose();
if (lngRes > 0 && dtbApplUnit != null)
{
if (dtbApplUnit.Rows.Count > 0)
{
p_objResultArr = new clsApplUnit_VO[dtbApplUnit.Rows.Count];
for (int i = 0; i < dtbApplUnit.Rows.Count; i++)
{
p_objResultArr[i] = new clsApplUnit_VO();
ConstructApplUnitVO(dtbApplUnit.Rows[i], ref p_objResultArr[i]);
}
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngFindPatientPayTypeList(System.Security.Principal.IPrincipal p_objPrincipal, out clstPatientPaytype_VO[] p_objResultArr)
{
p_objResultArr = new clstPatientPaytype_VO[0];
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsLisDeviceSvc", "m_lngFindPatientPayTypeList");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT p.*,PLANNAME_CHR FROM t_bse_patientPaytype p left join T_AID_INSPLAN i on p.COPAYID_CHR =i.PLANID_CHR order by PAYTYPENO_VCHR";
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 clstPatientPaytype_VO[dtbResult.Rows.Count];
for (int i1 = 0; i1 < p_objResultArr.Length; i1++)
{
p_objResultArr[i1] = new clstPatientPaytype_VO();
p_objResultArr[i1].m_strPAYTYPEID_CHR = dtbResult.Rows[i1]["PAYTYPEID_CHR"].ToString().Trim();
p_objResultArr[i1].m_strPAYTYPENAME_VCHR = dtbResult.Rows[i1]["PAYTYPENAME_VCHR"].ToString().Trim();
p_objResultArr[i1].m_strMEMO_VCHR = dtbResult.Rows[i1]["MEMO_VCHR"].ToString().Trim();
p_objResultArr[i1].m_strPAYLIMIT_MNY = dtbResult.Rows[i1]["PAYLIMIT_MNY"].ToString().Trim();
p_objResultArr[i1].m_strPAYFLAG_DEC = dtbResult.Rows[i1]["PAYFLAG_DEC"].ToString().Trim();
p_objResultArr[i1].m_strPAYPERCENT_DEC = dtbResult.Rows[i1]["PAYPERCENT_DEC"].ToString().Trim();
p_objResultArr[i1].m_strPAYTYPENO_VCHR = dtbResult.Rows[i1]["PAYTYPENO_VCHR"].ToString().Trim();
p_objResultArr[i1].m_strISUSING_NUM = dtbResult.Rows[i1]["ISUSING_NUM"].ToString().Trim();
p_objResultArr[i1].m_strCOPAYID_CHR = dtbResult.Rows[i1]["PLANNAME_CHR"].ToString().Trim();
p_objResultArr[i1].m_strCHARGEPERCENT_DEC = dtbResult.Rows[i1]["CHARGEPERCENT_DEC"].ToString().Trim();
p_objResultArr[i1].m_intINTERNALFLAG_INT = Convert.ToInt16(dtbResult.Rows[i1]["INTERNALFLAG_INT"].ToString().Trim());
p_objResultArr[i1].m_strCOALITIONRECIPEFLAG_INT = dtbResult.Rows[i1]["COALITIONRECIPEFLAG_INT"].ToString().Trim();
p_objResultArr[i1].m_strBIHLIMITRATE_DEC = dtbResult.Rows[i1]["BIHLIMITRATE_DEC"].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_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_lngGetDictListFor(System.Security.Principal.IPrincipal p_objPrincipal, string p_strDictKind, out clsAIDDICT_VO[] p_objResultArr)
{
long lngRes = 0;
p_objResultArr = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsDictSvc", "m_lngGetDictListFor");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT *
FROM t_aid_dict
WHERE trim(dictid_chr) <> '0'
AND dictkind_chr = '" + p_strDictKind + "'";
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 clsAIDDICT_VO[dtbResult.Rows.Count];
for (int i1 = 0; i1 < p_objResultArr.Length; i1++)
{
p_objResultArr[i1] = new clsAIDDICT_VO();
p_objResultArr[i1].m_strJXCODE_CHR = dtbResult.Rows[i1]["JXCODE_CHR"].ToString().Trim();
p_objResultArr[i1].m_strWBCODE_CHR = dtbResult.Rows[i1]["WBCODE_CHR"].ToString().Trim();
p_objResultArr[i1].m_strPYCODE_CHR = dtbResult.Rows[i1]["PYCODE_CHR"].ToString().Trim();
p_objResultArr[i1].m_strDICTNAME_VCHR = dtbResult.Rows[i1]["DICTNAME_VCHR"].ToString().Trim();
p_objResultArr[i1].m_strDICTID_CHR = dtbResult.Rows[i1]["DICTID_CHR"].ToString().Trim();
p_objResultArr[i1].m_strDICTKIND_CHR = dtbResult.Rows[i1]["DICTKIND_CHR"].ToString().Trim();
p_objResultArr[i1].m_strDICTSEQID_CHR = dtbResult.Rows[i1]["DICTSEQID_CHR"].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_lngGetApplUnitBySampleGroupID(System.Security.Principal.IPrincipal p_objPrincipal, string p_strSampleGroupID,
out clsLisSampleGroupUnit_VO[] p_objResultArr)
{
long lngRes = 0;
p_objResultArr = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsSampleGroupSvc", "m_lngGetApplUnitBySampleGroupID");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT a.*, b.apply_unit_name_vchr
FROM t_aid_lis_sample_group_unit a, t_aid_lis_apply_unit b
WHERE a.apply_unit_id_chr = b.apply_unit_id_chr" ;
if (p_strSampleGroupID != null && p_strSampleGroupID != "")
{
strSQL += @" AND a.sample_group_id_chr = '" + p_strSampleGroupID + @"'";
}
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 != null && dtbResult.Rows.Count > 0)
{
p_objResultArr = new clsLisSampleGroupUnit_VO[dtbResult.Rows.Count];
for (int i = 0; i < p_objResultArr.Length; i++)
{
p_objResultArr[i] = new clsLisSampleGroupUnit_VO();
p_objResultArr[i].m_strAPPLY_UNIT_DESC_VCHR = dtbResult.Rows[i]["apply_unit_name_vchr"].ToString().Trim();
p_objResultArr[i].m_strAPPLY_UNIT_ID_CHR = dtbResult.Rows[i]["apply_unit_id_chr"].ToString().Trim();
p_objResultArr[i].m_strSAMPLE_GROUP_ID_CHR = dtbResult.Rows[i]["sample_group_id_chr"].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_lngGetSpecialRemarkDicByCondition(System.Security.Principal.IPrincipal p_objPrincipal, string m_strConditionIndex, string m_strSearchContent, out DataTable m_objTable)
{
long m_lngRes = -1;
m_objTable = new DataTable();
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
m_lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.BIHOrderServer.clsSpecialRemarkDicService", "m_lngGetSpecialRemarkDicByCondition");
if (m_lngRes < 0)
{
return(-1);
}
string m_strSQL = @"SELECT A.remarkid_chr, A.remarkname_vchr, A.usercode_vchr,case when A.chargectl_int=0 then '²»ÔÊÐí'
when A.chargectl_int=1 then 'ÔÊÐí' end as chargectl_status FROM t_bse_bih_specremark A ";
switch (m_strConditionIndex.Trim())
{
case "0": m_strSQL += " where A.remarkid_chr like'%" + m_strSearchContent.Trim() + "'order by A.remarkid_chr"; break;
case "1": m_strSQL += " where A.remarkname_vchr like'%" + m_strSearchContent.Trim() + "%'order by A.remarkid_chr"; break;
case "2": m_strSQL += " where A.usercode_vchr like'%" + m_strSearchContent.Trim() + "%'order by A.remarkid_chr"; break;
case "3":
if (m_strSearchContent.Trim() == "ÔÊÐí")
{
m_strSQL += "where A.chargectl_int=1 order by A.remarkid_chr";
}
else if (m_strSearchContent.Trim() == "²»ÔÊÐí")
{
m_strSQL += "where A.chargectl_int=0 order by A.remarkid_chr";
}
break;
default: break;
}
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService m_objHRP = new clsHRPTableService();
m_lngRes = m_objHRP.lngGetDataTableWithoutParameters(m_strSQL, ref m_objTable);
}
catch (Exception ex)
{
string strTmp = ex.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(ex);
}
return(m_lngRes);
}
public long m_lngFindAllUsage(
System.Security.Principal.IPrincipal p_objPrincipal,
out clsUsageType_VO[] p_objResultArr, string strEx)
{
p_objResultArr = new clsUsageType_VO[0];
long lngRes = 0;
//权限控制
com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService();
lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsGetBase", "m_lngFindAllUsage");
if (lngRes < 0)
{
return(-1);
}
DataTable dtbResult = new DataTable();
string strSQL = "SELECT * FROM t_bse_usagetype WHERE usercode_chr LIKE '" + strEx + "%' OR pycode_vchr LIKE '" + strEx + "%' OR wbcode_vchr LIKE '" + strEx + "%' ORDER BY scope_int, usercode_chr";
try
{
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 clsUsageType_VO[dtbResult.Rows.Count];
for (int i1 = 0; i1 < p_objResultArr.Length; i1++)
{
p_objResultArr[i1] = new clsUsageType_VO();
p_objResultArr[i1].m_intScope = Convert.ToInt32(dtbResult.Rows[i1]["scope_int"].ToString());
p_objResultArr[i1].m_strUsageID = dtbResult.Rows[i1]["USAGEID_CHR"].ToString().Trim();
p_objResultArr[i1].m_strUsageName = dtbResult.Rows[i1]["USAGENAME_VCHR"].ToString().Trim();
p_objResultArr[i1].m_strUsageCode = dtbResult.Rows[i1]["USERCODE_CHR"].ToString().Trim();
p_objResultArr[i1].m_strUsagePYCODE = dtbResult.Rows[i1]["PYCODE_VCHR"].ToString().Trim();
p_objResultArr[i1].m_strUsageWBCODE = dtbResult.Rows[i1]["WBCODE_VCHR"].ToString().Trim();
p_objResultArr[i1].m_intPutMed = int.Parse(dtbResult.Rows[i1]["PUTMED_INT"].ToString().Trim()) == 0 ? 0 : 1;
p_objResultArr[i1].m_intTest = int.Parse(dtbResult.Rows[i1]["TEST_INT"].ToString().Trim()) == 0 ? 0 : 1;
p_objResultArr[i1].m_strOPUsageDesc = dtbResult.Rows[i1]["OPUSAGEDESC"].ToString();
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetApplyUnitVOByApplyUnitID(System.Security.Principal.IPrincipal p_objPrincipal,
string p_strApplyUnitID,
out clsApplUnit_VO p_objApplUnit)
{
long lngRes = 0;
p_objApplUnit = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngGetApplyUnitVOByApplyUnitID");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"select apply_unit_id_chr, apply_unit_name_vchr, other_name_vchr, py_code_chr,
assist_code01_chr, wb_code_chr, assist_code02_chr,
check_category_id_chr, is_no_food_required_chr,
is_physical_exam_required_chr, is_reservation_required_chr, price_num,
cost_num, sample_type_id_chr, summary_vchr, outer_check_flag_num, reporthour, SamplingInstr
from t_aid_lis_apply_unit
where apply_unit_id_chr = ?";
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
DataTable dtbResult = null;
IDataParameter[] objDPArr = null;
objHRPSvc.CreateDatabaseParameter(1, out objDPArr);
objDPArr[0].Value = p_strApplyUnitID;
lngRes = 0;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr);
objHRPSvc.Dispose();
if (lngRes > 0 && dtbResult != null && dtbResult.Rows.Count != 0)
{
p_objApplUnit = new clsApplUnit_VO();
ConstructApplUnitVO(dtbResult.Rows[0], ref p_objApplUnit);
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetStatiticsData(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable p_dtbResult, string p_strPeriodId)
{
p_dtbResult = new DataTable();
long lngRes = 0;
//权限控制
com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService();
lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsHisMedInOrderStatisticSvc", "m_lngGetStatiticsData");
if (lngRes < 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL;
if (p_strPeriodId != "")
{
strSQL = @"SELECT Ta.docid_vchr, Ta.tolmny_mny, Tb.vendorname_vchr
FROM t_opr_storageord Ta, t_bse_vendor Tb, t_bse_period Tc
WHERE Ta.vendorid_chr = Tb.vendorid_chr(+)
AND Ta.periodid_chr = Tc.periodid_chr
AND Tc.PERIODID_CHR = " ;
strSQL += "'" + p_strPeriodId + "'";
strSQL += " AND Ta.pstatus_int = 2 AND Ta.sign_int = 1";
}
else //选择所有时期
{
strSQL = @"SELECT Ta.docid_vchr, Ta.tolmny_mny, Tb.vendorname_vchr
FROM t_opr_storageord Ta, t_bse_vendor Tb, t_bse_period Tc
WHERE Ta.vendorid_chr = Tb.vendorid_chr(+)
AND Ta.periodid_chr = Tc.periodid_chr " ;
strSQL += " AND Ta.pstatus_int = 2 AND Ta.sign_int = 1";
}
try
{
lngRes = objHRPSvc.DoGetDataTable(strSQL, ref p_dtbResult);
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
objHRPSvc.Dispose();
return(lngRes);
}
public long m_lngUpdateQCReport(IPrincipal p_objPrincipal, clsLisQCReportVO QCBatch)
{
long num = 0L;
clsPrivilegeHandleService clsPrivilegeHandleService = new clsPrivilegeHandleService();
num = clsPrivilegeHandleService.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsQCBusiness_Serv", "m_lngUpdateQCReport");
long result;
if (num <= 0L)
{
result = -1L;
}
else
{
clsHRPTableService svc = new clsHRPTableService();
try
{
IDataParameter[] updateDataParameterArr = this.GetUpdateDataParameterArr(QCBatch);
long num2 = -1L;
num = 0L;
string Sql = @"update t_opr_lis_qcreport
set qcbatch_seq_int = ?,
qcstatus_int = ?,
unmatchedrule_vchr = ?,
reason_vchr = ?,
process_vchr = ?,
summary_vchr = ?,
report_dat = ?,
reportor_id_chr = ?,
status_int = ?,
modify_dat = ?,
report_stats_int = ?
where qcreport_seq_int = ? ";
num = svc.lngExecuteParameterSQL(Sql, ref num2, updateDataParameterArr);
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
finally
{
svc.Dispose();
}
result = num;
}
return(result);
}
public long m_mthFindCMRecipeDetail(System.Security.Principal.IPrincipal p_objPrincipal, string ID, out DataTable dt)
{
dt = new DataTable();
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS", "m_mthFindCMRecipeDetail");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT a.itemid_chr, a.qty_dec,a.DOSAGEQTY_DEC,a.DOSETYPE_CHR, b.itemname_vchr, b.itemspec_vchr,
b.dosageunit_chr, ROUND (b.itemprice_mny / b.packqty_dec, 4) submoney,b.itemengname_vchr,
b.packqty_dec, b.itemprice_mny,b.opchargeflg_int,b.dosage_dec, b.insuranceid_chr,
b.ITEMOPINVTYPE_CHR,d.usagename_vchr,b.ITEMCODE_VCHR,a.ROWNO_CHR, m.deptprep_int
FROM t_aid_concertrecipedetail a,
t_bse_chargeitem b,
T_BSE_CHARGECATMAP e,
T_BSE_USAGETYPE d,
t_bse_medicine m
WHERE a.itemid_chr = b.itemid_chr(+)
AND b.ITEMOPINVTYPE_CHR =e.catid_chr(+)
and a.dosetype_chr=d.usageid_chr(+)
and e.groupid_chr='0002'
and e.INTERNALFLAG_INT=0
and b.ITEMSRCID_VCHR = m.MEDICINEID_CHR(+)
AND recipeid_chr = ? order by a.sort_int";
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
IDataParameter[] ParamArr = null;
objHRPSvc.CreateDatabaseParameter(1, out ParamArr);
//((OracleParameter)ParamArr[0]).OracleDbType = OracleDbType.Char;
ParamArr[0].Value = ID;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dt, 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 GetCheckoutPrepayHis(System.Security.Principal.IPrincipal p_objPrincipal,
string p_strOperatorId,
string p_strStartDate,
string p_strEndDate,
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 BALANCEID_VCHR,
BALANCEEMP_CHR,
BALANCE_DAT,
REMARK_VCHR
from T_OPR_BIH_PREPAYBALANCE
where BALANCEEMP_CHR = ?
and (BALANCE_DAT between ? and ? ) ORDER BY BALANCE_DAT";
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(3, out arrParams);
arrParams[0].Value = p_strOperatorId;
arrParams[1].Value = System.DateTime.Parse(p_strStartDate);
arrParams[2].Value = System.DateTime.Parse(p_strEndDate);
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);
}
public long m_lngMeditionProtectReport(System.Security.Principal.IPrincipal p_objPrincipal, string finddate, string finddateLast, out System.Data.DataTable p_tabReport)
{
string strSQL;
p_tabReport = new DataTable();
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReckoningReport", "m_lngMeditionProtectReport");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
// strSQL=@"SELECT t1.invoiceno_vchr, t1.invdate_dat, t1.balance_dat, t1.TOTALSUM_MNY as TOTALSUM_MNY,
//t2.idcard_chr as PATIENTID_CHR, t1.patientname_chr
// FROM t_opr_outpatientrecipeinv t1, t_bse_patient t2,t_bse_patientPaytype t3
// WHERE t1.patientid_chr = t2.patientid_chr(+)
// and t1.paytypeid_chr=t3.paytypeid_chr(+)
// and t3.internalflag_int = 2
//and t1.BALANCE_DAT is not null
//AND t1.invdate_dat BETWEEN TO_DATE('"+finddate+"','yyyy-mm-dd hh24:mi:ss') "+
// " AND TO_DATE('"+finddateLast+" 23:59:59','yyyy-mm-dd hh24:mi:ss')";
strSQL = @"SELECT t1.invoiceno_vchr, t1.invdate_dat, t1.balance_dat, t1.TOTALSUM_MNY as TOTALSUM_MNY,
t2.idcard_chr as PATIENTID_CHR, t1.patientname_chr
FROM t_opr_outpatientrecipeinv t1, t_bse_patient t2
WHERE t1.patientid_chr = t2.patientid_chr(+)
AND t1.PAYTYPE_INT=3
and (t1.status_int = 1 or t1.status_int = 3)
and t1.BALANCE_DAT is not null
AND t1.invdate_dat BETWEEN TO_DATE('" + finddate + "','yyyy-mm-dd hh24:mi:ss') " +
" AND TO_DATE('" + finddateLast + " 23:59:59','yyyy-mm-dd hh24:mi:ss') order by t1.invdate_dat";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_tabReport);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngFindAllUsageSet(
System.Security.Principal.IPrincipal p_objPrincipal,
out clsUsageType_VO[] p_objResultArr)
{
p_objResultArr = new clsUsageType_VO[0];
long lngRes = 0;
//权限控制
com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService();
lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsGetBase", "m_lngFindAllUsageSet");
if (lngRes < 0)
{
return(-1);
}
DataTable dtbResult = new DataTable();
string strSQL = "SELECT distinct t1.usageid_chr, t2.usercode_chr, t2.usagename_vchr, t1.type_int " +
" FROM t_opr_setusage t1, t_bse_usagetype t2 " +
"where t1.usageid_chr=t2.usageid_chr " +
"ORDER BY t1.usageid_chr ";
try
{
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 clsUsageType_VO[dtbResult.Rows.Count];
for (int i1 = 0; i1 < p_objResultArr.Length; i1++)
{
p_objResultArr[i1] = new clsUsageType_VO();
p_objResultArr[i1].m_strUsageID = dtbResult.Rows[i1]["USAGEID_CHR"].ToString().Trim();
p_objResultArr[i1].m_strUsageName = dtbResult.Rows[i1]["USAGENAME_VCHR"].ToString().Trim();
p_objResultArr[i1].m_strUsageCode = dtbResult.Rows[i1]["USERCODE_CHR"].ToString().Trim();
p_objResultArr[i1].m_strUsageType = dtbResult.Rows[i1]["type_int"].ToString().Trim();
// p_objResultArr[i1].m_strorderid = dtbResult.Rows[i1]["orderid_vchr"].ToString().Trim();
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetAllSampleGroupDetail(System.Security.Principal.IPrincipal p_objPrincipal, out clsSampleGroupDetail_VO[] objSampleGroupDetailVOList)
{
long lngRes = 0;
objSampleGroupDetailVOList = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsSampleGroupSvc", "m_lngGetAllSampleGroupDetail");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT t1.sample_group_id_chr, t2.check_item_id_chr, t2.print_seq_int
FROM t_aid_lis_sample_group_unit t1, t_aid_lis_apply_unit_detail t2
WHERE t1.apply_unit_id_chr = t2.apply_unit_id_chr
ORDER BY sample_group_id_chr, print_seq_int" ;
DataTable dtbSampleGroupDetail = null;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbSampleGroupDetail);
objHRPSvc.Dispose();
if (lngRes > 0 && dtbSampleGroupDetail != null)
{
if (dtbSampleGroupDetail.Rows.Count > 0)
{
if (dtbSampleGroupDetail.Rows.Count > 0)
{
objSampleGroupDetailVOList = new clsSampleGroupDetail_VO[dtbSampleGroupDetail.Rows.Count];
for (int i = 0; i < dtbSampleGroupDetail.Rows.Count; i++)
{
objSampleGroupDetailVOList[i] = new clsSampleGroupDetail_VO();
ConstructSampleGroupDetailVO(dtbSampleGroupDetail.Rows[i], ref objSampleGroupDetailVOList[i]);
}
}
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。
}
return(lngRes);
}
public long m_lngAddMedSendGiveRelation(System.Security.Principal.IPrincipal p_objPrincipal, out int p_intSeq,
clsMedSendConfig_VO p_objWinArr)
{
long lngRes = 0;
p_intSeq = 0; //流水号
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsMedStoreBseInfoSvc", "m_lngAddMedSendGiveRelation");
if (lngRes < 0)
{
return(-1);
}
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new com.digitalwave.iCare.middletier.HRPService.clsHRPTableService();
p_intSeq = Convert.ToInt32(objHRPSvc.m_strGetNewID("T_OPR_MEDSTOREWINRLT", "SEQ_INT", 6));
string strSQL = @"INSERT INTO T_OPR_MEDSTOREWINRLT
(SEQ_INT, TREATWINID_CHR, GIVEWINID_CHR,
ORDER_INT
)
VALUES (?,?,?,?)" ;
System.Data.IDataParameter[] paramArr = null;
objHRPSvc.CreateDatabaseParameter(4, out paramArr);
paramArr[0].Value = p_intSeq;
paramArr[1].Value = p_objWinArr.m_TreatWinID_chr;
paramArr[2].Value = p_objWinArr.m_GiveWinID_chr;
paramArr[3].Value = p_objWinArr.m_intOrder;
long lngRecordsAffected = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordsAffected, 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_lngSaveAll(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCDataVO[] p_objInsertArr, clsLisQCDataVO[] p_objUpdateArr, int[] p_intDelArr, out int[] p_intISeqArr)
{
p_intISeqArr = null;
long lngRes = 0;
com.digitalwave.security.clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngSaveAll");
objPrivilege = null;
if (lngRes <= 0)
{
return(lngRes);
}
if (p_objUpdateArr != null && p_objUpdateArr.Length > 0)
{
lngRes = m_lngUpdateByArr(p_objPrincipal, p_objUpdateArr);
if (lngRes <= 0)
{
ContextUtil.SetAbort();
}
}
if (p_objInsertArr != null && p_objInsertArr.Length > 0)
{
lngRes = m_lngInsertByArr(p_objPrincipal, p_objInsertArr, out p_intISeqArr);
if (lngRes <= 0)
{
p_intISeqArr = null;
ContextUtil.SetAbort();
}
}
if (p_intDelArr != null && p_intDelArr.Length > 0)
{
lngRes = m_lngDeleteByArr(p_objPrincipal, p_intDelArr);
if (lngRes <= 0)
{
ContextUtil.SetAbort();
}
}
p_intDelArr = null;
p_objInsertArr = null;
p_objUpdateArr = null;
return(lngRes);
}
public long m_mthGetGroupByID(System.Security.Principal.IPrincipal p_objPrincipal,
string strID, out clsReportDetail_VO[] objResult)
{
long lngRes = 0;
objResult = null;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReportMaintenanceSvc", "m_mthGetGroupByID");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "Select * From T_AID_RPT_GOP_DEF ";
if (strID.Trim() != "")
{
strSQL += " where RPTID_CHR = '" + strID + "'";
}
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 clsReportDetail_VO[dtResult.Rows.Count];
for (int i1 = 0; i1 < objResult.Length; i1++)
{
objResult[i1] = new clsReportDetail_VO();
objResult[i1].strReportID = dtResult.Rows[i1]["RPTID_CHR"].ToString().Trim();
objResult[i1].strGroupID = dtResult.Rows[i1]["GROUPID_CHR"].ToString().Trim();
objResult[i1].strGroupName = dtResult.Rows[i1]["GROUPNAME_CHR"].ToString().Trim();
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}