From 3140b58a56be4b1693766121dacb83fe6f6f21df Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 26 九月 2023 14:48:30 +0800
Subject: [PATCH] 2023-09-26

---
 src/menu/components/table/base-table/index.jsx |   15 +++++++++++++--
 1 files changed, 13 insertions(+), 2 deletions(-)

diff --git a/src/menu/components/table/base-table/index.jsx b/src/menu/components/table/base-table/index.jsx
index 653881d..95759e2 100644
--- a/src/menu/components/table/base-table/index.jsx
+++ b/src/menu/components/table/base-table/index.jsx
@@ -259,12 +259,23 @@
     config.cols.forEach(col => {
       if (!col.field) return
       if (['text', 'picture', 'video', 'textarea'].includes(col.type)) {
+        let datatype = `Nvarchar(${col.fieldlength || 50})`
+        let type = 'text'
+
+        if (col.type === 'text') {
+          if (col.textFormat === 'YYYY-MM-DD') {
+            datatype = 'date'
+          } else if (col.textFormat === 'YYYY-MM-DD HH:mm:ss') {
+            datatype = 'datetime'
+          }
+        }
+
         config.columns.push({
-          datatype: `Nvarchar(${col.fieldlength || 50})`,
+          datatype: datatype,
           field: col.field,
           fieldlength: col.fieldlength || 50,
           label: col.label,
-          type: 'text',
+          type: type,
           uuid: col.uuid
         })
       } else if (col.type === 'link') {

--
Gitblit v1.8.0