public long m_mthFindChargeItem(System.Security.Principal.IPrincipal p_objPrincipal, string strCatID, string strType, string strContent, out DataTable dt)
{
dt = new DataTable();
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsChargeItemSvc", "m_mthFindChargeItem");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
try
{
string strSQL = @"select a.ITEMID_CHR,a.ITEMCODE_VCHR,a.ITEMNAME_VCHR,a.ITEMSRCID_VCHR,a.ITEMSRCNAME_VCHR,b.assistcode_chr from t_bse_chargeitem A,t_bse_medicine B
where a.ITEMSRCID_VCHR =b.medicineid_chr(+) and a.ITEMCATID_CHR = '" + strCatID + "' order by a.ITEMCODE_VCHR";
if (strContent.Trim() != "")
{
strSQL = @"select a.ITEMID_CHR,a.ITEMCODE_VCHR,a.ITEMNAME_VCHR,a.ITEMSRCID_VCHR,a.ITEMSRCNAME_VCHR,b.assistcode_chr from t_bse_chargeitem A,t_bse_medicine B
where a.ITEMSRCID_VCHR =b.medicineid_chr(+) and a.ITEMCATID_CHR = '" + strCatID + "' AND " + strType + " LIKE '" + strContent + "%' order by a.ITEMCODE_VCHR";
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dt);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDelApplUnit(System.Security.Principal.IPrincipal p_objPrincipal, string strApplUnitID)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngDelApplUnit");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"DELETE FROM t_aid_lis_apply_unit WHERE apply_unit_id_chr = '" + strApplUnitID + "'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
long lngRecEff = -1;
lngRes = objHRPSvc.DoExcuteForDelete(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_lngFindAllSour(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable dtResult)
{
string strSQL = "select MEDICINESTDID_CHR ID,MEDICINESTDNAME_VCHR Name From T_BSE_MEDICINESTD";
dtResult = new DataTable();
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsChargeItemSvc", "m_GetGroupCat");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtResult);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetAllUserGroupApplUnitID(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable dtbApplUnit)
{
long lngRes = 0;
dtbApplUnit = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsAppGroupSvc", "m_lngAddApplUserRelation");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"SELECT DISTINCT apply_unit_id_chr FROM t_aid_lis_appuser_group_detail";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbApplUnit);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetDoctorDuty(out DataTable dt)
{
long lngRes = 0;
string SQL = @"select a.jxcode_chr, a.wbcode_chr, a.pycode_chr, a.dictname_vchr,
a.dictid_chr, a.dictkind_chr, a.dictseqid_chr, a.dictdefinecode_vchr
from t_aid_dict a
where dictid_chr <> '0' and dictkind_chr = '21'
order by to_number (dictid_chr)";
dt = new DataTable();
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(SQL, ref dt);
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="dtbResult"></param>
/// <returns></returns>
public long lngGetSamType(out DataTable dtbResult)
{
dtbResult = null;
long lngRes = 0;
string strSQL = " select sample_type_id_chr, sample_type_desc_vchr from t_aid_lis_sampletype order by sample_type_id_chr ";
clsHRPTableService objHRPServ = null;
try
{
objHRPServ = new clsHRPTableService();
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref dtbResult);
objHRPServ.Dispose();
dtbResult = dtbResult.DefaultView.ToTable();
}
catch (Exception objEx)
{
lngRes = 0;
clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogDetailError(objEx, true);
}
finally
{
objHRPServ = null;
}
return(lngRes);
}
/// <summary>
/// 获取系统时间
/// </summary>
/// <returns></returns>
public DateTime m_datGetServerDate()
{
DateTime datNow = DateTime.Now;
clsOPChargeSvc objServ = null;
try
{
objServ = (clsOPChargeSvc)clsObjectGenerator.objCreatorObjectByType(typeof(clsOPChargeSvc));
datNow = objServ.m_datGetSeverDate();
return(datNow);
}
catch (Exception objEx)
{
clsLogText objLogger = new clsLogText();
objLogger.LogError("连接中间件操作异常，" + objEx.Message);
}
finally
{
if (objServ != null)
{
objServ.Dispose();
objServ = null;
}
}
return(datNow);
}
public long m_lngDelete(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngDelete");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
try
{
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(p_intSeq);
long lngRecEff = -1;
lngRes = 0;
lngRes = objHRPSvc.lngExecuteParameterSQL(m_strDeleteSql, ref lngRecEff, objODPArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int p_intSeq, out clsLisQCSamplelotVO p_objQCSamplelot)
{
long lngRes = 0;
p_objQCSamplelot = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngFind");
if (lngRes <= 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
try
{
System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(p_intSeq);
DataTable dtbResult = null;
lngRes = 0;
lngRes = objHRPSvc.lngGetDataTableWithParameters(m_strFindSql, ref dtbResult, objODPArr);
objHRPSvc.Dispose();
if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0)
{
p_objQCSamplelot = new clsLisQCSamplelotVO();
this.ConstructVO(dtbResult.Rows[0], ref p_objQCSamplelot);
}
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngFindFeeList(System.Security.Principal.IPrincipal objPri,
ref DataTable dtResult)
{
com.digitalwave.security.clsPrivilegeHandleService clsSec = new clsPrivilegeHandleService();
long lngRes = clsSec.m_lngCheckCallPrivilege(objPri, "com.digitalwave.iCare.middletier.HIS.clsOPDoctorSvc", "m_lngFindWaitDiagList");
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = @"Select a.registertypeid_chr,a.paytypeid_chr,a.regfee,a.diagfee,
b.registertypename_vchr,c.paytypename_vchr from t_opPatRegAmount a,
t_bse_registertype b,t_bse_patientpaytype c
Where a.registertypeid_chr=b.registertypeid_chr
And a.paytypeid_chr=c.paytypeid_chr";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService HRPSvc = new clsHRPTableService();
lngRes = HRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtResult);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
lngRes = -2;
}
return(lngRes);
}
public long m_lngUPDateFeeList(System.Security.Principal.IPrincipal objPri,
clsPatRegFee_VO clsVO)
{
com.digitalwave.security.clsPrivilegeHandleService clsSec = new clsPrivilegeHandleService();
long lngRes = clsSec.m_lngCheckCallPrivilege(objPri, "com.digitalwave.iCare.middletier.HIS.clsOPDoctorSvc", "m_lngFindWaitDiagList");
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = @"UPDate t_opPatRegAmount Set regfee=?,diagfee=?
Where registertypeid_chr=? And paytypeid_chr=?";
System.Data.IDataParameter[] objPara = clsIDataParameterCreator.s_objConstructIDataParameterArr
(new object[] { clsVO.m_decRegFee, clsVO.m_decDiagFee, clsVO.m_strRegisterTypeID, clsVO.m_strPayTypeID });
try
{
long lngRec = 0;
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService HRPSvc = new clsHRPTableService();
lngRes = HRPSvc.lngExecuteParameterSQL(strSQL, ref lngRec, objPara);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
lngRes = -2;
}
return(lngRes);
}
/// <summary>
/// Query
/// </summary>
internal void Query()
{
DataRow dr = this.GetPatObj();
if (dr != null)
{
try
{
int n = -1;
object[] objs = new object[5];
objs[++n] = "763709818";
objs[++n] = "A74CC68F-B009-4264-A880-FBE87DD91E56";
objs[++n] = m_objViewer.LoginInfo.m_strEmpNo;//"0001";
objs[++n] = dr["patientid_chr"].ToString();
//objs[++n] = DateTime.Now.ToString("yyyy-MM-dd");
objs[++n] = Convert.ToDateTime(this.m_objViewer.QueryDate.Value).ToString("yyyy-MM-dd");
clsPublic.PlayAvi("加载妇幼平台界面，请稍候...");
string uri = string.Format(this.ServerIp + "/W_Fubao/AspCode/JiBenXinXi/HIS/Default.aspx?AUTHORID={0}&INFOID={1}&USER={2}&page=ChanJianTab&HISID={3}&DATE={4}&BARCODE=&HDSB0101005=&DEP=", objs);
com.digitalwave.Utility.clsLogText log = new clsLogText();
log.LogError(uri);
this.m_objViewer.webBrowser.Navigate(uri);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
clsPublic.CloseAvi();
}
}
}
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_lngModifyINSCOPAY(System.Security.Principal.IPrincipal p_objPrincipal, clsInsPay_VO objResult)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngModifyINSCOPAY");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDate T_AID_INSCOPAY Set " +
"COPAYNAME_CHR='" + objResult.m_strCOPAYNAME_CHR + "' " +
", PRECENT_DEC='" + objResult.m_dblPRECENT_DEC + "' " +
", USERCODE_CHR='" + objResult.m_strUSERCODE_CHR + "' " +
", REMARK_VCHR='" + objResult.m_strREMARK_VCHR + "' " +
", PLANID_CHR='" + objResult.m_strPLANID_CHR + "' " +
" Where COPAYID_CHR='" + objResult.m_strCOPAYID_CHR + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetMedShape(System.Security.Principal.IPrincipal p_objPrincipal, 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_lngGetMedShape");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"select * from t_aid_medicinepreptype";
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);
}
public long m_mthAddNewReportInfo2(System.Security.Principal.IPrincipal p_objPrincipal, clsReportDetail_VO obj_VO)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsReportMaintenanceSvc", "m_mthAddNewReportInfo2");
if (lngRes < 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
string strSQL = "INSERT INTO T_AID_RPT_GOP_DEF (RPTID_CHR,GROUPID_CHR,GROUPNAME_CHR) VALUES (?,?,?)";
try
{
System.Data.IDataParameter[] objLisAddItemRefArr = null;
objHRPSvc.CreateDatabaseParameter(3, out objLisAddItemRefArr);
objLisAddItemRefArr[0].Value = obj_VO.strReportID; //p_objRecord.m_strAPPID_CHR;
objLisAddItemRefArr[1].Value = obj_VO.strGroupID;
objLisAddItemRefArr[2].Value = obj_VO.strGroupName;
long lngRecEff = -1;
//往表增加记录
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objLisAddItemRefArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <summary>
/// 获取病区
/// </summary>
/// <param name="dtbResult"></param>
/// <returns></returns>
public long lngGetDeptName(out DataTable dtbResult)
{
dtbResult = null;
long lngRes = 0;
string strSQL = "select dictid_chr,dictname_vchr from t_aid_dict where trim(dictid_chr) <> '0' and dictkind_chr = '61'";
clsHRPTableService objHRPServ = null;
try
{
objHRPServ = new clsHRPTableService();
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref dtbResult);
objHRPServ.Dispose();
dtbResult = dtbResult.DefaultView.ToTable();
}
catch (Exception objEx)
{
lngRes = 0;
clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogDetailError(objEx, true);
}
finally
{
objHRPServ = null;
}
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);
}
/// <summary>
/// 获取所有抗生素
/// </summary>
/// <param name="dtbResult"></param>
/// <returns></returns>
public long lngGetAllAnti(out DataTable dtbResult)
{
dtbResult = null;
long lngRes = 0;
string strSQL = @"select t.antiid as 抗生素ID,t.cname as 抗生素名称,t.ename as 英文名称 from t_atb_anti t order by antiid ";
clsHRPTableService objHRPServ = null;
try
{
objHRPServ = new clsHRPTableService();
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref dtbResult);
dtbResult = dtbResult.DefaultView.ToTable();
}
catch (Exception objEx)
{
lngRes = 0;
clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogDetailError(objEx, true);
}
finally
{
objHRPServ = null;
}
return(lngRes);
}
public long m_lngGetempinfo(out DataTable dt, string empno)
{
long lngRes = 0;
dt = new DataTable();
string SQL = @"select empid_chr, lastname_vchr, psw_chr from t_bse_employee where status_int = 1 and empno_chr = ?";
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
IDataParameter[] ParamArr = null;
objHRPSvc.CreateDatabaseParameter(1, out ParamArr);
//((OracleParameter)ParamArr[0]).OracleDbType = OracleDbType.Char;
ParamArr[0].Value = empno;
lngRes = objHRPSvc.lngGetDataTableWithParameters(SQL, ref dt, ParamArr);
}
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_strStartDate"></param>
/// <param name="p_strEndDate"></param>
/// <param name="p_dtResult"></param>
/// <returns></returns>
internal long m_lngQueryArrearsPatientByDate(string p_strStartDate, string p_strEndDate, out DataTable p_dtResult, bool p_blnALL)
{
long lngRes = 0;
p_dtResult = null;
#region 中间件操作
clsOPChargeSvc objServ = null;
try
{
objServ = (clsOPChargeSvc)clsObjectGenerator.objCreatorObjectByType(typeof(clsOPChargeSvc));
lngRes = objServ.m_lngQueryArrearsPatientByDate(objPrincipal, p_strStartDate, p_strEndDate, out p_dtResult, p_blnALL);
}
catch (Exception objEx)
{
clsLogText objLogger = new clsLogText();
objLogger.LogError("连接中间件操作异常，" + objEx.Message);
}
finally
{
if (objServ != null)
{
objServ.Dispose();
objServ = null;
}
}
#endregion
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_lngGetOutPatientDefaultAddItem(out DataTable dt, string PayTypeID)
{
long lngRes = 0;
string SQL = @"select a.paytypeid_chr, a.itemid_chr, a.qty_dec, a.regflag_int, a.recflag_int,
a.dutyname_vchr, a.begintime_chr, a.endtime_chr, b.itemname_vchr,
b.ipchargeflg_int, b.itemprice_mny,
round (b.itemprice_mny / b.packqty_dec, 4) as submoney,
b.itemspec_vchr, b.itemunit_chr, b.itemipunit_chr,a.deptid_chr
from t_aid_outpatientdefaultadditem a, t_bse_chargeitem b
where a.itemid_chr = b.itemid_chr(+)
and a.paytypeid_chr = ?
order by a.begintime_chr";
dt = new DataTable();
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
IDataParameter[] ParamArr = null;
objHRPSvc.CreateDatabaseParameter(1, out ParamArr);
ParamArr[0].Value = PayTypeID;
lngRes = objHRPSvc.lngGetDataTableWithParameters(SQL, 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_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_lngDelApplyUnitDetailByApplyIDAndCheckItemID(System.Security.Principal.IPrincipal p_objPrincipal,
clsApplUnitDetail_VO p_objRecord)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsApplyUnitSvc", "m_lngDelApplyUnitDetailByApplyIDAndCheckItemID");
if (lngRes < 0)
{
return(-1);
}
string strSQL = @"DELETE FROM t_aid_lis_apply_unit_detail
WHERE check_item_id_chr = '" + p_objRecord.strCheckItemID + @"'
AND apply_unit_id_chr = '" + p_objRecord.strApplUnitID + "'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
long lngRecEff = -1;
lngRes = objHRPSvc.DoExcuteForDelete(strSQL, ref lngRecEff);
if (lngRecEff > -1)
{
lngRes = 1;
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDoUpdMethodByID(System.Security.Principal.IPrincipal p_objPrincipal, clsCookMethod_VO objResult)
{
long lngRes = 0;
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegTypeSvc", "m_lngDoUpdMethodByID");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = "UPDATE T_AID_CMCOOKINGMETHOD SET " +
"COOKINGMETHODNAME_VCHR = '" + objResult.m_strCookMethodName + "', " +
"MNEMONIC_CHR = '" + objResult.m_strMNemonic + "' " +
"WHERE COOKINGMETHODID_CHR = '" + objResult.m_strCookMethodID + "' ";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_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_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_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_mthWindowInfoByID(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable dt, string strExpen)
{
long lngRes = 0;
dt = new DataTable();
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsItemCatMappingSvc", "m_mthGetSubjectionCat");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
string strSQL = @"select windowid_chr,
windowname_vchr,
medstoreid_chr,
windowtype_int,
workstatus_int,
winproperty_int from T_BSE_MEDSTOREWIN where MEDSTOREID_CHR ='" + strExpen + "'";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dt);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
