service

 

package cn.com.mbp.hr.employee.OutSourcing.service;

import java.sql.Timestamp;

import java.util.Date;

import java.util.List;

 

import javax.persistence.EntityManager;

import javax.persistence.PersistenceContext;

 

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.security.core.context.SecurityContextHolder;

import org.springframework.stereotype.Service;

 

import cn.com.mbp.common.acount.security.UserInfoDetails;

import cn.com.mbp.common.sql.impl.JpaNativeSqlRunner;

import cn.com.mbp.hr.common.entity.TOutSourcing;

import cn.com.mbp.hr.employee.OutSourcing.mvc.OutSourcingdetailForm;

import cn.com.mbp.hr.employee.OutSourcing.orm.OutSourcingInfoBean;

import cn.com.mbp.hr.employee.SkillGrade.ScoreRecord.mvc.ScoreRecordForm;

 

/**

 * <p>机能名: 基本设计 /外派信息</p>

 * <p>功能说明：员工外派信息一览</p>

 * <p>式样书：基本设计_外派信息.xls</p>

 * @version 1.0 2011/3/21

 * @author 张蕾（s1011524）

 */

@Service

public class OutSourcingService implements OutSourcingServicelocal {

@Autowired

private JpaNativeSqlRunner sqlRunner;

@PersistenceContext

private EntityManager em;

 

private static final String SQLMAP = "cn.com.mbp.hr.employee.OutSourcing.orm.OutSourcing.";

public List<OutSourcingInfoBean> FindAll(Integer employeeid){

List<OutSourcingInfoBean> datas=sqlRunner.queryForList(em, SQLMAP + "findOutSourcing",employeeid, OutSourcingInfoBean.class, -1, -1);

return datas;

}

public void saveOutSourcing(OutSourcingdetailForm form,int employeeid) {

UserInfoDetails user = (UserInfoDetails)SecurityContextHolder.getContext().getAuthentication().getPrincipal();

 

TOutSourcing l = new TOutSourcing();

l.setEmployeeid(employeeid);//员工ID

l.setOuttype(form.getOuttype());//外派类型

l.setStartdate(new Timestamp(form.getStartdate().getTime()));//开始时间

l.setEnddate(new Timestamp(form.getEnddate().getTime()));//结束时间

if("支援".equals(form.getOuttype())){

l.setDestination(null);

}else{

l.setDestination(form.getDestination());

}

if("外派".equals(form.getOuttype())){

System.out.println("1");

l.setDeptno(null);//支1援部门

l.setGroupname(null);

}

else{

System.out .println("1111111");

l.setGroupname(form.getGroupname());

l.setDeptno(form.getDeptno());//支援部门

}

l.setUpdateuserid(user.getUserid());//更新者

l.setCreatedate(new Timestamp((new Date()).getTime()));//创建日期

l.setCreateuserid(user.getUserid());//创建者

em.persist(l);//保存数据

}

public TOutSourcing getOutSourcingById(Integer outsourcingid) {

return em.find(TOutSourcing.class, outsourcingid);

}

public void updateOutSourcing(Integer outsourcingid, OutSourcingdetailForm form) {

// 读取login用户信息

UserInfoDetails user = (UserInfoDetails)SecurityContextHolder.getContext().getAuthentication().getPrincipal();

TOutSourcing t = new TOutSourcing();

//version check

t.setOutsourcingid(outsourcingid);//外派ID

t.setUpdatedate(new Timestamp(form.getUpdatedate().getTime()));//更新时间

t = em.merge(t);//验证版本

t.setOuttype(form.getOuttype());//修改外派类型

t.setStartdate(new Timestamp(form.getStartdate().getTime()));//修改开始时间

t.setEnddate(new Timestamp(form.getEnddate().getTime()));//修改结束时间

if("支援".equals(form.getOuttype())){

t.setDestination(null);

}else{

t.setDestination(form.getDestination());

}

if("外派".equals(form.getOuttype())){

System.out.println("1");

t.setDeptno(null);//支1援部门

t.setGroupname(null);

}

else{

System.out .println("1111111");

t.setGroupname(form.getGroupname());

t.setDeptno(form.getDeptno());//支援部门

}

t.setUpdateuserid(user.getUserid());//修改更新者

}

public void deleteOutSourcing(OutSourcingdetailForm form,int outsourcingid){

TOutSourcing t= new TOutSourcing();

t.setOutsourcingid(outsourcingid);//外派ID

t.setUpdatedate(new Timestamp(form.getUpdatedate().getTime()));//

t = em.merge(t);//验证版本

em.remove(t);//删除

}

 

@Override

public Integer checkDept(OutSourcingdetailForm form, Integer userid){

Integer c = sqlRunner.queryForObject(em, 

SQLMAP + "checkDept", form.getDeptno(), Integer.class);

if(!(form.getDeptno().isEmpty())&&(c==0)){

return 0;

}else{

return 1;

}

}

public Integer checkType(OutSourcingdetailForm form, Integer userid){

if("外派".equals(form.getOuttype())&&(form.getDestination().isEmpty())){

return 0;

}

if("支援".equals(form.getOuttype())&&form.getDeptno().isEmpty()){

return 1;}

else{

return 2;

}

}

}