潘钊 / bsth_control · Files

package com.bsth.entity.schedule.temp;

import com.bsth.entity.schedule.SchedulePlan;

import javax.persistence.*;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Date;

/**
 * 排班的中间结果数据，记录每次排班后规则的变化。
 */
@Entity
@Table(name = "bsth_c_s_sp_rule_rst")
// TODO：此表以后考虑表分区
public class SchedulePlanRuleResult {
    /** 主键Id */
    @Id
    @GeneratedValue
    private Long id;

    /** 线路id */
    // 这里要建一个索引 tt1 normal btree
    private Integer xlId;
    /** 线路名字 */
    private String xlName;

    /** 排班规则id */
    private String ruleId;
    /** 启用日期（用于md5计算） */
    private Date qyrq;
    /** 车辆配置id */
    private String ccId;
    /** 车辆自编号 */
    private String ccZbh;

    /** 路牌id列表字符串（用于md5计算） */
    @Column(length = 1000)
    private String gids;
    /** 路牌名字列表字符串 */
    private String gnames;
    /** 翻到哪个路牌索引 */
    private String gidindex;
    /** 原始的起始路牌索引（用于md5计算） */
    private String origingidindex;
    /** 人员配置id列表字符串 */
    @Column(length = 1000)
    private String ecids;
    /** 人员配置搭班编码列表字符串 */
    private String ecdbbms;
    /** 翻到哪个人员配置索引 */
    private String ecindex;

    /** 时刻表id */
    private String ttinfoId;
    /** 时刻表名字 */
    private String ttinfoName;

    /** 排班日期 */
    // 这里要建一个索引 tt2 normal btree
    private Date scheduleDate;

    /** 操作人员id */
    private String sysuserId;
    /** 操作人员姓名 */
    private String sysuserName;
    /** 操作时间 */
    // 这里要建一个索引 tt3 normal btree
    private Date createDate;

    public SchedulePlanRuleResult() {

    }
    public SchedulePlanRuleResult(SchedulePlan schedulePlan) {
        this.sysuserId = schedulePlan.getCreateBy().getId().toString();
        this.sysuserName = schedulePlan.getCreateBy().getName();
//        this.createDate = schedulePlan.getCreateDate();
        this.createDate = new Date();
    }

    public static String generateInsertSql() {
        String sql = "insert into bsth_c_s_sp_rule_rst" +
                "(xl_id,xl_name,rule_id,cc_id,cc_zbh," +
                "gids,gnames,gidindex,ecids,ecdbbms,ecindex," +
                "ttinfo_id,ttinfo_name,schedule_date," +
                "sysuser_id,sysuser_name,create_date, qyrq, origingidindex) " +
                "values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

        return sql;
    }

    public void preparedStatementSet(PreparedStatement ps) throws SQLException {
        ps.setInt(1, this.getXlId());
        ps.setString(2, this.getXlName());
        ps.setString(3, this.getRuleId());
        ps.setString(4, this.getCcId());
        ps.setString(5, this.getCcZbh());
        ps.setString(6, this.getGids());
        ps.setString(7, this.getGnames());
        ps.setString(8, this.getGidindex());
        ps.setString(9, this.getEcids());
        ps.setString(10, this.getEcdbbms());
        ps.setString(11, this.getEcindex());
        ps.setString(12, this.getTtinfoId());
        ps.setString(13, this.getTtinfoName());
        ps.setDate(14, new java.sql.Date(this.getScheduleDate().getTime()));
        ps.setString(15, this.getSysuserId());
        ps.setString(16, this.getSysuserName());
        ps.setTimestamp(17, new java.sql.Timestamp(this.getCreateDate().getTime()));
        ps.setDate(18, new java.sql.Date(this.getQyrq().getTime()));
        ps.setString(19, this.getOrigingidindex());

    }

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public Integer getXlId() {
        return xlId;
    }

    public void setXlId(Integer xlId) {
        this.xlId = xlId;
    }

    public String getXlName() {
        return xlName;
    }

    public void setXlName(String xlName) {
        this.xlName = xlName;
    }

    public String getRuleId() {
        return ruleId;
    }

    public void setRuleId(String ruleId) {
        this.ruleId = ruleId;
    }

    public String getCcId() {
        return ccId;
    }

    public void setCcId(String ccId) {
        this.ccId = ccId;
    }

    public String getCcZbh() {
        return ccZbh;
    }

    public void setCcZbh(String ccZbh) {
        this.ccZbh = ccZbh;
    }

    public String getGids() {
        return gids;
    }

    public void setGids(String gids) {
        this.gids = gids;
    }

    public String getGnames() {
        return gnames;
    }

    public void setGnames(String gnames) {
        this.gnames = gnames;
    }

    public String getGidindex() {
        return gidindex;
    }

    public void setGidindex(String gidindex) {
        this.gidindex = gidindex;
    }

    public String getEcids() {
        return ecids;
    }

    public void setEcids(String ecids) {
        this.ecids = ecids;
    }

    public String getEcdbbms() {
        return ecdbbms;
    }

    public void setEcdbbms(String ecdbbms) {
        this.ecdbbms = ecdbbms;
    }

    public String getEcindex() {
        return ecindex;
    }

    public void setEcindex(String ecindex) {
        this.ecindex = ecindex;
    }

    public String getTtinfoId() {
        return ttinfoId;
    }

    public void setTtinfoId(String ttinfoId) {
        this.ttinfoId = ttinfoId;
    }

    public String getTtinfoName() {
        return ttinfoName;
    }

    public void setTtinfoName(String ttinfoName) {
        this.ttinfoName = ttinfoName;
    }

    public Date getScheduleDate() {
        return scheduleDate;
    }

    public void setScheduleDate(Date scheduleDate) {
        this.scheduleDate = scheduleDate;
    }

    public String getSysuserId() {
        return sysuserId;
    }

    public void setSysuserId(String sysuserId) {
        this.sysuserId = sysuserId;
    }

    public String getSysuserName() {
        return sysuserName;
    }

    public void setSysuserName(String sysuserName) {
        this.sysuserName = sysuserName;
    }

    public Date getCreateDate() {
        return createDate;
    }

    public void setCreateDate(Date createDate) {
        this.createDate = createDate;
    }

    public Date getQyrq() {
        return qyrq;
    }

    public void setQyrq(Date qyrq) {
        this.qyrq = qyrq;
    }

    public String getOrigingidindex() {
        return origingidindex;
    }

    public void setOrigingidindex(String origingidindex) {
        this.origingidindex = origingidindex;
    }
}