func_print.asp

企业办公简单管理系统,可以发布信息以及论坛

<SCRIPT LANGUAGE="JavaScript">
<!--
function CheckInput()
{
	if(!dochange(document.theform.Quotient))
		return false;
		
	return true;
}	
function dochange(object)
{
		var i,strText,s;
		s=object.value;
		strText="请输入正确值，必须用阿拉伯数字填写";
		 for (i = 0; i < s.length; i++)
		{   
			// Check that current character is number.
			var c = s.charAt(i);
			if (!(((c >= "0") && (c <= "9")) || c == "."))
			{
				object.focus();
				window.alert(strText);
				
				return false;
			}
		}
		return true;
}		
//-->
</SCRIPT>

<!-- #include file="func_verify.asp" -->
<%

dim sumcount,saveserial

set rs = Server.CreateObject("ADODB.Recordset")


if request("saveflag")<>"" then
	dim msg
	saveserial=1
	msg=""

	if trim(request("printid"))="" then
		msg=msg & saveserial & "、请选择印章名称!<br>"
		saveserial=saveserial+1
	end if

	if trim(request("quotient"))="" then
		msg=msg & saveserial & "、请输入印数!<br>"
		saveserial=saveserial+1
	end if
	if trim(request("Memo"))="" then
		msg=msg & saveserial & "、请输入用印事由!<br>"
		saveserial=saveserial+1
	end if
	if request("wfid")="" then
		msg=msg & saveserial & "、请选择发起工作流!<br>"
		saveserial=saveserial+1
	end if
	if saveserial<=1 then
		maxid=getmaxid(request("wfid"))
		
		sql="select * from cci_oa_print"
		rs.open sql,connobj,3,3
		rs.addnew
		
		rs("wfid")=maxid
		rs("userid")=session("userid")
		rs("deptid")=session("deptid")
		
		rs("isout")=request("isout")
		rs("Memo")=trim(request("Memo"))
		rs("printid")=request("printid")
		rs("quotient")=request("quotient")
		rs("usetime")=request("year") & "-" & request("month") & "-" & request("day") & " 00:00:00"
		rs("rettime")=request("year1") & "-" & request("month1") & "-" & request("day1") & " 00:00:00"

		rs("InDate")=now
		rs.update
		rs.close
		
		sql="select * from cci_oa_flowlist where id="& maxid
		rs.open sql,connobj,3,3
		if not rs.eof then
			rs("title")="关于"& session("name") & "的『用印申请』"
			rs.update
		end if
		rs.close
		
		response.redirect "message.asp?rediurl=defaultA.asp&msgurl=首页&msginfo=用印申请操作成功！请耐心等待领导审批!"

		
	end if
	response.Write("<div align=center><font color=#FF0000>" &msg & "</font></div>")
end if





%>

  
<table width="100%" align="center" cellpadding="1" cellspacing="1" class=tableborder1>
  <form name="theform" method="post" action="" onSubmit="return CheckInput()">
    <tr > 
      <th height="25" colspan="6" align="center" class=TopLighNav>用印申请表</th>
    </tr>
    <tr> 
      <td width="90" align="center" class=TopLighNav><b>部门</b></td>
      <td width="100" align="center" class=TopLighNav><%
	  
	  sql="select deptname from cci_dept where id=" & session("deptid")
	  rs.open sql,connobj,1,1
	  if not rs.eof then
	  	response.Write rs("deptname")
	  end if
	  rs.close
	  
	  %></td>
      <td width="80" align="center" class=TopLighNav><b>姓名</b></td>
      <td width="80" align="center" class=TopLighNav><%=session("name")%></td>
      <td width="80" align="center" class=TopLighNav><b>职务</b></td>
      <td align="center" class=TopLighNav><%
	  
	  sql="select stationname from cci_station where id=" & session("stationid")
	  rs.open sql,connobj,1,1
	  if not rs.eof then
	  	response.Write rs("stationname")
	  end if
	  rs.close
	  
	  %></td>
    </tr>
    <tr > 
      <td class=tablebody1 align="center"><b>用印事由</b></td>
      <td colspan="5" class=tablebody1 align="left"><textarea name="Memo" cols="75" rows="8"><%=request("Memo")%></textarea></td>
    </tr>
    <tr>
      <td align="center" class=tablebody1><b>用印名称</b></td>
      <td colspan="2" class=tablebody1><select name=printid>
          <%
	  		sql="select * from cci_oa_printin"
			Rs.Open Sql,connObj,1,1
			flag=0
			do while not rs.eof
				if stationCode=rs("id") then
					flag=1
				 	response.Write "<option value=" & rs("id") & " selected>" & rs("printName") & "</option>"
				else
					response.Write "<option value=" & rs("id") & ">" & rs("printName") & "</option>"
				end if				
				rs.movenext
			loop
		rs.close
	  	if flag<>1 then
			response.Write "<option selected></option>"
		else
			response.Write "<option></option>"	
		end if	
	  %>
        </select></td>
      <td class=tablebody1><b>份数</b></td>
      <td colspan="2" class=tablebody1><input name="Quotient" type="text" id="Quotient" size="4" maxlength="4">(份)</td>
    </tr>
	 <tr > 
      <td class=tablebody1 align="center"><b>外出使用</b></td>
      <td colspan="5" class=tablebody1 align="left"><select name=isout>
	  <option value=0 selected>否</option>
	  <option value=1>是</option>
	  </select></td>
    </tr>
    <tr> 
      <td align="center" class=tablebody1><b> 使用时间</b></td>
      <td colspan="2" class=tablebody1><!-- #include file="func_currtime.asp" --></td>
      <td class=tablebody1><b>归还时间</b></td>
      <td colspan="2" class=tablebody1><!-- #include file="func_currtime1.asp" --></td>
    </tr>
	   <tr >
      <td class=tablebody1 align="center"><b>工作流发起</b></td>
      <td colspan="5" class=tablebody1 align="left"><select name="wfid">
	  <%
	  	sql="select * from cci_oa_wfdefine where taskid=13"
		Rs.Open Sql,connObj,1,1
		do while not rs.eof
			response.Write "<option value=" & rs("id") & ">" & rs("wfname")& "</option>"
			rs.movenext
	  	loop
		rs.close
	  %></select>
	  </td>
    </tr>
    <tr> 
      <td colspan="6" align="center" class=tablebody1><input type="submit" name="Submit" value=" 申 请 "></td>
    </tr>
    <input type=hidden name=saveflag value="1">
  </form>
</table>