📄 dutybean.java
字号:
/**********************************************************
Copyright (C),2003-10-17, Beijing USTB.
All rights reserved.
Filename: DutyBean.java
Author:
Version 1.0
Date:2003-10-17
Description:组织机构中的职务表:列表查询、单条信息查询、增加记录、修改记录、删除记录
Other:
Variable List:
1.String strOrgNO = "-1"//部门编号
2.String strDutyNO = "-1";//职务编号
Function List:
1.public DutyBean()//构造函数
2.public void setOrgNO(String o)//设置部门编号
3.public void setDutyNO(String d)//设置职务编号
4.public Vector getData()//取得当前部门的职务列表
5.public Hashtable getOneData()//取得当前部门当前职务的信息
6.public int addDuty(Hashtable hash)//增加当前部门职务数据记录
7.public int modDuty(Hashtable hash)//修改当前部门职务数据记录
8.public int delDuty()//删除当前部门当前职务数据记录,返回值为True表示删除成功，
//返回值为false表示职务职工占用不执行操作
public void delDBDuty() //删除当前部门当前职务数据记录
9.public String getOper()//通过部门编号和职务编号得到当前职务的操作权限，没转化为汉字 NEW 改的
10.public String getFlow()//通过部门编号和职务编号得到当前职务的流程权限，并且转化为汉字
11.public String getConf()//通过部门编号得到当前职务的配置参数
12.public String toOperNo(String strPer)//根据填写的操作权限转化为存储字符
13.public String toFlowNo(String strFlow)//根据填写的流程权限转化为存储字符
14.public String toName()//根据部门编号返回名称
15.public String getJBNo() throws SQLException//设置级别序号
16.public String getOrdinaryZWBH(String bmbh,String zwmc)//根椐部门编号、职务名称返回职务编号
1.History:
2003-10-19 修改SQL处理方式
2. Date:2003-11-22
Author:
Modification:级别序号问题修正
3. Date:2003-11-23
Author:
Modification:修正getOper()
4. Date:2003-11-24
Author:
Modification:public String getOrdinaryZWBH(String bmbh,String zwmc)//根椐部门编号、职务名称返回职务编号
修改：//通过部门编号和职务编号得到当前职务的操作权限，没转化为汉字 11-24
public String getOper()
***********************************************************/
package oa.bean;
import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;
public class DutyBean extends ParentBean
{
String strOrgNO = "-1";
String strDutyNO = "-1";
String strConfNO = "-1";
//构造函数
public DutyBean()
{
}
//设置部门编号
public void setOrgNO(String o)
{
strOrgNO = o;
}
//设置职务编号
public void setDutyNO(String d)
{
strDutyNO = d;
}
//取得当前部门的职务列表
public Vector getData()
{
Vector vect = new Vector();
String sql = "";
sql = " select * from ZZ_ZWB order by BMBH,ZWBH ";
ResultSet rs = selectRecord(sql);
//取得列数和列名
Statement stmt = null;
try{
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
while(rs.next())
{
Hashtable hash = new Hashtable();
for(int i=1;i<=cols;i++)
{
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
hash.put(field,value);
}
vect.add(hash);
}
}catch(Exception e){System.out.println("DutyBean.getData()运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getData()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getData()关闭声明时statement出错"+e);}
}
return vect;
}
//取得当前部门当前职务的信息
public Hashtable getOneData()
{
Hashtable hash = new Hashtable();
String sql = "";
sql = " select * from ZZ_ZWB where BMBH = '"+strOrgNO+"' and ZWBH = "+strDutyNO+" ";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
if (rs.next())
{
for(int i=1;i<=cols;i++)
{
String field = ds.toString(rsmd.getColumnName(i));
String value = ds.toString(rs.getString(i));
if(field.equals("CZQX"))
{
//value = getOper();
}
if(field.equals("LCQX"))
{
value = getFlow();
}
if(field.equals("PZCS"))
{
//value = getConf();
}
hash.put(field,value);
}
}
}catch(Exception e){System.out.println("DutyBean.getOneData()运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.getOneData()关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.getOneData()关闭声明时statement出错"+e);}
}
return hash;
}
public int addDuty(Hashtable hash,boolean rebuild)
{
String sql="";
String strBMBH = ds.toString((String)hash.get("BMBH"));
int intZWBH = db.makeID("ZZ_ZWB","BMBH","ZWBH",strBMBH,false);
String strZWMC = ds.toString((String)hash.get("ZWMC"));
String strCZQX = ds.toString((String)hash.get("CZQX"));
String strLCQX = ds.toString((String)hash.get("LCQX"));
String strPZCS = ds.toString((String)hash.get("PZCS"));
String strJBXH = ds.toString((String)hash.get("JBXH"));
String strZWZT = ds.toString((String)hash.get("ZWZT"));
String strSFJC = ds.toString((String)hash.get("SFJC"));
//检验是否已经存在
ResultSet rs = selectRecord("select * from ZZ_ZWB where BMBH='"+strBMBH+"' and ZWMC='"+strZWMC+"' and ZWZT=0");
Statement stmt = null;
try{
if(rs.next()){
return 1;
}
}catch(Exception e){System.out.println("DutyBean.addDuty(Hashtable hash)运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("DutyBean.addDuty(Hashtable hash)关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("DutyBean.addDuty(Hashtable hash)关闭声明时statement出错"+e);}
}
/////////////////
int maxjbNo=makeID("ZZ_ZWB","BMBH","JBXH",strBMBH,false);
int jbxh=0;
if(!strJBXH.equals(""))
jbxh=Integer.parseInt(strJBXH);
if(jbxh==0||jbxh>maxjbNo)
{ jbxh=maxjbNo;strJBXH=""+jbxh;}
//////////////////////
sql="update ZZ_ZWB set jbxh=jbxh+1 where BMBH='"+ strBMBH + "' and JBXH >=" + jbxh ;
deleteRecord(sql);
//////////////////////
Vector vect = new Vector();
vect.add("ZZ_ZWB");
vect.add(addVector("BMBH",strBMBH,"CHAR"));
vect.add(addVector("ZWBH",String.valueOf(intZWBH),"NUM"));
vect.add(addVector("ZWMC",strZWMC,"CHAR"));
vect.add(addVector("CZQX",strCZQX,"CHAR"));
vect.add(addVector("LCQX",strLCQX,"CHAR"));
vect.add(addVector("PZCS",strPZCS,"CHAR"));
vect.add(addVector("JBXH",strJBXH,"NUM"));
vect.add(addVector("ZWZT",strZWZT,"NUM"));
vect.add(addVector("SFJC",strSFJC,"NUM"));
insertRecord(vect);
if(rebuild){
PublicData.rebuildFlowVector();
PublicData.rebuildRightVector();
}
return 0;
}
//增加当前部门数据记录
public int addDuty(Hashtable hash)
{
return addDuty(hash,true);
}
//修改当前部门数据记录
public int modDuty(Hashtable hash)
{
String strZWMC = ds.toString((String)hash.get("ZWMC"));
String strCZQX = ds.toString((String)hash.get("CZQX"));
String strLCQX = ds.toString((String)hash.get("LCQX"));
String strPZCS = ds.toString((String)hash.get("PZCS"));
String strJBXH = ds.toString((String)hash.get("JBXH"));
String strZWZT = ds.toString((String)hash.get("ZWZT"));
String strSFJC = ds.toString((String)hash.get("SFJC"));
///////////////
ResultSet rs1 = selectRecord(
"select JBXH from ZZ_ZWB where BMBH='" + strOrgNO + "' and ZWBH=" + strDutyNO);
int yjbxh=999;
Statement stmt = null;
try{
if(rs1.next())
yjbxh=Integer.parseInt(rs1.getString("JBXH"));
}catch(Exception e){System.out.println("DutyBean.modDuty(Hashtable hash)运行时出错："+e);}
finally{
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.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);}
}
///////////////
int jbxh=Integer.parseInt(strJBXH);
int maxjbNo=makeID("ZZ_ZWB","BMBH","JBXH",strOrgNO,false);
if(jbxh==0||jbxh>=maxjbNo)
{ jbxh=maxjbNo-1;strJBXH=""+jbxh;}
if(jbxh < yjbxh){
String sql1="update ZZ_ZWB set jbxh=jbxh+1 where BMBH='"
+ strOrgNO
+ "' and JBXH >="
+ jbxh
+ " and JBXH<"
+ yjbxh;
deleteRecord(sql1);
}
else if(jbxh > yjbxh && yjbxh!=0){
String sql2="update ZZ_ZWB set jbxh=jbxh-1 where BMBH='"
+ strOrgNO
+ "' and JBXH <="
+ jbxh
+ " and JBXH>"
+ yjbxh;
deleteRecord(sql2);
}
//////////////////////
Vector vect = new Vector();
vect.add("ZZ_ZWB");
vect.add(addVector("ZWMC",strZWMC,"CHAR"));
vect.add(addVector("CZQX",strCZQX,"CHAR"));
vect.add(addVector("LCQX",strLCQX,"CHAR"));
vect.add(addVector("PZCS",strPZCS,"CHAR"));
vect.add(addVector("JBXH",strJBXH,"NUM"));
vect.add(addVector("ZWZT",strZWZT,"NUM"));
vect.add(addVector("SFJC",strSFJC,"NUM"));
vect.add("BMBH = '"+strOrgNO+"' and ZWBH = "+strDutyNO);
updateRecord(vect);
ResultSet rs2 = selectRecord("select ZGBH from ZZ_ZGZWB where BMBH='"+strOrgNO+"' and ZWBH="+strDutyNO+" and CZQX is null");
//rs1 = selectRecord("select * from CODE_ANCZQXB where mkmc='信息管理' and (anmc='信息维护' or anmc='类别维护'");
try{
while(rs2.next()){
String personno = rs2.getString(1);
boolean sfgl = false,sflr = false;
int id = 0;
String sql = "select id from zz_fbxwb where zgbh='" + personno + "' and bmbh='"+strOrgNO+"' and lb='2' and sfgl='1'";
ResultSet rs = selectRecord(sql);
try{
if(rs.next()){
sfgl = true;
sflr = true;
id = rs.getInt(1);
}
else{
rs.getStatement().close();
sql = "select id from zz_fbxwb where zgbh='" + personno + "' and bmbh='"+strOrgNO+"' and lb='2' and sfgl<>'1'";
rs = selectRecord(sql);
if(rs.next()){
sflr = true;
id = rs.getInt(1);
}
}
}catch(Exception e){System.out.println("DutyBean.modDuty(Hashtable hash)运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.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);}
}
if(strOrgNO.equals("00000000000000000000")||!strOrgNO.substring(4).equals("0000000000000000"))
return 0;
RightBean rb = null;
boolean _sflr = false,
_sfgl = false;
try{
rb = new RightBean();
rb.setUID(personno);
rb.setOrgid(strOrgNO);
_sflr = rb.isRightModelbh("信息管理","信息发布");
_sfgl = rb.isRightModelbh("信息管理","信息维护")||rb.isRightModelbh("信息管理","类别维护");
}
finally{
if(rb!=null)
rb.closeConn();
}
if(!sflr){//原先没有录入权限
if(_sfgl){//原先没有录入权限，则一定没有管理权限，此时分配给他管理权限
Hashtable hash1 = new Hashtable();
hash1.put("ZGBH",personno);
hash1.put("LB","2");
hash1.put("BMBH",strOrgNO);
hash1.put("SFGL","1");
MakeNews news = null;
try{
news= new MakeNews();
news.addNews(hash1);
}finally{
if(news!=null)
news.closeConn();
}
}
else if(_sflr&&!_sfgl){//原先没有录入权限，则一定没有管理权限，此时只分配给他录入权限，没有管理权限
Hashtable hash1= new Hashtable();
hash1.put("ZGBH",personno);
hash1.put("LB","2");
hash1.put("BMBH",strOrgNO);
hash1.put("SFGL","0");
MakeNews news = null;
try{
news= new MakeNews();
news.addNews(hash1);
}finally{
if(news!=null)
news.closeConn();
}
}
}
else if(sfgl&&!_sfgl){//原先有管理权限，此时去掉他的管理权限
if(_sflr){//原先有管理权限，此时去掉他的管理权限，保留他的录入权限
Hashtable hash1 = new Hashtable();
hash1.put("ZGBH",personno);
hash1.put("LB","2");
hash1.put("BMBH",strOrgNO);
hash1.put("SFGL","0");
MakeNews news = null;
try{
news= new MakeNews();
news.setID(id);
news.modNews(hash1);
}finally{
if(news!=null)
news.closeConn();
}
}
else if(!_sflr){//原先有管理权限，此时去掉他的录入权限和管理权限,删除记录
MakeNews news = null;
try{
news= new MakeNews();
news.setID(id);
news.delNews();
}finally{
if(news!=null)
news.closeConn();
}
}
}
else if(sflr&&!sfgl){//原先有录入权限但没有管理权限
if(_sfgl){//原先有录入权限但没有管理权限，此时分配给他管理权限
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -