?? departmentbean.java
字號:
String fatherNo=getFatherNo();
if(bmNo.equals("00000000000000000000"))
sql = "select JBXH from ZZ_BMB where BMMC='"+ bmName+ "' and BMFBH is null and BMZT=0";
else
sql = "select JBXH from ZZ_BMB where BMMC='"+ bmName+ "' and BMFBH='"+ fatherNo+ "' and BMZT=0";
ResultSet rs1 = selectRecord(sql);
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)關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.modRec(Hashtable,String)關(guān)閉聲明時statement出錯"+e);}
}
if (flg.equals("0")) { //父部門沒變
int jbxh=0;
if(!jbNo.equals(""))
jbxh=Integer.parseInt(jbNo);
if(!fatherNo.equals(""))
{
int maxjbNo=makeID("ZZ_BMB","BMFBH","BMZT","JBXH",fatherNo,"0",false,true);
if(jbxh==0||jbxh>=maxjbNo)
{ jbxh=maxjbNo;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 {
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; //部門下的職務(wù)有人擔當，不能刪除部門
}
else {
sql1 =
"update ZZ_ZWB set ZWZT=1 where BMBH = '"
+ depNo
+ "' and ZWZT=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()關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()關(guān)閉聲明時statement出錯"+e);}
if(rs2!=null)try{ stmt = rs2.getStatement(); rs2.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()關(guān)閉聲明時statement出錯"+e);}
if(rs3!=null)try{ stmt = rs3.getStatement(); rs3.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()關(guān)閉聲明時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()關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.delRec()關(guān)閉聲明時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()關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getJBNo()關(guān)閉聲明時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()關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getFatherNo()關(guān)閉聲明時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)關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getBmNo(String)關(guān)閉聲明時statement出錯"+e);}
}
return bmNo;
}
public String getBossDutyNo(String bossName)
{
String sql =
"select ZWBH from ZZ_ZWB where trim(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)關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getBossDutyNo(String)關(guān)閉聲明時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()關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getDutyNo()關(guān)閉聲明時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()關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.allBmName()關(guān)閉聲明時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
+ "'";
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 = "";
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()關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()關(guān)閉聲明時statement出錯"+e);}
}
if (!tzwbh.equals("") && tzwbh != null) {
sql =
"select ZWMC from ZZ_ZWB where ZWBH="
+ tzwbh
+ " and BMBH='"
+ depNo
+ "'";
rs = selectRecord(sql);
try{
if (rs.next())
zwmc = ds.toString(rs.getString("ZWMC"));
}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()關(guān)閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DepartmentBean.getAllInf()關(guān)閉聲明時statement出錯"+e);}
}
}
ht.put("ZWMC", zwmc);
if (!glyzwbh.equals("") && glyzwbh != null) {
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -