obj=request("tj")
if obj="修改" or obj="删除" then
dbrq=request("SY")&"-"& request("SM")&"-"&request("SD")
dbrq=cdate(dbrq)
dbsj=request.form("dbbc")
dbsj=cdate(dbsj)
else
dbrq=date()
dbsj=time()
if dbsj<#3:00:00# then
dbrq=dbrq-1
end if
end if
if dbsj>=#10:00:00# and dbsj<#19:0:00# then
bc="白班"
bctime=9
bcsjd="10:00-19:00"
elseif dbsj>=#3:00:00# and dbsj<#10:00:00# then
bc="夜班"
bctime=7
bcsjd="3:00-10:00"
else
bc="中班"
bctime=8
bcsjd="19:00-3:00"
end if
response.write bc&"("&bcsjd&"/计"&bctime&"小时)"
sb_n=split(get_sbname(),",")
sbs=ubound(sb_n)
set rs=server.createobject("adodb.recordset")
if obj="删除" then
sql="delete * from sbyxzt where rq=#"&dbrq&"# and bc="&bctime&""
rs.open sql,conn,3,1
response.write "的记录已删除<BR>请选择<a href='cx.asp'><font color=red>查询</font></a>进行查看。"
response.end
rs.close
conn.close
set rs=nothing
set conn=nothing
end if
dim sb_zt(20),sbyx_sj(20),sb_bz(20)
for i=0 to sbs
sql="select * from sbyxzt where rq=#"&dbrq&"# and bc="&bctime&" and sbname="&cint(i+1)&""
rs.open sql,conn,1,1
if rs.recordcount>0 then
sb_zt(i)=rs.fields("yxzt")
if rs.fields("yxsj_fz")=0 or IsNull(rs.fields("yxsj_fz")) then
sbyx_sj(i)=rs.fields("yxsj_xs")
elseif rs.fields("yxsj_fz")<10 then
sbyx_sj(i)=rs.fields("yxsj_xs")&".0"&rs.fields("yxsj_fz")
else
sbyx_sj(i)=rs.fields("yxsj_xs")&"."&rs.fields("yxsj_fz")
end if
sb_bz(i)=HTMLcode(rs.fields("bz"))
else
sb_zt(i)=0
sbyx_sj(i)=""
sb_bz(i)=""
end if
obj=request("tj")
if obj="修改" or obj="删除" then
dbrq=request("SY")&"-"& request("SM")&"-"&request("SD")
dbrq=cdate(dbrq)
dbsj=request.form("dbbc")
dbsj=cdate(dbsj)
else
dbrq=date()
dbsj=time()
if dbsj<#3:00:00# then
dbrq=dbrq-1
end if
end if
if dbsj>=#10:00:00# and dbsj<#19:0:00# then
bc="白班"
bctime=9
bcsjd="10:00-19:00"
elseif dbsj>=#3:00:00# and dbsj<#10:00:00# then
bc="夜班"
bctime=7
bcsjd="3:00-10:00"
else
bc="中班"
bctime=8
bcsjd="19:00-3:00"
end if
response.write bc&"("&bcsjd&"/计"&bctime&"小时)"
sb_n=split(get_sbname(),",")
sbs=ubound(sb_n)
set rs=server.createobject("adodb.recordset")
if obj="删除" then
sql="delete * from sbyxzt where rq=#"&dbrq&"# and bc="&bctime&""
rs.open sql,conn,3,1
response.write "的记录已删除<BR>请选择<a href='cx.asp'><font color=red>查询</font></a>进行查看。"
response.end
end if
%>
</td></tr>
<tr><td>
<%
dim sb_zt(20),sbyx_sj(20),sb_bz(20)
for i=0 to sbs
sql="select * from sbyxzt where rq=#"&dbrq&"# and bc="&bctime&" and sbname="&cint(i+1)&""
rs.open sql,conn,1,1
if rs.recordcount>0 then
sb_zt(i)=rs.fields("yxzt")
if rs.fields("yxsj_fz")=0 or IsNull(rs.fields("yxsj_fz")) then
sbyx_sj(i)=rs.fields("yxsj_xs")
elseif rs.fields("yxsj_fz")<10 then
sbyx_sj(i)=rs.fields("yxsj_xs")&".0"&rs.fields("yxsj_fz")
else
sbyx_sj(i)=rs.fields("yxsj_xs")&"."&rs.fields("yxsj_fz")
end if
sb_bz(i)=HTMLcode(rs.fields("bz"))
else
sb_zt(i)=0
sbyx_sj(i)=""
sb_bz(i)=""
end if
rs.close
%>
<table cellpadding="0" cellspacing="0" width="580">
<tr>
<td height="30" width="55"><font color=red><b><%=sb_n(i)%>
<input type="hidden" name="<%="sbname"&i%>" value="<%=sb_n(i)%>">
</b></font></td>
<td align="center" bgcolor="#F9F9F9" width="233">
<% if sb_zt(i)=1 then %>
<input type="radio" value="1" name="<%="sb"&i%>" checked>
<% else %>
<input type="radio" value="1" name="<%="sb"&i%>">
<%end if%>
运行
<% if sb_zt(i)=2 then %>
<input type="radio" value="2" name="<%="sb"&i%>" checked>
<% else %>
<input type="radio" value="2" name="<%="sb"&i%>">
<%end if%>
备用
<% if sb_zt(i)=3 then %>
<input type="radio" value="3" name="<%="sb"&i%>" checked>
<% else %>
<input type="radio" value="3" name="<%="sb"&i%>">
<%end if%>
自动
<% if sb_zt(i)=4 then %>
<input type="radio" value="4" name="<%="sb"&i%>" checked>
<% else %>
<input type="radio" value="4" name="<%="sb"&i%>">
<%end if%>
检修</td>
<td align="center" width="56"><font color="#0000FF">运行时间</font></td>
<td align="center" bgcolor="#F9F9F9" width="33">
<input type="text" name="<%="sbyxsj"&i%>" size="4" class="box" maxlength="4" value="<%=sbyx_sj(i)%>">
</td>
<td align="center" width="44"> <font color="#0000FF">备 注</font></td>
<td align="center" bgcolor="#F9F9F9" width="158">
<textarea rows="1" name="<%="sbbz"&i%>" cols="18" class="box"><%=sb_bz(i)%></textarea>
</td>
</tr>
</table>
<%
next
%>
</td></tr>
<tr><td align="center" height="40">
<input type="submit" value="提交" name="B1">
<input type="hidden" name="<%="sbs"%>" value="<%=sbs%>">
<input type="hidden" name="<%="rq"%>" value="<%=dbrq%>">
<input type="hidden" name="<%="bc"%>" value="<%=bc%>">
<input type="hidden" name="<%="dbbctime"%>" value="<%=bctime%>">
<input type="hidden" name="<%="obj"%>" value="<%=obj%>"><br/><br/>