Search in sources :

Example 1 with SysSetting

use of com.github.qinyou.system.model.SysSetting in project my_curd by qinyou.

the class SysSettingController method updateAction.

/**
 * 修改 action
 */
public void updateAction() {
    SysSetting sysSetting = getBean(SysSetting.class, "");
    sysSetting.setUpdater(WebUtils.getSessionUsername(this)).setUpdateTime(new Date());
    if (sysSetting.update()) {
        refreshSetting();
        renderSuccess(UPDATE_SUCCESS);
    } else {
        renderFail(UPDATE_FAIL);
    }
}
Also used : SysSetting(com.github.qinyou.system.model.SysSetting) Date(java.util.Date)

Example 2 with SysSetting

use of com.github.qinyou.system.model.SysSetting in project my_curd by qinyou.

the class SysSettingController method newModel.

/**
 * 打开新增或者修改弹出框
 */
public void newModel() {
    String id = getPara("id");
    if (StringUtils.notEmpty(id)) {
        SysSetting sysSetting = SysSetting.dao.findById(id);
        setAttr("sysSetting", sysSetting);
    }
    render("system/sysSetting_form.ftl");
}
Also used : SysSetting(com.github.qinyou.system.model.SysSetting)

Example 3 with SysSetting

use of com.github.qinyou.system.model.SysSetting in project my_curd by qinyou.

the class SysSettingController method exportExcel.

/**
 * 导出excel
 */
@Before(SearchSql.class)
public void exportExcel() {
    String where = getAttr(Constant.SEARCH_SQL);
    if (SysSetting.dao.findCountByWhere(where) > 50000) {
        setAttr("msg", "一次导出数据不可大于 5W 条,请修改查询条件。");
        render("common/card.ftl");
        return;
    }
    List<SysSetting> list = SysSetting.dao.findByWhere(where);
    Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("系统设置项", "系统设置项"), SysSetting.class, list);
    render(ExcelRender.me(workbook).fileName("系统设置项.xls"));
}
Also used : ExportParams(cn.afterturn.easypoi.excel.entity.ExportParams) SysSetting(com.github.qinyou.system.model.SysSetting) Workbook(org.apache.poi.ss.usermodel.Workbook) Before(com.jfinal.aop.Before)

Example 4 with SysSetting

use of com.github.qinyou.system.model.SysSetting in project my_curd by qinyou.

the class SysSettingController method addAction.

/**
 * 新增 action
 */
public void addAction() {
    SysSetting sysSetting = getBean(SysSetting.class, "");
    sysSetting.setId(IdUtils.id()).setUpdater(WebUtils.getSessionUsername(this)).setUpdateTime(new Date());
    if (sysSetting.save()) {
        refreshSetting();
        renderSuccess(ADD_SUCCESS);
    } else {
        renderFail(ADD_FAIL);
    }
}
Also used : SysSetting(com.github.qinyou.system.model.SysSetting) Date(java.util.Date)

Example 5 with SysSetting

use of com.github.qinyou.system.model.SysSetting in project my_curd by qinyou.

the class SysSettingController 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<SysSetting> list;
    try {
        ImportParams params = new ImportParams();
        params.setTitleRows(1);
        params.setHeadRows(1);
        list = ExcelImportUtil.importExcel(uploadFile.getFile(), SysSetting.class, params);
    } catch (Exception e) {
        log.error(e.getMessage(), e);
        FileUtils.deleteFile(uploadFile.getFile());
        renderFail("模板文件格式错误");
        return;
    }
    for (SysSetting sysSetting : list) {
        sysSetting.setId(IdUtils.id()).setUpdater(WebUtils.getSessionUsername(this)).setUpdateTime(new Date()).save();
    }
    FileUtils.deleteFile(uploadFile.getFile());
    refreshSetting();
    renderSuccess(IMPORT_SUCCESS);
}
Also used : UploadFile(com.jfinal.upload.UploadFile) SysSetting(com.github.qinyou.system.model.SysSetting) ImportParams(cn.afterturn.easypoi.excel.entity.ImportParams) Date(java.util.Date) Before(com.jfinal.aop.Before)

Aggregations

SysSetting (com.github.qinyou.system.model.SysSetting)5 Date (java.util.Date)3 Before (com.jfinal.aop.Before)2 ExportParams (cn.afterturn.easypoi.excel.entity.ExportParams)1 ImportParams (cn.afterturn.easypoi.excel.entity.ImportParams)1 UploadFile (com.jfinal.upload.UploadFile)1 Workbook (org.apache.poi.ss.usermodel.Workbook)1