moddailyarragement.jsp

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,oa.main.DealString"%>
<%
oa.bean.dailyArragement myBean = null;
try{
	myBean = new oa.bean.dailyArragement();

	if(myBean.getConn()==null)
	{
		%>		
		数据库无法响应,请<a href="javascript:window.history.back(-1);">返回</a>重试
		<%out.close();
	}

	DealString ds = new DealString();
	//职工人员编号
	String strPersonNo = ds.toString((String)request.getParameter("txt_personno"));
	//日程序号
	String strRCXH = ds.toString((String)request.getParameter("txt_rcxh"));
	Hashtable hash = myBean.getOneData(strPersonNo,strRCXH);
 
	String strBT = (String)hash.get("BT");
	String strSJ = (String)hash.get("SJ");
	String strTXSJ = (String)hash.get("TXSJ");
	String strSFTX = (String)hash.get("SFTX");
	String strNR = (String)hash.get("NR");
	String tempstr = "";
%>
<br><br>
<table id="t1" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="D0E7FF" width="100%" height="2">
       <tr bgColor="#ffffff" height="22">
            &nbsp;&nbsp;&nbsp;&nbsp;
			<input type="button" value="提交" class=fashion onmouseover="msover();" onmouseout="msout();" onclick="return toServlet1(<%=strRCXH%>)">
			&nbsp;			
			<input type="button" value="返回" class=fashion onmouseover="msover();" onmouseout="msout();"onclick="javascript:history.back();">			
		 </td>
	   </tr>
     </table>


<TABLE WIDTH="95%" BORDER=0 CELLSPACING=1 CELLPADDING=0 ALIGN=center bgcolor="#ffffff">
<!--hr  noshade color="yellow"-->
  <col width="55%"><col width="45%">
  <TR CLASS=p9 valign=middle>
    <TD ALIGN=center BGCOLOR=#cc99cc nowrap height=20>
      <FONT COLOR=#ffffff >&nbsp;修改日程</FONT>
    </TD>
  </TR>
</TABLE>

<TABLE WIDTH="95%" BORDER=0 CELLSPACING=0 CELLPADDING=3 ALIGN=center style="table-layout:fixed;word-break:break-all">
  <tr align=center height=22  bgcolor="#E7E7E7">
    <td width="20%" align=center>日程标题：</td>
	<td width="50%" align=center><input type="text" size="30" value="<%=strBT%>" name="txtBT" class=txtframe></td>
	<td width="10%"></td>
  </tr>

  <tr align=center  bgcolor="#ffffff">
    <td width="20%" align=center>日程安排内容：</td>
	<td width="50%" align=center><textarea name="txtNR" cols="30" rows="15"><%=strNR%></textarea></td>
	<td width="10%"></td>
  </tr>

  <tr align=center height=22  bgcolor="#E7E7E7">
    <td width="20%" align=center>日程时间：</td>
	<td align=center valign=middle>
	  <input type="text" name="arraytimemod" size="20" value="<%=strSJ%>" readonly>
	  <a href="#" title="点击修改预警时间" onClick="fPopUpDlg('calendar.htm',document.all.arraytimemod,'winpop',172,230);return false;">
	   <img src="../images/DATETIME.GIF">
	  </a>
	</td>
	<td width="10%"></td>
  </tr>

  <tr align=center height=22  bgcolor="#ffffff">
    <td width="20%" align=center>是否提醒</td>
	<td align=center>
<%	if(strSFTX.equals("提醒"))
	{
		tempstr = strTXSJ;
%>
		<input type=radio name="txmod" value="yes" checked>是
		<input type=radio name="txmod" value="no">否	
<%	}
	else
	{	
		tempstr = "";
%>
		<input type=radio name="txmod" value="yes">是
		<input type=radio name="txmod" value="no" checked>否	
<%	}	%>
		</td>
	<td width="10%"></td>
  </tr>

  <tr align=center height=22  bgcolor="#E7E7E7">
    <td width="20%" align=center>提醒时间：</td>
	<td align=center>
	 <input type="text" name="txtimemod" size="20" value="<%=tempstr%>" readonly>
	  <a href="#" title="点击修改预警时间" onClick="fPopUpDlg('calendar.htm',document.all.txtimemod,'winpop',172,230);return false;">
	   <img src="../images/DATETIME.GIF">
	  </a>
	</td>
	<td width="10%"></td>
  </tr>		

</TABLE>
<script>
	function toServlet1(rcxh)
	{
		if(document.all.txtBT.value=="")
		{	alert("日程安排标题不能为空！");  return false; }
		if(document.all.txmod[0].checked==true && document.all.txtimemod.value=="")
		{	alert("请选择提醒时间！");   return false; }
		if(document.all.txmod[1].checked==true && document.all.txtimemod.value!="")
		{	alert("请确定是否设置提醒时间！");   return false; }

		document.all.txt_type.value = "2"; //个人日程安排表
		document.all.txt_edit.value = "2"; 

		//document.all.txt_rcxh.value = rcxh;
		document.all.form1.action="../../PerSvlt";
		document.all.form1.submit();
	}
</script>
<%}catch(Exception e){oa.main.Logger.log("ERROR:oa.person.modDailyArragement.jsp=>");e.printStackTrace(oa.main.Logger.log);}
finally{
	if(myBean!=null)myBean.closeConn();
}
%>