📄 personbean.java
字号:
value = getApartName(value);
}
if (field.equals("ZZZT")) {
if (value.equals("0"))
value = "正常";
if (value.equals("1"))
value = "离职";
if (value.equals("2"))
value = "退休";
}
if (value == null)
value = "";
hash.put(field, value);
}
vect.add(hash);
}
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return vect;
}
//取得人员记录列表
public Vector getData(String strLCQX) {
strLCQX=ds.toString(strLCQX);
if (strLCQX.equals("")) return null;
Vector vect = new Vector();
// DealBean db = new DealBean();
String sql = "";
//String strFormatedLCQX ="," + ds.toString(strLCQX) + ",";
sql =" select * from ZZ_ZGB where bmbh='"+strOrgNO+"' and ZZZT=0 "
+" and ZZ_ZGB.ZGBH<>'1'"
+ " order by ZZ_ZGB.ZGBH ";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
//取得列数和列名
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
while (rs.next()) {
String strPersonNo_Temp=ds.toString(rs.getString("ZGBH"));
if(strPersonNo_Temp.equals("")) continue;
setPersonNO(strPersonNo_Temp);
if(!isFlowRight(strLCQX)) continue;
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));
if (field.equals("BMBH")) {
value = getApartName(value);
}
if (field.equals("ZZZT")) {
if (value.equals("0"))
value = "正常";
if (value.equals("1"))
value = "离职";
if (value.equals("2"))
value = "退休";
}
if (value == null)
value = "";
hash.put(field, value);
}
vect.add(hash);
}
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return vect;
}
public DefaultMutableTreeNode CutBMTree(DefaultMutableTreeNode root,String strLCQX){
Vector vectBMBH = getFlowBM1(strLCQX);
//System.out.println("\r\n222222222222222222222"+vectBMBH);
//开始剪枝
boolean canCut = true;
boolean cut = true;
while (canCut && root.getChildCount() > 0) {
canCut = false;
for (Enumeration e = root.preorderEnumeration();
e.hasMoreElements();
) {
DefaultMutableTreeNode node =
(DefaultMutableTreeNode) e.nextElement();
Hashtable hs = (Hashtable) (node.getUserObject());
String strID = (String) hs.get("BMBH");
if (!vectBMBH.contains(strID)) {
if (node.isLeaf()) {
node.removeFromParent();
canCut = true;
continue;
} //end if
} else {
Hashtable hst = (Hashtable) node.getUserObject();
hst.put("Enabled", "True");
} //end if else
} //end for
} //end while
return root;
}
public DefaultMutableTreeNode CutBMTree1(Vector vectBMBH,DefaultMutableTreeNode root,String strLCQX) {
//System.out.println("\r\n222222222222222222222"+vectBMBH);
//开始剪枝
boolean canCut = true;
boolean cut = true;
while (canCut && root.getChildCount() > 0) {
canCut = false;
for (Enumeration e = root.preorderEnumeration();
e.hasMoreElements();
) {
DefaultMutableTreeNode node =
(DefaultMutableTreeNode) e.nextElement();
Hashtable hs = (Hashtable) (node.getUserObject());
String strID = (String) hs.get("BMBH");
if (!vectBMBH.contains(strID)) {
if (node.isLeaf()) {
node.removeFromParent();
canCut = true;
continue;
} //end if
} else {
Hashtable hst = (Hashtable) node.getUserObject();
hst.put("Enabled", "True");
} //end if else
} //end for
} //end while
return root;
}
public String getZWData(String strPersonNo)//通过职工编号得到ZZ_ZGZWB的所有记录
{
String zwmc = "";
Vector vt = new Vector();
String sql ="select BMBH,ZWBH from ZZ_ZGZWB where ZGBH='"+strPersonNo+"'";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
while(rs.next())
{
String bmbh = ds.toString(rs.getString("BMBH"));
String zwbh = ds.toString(rs.getString("ZWBH"));
if(!zwmc.equals(""))
zwmc = zwmc +"、"+ getDutyName(bmbh,zwbh);
else
zwmc = getDutyName(bmbh,zwbh);
}
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return zwmc;
}
//查询职务名称
public String getDutyName(String bmbh,String zwbh) {
String zwName="";
String sql =
"select ZWMC from ZZ_ZWB where ZWZT=0 and BMBH='"
+ bmbh +"' and ZWBH='"+zwbh
+ "' order by JBXH";
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
Vector vt = new Vector();
Hashtable ht = new Hashtable();
if (rs.next()) {
zwName = ds.toString(rs.getString("ZWMC"));
}
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return zwName;
}
//取得人员记录列表display.jsp排序用
public Vector getData(boolean isfather,String pxzd,boolean isdesc,String srchzd,String srchzdval,boolean isexact)
{
//isfather是否看总公司所有纪录；pxzd按哪个字段排序；isdesc是否降序排列；srchzd按哪个字段搜索；isexact是否精确查询
Vector vect = new Vector();
String sql = "";
String zdnames="BMBH,ZGBH,XM,XB,GH,PZCS";
if(isfather)
{
sql = " select "+zdnames+" from ZZ_ZGB where ZZZT=0 order by BMBH";
if(!srchzd.equals(""))
{
if(isexact)
sql = " select "+zdnames+" from ZZ_ZGB where ZZZT=0 and "+srchzd+"='"+srchzdval+"'";
if(!isexact)
sql = " select "+zdnames+" from ZZ_ZGB where ZZZT=0 and "+srchzd+" like '%"+srchzdval+"%'";
sql = sql+" order by BMBH";
}
if(!pxzd.equals("") && !pxzd.equals("BMBH"))
{
sql = sql +","+pxzd;
}
else{
sql = sql +",JBXH";
}
}
else
{
int n = -1;
int m=strOrgNO.length()-1;
for (;m>0 ;m-- )
{
char indexchar = strOrgNO.charAt(m);
if(indexchar!='0')
{
n = m;
break;
}
}
if(n==6 || n==7)
{
strOrgNO = strOrgNO.substring(0,8);
}
else if(n==4 || n==5)
strOrgNO = strOrgNO.substring(0,6);
else if(n==2 || n==3)
strOrgNO = strOrgNO.substring(0,4);
sql = " select "+zdnames+" from ZZ_ZGB where (bmbh='"+strOrgNO+"' or bmbh like'"+strOrgNO+"%') and ZZZT=0";
if(!srchzd.equals(""))
{
if(isexact)
sql = sql+" and "+srchzd+"='"+srchzdval+"'";
if(!isexact)
sql = sql+" and "+srchzd+" like '%"+srchzdval+"%'";
}
sql = sql+" order by BMBH";
if(!pxzd.equals("") && !pxzd.equals("BMBH"))
{
sql = sql +","+pxzd;
}
else{
sql = sql +",JBXH";
}
// if(!pxzd.equals(""))
// sql = sql+" order by "+pxzd;
}
if(isdesc)
{
sql = sql+" DESC";
}
Hashtable ht = new Hashtable();
ht.put("sql",sql);
vect.add(ht);
ResultSet rs = selectRecord(sql);
Statement stmt = null;
try{
int rowno=0;
//取得列数和列名
ResultSetMetaData rsmd = rs.getMetaData();
int cols = rsmd.getColumnCount();
while(rs.next())
{
rowno++;
//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));
if(field.equals("BMBH"))
{
value = getApartName(value);
}
if(field.equals("ZZZT"))
{
if(value.equals("0"))value="正常";
if(value.equals("1"))value="离职";
if(value.equals("2"))value="退休";
if(value.equals("3"))value="挂起";
}
//if(value==null)value="";
//hash.put(field,value);
} */
//vect.add(hash);
}
vect.add(new Integer(rowno));
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return vect;
}
//取得人员记录列表（不包括只能用户）
public Vector getData()
{
Vector vect = new Vector();
String sql = "";
sql =" select * from ZZ_ZGB where bmbh='"+strOrgNO+"' and ZZZT=0 "
+" and ZZ_ZGB.ZGBH<>'1' and ZNYH=0"
+" order by JBXH ";
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));
if(field.equals("BMBH"))
{
value = getApartName(value);
}
if(field.equals("ZZZT"))
{
if(value.equals("0"))value="正常";
if(value.equals("1"))value="离职";
if(value.equals("2"))value="退休";
}
if(value==null)value="";
hash.put(field,value);
}
vect.add(hash);
}
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
}
return vect;
}
////取得人员记录列表（包括职能用户）
public Vector getZNData()
{
Vector vect = new Vector();
String sql = "";
sql =" select * from ZZ_ZGB where bmbh='"+strOrgNO+"' and ZZZT=0 "
+" and ZZ_ZGB.ZGBH<>'1' "
+" order by JBXH ";
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));
if(field.equals("BMBH"))
{
value = getApartName(value);
}
if(field.equals("ZZZT"))
{
if(value.equals("0"))value="正常";
if(value.equals("1"))value="离职";
if(value.equals("2"))value="退休";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -