📄 departmentbean.java
字号:
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.addRec(Hashtable)关闭声明时statement出错"+e);}
}
if(newNo.equals(getOrgNo(newNo))){//新加入的部门是二级部门，加入新闻类别
OrgMenuBean omb = null;
try{
omb = new OrgMenuBean();
omb.initialMenu(newNo);
}finally{
if(omb!=null) omb.closeConn();
}
}
if(rebuild)
rebuildTree();
return 0;
////////////////////
}
//增加一条纪录,返回此部门编号
public int addRec(Hashtable ht)
{
return addRec(ht,true);
}
//修改一条纪录(由公共变量-部门编号depno确定)、
public int modRec(Hashtable ht, String flg){
String bmNo = ds.toString((String) ht.get("BMBH"));
String bmName = ds.toString((String) ht.get("BMMC"));
String bossNo = ds.toString((String) ht.get("TZWBH"));
String admin = ds.toString((String) ht.get("GLYZWBH"));
String ws = ds.toString((String) ht.get("WSZWBH"));
String jbNo = ds.toString((String) ht.get("JBXH"));
String ckqx = ds.toString((String) ht.get("CKQX"));
String[] ckqxMax = null;
String psNo = "";
String strMax = "";
String sql = "";
//要考虑父部门变了，则此条部门纪录""挂起""，要重新编号添加一条纪录
Vector sqlvt = new Vector();
String fatherNo=getFatherNo();
ResultSet rs1 = selectRecord(
"select JBXH from ZZ_BMB where BMMC='"
+ bmName
+ "' and BMFBH='"
+ fatherNo
+ "' and BMZT=0");
int yjbxh=999;
Statement stmt = null;
try{
if(rs1.next())
yjbxh=Integer.parseInt(rs1.getString("JBXH"));
}catch(Exception e){System.out.println("DepartmentBean.modRec(Hashtable,String)运行时出错："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("DepartmentBean.modRec(Hashtable,String)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.modRec(Hashtable,String)关闭声明时statement出错"+e);}
}
if (flg.equals("0")) { //父部门没变
///////////////
int jbxh=0;
if(!jbNo.equals(""))
jbxh=Integer.parseInt(jbNo);
int maxjbNo=makeID("ZZ_BMB","BMFBH","BMZT","JBXH",fatherNo,"0",false,true);
if(jbxh==0||jbxh>=maxjbNo)
{ jbxh=maxjbNo-1;jbNo=""+jbxh;}
if(jbxh < yjbxh){
String sql1="update ZZ_BMB set jbxh=jbxh+1 where BMFBH='"
+ fatherNo
+ "' and BMZT=0 and JBXH >="
+ jbxh
+ " and JBXH<"
+ yjbxh;
deleteRecord(sql1);
}
else if(jbxh > yjbxh && yjbxh!=0){
String sql2="update ZZ_BMB set jbxh=jbxh-1 where BMFBH='"
+ fatherNo
+ "' and BMZT=0 and JBXH <="
+ jbxh
+ " and JBXH>"
+ yjbxh;
deleteRecord(sql2);
}
///////////////////////
sqlvt.add("ZZ_BMB");
sqlvt.add(addVector("BMMC", bmName, "CHAR"));
sqlvt.add(addVector("TZWBH", bossNo, "CHAR"));
sqlvt.add(addVector("JBXH", jbNo, "CHAR"));
sqlvt.add(addVector("GLYZWBH", admin, "CHAR"));
sqlvt.add(addVector("WSZWBH", ws, "CHAR"));
sqlvt.add(addVector("BMZT", "0", "NUM"));
sqlvt.add(addVector("CKQX", ckqx, "CHAR"));
sqlvt.add("BMBH='" + bmNo + "'");
updateRecord(sqlvt);
rebuildTree();
return 0;
}
else { //父部门变了，则此条部门纪录""挂起""
/* String sql3="update ZZ_BMB set jbxh=jbxh-1 where BMFBH='"
+ fatherNo
+ "' and BMZT=0 and JBXH >="
+ yjbxh;
deleteRecord(sql3);
sqlvt.add("ZZ_BMB");
sqlvt.add(addVector("BMZT", "1", "NUM"));
sqlvt.add("BMBH='" + bmNo + "'");*/
depNo = bmNo;
return delRec();
}
}
//删除一条纪录(由公共变量-部门编号depNo确定)
//考虑部门下是否有纪录 有返回false,无纪录删除(挂起)并返回true
public int delRec(){
String sql1 = "", sql2 = "",sql3="";
String strBMZT = "1";
sql1 = "select * from ZZ_BMB where BMFBH = '" + depNo + "' and BMZT=0";
sql2 = "select * from ZZ_ZWB where BMBH = '" + depNo + "' and ZWZT=0";
sql3 = "select * from ZZ_ZGB where BMBH = '" + depNo + "' and ZZZT=0";
ResultSet rs1 = selectRecord(sql1);
ResultSet rs2 = selectRecord(sql2);
ResultSet rs3 = selectRecord(sql3);
Statement stmt = null;
try{
if (rs1.next()) {
return -2; //部门下有子部门，不能删除该部门
}
///判断部门下有没有人
if(rs3.next())
{
return -4; //部门下有人，不能删除该部门
}
if (rs2.next()) {
stmt = rs2.getStatement();
rs2.close();
stmt.close();
sql2 = "select * from ZZ_ZGZWB where BMBH = '" + depNo + "'";
rs2 = selectRecord(sql2);
if (rs2.next()) {
return -3; //部门下的职务有人担当，不能删除部门
}
else {
sql1 =
"update ZZ_ZWB set ZWZT=1 where BMBH = '"
+ depNo
+ "' and ZWZT=0";
/* sql2 =
"update ZZ_BMB set BMZT=1 where BMBH = '"
+ depNo
+ "' and BMZT=0";*/
deleteRecord(sql1);
}
}
}catch(Exception e){System.out.println("DepartmentBean.delRec()运行时出错："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭声明时statement出错"+e);}
if(rs2!=null)try{ stmt = rs2.getStatement(); rs2.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭声明时statement出错"+e);}
if(rs3!=null)try{ stmt = rs3.getStatement(); rs3.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭声明时statement出错"+e);}
}
//////////////////////
String fatherNo=getFatherNo();
ResultSet rst = selectRecord(
"select JBXH from ZZ_BMB where BMBH = '"
+ depNo
+ "' and BMFBH='"
+ fatherNo
+ "' and BMZT=0");
int yjbxh=999;
try{
if(rst.next())
yjbxh=Integer.parseInt(rst.getString("JBXH"));
}catch(Exception e){System.out.println("DepartmentBean.delRec()运行时出错："+e);}
finally{
if(rst!=null)try{ stmt = rst.getStatement(); rst.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()关闭声明时statement出错"+e);}
}
String sql="update ZZ_BMB set jbxh=jbxh-1 where BMFBH='"
+ fatherNo
+ "' and BMZT=0 and JBXH >"
+ yjbxh;
deleteRecord(sql);
/////////////////////
sql = "update ZZ_BMB set BMZT=1 where BMBH='" + depNo + "'";
deleteRecord(sql);
rebuildTree();
return 0;
}
public String toName()
{
return db.toName("ZZ_BMB", "BMBH", "BMMC", depNo);
}
public String toName(String depno)
{
return db.toName("ZZ_BMB", "BMBH", "BMMC", depno);
}
public String getJBNo(){
String jbNo = "", maxNo = "0";
int ljbNo = -1, lmaxNo = 0;
String sql = "select JBXH from ZZ_BMB where BMFBH='" + depNo + "' and BMZT=0";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
while (rs.next()) { //取得本部门的级别序号的最大编号
jbNo = ds.toString(rs.getString("JBXH"));
ljbNo = Integer.parseInt(jbNo);
if (ljbNo > lmaxNo) {
lmaxNo = ljbNo;
maxNo = jbNo;
}
}
}catch(Exception e){System.out.println("DepartmentBean.getJBNo()运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getJBNo()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getJBNo()关闭声明时statement出错"+e);}
}
jbNo = String.valueOf(lmaxNo + 1);
return jbNo;
}
//返回父编号
public String getFatherNo(){
String sql = "select BMFBH from ZZ_BMB where BMBH='" + depNo + "'";
ResultSet rs = selectRecord(sql);
String fatherNo = "";
Statement stmt = null;
try{
if (rs.next())
fatherNo = ds.toString(rs.getString("BMFBH"));
}catch(Exception e){System.out.println("DepartmentBean.getFatherNo()运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getFatherNo()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getFatherNo()关闭声明时statement出错"+e);}
}
return fatherNo;
}
public String getBmNo(String bmName)//根据部门名称返回部门编号
{ //暂且没用，部门名称有相同的
String sql = "select BMBH from ZZ_BMB where BMMC='" + bmName + "'";
ResultSet rs = selectRecord(sql);
String bmNo = "";
Statement stmt = null;
try{
if (rs.next())
bmNo = ds.toString(rs.getString("BMBH"));
}catch(Exception e){System.out.println("DepartmentBean.getBmNo(String)运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getBmNo(String)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getBmNo(String)关闭声明时statement出错"+e);}
}
return bmNo;
}
public String getBossDutyNo(String bossName)//根据职务名称返回职务编号
{
String sql =
"select ZWBH from ZZ_ZWB where ZWMC='"
+ bossName
+ "' and BMBH='"
+ depNo
+ "'";
ResultSet rs = selectRecord(sql);
String bossNo = "";
Statement stmt = null;
try{
if (rs.next())
bossNo = ds.toString(rs.getString("ZWBH"));
}catch(Exception e){System.out.println("DepartmentBean.getBossDutyNo(String)运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getBossDutyNo(String)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getBossDutyNo(String)关闭声明时statement出错"+e);}
}
return bossNo;
}
public String getDutyNo()//根据部门编号返回其头职务编号
{
String sql = "select TZWBH from ZZ_BMB where BMBH='" + depNo + "'";
ResultSet rs = selectRecord(sql);
String bossNo = "";
Statement stmt = null;
try{
if (rs.next())
bossNo = ds.toString(rs.getString("TZWBH"));
}catch(Exception e){System.out.println("DepartmentBean.getDutyNo()运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getDutyNo()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getDutyNo()关闭声明时statement出错"+e);}
}
return bossNo;
}
public Vector allBmName()//返回所有的部门名称，除了自己
{
String sql = "select BMMC from ZZ_BMB where BMBH!='" + depNo + "'";
ResultSet rs = selectRecord(sql);
Vector allBmName = new Vector();
String bmName = "";
Statement stmt = null;
try{
while (rs.next()) {
bmName = ds.toString(rs.getString("BMMC"));
allBmName.add(bmName);
}
}catch(Exception e){System.out.println("DepartmentBean.allBmName()运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.allBmName()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.allBmName()关闭声明时statement出错"+e);}
}
return allBmName;
}
public Hashtable getAllInf()//管理员和文书数据已经汉化
{
String sql =
"select a.BMMC as FBMMC,b.BMMC as BMMC,b.TZWBH as TZWBH,b.JBXH as JBXH,b.GLYZWBH as GLYZWBH,b.WSZWBH as WSZWBH,b.CKQX as CKQX from ZZ_BMB a,ZZ_BMB b where a.BMBH=b.BMFBH and b.BMBH='"
+ depNo
+ "'";
//and c.BMBH=b.BMBH and c.ZWBH=b.TZWBH ,ZZ_ZWB c
ResultSet rs = selectRecord(sql);
Statement stmt = null;
Hashtable ht = new Hashtable();
String zwmc = "";
String tzwbh = "";
String ckqxbh = "";
String glyxm = "";
String wsxm = "";
String glyzwbh = "";
String wszwbh = "";
try{
if(rs.next())
{
ht.put("BMFBH", ds.toString(rs.getString("FBMMC")));
ht.put("BMMC", ds.toString(rs.getString("BMMC")));
ht.put("JBXH", ds.toString(rs.getString("JBXH")));
ht.put("GLYZWBH", ds.toString(rs.getString("GLYZWBH")));
ht.put("WSZWBH", ds.toString(rs.getString("WSZWBH")));
ht.put("CKQXBH", ds.toString(rs.getString("CKQX")));
zwmc = ""; //toName();
tzwbh = ds.toString(rs.getString("TZWBH"));
ckqxbh = ds.toString(rs.getString("CKQX"));
glyxm = "";
wsxm = "";
glyzwbh = ds.toString(rs.getString("GLYZWBH"));
wszwbh = ds.toString(rs.getString("WSZWBH"));
}
}catch(Exception e){System.out.println("DepartmentBean.getAllInf()运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()关闭声明时statement出错"+e);}
}
if (!tzwbh.equals("") && tzwbh != null) {
sql =
"select ZWMC from ZZ_ZWB where ZWBH="
+ tzwbh
+ " and BMBH='"
+ depNo
+ "'";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -