📄 u_scheme.jsp
字号:
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="cn.com.aheadsoft.business.SchemeBusiness,cn.com.aheadsoft.recordset.SchemeRecordSet"%>
<%@ page import="cn.com.aheadsoft.business.SchemeInfoBusiness,cn.com.aheadsoft.recordset.SchemeInfoRecordSet"%>
<%@ page import="cn.com.aheadsoft.business.SCHUserInfoBusiness,cn.com.aheadsoft.recordset.SCHUserInfoRecordSet"%>
<%@ page import="cn.com.aheadsoft.business.ApproveFlowBusiness,cn.com.aheadsoft.recordset.ApproveFlowRecordSet"%>
<%@ page import="cn.com.aheadsoft.business.TaskBusiness,cn.com.aheadsoft.recordset.TaskRecordSet"%>
<%@ page import="cn.com.aheadsoft.business.TeamBusiness,cn.com.aheadsoft.recordset.TeamRecordSet"%>
<%@ page import="cn.com.aheadsoft.manage.UserPurviewManage"%>
<%@ page import="cn.com.aheadsoft.util.UserInfo"%>
<%@ page import="cn.com.aheadsoft.util.ChangeByte"%>
<%
UserInfo ui=(UserInfo)request.getSession().getAttribute("userinfo");
UserPurviewManage upm=new UserPurviewManage();
boolean isHave=upm.getUserPop(ui,"6","4","u");
if(!isHave){
request.setAttribute("message",ChangeByte.I8859_1ToGB2312("你没有该权限，如有疑问请与系统管理员联系！"));
request.setAttribute("urllink","");
this.getServletContext().getRequestDispatcher("/jsp/srvmanage/info/message.jsp").forward(request,response);
return;
}
%>
<%
String schID=request.getParameter("theID").trim();
System.out.println("the schID is "+schID);
String tasID="";
String teaID="";
String schemeName="";//方案名
String leagureRequest="";//来宾要求
String schemeMemo="";//日程安排
String schemeMind="";//拟办意见
String recePersonID="";//接待负责人
String recePersonName="";//接待负责人
String leaderID="";//陪同领导
String leaderName="";//陪同领导
String personID="";//参与人员
String personName="";//参与人员
String outlayOutgo="";//预支
String outlayIncome="";//预收
String factOutlayOutgo="";//实际预支
String eaaPersonID="";//审批人
String eaaPersonName="";//审批人
String readyPersonID="";//拟办人ID
String readyPersonName="";//拟办人姓名
if(schID!=null){
SchemeBusiness schB=new SchemeBusiness();//方案信息
schB.setQueryWhere(schID);
int isOK=schB.execute("query");
SchemeRecordSet schRS=schB.getSchRecordSet();
System.out.println("======================"+schRS.size());
if(schRS.next()){
tasID=schRS.getTAS_ID();
teaID=schRS.getTEA_ID();
schemeName=schRS.getSCH_Name();
leagureRequest=schRS.getSCH_VisitorEquest();
schemeMemo=schRS.getSCH_ReceptionProject();
recePersonName=schRS.getSCH_ReceptionPrincipallName();
recePersonID=schRS.getSCH_ReceptionPrincipalID();
outlayOutgo=schRS.getSCH_OutlayOutgo();
outlayIncome=schRS.getSCH_OutlayIncome();
factOutlayOutgo=schRS.getSCH_OutlayNetOutgo();
//方案附加信息
SchemeInfoBusiness sciB=new SchemeInfoBusiness();
sciB.setQueryWhereforSCH(schID);
sciB.execute("query");
SchemeInfoRecordSet sciRS=sciB.getSciRecordSet();
while(sciRS.next()){
schemeMind=sciRS.getSCI_ReadyMind();
readyPersonID=sciRS.getSCI_ReadyPersonID();
readyPersonName=sciRS.getSCI_ReadyPersonName();
}
//查询陪同领导的信息
SCHUserInfoBusiness schuB=new SCHUserInfoBusiness();
schuB.setQueryfor(schID,true);
schuB.execute("query");
SCHUserInfoRecordSet schuRS=schuB.getSuiRecordSet();
while(schuRS.next()){
leaderName+=schuRS.getSUI_AccompanyPersonName()+",";
leaderID+=schuRS.getSUI_AccompanyPersonrID()+"#";
}
//查询参与接待人员信息
SCHUserInfoBusiness schuB1=new SCHUserInfoBusiness();
schuB1.setQueryfor(schID,false);
schuB1.execute("query");
SCHUserInfoRecordSet schuRS1=schuB1.getSuiRecordSet();
while(schuRS1.next()){
personName+=schuRS1.getSUI_AccompanyPersonName()+",";
personID+=schuRS1.getSUI_AccompanyPersonrID()+"#";
}
//查询审批信息
ApproveFlowBusiness apfB=new ApproveFlowBusiness();
apfB.setQueryWhereforByID(schID);
apfB.setQueryWhereforDate(false);
apfB.setQueryWhereforMind("backModify");
apfB.execute("query");
ApproveFlowRecordSet apfRS=apfB.getAfRecordSet();
while(apfRS.next()){
eaaPersonID+=apfRS.getAPF_FactEAAID()+"#";
eaaPersonName+=apfRS.getAPF_FactEAAName()+",";
}
}
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link rel="stylesheet" type="text/css" href="/krm/jsp/css/css.css">
<script src="/krm/jsp/jscript/Calendar.js"></script>
<script src="/krm/jsp/jscript/StringFormat.js"></script>
<script language="JavaScript">
function check(){
if(document.theform.uname.value.length<1){alert("请填写方案名称");document.theform.uname.focus();return false;}
if(document.theform.visitorEquest.value.length<1){alert("请填写来宾要求");document.theform.visitorEquest.focus();return false;}
if(document.theform.rp.value.length<1){alert("请填写日程安排");document.theform.rp.focus();return false;}
if(document.theform.rm.value.length<1){alert("请填写拟办意见");document.theform.rm.focus();return false;}
if(document.theform.rpName.value.length<1) {alert("请选择接待负责人");document.theform.rpName.focus();return false;}
if(document.theform.outlayOutgo.value.length<1){alert("请填写预支");document.theform.outlayOutgo.focus();return false;}
if(document.theform.outlayIncome.value.length<1){alert("请填写预收");document.theform.outlayIncome.focus();return false;}
if(document.theform.outlayNetOutgo.value.length<1){alert("请填写实际预支");document.theform.outlayNetOutgo.focus();return false;}
if(document.theform.afInfo1.value.length<1){alert("请选择审批人");return false;}
if(!isInt(document.theform.outlayOutgo.value)){alert("你在预支一栏填写有误，你只能填写整整数");return false;}
if(!isInt(document.theform.outlayIncome.value)){alert("你在预收一栏填写有误，你只能填写整整数");return false;}
if(!isInt(document.theform.outlayNetOutgo.value)){alert("你在实际预支一栏填写有误，你只能填写整整数");return false;}
document.theform.submit();
document.theform.submit();
}
function checkCharge(){
var outin=document.theform.outlayIncome.value;
var outgo=document.theform.outlayOutgo.value;
if(outin.length>0 && outgo.length>0){
document.theform.outlayNetOutgo.value=outgo-outin;
}
}
function openWindow(theURL,winName,features) {
window.open(theURL,winName,features);
}
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
<table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
<form name="theform" action="/krm/servlet/receiveregisterservlet?module=modifyScheme&theID=<%=schID%>" method="post" onSubmit="return false;">
<tr >
<td class="trA"> 您的位置：行政管理 >> 接待管理 >> <font class="fontcolor"> 修改方案</font></td>
</tr>
<tr height="8">
<td >
</td>
</tr>
<td align="center">
<table width="98%" border="0" cellpadding="0" cellspacing="0" bordercolor="A1B7DB" class="collapse">
<tr >
<td class="tdA" colspan="7">
修改接待方案
</td>
</tr>
<tr class="common">
<td width="14%" valign="middle" class="common bgcolor"> 所属接待<br> 任务：</td>
<td colspan="5" valign="middle" class="common"><select name="tasID">
<%
//找到方案对应的接待任务信息
String tasname="";
TaskBusiness taskB=new TaskBusiness();
taskB.setQueryfinish(false);
taskB.execute("query");
TaskRecordSet taskRS=taskB.getTaskRecordSet();
while(taskRS.next()){
if(taskRS.getTAS_ID().trim().equals(tasID.trim())){
tasname=taskRS.getTAS_Name();
break;
}
}
%>
<option value="<%=tasID.trim()%>" selected><%=tasname%></option>
</select> <font color="#FF0000">*</font>
</td>
</tr>
<tr class="common">
<td valign="middle" class="common bgcolor"> 接待的团<br> 队为：</td>
<td colspan="5" valign="middle" class="common"><select name="teaID">
<%
//照到方案对应的来访团队信息
String teamname="";
TeamBusiness teamB=new TeamBusiness();
teamB.setQueryWhereforTable();
teamB.execute("query");
TeamRecordSet teaRS=teamB.getTeamRecordSet();
while(teaRS.next()){
if(teaRS.getTEA_ID().trim().equals(teaID.trim())){
teamname=teaRS.getTEA_Name();
break;
}
}
%>
<option value="<%=teaID.trim()%>" selected><%=teamname%></option>
</select> </td>
</tr>
<tr class="common">
<td valign="middle" class="common bgcolor"> 方案名称：</td>
<td colspan="5" valign="middle" class="common"><input name="uname" type="text" size="60" class="long" readyOnly="true" value="<%=schemeName%>">
</td>
</tr>
<tr class="common">
<td valign="middle" class="common bgcolor"> 来宾要求：</td>
<td colspan="5" valign="middle" class="common"><input name="visitorEquest" type="text" size="60" class="long" value="<%=leagureRequest%>"></td>
</tr>
<tr class="common">
<td class="common bgcolor"> 接待日程<br> 安排：</td>
<td colspan="5" valign="middle" class="common"><textarea name="rp" cols="80" rows="6"><%=schemeMemo%></textarea></td>
</tr>
<tr class="common">
<td valign="middle" class="common bgcolor" > 拟办意见：</td>
<td colspan="5" valign="middle" class="common"><textarea name="rm" cols="60"><%=schemeMind%></textarea></td>
</tr>
<tr class="common">
<td valign="middle" class="common bgcolor"> 接待负责<br> 人：</td>
<td colspan="2" valign="middle" class="common"><input type="text" name="rpName" class="short" value="<%=recePersonName%>">
<a href="javascript:openWindow('/krm/servlet/UserSelectServlet?link1=theform.rpID&link2=theform.rpName','selectuser','width=500,height=300')"><img src="/krm/jsp/image/selectperson.gif" width="20" border="0"></a>
<input type="hidden" name="rpID" value="<%=recePersonID%>">
</td>
<td width="80" valign="middle" class="common bgcolor"> 陪同领导：</td>
<td colspan="2" valign="middle" class="common"><input type="text" name="apnh1" class="middle" value="<%=leaderName%>">
<a href="javascript:openWindow('/krm/servlet/UserSelectServlet?src1=theform.apnh&src2=theform.apnh1','selectuser','width=500,height=300')"><img src="/krm/jsp/image/selectperson.gif" width="20" border="0"></a>
<input type="hidden" name="apnh" value="<%=leaderID%>">
</td>
</tr>
<tr class="common">
<td valign="middle" class="common bgcolor"> 参与接待<br> 人员：</td>
<td colspan="5" valign="middle" class="common"><input name="apng1" type="text" class="middle" value="<%=personName%>">
<a href="javascript:openWindow('/krm/servlet/UserSelectServlet?src1=theform.apng&src2=theform.apng1','selectuser','width=500,height=300')"><img src="/krm/jsp/image/selectperson.gif" width="20" border="0"></a>
<input type="hidden" name="apng" value="<%=personID%>">
</td>
</tr>
<tr class="common">
<td valign="middle" class="common bgcolor"> 经费预算：</td>
<td valign="middle" class="common bgcolor"> 预支：
<input name="outlayOutgo" type="text" class="short" value="<%=outlayOutgo%>">元</td>
<td colspan="3" valign="middle" class="common bgcolor"> 预收：
<input name="outlayIncome" type="text" class="short" value="<%=outlayIncome%>">元</td>
<td valign="middle" class="common bgcolor"> 实际预支：
<input name="outlayNetOutgo" type="text" class="short" onFocus="checkCharge();" value="<%=factOutlayOutgo%>">元</td>
</tr>
<tr class="common">
<td valign="middle" class="common bgcolor"> 下步操作：</td>
<td colspan="3" valign="middle" class="common"><select name="mind">
<option vlaue="请你审批">请你审批</option>
</select>
<input type="text" name="afInfo1" class="short" readOnly="true" value="<%=eaaPersonName%>">
<input type="hidden" name="afInfo" value="<%=eaaPersonID%>">
</td>
<td colspan="1" valign="middle" class="common">拟办者：</td>
<td valign="middle" class="common"><input type="text" name="rrpn" class="short" readOnly="true" value="<%=readyPersonName%>">
<input type="hidden" name="rrp" value="<%=readyPersonID%>">
</td>
</tr>
<tr class="common">
<td valign="middle" class="common bgcolor"> 送审方式：</td>
<td colspan="5" valign="middle" class="common"> <input type="radio" name="sm" value="N" checked>网上审批
</td>
</tr>
<tr>
<td align="center" colspan="6">
<input name="button" type="submit" onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" value="提 交" onClick="javascript:check();">
<input name="button" type="button" onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" value="返 回" onClick="history.back(-1);"> </td>
</tr>
</table>
</td>
</tr>
</form>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -