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

📄 workmng.asp

📁 asp+access实现web环境中的企业实时考勤
💻 ASP
📖 第 1 页 / 共 5 页
字号:
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
        </select>时
        <select name="BMin">
          <option value="1">01</option>
          <option value="2">02</option>
          <option value="3">03</option>
          <option value="4">04</option>
          <option value="5">05</option>
          <option value="6">06</option>
          <option value="7">07</option>
          <option value="8">08</option>
          <option value="9">09</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
		  <option value="24">24</option>
		  <option value="25">25</option>
		  <option value="26">26</option>
		  <option value="27">27</option>
		  <option value="28">28</option>
		  <option value="29">29</option>
		  <option value="30">30</option>
          <option value="31">31</option>
          <option value="32">32</option>
          <option value="33">33</option>
		  <option value="34">34</option>
		  <option value="35">35</option>
		  <option value="36">36</option>
		  <option value="37">37</option>
		  <option value="38">38</option>
		  <option value="39">39</option>
		  <option value="40">40</option>
          <option value="41">41</option>
          <option value="42">42</option>
          <option value="43">43</option>
		  <option value="44">44</option>
		  <option value="45">45</option>
		  <option value="46">46</option>
		  <option value="47">47</option>
		  <option value="48">48</option>
		  <option value="49">49</option>
		  <option value="40">40</option>
          <option value="51">51</option>
          <option value="52">52</option>
          <option value="53">53</option>
		  <option value="54">54</option>
		  <option value="55">55</option>
		  <option value="56">56</option>
		  <option value="57">57</option>
		  <option value="58">58</option>
		  <option value="59">59</option>
        </select>分
<%end if%>
        <script language="JavaScript">       
              var LastModDate = new Date ; 
               document.form1.Byy.value=LastModDate.getYear();
               document.form1.Bmm.value=LastModDate.getMonth()+1;
            //   document.form1.Bdd.value=LastModDate.getDate();
        </script>
<%
end sub

sub EndTimeHtml()
%>
        <select name="Eyy">
          <option value="2000" selected>2000</option>
          <option value="2001">2001</option>
          <option value="2002">2002</option>
          <option value="2003">2003</option>
          <option value="2004">2004</option>
          <option value="2005">2005</option>
        </select>
        <select name="Emm">
          <option value="1" selected>01</option>
          <option value="2">02</option>
          <option value="3">03</option>
          <option value="4">04</option>
          <option value="5">05</option>
          <option value="6">06</option>
          <option value="7">07</option>
          <option value="8">08</option>
          <option value="9">09</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
        </select>
        <select name="Edd">
          <option value="1" selected>01</option>
          <option value="2">02</option>
          <option value="3">03</option>
          <option value="4">04</option>
          <option value="5">05</option>
          <option value="6">06</option>
          <option value="7">07</option>
          <option value="8">08</option>
          <option value="9">09</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
          <option value="24">24</option>
          <option value="25">25</option>
          <option value="26">26</option>
          <option value="27">27</option>
          <option value="28">28</option>
          <option value="29">29</option>
          <option value="30">30</option>
          <option value="31">31</option>
        </select>日
<%if gpy<>"Expert" then%>
        <select name="EHour">
          <option value="0">00</option>
          <option value="1">01</option>
          <option value="2">02</option>
          <option value="3">03</option>
          <option value="4">04</option>
          <option value="5">05</option>
          <option value="6">06</option>
          <option value="7">07</option>
          <option value="8" selected>08</option>
          <option value="9">09</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
        </select>时
        <select name="EMin">
          <option value="1">01</option>
          <option value="2">02</option>
          <option value="3">03</option>
          <option value="4">04</option>
          <option value="5">05</option>
          <option value="6">06</option>
          <option value="7">07</option>
          <option value="8">08</option>
          <option value="9">09</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
		  <option value="24">24</option>
		  <option value="25">25</option>
		  <option value="26">26</option>
		  <option value="27">27</option>
		  <option value="28">28</option>
		  <option value="29">29</option>
		  <option value="30">30</option>
          <option value="31">31</option>
          <option value="32">32</option>
          <option value="33">33</option>
		  <option value="34">34</option>
		  <option value="35">35</option>
		  <option value="36">36</option>
		  <option value="37">37</option>
		  <option value="38">38</option>
		  <option value="39">39</option>
		  <option value="40">40</option>
          <option value="41">41</option>
          <option value="42">42</option>
          <option value="43">43</option>
		  <option value="44">44</option>
		  <option value="45">45</option>
		  <option value="46">46</option>
		  <option value="47">47</option>
		  <option value="48">48</option>
		  <option value="49">49</option>
		  <option value="40">40</option>
          <option value="51">51</option>
          <option value="52">52</option>
          <option value="53">53</option>
		  <option value="54">54</option>
		  <option value="55">55</option>
		  <option value="56">56</option>
		  <option value="57">57</option>
		  <option value="58">58</option>
		  <option value="59">59</option>
        </select>分
<%end if%>
        <script language="JavaScript">       
              var LastModDate = new Date ; 
               document.form1.Eyy.value=LastModDate.getYear();
               document.form1.Emm.value=LastModDate.getMonth()+1;
               document.form1.Edd.value=LastModDate.getDate();
        </script>
<%
end sub

'////////////////////显示主界面
sub ShowLookHtml()
response.write "<html><head><meta HTTP-EQUIV='Pragma' CONTENT='no-cache'><meta http-equiv=refresh content='10;url=workmng.asp?KeyId="&KeyId&"'></head>"
 HtmlHead("考勤管理")
%>
<table width="550" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#7C7C7C" bordercolordark="#FFFFFF">
  <tr bgcolor="#FFFFFF" > 
    <td colspan=4 height=50> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" 9>
        <tr align=center> 
          <td> 
              <INPUT TYPE="button" name="submit" value="上班登记" onClick="window.location.href ='<%=UrlName&"?gpy=BeginWork&KeyId="&server.urlencode(KeyId)%>'" <%if numBegin1>=MBeginWork1 and numBegin1<=MBeginWork2 or numBegin2>=ABeginWork1 and numBegin2<=ABeginWork2 then response.write "&nbsp;" else response.write "disabled" end if%>>&nbsp;
			  <INPUT TYPE="button" name="submit" value="下班登记" onClick="window.location.href ='<%=UrlName&"?gpy=EndWork&KeyId="&server.urlencode(KeyId)%>'" <%if numEnd1>=MEndWork1 and numEnd1<=MEndWork2 or numEnd2>=AEndWork1 and  numEnd2<=AEndWork2 then response.write "&nbsp;" else response.write "disabled" end if%>>&nbsp;
			  <INPUT TYPE="button" name="submit" value="请假申请" onClick="window.location.href ='<%=UrlName&"?gpy=Holiday&LeaveMark=0&KeyId="&server.urlencode(KeyId)%>'">&nbsp;
			  <INPUT TYPE="button" name="submit" value="出差申请" onClick="window.location.href ='<%=UrlName&"?gpy=Holiday&LeaveMark=1&KeyId="&server.urlencode(KeyId)%>'">&nbsp;
			  <INPUT TYPE="button" name="submit" value="高级功能" onClick="window.location.href ='<%=UrlName&"?gpy=Expert&KeyId="&server.urlencode(KeyId)%>'">&nbsp;
			  <INPUT TYPE="button" name="submit" value="修正申请" onClick="window.location.href ='<%=UrlName&"?gpy=ModiTime&KeyId="&server.urlencode(KeyId)%>'">&nbsp;
		  </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr bgcolor="<%=TableTopBg%>" >
    <td>
       <table width='100%' border='1' cellspacing='0' cellpadding='0' bordercolorlight='#7C7C7C' bordercolordark='#FFFFFF'>
         <tr bgcolor="<%=TableTopBg%>" >
           <td class="pt2" colspan=6>今天考勤记录</td>
         </tr>
<%
  Query="select * from GpyWorkLog where WorkDate=#"&Date&"# order by LoginName desc"
  set sql=conn.Execute(Query)
%>
  <tr align=center> 
    <td rowspan=2 width="10" height="20" bgcolor="rgb(214,211,206)">&nbsp;</td>
    <td rowspan="2">姓&nbsp;&nbsp;名</td>
    <td colspan="2">上&nbsp;&nbsp;午</td>
    <td colspan="2">下&nbsp;&nbsp;午</td>
  </tr>
  <tr align=center> 
    <td >上&nbsp;&nbsp;班</td>
    <td >下&nbsp;&nbsp;班</td>
    <td >上&nbsp;&nbsp;班</td>
    <td >下&nbsp;&nbsp;班</td>
  </tr>
<%while not sql.eof 
 %>
        <tr bgcolor="#FFFFFF"> 
          <td width="10" height="20" bgcolor="rgb(214,211,206)">&nbsp;</td>
          <td class="pt2"><%=GetName("select Name from MyOper where LoginName='"&sql("LoginName")&"'")%></td>
          <td class="pt2"><%=sql("MBeginTime")%>&nbsp</td>
          <td class="pt2"><%=sql("MEndTime")%>&nbsp</td>
          <td class="pt2"><%=sql("ABeginTime")%>&nbsp</td>
          <td class="pt2"><%=sql("AEndTime")%>&nbsp</td>
		</tr>
<% 
  sql.movenext
  wend%>
	  </table>
     </td>
   </tr>
</table>
<%HtmlEnd
  end sub

sub ShowLook(sql)
  response.write "<title>请假申请处理</title>"
  HtmlHead ("处理"&MarkName(sql("LeaveMark"))&"申请")
%>
<SCRIPT language=JavaScript>
  <!--
  function checkvalue() {

⌨️ 快捷键说明

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