private void writeData2Excel(HSSFSheet sheet, HSSFCellStyle dataStyle, HSSFCellStyle headerStyle)
throws ContainerException {
RowSet searchResult = executeFrm.getSearchResult();
if (searchResult != null && !searchResult.isEmpty()) {
List<ReportViewFrm> definedViews = executeFrm.getDefinedViews();
int fieldCount = definedViews.size();
int dataCount = searchResult.getSize();
int xlsRowNum = 0;
for (int i = 0; i < dataCount; i++) {
Row row = searchResult.getRow(i);
xlsRowNum = i;
if (isFirstFile) {
xlsRowNum++;
}
HSSFRow xlsRow = sheet.createRow(xlsRowNum);
xlsRow.setHeightInPoints(18);
for (short j = 0; j < fieldCount; j++) {
ReportViewFrm viewFrm = definedViews.get(j);
String fieldName = viewFrm.getFieldName();
HSSFCell xlsCell = xlsRow.createCell(j);
xlsCell.setCellStyle(dataStyle);
HSSFRichTextString richText = new HSSFRichTextString(row.getStrValue(fieldName));
xlsCell.setCellValue(richText);
}
}
}
}
/**
* 功能说明：将EAM系统发生的公司内资产调拨同步到MIS系统
*
* @throws com.sino.base.exception.DataHandleException 将EAM系统发生的公司内资产调拨同步到MIS系统出错时抛数据处理异常
*/
public void writeAssetsAllocations() throws DataHandleException {
Connection conn = null;
try {
conn = getDBConnection();
RowSet rows = getCompanyList(conn);
if (rows != null && !rows.isEmpty()) {
int dataCount = rows.getSize();
SrvDAO srvDAO = new SrvDAO();
for (int i = 0; i < dataCount; i++) {
Row row = rows.getRow(i);
String orgId = row.getStrValue("ORGANIZATION_ID");
int organizationId = Integer.parseInt(orgId);
taskExecutor = getOUTaskExecutor(conn, organizationId);
if (taskExecutor == null) {
continue;
}
srvDAO.synTransInCompany(conn, taskExecutor);
}
}
} catch (Throwable ex) {
Logger.logError(ex);
throw new DataHandleException(ex.getMessage());
} finally {
closeDBConnection(conn);
}
}
// -----------------------------------------------------------------------------------------
// --getItemCode
public String getItemCodeInESI() throws QueryException, ContainerException {
AmsCabelInfoModel modelClass = (AmsCabelInfoModel) sqlProducer;
SQLModel sqlModel = modelClass.getItemCodeInESIModel();
SimpleQuery sq = new SimpleQuery(sqlModel, conn);
sq.executeQuery();
RowSet rs = sq.getSearchResult();
return rs.getRow(0).getStrValue(0);
}
/** 查询资产地点 */
public void synFaLocation(Connection conn, SfUserDTO user) {
int totalCount = 0;
int count = 0;
long resumeTime = 0;
SynLogDTO logDTO = null;
SynLogUtil logUtil = new SynLogUtil();
long start = System.currentTimeMillis();
try {
logDTO = new SynLogDTO();
logDTO.setSynType(SrvType.SRV_FA_LOCATION);
logDTO.setCreatedBy(user.getUserId());
logDTO.setSynMsg("同步MIS资产地点开始");
logUtil.synLog(logDTO, conn);
SrvAssetLocationSrv service = new SrvAssetLocationSrv();
SrvAssetLocationDTO dtoParameter = new SrvAssetLocationDTO();
SrvAssetLocationDAO srvAssetLocationDAO = new SrvAssetLocationDAO(user, dtoParameter, conn);
service.setLastUpDate(SynUpdateDateUtils.getLastUpdateDate(SrvType.SRV_FA_LOCATION, conn));
SrvProcessModel spm = new SrvProcessModel();
SQLModel sqlModel =
spm.getLocalCodeModel(MIS_CONSTANT.SOURCE_MIS, SinoConfig.getLoc1SetNameMis());
SimpleQuery simp = new SimpleQuery(sqlModel, conn);
simp.executeQuery();
Row row = null;
if (simp.hasResult()) {
RowSet rs = simp.getSearchResult();
for (int i = 0; i < rs.getSize(); i++) {
row = rs.getRow(i);
String cc = row.getStrValue("FLEX_VALUE");
service.setSegment1(cc);
service.excute();
SrvReturnMessage srm = service.getReturnMessage();
if (srm.getErrorFlag().equals("Y")) {
DTOSet ds = service.getDs();
totalCount += ds.getSize();
if (ds.getSize() > 0) {
count += srvAssetLocationDAO.synAssetLocation(ds, cc);
}
}
}
if (totalCount == count) { // 全部成功才更新同步类型日志，以免下次获取不到数据
SynUpdateDateUtils.createLastUpdateDate(SrvType.SRV_FA_LOCATION, conn);
SynUpdateDateUtils.updateLastUpdateDate(SrvType.SRV_FA_LOCATION, conn);
}
}
resumeTime = System.currentTimeMillis() - start;
logDTO = new SynLogDTO();
logDTO.setSynType(SrvType.SRV_FA_LOCATION);
logDTO.setCreatedBy(user.getUserId());
logDTO.setSynMsg(
"同步MIS资产地点结束。同步"
+ totalCount
+ "条记录，成功"
+ count
+ "，失败"
+ (totalCount - count)
+ "，耗时"
+ resumeTime
+ "毫秒");
logUtil.synLog(logDTO, conn);
} catch (Exception e) {
Logger.logError(e);
}
}