📄 jcy_zb_submit.jsp
字号:
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*,com.vstsoft.std.*" errorPage="" %>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<html>
<%vststd std = new vststd();%>
<%
String zbdm_id = std.getValue(request,"ID"); // 街道代码
String szt = std.getValue(request,"zt"); // 按钮类别
String imager = "";
String lrsj = ""; //录入时间
int ixy = 0;
%>
<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 (szt.equals("del"))
{
if (jcypurview.purviewVerdict("B0500030") == 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;
}
}
if (szt.equals("new"))
{
if (jcypurview.purviewVerdict("B0500028") == 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(); //取当前用户所在单位
%>
<%
//新增组别
if ( szt.equals("new"))
{
String zbmc= std.getValue(request,"zbmc").trim(); //街道名称
String dwdm= std.getValue(request,"dwdm").trim(); //单位代码
String lxdh= std.getValue(request,"lxdh").trim(); //联系电话
String bz= std.getValue(request,"bz").trim(); //备注
String blrq= std.getValue(request,"rq").trim(); //录入时间
String qxxx= std.getValue(request,"qxxx").trim(); //单位所在区县
if (zbmc.length() > 80)
{
imager = "组别名称长度不能超过80位!";
ixy = 1;
}
if (ixy != 1)
{
if (lxdh.length() > 40)
{
imager = "联系电话长度不能超过40位!";
ixy = 1;
}
}
if (ixy != 1)
{
if (bz.length() > 200)
{
imager = "备注度不能超过200位!";
ixy = 1;
}
}
if (ixy != 1)
{
if (dwdm.equals(""))
{
imager = "请查看是否连接数据库!";
ixy = 1;
}
}
if (ixy != 1)
{
if (zbmc.equals(""))
{
imager = "组别名称不能为空!";
ixy = 1;
}
}
String suserid = "";
String suseris = "";
String qsqx = "";
String qbym = "";
String dqrq = "";
if (ixy == 0)
{
//取数据库时间
String lrrq = std.getDateStr("YYYY.MM.DD");
//查询人员表
String jcy_zbname = "select count(*) from jcy_zb where zbmc = '"+zbmc+"'";
sun.jdbc.rowset.CachedRowSet jcy_zb = std.getResultBySelect(jcy_zbname);
jcy_zb.next();
String zbname = jcy_zb.getString(1);
if (zbname.equals("0"))
{
//单位序号
String ymd = "select to_char(sysdate, 'yyyy') from dual";
sun.jdbc.rowset.CachedRowSet jcy_ymd = std.getResultBySelect(ymd);
jcy_ymd.next();
String yemoda = jcy_ymd.getString(1);
//判断是否有前三位
String sl = "select count(*) from jcy_zb where substr(zbdm,1,3)='"+qxxx+"'";
sun.jdbc.rowset.CachedRowSet jcy_sl = std.getResultBySelect(sl);
jcy_sl.next();
String slmc = jcy_sl.getString(1);
if (!slmc.equals("0"))
{
String scxh = "select max(substr(zbdm,1,3)),substr(max(zbdm),4,4),max(substr(zbdm,4,6)),to_char(sysdate,'yyyy') from jcy_zb where substr(zbdm,1,3)= '"+qxxx+"'";
sun.jdbc.rowset.CachedRowSet jcy_scxh = std.getResultBySelect(scxh);
jcy_scxh.next();
suseris = jcy_scxh.getString(3);
qsqx = jcy_scxh.getString(1);
qbym = jcy_scxh.getString(2);
dqrq = jcy_scxh.getString(4);
//判断是否有当天
out.print(qbym);
out.print("qq"+dqrq);
if (qbym.equals(dqrq))
{
int a = Integer.parseInt(suseris.substring(suseris.length()-2,suseris.length()))+1;
/* if (a>90)
{//imager = "已经达到今日输入最大值！请改明日再加入。";
//ixy =1;
suserid = "99";
}*/
if (a<10)
{
suserid = String.valueOf(a);
suserid = 0+suserid;
}
else
{
suserid = String.valueOf(a);
}
}
if (!qbym.equals(dqrq))
{
suserid = "01";
}
}
if (slmc.equals("0"))
{
suserid = "01";
}
String lxd = qxxx+yemoda+suserid; //生成组别ID
String zbid = "select count(*) from jcy_zb where zbdm = '"+lxd+"'";
sun.jdbc.rowset.CachedRowSet jcy_zbid = std.getResultBySelect(zbid);
jcy_zbid.next();
String zbids = jcy_zbid.getString(1);
//out.print (zbids);
String sql_insert = "insert into jcy_zb (zbdm) values ('"+lxd+"')";
int isi = std.getResultByUpdate(sql_insert);
if (isi == 1 )
{
String sql_update = "update jcy_zb set zbmc='"+zbmc+"', blrq=to_date('"+blrq+"','YYYY.MM.DD'), lxdh='"+lxdh+"',bz='"+bz+"',dwdm='"+dwdm+"'where zbdm = '"+lxd+"'";
int isu = std.getResultByUpdate(sql_update);
if (isu == 1)
{
imager = "保存成功!";
}else
{
ixy = 1;
imager = "新增失败!";
}
}
else
{
imager = "已经有此组名ID,请明日再录入！";
ixy = 1;
}
}
else
{
imager = "已经有此组名，请更换！";
ixy = 1;
}
}
}
//修改组别
if ( szt.equals("modify"))
{
String zbmc= std.getValue(request,"zbmc").trim(); //街道名称
String qx= std.getValue(request,"qx").trim(); //单位代码
String dwdm =std.getValue(request,"dwdm").trim();
String lxdh= std.getValue(request,"lxdh").trim(); //联系电话
String bz= std.getValue(request,"bz").trim(); //备注
String blrq= std.getValue(request,"rq").trim(); //录入时间
if (zbmc.length() > 80)
{
imager = "街道名称长度不能超过80位!";
ixy = 1;
}
if (ixy != 1)
{
if (lxdh.length() > 40)
{
imager = "联系电话长度不能超过40位!";
ixy = 1;
}
}
if (ixy != 1)
{
if (bz.length() > 200)
{
imager = "备注度不能超过200位!";
ixy = 1;
}
}
if (ixy != 1)
{
if (dwdm.equals(""))
{
imager = "请查看是否连接数据库!";
ixy = 1;
}
}
if (ixy != 1)
{
if (zbmc.equals(""))
{
imager = "组别名称不能为空!";
ixy = 1;
}
}
if (ixy == 0)
{
String jcy_yuanname = "select zbmc from jcy_zb where zbdm = '"+zbdm_id+"'";
sun.jdbc.rowset.CachedRowSet jcy_zbyuanname = std.getResultBySelect(jcy_yuanname);
jcy_zbyuanname.next();
String zbyuanname = jcy_zbyuanname.getString(1);
if (!zbyuanname.equals(zbmc))
{
String jcy_zbmodifyname = "select count(*) from jcy_zb where zbmc = '"+zbmc+"'";
sun.jdbc.rowset.CachedRowSet jcy_zbmodify = std.getResultBySelect(jcy_zbmodifyname);
jcy_zbmodify.next();
String zbmodifyname = jcy_zbmodify.getString(1);
out.print(zbyuanname);
if (!zbmodifyname.equals("0"))
{
imager = "已经有此组名";
ixy = 1;
}else
{
//修改组别信息
String sql_update = "update jcy_zb set zbmc='"+zbmc+"', blrq=to_date('"+blrq+"','YYYY.MM.DD'), lxdh='"+lxdh+"',bz='"+bz+"',dwdm='"+dwdm+"'where zbdm = '"+zbdm_id+"'";
int isu = std.getResultByUpdate(sql_update);
if (isu == 1)
{
imager = "修改成功!";
}
else
{
ixy = 1;
imager = "修改失败!";
}
}
}
else
{
//修改组别信息
String sql_update = "update jcy_zb set zbmc='"+zbmc+"', blrq=to_date('"+blrq+"','YYYY.MM.DD'), lxdh='"+lxdh+"',bz='"+bz+"',dwdm='"+dwdm+"'where zbdm = '"+zbdm_id+"'";
int isu = std.getResultByUpdate(sql_update);
if (isu == 1)
{
imager = "修改成功!";
}
else
{
ixy = 1;
imager = "修改失败!";
}
}
}
}
//删除组别
if ( szt.equals("del"))
{
if (ixy == 0)
{
String zbdmry = "";
String sql_rs = "select count(*) from jcy_ry where zbdm = '"+zbdm_id+"'";
sun.jdbc.rowset.CachedRowSet ii = std.getResultBySelect(sql_rs);
ii.next();
zbdmry = ii.getString(1);
if (zbdmry.equals("0"))
{
String sql_del = "delete from jcy_zb where zbdm = '"+zbdm_id+"' ";
int idel = std.getResultByUpdate(sql_del);
if (idel == 1)
{
imager = "删除成功!";
}
else
{
ixy = 1;
imager = "删除失败!";
}
}
else
{
imager = "请先删除此组成员!";
ixy = 1;
}
}
}
%>
<head>
<title>
</title>
</head>
<body onLoad="parent.f_imager('<%=imager%>','<%=ixy%>')">
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -