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