?? dutybean.java
字號:
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){//原先有錄入權限但沒有管理權限，此時分配給他管理權限
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.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();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -