12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455 |
- package com.kingdee.shr.ats.web.handler;
- import java.math.BigDecimal;
- import java.sql.SQLException;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import org.springframework.ui.ModelMap;
- import com.kingdee.bos.BOSException;
- import com.kingdee.bos.Context;
- import com.kingdee.eas.common.EASBizException;
- import com.kingdee.eas.util.app.DbUtil;
- import com.kingdee.jdbc.rowset.IRowSet;
- import com.kingdee.shr.base.syssetting.context.SHRContext;
- import com.kingdee.shr.base.syssetting.exception.SHRWebException;
- import com.kingdee.shr.base.syssetting.web.json.JSONUtils;
- /**
- * 假期额度表单handler
- * @author xiaoxin
- *
- */
- public class HolidayLimitEditHandlerEx extends HolidayLimitEditHandler{
- /**
- * 获取年假上年转入额度-今年结转额度
- * @param request
- * @param response
- * @param modelMap
- * @throws EASBizException
- * @throws BOSException
- * @throws SHRWebException
- */
- public void getCarryLimitAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap) throws EASBizException, BOSException, SHRWebException {
- Context ctx = SHRContext.getInstance().getContext();
- String billId = request.getParameter("billId");
- String sql = "/*dialect*/SELECT COALESCE(a.CFLASTCARRYFORWARD,0) - COALESCE(a.CFCARRYFORWARD,0) as auualLimit FROM T_HR_ATS_HolidayLimit a "
- + "left join T_HR_ATS_HolidayPolicy b on a.FHOLIDAYPOLICYID = b.fid "
- + "left join T_HR_ATS_HolidayType c on b.FHOLIDAYTYPEID = c.fid "
- + "where a.fid = '"+billId+"' and c.FNUMBER = 'JQLX000001Y'";
- IRowSet rowSet = DbUtil.executeQuery(ctx, sql);
- BigDecimal carryLimit = BigDecimal.ZERO;
- try {
- if(rowSet.next()) {
- carryLimit = rowSet.getBigDecimal("auualLimit")==null?BigDecimal.ZERO:rowSet.getBigDecimal("auualLimit");
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- modelMap.put("carryLimit", carryLimit);
- JSONUtils.writeJson(response, modelMap);
- }
- }
|