📄 jcy_ry_sp.jsp

📁 公务员工资系统软件工程文档及源代码
💻 JSP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*,com.vstsoft.std.*" %>
<%
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires", 0);
%>
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />
<%
  String currusercode = jcypurview.getUsercode(); //取当前用户usercode
  String curruserid = jcypurview.getUserid();     //取当前用户编号
  String currusername = jcypurview.getUserName(); //取当前用户名称
  String curruserszqx = jcypurview.getUserSzqx(); //取当前用户所在区县 
  String curruserszdw = jcypurview.getUserSzdw(); //取当前用户所在单位

//检测用户是否登录
if (jcypurview.checkLogin() == false)
   {
%>   
	<Script Language=javascript>
		alert("用户已断线或未正常登录，请重新登录！")
		window.open("../index.htm","_top")
	</Script>
<%  
    return;}
%>
<%
  //检测用户是否有操作权限 
  if (jcypurview.purviewVerdict("B0500004") == false || !curruserszqx.equals("001"))
  {
%>
	<Script Language=javascript>
		alert("您没有操作此页权限！")
		history.go(-1);
	</Script>
<%	return;
   }
%> 
<html>
<head>
<%vststd std = new vststd();%>
<%String today = std.getDateStr("YYYY.MM.DD");%>
<title>公务员信息（审批页）</title>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<script language="JavaScript1.2" src="new.js"></script>
<link rel="stylesheet" href="../style.css" type="text/css">
<script language="JavaScript">
	var G_id;
	function f_radio(num)
	{   
		G_id = num;
	}
	function f_check()
	{
		if (G_id == "" || G_id == null)
		{
		alert("请选择要进行审批的人员！");
		return false;
		}
	}
	function f_err(err)
	{
	    if (err == "ok")
		{
			alert("审核结果提交成功！");
			window.open("jcy_ry_sp_select.jsp","_self");
			return;
		}
	    alert(err);
	}
</script>
<%
	String uid = request.getParameter("radio");
	String sql_temp = "select dwdm, zbdm from jcy_ry where userid = '"+uid+"'";
	sun.jdbc.rowset.CachedRowSet crs_t = std.getResultBySelect(sql_temp);
	crs_t.next();
	String sdwdm = crs_t.getString(1);
	String szbdm = crs_t.getString(2);

	String sql_sp_view = null;

	if (sdwdm == null){
	sql_sp_view = "select ry.username, ry.sfzh, dp_sys.F_Get_mc_by_dm('0004',ry.xb), ry.usercode, DP_SYS.TO_CHN_DATE(ry.csrq,'YMD'), dp_sys.F_Get_mc_by_dm('0006',ry.mz), dp_sys.F_Get_mc_by_dm('5005',ry.whcd), ry.sxzy, dp_sys.F_Get_mc_by_dm('5004',ry.zzmm), dp_sys.F_Get_mc_by_dm('0001',ry.qx), dp_sys.F_Get_mc_by_dm('0002',ry.jddm), dp_sys.F_Get_mc_by_dm('5007',ry.sfjd), '' dwmc , '' zbmc,  dp_sys.F_Get_mc_by_dm('5003',ry.ssbz), dp_sys.F_Get_mc_by_dm('5006',ry.zjlb), dp_sys.F_Get_mc_by_dm('5002',ry.zw), ry.xphm, ry.zjhm, ry.fzjg, ry.gzbm, DP_SYS.TO_CHN_DATE(ry.gzqr,'YMD'), DP_SYS.TO_CHN_DATE(ry.gzzr,'YMD'), DP_SYS.TO_CHN_DATE(ry.zxrq,'YMD'), dp_sys.F_Get_mc_by_dm('5008',ry.zxyy), ry.ryzt from jcy_ry ry where userid = '"+uid+"'";
	}
	else if (szbdm == null){
	sql_sp_view = "select ry.username, ry.sfzh, dp_sys.F_Get_mc_by_dm('0004',ry.xb), ry.usercode, DP_SYS.TO_CHN_DATE(ry.csrq,'YMD'), dp_sys.F_Get_mc_by_dm('0006',ry.mz), dp_sys.F_Get_mc_by_dm('5005',ry.whcd), ry.sxzy, dp_sys.F_Get_mc_by_dm('5004',ry.zzmm), dp_sys.F_Get_mc_by_dm('0001',ry.qx), dp_sys.F_Get_mc_by_dm('0002',ry.jddm), dp_sys.F_Get_mc_by_dm('5007',ry.sfjd), dw.dwmc, '',  dp_sys.F_Get_mc_by_dm('5003',ry.ssbz), dp_sys.F_Get_mc_by_dm('5006',ry.zjlb), dp_sys.F_Get_mc_by_dm('5002',ry.zw), ry.xphm, ry.zjhm, ry.fzjg, ry.gzbm, DP_SYS.TO_CHN_DATE(ry.gzqr,'YMD'), DP_SYS.TO_CHN_DATE(ry.gzzr,'YMD'), DP_SYS.TO_CHN_DATE(ry.zxrq,'YMD'), dp_sys.F_Get_mc_by_dm('5008',ry.zxyy), ry.ryzt from jcy_ry ry, jcy_dw dw where userid = '"+uid+"' and ry.dwdm = dw.dwdm";
	}
	else{
	sql_sp_view = "select ry.username, ry.sfzh, dp_sys.F_Get_mc_by_dm('0004',ry.xb), ry.usercode, DP_SYS.TO_CHN_DATE(ry.csrq,'YMD'), dp_sys.F_Get_mc_by_dm('0006',ry.mz), dp_sys.F_Get_mc_by_dm('5005',ry.whcd), ry.sxzy, dp_sys.F_Get_mc_by_dm('5004',ry.zzmm), dp_sys.F_Get_mc_by_dm('0001',ry.qx), dp_sys.F_Get_mc_by_dm('0002',ry.jddm), dp_sys.F_Get_mc_by_dm('5007',ry.sfjd), dw.dwmc, zb.zbmc,  dp_sys.F_Get_mc_by_dm('5003',ry.ssbz), dp_sys.F_Get_mc_by_dm('5006',ry.zjlb), dp_sys.F_Get_mc_by_dm('5002',ry.zw), ry.xphm, ry.zjhm, ry.fzjg, ry.gzbm, DP_SYS.TO_CHN_DATE(ry.gzqr,'YMD'), DP_SYS.TO_CHN_DATE(ry.gzzr,'YMD'), DP_SYS.TO_CHN_DATE(ry.zxrq,'YMD'), dp_sys.F_Get_mc_by_dm('5008',ry.zxyy), ry.ryzt from jcy_ry ry, jcy_dw dw, jcy_zb zb where userid = '"+uid+"' and ry.dwdm = dw.dwdm and ry.zbdm = zb.zbdm";
	}
	
//	System.out.println(sql_sp_view);
	sun.jdbc.rowset.CachedRowSet crs = std.getResultBySelect(sql_sp_view);
	crs.next();
	String username = crs.getString(1);
	String sfzh = crs.getString(2);
	String xb   = crs.getString(3);
	String usercode = crs.getString(4);
	String csrq = crs.getString(5);
	String mz   = crs.getString(6);
	String whcd = crs.getString(7);
	String sxzy = crs.getString(8);
	String zzmm = crs.getString(9);
	String qx   = crs.getString(10);
	String jd   = crs.getString(11);
	String sfjx = crs.getString(12);
	String gzdw = crs.getString(13);
	String sszb = crs.getString(14);
	String ssbz = crs.getString(15);
	String zjlb = crs.getString(16);
	String zw   = crs.getString(17);
	String xphm = crs.getString(18);
	String zjhm = crs.getString(19);
	String fzjg = crs.getString(20);
	String gzbm = crs.getString(21);
	String gzqr = crs.getString(22);
	String gzzr = crs.getString(23);
	String zxrq = crs.getString(24);
	String zxyy = crs.getString(25);

	username = (username != null)?username:"";
	sfzh = (sfzh != null)?sfzh:"";
	xb   = (xb != null)?xb:"";
	usercode = (usercode != null)?usercode:"";
	csrq = (csrq != null)?csrq:"";
	mz   = (mz != null)?mz:"";
	whcd = (whcd != null)?whcd:"";
	sxzy = (sxzy != null)?sxzy:"";
	zzmm = (zzmm != null)?zzmm:"";
	qx   = (qx   != null)?qx:"";
	jd   = (jd != null)?jd:"";
	sfjx = (sfjx != null)?sfjx:"";
	gzdw = (gzdw != null)?gzdw:"";
	sszb = (sszb != null)?sszb:"";
	ssbz = (ssbz != null)?ssbz:"";
	zjlb = (zjlb != null)?zjlb:"";
	zw   = (zw != null)?zw:"";
	xphm = (xphm != null)?xphm:"";
	zjhm = (zjhm != null)?zjhm:"";
	fzjg = (fzjg != null)?fzjg:"";
	gzbm = (gzbm != null)?gzbm:"";
	gzqr = (gzqr != null)?gzqr:"";
	gzzr = (gzzr != null)?gzzr:"";
	zxrq = (zxrq != null)?zxrq:"";
	zxyy = (zxyy != null)?zxyy:"";
%>
</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
12 下一页
⌨️ 快捷键说明

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