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