?? 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 + -