📄 modifyfinancialrecord.jsp
字号:
</tr>
</table>
<table width="800" border="0" bordercolor="#164DA8" align="center"
cellpadding="0" cellspacing="0">
<tr>
<td height="13"><img src=".././image/banner2.jpg" width="800"
height="12"></td>
</tr>
</table>
<table width=800 border=0 bgcolor=#164DA8 cellspacing=1 cellpadding=2
align=center>
<tr>
<td colspan=3>
<div align="center"><font color=white>
公司办公信息管理系统->公司财务信息管理系统->修改财务记录[当前用户- <%=session.getAttribute("Name")%>
] </font></div>
</td>
</tr>
<tr bgcolor=white>
<td><a href=".././html/home.jsp"><font color="#104DAD">返回系统主页</font></a></td>
<td align=center><%if (Warning == false) {%> <font color="#104DAD"><%=TheMessage%></FONT>
<%}
else {%> <font color=Red><%=TheMessage%></font> <%}%></td>
<td align=right><a href="finance.jsp"><font color="#104DAD">返回上一级网页</font></a></td>
</tr>
</table>
<table width="800" border="0" bordercolor="#164DA8" align="center"
cellpadding="0" cellspacing="0">
<tr>
<td height="13"><img src=".././image/banner2.jpg" width="800"
height="12"></td>
</tr>
</table>
<br>
<FORM ACTION="modifyfinancialrecord.jsp" METHOD=POST><%if (QueryLabel == 1) {%>
<TABLE CELLPADDING=1 CELLSPACING=2 BORDER=1 bordercolor="#164DA8"
WIDTH=800 align=center>
<TR VALIGN="middle" ALIGN="center">
<TD WIDTH=20% bgcolor=#B5C7EF><img src="../image/finance1.jpg"></td>
<td>
<table CELLPADDING=1 CELLSPACING=1 BORDER=1 align=center width=100%
bgcolor=White>
<tr height=35>
<td><input type=checkbox name=QueryCheck1 value="on"></td>
<td>财务记录ID</td>
<td><INPUT TYPE="text" NAME="FinancialRecordID" VALUE="" size=50></td>
</tr>
<tr height=35>
<td><input type=checkbox name=QueryCheck2 value="on"></td>
<td>财务项目名称</td>
<td><INPUT TYPE="text" NAME="FinancialProjectName" VALUE="" size=50>
</td>
</tr>
<tr height=35>
<td><input type=checkbox name=QueryCheck3 value="on"></td>
<td width=25％><font color="#164DA8">财务记录经手人</font></td>
<td><SELECT NAME="SelectName">
<%ResultSet RSPersons =
stmt.executeQuery("select Name from PSLogins order by Name");
while (RSPersons.next()) {
temp = RSPersons.getString("Name");%>
<OPTION VALUE="<%=temp%>"><%=temp%></OPTION>
<%}%>
</SELECT></td>
</tr>
<tr height=35>
<td><input type=checkbox name=QueryCheck4 value="on"></td>
<td width=25％><font color="#164DA8">财务记录添加日期</font></td>
<td><select name="AddYear" size=1>
<OPTION VALUE="<%=Year%>"><%=Year%></OPTION>
<%for (int YearCounter = 1990; YearCounter <= 2050; YearCounter++) {%>
<OPTION VALUE="<%=YearCounter%>"><%=YearCounter%></OPTION>
<%}%>
</select>年 <select name="AddMonth" size=1>
<OPTION VALUE="<%=Month%>"><%=Month%></OPTION>
<%for (int MonthCounter = 1; MonthCounter <= 12; MonthCounter++) {%>
<OPTION VALUE="<%=MonthCounter%>"><%=MonthCounter%></OPTION>
<%}%>
</select> 月 <select name="AddDay" size=1>
<OPTION VALUE="<%=Day%>"><%=Day%></OPTION>
<%for (int DayCounter = 1; DayCounter <= 31; DayCounter++) {%>
<OPTION VALUE="<%=DayCounter%>"><%=DayCounter%></OPTION>
<%}%>
</select>日</td>
</tr>
</table>
<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=1 WIDTH=100% align=center>
<TR VALIGN="top" ALIGN="center">
<TD WIDTH=100% align=center><INPUT TYPE="submit" NAME="Query"
VALUE="查询符合条件的财务记录"
style="border: 1px solid #3466BB; background-color: #B6CAEB; color: #3466BB">
</TD>
</TR>
<tr>
<td><div align="center">注意:您只能修改您作为会计经手人的财务记录！</div></td>
</tr>
</table>
</td>
</TR>
</table>
<br>
<%}%> <%if (QueryLabel == 2) {%>
<table width=800 border=0 bgcolor=#164DA8 cellspacing=1 cellpadding=2
align=center>
<tr>
<td><font color=white>选中</font></td>
<td><font color=white>记录ID</font></td>
<td><font color=white>记录经手人</font></td>
<td><font color=white>部门</font></td>
<td><font color=white>所属财务项目</font></td>
<td><font color=white>款项A</font></td>
<td><font color=white>款项B</font></td>
<td><font color=white>款项C</font></td>
<td><font color=white>款项D</font></td>
<td><font color=white>合计</font></td>
<td><font color=white>添加日期</font></td>
<td><font color=white>最新修改日期</font></td>
</tr>
<%int index = 0;
while (RSRecordResult.next()) {
index = RSRecordResult.getInt("ID");
out.println(
"<tr bgcolor=white><td><input type=radio name=RadioFinancialRecord value="
+ index
+ "></td>");
out.println("<td>" + index + "</td>");
out.println("<td>" + RSRecordResult.getString("Name") + "</td>");
out.println(
"<td>" + RSRecordResult.getString("Department") + "</td>");
out.println(
"<td>" + RSRecordResult.getString("ProjectName") + "</td>");
out.println(
"<td>" + RSRecordResult.getInt("FundTypeA") + "</td>");
out.println(
"<td>" + RSRecordResult.getInt("FundTypeB") + "</td>");
out.println(
"<td>" + RSRecordResult.getInt("FundTypeC") + "</td>");
out.println(
"<td>" + RSRecordResult.getInt("FundTypeD") + "</td>");
out.println("<td>" + RSRecordResult.getInt("Sum") + "</td>");
out.println(
"<td>"
+ RSRecordResult.getString("AddDate").substring(0, 10)
+ "</td>");
temp = RSRecordResult.getString("ModifyDate");
if (temp != null) {
temp = temp.substring(0, 10);
}
out.println("<td>" + temp + "</td></tr>");
}
%>
</table>
<table width="800" border="0" bordercolor="#164DA8" align="center"
cellpadding="0" cellspacing="0">
<tr>
<td height="13"><img src=".././image/banner2.jpg" width="800"
height="12"></td>
</tr>
</table>
<p align=center><input type=submit name=SelectRecord value=选中某条财务记录
style="border: 1px solid #3466BB; background-color: #FFFFFF; color: #3466BB">
<%}%> <%if (QueryLabel == 3) {%>
<TABLE CELLPADDING=1 CELLSPACING=2 BORDER=1 bordercolor="#164DA8"
WIDTH=800 align=center>
<TR VALIGN="middle" ALIGN="center">
<TD WIDTH=20% bgcolor=#B5C7EF><img src="../image/finance1.jpg"></td>
<td>
<table CELLPADDING=1 CELLSPACING=1 BORDER=1 align=center width=100%>
<tr>
<td width=30%>财务记录号</td>
<td><%=((Integer)HTThisRecord.get("ID")).intValue()%> <input
name=UpdateID type=hidden
value="<%=((Integer)HTThisRecord.get("ID")).intValue()%>"></td>
</tr>
<tr>
<td width=30%>财务记录添加日期</td>
<td><%=HTThisRecord.get("AddDate")%></td>
</tr>
<tr>
<td width=30%>经手人</td>
<td><Select name=UpdateName>
<option value="<%=HTThisRecord.get("Name")%>"><%=HTThisRecord.get("Name")%></option>
<%ResultSet RSPersons =
stmt.executeQuery("select Name from PSLogins order by Name");
while (RSPersons.next()) {
temp = RSPersons.getString("Name");
out.println("<option value=" + temp + ">" + temp + "</option>");
}%>
</select></td>
</tr>
<tr>
<td width=30%>所属财务项目</td>
<td><Select name=UpdateProjectName>
<option value="<%=HTThisRecord.get("ProjectName")%>"><%=HTThisRecord.get("ProjectName")%></option>
<%ResultSet RSFinancialProject =
stmt.executeQuery(
"select * from FinancialProject order by FinancialProjectName");
while (RSFinancialProject.next()) {
temp = RSFinancialProject.getString("FinancialProjectName");
out.println("<option value=" + temp + ">" + temp + "</option>");
}%>
</select></td>
</tr>
<tr>
<td width=30%>款项A</td>
<td><input name=UpdateFundTypeA
value="<%=((Integer)HTThisRecord.get("FundTypeA")).intValue()%>"></td>
</tr>
<tr>
<td width=30%>款项B</td>
<td><input name=UpdateFundTypeB
value="<%=((Integer)HTThisRecord.get("FundTypeB")).intValue()%>"></td>
</tr>
<tr>
<td width=30%>款项C</td>
<td><input name=UpdateFundTypeC
value="<%=((Integer)HTThisRecord.get("FundTypeC")).intValue()%>"></td>
</tr>
<tr>
<td width=30%>款项D</td>
<td><input name=UpdateFundTypeD
value="<%=((Integer)HTThisRecord.get("FundTypeD")).intValue()%>"></td>
</tr>
<tr>
<td width=30%>摘要</td>
<td><input name=UpdateSummary
value="<%=HTThisRecord.get("Summary")%>"></td>
</tr>
<tr>
<td width=30%>备注</td>
<td><input name=UpdateRemark value="<%=HTThisRecord.get("Remark")%>"></td>
</tr>
</table>
<p align=center><input type=submit name=UpdateRecord value=修改此条财务记录
style="border: 1px solid #3466BB; background-color: #FFFFFF; color: #3466BB">
<%}%>
</td>
</tr>
</table>
</FORM>
</BODY>
</HTML>
<%DBConnectionManager.getInstance().freeConnection("eims", conn);%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -