?? dutybean.java
字號:
}
}catch(Exception e){System.out.println("DutyBean.modDuty(Hashtable hash)運行時出錯："+e);}
finally{
if(rs2!=null)try{ stmt = rs2.getStatement(); rs2.close();}catch(Exception e){System.out.println("DutyBean.modDuty(Hashtable hash)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.modDuty(Hashtable hash)關閉聲明時statement出錯"+e);}
}
PublicData.rebuildFlowVector();
PublicData.rebuildRightVector();
return 0;
}
//刪除當前部門當前職務數據記錄
public int delDuty()
{
String sql="";
String strZWZT="1";
sql = "select * from ZZ_ZGZWB where BMBH = "+strOrgNO+" and ZWBH = "+strDutyNO+"";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
return -1;//職務有人擔當，不能刪除！
}
}catch(Exception e){System.out.println("DutyBean.delDuty()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.delDuty()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.delDuty()關閉聲明時statement出錯"+e);}
}
sql = "update ZZ_ZWB set ZWZT = "+strZWZT+" where BMBH = "+strOrgNO+" and ZWBH = "+strDutyNO+"";
return deleteRecord(sql);
}
//刪除當前部門當前職務數據記錄
public int delDBDuty()
{
String sql = "select * from ZZ_ZGZWB where BMBH = "+strOrgNO+" and ZWBH = "+strDutyNO+"";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next()){ return -1;//職務有人擔當，不能刪除！
}
}catch(Exception e){System.out.println("DutyBean.delDBDuty()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.delDBDuty()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.delDBDuty()關閉聲明時statement出錯"+e);}
}
sql = "delete from ZZ_ZWB where BMBH = "+strOrgNO+" and ZWBH = "+strDutyNO+"";
return deleteRecord(sql);
}
//通過部門編號和職務編號得到當前職務的操作權限，沒轉化為漢字 11-24
public String getOper()
{
String strOper = "";
String sql = "";
String strMRCZ = "1";
String strSYZT = "0";
String str = ",";
sql = "select CZQX from ZZ_ZWB where BMBH = "+strOrgNO+" and ZWBH = "+strDutyNO+"";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
String strOperNo = ds.toString(rs.getString("CZQX"));
if (strOperNo.equals(""))//如果職務表中的操作權限為空則去模塊權限表取默認操作權限
{
sql = "select ID from CODE_ANCZQXB where MRCZ = "+strMRCZ+" and SYZT = "+strSYZT+"";
ResultSet res = selectRecord(sql);
try{
while(res.next())
{
strOper+=ds.toString(res.getString("ID"))+str;
}
}catch(Exception e){System.out.println("DutyBean.getOper()運行時出錯："+e);}
finally{
if(res!=null)try{ stmt = res.getStatement(); res.close();}catch(Exception e){System.out.println("DutyBean.getOper()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getOper()關閉聲明時statement出錯"+e);}
}
if(strOper!=null && !strOper.equals(""))
strOper = strOper.substring(0,strOper.length()-1);
if(strOper==null)
strOper="";
return strOper;
}
//String strOpers[] = strOperNo.split(",");
//for(int i=0;i<strOpers.length;i++)//根據分割后的編號取得模塊名稱
//{
// strOper+=db.toName("CODE_CZQXB","MKBH","MKMC",strOpers[i])+str;
//}
strOper = strOper.substring(0,strOper.length()-1);
}
}catch(Exception e){System.out.println("DutyBean.getOper()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getOper()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getOper()關閉聲明時statement出錯"+e);}
}
return strOper;
}
//通過部門編號和職務編號得到當前職務的流程權限，并且轉化為漢字
public String getFlow()
{
String strFlow = "";
String sql = "";
String strMRCZ = "1";
String strSYZT = "0";
String str = ",";
sql = "select LCQX from ZZ_ZWB where BMBH = "+strOrgNO+" and ZWBH = "+strDutyNO+"";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
String strFlowNo = ds.toString(rs.getString("LCQX"));
if (strFlowNo.equals(""))//如果職務表中的流程權限為空則去流程權限表取默認流程權限
{
sql = "select MKMC from CODE_LCQXB where MRCZ = "+strMRCZ+" and SYZT = "+strSYZT+"";
ResultSet res = selectRecord(sql);
try{
while(res.next())
{
strFlow+=ds.toString(res.getString("MKMC"))+str;
}
}catch(Exception e){System.out.println("DutyBean.getFlow()運行時出錯："+e);}
finally{
if(res!=null)try{ stmt = res.getStatement(); res.close();}catch(Exception e){System.out.println("DutyBean.getFlow()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getFlow()關閉聲明時statement出錯"+e);}
}
if(!strFlow.equals(""))
strFlow = strFlow.substring(0,strFlow.length()-1);
return strFlow;
}
String strFlows[] = strFlowNo.split(",");
for(int i=0;i<strFlows.length;i++)//根據分割后的編號取得流程名稱
{
strFlow+=db.toName("CODE_LCQXB","MKBH","MKMC",strFlows[i])+str;
}
strFlow = strFlow.substring(0,strFlow.length()-1);
}
}catch(Exception e){System.out.println("DutyBean.getFlow()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getFlow()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getFlow()關閉聲明時statement出錯"+e);}
}
return strFlow;
}
//通過部門編號得到當前職務的配置參數
public String getConf()
{
String strConf = "";
String sql = "";
//String str = ",";
String str1 = ",";
String strMax = "";
int i,num=0;//,j
String []xm = new String[10];//{"郵箱空間:","附件大小:","個人通訊錄數目:","文件柜大小:",""};//
String []unit = new String[10];//{"MB","MB","條","MB",""};//
sql = "select PZBH,PZMC,PZSZ,PZSM from CODE_XTPZ order by PZBH ";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
while(rs.next())
{
xm[num] = ds.toString(rs.getString("PZMC"));
unit[num] = ds.toString(rs.getString("PZSM"));
num++;
}
sql = "select PZCS from ZZ_ZWB where BMBH = "+strOrgNO+" and ZWBH = "+strDutyNO+"";
stmt = rs.getStatement();rs.close();stmt.close();
rs = selectRecord(sql);
if(rs.next())
{
strConf = ds.toString(rs.getString("PZCS"));
if (!strConf.equals(""))//如果職工中的配置參數不空
{
String sglemt[] = strConf.split(",");
for(i=0;i<sglemt.length;i++)
{
if(!strMax.equals(""))
strMax+=str1+xm[i]+sglemt[i]+unit[i];
if(strMax.equals(""))
strMax = xm[i]+sglemt[i]+unit[i];
}
strConf = strMax;
return strConf; //ok
}
if (strConf.equals(""))//如果職務表中的配置參數為空則去系統配置表取默認流程權限
{
sql = "select PZBH,PZSZ from CODE_XTPZ order by PZBH ";
ResultSet r = selectRecord(sql);
try{
while(r.next())
{
strConf+=ds.toString(r.getString("PZSZ"))+str1;
}
}catch(Exception e){System.out.println("DutyBean.getConf()運行時出錯："+e);}
finally{
if(r!=null)try{ stmt = r.getStatement(); r.close();}catch(Exception e){System.out.println("DutyBean.getConf()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getConf()關閉聲明時statement出錯"+e);}
}
strConf = strConf.substring(0,strConf.length()-1);
String sglelement[] = strConf.split(",");
for(i=0;i<sglelement.length;i++)
{
if(!strMax.equals(""))
strMax+=str1+xm[i]+sglelement[i]+unit[i];
if(strMax.equals(""))
strMax = xm[i]+sglelement[i]+unit[i];
}
strConf = strMax;
return strConf; //ok
}
//return strConf;
}
}catch(Exception e){System.out.println("DutyBean.getConf()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getConf()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getConf()關閉聲明時statement出錯"+e);}
}
return strConf;
}
//根據部門編號返回名稱
public String toName()
{
return db.toName("ZZ_BMB","BMBH","BMMC",strOrgNO);
}
//根據填寫的操作權限轉化為存儲字符
public String toOperNo(String strOper)
{
String strOperNo = "";
String str = ",";
if(strOper.equals(""))//默認操作權限
{
return strOperNo;
}
String strOpers[] = strOper.split(",");
for(int i=0;i<strOpers.length;i++)
{
strOperNo+= db.toID("CODE_CZQXB","MKMC","MKBH",strOpers[i])+str;
}
strOperNo = strOperNo.substring(0,strOperNo.length()-1);
return strOperNo;
}
//根據填寫的流程權限轉化為存儲字符
public String toFlowNo(String strFlow)
{
String strFlowNo = "";
String str = ",";
if(strFlow.equals(""))//默認流程權限
{
return strFlowNo;
}
String strFlows[] = strFlow.split(",");
for(int i=0;i<strFlows.length;i++)
{
strFlowNo+= db.toID("CODE_LCQXB","MKMC","MKBH",strFlows[i])+str;
}
strFlowNo = strFlowNo.substring(0,strFlowNo.length()-1);
return strFlowNo;
}
//設置級別序號
public String getJBNo()
{
String pri="0";
String sql = "select max(JBXH) from ZZ_ZWB where BMBH='"+strOrgNO+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
//取得本部門職務的級別序號的最大編號
if(rs.next())
{
pri = ds.toString(rs.getInt(1) + 1+"");
}
}catch(Exception e){System.out.println("DutyBean.getJBNo()運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getJBNo()關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getJBNo()關閉聲明時statement出錯"+e);}
}
return pri;
}
public ResultSet selOper()//從操作權限表里選取所有的模塊名稱
{
String sql = "select MKMC from CODE_CZQXB where SYZT=0";
ResultSet rs = selectRecord(sql);
return rs;
}
public ResultSet selFlow()//從流程表里選取所有的流程名稱
{
String sql = "select MKMC from CODE_LCQXB where SYZT=0 order by JBXH";
ResultSet rs = selectRecord(sql);
return rs;
}
public String getOrdinaryZWBH(String bmbh,String zwmc)//根椐部門編號、職務名稱返回職務編號
{
String zwbh = "";
String sql = "select ZWBH from ZZ_ZWB where BMBH='"+ bmbh +"' and ZWMC='"+ ds.toString(zwmc) +"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
zwbh = ds.toString(String.valueOf(rs.getInt(1)));
}
}catch(Exception e){System.out.println("DutyBean.getOrdinaryZWBH(String,String)運行時出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getOrdinaryZWBH(String,String)關閉記錄集rs時出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getOrdinaryZWBH(String,String)關閉聲明時statement出錯"+e);}
}
return zwbh;
}
public static void main(String args[])
{
DutyBean mb = new DutyBean();
mb.setOrgNO("00040000000000000000");
mb.setDutyNO("6");
Hashtable hash= new Hashtable();
//hash.put("BMBH","00040000000000000000");
hash.put("ZWMC","邯鋼科技服務部1111");
hash.put("CZQX","6");
hash.put("LCQX","3");
hash.put("PZCS","");
hash.put("JBXH","1");
hash.put("ZWZT","0");
System.out.println("\n\n begin \n\n\n");
System.out.println(mb.toOperNo("模塊6"));
//System.out.println(mb.toFlowNo("Wfdsafdsa,sss"));
//mb.addDuty(hash);
//mb.modDuty(hash);
//System.out.println(mb.getData());
//mb.delDuty();
System.out.println("------------liumei--------職務編號： "+mb.getOrdinaryZWBH("00050000000000000000","一般員工"));
System.out.println("\n\n end \n\n\n");
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -