📄 sysmanbean.java
字号:
//根据配置名称得到配置数值
public String getPZSZ(String pzmc)
{
String pzsz = "";
String sql = "select PZSZ from CODE_XTPZ where PZMC='"+ ds.toString(pzmc) +"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
pzsz = ds.toString(String.valueOf(rs.getInt(1)));
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return pzsz;
}
//增加系统配置数据记录
public int addConf(Hashtable hash)
{
int intPZBH = db.makeID("CODE_XTPZ","PZBH","","",true);
String strPZMC = ds.toString((String)hash.get("PZMC"));
String strPZSZ = ds.toString((String)hash.get("PZSZ"));
String strPZSM = ds.toString((String)hash.get("PZSM"));
Vector vect = new Vector();
vect.add("CODE_XTPZ");
vect.add(addVector("PZBH",String.valueOf(intPZBH),"NUM"));
vect.add(addVector("PZMC",strPZMC,"CHAR"));
vect.add(addVector("PZSZ",strPZSZ,"NUM"));
vect.add(addVector("PZSM",strPZSM,"CHAR"));
//检验是否已经存在
ResultSet rs = selectRecord("select * from CODE_XTPZ where PZMC='"+strPZMC+"'");
Statement stmt = null;
try{
if(!rs.next())
return insertRecord(vect);
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return 1;
}
//修改字典数据记录
public int modDict(Hashtable hash)
{
String strXMMC = ds.toString((String)hash.get("XMMC"));
String strSYZT = ds.toString((String)hash.get("SYZT"));
String strJBXH = ds.toString((String)hash.get("JBXH"));
// id = ds.toString((String)hash.get("XMBH"));
// dictname = ds.toString((String)hash.get("ZDMC"));
//////////////// and SYZT=0
ResultSet rs1 = selectRecord(
"select JBXH from CODE_ZDB where XMBH='"
+ id
+ "' and ZDMC='"
+ dictname
+ "'");
int yjbxh=999;
Statement stmt = null;
try{
if(rs1.next())
yjbxh=Integer.parseInt(rs1.getString("JBXH"));///////////////
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
int jbxh=Integer.parseInt(strJBXH);
int maxjbNo=makeID("CODE_ZDB","ZDMC","JBXH",dictname,false);
if(jbxh==0||jbxh>=maxjbNo)
{ jbxh=maxjbNo-1;strJBXH=""+jbxh;}
if(jbxh < yjbxh){
String sql="update CODE_ZDB set jbxh=jbxh+1 where ZDMC='"
+ dictname
+ "' and JBXH >="
+ jbxh
+ " and JBXH<"
+ yjbxh;
deleteRecord(sql);
}
else if(jbxh > yjbxh && yjbxh!=0){
String sql="update CODE_ZDB set jbxh=jbxh-1 where ZDMC='"
+ dictname
+ "' and JBXH <="
+ jbxh
+ " and JBXH>"
+ yjbxh;
deleteRecord(sql);
}
///////////////////////
Vector vect = new Vector();
vect.add("CODE_ZDB");
vect.add(addVector("XMMC",strXMMC,"CHAR"));
vect.add(addVector("SYZT",strSYZT,"NUM"));
vect.add(addVector("JBXH",strJBXH,"NUM"));
vect.add("ZDMC='"+dictname+"' and XMBH="+id+"");
return updateRecord(vect);
}
//修改操作权限数据记录
public int modOper(Hashtable hash)
{
String strMKMC = ds.toString((String)hash.get("MKMC"));
String strMKSM = ds.toString((String)hash.get("MKSM"));
String strCZLX = ds.toString((String)hash.get("CZLX"));
String strMRCZ = ds.toString((String)hash.get("MRCZ"));
String strSYZT = ds.toString((String)hash.get("SYZT"));
Vector vect = new Vector();
vect.add("CODE_CZQXB");
vect.add(addVector("MKMC",strMKMC,"CHAR"));
vect.add(addVector("MKSM",strMKSM,"CHAR"));
vect.add(addVector("CZLX",strCZLX,"NUM"));
vect.add(addVector("MRCZ",strMRCZ,"NUM"));
vect.add(addVector("SYZT",strSYZT,"NUM"));
vect.add("MKBH="+id+"");
return updateRecord(vect);
}
//修改按钮操作权限数据记录
public int modOper_new(Hashtable hash)
{
String strMKMC = ds.toString((String)hash.get("MKMC"));
String strMKSM = ds.toString((String)hash.get("MKSM"));
String strANMC = ds.toString((String)hash.get("ANMC"));
String strANSM = ds.toString((String)hash.get("ANSM"));
String strMRCZ = ds.toString((String)hash.get("MRCZ"));
String strSYZT = ds.toString((String)hash.get("SYZT"));
Vector vect = new Vector();
vect.add("CODE_ANCZQXB");
vect.add(addVector("MKMC", strMKMC,"CHAR"));
vect.add(addVector("MKSM", strMKSM,"CHAR"));
vect.add(addVector("ANMC",strANMC ,"CHAR"));
vect.add(addVector("ANSM", strANSM,"CHAR"));
vect.add(addVector("MRCZ",strMRCZ ,"NUM"));
vect.add(addVector("SYZT", strSYZT,"NUM"));
vect.add("ID="+id+"");
updateRecord(vect);
PublicData.rebuildButtonTable();
PublicData.rebuildRightVector();
return 0;
}
//修改流程权限数据记录
public int modFlow(Hashtable hash)
{
String strMKMC = ds.toString((String)hash.get("MKMC"));
String strDYLX = ds.toString((String)hash.get("DYLX"));
String strMKSM = ds.toString((String)hash.get("MKSM"));
String strMRCZ = ds.toString((String)hash.get("MRCZ"));
String strSYZT = ds.toString((String)hash.get("SYZT"));
String strJBXH = ds.toString((String)hash.get("JBXH"));
// id = ds.toString((String)hash.get("MKBH"));
//////////////// and SYZT=0
ResultSet rs1 = selectRecord(
"select JBXH from CODE_LCQXB where MKBH="
+ id
+ "");
int yjbxh=999;
Statement stmt = null;
try{
if(rs1.next())
yjbxh=Integer.parseInt(rs1.getString("JBXH"));///////////////
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
int jbxh=Integer.parseInt(strJBXH);
int maxjbNo=makeID("CODE_LCQXB","JBXH","","",true);
if(jbxh==0||jbxh>=maxjbNo)
{ jbxh=maxjbNo-1;strJBXH=""+jbxh;}
if(jbxh < yjbxh){
String sql="update CODE_LCQXB set jbxh=jbxh+1 where JBXH >="
+ jbxh
+ " and JBXH <"
+ yjbxh;
deleteRecord(sql);
}
else if(jbxh > yjbxh && yjbxh!=0){
String sql="update CODE_LCQXB set jbxh=jbxh-1 where JBXH <="
+ jbxh
+ " and JBXH >"
+ yjbxh;
deleteRecord(sql);
}
///////////////////////
Vector vect = new Vector();
vect.add("CODE_LCQXB");
vect.add(addVector("MKMC",strMKMC,"CHAR"));
vect.add(addVector("DYLX",strDYLX,"NUM"));
vect.add(addVector("MKSM",strMKSM,"CHAR"));
vect.add(addVector("MRCZ",strMRCZ,"NUM"));
vect.add(addVector("SYZT",strSYZT,"NUM"));
vect.add(addVector("JBXH",strJBXH,"NUM"));
vect.add("MKBH="+id+"");
updateRecord(vect);
PublicData.rebuildFlowVector();
return 0;
}
//修改系统配置数据记录
public int modConf(Hashtable hash)
{
String strPZMC = ds.toString((String)hash.get("PZMC"));
String strPZSZ = ds.toString((String)hash.get("PZSZ"));
String strPZSM = ds.toString((String)hash.get("PZSM"));
Vector vect = new Vector();
vect.add("CODE_XTPZ");
vect.add(addVector("PZMC",strPZMC,"CHAR"));
vect.add(addVector("PZSZ",strPZSZ,"NUM"));
vect.add(addVector("PZSM",strPZSM,"CHAR"));
vect.add("PZBH = "+id+"");
return updateRecord(vect);
}
//删除数据记录
public int delData()
{
String sql="";
String sqlxh="";
String strSYZT="1";
switch (type)
{
case 1: sql = "update CODE_ZDB set SYZT = "+strSYZT+" where ZDMC='"+dictname
+"' and XMBH="+id+"";
break;
case 2: sql = "update CODE_CZQXB set SYZT = "+strSYZT+" where MKBH="+id+"";
break;
case 3: sql = "update CODE_LCQXB set SYZT = "+strSYZT+" where MKBH="+id+"";
break;
case 4: sql = "delete from CODE_XTPZ where PZBH = "+id+"";
break;
case 5: sql = "delete from CODE_ANCZQXB where ID = "+id;
break;
case 11: sql = "delete from CODE_ZDB where SYZT=1 and ZDMC='"+dictname
+"' and XMBH="+id+"";
executeUpdate("update CODE_ZDB set JBXH=JBXH-1 where ZDMC='"
+dictname+"' and JBXH > (select JBXH from CODE_ZDB where SYZT=1 and ZDMC='"
+dictname+"' and XMBH="+id+")");
break;
case 13: sql = "delete CODE_LCQXB where SYZT=1 and MKBH="+id+"";
executeUpdate("update CODE_LCQXB set JBXH=JBXH-1 where "
+"JBXH > (select JBXH from CODE_LCQXB where SYZT=1 and and MKBH="+id+")");
break;
default:break;
}
if(!sql.equals(""))
{
deleteRecord(sql);
if(type==5){
PublicData.rebuildButtonTable();
PublicData.rebuildRightVector();
}
if(type==3)
PublicData.rebuildFlowVector();
}
return 0;
}
public int revert()
{
String sql="";
String sqlxh="";
String strSYZT="0";
switch (type)
{
case 1: sql = "update CODE_ZDB set SYZT = "+strSYZT+" where ZDMC='"+dictname
+"' and XMBH="+id+"";
break;
case 2: sql = "update CODE_CZQXB set SYZT = "+strSYZT+" where MKBH="+id+"";
break;
case 3: sql = "update CODE_LCQXB set SYZT = "+strSYZT+" where MKBH="+id+"";
break;
default:break;
}
if(!sql.equals(""))
{
deleteRecord(sql);
if(type==3)
PublicData.rebuildFlowVector();
}
return 0;
}
public String isWho(String zgbh)
{//判断当前人员的身份new
String bmno = getBMBH(zgbh);
String sql = "";
String admin="",ws="";
if(bmno!=null && !bmno.equals(""))
sql = " select GLYZWBH,WSZWBH from ZZ_BMB where BMBH = '"+bmno+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
admin = ds.toString(rs.getString("GLYZWBH"));
ws = ds.toString(rs.getString("WSZWBH"));
if(admin.equals(zgbh) || (admin.equals(zgbh) && ws.equals(zgbh))){
return "bmadmin";
}
else if(ws.equals(zgbh)){
return "bmws";
}
}
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return "person";
}
public String getBMBH(String strPersonNO)//取得当前人员所在部门的部门编号new
{
String sql = "";
String name = "";
sql = " select BMBH from ZZ_ZGB where ZGBH = '"+strPersonNO+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
name = ds.toString(rs.getString("BMBH"));
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return name;
}
public static void main(String args[])
{
SysmanBean mb = new SysmanBean();
mb.setType(1);
mb.setID("1");
mb.setDictname("字典名称111111111111111111");
System.out.println("begin\r\n\r\n");
Hashtable hash= new Hashtable();
hash.put("ZDMC","字典名称111111111111111111");
hash.put("XMMC","项目名称11111111111111111111");
hash.put("SYZT","0");
//mb.addDict(hash);
System.out.println(mb.getOneData());
System.out.println("\r\n\r\nend");
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -