/**
* 功能：获取部门盘点设备明细Excel文件
*
* @return File
* @throws DataTransException
*/
public File getExportFile() throws DataTransException {
File file = null;
try {
CostCheckResultModel modelProducer = (CostCheckResultModel) sqlProducer;
SQLModel sqlModel = modelProducer.getPageQueryModel();
String reportTitle = "盘点结果报表（按部门）";
String fileName = reportTitle + ".xls";
String filePath = WorldConstant.USER_HOME;
filePath += WorldConstant.FILE_SEPARATOR;
filePath += fileName;
TransRule rule = new TransRule();
rule.setDataSource(sqlModel);
rule.setSourceConn(conn);
rule.setTarFile(filePath);
DataRange range = new DataRange();
rule.setDataRange(range);
rule.setFieldMap(getFieldMap());
CustomTransData custData = new CustomTransData();
custData.setReportTitle(reportTitle);
custData.setReportPerson(userAccount.getUsername());
custData.setNeedReportDate(true);
rule.setCustData(custData);
rule.setCalPattern(LINE_PATTERN);
TransferFactory factory = new TransferFactory();
DataTransfer transfer = factory.getTransfer(rule);
transfer.transData();
file = (File) transfer.getTransResult();
} catch (SQLModelException ex) {
ex.printLog();
throw new DataTransException(ex);
}
return file;
}
/**
* 功能：导出Excel文件。
*
* @return File
* @throws com.sino.base.exception.DataTransException
*/
public File exportFile() throws DataTransException {
File file = null;
try {
DataTransfer transfer = null;
SQLModel sqlModel = sqlProducer.getPageQueryModel();
TransRule rule = new TransRule();
rule.setDataSource(sqlModel);
rule.setCalPattern(CalendarConstant.LINE_PATTERN);
rule.setSourceConn(conn);
String fileName = "基站地点统计表.xls";
String filePath = WorldConstant.USER_HOME;
filePath += WorldConstant.FILE_SEPARATOR;
filePath += fileName;
rule.setTarFile(filePath);
DataRange range = new DataRange();
rule.setDataRange(range);
Map fieldMap = new HashMap();
fieldMap.put("WORKORDER_OBJECT_CODE", "地点编号");
fieldMap.put("WORKORDER_OBJECT_NAME", "地点简称");
fieldMap.put("WORKORDER_OBJECT_LOCATION", "所在地点");
fieldMap.put("ORGANIZATION_ID", "组织ID");
fieldMap.put("COUNTY_NAME", "所在区县");
fieldMap.put("DISABLE_DATE", "失效日期");
fieldMap.put("CATEGORY_NAME", "地点类别");
// fieldMap.put("IS_TEMP_ADDR", "是否临时地点");
fieldMap.put("CREATION_DATE", "创建日期");
fieldMap.put("CREATED_BY", "创建人");
fieldMap.put("PROJECT_NAME", "所属工程");
rule.setFieldMap(fieldMap);
CustomTransData custData = new CustomTransData();
custData.setReportTitle(fileName);
custData.setReportPerson(sfUser.getUsername());
custData.setNeedReportDate(true);
rule.setCustData(custData);
/*rule.setSheetSize(1000);*/
// 设置分页显示
TransferFactory factory = new TransferFactory();
transfer = factory.getTransfer(rule);
transfer.transData();
file = (File) transfer.getTransResult();
} catch (SQLModelException ex) {
ex.printLog();
throw new DataTransException(ex);
}
return file;
}
/**
* 功能：导出Excel文件。
*
* @return File
* @throws com.sino.base.exception.DataTransException
*/
public File exportFileM() throws DataTransException {
File file = null;
try {
// SQLModel sqlModel = sqlProducer.getPageQueryModel(); //获得查询的sql
AmsHouseInfoDTO HLDTO = (AmsHouseInfoDTO) dtoParameter;
GetMisHousInfoModel updateEII = new GetMisHousInfoModel(userAccount, HLDTO);
SQLModel sqlModel = updateEII.getDispositionModel();
TransRule rule = new TransRule();
rule.setDataSource(sqlModel);
rule.setCalPattern(CalendarConstant.LINE_PATTERN);
rule.setSourceConn(conn);
String fileName = "房屋土地信息表.xls";
String filePath = WorldConstant.USER_HOME;
filePath += WorldConstant.FILE_SEPARATOR;
filePath += fileName;
rule.setTarFile(filePath);
DataRange range = new DataRange();
rule.setDataRange(range);
Map fieldMap = new HashMap();
fieldMap.put("BARCODE", "条码");
fieldMap.put("ITEM_NAME", "名称");
fieldMap.put("ITEM_SPEC", "型号");
fieldMap.put("HOUSE_ADDRESS", "地点");
fieldMap.put("HOUSE_AREA", "房屋面积");
fieldMap.put("OCCUPY_AREA", "占地面积");
fieldMap.put("OFFICE_USAGE", "用途");
fieldMap.put("OFFICE_TYPE", "类型");
fieldMap.put("HOUSE_CERTIFICATE_NO", "房产证号");
fieldMap.put("LAND_CERTFICATE_NO", "土地证号");
fieldMap.put("ATTRIBUTE2", "是否处理");
rule.setFieldMap(fieldMap);
CustomTransData custData = new CustomTransData();
custData.setReportTitle("房屋土地信息表");
custData.setReportPerson(userAccount.getUsername());
custData.setNeedReportDate(true);
rule.setCustData(custData);
TransferFactory factory = new TransferFactory();
DataTransfer transfer = factory.getTransfer(rule);
transfer.transData();
file = (File) transfer.getTransResult();
} catch (SQLModelException ex) {
ex.printLog();
throw new DataTransException(ex);
}
return file;
}
/**
* 功能：导出未处理的Excel文件。
*
* @return File
* @throws com.sino.base.exception.DataTransException
*/
public File exportMisFile() throws DataTransException {
File file = null;
try {
SQLModel sqlModel = sqlProducer.getPageQueryModel(); // 获得查询的sql
TransRule rule = new TransRule();
rule.setDataSource(sqlModel);
rule.setCalPattern(CalendarConstant.LINE_PATTERN);
rule.setSourceConn(conn);
String fileName = "未导入房屋土地信息表.xls";
String filePath = WorldConstant.USER_HOME;
filePath += WorldConstant.FILE_SEPARATOR;
filePath += fileName;
rule.setTarFile(filePath);
DataRange range = new DataRange();
rule.setDataRange(range);
Map fieldMap = new HashMap();
fieldMap.put("TAG_NUMBER", "条码");
fieldMap.put("ASSETS_DESCRIPTION", "名称");
fieldMap.put("MODEL_NUMBER", "型号");
fieldMap.put("ASSIGNED_TO_NAME", "责任人");
fieldMap.put("DATE_PLACED_IN_SERVICE", "启用日期");
fieldMap.put("ASSETS_LOCATION", "地点");
rule.setFieldMap(fieldMap);
CustomTransData custData = new CustomTransData();
custData.setReportTitle("信息表");
custData.setReportPerson(userAccount.getUsername());
custData.setNeedReportDate(true);
rule.setCustData(custData);
TransferFactory factory = new TransferFactory();
DataTransfer transfer = factory.getTransfer(rule);
transfer.transData();
file = (File) transfer.getTransResult();
} catch (SQLModelException ex) {
ex.printLog();
throw new DataTransException(ex);
}
return file;
}
public File exportFile() throws DataTransException {
File file = null;
try {
SQLModel sqlModel = sqlProducer.getPageQueryModel();
TransRule rule = new TransRule();
rule.setDataSource(sqlModel);
rule.setSourceConn(conn);
String fileName = "备件业务单据统计表.xls";
String filePath = WorldConstant.USER_HOME;
filePath += WorldConstant.FILE_SEPARATOR;
filePath += fileName;
rule.setTarFile(filePath);
DataRange range = new DataRange();
rule.setDataRange(range);
Map fieldMap = new HashMap();
fieldMap.put("TRANS_NO", "单据号");
fieldMap.put("CREATED_USER", "创建人");
fieldMap.put("CREATION_DATE", "创建日期");
fieldMap.put("TRANS_STATUS_NAME", "单据状态");
fieldMap.put("TRANS_TYPE_NAME", "单据类型");
rule.setFieldMap(fieldMap);
CustomTransData custData = new CustomTransData();
custData.setReportTitle(fileName);
custData.setReportPerson(sfUser.getUsername());
custData.setNeedReportDate(true);
rule.setCustData(custData);
/*rule.setSheetSize(1000);*/
// 设置分页显示
TransferFactory factory = new TransferFactory();
DataTransfer transfer = factory.getTransfer(rule);
transfer.transData();
file = (File) transfer.getTransResult();
} catch (SQLModelException ex) {
ex.printLog();
throw new DataTransException(ex);
}
return file;
}
public File exportFile() throws DataTransException {
File file = null;
try {
ItemInfoDTO itemInfoDto = (ItemInfoDTO) dtoParameter;
if (itemInfoDto.getQryType().equals(WebAttrConstant.BY_DAIWEI)) {
SQLModel sqlModel = sqlProducer.getPageQueryModel();
TransRule rule = new TransRule();
rule.setDataSource(sqlModel);
rule.setCalPattern(CalendarConstant.LINE_PATTERN);
rule.setSourceConn(conn);
String fileName = "设备信息.xls";
String filePath = WorldConstant.USER_HOME;
filePath += WorldConstant.FILE_SEPARATOR;
filePath += fileName;
rule.setTarFile(filePath);
DataRange range = new DataRange();
rule.setDataRange(range);
Map fieldMap = new HashMap();
// fieldMap.put("ORG_NAME", "公司");
fieldMap.put("BARCODE", "条码");
fieldMap.put("ITEM_NAME", "设备名称");
fieldMap.put("ITEM_SPEC", "规格型号");
fieldMap.put("WORKORDER_OBJECT_CODE", "地点编号");
fieldMap.put("WORKORDER_OBJECT_LOCATION", "所在地点");
fieldMap.put("NAME", "代维公司");
rule.setFieldMap(fieldMap);
CustomTransData custData = new CustomTransData();
custData.setReportTitle("设备信息");
custData.setReportPerson(sfUser.getUsername());
custData.setNeedReportDate(true);
rule.setCustData(custData);
TransferFactory factory = new TransferFactory();
DataTransfer transfer = factory.getTransfer(rule);
transfer.transData();
file = (File) transfer.getTransResult();
} else {
SQLModel sqlModel = sqlProducer.getPageQueryModel();
TransRule rule = new TransRule();
rule.setDataSource(sqlModel);
rule.setCalPattern(CalendarConstant.LINE_PATTERN);
rule.setSourceConn(conn);
String fileName = "设备信息.xls";
String filePath = WorldConstant.USER_HOME;
filePath += WorldConstant.FILE_SEPARATOR;
filePath += fileName;
rule.setTarFile(filePath);
DataRange range = new DataRange();
rule.setDataRange(range);
Map fieldMap = new HashMap();
// fieldMap.put("ORG_NAME", "公司");
fieldMap.put("BARCODE", "条码");
fieldMap.put("ITEM_NAME", "设备名称");
fieldMap.put("ITEM_SPEC", "规格型号");
fieldMap.put("ITEM_CATEGORY", "设备分类");
fieldMap.put("START_DATE", "启用日期");
fieldMap.put("PROJECT_NAME", "所属工程");
fieldMap.put("WORKORDER_OBJECT_NAME", "所属地点");
fieldMap.put("COUNTY_NAME", "所属区县");
rule.setFieldMap(fieldMap);
CustomTransData custData = new CustomTransData();
custData.setReportTitle("设备信息");
custData.setReportPerson(sfUser.getUsername());
custData.setNeedReportDate(true);
rule.setCustData(custData);
TransferFactory factory = new TransferFactory();
DataTransfer transfer = factory.getTransfer(rule);
transfer.transData();
file = (File) transfer.getTransResult();
}
} catch (SQLModelException ex) {
ex.printLog();
throw new DataTransException(ex);
}
return file;
}