?? alarmadd.jsp
字號:
<%--
模塊名稱：個人助理
模塊功能：提醒增加
版 本：V1.0
著 作 人：蔡靜
著作日期：2001-11-12
使用說明：
主要技術說明：
參考文獻：法律事務設計書
修改歷史：= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：2001-11-25
修 改 人：Celts
修改理由：t_alerted表插入出錯
修改出處：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="system.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%
Security auth = new Security();
String employeeid = (String)session.getAttribute("employee_id");
if(employeeid == null || employeeid.equals(""))
{
response.sendRedirect(response.encodeRedirectURL("../Error/nonlogin.htm"));
}
String modelid = "Per010";
int authflag = auth.popedom(employeeid, modelid);
if(authflag == 0 || authflag == 2 || authflag == -1)
{
%>
<jsp:forward page="../inc/noauth.jsp" >
</jsp:forward>
<%
}
%>
<%
GetID gid = new GetID();
ExtendString es = new ExtendString();
String alertid = "JS" + es.digitToString(gid.getIDNumber("alert_id")+1);
String str = request.getParameter("save");
if (str!=null) {
String alert_id, alert_title, alert_thing, alert_fromtime, alert_totime;
alert_id = request.getParameter("alert_id");
alert_title = es.getStr(request.getParameter("alert_title"));
alert_thing = es.getStr(request.getParameter("alert_thing"));
alert_fromtime = request.getParameter("alert_fromtime") + " ";
alert_fromtime = alert_fromtime + request.getParameter("fromhour") + ":";
alert_fromtime = alert_fromtime + request.getParameter("fromminute");
alert_totime = request.getParameter("alert_totime") + " ";
alert_totime = alert_totime + request.getParameter("tohour") + ":";
alert_totime = alert_totime + request.getParameter("tominute");
String alerteds = request.getParameter("alertedlist");
String alerted[] = new String[20];
alerted = es.Split(";",alerteds);
String sql = "insert into t_alert(alert_id, alert_title, alert_thing,";
sql = sql + "alert_person, alert_fromtime, alert_totime) values ('";
sql = sql + alert_id + "','" + alert_title + "','" + alert_thing;
sql = sql + "','" + employeeid + "','" + alert_fromtime + "','";
sql = sql + alert_totime + "')";
int num = db.executeUpdate(sql);
if (num <= 0) {%>
<script language="javascript">
alert("新增失敗！");
</script>
<%}else {
gid.setIDNumber("alert_id", gid.getIDNumber("alert_id")+1);
alertid = "JS" + es.digitToString(gid.getIDNumber("alert_id")+1);
}
for (int i=0; i<es.length; i++) {
sql = "insert into t_alerted(alert_id, alerted_person,alert_state) values ('";
sql = sql + alert_id + "','" + alerted[i] + "','1')";
db.executeUpdate(sql);
}
}
%>
<html>
<head>
<title>提醒增加</title>
<%@ include file="../inc/config.jsp" %>
<script language="javascript">
function copyToList(from,to) //from表示:包含可選擇項目的select對象名字 to表示:列出可選擇項目的select對象名字 //你可以根據你的具體情況修改
{
fromList = eval("document.forms[0]." + from);
toList = eval("document.forms[0]." + to);
var sel = false;
for (i=0;i<fromList.options.length;i++)
{
var current = fromList.options[i];
if (current.selected)
{
sel = true;
if (current.value == "temp")
{
alert ("你不能選擇這個項目!");
return;
}
txt = current.text;
val = current.value;
if (toList.options.length > 0 && toList.options[0].value == 'temp')
{
toList.options.length = 0;
}
toList.options[toList.length] = new Option(txt,val);
fromList.options[i] = null;
i--;
}
}
if (!sel) alert ("你還沒有選擇任何項目");
}
function allSelect() //這是當用戶按下提交按鈕時，對列出選擇的select對象執行全選工作，讓遞交至的后臺程序能取得相關數據
{
List = document.form1.chosen;
alertedlist = "";
for (i=0; i<List.length; i++)
{
if (alertedlist == "")
alertedlist = List.options[i].value;
else
alertedlist = alertedlist + ";" + List.options[i].value;
}
document.form1.alertedlist.value = alertedlist;
}
</script>
</head>
<body class=page>
<script language="javascript">
function checkForm() {
if (document.form1.alert_title.value == "") {
alert("請輸入提醒標題！");
document.form1.alert_title.focus();
return false;
}
if (document.form1.alert_fromtime.value == "") {
alert("請輸入提醒開始時間！");
return false;
}
if (document.form1.alert_totime.value == "") {
alert("請輸入提醒結束時間！");
return false;
}
if (document.form1.alert_fromtime.value > document.form1.alert_totime.value) {
alert("提醒開始時間要小于提醒結束時間！");
document.form1.alert_fromtime.value = "";
document.form1.alert_totime.value = "";
return false;
}
else {
if (document.form1.alert_fromtime.value == document.form1.alert_totime.value) {
if (document.form1.fromhour.value > document.form1.tohour.value) {
alert("提醒開始時間要小于提醒結束時間！");
return false;
}
else {
if (document.form1.fromhour.value == document.form1.tohour.value) {
if (document.form1.fromminute.value > document.form1.tominute.value) {
alert("提醒開始時間要小于提醒結束時間！");
return false;
}
}
}
}
}
if ((document.form1.chosen.length == 0) ||
(document.form1.chosen.length == 1 && document.form1.chosen.options[0].value == "temp")) {
alert("請選擇被提醒人！");
return false;
}
if (document.form1.alert_thing.value == "") {
alert("請輸入提醒內容!");
document.form1.alert_thing.focus();
return false;
}
List = document.form1.chosen;
var alertedlist = "";
for (i=0; i<List.length; i++) {
if (alertedlist == "")
alertedlist = List.options[i].value;
else
alertedlist = alertedlist + ";" + List.options[i].value;
}
document.form1.alertedlist.value = alertedlist;
return true;
}
</script>
<!--顯示工具條-->
<table width="98%" align="center" cellspacing="1">
<tr>
<td><a href="Alarm1.jsp"><img src="../images/alarm.gif" width="88" height="22" border="0"></a>
<a href="Alarm1all.jsp"><img src="../images/alarm_all.gif" height="22" border="0" width="88"></a>
<a href="AlarmAdd.jsp"><img src="../images/add.gif" alt="增加內容" width="79" height="22" border="0"></a>
<img src="../images/delete.gif" alt="刪除選中的內容" style="cursor:hand" width="79" height="22">
<a href="Alarmall.jsp"><img src="../images/alarm_2.gif" width="88" height="22" border="0"></a></td>
<td align="right"><img src="../images/back.gif" width="50" height="22" onClick="window.history.back()" style="cursor:hand" alt="返回"></td>
</tr>
</table>
<table width="98%" background="../images/line.gif" border="0" cellspacing="0" cellpadding="0" height="12" align="center">
<tr>
<td> </td>
</tr>
</table>
<!--顯示工具條結束-->
<form name="form1" method="post" action="AlarmAdd.jsp">
<table width="98%" border="0" cellspacing="1" cellpadding="5" class="table_bg" align="center">
<tr>
<td width="21%" class="title_bg" align="right"> 提醒標題：</td>
<td width="79%" class="tr_bg1">
<input type="text" name="alert_title" size="70" class="input" maxlength="70">
<font color="#FF0000">*</font>
</td>
</tr>
<tr>
<td width="21%" class="title_bg" height="4" align="right"> 提醒開始時間：</td>
<td width="79%" class="tr_bg1" height="-2">
<input type="text" name="alert_fromtime" maxlength="10" size="10" value="" class="input" readOnly>
<img src="../images/datetime.gif" border="0" align="absmiddle"
alt="彈出日歷下拉菜單" onClick="fPopUpCalendarDlg(alert_fromtime);return false">
<select name="fromhour" class="select">
<%String temp = "";
for (int i=0; i<24; i++) {
if (i < 10)
temp = "0" + i;
else
temp = String.valueOf(i);
out.print("<option value=\""+temp+"\">"+temp+"</option>");
}
%>
</select>
：
<select name="fromminute" class="select">
<option value="00">00</option>
<option value="10">10</option>
<option value="20">20</option>
<option value="30">30</option>
<option value="40">40</option>
<option value="50">50</option>
</select>
<font color="#FF0000">*</font>
</td>
</tr>
<tr>
<td width="21%" class="title_bg" height="4" align="right"> 提醒結束時間：</td>
<td width="79%" class="tr_bg1" height="0">
<input type="text" name="alert_totime" maxlength="10" size="10" value="" class="input" readOnly>
<img src="../images/datetime.gif" border="0" align="absmiddle"
alt="彈出日歷下拉菜單" onClick="fPopUpCalendarDlg(alert_totime);return false">
<select name="tohour" class="select">
<%
for (int i=0; i<24; i++) {
if (i < 10)
temp = "0" + i;
else
temp = String.valueOf(i);
out.print("<option value=\""+temp+"\">"+temp+"</option>");
}
%>
</select>
：
<select name="tominute" class="select">
<option value="00">00</option>
<option value="10">10</option>
<option value="20">20</option>
<option value="30">30</option>
<option value="40">40</option>
<option value="50">50</option>
</select>
<font color="#FF0000">*</font>
</td>
</tr>
<tr>
<td width="21%" class="title_bg" height="9" align="right">被提醒人：</td>
<td width="79%" class="tr_bg1" height="9">
<table border="0" width="60%">
<tr>
<td>已經選擇</td>
<td> </td>
<td>沒有選擇</td>
</tr>
<tr>
<td>
<select name="chosen" size="4" multiple
width=200 style="width: 158; height: 100" class="select">
<option value="temp">從右邊選擇要提醒的人</option>
</select>
</td>
<td>
<input onClick="javascript:copyToList('possible','chosen')" type="button" value="<<添加" name="B5" class="button">
<br>
<input onClick="javascript:copyToList('chosen','possible')" type="button" value="刪除>>" name="B6" class="button">
</td>
<td>
<select name="possible" size="4" multiple
width=200 style="width: 148; height: 97" class="select">
<%
String employee_id, employee_name;
String sql = "select employee_id, employee_name from t_employee";
sql = sql + " order by employee_id";
ResultSet rs = db.executeQuery(sql);
while (rs.next()) {
employee_id = rs.getString("employee_id");
employee_name = rs.getString("employee_name");
out.print("<option value=\"" + employee_id + "\">" + employee_name + "</option>");
}
%>
</select>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="21%" class="title_bg" align="right"> 提醒內容：</td>
<td width="79%" class="tr_bg1">
<textarea name="alert_thing" rows="5" cols="70" class="input"></textarea>
<font color="#FF0000">*</font>
</td>
</tr>
</table>
<div align="center">
<input type="submit" name="save" value="保存" class="button" onClick="return checkForm()">
<input type="reset" name="reset" value="重寫" class="button">
<br>
</div>
<input type="hidden" name="alert_id" value=<%=alertid%>>
<input type="hidden" name="alertedlist">
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -