SchedulePlan.java
4.61 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
package com.bsth.entity.schedule;
import com.bsth.entity.Line;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import org.apache.commons.lang3.BooleanUtils;
import javax.persistence.*;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
/**
* 排班计划。
*/
@Entity
@Table(name = "bsth_c_s_sp")
@NamedEntityGraphs({
@NamedEntityGraph(name = "schedulePlan_xl", attributeNodes = {
@NamedAttributeNode("xl"),
})
})
@JsonIgnoreProperties(value={"hibernateLazyInitializer","handler","fieldHandler"})
public class SchedulePlan extends BEntity {
/** 主键Id */
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
/** 关联的线路 */
@ManyToOne(optional = false, cascade = CascadeType.DETACH, fetch = FetchType.LAZY)
private Line xl;
/** 排班计划的开始时间 */
@Column(nullable = false)
private Date scheduleFromTime;
/** 排班计划的结束时间 */
@Column(nullable = false)
private Date scheduleToTime;
/** 使用的时刻表名字列表（用逗号连接） */
private String ttInfoNames;
/** 使用的时刻表id列表（用逗号连接） */
private String ttInfoIds;
/** 是否 排班计划优先 */
private Boolean isHistoryPlanFirst;
/** 每次排班的结果数据（错误，正确提示都在这里） */
@Column(length = 2000)
private String planResult;
@JsonIgnore
/** 使用中间表的一对多关联 明细信息 */
@OneToMany(mappedBy = "schedulePlan", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
private List<SchedulePlanInfo> schedulePlanInfoList = new ArrayList<>();
public static String generateInsertSql() {
String sql = "insert into bsth_c_s_sp " +
" (xl, schedule_from_time, schedule_to_time, " +
"tt_info_names, tt_info_ids, is_history_plan_first, plan_result, " +
"create_by, update_by, create_date, update_date) " +
"values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
return sql;
}
public void preparedStatementSet(PreparedStatement ps) throws SQLException {
ps.setInt(1, this.xl.getId());
ps.setDate(2, new java.sql.Date(this.scheduleFromTime.getTime()));
ps.setDate(3, new java.sql.Date(this.scheduleToTime.getTime()));
ps.setString(4, this.ttInfoNames);
ps.setString(5, this.ttInfoIds);
ps.setInt(6, BooleanUtils.isTrue(this.isHistoryPlanFirst) ? 1 : 0);
ps.setString(7, this.planResult);
ps.setInt(8, this.getCreateBy().getId());
ps.setInt(9, this.getUpdateBy().getId());
ps.setTimestamp(10, new java.sql.Timestamp(this.getCreateDate().getTime()));
ps.setTimestamp(11, new java.sql.Timestamp(this.getUpdateDate().getTime()));
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public Line getXl() {
return xl;
}
public void setXl(Line xl) {
this.xl = xl;
}
public Date getScheduleFromTime() {
return scheduleFromTime;
}
public void setScheduleFromTime(Date scheduleFromTime) {
this.scheduleFromTime = scheduleFromTime;
}
public Date getScheduleToTime() {
return scheduleToTime;
}
public void setScheduleToTime(Date scheduleToTime) {
this.scheduleToTime = scheduleToTime;
}
public List<SchedulePlanInfo> getSchedulePlanInfoList() {
return schedulePlanInfoList;
}
public void setSchedulePlanInfoList(List<SchedulePlanInfo> schedulePlanInfoList) {
this.schedulePlanInfoList = schedulePlanInfoList;
}
public String getTtInfoNames() {
return ttInfoNames;
}
public void setTtInfoNames(String ttInfoNames) {
this.ttInfoNames = ttInfoNames;
}
public String getTtInfoIds() {
return ttInfoIds;
}
public void setTtInfoIds(String ttInfoIds) {
this.ttInfoIds = ttInfoIds;
}
public Boolean getIsHistoryPlanFirst() {
return isHistoryPlanFirst;
}
public void setIsHistoryPlanFirst(Boolean isHistoryPlanFirst) {
this.isHistoryPlanFirst = isHistoryPlanFirst;
}
public String getPlanResult() {
return planResult;
}
public void setPlanResult(String planResult) {
this.planResult = planResult;
}
}