package com.qxueyou.scc.exam.model;

import java.io.Serializable;
import java.util.Date;
import java.util.List;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Transient;

import org.springframework.format.annotation.DateTimeFormat;

import com.fasterxml.jackson.annotation.JsonIgnore;
import com.qxueyou.scc.base.model.ITrace;
import com.qxueyou.scc.exercise.model.ExerciseItem;


/**
 * The persistent class for the exam_paper_section_info database table.
 * 
 */
@Entity
@Table(name="exam_paper_section_info")
@NamedQuery(name="ExamPaperSectionInfo.findAll", query="SELECT e FROM ExamPaperSectionInfo e")
public class ExamPaperSectionInfo implements Serializable,ITrace {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="SECTION_ID", unique=true,nullable=false, length=32)
	private String sectionId;

	@Column(name="GROUP_ID")
	private String groupId;
	
	@Column(name="EXAM_PAPER_ID")
	private String examPaperId;

	@Column(name="ITEM_END_ORDER")
	private short itemEndOrder;

	@Column(name="ITEM_START_ORDER")
	private short itemStartOrder;

	@Column(name="SECTION_DESC")
	private String sectionDesc;

	@Column(name="SECTION_NAME")
	private String sectionName;

	@Column(name="SECTION_ORDER")
	private int sectionOrder;
	
	@Column(name = "CREATE_ID", length = 32)
	@JsonIgnore
	private String createId;
	
	@Column(name="CREATOR", nullable=false, length=100)
	@JsonIgnore
	private String creator;
	
	@Column(name="CREATE_TIME", nullable=false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@JsonIgnore
	private Date createTime;
	
	/**  修改人ID */
	@Column(name="UPDATE_ID", length=32)
	@JsonIgnore
	private String updateId;

	/**  修改时间 */
	@Column(name="UPDATE_TIME", nullable=false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	private Date updateTime;
	
	/**  修改人 */
	@Column(name="UPDATOR", length=100)
	@JsonIgnore
	private String updator;

	/** 删除标志  */
	@Column(name="DELETE_FLAG", nullable=false)
	@JsonIgnore
	private boolean deleteFlag;
	
	@ManyToOne(cascade = CascadeType.ALL,fetch = FetchType.LAZY)
	@JoinColumn(name = "EXAM_PAPER_ID",referencedColumnName="EXAM_PAPER_ID",updatable=false,insertable=false)
	@JsonIgnore
	private ExamPaperInfo examPaperInfo;
	
	@Transient
	List<ExerciseItem> lstExerciseItem;

	public ExamPaperSectionInfo() {
	}

	public String getExamPaperId() {
		return examPaperId;
	}

	public void setExamPaperId(String examPaperId) {
		this.examPaperId = examPaperId;
	}


	public List<ExerciseItem> getLstExerciseItem() {
		return lstExerciseItem;
	}

	public void setLstExerciseItem(List<ExerciseItem> lstExerciseItem) {
		this.lstExerciseItem = lstExerciseItem;
	}

	public ExamPaperInfo getExamPaperInfo() {
		return examPaperInfo;
	}

	public void setExamPaperInfo(ExamPaperInfo examPaperInfo) {
		this.examPaperInfo = examPaperInfo;
	}

	public String getSectionId() {
		return this.sectionId;
	}

	public void setSectionId(String sectionId) {
		this.sectionId = sectionId;
	}

	public String getGroupId() {
		return this.groupId;
	}

	public void setGroupId(String groupId) {
		this.groupId = groupId;
	}

	public short getItemEndOrder() {
		return this.itemEndOrder;
	}

	public void setItemEndOrder(short itemEndOrder) {
		this.itemEndOrder = itemEndOrder;
	}

	public short getItemStartOrder() {
		return this.itemStartOrder;
	}

	public void setItemStartOrder(short itemStartOrder) {
		this.itemStartOrder = itemStartOrder;
	}

	public String getSectionDesc() {
		return this.sectionDesc;
	}

	public void setSectionDesc(String sectionDesc) {
		this.sectionDesc = sectionDesc;
	}

	public String getSectionName() {
		return this.sectionName;
	}

	public void setSectionName(String sectionName) {
		this.sectionName = sectionName;
	}

	public int getSectionOrder() {
		return this.sectionOrder;
	}

	public void setSectionOrder(int sectionOrder) {
		this.sectionOrder = sectionOrder;
	}

	public String getCreateId() {
		return createId;
	}

	public void setCreateId(String createId) {
		this.createId = createId;
	}

	public String getCreator() {
		return creator;
	}

	public void setCreator(String creator) {
		this.creator = creator;
	}

	public Date getCreateTime() {
		return createTime;
	}

	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}

	public String getUpdateId() {
		return updateId;
	}

	public void setUpdateId(String updateId) {
		this.updateId = updateId;
	}

	public Date getUpdateTime() {
		return updateTime;
	}

	public void setUpdateTime(Date updateTime) {
		this.updateTime = updateTime;
	}

	public String getUpdator() {
		return updator;
	}

	public void setUpdator(String updator) {
		this.updator = updator;
	}

	public boolean getDeleteFlag() {
		return deleteFlag;
	}

	public void setDeleteFlag(boolean deleteFlag) {
		this.deleteFlag = deleteFlag;
	}
	
}