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);
}
private void m_SaveToVO(out clsPatRegFee_VO clsVO)
{
clsVO = new clsPatRegFee_VO();
clsVO.m_strPayTypeID = objfrm.ctlPatType.SelectItemValue;
clsVO.m_strRegisterTypeID = objfrm.ctlRegType.SelectItemValue;
clsVO.m_decRegFee = decimal.Parse(objfrm.m_txtRegFee.Text);
clsVO.m_decDiagFee = decimal.Parse(objfrm.m_txtDiagFee.Text);
}
public long m_lngFindFeeListByID(System.Security.Principal.IPrincipal objPri,
string RegTypeID, string PatTypeID, out clsPatRegFee_VO clsVO)
{
clsVO = new clsPatRegFee_VO();
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=? And a.paytypeid_chr=?
And a.registertypeid_chr=b.registertypeid_chr
And a.paytypeid_chr=c.paytypeid_chr";
System.Data.IDataParameter[] objPara = clsIDataParameterCreator.s_objConstructIDataParameterArr(new object[] { RegTypeID, PatTypeID });
try
{
DataTable dtResult = new DataTable();
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService HRPSvc = new clsHRPTableService();
lngRes = HRPSvc.lngGetDataTableWithParameters(strSQL, ref dtResult, objPara);
if (lngRes < 0)
{
return(lngRes);
}
if (dtResult.Rows.Count == 0)
{
return(0);
}
clsVO.m_strPayTypeID = PatTypeID;
clsVO.m_strRegisterTypeID = RegTypeID;
clsVO.m_decRegFee = decimal.Parse(dtResult.Rows[0]["regfee"].ToString().Trim());
clsVO.m_decDiagFee = decimal.Parse(dtResult.Rows[0]["diagfee"].ToString().Trim());
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
lngRes = -2;
}
return(lngRes);
}
