del_phone_contract.asp

这是一个采用ASP技术的物业管理系统

<%--
title :
description :
@author : wangjn
copy right : copy right (@) 2002
date : 2002-04
--%>
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ include file="/inc/all.jsp" %>
<%@ page import = "com.excenon.core.*,com.excenon.core.db.*,com.xinghe.wuye.device.*" %>
<%@ page import = "com.xinghe.system.*,com.xinghe.wuye.phone.*,com.xinghe.wuye.*,com.xinghe.fee.calculate.*" %>
<%@ page import = "java.rmi.RemoteException,java.util.Vector,java.util.*,java.sql.Timestamp" %>
<%
// Create phone remote interface
SBPhoneHome phHome = (SBPhoneHome)EBBeanFactory.findEBHome("com.xinghe.wuye.phone.SBPhoneBean");
SBPhone phInterf = phHome.create();

// get parameter from request
String phoneContractID = ebString.jspr( request.getParameter("phonecontractid") ).gb();
String sQuery = "select * from wy_phone_contract where phonecontractid='"+phoneContractID+"'";
String buildingAreaID = MyFun.getColumnResult( sQuery,"buildingareaid" );
String buildingID = MyFun.getColumnResult( sQuery,"buildingid" );
String hstatus = MyFun.getColumnResult( sQuery,"status" );
if( hstatus.equals("生效") ){
%>
<jsp:forward page="back.jsp"  >
    <jsp:param name="failinfo" value="该电话合同正处在生效状态，您不能删除该合同!" />
</jsp:forward>
<%
}
// get uesr ACL
ACL[] mm_ACL = webUser.getA_acl();
// if this loginer can read or manage wuye model
boolean isReader = false, isManager = false, isWebManager = false;
isReader = AccessJudge.hasBuildingAreaRight( buildingAreaID,OperationType.TENANCY_MANAGE,mm_ACL );
isManager = AccessJudge.hasBuildingAreaRight( buildingAreaID,OperationType.TENANCY_MANAGE,mm_ACL );
String strDisabled = "";// disabled button
if( !isManager ){
%>
<jsp:forward page="back.jsp"  >
    <jsp:param name="failinfo" value="您没有删除电话合同的权限，请与管理员联系！" />
</jsp:forward>
<%
}

// insert to db
try{
    phInterf.delPhoneContract( phoneContractID );
%>
<jsp:forward page="back.jsp">
    <jsp:param name="sucinfo" value="成功删除电话合同"/>
    <jsp:param name="param_num" value="2" />
    <jsp:param name="name1" value="buildingarea" />
    <jsp:param name="value1" value="<%=buildingAreaID%>" />
	<jsp:param name="name2" value="building" />
    <jsp:param name="value2" value="<%=buildingID%>" />
    <jsp:param name="url" value="phonecontract_list.jsp" />
</jsp:forward>
<%
}catch( SysException se ){
%>
<jsp:forward page="back.jsp">
    <jsp:param name="stopPhoneContractSuc" value="<%=se.getInfo()%>"/>
</jsp:forward>
<%
}catch( BusinessException be ){
%>
<jsp:forward page="back.jsp">
    <jsp:param name="stopPhoneContractSuc" value="<%=be.getInfo()%>"/>
</jsp:forward>
<%}%>