开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Jsp/Servlet > 查看源码
desktop_old.jsp
资源名称：JSP-OA.rar　[点击查看]
上传用户：jhtang88
上传日期：2014-01-27
资源大小：28528k
文件大小：22k
源码类别：

Jsp/Servlet

开发平台：

Java

desktop_old.jsp：源码内容
  1. <%@ page contentType="text/html;charset=gb2312"%>
  2. <%@ page import = "java.net.URLEncoder"%>
  3. <%@ page import = "com.redmoon.oa.db.PageQuery"%>
  4. <%@ page import = "com.redmoon.oa.db.Conn"%>
  5. <%@ include file="inc/inc.jsp"%>
  6. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  7. <html>
  8. <head>
  9. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  10. <title>我的办公桌</title>
  11. <link href="common.css" rel="stylesheet" type="text/css">
  12. <jsp:useBean id="fchar" scope="page" class="cn.js.fan.util.StrUtil"/>
  13. <jsp:useBean id="privilege" scope="page" class="com.redmoon.oa.pvg.Privilege"/>
  14. <jsp:useBean id="cfgparser" scope="page" class="fan.util.CFGParser"/>
  15. <%
  16. String user = privilege.getUser(request);
  17. String pwd = privilege.getPwd(request);
  18. int i = 0;
  19. cfgparser.parse("config.xml");
  20. Properties props = cfgparser.getProps();
  21. String serveraddr = props.getProperty("serveraddr");
  22. String serverport = props.getProperty("serverport");
  23. String virtualpath = props.getProperty("virtualpath");
  25. Calendar cal = Calendar.getInstance();
  26. int curday = cal.get(cal.DAY_OF_MONTH);
  27. int curmonth = cal.get(cal.MONTH)+1;
  28. int curyear = cal.get(cal.YEAR);
  29. String curdate = curyear+"-"+curmonth+"-"+curday;
  31. String myname = privilege.getUser(request);
  32. String fromwhom = "";
  33. %>
  34. <%@ include file="inc/nocache.jsp"%>
  35. <script language="JavaScript" type="text/JavaScript">
  36. <!--
  37. function MM_preloadImages() { //v3.0
  38.   var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
  39.     var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
  40.     if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
  41. }
  42. //-->
  43. </script>
  44. <script language=javascript>
  45. <!--
  46. function openWin(url,width,height)
  47. {
  48.   var newwin=window.open(url,"_blank","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,top=50,left=120,width="+width+",height="+height);
  49. }
  51. var filename1,document_id1;//全局变量，用于记录编辑中的文件名和文件id
  52. function editdoc(filename,document_id)
  53. {
  54. var user = "<%=user%>"
  55. var pwd = "<%=pwd%>"
  56. filename1 = filename;
  57. document_id1 = document_id;
  58. useword.OpenWordDoc("http://<%=serveraddr%>:<%=serverport%>/<%=virtualpath%>/getdoctomodify.jsp?user="+user+"&pwd="+pwd+"&filename="+filename+"&document_id="+document_id);
  59. }
  61. function uploaddoc() {
  62.     var document_id = document_id1;
  63. var filename = filename1;
  64. var user = "<%=user%>"
  65. var pwd = "<%=pwd%>"
  66. var fieldstr = "rn--AaB03xrnContent-Disposition: form-data; name="filename"rnrn"+filename+"rn--AaB03x--";
  67. fieldstr += "rn--AaB03xrnContent-Disposition: form-data; name="user"rnrn"+user+"rn--AaB03x--";
  68. fieldstr += "rn--AaB03xrnContent-Disposition: form-data; name="pwd"rnrn"+pwd+"rn--AaB03x--";
  69. fieldstr += "rn--AaB03xrnContent-Disposition: form-data; name="document_id"rnrn"+document_id+"rn--AaB03x--";
  70. useword.UploadDoc(fieldstr);
  71. }
  73. //--------------展开任务----------------------------
  74. function loadThreadFollow(b_id,t_id,getstr){
  75. var targetImg2 =eval("document.all.followImg" + t_id);
  76. var targetTR2 =eval("document.all.follow" + t_id);
  77. if (targetImg2.src.indexOf("nofollow")!=-1){return false;}
  78. if ("object"==typeof(targetImg2)){
  79. if (targetTR2.style.display!="")
  80. {
  81. targetTR2.style.display="";
  82. targetImg2.src="sq/forum/images/minus.gif";
  83. if (targetImg2.loaded=="no"){
  84. document.frames["hiddenframe"].location.replace("task_tree.jsp?id="+b_id+getstr);
  85. }
  86. }else{
  87. targetTR2.style.display="none";
  88. targetImg2.src="sq/forum/images/plus.gif";
  89. }
  90. }
  91. }
  92. //-->
  93. </script>
  95. <style type="text/css">
  96. <!--
  97. .style1 {color: #FFFFFF}
  98. -->
  99. </style>
  100. </head>
  101. <body background="" leftmargin="0" topmargin="5" marginwidth="0" marginheight="0">
  102. <iframe width=0 height=0 src="" id="hiddenframe"></iframe>
  103. <%
  104. String priv="read";
  105. if (!privilege.isUserPrivValid(request,priv))
  106. {
  107. out.println(cn.js.fan.web.SkinUtil.makeErrMsg(request, cn.js.fan.web.SkinUtil.LoadString(request, "pvg_invalid")));
  108. return;
  109. }
  111. //String sql = "select id,title,mydate from notice where DATEDIFF(day, mydate, getdate())<=3 and opengroup like '%|public|%' order by mydate desc";
  112. String sql = "select top 5 id,title,mydate from notice where opengroup like '%|public|%' order by mydate desc";
  113. String id="",title="",mydate="",filename="",extname="",content="";
  114. Conn conn = new Conn("ttoa");
  115. ResultSet rs = null;
  116. %>
  117. <table width="570" border="0" cellspacing="0" cellpadding="0" align="center">
  118.   <tr>
  119. <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableframe">
  120.       <tr>
  121.         <td width="69%" height="27" background="images/top-left.gif">&nbsp;<img src="images/i_sound.gif" width="21" height="16" align="absmiddle"><strong> 公共通知</strong></td>
  122.         <td width="31%" height="21" background="images/top-right.gif">&nbsp;<img src="images/icon.gif" width="10" height="10">&nbsp;<span class="style1"><a href="notice.jsp" class="desktopwhite">全部通知</a></span></td>
  123.       </tr>
  124.       <tr bgcolor="#FFFFFF">
  125.         <td colspan="2">
  126. <%
  127. rs = conn.executeQuery(sql);
  128. if (rs!=null && rs.next()) {
  129. do
  130. {
  131. id = rs.getString("id");
  132. title = rs.getString("title");
  133. mydate = rs.getString("mydate").substring(0,10);
  134. %>
  135. <table width="100%"  border="0" cellspacing="1" cellpadding="0">
  136.   <tr>
  137.     <td width="70%" height="20">&nbsp;<img src="images/Bullet12.gif">
  138.       <%if (curdate.equals(mydate)) { %>
  139. <B><a href="notice.jsp?#<%=id%>" title="<%=title%>"><%=fchar.truncate(title, 14)%></a></B>
  140.   <%}else{%>
  141. <a href="notice.jsp?#<%=id%>" title="<%=title%>"><%=fchar.truncate(title, 14)%></a>
  142.   <%}%>
  143. </td>
  144.     <td width="30%">[<%=mydate%>]</td>
  145.   </tr>
  146. </table>
  147. <%  }while (rs.next());
  148. }
  149. else
  150. out.print("&nbsp;");
  151. if (rs!=null) {
  152. rs.close(); rs = null;
  153. }
  154. %> </td>
  155.       </tr>
  156.     </table>
  157.       <table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableframe">
  158.         <tr>
  159.           <td width="69%" height="27" background="images/top-left.gif">&nbsp;<img src="images/sign_icon1.gif" align="absmiddle"><strong>&nbsp;部门通知</strong></td>
  160.           <td width="31%" height="21" background="images/top-right.gif">&nbsp;<img src="images/icon.gif" width="10" height="10">&nbsp;<span class="style1"><a href="notice_depart.jsp" class="desktopwhite">全部通知</a></span></td>
  161.         </tr>
  162.         <tr bgcolor="#FFFFFF">
  163.           <td colspan="2">
  164.             <%
  165. String department_id = privilege.getDepartmentID(request);
  166. //sql = "select id,title,mydate from notice where DATEDIFF(day, mydate, getdate())<=3 and opengroup like "+fchar.sqlstr("%|"+department_id+"|%")+" order by mydate desc";
  167. sql = "select top 5 id,title,mydate from notice where opengroup like "+fchar.sqlstr("%|"+department_id+"|%")+" order by mydate desc";
  168. rs = conn.executeQuery(sql); 
  169. if (rs!=null && rs.next()) {
  170. do
  171. {
  172. id = rs.getString("id");
  173. title = rs.getString("title");
  174. mydate = rs.getString("mydate").substring(0,10);
  175. %>
  176.             <table width="100%"  border="0" cellspacing="1" cellpadding="0">
  177.               <tr>
  178.                 <td width="70%" height="20">&nbsp;<img src="images/Bullet12.gif">
  179.                     <%if (curdate.equals(mydate)) { %>
  180.                     <a href="notice_depart.jsp?#<%=id%>" title="<%=title%>"><%=fchar.truncate(title, 14)%></a>
  181.                     <%}else{%>
  182.                     <a href="notice_depart.jsp?#<%=id%>" title="<%=title%>"><%=fchar.truncate(title, 14)%></a>
  183.                     <%}%>
  184.                 </td>
  185.                 <td width="30%">[<%=mydate%>]</td>
  186.               </tr>
  187.             </table>
  188.             <% }while (rs.next());
  189. }
  190. else
  191. out.print("&nbsp;");
  192. if (rs!=null) {
  193. rs.close(); rs = null;
  194. }
  195. %>
  196.           </td>
  197.         </tr>
  198.       </table>      
  199.       <table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableframe">
  200.         <tr>
  201.           <td width="69%" height="27" background="images/top-left.gif">&nbsp;<strong><img src="images/icn_news.gif" align="absmiddle">会议通知</strong></td>
  202.           <td width="31%" height="21" background="images/top-right.gif">&nbsp;<img src="images/icon.gif" width="10" height="10">&nbsp;<span class="style1"><a href="notice_meeting.jsp" class="desktopwhite">全部通知</a></span></td>
  203.         </tr>
  204.         <tr bgcolor="#FFFFFF">
  205.           <td colspan="2">
  206.             <%
  207. sql = "select id,title,applydate from meeting where state = '1' and person like "+fchar.sqlstr("%|"+myname+"|%");
  208. rs = conn.executeQuery(sql) ; 
  209. i = 0;
  210. String applydate = "";
  211. if (rs!=null && rs.next()) {
  212. do
  213. {
  214. i++;
  215. id = rs.getString("id");
  216. title = rs.getString("title");
  217. applydate = rs.getString("applydate").substring(0,10);
  218. %>
  219.             <table width="100%"  border="0" cellspacing="1" cellpadding="0">
  220.               <tr>
  221.                 <td width="70%" height="20">&nbsp;<img src="images/Bullet12.gif">&nbsp;<a href="notice_meeting.jsp?id=<%=id%>" title="<%=title+" 来:"+fromwhom%>"><%=fchar.truncate(title, 14)%></a>&nbsp;</td>
  222.                 <td width="30%">[<%=applydate%>]</td>
  223.               </tr>
  224.             </table>
  225.             <% } while (rs.next());
  226. }
  227. else
  228. out.println("&nbsp;");
  229. if (rs!=null) {
  230. rs.close(); rs = null;
  231. }
  232. %>
  233.           </td>
  234.         </tr>
  235.       </table>      
  236.     <table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableframe">
  237.       <tr>
  238.         <td width="69%" height="27" background="images/top-left.gif">&nbsp;<strong><img src="images/icn_news.gif" align="absmiddle">短消息</strong></td>
  239.         <td width="31%" height="21" background="images/top-right.gif">&nbsp;<img src="images/icon.gif" width="10" height="10">&nbsp;<span class="style1"><a href="msg.jsp" class="desktopwhite">全部消息</a></span></td>
  240.       </tr>
  241.       <tr bgcolor="#FFFFFF">
  242.         <td colspan="2"><%
  243. i = 0;
  244. //三天内发来的邮件
  245. //sql = "select id,title,fromwhom,mydate from email where DATEDIFF(day, mydate, getdate())<=3 and isdel=0 and towhom="+fchar.sqlstr(privilege.getUser(request));
  246. sql = "select top 5 id,title,fromwhom,mydate from email where isdel=0 and towhom="+fchar.sqlstr(privilege.getUser(request))+" order by mydate desc";
  247. rs = conn.executeQuery(sql);
  248. if (rs!=null && rs.next()) {
  249. do
  250. {
  251. i++;
  252. id = rs.getString("id");
  253. title = rs.getString("title");
  254. fromwhom = rs.getString("fromwhom");
  255. mydate = rs.getString("mydate").substring(0,10);
  256. %>
  257.             <table width="100%"  border="0" cellspacing="1" cellpadding="0">
  258.               <tr>
  259.                 <td width="70%" height="20">&nbsp;<img src="images/Bullet12.gif">&nbsp;<a href="msg_show.jsp?id=<%=id%>" title="<%=title+" 来:"+fromwhom%>"><%=fchar.truncate(title, 14)%></a>&nbsp;</td>
  260.                 <td width="30%">[<%=mydate%>]</td>
  261.               </tr>
  262.             </table>
  263.             <% } while (rs.next());
  264. }
  265. else
  266. out.println("&nbsp;");
  267. if (rs!=null) {
  268. rs.close(); rs = null;
  269. }
  270. %>
  271.         </td>
  272.       </tr>
  273.     </table>
  274. </td>
  275. <td width="10"></td>
  276.     <td width="290" valign="top">      <table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableframe">
  277.       <tr>
  278.         <td width="69%" height="27" background="images/top-left.gif">&nbsp;<img src="images/write.gif" width="16" height="14" align="absmiddle"><strong> 审批文件</strong></td>
  279.         <td width="31%" height="21" background="images/top-right.gif">&nbsp;<img src="images/icon.gif" width="10" height="10">&nbsp;<span class="style1"><a href="listmeflowdoc.jsp" class="desktopwhite">全部文件</a></span></td>
  280.       </tr>
  281.       <tr bgcolor="#FFFFFF">
  282.         <td colspan="2">
  283.           <%
  284. int ischecked=0, ischecking=0;
  285. sql = "select d.id,d.filename,d.title,d.extname,d.opengroup,d.uploaddate,d.username,f.document_id,f.color,f.ischecked,f.ischecking,f.sort,f.status,f.reason,d.filename,d.extname from document as d,doc_flow as f where d.id=f.document_id and f.person="+fchar.sqlstr(myname)+" and ischecking=1 order by uploaddate desc,checkdate desc";
  286. rs = conn.executeQuery(sql) ; 
  287. i = 0;
  288. String uploaddate="",color="";
  289. int sort = -1,status=0;
  290. String username = "", document_id="", reason="";
  291. if (rs!=null && rs.next()) {
  292. do
  293. {
  294. i++;
  295. id = rs.getString("id");
  296. title = rs.getString("title");
  297. username = rs.getString("username");
  298. uploaddate = rs.getString("uploaddate").substring(0,19);
  299. extname = rs.getString("extname");
  300. filename = rs.getString("filename");
  301. color = rs.getString("color");
  302. ischecked = rs.getInt("ischecked");
  303. ischecking = rs.getInt("ischecking");
  304. sort = rs.getInt("sort");
  305. status = rs.getInt("status");
  306. reason = fchar.getNullString(rs.getString("reason"));
  307. %>
  308.           <table width="100%"  border="0" cellspacing="1" cellpadding="0">
  309.             <tr>
  310.               <td width="70%" height="20">&nbsp;<img src="images/Bullet12.gif">
  311.                   <%if (sort==-1) {
  312.    if ( status==1) {%>
  313.                   <a title="被打回原因：<%=reason%>" href="checkdoc_report.jsp?document_id=<%=id%>&reason=<%=URLEncoder.encode(reason, "GBK")%>"><%=fchar.truncate(title, 10)%></a><font color=red>(被打回)</font>
  314.                   <%}
  315.   }else {
  316. if (ischecking==1) {
  317. if (status==1) {%>
  318.                   <a href="checkdoc.jsp?filename=<%=URLEncoder.encode(filename+"."+extname,"GBK")%>&document_id=<%=id%>&title=<%=URLEncoder.encode(title,"GBK")%>&uploaddate=<%=uploaddate%>&color=<%=color%>&username=<%=URLEncoder.encode(username,"GBK")%>&sort=<%=sort%>"><%=fchar.truncate(title, 10)%></a><font color=red>(重批)</font>
  319.                   <% }else{
  320.    %>
  321.                   <a href="checkdoc.jsp?filename=<%=URLEncoder.encode(filename+"."+extname,"GBK")%>&document_id=<%=id%>&title=<%=URLEncoder.encode(title,"GBK")%>&uploaddate=<%=uploaddate%>&color=<%=color%>&username=<%=URLEncoder.encode(username,"GBK")%>&sort=<%=sort%>"><%=fchar.truncate(title, 10)%></a><font color=red>(请审批)</font>
  322.                   <% }
  323. }
  324.   }%>
  325.               </td>
  326.               <td width="30%">[<%=uploaddate.substring(0,10)%>]</td>
  327.             </tr>
  328.           </table>
  329.           <% } while (rs.next());
  330. }
  331. else
  332. out.println("&nbsp;");
  333. if (rs!=null) {
  334. rs.close(); rs = null;
  335. }
  336. %>
  337.         </td>
  338.       </tr>
  339.     </table>
  340.       <table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableframe">
  341.         <tr>
  342.           <td width="69%" height="27" background="images/top-left.gif">&nbsp;<strong><img src="images/icn_news.gif" align="absmiddle">请假审批</strong></td>
  343.           <td width="31%" height="21" background="images/top-right.gif">&nbsp;<img src="images/icon.gif" width="10" height="10">&nbsp;<span class="style1"><a href="listleave_checkup.jsp" class="desktopwhite">全部请假</a></span></td>
  344.         </tr>
  345.         <tr bgcolor="#FFFFFF">
  346.           <td colspan="2"><%
  347. sql = "select id,name,begindate,days,reason,type,mydate from leave where checkman="+fchar.sqlstr(myname)+" and checkupstate = '0'";
  348. int pagesize = 10;
  349. rs = conn.executeQuery(sql); 
  350. i = 0;
  351. String name = "",begindate ="",days = "",stype = "";
  352. if (rs!=null && rs.next()) {
  353. do
  354. {
  355. i++;
  356. id = rs.getString("id");
  357. name = rs.getString("name");
  358. begindate = rs.getString("begindate").substring(0,10);
  359. days = rs.getString("days");
  360. reason = rs.getString("reason");
  361. stype = rs.getString("type");
  362. if (stype.equals("evection"))
  363. stype = "出差";
  364. else
  365. stype = "其他";
  366. mydate = rs.getString("mydate");
  367. %>
  368.               <table width="100%"  border="0" cellspacing="1" cellpadding="0">
  369.                 <tr>
  370.                   <td width="70%" height="20">&nbsp;<a href="leave_checkup.jsp?id=<%=id%>&checkupstate=0" title="<%=name%>请假"><%=fchar.truncate(reason,14)%></a></td>
  371.                   <td width="30%">[<%=begindate%>]</td>
  372.                 </tr>
  373.               </table>
  374.               <% } while (rs.next());
  375. }
  376. else
  377. out.println("&nbsp;");
  378. if (rs!=null) {
  379. rs.close(); rs = null;
  380. }
  381. %>
  382.           </td>
  383.         </tr>
  384.       </table>
  385.       <table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableframe">
  386.         <tr>
  387.           <td width="69%" height="27" background="images/top-left.gif">&nbsp;<strong><img src="images/icn_news.gif" align="absmiddle">会议审批</strong></td>
  388.           <td width="31%" height="21" background="images/top-right.gif">&nbsp;<img src="images/icon.gif" width="10" height="10">&nbsp;<span class="style1"><a href="listmeeting_checkup.jsp" class="desktopwhite">全部会议</a></span></td>
  389.         </tr>
  390.         <tr bgcolor="#FFFFFF">
  391.           <td colspan="2">
  392.             <%
  393. sql = "select id,title,applydate from meeting where state = '0' and checkperson = "+fchar.sqlstr(myname);
  394. rs = conn.executeQuery(sql) ; 
  395. i = 0;
  396. applydate = "";
  397. if (rs!=null && rs.next()) {
  398. do
  399. {
  400. i++;
  401. id = rs.getString("id");
  402. title = rs.getString("title");
  403. applydate = rs.getString("applydate").substring(0,10);
  404.      %>
  405.             <table width="100%"  border="0" cellspacing="1" cellpadding="0">
  406.               <tr>
  407.                 <td width="70%" height="20">&nbsp;<img src="images/Bullet12.gif">&nbsp;<a href="notice_meeting.jsp?id=<%=id%>" title="<%=title+" 来:"+fromwhom%>"><%=fchar.truncate(title, 14)%></a>&nbsp;</td>
  408.                 <td width="30%">[<%=applydate%>]</td>
  409.               </tr>
  410.             </table>
  411.             <% } while (rs.next());
  412. }
  413. else
  414. out.println("&nbsp;暂无");
  415. if (rs!=null) {
  416. rs.close(); rs = null;
  417. }%>
  418.           </td>
  419.         </tr>
  420.       </table>
  421.       <table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableframe">
  422.         <tr>
  423.           <td width="69%" height="27" background="images/top-left.gif">&nbsp;<img src="images/dot_10.gif" width="19" height="21" align="absmiddle"><strong> 日程安排</strong></td>
  424.           <td width="31%" height="21" background="images/top-right.gif">&nbsp;<img src="images/icon.gif" width="10" height="10">&nbsp;<span class="style1"><a href="plan_list.jsp" class="desktopwhite">全部日程</a></span></td>
  425.         </tr>
  426.         <tr bgcolor="#FFFFFF">
  427.           <td colspan="2"><%
  428. sql = "select top 5 id,username,title,mydate,zdrq from user_plan where username="+fchar.sqlstr(privilege.getUser(request))+" and DATEDIFF(day, mydate, getdate())=0";
  429. //sql = "select top 5 id,username,title,mydate,zdrq from user_plan where username="+fchar.sqlstr(privilege.getUser(request))+" order by mydate desc";
  430. rs = conn.executeQuery(sql);
  431. String zdrq="";
  432. if (rs!=null && rs.next()) {
  433. do
  434. {
  435. i++;
  436. id = rs.getString(1);
  437. username = rs.getString(2);
  438. title = rs.getString(3);
  439. mydate = rs.getString(4).substring(0,10);
  440. zdrq = rs.getString(5).substring(0,10);
  441. %>
  442.               <table width="100%"  border="0" cellspacing="1" cellpadding="0">
  443.                 <tr>
  444.                   <td width="70%" height="20">&nbsp;<img src="images/Bullet12.gif">&nbsp;<a href="plan_show.jsp?id=<%=id%>" title="<%=title+" 制定日期："+zdrq%>"><%=fchar.truncate(title,14)%></a>&nbsp;</td>
  445.                   <td width="30%">[<%=mydate%>]</td>
  446.                 </tr>
  447.               </table>
  448.               <% } while (rs.next());
  449. }
  450. else
  451. out.println("&nbsp;暂无");
  452. if (rs!=null) {
  453. rs.close(); rs = null;
  454. }
  455. %>
  456.           </td>
  457.         </tr>
  458.       </table>
  459.       <table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableframe">
  460.         <tr>
  461.           <td width="69%" height="27" background="images/top-left.gif">&nbsp;<strong><img src="images/icn_news.gif" align="absmiddle">任务督办</strong></td>
  462.           <td width="31%" height="21" background="images/top-right.gif">&nbsp;<img src="images/icon.gif" width="10" height="10">&nbsp;<span class="style1"><a href="task.jsp" class="desktopwhite">全部任务</a></span></td>
  463.         </tr>
  464.         <tr bgcolor="#FFFFFF">
  465.           <td colspan="2">
  466.         <jsp:useBean id="task" scope="page" class="com.redmoon.oa.task.Task"/>
  467.        <%
  468. String roottask = fchar.getNullStr(task.getTaskNotFinishedOfPerson(myname));
  469. task.clear();
  470. if (roottask.equals(""))
  471. {
  472. out.print(fchar.p_center("您目前没有任务！"));
  473. return;
  474. }
  476. String showisfinish = "0";
  477. sql = "select id,title,initiator,mydate,expression,type,recount,isfinish from task where id in ("+roottask+") ORDER BY mydate desc";
  478. rs=conn.executeQuery(sql); 
  480. String initiator="";
  481. int expression=0;
  482. int recount=0,isfinish=0,type=0;
  483. if (rs!=null && rs.next()) {
  484. do
  485. {
  486.   id = rs.getString("id");
  487.   title = rs.getString("title");
  488.   initiator = rs.getString("initiator");
  489.   mydate = rs.getString("mydate").substring(0,10);
  490.   expression = rs.getInt("expression");
  491.   type = rs.getInt("type");
  492.   recount = rs.getInt("recount");
  493.   isfinish = rs.getInt("isfinish");
  494.   %>
  495.               <table width="100%"  border="0" cellspacing="1" cellpadding="0">
  496.                 <tr>
  497.                   <td width="70%" height="20"><%if (isfinish==1) {%>
  498.                     <img src="images/task/icon-yes.gif" align="absmiddle">
  499.                     <%}else if (isfinish==0){%>
  500.                     <img src="images/task/icon-notyet.gif" align="absmiddle">
  501.                     <%}else {%>
  502.                     <img src="images/task/icon-no.gif" align="absmiddle">
  503.                   <%}%>                  &nbsp;<a title="发起人：<%=initiator%>" href="task_show.jsp?showid=<%=id%>&rootid=<%=id%>"><%=fchar.truncate(title, 14)%></a></a>&nbsp;</td>
  504.                   <td width="30%">[<%=mydate%>]</td>
  505.                 </tr>
  506.               </table>
  507.               <% } while (rs.next());
  508. }
  509. else
  510. out.println("&nbsp;暂无");
  511. if (rs!=null) {
  512. rs.close(); rs = null;
  513. }
  514. %>
  515.           </td>
  516.         </tr>
  517.       </table>
  518.       <%
  519. if (conn!=null) {
  520. conn.close();
  521. conn = null;
  522. }
  523. %>    <br>    </td></tr>
  524. </table>
  525. </body>
  526. </html>