SQLServerTable.jsx 6.38 KB
Newer Older
1
import React, { useEffect, useState } from 'react';
2 3
// import ProTable from '@ant-design/pro-table';
import { Button, Popconfirm, notification, Table } from 'antd';
4
import { GetConnString, DeleteConnString, GetConnTest } from '@/services/database/api';
5
import AddModal from './AddModal';
6 7 8 9 10 11 12 13 14 15
const SQLServerTable = props => {
  const [flag, setFlag] = useState(1);
  const [dataList, setDataList] = useState([]); // table数据
  const [visible, setVisible] = useState(false); // 弹窗
  const [tableLoading, setTableLoading] = useState(false); // tableLoading
  const [type, setType] = useState('add'); // 弹窗类型
  const [formObj, setFormObj] = useState({});

  useEffect(() => {
    setTableLoading(true);
16 17 18 19 20 21 22 23 24 25 26 27 28
    // getSQLServerConnString({
    //   _version: 9999,
    //   _dc: Date.now(),
    // })
    //   .then(res => {
    //     setTableLoading(false);
    //     if (res) {
    //       setDataList(res);
    //     }
    //   })
    //   .catch(err => {
    //     setTableLoading(false);
    //   });
29 30 31 32
    GetConnString({
      Type: 'SQLServer',
    })
      .then(resnew => {
33
        setTableLoading(false);
34
        if (resnew.code == 0) {
35
          let res = resnew.data;
36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
          setDataList(res);
        }
      })
      .catch(err => {
        setTableLoading(false);
      });
  }, [flag]);
  // 新增
  const handleAdd = (val, item) => {
    setType('add');
    setVisible(true);
  };
  // 测试连接
  const handleCon = (val, item) => {
    setTableLoading(true);
51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75
    // getSQLServerConnectionTest({
    //   name: item.name,
    //   _version: 9999,
    //   _dc: Date.now(),
    // })
    //   .then(res => {
    //     setTableLoading(false);
    //     if (res.success) {
    //       notification.success({
    //         message: '提示',
    //         description: '连接成功',
    //         duration: 3,
    //       });
    //     } else {
    //       notification.error({
    //         message: '提示',
    //         description: res.message || '连接失败',
    //         duration: 3,
    //       });
    //     }
    //   })
    //   .catch(err => {
    //     setTableLoading(false);
    //     console.error(err);
    //   });
76 77 78 79 80
    GetConnTest({
      Type: 'SQLServer',
      name: item.name,
    })
      .then(res => {
81
        setTableLoading(false);
82
        if (res.code == 0) {
83
          notification.success({
Maofei94's avatar
Maofei94 committed
84
            message: '提示',
85
            description: '连接成功',
86 87 88 89
            duration: 3,
          });
        } else {
          notification.error({
Maofei94's avatar
Maofei94 committed
90
            message: '提示',
91
            description: res.msg || '连接失败',
92 93 94 95 96 97 98 99 100 101 102 103
            duration: 3,
          });
        }
      })
      .catch(err => {
        setTableLoading(false);
        console.error(err);
      });
  };
  // 删除
  const handleDel = (val, item) => {
    const { name = '' } = item;
104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125
    // deleteConnString({
    //   name,
    //   _version: 9999,
    //   _dc: Date.now(),
    // })
    //   .then(res => {
    //     setFlag(flag + 1);
    //     if (res.success) {
    //       notification.success({
    //         message: '提示',
    //         duration: 3,
    //         description: res.message || '删除成功',
    //       });
    //     } else {
    //       notification.error({
    //         message: '提示',
    //         duration: 3,
    //         description: res.message || '删除失败',
    //       });
    //     }
    //   })
    //   .catch(err => console.error(err));
126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143
    DeleteConnString({
      name,
    }).then(res => {
      setFlag(flag + 1);
      if (res.code == 0) {
        notification.success({
          message: '提示',
          duration: 3,
          description: res.msg || '删除成功',
        });
      } else {
        notification.error({
          message: '提示',
          duration: 3,
          description: res.msg || '删除失败',
        });
      }
    });
144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159
  };
  // 编辑
  const handleEdit = (val, item) => {
    setType('edit');
    setFormObj(item);
    setVisible(true);
  };
  const onSubmit = prop => {
    setVisible(false);
    setFlag(flag + 1);
  };
  const columns = [
    {
      title: '标签',
      dataIndex: 'name',
      key: 'name',
Maofei94's avatar
Maofei94 committed
160
      ellipsis: true,
161 162 163 164 165
    },
    {
      title: 'ip',
      dataIndex: 'ip',
      key: 'ip',
Maofei94's avatar
Maofei94 committed
166
      ellipsis: true,
167 168 169 170 171
    },
    {
      title: '数据库名',
      dataIndex: 'dbName',
      key: 'dbName',
Maofei94's avatar
Maofei94 committed
172
      ellipsis: true,
173 174 175 176 177
    },
    {
      title: '用户名',
      dataIndex: 'userName',
      key: 'userName',
Maofei94's avatar
Maofei94 committed
178
      ellipsis: true,
179
    },
180 181 182 183 184 185 186
    // {
    //   title: '密码',
    //   dataIndex: 'password',
    //   key: 'password',
    //   // width: 200,
    //   ellipsis: true,
    // },
187 188 189 190 191
    {
      title: '操作',
      dataIndex: 'options',
      key: 'options',
      render: (val, item) => [
192
        <Button size="small" type="primary" onClick={() => handleCon(val, item)} key="testLink">
193
          测试连接
Maofei94's avatar
Maofei94 committed
194 195 196 197 198 199 200 201
        </Button>,
        <Button
          style={{
            margin: '0 10px',
            backgroundColor: '#fffbe6',
            color: '#faad14',
            borderColor: '#ffe58f',
          }}
202
          key="bntEdit"
Maofei94's avatar
Maofei94 committed
203 204 205
          size="small"
          onClick={() => handleEdit(val, item)}
        >
206
          编辑
Maofei94's avatar
Maofei94 committed
207
        </Button>,
208
        <Popconfirm
209
          key="btnDelete"
210 211 212 213 214 215
          title={`是否删除连接${item.name}`}
          cancelText="取消"
          okText="确认"
          // placement="right"
          onConfirm={() => handleDel(val, item)}
        >
Maofei94's avatar
Maofei94 committed
216 217 218
          <Button size="small" danger>
            删除
          </Button>
219 220 221 222 223 224
        </Popconfirm>,
      ],
    },
  ];
  return (
    <>
225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241
      <div style={{ display: 'flex', justifyContent: 'space-between', marginBottom: '10px' }}>
        <div
          style={{ fontWeight: 'bold', fontSize: '16px', marginLeft: '30x', marginBottom: '10px' }}
        >
          SQL数据库
        </div>
        <Button
          type="primary"
          onClick={() => {
            handleAdd();
          }}
        >
          添加连接
        </Button>
      </div>
      <Table
        // title="SQL数据库"
242
        rowKey="name"
243 244 245 246
        columns={columns}
        bordered
        loading={tableLoading}
        dataSource={dataList}
247
        scroll={{ x: 'max-content', y: '400px' }}
248 249 250 251 252 253 254 255 256 257 258 259 260
      />
      <AddModal
        visible={visible}
        onCancel={() => setVisible(false)}
        callBackSubmit={onSubmit}
        type={type}
        formObj={formObj}
      />
    </>
  );
};

export default SQLServerTable;