📄 jcy_dw_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 dwdm_id = std.getValue(request,"ID"); //单位代码
String szt = std.getValue(request,"zt"); //按钮类别
String imager = "";
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("B0500013") == false) //判断是否有删除权限
{
%>
<Script Language=javascript>
alert("您没有操作此页权限！")
window.open("../index.jsp","_top")
</Script>
<% return;
}
}
if (szt.equals("modify"))
{
if (jcypurview.purviewVerdict("B0500011") == false) //判断是否有修改权限
{
%>
<Script Language=javascript>
alert("您没有操作此页权限！")
window.open("../index.jsp","_top")
</Script>
<% return;
}
}
if (szt.equals("new"))
{
if (jcypurview.purviewVerdict("B0500012") == false) //判断是否有新增权限
{
%>
<Script Language=javascript>
alert("您没有操作此页权限！")
window.open("../index.jsp","_top")
</Script>
<% return;
}
}
if (szt.equals("ret"))
{
if (jcypurview.purviewVerdict("B0500018") == 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 dwmc = std.getValue(request,"dwmc").trim(); //公务单位名称
if (dwmc.equals(""))
{
ixy = 1;
imager = "单位名称不能为空!";
}
if (ixy != 1)
{
if (dwmc.length() > 80)
{
ixy = 1;
imager = "单位名称长度不能大于80个字符!";
}
}
String qx = std.getValue(request,"qx"); //所属区县
if (ixy != 1)
{
if (qx.equals("0"))
{
ixy = 1;
imager = "所属区县不能为空";
}
}
out.print(qx);
String jdbm = std.getValue(request,"jdbm"); //所属街道
if (ixy !=1)
{
if (jdbm == null)
{
ixy = 1;
imager = "请检查数据库是否接连正常?";
}
}
if (ixy !=1)
{
if (!qx.equals("001000"))
{
if (jdbm.equals("")||jdbm.equals("-1"))
{
ixy = 1;
imager = "街道名称不能为空！";
}
}
}
String szdz = std.getValue(request,"dwdz").trim(); //单位地址
if (ixy !=1)
{
if (szdz.length() > 200)
{
ixy = 1;
imager = "单位地址长度不能大于200个字符!";
}
}
String lxdh = std.getValue(request,"lxdh").trim(); //联系电话
if (ixy !=1)
{
if (lxdh.length() > 40)
{
ixy = 1;
imager = "联系电话长度不能大于40个字符!";
}
}
if (ixy !=1)
{
if (lxdh.equals(""))
{
ixy = 1;
imager = "联系电话不能为空!";
}
}
String bz = std.getValue(request,"bz").trim(); //备注
if (ixy !=1)
{
if (bz.length() > 200)
{
ixy = 1;
imager = "备注不能大于200个字符!";
}
}
if (ixy == 0)
{
//取人员
String lrrq = std.getDateStr("YYYY.MM.DD"); //取数据库时间
String dwdm ="SELECT LPAD(SEQ_jcyID.NEXTVAL,10,'0') FROM DUAL"; //单位序号
sun.jdbc.rowset.CachedRowSet crs = std.getResultBySelect("SELECT LPAD(SEQ_jcyID.NEXTVAL,10,'0') FROM DUAL");
crs.next();
String suserid = crs.getString(1);
//新增单位信息
String sql_insert = "insert into jcy_dw (dwdm) values ('"+suserid+"')";
int isi = std.getResultByUpdate(sql_insert);
if (isi == 1 )
{
String sql_update = "update jcy_dw set dwmc='"+dwmc+"',qx = substr('"+qx+"',1,3), jdbm='"+jdbm+"', szdz='"+szdz+"',lxdh='"+lxdh+"',yxbz='01',bz='"+bz+"',blrq=to_date('"+lrrq+"','YYYY.MM.DD'),jbr='"+nowuserid+"' where dwdm = '"+suserid+"'";
int isu = std.getResultByUpdate(sql_update);
if (isu == 1)
{
imager = "保存成功!";
//return;
}else
{
ixy = 1;
imager = "保存失败!";
}
}
}
}
//修改单位
if (szt.equals("modify"))
{
String dwmc = std.getValue(request,"dwmc").trim(); //公务单位名称
if (dwmc.equals(""))
{
imager = "单位名称不能为空!";
ixy = 1;
}
if (ixy != 1)
{
if (dwmc.length() > 80)
{
imager = "单位名称长度不能大于80位!";
ixy = 1;
}
}
String qx = std.getValue(request,"qx"); //所属区县
if (ixy != 1)
{
if (qx.equals("0"))
{
ixy = 1;
imager = "所属区县不能为空";
}
}
String jdbm = std.getValue(request,"jdbm"); //所属街道
if (ixy !=1)
{
if (jdbm == null)
{
imager = "所属街道不能为空";
ixy = 1;
}
}
if (ixy !=1)
{
if (!qx.equals("001000"))
{
if (jdbm.equals("")||jdbm.equals("-1"))
{
ixy = 1;
imager = "街道代码不能为空！";
}
}
}
String szdz = std.getValue(request,"dwdz").trim(); //单位地址
if (ixy !=1)
{
if (szdz.length() > 200)
{
imager = "单位地址长度不能大于200个字符!";
ixy = 1;
}
}
String lxdh = std.getValue(request,"lxdh").trim(); //联系电话
if (ixy !=1)
{
if (lxdh.length() > 40)
{
imager = "联系电话长度不能大于40个字符!";
ixy = 1;
}
}
if (ixy !=1)
{
if (lxdh.equals(""))
{
ixy = 1;
imager = "联系电话不能为空!";
}
}
String bz = std.getValue(request,"bz").trim(); //备注
if (ixy !=1)
{
if (bz.length() > 200)
{
imager = "备注不能大于200个字符!";
ixy = 1;
}
}
String lrrq = std.getDateStr("YYYY.MM.DD"); //取数据库时间
if(ixy == 0)
{
String sql_qxrybd = "select qx from jcy_dw where dwdm = '"+dwdm_id+"'";
sun.jdbc.rowset.CachedRowSet dw_qxrybd = std.getResultBySelect(sql_qxrybd);
dw_qxrybd.next();
String qxdwry = dw_qxrybd.getString(1);
String a = qx.substring(0,3);
//out.print(qxdwry+"--"+a);
if (!qxdwry.equals(a))
{
String sql_qxry = "select count(*) from jcy_ry where dwdm = '"+dwdm_id+"'";
sun.jdbc.rowset.CachedRowSet dw_qxry = std.getResultBySelect(sql_qxry);
dw_qxry.next();
String dwry = dw_qxry.getString(1);
if (dwry.equals("0"))
{
String sql_modify_update = "update jcy_dw set dwmc='"+dwmc+"', qx = substr('"+qx+"',1,3), jdbm='"+jdbm+"', szdz='"+szdz+"',lxdh='"+lxdh+"',bz='"+bz+"',blrq=to_date('"+lrrq+"','YYYY.MM.DD'),jbr='"+nowuserid+"' where dwdm = '"+dwdm_id+"'";
int imodify = std.getResultByUpdate(sql_modify_update);
if (imodify == 1 )
{
imager = "修改成功!";
}else
{
ixy = 1;
imager = "修改失败!";
}
}else
{
ixy =1;
imager = "此单位下有人员，不能修改区县!";
}
}else
{
String sql_modify_update = "update jcy_dw set dwmc='"+dwmc+"', qx = substr('"+qx+"',1,3), jdbm='"+jdbm+"', szdz='"+szdz+"',lxdh='"+lxdh+"',bz='"+bz+"',blrq=to_date('"+lrrq+"','YYYY.MM.DD'),jbr='"+nowuserid+"' where dwdm = '"+dwdm_id+"'";
int imodify = std.getResultByUpdate(sql_modify_update);
if (imodify == 1 )
{
imager = "修改成功!";
}else
{
ixy = 1;
imager = "修改失败!";
}
}
}
}
//单位减少信息
if(szt.equals("del"))
{
String sql_ry = "select count(*) from jcy_ry where dwdm = '"+dwdm_id+"'";
sun.jdbc.rowset.CachedRowSet dw_ry = std.getResultBySelect(sql_ry);
dw_ry.next();
String dwry = dw_ry.getString(1);
if (dwry.equals("0"))
{
String sql_del = "update jcy_dw set yxbz='02'where dwdm = '"+dwdm_id+"'";
int idel = std.getResultByUpdate(sql_del);
if (idel == 1)
{
imager = "单位减少成功！";
}
else
{
ixy = 1;
imager = "单位减少失败！";
}
}
else
{
ixy =1;
imager = "请先删除单位下的人员信息!";
}
}
//单位恢复
if(szt.equals("ret"))
{
String sql_ret= "update jcy_dw set yxbz='01'where dwdm = '"+dwdm_id+"'";
int iret = std.getResultByUpdate(sql_ret);
if (iret == 1)
{
imager = "单位恢复成功！";
}else
{
ixy = 1;
imager = "单位恢复失败！";
}
}
%>
<head>
<title>
</title>
</head>
<body onLoad="parent.f_imager('<%=imager%>','<%=ixy%>')">
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -