package com.semor.workorder.services;
import java.sql.Connection;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import com.semor.workorder.dao.implDao.WorkOrderDao;
import com.semor.workorder.dbhelper.ConnectionManager;
import com.semor.workorder.models.CustomerInfoModel;
import com.semor.workorder.models.EmployeeModel;
import com.semor.workorder.models.InstallTypeModel;
import com.semor.workorder.models.PackageModel;
import com.semor.workorder.models.WorkOrderModel;
/**
* 表单业务处理
*
* @author Administrator
*
*/
public class WorkOrderService {
private WorkOrderDao wod = new WorkOrderDao();
/**
* 执行插入操作
*
* @param wom
* @return
*/
public int exeInsert(WorkOrderModel wom) {
Connection con = null;
try {
con = ConnectionManager.getConnection();
return this.wod.add(wom, con);
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionManager.closeConnection(con);
}
return -1;
}
/**
* 获取总记录数
*
* @return
*/
public int getTotalCount() {
Connection con = null;
try {
con = ConnectionManager.getConnection();
Object obj = this.wod.findByCondition(null, 2, con);
if (obj != null) {
return (int) obj;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionManager.closeConnection(con);
}
return -1;
}
/**
* 分页获取数据
*
* @param startPage
* @param count
* @return
*/
public List<WorkOrderModel> findByPage(int startPage, int count) {
Connection con = null;
int[] obj = { startPage, count };
try {
con = ConnectionManager.getConnection();
Object o = this.wod.findByCondition(obj, 1, con);
if (o != null) {
@SuppressWarnings("unchecked")
List<WorkOrderModel> list = (List<WorkOrderModel>) o;
if (list != null && list.size() > 0) {
for (WorkOrderModel em : list) {
if (em != null) {
em.setCim(new CustomerInfoService().findById(new CustomerInfoModel(em.getWorCustomerId())));
em.setEm(new EmployeeService().findById(new EmployeeModel(em.getWorAddUserId())));
em.setItm(
new InstallTypeService().findById(new InstallTypeModel(em.getWorInstallTypeId())));
em.setPm(new PackageService().findById(new PackageModel(em.getWorPackageId())));
}
}
}
return list;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionManager.closeConnection(con);
}
return null;
}
/**
* 查找自己的工单
*
* @param startPage
* @param count
* @param id
* @return
*/
public List<WorkOrderModel> findSelfByPage(int startPage, int count, int id) {
Connection con = null;
int[] obj = { startPage, count, id };
try {
con = ConnectionManager.getConnection();
Object o = this.wod.findByCondition(obj, 4, con);
if (o != null) {
@SuppressWarnings("unchecked")
List<WorkOrderModel> list = (List<WorkOrderModel>) o;
if (list != null && list.size() > 0) {
for (WorkOrderModel em : list) {
if (em != null) {
em.setCim(new CustomerInfoService().findById(new CustomerInfoModel(em.getWorCustomerId())));
em.setEm(new EmployeeService().findById(new EmployeeModel(em.getWorAddUserId())));
em.setItm(
new InstallTypeService().findById(new InstallTypeModel(em.getWorInstallTypeId())));
em.setPm(new PackageService().findById(new PackageModel(em.getWorPackageId())));
}
}
}
return list;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionManager.closeConnection(con);
}
return null;
}
/**
* 获取自己表单总量
*
* @param id
* @return
*/
public int getTotalCount(int id) {
Connection con = null;
try {
con = ConnectionManager.getConnection();
Object obj = this.wod.findByCondition(id, 5, con);
if (obj != null) {
return (int) obj;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionManager.closeConnection(con);
}
return -1;
}
/**
* 显示待销户工单数量
*
* @return
*/
public int getWaitDeleteTotalCount() {
Connection con = null;
try {
con = ConnectionManager.getConnection();
Object obj = this.wod.findByCondition(null, 6, con);
if (obj != null) {
return (int) obj;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionManager.closeConnection(con);
}
return -1;
}
/**
* 显示待销户工单
*
* @param startPage
* @param count
* @return
*/
public List<WorkOrderModel> findWaitDeleteByPage(int startPage, int count) {
Connection con = null;
int[] obj = { startPage, count };
try {
con = ConnectionManager.getConnection();
Object o = this.wod.findByCondition(obj, 7, con);
if (o != null) {
@SuppressWarnings("unchecked")
List<WorkOrderModel> list = (List<WorkOrderModel>) o;
if (list != null && list.size() > 0) {
for (WorkOrderModel em : list) {
if (em != null) {
em.setCim(new CustomerInfoService().findById(new CustomerInfoModel(em.getWorCustomerId())));
em.setEm(new EmployeeService().findById(new EmployeeModel(em.getWorAddUserId())));
em.setItm(
new InstallTypeService().findById(new InstallTypeModel(em.getWorInstallTypeId())));
em.setPm(new PackageService().findById(new PackageModel(em.getWorPackageId())));
}
}
}
return list;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionManager.closeConnection(con);
}
return null;
}
/**
* 显示待安装工单
*
* @return
*/
public int getWaitInstallTotalCount() {
Connection con = null;
try {
con = ConnectionManager.getConnection();
Object obj = this.wod.findByCondition(null, 8, con);
if (obj != null) {
return (int) obj;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionManager.closeConnection(con);
}
return -1;
}
/**
* 查找待安装工单
*
* @param startPage
* @param count
* @return
*/
public List<WorkOrderModel> findWaitInstallByPage(int startPage, int count) {
Connection con = null;
int[] obj = { startPage, count };
try {
con = ConnectionManager.getConnection();
Object o = this.wod.findByCondition(obj, 9, con);
if (o != null) {
@SuppressWarnings("unchecked")
List<WorkOrderModel> list = (List<WorkOrderModel>) o;
if (list != null && list.size() > 0) {
for (WorkOrderModel em : list) {
if (em != null) {
em.setCim(new CustomerInfoService().findById(new CustomerInfoModel(em.getWorCustomerId())));
em.setEm(new EmployeeService().findById(new EmployeeModel(em.getWorAddUserId())));
em.setItm(
new InstallTypeService().findById(new InstallTypeModel(em.getWorInstallTypeId())));
em.setPm(new PackageService().findById(new PackageModel(em.getWorPackageId())));
}
}
}
return list;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionManager.closeConnection(con);
}
return null;
}
/**
* 根据id查找数据
*
* @param wom
* @return
*/
public WorkOrderModel findById(WorkOrderModel wom) {
Connection con = null;
try {
con = ConnectionManager.getConnection();
WorkOrderModel em = this.wod.findById(wom, con);
if (em != null) {
em.setCim(new CustomerInfoService().findById(new CustomerInfoModel(em.getWorCustomerId())));
em.setEm(new EmployeeService().findById(new EmployeeModel(em.getWorAddUserId())));
em.setItm(new InstallTypeService().findById(new InstallTypeMod
基于JAVA EE的工单管理系统 （271个子文件） 
WorkOrderService.class 11KB WorkOrderDao.class 8KB EmployeeService.class 5KB EmployeeDao.class 5KB CustomerInfoDao.class 4KB LoggerDao.class 4KB WorkOrderModel.class 4KB InstallTypeDao.class 4KB PackageDao.class 4KB UsRoleDao.class 4KB DBHelper.class 4KB LoggerServices.class 4KB InstallTypeService.class 4KB PackageService.class 3KB UsRoleService.class 3KB EmployeeModel.class 3KB CustomerInfoService.class 3KB ConnectionManager.class 3KB LoggerModel.class 2KB CustomerInfoModel.class 2KB WorkOrderMapper.class 2KB EmployeeMapper.class 2KB PackageModel.class 1KB LoggerMapper.class 1KB CustomerInfoMapper.class 1KB PackageMapper.class 1KB InstallTypeModel.class 1KB UsRoleModel.class 1KB InstallTypeMapper.class 1KB UsRoleMapper.class 1KB IDao.class 746B IMapper.class 332B .classpath 846B org.eclipse.wst.common.component 479B org.eclipse.wst.jsdt.ui.superType.container 49B easyui.css 58KB datepicker.css 5KB datepicker.css 5KB icon.css 2KB login.css 2KB demo.css 388B general.css 309B WdatePicker.css 158B Thumbs.db 9KB Thumbs.db 5KB Thumbs.db 3KB
mainFrameMark.gif 18KB btnBg.gif 2KB logo.gif 2KB loading.gif 2KB img.gif 2KB login_name.gif 2KB img.gif 2KB login_password.gif 1KB datePicker.gif 1KB blank.gif 43B blank.gif 43B My97DatePicker.htm 1KB
mysql-connector-java-5.1.39-bin.jar 966KB WorkOrderService.java 12KB WorkOrderDao.java 8KB EmployeeService.java 5KB DBHelper.java 4KB EmployeeDao.java 3KB InstallTypeService.java 3KB WorkOrderModel.java 3KB UsRoleService.java 3KB PackageService.java 3KB CustomerInfoDao.java 3KB LoggerServices.java 3KB EmployeeModel.java 3KB CustomerInfoService.java 3KB LoggerDao.java 3KB InstallTypeDao.java 3KB PackageDao.java 2KB UsRoleDao.java 2KB ConnectionManager.java 2KB LoggerModel.java 2KB IDao.java 2KB CustomerInfoModel.java 1KB PackageModel.java 1KB InstallTypeModel.java 991B UsRoleModel.java 976B WorkOrderMapper.java 901B EmployeeMapper.java 895B CustomerInfoMapper.java 705B LoggerMapper.java 669B PackageMapper.java 613B InstallTypeMapper.java 603B UsRoleMapper.java 573B IMapper.java 235B
111111.jpg 284KB face.jpg 257KB bg1.jpg 207KB leftFrameBg.jpg 27KB leftFrameButtonBg.jpg 17KB bg11.jpg 15KB bg.jpg 15KB loginInputBg.jpg 8KB leftFrameButton.jpg 7KB共 271 条
- 1
- 2
- 3
资源评论
tom_ok00102019-05-10内容太少。
SemorBaby2019-05-17只是针对开发学习的，以后会更努力，谢谢- 卖萌不还价2017-03-07类似学生练习的作品，10分不值
