⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 query.php

📁 极限网络智能办公系统 Office Automation V3.0官方100%源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
?>

<html>
<head>
<title>维护记录管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script Language="JavaScript">
function td_calendar(fieldname)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;

  window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
</script>
</head>

<body class="bodycolor" topmargin="5">
<br>
<table border="0" width="500" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
  <form enctype="multipart/form-data" action="search.php"  method="post" name="form1">
    <tr>
      <td colspan="2" nowrap class="TableHeader">
      <img src="/images/green_arrow.gif"> 请指定查询条件:
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent" width="80"> 车 牌 号:</td>
      <td class="TableData" width="470">
        <select name="V_ID" class="BigSelect">
          <option value=""></option>
<?
$query = "SELECT * from VEHICLE order by V_NUM";
$cursor1= exequery($connection,$query);
while($ROW1=mysql_fetch_array($cursor1))
{
   $V_ID1=$ROW1["V_ID"];
   $V_NUM=$ROW1["V_NUM"];
?>
          <option value="<?=$V_ID1?>"><?=$V_NUM?></option>
<?
}
?>
        </select>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"> 维护日期:</td>
      <td class="TableData">
        <input type="text" name="BEGIN_DATE" size="10" maxlength="10" class="BigInput" value="">
        <img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar('form1.BEGIN_DATE');"> 至
        <input type="text" name="END_DATE" size="10" maxlength="10" class="BigInput" value="">
        <img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar('form1.END_DATE');">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"> 维护类型:</td>
      <td class="TableData">
        <SELECT name="VM_TYPE"  class="BigSelect">
          <option value=""></option>
          <option value="0">维修</option>
          <option value="1">加油</option>
          <option value="2">洗车</option>
          <option value="3">年检</option>
          <option value="4">其它</option>
        </SELECT>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"> 维护原因:</td>
      <td class="TableData">
        <input type="text" name="VM_REASON" size="30" maxlength="200" class="BigInput" value="">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"> 经 办 人:</td>
      <td class="TableData">

        <input type="text" name="VM_PERSON" size="10" maxlength="200" class="BigInput" value="">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"> 维护费用:</td>
      <td class="TableData">
        <input type="text" name="VM_FEE_MIN" size="10" maxlength="200" class="BigInput" value=""> 至
        <input type="text" name="VM_FEE_MAX" size="10" maxlength="200" class="BigInput" value="">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"> 备  注:</td>
      <td class="TableData">
        <input type="text" name="VM_REMARK" size="30" maxlength="200" class="BigInput" value="">
      </td>
    </tr>
    <tr align="center" class="TableControl">
      <td colspan="2" nowrap>
        <input type="submit" value="查询" class="BigButton">&nbsp;&nbsp;
        <input type="reset" value="重填" class="BigButton">
      </td>
    </tr>
  </table>
</form>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -