// other项目总额 public double getWageOtherItemSum(String itemType, String wageDate, String wageSetID) { double r = 0.0; try { String sql = "select sum(money) from wage_data_record where yearmonth='" + wageDate + "' and setid in (select id from wage_dataset where item_type='" + itemType + "') " + "and userid in (select p.id from wage_set_pers_r p,wage_set w where p.A815700=w.set_id and w.set_id='" + wageSetID + "')"; if ("2".equals(itemType) || "3".equals(itemType)) { sql += " and id in (select concat(v.dataset_user_id,'" + wageDate + "') from wage_dataset_verify v where v.status=1 and v.yearmonth='" + wageDate + "')"; } String c = this.activeapi.queryForString(sql); if (c != null && !"".equals(c)) { r = Double.valueOf(c); } } catch (SysException e) { e.printStackTrace(); } return r; }
public double getWageSigleSum(String itemType) { String set = null; if ("1".equals(itemType)) { set = "a225"; } else if ("2".equals(itemType)) { set = "a226"; } else if ("3".equals(itemType)) { set = "a227"; } String sql = "select sum(" + set + "200) from " + set + " where " + set + "200 is not null and " + set + "200<>0 and " + set + "200<>0.0"; double r = 0.0; try { String c = this.activeapi.queryForString(sql); if (c != null && !"".equals(c)) { r = Double.valueOf(c); } } catch (SysException e) { e.printStackTrace(); } return r; }
public void delete() { try { this.changeService.deleteTypeChange(this.operID); this.operID = null; } catch (SysException e) { e.printStackTrace(); } }
public void effect() { try { this.changeService.batchUpdateTypeChange(this.typeChangeIDs.split(",")); this.typeChangeIDs = null; super.showMessageDetail("操作完成"); } catch (SysException e) { e.printStackTrace(); } }
/** * 设置加入帐套人员顺序 * * @param setID 帐套ID * @param personIDs 人员IDS * @param personCode 人员编号s */ public void batchUpdateWageSetPersonSort(String setID, String personIDs, String personCode) { if (personCode != null && !"".equals(personCode)) { // 查询当前帐套中的最大薪资序号 String sql = "select isnull(max(a001745),0) from a001 where id in (select id from wage_set_pers_r w where w.a815700='" + setID + "')"; int currSort = this.jdbcTemplate.queryForInt(sql); // 循环处理每个人员编号 List sqlList = new ArrayList(); String[] codes = personCode.split(","); for (int i = 0; i < codes.length; i++) { PersonBO p = SysCacheTool.findPersonByCode(codes[i].trim()); // 获得人员对象 if (p != null && personIDs.indexOf(p.getPersonId()) != -1) { String sql1 = "update a001 set A001745= case when len(" + currSort + "+10)<4 then (lpad(" + currSort + "+10,4,0)) else " + currSort + "+10||'' end where id='" + p.getPersonId() + "'"; sqlList.add(sql1); currSort += 10; } } try { this.activeapi.batchExecuteSql(sqlList); } catch (SysException e) { e.printStackTrace(); } } }
public String getInitOrgEdit() { String act = super.getRequestParameter("act"); if ("init".equals(act)) { try { this.orgchangebo = (OrgPersonTypeChangeBO) this.changeService.getObjByID( OrgPersonTypeChangeBO.class, super.getUserInfo().getOrgId()); if (this.orgchangebo == null) { this.orgchangebo = new OrgPersonTypeChangeBO(); this.orgchangebo.setOrgID(super.getUserInfo().getOrgId()); this.changeService.saveObj(this.orgchangebo); } else { if (this.orgchangebo.getWageItem() != null && !"".equals(this.orgchangebo.getWageItem())) { this.baseFields = new ArrayList(); String[] fs = this.orgchangebo.getWageItem().split(","); for (int i = 0; i < fs.length; i++) { InfoItemBO ib = SysCacheTool.findInfoItem("", fs[i]); ib.setItemSequence(String.valueOf(i + 1)); ib.setSetId(CodeUtil.interpertCode(CodeUtil.TYPE_INFOSET, ib.getSetId())); if (!this.baseFields.contains(ib)) { this.baseFields.add(ib); } } } } this.orgchangebo.setOrgName( CodeUtil.interpertCode(CodeUtil.TYPE_ORG, this.orgchangebo.getOrgID())); } catch (SysException e) { e.printStackTrace(); } } return initOrgEdit; }
public void doQuery() { if (this.mypage.getCurrentPage() == 0) { this.mypage.setCurrentPage(1); } try { this.list = this.changeService.getEmpTypeChangeBO( mypage, this.orgID, super.getUserInfo(), this.name, this.apprived, this.time, this.time2); } catch (SysException e) { e.printStackTrace(); } if (this.list == null) { this.list = new ArrayList<EmpPersonTypeChangeBO>(); } for (EmpPersonTypeChangeBO bo : this.list) { PersonBO p = SysCacheTool.findPersonById(bo.getPersonID()); bo.setName(p.getName()); bo.setPersonCode(p.getPersonCode()); bo.setOrgName(CodeUtil.interpertCode(CodeUtil.TYPE_ORG, p.getOrgId())); bo.setDeptName(CodeUtil.interpertCode(CodeUtil.TYPE_ORG, p.getDeptId())); if (bo.getOldType() != null) { bo.setOldTypeDes(CodeUtil.interpertCode(bo.getOldType())); } bo.setNewTypeDes(CodeUtil.interpertCode(bo.getNewType())); p = SysCacheTool.findPersonById(bo.getApplyPersonID()); if (p != null) { bo.setApplyPersonName(p.getName()); } } }