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

260
export default OracleTable;