jkyjjkyjsjdao.java

以前做的一个j2ee的项目

package gov.gdlt.ssgly.taxcore.taxdao.jkyj;

import java.math.BigDecimal;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.HashMap;

import gov.gdlt.ssgly.taxcore.comm.config.ApplicationContext;
import gov.gdlt.ssgly.taxcore.comm.dao.BaseDataAccessObject;
import gov.gdlt.ssgly.taxcore.taxdao.zbgl.ZBGLzbsjDAO;

/**
 *
 * <p>Title: 监控预警事件DAO</p>
 *
 * <p>Description: 广东地税税收管理员工作平台</p>
 *
 * <p>Copyright: Copyright (c) 2005 广东省地方税务局，广州市地方税务局</p>
 *
 * <p>Company: 广州地税</p>
 *
 * @author 郑毅晖
 * @version 1.0
 */
public class JKYJjkyjsjDAO extends BaseDataAccessObject {
    public JKYJjkyjsjDAO() {
    }

    private BigDecimal jl_xh;
    private Timestamp fs_sj;
    private String cfy_dm;
    private BigDecimal rw_xh;
    private BigDecimal nsrnbm;
    private String zb_dm;
    private String ztbh;
    private String xxms;
    private String ts_bj;
    private String zt_mc;
    private String zt_lx;
    private String ztms;
    private String tsys;
    private String tstb_mc;
    private String op_jsp; //调用任务管理的页面

    public void setJl_xh(BigDecimal jl_xh) {
        this.jl_xh = jl_xh;
    }

    public BigDecimal getJl_xh() {
        return jl_xh;
    }

    public void setFs_sj(Timestamp fs_sj) {
        this.fs_sj = fs_sj;
    }

    public Timestamp getFs_sj() {
        return fs_sj;
    }

    public void setCfy_dm(String cfy_dm) {
        this.cfy_dm = cfy_dm;
    }

    public String getCfy_dm() {
        return cfy_dm;
    }

    public void setRw_xh(BigDecimal rw_xh) {
        this.rw_xh = rw_xh;
    }

    public void setNsrnbm(BigDecimal nsrnbm) {
        this.nsrnbm = nsrnbm;
    }

    public void setZb_dm(String zb_dm) {
        this.zb_dm = zb_dm;
    }

    public void setZtbh(String ztbh) {
        this.ztbh = ztbh;
    }

    public void setXxms(String xxms) {
        this.xxms = xxms;
    }

    public void setTs_bj(String ts_bj) {
        this.ts_bj = ts_bj;
    }

    public void setZt_mc(String zt_mc) {
        this.zt_mc = zt_mc;
    }

    public void setZt_lx(String zt_lx) {
        this.zt_lx = zt_lx;
    }

    public void setZtms(String ztms) {
        this.ztms = ztms;
    }

    public void setTsys(String tsys) {
        this.tsys = tsys;
    }

    public void setTstb_mc(String tstb_mc) {
        this.tstb_mc = tstb_mc;
    }

    public void setOp_jsp(String op_jsp) {
        this.op_jsp = op_jsp;
    }


    public BigDecimal getRw_xh() {
        return rw_xh;
    }

    public BigDecimal getNsrnbm() {
        return nsrnbm;
    }

    public String getZb_dm() {
        return zb_dm;
    }

    public String getZtbh() {
        return ztbh;
    }

    public String getXxms() {
        return xxms;
    }

    public String getTs_bj() {
        return ts_bj;
    }

    public String getZt_mc() {
        return zt_mc;
    }

    public String getZt_lx() {
        return zt_lx;
    }

    public String getZtms() {
        return ztms;
    }

    public String getTsys() {
        return tsys;
    }

    public String getTstb_mc() {
        return tstb_mc;
    }

    public String getOp_jsp() {
        return op_jsp;
    }

    /**
     * 查找某个分类、某个视图下的所有预警事件
     * @param fl_xh：BigDecimal 分类序号
     * @param st_dm：String 视图代码
     * @return ArrayList
     */
    public ArrayList findAllByFlxhStdm(BigDecimal fl_xh, String st_dm) {
        HashMap paramMap = new HashMap();
        paramMap.put("fl_xh", fl_xh);
        paramMap.put("st_dm", st_dm);
        return (ArrayList) selectAll("T_JKYJ_JKYJSJ.selectJkyjsj", paramMap);
    }

    /**
     * 根据关键字查找某个分类、某个视图下的所有预警事件
     * @param fl_xh：BigDecimal 分类序号
     * @param st_dm：String 视图代码
     * @return ArrayList
     * @author:向寅
     */
    public ArrayList findAllByFlxhStdmQuery(BigDecimal fl_xh, String st_dm,
                                            String nsrnbmList) {
        HashMap paramMap = new HashMap();
        paramMap.put("fl_xh", fl_xh);
        paramMap.put("st_dm", st_dm);
        paramMap.put("nsrnbmList", nsrnbmList);
        return (ArrayList) selectAll("T_XTFL.selectJkyjsjQuerys", paramMap);
    }

    /**
     * 查找某个分类下的所有纳税人（冗余设计，与分类管理DAO有重复，但执行的语句不同，因而暂时放在这里）
     * @param fl_xh BigDecimal
     * @return ArrayList
     */
    public ArrayList findAllNsrByFlxh(BigDecimal fl_xh) {
        return (ArrayList) selectAll("T_JKYJ_JKYJSJ.selectNsrInFl", fl_xh);
    }

    /**
     * 根据关键字查找某个分类下的所有纳税人
     * @param fl_xh BigDecimal
     * @return ArrayList
     */
    public ArrayList findAllNsrByFlxhQuery(BigDecimal fl_xh, String cx_tj) {
        HashMap paramMap = new HashMap();
        paramMap.put("fl_xh", fl_xh);
        paramMap.put("cx_tj", cx_tj);
        return (ArrayList) selectAll("T_XTFL.selectNsrInFlQuery", paramMap);
    }

    public ArrayList findAllByFlxhStdmQuerys(BigDecimal fl_xh, String st_dm,
                                             String nsrnbmlist) {
        HashMap paramMap = new HashMap();
        paramMap.put("fl_xh", fl_xh);
        paramMap.put("st_dm", st_dm);
        paramMap.put("nsrnbmList", nsrnbmlist);
        return (ArrayList) selectAll("T_XTFL.selectJkyjsjQuerys", paramMap);
    }

    /**
     * 更新提示标记
     * @param jl_xh：BigDecimal 预警记录序号
     * @param ts_bj：String 提示标记
     * @return int <br>
     *     >=0 被更新的记录数<br>
     *     RET_FAIL 执行失败
     */
    public int updateTsbj(BigDecimal jl_xh, String ts_bj) {
        HashMap paramMap = new HashMap();
        paramMap.put("jl_xh", jl_xh);
        paramMap.put("ts_bj", ts_bj);
        return update("T_JKYJ_JKYJSJ.updateTsbj", paramMap);
    }

    /**
     * 保存预警提示信息（任务管理专用接口）
     * @param nsrnbm：BigDecimal 纳税人内部码
     * @param zb_dm：String 指标代码
     * @param ztbh：String 预警状态编号
     * @param xxms：String 预警详细描述
     * @param rw_xh：BigDecimal 任务序号
     * @return BigDecimal 监控预警事件记录序号<br>
     *     NULL: 执行失败<br>
     *     非空: 保存成功
     */
    public BigDecimal saveJkyjsjForRwgl(BigDecimal nsrnbm, String zb_dm, String ztbh, String xxms, BigDecimal rw_xh) {
        Object result;
        BigDecimal res;

        this.nsrnbm = nsrnbm;
        this.zb_dm = zb_dm;
        this.ztbh = ztbh;
        this.xxms = xxms;
        this.rw_xh = rw_xh;
        this.cfy_dm = "03"; //管理员平台生成
        this.ts_bj = "1"; //需要提示
        result = save("T_JKYJ_JKYJSJ.insertJkyjsj");
        if (result != null && result.equals(new Integer(ApplicationContext.RET_FAIL))) {
            return null;
        } else {
            res = (BigDecimal) result;
        }
        ZBGLzbsjDAO zbsjDAO = new ZBGLzbsjDAO();
        zbsjDAO.setNsrnbm(nsrnbm);
        zbsjDAO.setZb_dm(zb_dm);
        zbsjDAO.setZbz("1"); //预警提示默认填"1"
        zbsjDAO.setLrry_dm("24401000000"); //默认为"税收管理员平台"
        zbsjDAO.setSjly("4"); //来源为管理员平台
        zbsjDAO.setHh(new Integer(1));
        result = zbsjDAO.saveZbsj();
        if (result != null && result.equals(new Integer(ApplicationContext.RET_FAIL))) {
            return null;
        } else {
            return res;
        }
    }

    /**
     * just for test
     * @param args String[]
     */
//    public static void main(String[] args) {
//        JKYJjkyjsjDAO yjsjDAO = new JKYJjkyjsjDAO();
//        BigDecimal result = yjsjDAO.saveJkyjsjForRwgl(new BigDecimal(981533),"ALARM_FP","A04-05","该户6个月没有续购发票",new BigDecimal(0));
//        if (result == null) {
//            System.out.println("save fail!");
//        } else {
//            System.out.println("save successful! jl_xh=" + result);
//        }
//    }
}