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