📄 jcy_zb_view.jsp

📁 公务员工资系统软件工程文档及源代码
💻 JSP
字号:

<%@ page contentType="text/html; charset=GBK" errorPage="" %>
<%@ import="com.vstsoft.std.vststd" %>
<%com.vstsoft.std.vststd std=new com.vstsoft.std.vststd();%>
<%@ errorPage="errorPage.jsp" %>
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />

<% if (jcypurview.checkLogin() == false)
   {
%>   
	<Script Language=javascript>
		alert("用户已断线或未正常登录，请重新登录！")
		window.open("../index.htm","_top")
	</Script>
<%  return;
    }
   if (jcypurview.purviewVerdict("B0500027") == false)
  {
%>   
	<Script Language=javascript>
		alert("您没有操作此页权限！")
		window.open("../index.jsp","_top")
	</Script>
<%  return;  
}  %>  
<%
  String nowuserid   = jcypurview.getUserid();   //取当前用户编号
  String nowusername = jcypurview.getUserName(); //取当前用户名称
  String nowuserszqx = jcypurview.getUserSzqx(); //取当前用户所在区县 
  String nowuserszdw = jcypurview.getUserSzdw(); //取当前用户所在单位
%>
<html>
<head>
<%
	//response.setHeader("Pragma","No-cache");
	//response.setHeader("Cache-Control","no-cache");
	//response.setDateHeader("Expires",0);
	String zbmc = std.getValue(request,"zbmc");		    	//组别名称                         
	String zbdm = std.getValue(request,"zbdm");			//组别编号
	String dwdm   = std.getValue(request,"dwdm");			//所属区县
	String jl   = "";
	String xzbdm   = "";
	String blrq   = "";
	String qx     = "";
	String sql_dw = "select qx from jcy_dw where dwdm = '"+dwdm+"'";
	sun.jdbc.rowset.CachedRowSet dw = std.getResultBySelect(sql_dw);	
	dw.next();
	qx = dw.getString(1);
		
	String sql_select = "select jcy_zb.zbdm,dp_sys.f_get_mc_by_dm('0001',jcy_dw.qx),jcy_zb.zbmc,jcy_zb.zbdm,to_char(jcy_zb.blrq,'yyyy.mm.dd') from jcy_zb ,jcy_dw where jcy_zb.DWDM=jcy_dw.DWDM and jcy_dw.dwdm = '"+dwdm+"'";
	if (!zbmc.equals(""))
	sql_select = sql_select + " and jcy_zb.zbmc like '%"+zbmc+"%'";
	if (!zbdm.equals(""))
	sql_select = sql_select + " and jcy_zb.zbdm like '%"+zbdm+"%'";
	sql_select = sql_select + " order by jcy_zb.blrq desc ";
	sun.jdbc.rowset.CachedRowSet crs = std.getResultBySelect(sql_select);	
	
	String panduan = "select count(*) from jcy_zb ,jcy_dw where jcy_zb.DWDM=jcy_dw.DWDM and jcy_dw.qx = '"+qx+"'";
	if (!zbmc.equals(""))
	panduan = panduan + " and jcy_zb.zbmc like '%"+zbmc+"%'";
	if (!zbdm.equals(""))
	panduan = panduan + " and jcy_zb.zbdm like '%"+zbdm+"%'";
	sun.jdbc.rowset.CachedRowSet ii = std.getResultBySelect(panduan);
	ii.next();
	jl = ii.getString(1);
%>	
<script language=javascript>
var G_id;
function f_radio(num)
{   
	G_id = num;
}
function f_modify()
{   
    if (<%=jl%> == 0)
    {
    	alert("没有记录");
    	return false;	
    } 
    if (G_id == "" || G_id == null)
    {
	alert("请选择需要修改的组别信息！");
	return false;
    }
    else
    {
    window.open("jcy_zb_new_modify.jsp?zt=modify&ID="+G_id+"&dwdm="+'<%=dwdm%>',"_self");
    }
}
function f_del()
{   

    if (<%=jl%> == 0)
    {
    	alert("没有记录");
    	return false;	
     }    	
    if (G_id == "" || G_id == null)
	{
	alert("请选择需要删除的组别信息！");
	return false;
        }
    else
	{
	 form.action =  "jcy_zb_submit.jsp?zt=del&ID="+G_id;
	 form.submit();
     }
     
}
function f_back()
{
	window.open("jcy_zb_select.jsp?ID="+'<%=dwdm%>',"_self");
}    
function f_imager(text,ixy)
{	         		  
	   if (ixy == '0') 		  
	      {
	     alert(text);
	     window.open("jcy_zb_select.jsp?ID="+'<%=dwdm%>'+"&zt="+text,"_self");	 
	      }
		  else
		  {
		  alert(text);
		  }		 	     
}
</script>
<title>公务员管理</title>
<link rel="stylesheet" href="../style.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<script language="JavaScript" src="new.js"></script>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td align="center"> <br>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="17" align="left" background="../images/caozuo01.gif">&nbsp;</td>
          <td background="../images/caozuo02.gif" align="center" width="962"><b><font color="#FF6600" size="3">组别管理</font></b></td>
          <td width="15"><img src="../images/caozuo03.gif" width="15" height="84"></td>
        </tr>
      </table>
      <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#EEF9FF">
        <tr> 
          <td width="15" background="../images/caozuo04.gif"><img src="../images/caozuo04.gif" width="15" height="6"></td>
          <td align="center"> <form name="form" method="post" action="" target="zbview">
              <table align=center border=1 bordercolordark=#ffffff bordercolorlight=#666699 
cellpadding=0 cellspacing=0 width=100% bgcolor="#000099">
                <tr align="center" bgcolor="#174ca3"> 
                  <td width="4%"  height="40">&nbsp;</td>
                  <td width="19%" height="16"><font color="#FFFFFF">所属区县</font></td>
                  <td width="37%" height="16"><font color="#FFFFFF">组别名称</font></td>
                  <td width="15%" height="16"><font color="#FFFFFF">组别编号</font></td>
                  <td width="25%" height="16"><font color="#FFFFFF">登记时间</font></td>
                </tr>
                <%while (crs.next()){
							  zbdm = crs.getString(1);
							  qx = crs.getString(2);
							  zbmc = crs.getString(3);
							  xzbdm = crs.getString(4);				  
							  blrq = crs.getString(5);
							  if (zbdm == null) zbdm = "000";				 
							  if (qx == null) qx = "101";
							  if (zbmc == null) zbmc = "无";
							  if (xzbdm == null) xzbdm = "00000";
							  if (blrq == null) blrq = "0000-00-00";			  								
							%>
                <tr align="center" bgcolor="#FFFFFF"> 
                  <td height="25"> <input type="radio" name="radiobutton" value="<%=zbdm%>" onClick="f_radio(this.value)"> 
                  </td>
                  <td height="18"><font color="#105781"><%=qx%></font></td>
                  <td height="18"><font color="#105781"><%=zbmc%></font></td>
                  <td height="18"><font color="#105781"><%=xzbdm%></font></td>
                  <td height="18"><font color="#105781"><%=blrq%></font></td>
                </tr>
                <%}%>
              </table>
              <table width="70%" border="0">
                <tr> 
                  <td width="29%" height="63" align="center" valign="middle"><input type="button" class="input" name="Submit" value="修  改" onClick="f_modify()"></td>
                  <td width="44%" align="center" valign="middle"><input type="button" class="input" name="Submit2" value="删  除" onClick="f_del()"></td>
                  <td width="27%" align="center" valign="middle"><input type="button" class="input" name="Submit22" value="返  回" onClick="f_back()"></td>
                </tr>
              </table>
            </form></td>
          <td width="14" background="../images/caozuo07.gif"><img src="../images/caozuo07.gif" width="14" height="6"></td>
        </tr>
      </table>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="21"><img src="../images/caozuo05.gif" width="21" height="16"></td>
          <td background="../images/caozuo08.gif"><img src="../images/caozuo08.gif" width="6" height="16"></td>
          <td width="19"><img src="../images/caozuo09.gif" width="19" height="16"></td>
        </tr>
      </table>
      <br>
    </td>
  </tr>
</table>

<iframe name="zbview" width="1000" height="1000" style="display:none" ></iframe>
</body>
</html>
⌨️ 快捷键说明

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