⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 jcy_zb_new_modify.jsp

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

<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*,com.vstsoft.std.*"  errorPage=""%>
<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;  }%>  
<%
  String nowuserid   = jcypurview.getUserid();   			//取当前用户编号
  String nowusername = jcypurview.getUserName(); 			//取当前用户名称
  String nowuserszqx = jcypurview.getUserSzqx(); 			//取当前用户所在区县 
  String nowuserszdw = jcypurview.getUserSzdw(); 			//取当前用户所在单位
%>
<html>
<head>
<%vststd std = new vststd();%>
<%
	response.setHeader("Pragma","No-cache");
	response.setHeader("Cache-Control","no-cache");
	response.setDateHeader("Expires",0);
	String szt = std.getValue(request,"zt");
	String zbdm =std.getValue(request,"ID");

	String zbmc ="";
	String lxdh ="";
	String bz ="";
	String dwdm =std.getValue(request,"dwdm");
	String blrq ="";
	String qx = "";	
	String zbmc_e ="";
	String rqtime ="";
	String nameno ="";
	//查找区县
	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_qx = "select dp_sys.f_get_mc_by_dm('0001',qx) from jcy_dw where dwdm= '"+dwdm+"'";
	sun.jdbc.rowset.CachedRowSet qxdm = std.getResultBySelect(sql_qx);			 
	qxdm.next();
	String qxxx = qxdm.getString(1);
	//区县查找完成
	
	if ( szt.equals("modify"))
	{
	String sql_modify = "select zbmc,zbdm,lxdh,bz,dwdm,to_char(blrq,'yyyy.mm.dd') from jcy_zb where zbdm = '"+zbdm+"'";
	sun.jdbc.rowset.CachedRowSet crs = std.getResultBySelect(sql_modify);
	crs.next();
    	zbmc = crs.getString(1);   				//组别名称
	//zbdm = crs.getString(2);  				//组别编号	
	lxdh = crs.getString(3);   				//联系电话
	bz   = crs.getString(4);   				//备注
	dwdm = crs.getString(5);   				//所属单位
	blrq = crs.getString(6);   				//录入时间
	if (zbmc == null) zbmc = "";				 
	//if (zbdm == null) zbdm = "";
	if (lxdh == null) lxdh = "";
	if (bz   == null) bz   = "";
	if (dwdm   == null) dwdm   = "";
	if (blrq   == null) blrq   = "";
	}
	//计算当前时间,格式:yyyy.mm.dd
    sun.jdbc.rowset.CachedRowSet aa=std.getResultBySelect("select to_char(sysdate,'yyyy.mm.dd') t from dual");
    aa.next();
    String ti=aa.getString("t");
%>
<% 
 if (szt.equals("new"))
 {
    if (jcypurview.purviewVerdict("B0500028") == false)
   {
%>   
	<Script Language=javascript>
		alert("您没有操作此页权限!")
		window.open("../index.jsp","_top")
	</Script>
<%  return;  
    } 
 } 
 %>
<% 
 if (szt.equals("modify"))
 {
    if (jcypurview.purviewVerdict("B0500029") == false)
   {
%>   
	<Script Language=javascript>
		alert("您没有操作此页权限!")
		window.open("../index.jsp","_top")
	</Script>
<%  return;  
    } 
 } 
%>   	
<script language="JavaScript1.2" src="new.js"></script>
<!--// modify : yhy-->
	<link rel="stylesheet" href="../lib/main.css" type="text/css">	
	<script language="javascript" src="../lib/check.js"></script>
	<script language="JavaScript" src="../lib/date/GetDate.js"></script>
	<script language="JavaScript" src="../lib/util.js"></script>
<!-- modify end -->
<script>
function checkJsrqs(inval){
	    if(inval==""){
		  return true;
		}
	    var ret = check_date(inval,"D");
		if(ret == "")
		  return true;
        else
	   {
		  ret="新增日期 起:"+ret;
		  alert(ret);
		  return false;
        }
	  }
</script>
<script language="JavaScript">
  function f_number()
{
	var v_lxdh = document.form.lxdh.value;			//联系电话
	if (document.form.zbmc.value.length == 0 )
	{
		alert('组别名称不能为空');
		document.form.zbmc.focus();
		return(false);
	}
	if (document.form.zbmc.value.length > 80)
	{
		alert('组别名称长度不能超过80位');
		document.form.zbmc.focus();
		return(false);
	}
	if(document.form.rq.value.length==0)
	{
		alert("请输入登记日期!");
		document.form.rq.focus();
		return(false);
	}
	if (document.form.lxdh.value.length > 40)
	{
		alert('联系电话长度不能超过40位!');
		document.form.lxdh.focus();
		return(false);
	}
	if (document.form.bz.value.length > 200)
	{
		alert('备注长度不能超过200位!');
		document.form.bz.focus();
		return(false);
	}
	for (var i=1;i<document.form.lxdh.value.length;i++)
	   {
		   var a=document.form.lxdh.value.substr(i,1);
		   if (a =='.')
		   {
			 alert('联系电话不能有"."');
			 document.form.lxdh.focus();
			 return(false);
			}
	   }      	       
	if (check_tel(v_lxdh) == '1')
		{
		alert("请输入正确的联系电话!");
		document.form.lxdh.focus();
		return(false);
		}     	  
}
	function check_tel(num)
	{
		for(i=0;i<num.length;i++)
		{
			var a=num.substr(i,1);
			if ((a<'0'||a>'9')&&a!='*'&&a!='#'&&a!='-')
			return('1');
		}
		return('0');
	}
 function f_imager(text,ixy)
	 {	         		   
	   if (ixy == '0') 		  
	      {
		 alert(text);	      
	     	 window.open("jcy_zb_select.jsp?ID="+'<%=dwdm%>'+"&zt="+text,"_self");
	      }
		  else
		  {
		  alert(text);
		  }		 	     
	 }
function f_back()
{
	window.open("jcy_zb_view.jsp?dwdm="+'<%=dwdm%>',"_self");
}
</script>

<title>欢迎!</title>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<link rel="stylesheet" href="../style.css" type="text/css">
</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"></td>
          <td background="../images/caozuo02.gif" align="center" width="946"><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" height="194" background="../images/caozuo04.gif"><img src="../images/caozuo04.gif" width="15" height="6"></td>
          <td align="center">        
			<form name="form" method="post" action="jcy_zb_submit.jsp?zt=<%=szt%>&ID=<%=zbdm%>&dwdm=<%=dwdm%>&qxxx=<%=qx%>" onSubmit="return(f_number())" target="aaa">
              <table width="750" cellspacing="1" cellpadding="0" bgcolor="#000099">
                <tr> 
                  <td><table width=100% border="0" align=center 
cellpadding=0 cellspacing=1 bordercolorlight=#666699 bordercolordark=#ffffff bgcolor="#000099">
                      <tr bgcolor="#EEF9FF"> 
                        <td width="15%" height="25" align="center"><b><font color="#105781">组别名称<font color="#FF0000">*</font></font></b></td>
                        <td width="40%"><b><font color="#105781"> 
                          <input name="zbmc" type="text" value="<%=zbmc%>" size="36" maxlength="80">
                          </font></b></td>
                        <td width="15%" align="center"><b><font color="#105781">登记时间</font><font color="ff0000">*</font></b></td>
                          <!--所属单位-->
                        <td width="30%"> 
                          <!--<select name="qx" id="qx">
                      <%//=std.popListWithSelect("select dm, mc from dm_mx where dmm = '0001' ",qx)%> </select> -->
                          <!--<script language="JavaScript">-->
                    				<%if (szt.equals("modify"))
		                                   {
		                                    rqtime =blrq;
		                                    }else
		                                    {
		                                    //rqtime = std.getDateStr("YYYY.MM.DD"); 
		                                    rqtime=ti;
		                                    }
		                                   %>
						<!--var d1=new rlCtrl("rq","<%//=rqtime%>");</script>-->
						<input id="rq" name="rq" style="width:80px" class="dateinput" maxlength=10 onFocus=this.select() onblur="this.value=formatDate(this.value);if(!checkJsrqs(this.value)) this.focus();" onDblClick=this.value="" value="<%=rqtime%>"><img src="../images/select.gif" width="18" height="20" border="0" align="absmiddle" onClick="getDate('rq',1);">
						</td>
                      </tr>
                      <tr bgcolor="#EEF9FF"> 
                        <td height="25" align="center"><b><font color="#105781">联系电话 
                          <!--组别编号-->
                          </font></b></td>
                        <td colspan="3"> 
                          <!--<input name="zbdm" type="text" size="40" value="<%//=zbdm%>" disabled>-->
                          <input name="lxdh" type="text" value="<%=lxdh%>" size="36" maxlength="40"> 
                        </td>
                      </tr>
                      <tr bgcolor="#EEF9FF"> 
                        <td height="25" align="center"><b><font color="#105781">备注</font></b></td>
                        <td colspan="3"><textarea name="bz" cols="36"><%=bz%></textarea></td>
                      </tr>
                      <tr bgcolor="#EEF9FF"> 
                        <td height="25" align="center"><b><font color="#105781">所属区县</font></b></td>
                        <td colspan="3"><b><font color="#105781"> 
                          <input name="zbmc2" type="text" value="<%=qxxx%>" size="20" maxlength="80" disabled>
                          </font></b></td>
                      </tr>
                    </table></td>
                </tr>
              </table>
              <table width="75%" border="0">
                <tr> 
                  <td width="34%" height="63" align="center" valign="middle"> 
                    <input type="submit" class="input" name="save" value="保  存"> </td>
                  <% if(szt.equals("modify")){ %>
                 <%}%>
                  <% if(szt.equals("new")){ %>
                  <td width="34%" align="center"><input type="reset" class="input" name="return2" value="清  屏">
                    <%}%></td>
                  <td width="32%" align="center"><input type="button" class="input" name="return" 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="aaa" width="1000" height="1000" style="display:none" ></iframe>
</body>
</html>

⌨️ 快捷键说明

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