viewcs.asp

asp+sql的教室申请系统,可以完成一个学期的教室分配情况

                          <% Call YuDFlag(CSID,ZhouCi,"Fri",2) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sat",2) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sun",2) %>
                      </div></td>
                    </tr>
                    <tr bgcolor="#F0F7F0">
                      <td><div align="center">3</div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Mon",3) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Tue",3) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Wed",3) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Thi",3) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Fri",3) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sat",3) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sun",3) %>
                      </div></td>
                    </tr>
                    <tr bgcolor="#F0F7F0">
                      <td><div align="center">4</div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Mon",4) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Tue",4) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Wed",4) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Thi",4) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Fri",4) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sat",4) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sun",4) %>
                      </div></td>
                    </tr>
                    
                    <tr bgcolor="#F0F7F0">
                    <td><div align="center">　</div></td>
                      <td><div align="center">中午</div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Mon",9) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Tue",9) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Wed",9) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Thi",9) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Fri",9) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sat",9) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sun",9) %>
                      </div></td>
                    </tr>
                    
                    <tr bgcolor="#F0F7F0">
                      <td rowspan="4"><div align="center">下<br>
                              <br>
        午</div></td>
                      <td><div align="center">5</div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Mon",5) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Tue",5) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Wed",5) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Thi",5) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Fri",5) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sat",5) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sun",5) %>
                      </div></td>
                    </tr>
                    <tr bgcolor="#F0F7F0">
                      <td><div align="center">6</div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Mon",6) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Tue",6) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Wed",6) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Thi",6) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Fri",6) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sat",6) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sun",6) %>
                      </div></td>
                    </tr>
                    <tr bgcolor="#F0F7F0">
                      <td><div align="center">7</div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Mon",7) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Tue",7) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Wed",7) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Thi",7) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Fri",7) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sat",7) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sun",7) %>
                      </div></td>
                    </tr>
                    <tr bgcolor="#F0F7F0">
                      <td><div align="center">8</div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Mon",8) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Tue",8) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Wed",8) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Thi",8) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Fri",8) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sat",8) %>
                      </div></td>
                      <td height="17"><div align="center">
                          <% Call YuDFlag(CSID,ZhouCi,"Sun",8) %>
                      </div></td>
                    </tr>
                  </table></td>
                </tr>
              </table></td>
              <td width="47%"><div align="center"><iframe src="Main.asp" frameborder="0" width="350" height="190" scrolling="no" id="main" name="main"></iframe>
              </div></td>
            </tr>
          </table> </td>
        </tr>
      </table>
      <!-- End ImageReady Slices -->
</div></td>
  </tr>
</table>
<!-- End ImageReady Slices -->
</body>
</html>
<%
rs.Close()
Set rs = Nothing
%>