Examples with ExSingleTable com.github.qinyou.example.model.ExSingleTable used on opensource projects

Example 1 with ExSingleTable

use of com.github.qinyou.example.model.ExSingleTable in project my_curd by qinyou.

the class ExSingleTableController method importExcel.

/**
 * 导入excel
 */
@Before(Tx.class)
public void importExcel() {
    UploadFile uploadFile = getFile();
    if (uploadFile == null) {
        renderFail("上传文件不可为空");
        return;
    }
    if (!FilenameUtils.getExtension(uploadFile.getFileName()).equals("xls")) {
        FileUtils.deleteFile(uploadFile.getFile());
        renderFail("上传文件后缀必须是xls");
        return;
    }
    List<ExSingleTable> list;
    try {
        ImportParams params = new ImportParams();
        params.setTitleRows(1);
        params.setHeadRows(1);
        list = ExcelImportUtil.importExcel(uploadFile.getFile(), ExSingleTable.class, params);
    } catch (Exception e) {
        log.error(e.getMessage(), e);
        FileUtils.deleteFile(uploadFile.getFile());
        renderFail("模板文件格式错误");
        return;
    }
    for (ExSingleTable exSingleTable : list) {
        System.out.println(exSingleTable);
        System.out.println();
        exSingleTable.setId(IdUtils.id()).setCreater(WebUtils.getSessionUsername(this)).setCreateTime(new Date()).save();
    }
    FileUtils.deleteFile(uploadFile.getFile());
    renderSuccess(IMPORT_SUCCESS);
}

Example 2 with ExSingleTable

use of com.github.qinyou.example.model.ExSingleTable in project my_curd by qinyou.

the class ExSingleTableController method updateAction.

/**
 * 修改 action
 */
public void updateAction() {
    ExSingleTable exSingleTable = getBean(ExSingleTable.class, "");
    exSingleTable.setUpdater(WebUtils.getSessionUsername(this)).setUpdateTime(new Date());
    if (exSingleTable.update()) {
        renderSuccess(UPDATE_SUCCESS);
    } else {
        renderFail(UPDATE_FAIL);
    }
}

Example 3 with ExSingleTable

use of com.github.qinyou.example.model.ExSingleTable in project my_curd by qinyou.

the class ExSingleTableController method exportExcel.

/**
 * 导出excel
 */
@Before(SearchSql.class)
public void exportExcel() {
    String where = getAttr(Constant.SEARCH_SQL);
    if (ExSingleTable.dao.findCountByWhere(where) > 50000) {
        setAttr("msg", "一次导出数据不可大于 5W 条，请修改查询条件。");
        render("common/card.ftl");
        return;
    }
    List<ExSingleTable> list = ExSingleTable.dao.findByWhere(where);
    Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("例子单表结构", "例子单表结构"), ExSingleTable.class, list);
    render(ExcelRender.me(workbook).fileName("例子单表结构.xls"));
}

Example 4 with ExSingleTable

use of com.github.qinyou.example.model.ExSingleTable in project my_curd by qinyou.

the class ExSingleTableController method newModel.

/**
 * 打开新增或者修改弹出框
 */
public void newModel() {
    String id = getPara("id");
    if (StringUtils.notEmpty(id)) {
        ExSingleTable exSingleTable = ExSingleTable.dao.findById(id);
        setAttr("exSingleTable", exSingleTable);
    }
    render("example/exSingleTable_form.ftl");
}

Example 5 with ExSingleTable

use of com.github.qinyou.example.model.ExSingleTable in project my_curd by qinyou.

the class ExSingleTableController method addAction.

/**
 * 新增 action
 */
public void addAction() {
    ExSingleTable exSingleTable = getBean(ExSingleTable.class, "");
    exSingleTable.setId(IdUtils.id()).setCreater(WebUtils.getSessionUsername(this)).setCreateTime(new Date());
    if (exSingleTable.save()) {
        renderSuccess(ADD_SUCCESS);
    } else {
        renderFail(ADD_FAIL);
    }
}