📄 khxxzd_save.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<%@page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<%
if((session.getValueNames()).length==0)
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/sysmang/loginagain.html';");
out.println("</SCRIPT>");
return;
}
java.lang.String act=((java.lang.String)request.getParameter("ACT")).trim();
int iAct=Integer.parseInt(act);
/******************************************************
*操作参数(ACT)说明：
* 2:修改
* 3:增加
* 4:删除
******************************************************/
try
{
int i=0;
int iorder=0;
boolean bret;
java.lang.String sql="";
java.sql.ResultSet rs=null; //查询结果集;
java.lang.String chaList[];
java.lang.String strKhbm="";
java.lang.String strKhmc="";
java.lang.String strKhbz="";
java.lang.String strKhbzFirst="";
java.lang.String strKhbzSecond="";
java.lang.String strJgbm="";
java.lang.String strKhbmList[];
java.lang.String strKhmcList[];
java.lang.String strKhbzFirstList[];
java.lang.String strKhbzSecondList[];
java.lang.String selectedJgbm =((java.lang.String)(request.getParameter("jgbmlist"))).trim();
java.lang.String selectedRybm =((java.lang.String)(request.getParameter("rybmlist"))).trim();
switch(iAct)
{
case 2:
//修改
chaList=request.getParameterValues("UKHBMCHECK");
strKhbmList=request.getParameterValues("UKHBM");
strKhmcList=request.getParameterValues("UKHMC");
strKhbzFirstList=request.getParameterValues("UKHLB");
strKhbzSecondList=request.getParameterValues("UKHJB");
if(chaList == null)
{
out.println(DbBean.AlertMsg("没有选中修改的记录!"));
break;
}
else
{
DbBean.prepare();
for(i=0;i<chaList.length;i++)
{
iorder = Integer.parseInt(chaList[i]);
strKhbz = strKhbzFirstList[iorder] + strKhbzSecondList[iorder];
sql="UPDATE KHXXZD SET KHMC = '" + strKhmcList[iorder] + "', KHBZ = '" + strKhbz + "' WHERE KHBM = '" + strKhbmList[iorder] + "'";
DbBean.insertUpdate(sql);
}
DbBean.exeInsert();
}
out.println("<br>修改成功！");
break;
case 3:
//增加
java.lang.String strKhxh=""; //客户编码序号;
java.lang.String strRightXh=""; //8位客户编码的前缀;
int ikhxh;
strKhmc =((java.lang.String)(request.getParameter("NKHMC"))).trim();
strKhbzFirst=((java.lang.String)(request.getParameter("NKHLB"))).trim();
strKhbzSecond=((java.lang.String)(request.getParameter("NKHJB"))).trim();
strKhbz = strKhbzFirst + strKhbzSecond;
if(strKhmc.equals(""))
{
out.println(DbBean.AlertMsg("新增客户信息数据不完整!"));
break;
}
else
{
//从参数字典中获取客户编码：取，增，存操作，但要注意锁表；
//-----需要先锁表,最好是锁记录----
DbBean.prepare();
sql="SELECT CSZ FROM CSZD WITH (ROWLOCK) WHERE CSBM = 'KHBM'";
rs = DbBean.sqlQuery2(sql);
if(rs.next())
{
strKhxh=(rs.getString("CSZ")).trim();
ikhxh = Integer.parseInt(strKhxh);
ikhxh++;
//保存到CSZD表里；
sql="UPDATE CSZD SET CSZ='" + ikhxh + "' WHERE CSBM = 'KHBM'";
DbBean.insertUpdate(sql);
}
DbBean.exeInsert(); //提交事物，对CSZD解锁;
//对客户编号序号的处理----根据序号，构造 8 位的客户编码；
if(strKhxh.length() < 8)
{
for(i=0; i< (8-strKhxh.length()); i++)
{
strRightXh = strRightXh + "0";
}
strKhbm = strRightXh + strKhxh;
}
//检测客户编码是否已经占用？？
sql="SELECT KHXXZD.KHBM FROM DBO.KHXXZD WHERE KHBM = '" + strKhbm + "'";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
out.println(DbBean.AlertMsg("该客户编码[" + strKhbm + "]已经被使用，请您与系统管理员联系!"));
break;
}
//查询当前客户经理所在机构的编码
sql="SELECT RYZD.JGBM FROM DBO.RYZD WHERE RYBM = '" + selectedRybm + "'";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
strJgbm=(rs.getString("JGBM")).trim();
}
else
{
out.println(DbBean.AlertMsg("没有查询到当前客户经理客户编码[" + selectedRybm + "]所在机构的编码，请您与系统管理员联系!"));
break;
}
//增加客户信息记录
DbBean.prepare();
sql="INSERT INTO DBO.KHXXZD (JGBM, KHBM, KHMC, RYBM, KHBZ) VALUES ('" + strJgbm + "', '" + strKhbm + "', '" + strKhmc + "', '" + selectedRybm + "', '" + strKhbz + "')";
DbBean.insertUpdate(sql);
DbBean.exeInsert();
}
out.println("<br>增加成功！");
break;
case 4:
//删除
chaList=request.getParameterValues("DKHBMCHECK");
strKhbmList=request.getParameterValues("DKHBM");
DbBean.prepare();
//查询当前客户经理所在机构的编码
sql="SELECT RYZD.JGBM FROM DBO.RYZD WHERE RYBM = '" + selectedRybm + "'";
rs=DbBean.sqlQuery2(sql);
if(rs.next())
{
strJgbm=(rs.getString("JGBM")).trim();
}
else
{
out.println(DbBean.AlertMsg("没有查询到当前客户经理客户编码[" + selectedRybm + "]所在机构的编码，请您与系统管理员联系!"));
break;
}
if(chaList==null)
{
out.println(DbBean.AlertMsg("没有选中要删除的客户!"));
break;
}
else
{
for(i=0;i<chaList.length;i++)
{
iorder = Integer.parseInt(chaList[i]);
//sql="DELETE FROM DBO.KHXXZD WHERE JGBM = '" + selectedJgbm + "' AND KHBM ='" + strKhbmList[iorder] + "'";
sql="DELETE FROM DBO.KHXXZD WHERE JGBM = '" + strJgbm + "' AND KHBM ='" + strKhbmList[iorder] + "'";
DbBean.insertUpdate(sql);
}
}
DbBean.exeInsert();
out.println("<br>删除成功！");
break;
default:
java.sql.SQLException exception = new java.sql.SQLException("参数传递错误！");
throw exception;
}
%>
<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<TITLE>
客户信息字典维护保存
</TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
</HEAD>
<BODY onLoad="self.location='khxxzd.jsp?isFirst=2&jgbmlist=<%=selectedJgbm%>&rybmlist=<%=selectedRybm%>'">
<!--BODY onLoad="self.location='khxxzd.jsp?isFirst=0&jgbmlist=<%=selectedJgbm%>&rybmlist=<%=selectedRybm%>'"-->
<br><br>
<CENTER>
<INPUT TYPE="button" name="test" value="返回" onclick="history.back()">
</CENTER>
</BODY>
</HTML>
<%
System.gc();
} catch( Throwable e)
{
DbBean.clear();
if(((e.getMessage())).equals("ResultSet is closed"))
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/blank.html';");
out.println("</SCRIPT>");
}
else if(e.getMessage()==null)
{
out.println("服务已经重启，您闲置的时间太长或系统调用错误，请重新登入试一下！<br>如果再出现这种情况请与系统维护员联系！");
}
else out.println(e.getMessage());
System.gc();
return;
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -