?? main.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" errorPage="errpage.jsp" language="java" import="java.sql.*"%>
<%@include file="connect_odbc.jsp"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>浙江省臺州醫(yī)院職工網(wǎng)上訂餐系統(tǒng)</title>
<style type="text/css">
<!--
.style1 {
font-family: "宋體";
font-size: 24px;
font-weight: bold;
}
.style4 {font-family: "宋體"; font-size: 16px; font-weight: bold; }
-->
</style>
</head>
<%
int year,month,day;
int ii_ksdm = Integer.parseInt(session.getAttribute("ksdm").toString());
String ksmc = session.getAttribute("ksmc").toString();
int k=7;
GregorianCalendar calendar;
calendar=new GregorianCalendar();
year=calendar.get(Calendar.YEAR);
month=calendar.get(Calendar.MONTH)+1;//月份
day=calendar.get(Calendar.DAY_OF_MONTH);//天
//out.println(ksmc);
%>
<body bgcolor="#009999" onload="addAll()">
<div align="center">
<p class="style1">浙江省臺州醫(yī)院職工網(wǎng)上訂餐系統(tǒng)</p>
</div>
<form name="thisform" method="POST">
<div align="center"><font size="3" face="宋體">
預(yù)訂日期:</font>
<input name="year_start" type="text" maxlength="4" style="width: 40px; border-style: solid; border-color: #000080" size="20" onchange="addOption()" value=<%=year%>>
<font size="3" face="宋體">年</font>
<select size="1" name="month_start" onchange="addOption(1)">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
<font size="3" face="宋體">月</font>
<select name="day_start" size="1">
</select>
<font size="3" face="宋體">日
<INPUT TYPE=submit name="sub" value="刷新數(shù)據(jù)" style="font-family: 宋體; font-size: 10pt; border-style: ridge; border-color: #000080">
</div>
</form>
<div align="center">
<%
//變量定義
String syear=null,smonth=null,sday=null;
int zcsl=0,wcsl=0;
String ls_sysj;
syear=request.getParameter("year_start");
smonth=request.getParameter("month_start");
sday=request.getParameter("day_start");
if(syear==null)
{
syear=year+"";
}
else
{
year=Integer.parseInt(syear);
}
if(smonth==null)
{
smonth=month+"";
}
else
{
month=Integer.parseInt(smonth);
}
if(sday==null)
{
sday=day+"";
}
else
{
day=Integer.parseInt(sday);
}
ls_sysj=syear+"-"+smonth+"-"+sday+" 00:00:00";
String cdmc[] = new String[k];
int cdxh[] = new int[k] ;
int sysl=0;
int n=0;
for(int i=0;i<k;i++)
{
cdmc[i]="無";
}
for(int i=0;i<k;i++)
{
cdxh[i]=0;
}
request.getSession(true);
session.setAttribute("ksdm",ii_ksdm+"");
%>
<!-- 以下部分為中餐部分 -->
<form name="save_form" method="POST" action="savedata.jsp">
<div align="center">
<%
sql="select CDXH,CDMC,CDLX,SYSJ from YY_MRCD where SYSJ = to_date('"+ls_sysj+"','yyyy-mm-dd hh24:mi:ss') and CDCX=2 AND (CDLB = 1) order by CDXH";
//out.println(sql);
try{
rs=stmt.executeQuery(sql);
}
catch(SQLException se)
{
out.println(se.getMessage());
}
while(rs.next())
{
if(n<k)
{
cdxh[n]=rs.getInt(1);
cdmc[n]=rs.getString(2);
}
n++;
}
int saturday_lunch = -1,saturday_supper = -1 ;
int sunday_lunch = -1 ,sunday_supper = -1;
sql="SELECT XZFS,XZFS_WC,SATURDAY_LUNCH,SATURDAY_SUPPER,SUNDAY_LUNCH,SUNDAY_SUPPER FROM YY_KSDM WHERE KSDM ="+ii_ksdm+"";
rs=stmt.executeQuery(sql);
while(rs.next())
{
zcsl=rs.getInt(1);
wcsl=rs.getInt(2);
saturday_lunch=rs.getInt(3);
saturday_supper=rs.getInt(4);
sunday_lunch=rs.getInt(5);
sunday_supper=rs.getInt(6);
}
if(n>0)
{
%>
<span class="style4"><tt>以下為中餐,請輸入所需的份數(shù):</tt></span><br>
</div>
</div>
<table width="100%" border="1" align="center" cellspacing="0" bordercolor="#0000FF">
<tr>
<td width="87">
<div align="center">菜單名
</div></td>
<td width="113">
<div align="center"><%=cdmc[0]%>
</div></td>
<td width="113">
<div align="center"><%=cdmc[1]%>
</div></td>
<td width="113">
<div align="center"><%=cdmc[2]%>
</div></td>
<td width="113">
<div align="center"><%=cdmc[3]%>
</div></td>
<td width="113">
<div align="center"><%=cdmc[4]%>
</div></td>
<td width="113">
<div align="center"><%=cdmc[5]%>
</div></td>
<td width="113">
<div align="center"><%=cdmc[6]%>
</div></td>
</tr>
<tr>
<td width="87">
<div align="center">份數(shù)
</div></td>
<td width="113">
<%
sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+cdxh[0]+"";
rs=stmt.executeQuery(sql);
while(rs.next())
{
sysl=rs.getInt(1);
}
%>
<p align="center">
<input name="zc1" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
</p>
</td>
<td width="113">
<%
sysl=0;
sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+cdxh[1]+"";
rs=stmt.executeQuery(sql);
while(rs.next())
{
sysl=rs.getInt(1);
}
%>
<p align="center">
<input name="zc2" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
</p>
</td>
<td width="113">
<%
sysl=0;
sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+cdxh[2]+"";
rs=stmt.executeQuery(sql);
while(rs.next())
{
sysl=rs.getInt(1);
}
%>
<p align="center">
<input name="zc3" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
</p>
<%
sysl=0;
sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+cdxh[3]+"";
rs=stmt.executeQuery(sql);
while(rs.next())
{
sysl=rs.getInt(1);
}
%>
</td>
<td width="113">
<p align="center">
<input name="zc4" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
</p>
</td>
<td width="113">
<%
sysl=0;
sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+cdxh[4]+"";
rs=stmt.executeQuery(sql);
while(rs.next())
{
sysl=rs.getInt(1);
}
%>
<p align="center">
<input name="zc5" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
</p>
</td>
<td width="113">
<%
sysl=0;
sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+cdxh[5]+"";
rs=stmt.executeQuery(sql);
while(rs.next())
{
sysl=rs.getInt(1);
}
%>
<p align="center">
<input name="zc6" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
</p>
</td>
<td width="113">
<%
sysl=0;
sql="Select SYSL,SYRS FROM YY_EMPLOYE_DETAIL Where KSDM = "+ii_ksdm+" And CDXH = "+cdxh[6]+"";
rs=stmt.executeQuery(sql);
while(rs.next())
{
sysl=rs.getInt(1);
}
%>
<p align="center">
<input name="zc7" type="text" value=<%=sysl%> size="9" align="right" style="text-align: right">
</p>
</td>
</tr>
<%
}
else
{
out.print("對不起,今天營養(yǎng)科沒有配中餐!");
}
%>
<!-- 以下部分為晚餐操作 -->
</table>
<br>
<div align="center">
<%
int wcdxh[] = new int[k];
for(int i=0;i<k;i++)
{
cdmc[i]="無";
}
for(int i=0;i<k;i++)
{
wcdxh[i]=0;
}
n=0;
sql="select CDXH,CDMC,CDLX,SYSJ from YY_MRCD where SYSJ = to_date('"+ls_sysj+"','yyyy-mm-dd hh24:mi:ss') and CDCX=3 AND (CDLB = 1) ORDER BY CDXH";
try{
rs=stmt.executeQuery(sql);
}
catch(SQLException se)
{
out.println(se.getMessage());
}
while(rs.next())
{
if(n<k)
{
wcdxh[n]=rs.getInt(1);
cdmc[n]=rs.getString(2);
}
n++;
}
if(n>0)
{
%>
<span class="style4">以下為晚餐,請輸入所需的份數(shù):</span><br>
</div>
<table width="100%" border="1" align="center" cellspacing="0" bordercolor="#0000FF">
<tr>
<td width="87">
<div align="center">菜單名
</div></td>
<td width="113">
<div align="center"><%=cdmc[0]%>
</div></td>
<td width="113">
<div align="center"><%=cdmc[1]%>
</div></td>
<td width="113">
<div align="center"><%=cdmc[2]%>
</div></td>
<td width="113">
<div align="center"><%=cdmc[3]%>
</div></td>
<td width="113">
<div align="center"><%=cdmc[4]%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -