导入数据模板下载

czt

2026-01-21 a8296ef06369452e9151624b6ac4e7cb12a394e3

导入数据模板下载

 fzzy-igdss-view/src/main/java/com/fzzy/igds/InoutHand.view.xml

@@ -440,7 +440,7 @@
              <Children>
                <AutoForm>
                  <Property name="dataSet">dsMain</Property>
                  <Property name="cols">*,*,*</Property>
                  <Property name="cols">*,*,*,*</Property>
                  <Property name="labelAlign">right</Property>
                  <Property name="labelSeparator">：</Property>
                  <Property name="labelWidth">100</Property>
@@ -458,10 +458,25 @@
                    <Property name="property">plateNum</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                    <Property name="name">deptId</Property>
                    <Property name="property">deptId</Property>
                    <Property name="readOnly">true</Property>
                    <Editor>
                      <TextEditor>
                        <Property name="blankText">-- 系统自动带入 --</Property>
                      </TextEditor>
                    </Editor>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">depotId</Property>
                    <Property name="property">depotId</Property>
                    <Property name="label">装卸仓库</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">foodVariety</Property>
                    <Property name="property">foodVariety</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
@@ -475,29 +490,8 @@
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">foodVariety</Property>
                    <Property name="property">foodVariety</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">perWet</Property>
                    <Property name="property">perWet</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">userContact</Property>
                    <Property name="property">userContact</Property>
                    <Property name="label">联系电话</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">foodLevel</Property>
                    <Property name="property">foodLevel</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">perImpurity</Property>
                    <Property name="property">perImpurity</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
@@ -513,15 +507,31 @@
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">userContact</Property>
                    <Property name="property">userContact</Property>
                    <Property name="label">联系电话</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="label">客户名称</Property>
                    <Property name="property">customerName</Property>
                    <Property name="editable">false</Property>
                    <Property name="trigger">ddNotice</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                  <AutoFormElement>
                    <Property name="name">noticeId</Property>
                    <Property name="property">noticeId</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">perWet</Property>
                    <Property name="property">perWet</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">perImpurity</Property>
                    <Property name="property">perImpurity</Property>
                    <Editor/>
                  </AutoFormElement>
                </AutoForm>
@@ -533,76 +543,76 @@
              <Children>
                <AutoForm>
                  <Property name="dataSet">dsMain</Property>
                  <Property name="cols">*,50,*,50,*,50</Property>
                  <Property name="cols">*,*,*,*</Property>
                  <Property name="labelAlign">right</Property>
                  <Property name="labelWidth">100</Property>
                  <Property name="labelSeparator">：</Property>
                  <AutoFormElement layoutConstraint="colSpan:2">
                    <ClientEvent name="onBlur">deAutoByWeight();</ClientEvent>
                    <Property name="name">fullWeight</Property>
                    <Property name="property">fullWeight</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                  <AutoFormElement>
                    <Property name="name">fullWeightTime</Property>
                    <Property name="property">fullWeightTime</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                  <AutoFormElement>
                    <Property name="name">fullWeightUser</Property>
                    <Property name="property">fullWeightUser</Property>
                    <Property name="label">满车称重人</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                  <AutoFormElement>
                    <ClientEvent name="onBlur">deAutoByWeight();</ClientEvent>
                    <Property name="name">emptyWeight</Property>
                    <Property name="property">emptyWeight</Property>
                    <Property name="name">fullWeight</Property>
                    <Property name="property">fullWeight</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                    <Property name="name">emptyWeightTime</Property>
                    <Property name="property">emptyWeightTime</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                    <Property name="name">emptyWeightUser</Property>
                    <Property name="property">emptyWeightUser</Property>
                    <Property name="label">空车称重人</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                    <Property name="name">netWeight</Property>
                    <Property name="property">netWeight</Property>
                    <Property name="readOnly">true</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                  <AutoFormElement>
                    <ClientEvent name="onBlur">deAutoByWeight();</ClientEvent>
                    <Property name="name">deOther</Property>
                    <Property name="property">deOther</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                  <AutoFormElement>
                    <Property name="name">emptyWeightTime</Property>
                    <Property name="property">emptyWeightTime</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">emptyWeightUser</Property>
                    <Property name="property">emptyWeightUser</Property>
                    <Property name="label">空车称重人</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <ClientEvent name="onBlur">deAutoByWeight();</ClientEvent>
                    <Property name="name">emptyWeight</Property>
                    <Property name="property">emptyWeight</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">netWeight</Property>
                    <Property name="property">netWeight</Property>
                    <Property name="readOnly">true</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">registerTime</Property>
                    <Property name="property">registerTime</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                  <AutoFormElement>
                    <Property name="name">completeTime</Property>
                    <Property name="property">completeTime</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement>
                    <Property name="name">settleWeight</Property>
                    <Property name="property">settleWeight</Property>
                    <Property name="readOnly">true</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                  <AutoFormElement>
                    <Property name="name">recordWeight</Property>
                    <Property name="property">recordWeight</Property>
                    <Property name="readOnly">true</Property>
                    <Editor/>
                  </AutoFormElement>
                  <AutoFormElement layoutConstraint="colSpan:2">
                    <Property name="name">completeTime</Property>
                    <Property name="property">completeTime</Property>
                    <Editor/>
                  </AutoFormElement>
                </AutoForm>

 fzzy-igdss-view/src/main/java/com/fzzy/igds/InoutList.view.xml

@@ -612,11 +612,20 @@
        </ToolBarButton>
        <ToolBarButton>
          <Property name="caption">导入EXCEL</Property>
          <Property name="exClassName">btn1</Property>
          <Property name="exClassName">btn2</Property>
          <Property name="iconClass">fa fa-file-excel-o</Property>
          <Property name="action">uploadExcel</Property>
          <Property name="width">120</Property>
        </ToolBarButton>
        <ToolBarButton>
          <ClientEvent name="onClick">&#xD;
var url = &quot;/export/download-inout-excel&quot;;&#xD;
window.open(url);&#xD;</ClientEvent>
          <Property name="caption">模板下载</Property>
          <Property name="exClassName">btn1</Property>
          <Property name="iconClass">fa fa-cloud-download</Property>
          <Property name="width">120</Property>
        </ToolBarButton>
      </ToolBar>
      <DataGrid id="dataGridMain" layoutConstraint="padding:8">
        <ClientEvent name="onDataRowClick">view.get(&quot;#dataGridMain&quot;).set(&quot;selection&quot;,arg.data);</ClientEvent>

 fzzy-igdss-web/src/main/java/com/fzzy/common/ExportController.java

@@ -69,6 +69,17 @@
    }

    /**
     * 导出word并下载
     *
     * @param response
     */
    @RequestMapping("/download-inout-excel")
    public void downloadInoutExcel(HttpServletResponse response) {

        exportManager.downloadInoutExcel(response);
    }

    /**
     * PDF在线预览
     *
     * @param response

 fzzy-igdss-web/src/main/java/com/fzzy/common/manager/ExportManager.java

@@ -91,4 +91,23 @@
        }
    }

    /**
     * 渲染模板保存并下载
     *
     * @param response
     */
    public void downloadInoutExcel(HttpServletResponse response) {
        try {

            String savePath = fileService.getFileSavePath("TEMPLATE");
            String templateName = "出入库数据模板.xlsx";

            //下载文档
            WordUtil.download(savePath, templateName, response);

        } catch (Exception e) {
            log.error("下载文件失败", e);
        }
    }

}