?? dutybean.java
字號:
hash1.put("LB","2");
hash1.put("BMBH",strOrgNO);
hash1.put("SFGL","1");
MakeNews news = null;
try{
news= new MakeNews();
news.setID(id);
news.modNews(hash1);
}finally{
if(news!=null)
news.closeConn();
}
}
else if(!_sflr){//原先有錄入權(quán)限但沒有管理權(quán)限，此時(shí)去掉他的錄入權(quán)限，刪除記錄
MakeNews news = null;
try{
news= new MakeNews();
news.setID(id);
news.delNews();
}finally{
if(news!=null)
news.closeConn();
}
}
}
}
}catch(Exception e){System.out.println("DutyBean.modDuty(Hashtable hash)運(yùn)行時(shí)出錯："+e);}
finally{
if(rs2!=null)try{ stmt = rs2.getStatement(); rs2.close();}catch(Exception e){System.out.println("DutyBean.modDuty(Hashtable hash)關(guān)閉記錄集rs時(shí)出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.modDuty(Hashtable hash)關(guān)閉聲明時(shí)statement出錯"+e);}
}
PublicData.rebuildFlowVector();
PublicData.rebuildRightVector();
return 0;
}
//刪除當(dāng)前部門當(dāng)前職務(wù)數(shù)據(jù)記錄
public int delDuty()
{
String sql="";
String strZWZT="1";
sql = "select * from news.ZZ_ZGZWB where BMBH = "+strOrgNO+" and ZWBH = "+strDutyNO+"";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next())
{
return -1;//職務(wù)有人擔(dān)當(dāng)，不能刪除！
}
}catch(Exception e){System.out.println("DutyBean.delDuty()運(yùn)行時(shí)出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.delDuty()關(guān)閉記錄集rs時(shí)出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.delDuty()關(guān)閉聲明時(shí)statement出錯"+e);}
}
sql = "update ZZ_ZWB set ZWZT = "+strZWZT+" where BMBH = "+strOrgNO+" and ZWBH = "+strDutyNO+"";
return deleteRecord(sql);
}
//刪除當(dāng)前部門當(dāng)前職務(wù)數(shù)據(jù)記錄
public int delDBDuty()
{
String sql = "select * from news.ZZ_ZGZWB where BMBH = "+strOrgNO+" and ZWBH = "+strDutyNO+"";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
if(rs.next()){ return -1;//職務(wù)有人擔(dān)當(dāng)，不能刪除！
}
}catch(Exception e){System.out.println("DutyBean.delDBDuty()運(yùn)行時(shí)出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.delDBDuty()關(guān)閉記錄集rs時(shí)出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.delDBDuty()關(guān)閉聲明時(shí)statement出錯"+e);}
}
sql = "delete from news.ZZ_ZWB where BMBH = "+strOrgNO+" and ZWBH = "+strDutyNO+"";
return deleteRecord(sql);
}
//通過部門編號和職務(wù)編號得到當(dāng)前職務(wù)的操作權(quán)限，沒轉(zhuǎn)化為漢字 11-24
public String getOper()
{
String strOper = "";
String sql = "";
String strMRCZ = "1";
String strSYZT = "0";
String str = ",";
sql = "select CZQX from news.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(""))//如果職務(wù)表中的操作權(quán)限為空則去模塊權(quán)限表取默認(rèn)操作權(quán)限
{
sql = "select ID from news.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()運(yùn)行時(shí)出錯："+e);}
finally{
if(res!=null)try{ stmt = res.getStatement(); res.close();}catch(Exception e){System.out.println("DutyBean.getOper()關(guān)閉記錄集rs時(shí)出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getOper()關(guān)閉聲明時(shí)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++)//根據(jù)分割后的編號取得模塊名稱
//{
// 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()運(yùn)行時(shí)出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getOper()關(guān)閉記錄集rs時(shí)出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getOper()關(guān)閉聲明時(shí)statement出錯"+e);}
}
return strOper;
}
//通過部門編號和職務(wù)編號得到當(dāng)前職務(wù)的流程權(quán)限，并且轉(zhuǎn)化為漢字
public String getFlow()
{
String strFlow = "";
String sql = "";
String strMRCZ = "1";
String strSYZT = "0";
String str = ",";
sql = "select LCQX from news.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(""))//如果職務(wù)表中的流程權(quán)限為空則去流程權(quán)限表取默認(rèn)流程權(quán)限
{
sql = "select MKMC from news.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()運(yùn)行時(shí)出錯："+e);}
finally{
if(res!=null)try{ stmt = res.getStatement(); res.close();}catch(Exception e){System.out.println("DutyBean.getFlow()關(guān)閉記錄集rs時(shí)出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getFlow()關(guān)閉聲明時(shí)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++)//根據(jù)分割后的編號取得流程名稱
{
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()運(yùn)行時(shí)出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getFlow()關(guān)閉記錄集rs時(shí)出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getFlow()關(guān)閉聲明時(shí)statement出錯"+e);}
}
return strFlow;
}
//通過部門編號得到當(dāng)前職務(wù)的配置參數(shù)
public String getConf()
{
String strConf = "";
String sql = "";
//String str = ",";
String str1 = ",";
String strMax = "";
int i,num=0;//,j
String []xm = new String[10];//{"郵箱空間:","附件大小:","個(gè)人通訊錄數(shù)目:","文件柜大小:",""};//
String []unit = new String[10];//{"MB","MB","條","MB",""};//
sql = "select PZBH,PZMC,PZSZ,PZSM from news.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 news.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(""))//如果職工中的配置參數(shù)不空
{
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(""))//如果職務(wù)表中的配置參數(shù)為空則去系統(tǒng)配置表取默認(rèn)流程權(quán)限
{
sql = "select PZBH,PZSZ from news.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()運(yùn)行時(shí)出錯："+e);}
finally{
if(r!=null)try{ stmt = r.getStatement(); r.close();}catch(Exception e){System.out.println("DutyBean.getConf()關(guān)閉記錄集rs時(shí)出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getConf()關(guān)閉聲明時(shí)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()運(yùn)行時(shí)出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getConf()關(guān)閉記錄集rs時(shí)出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getConf()關(guān)閉聲明時(shí)statement出錯"+e);}
}
return strConf;
}
//根據(jù)部門編號返回名稱
public String toName()
{
return db.toName("ZZ_BMB","BMBH","BMMC",strOrgNO);
}
//根據(jù)填寫的操作權(quán)限轉(zhuǎn)化為存儲字符
public String toOperNo(String strOper)
{
String strOperNo = "";
String str = ",";
if(strOper.equals(""))//默認(rèn)操作權(quán)限
{
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;
}
//根據(jù)填寫的流程權(quán)限轉(zhuǎn)化為存儲字符
public String toFlowNo(String strFlow)
{
String strFlowNo = "";
String str = ",";
if(strFlow.equals(""))//默認(rèn)流程權(quán)限
{
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;
}
//設(shè)置級別序號
public String getJBNo()
{
String pri="0";
String sql = "select max(JBXH) from news.ZZ_ZWB where BMBH='"+strOrgNO+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
//取得本部門職務(wù)的級別序號的最大編號
if(rs.next())
{
pri = ds.toString(rs.getInt(1) + 1+"");
}
}catch(Exception e){System.out.println("DutyBean.getJBNo()運(yùn)行時(shí)出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getJBNo()關(guān)閉記錄集rs時(shí)出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getJBNo()關(guān)閉聲明時(shí)statement出錯"+e);}
}
return pri;
}
public ResultSet selOper()//從操作權(quán)限表里選取所有的模塊名稱
{
String sql = "select MKMC from news.CODE_CZQXB where SYZT=0";
ResultSet rs = selectRecord(sql);
return rs;
}
public ResultSet selFlow()//從流程表里選取所有的流程名稱
{
String sql = "select MKMC from news.CODE_LCQXB where SYZT=0 order by JBXH";
ResultSet rs = selectRecord(sql);
return rs;
}
public String getOrdinaryZWBH(String bmbh,String zwmc)//根椐部門編號、職務(wù)名稱返回職務(wù)編號
{
String zwbh = "";
String sql = "select ZWBH from news.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)運(yùn)行時(shí)出錯："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getOrdinaryZWBH(String,String)關(guān)閉記錄集rs時(shí)出錯"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getOrdinaryZWBH(String,String)關(guān)閉聲明時(shí)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","邯鋼科技服務(wù)部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--------職務(wù)編號： "+mb.getOrdinaryZWBH("00050000000000000000","一般員工"));
System.out.println("\n\n end \n\n\n");
}
}?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -