OracleTable.jsx 6.28 KB
Newer Older
1
import React, { useEffect, useState } from 'react';
2 3
// import ProTable from '@ant-design/pro-table';
import { Button, Tag, Popconfirm, notification, Table } from 'antd';
4
import {
5 6
  getOracleConnString,
  getOracleConnectionTest,
7
  deleteConnString,
8 9
  GetConnString,
  DeleteConnString,
10
  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
    // getOracleConnString({
    //   _version: 9999,
    //   _dc: Date.now(),
    // })
    //   .then(res => {
    //     setTableLoading(false);
    //     if (res) {
    //       setDataList(res);
    //     }
    //   })
    //   .catch(err => {
    //     setTableLoading(false);
    //   });
36 37 38 39
    GetConnString({
      Type: 'Oracle',
    })
      .then(resnew => {
40
        setTableLoading(false);
41
        if (resnew.code == 0) {
42
          let res = resnew.data;
43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
          setDataList(res);
        }
      })
      .catch(err => {
        setTableLoading(false);
      });
  }, [flag]);
  // 新增
  const handleAdd = (val, item) => {
    setType('add');
    setVisible(true);
  };
  // 测试连接
  const handleCon = (val, item) => {
    setTableLoading(true);
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
    // 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);
    //   });
83 84 85 86 87
    GetConnTest({
      Type: 'Oracle',
      name: item.name,
    })
      .then(res => {
88
        setTableLoading(false);
89
        if (res.code == 0) {
90
          notification.success({
Maofei94's avatar
Maofei94 committed
91 92
            message: '提示',
            description: '连接成功',
93 94 95 96
            duration: 3,
          });
        } else {
          notification.error({
Maofei94's avatar
Maofei94 committed
97
            message: '提示',
98
            description: res.msg || '连接失败',
99 100 101 102 103 104 105 106 107 108 109 110
            duration: 3,
          });
        }
      })
      .catch(err => {
        setTableLoading(false);
        console.error(err);
      });
  };
  // 删除
  const handleDel = (val, item) => {
    const { name = '' } = item;
111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132
    // 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));
133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150
    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 || '删除失败',
        });
      }
    });
151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167
  };
  // 编辑
  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
168
      ellipsis: true,
169 170
    },
    {
171
      title: '网络服务名/(ip:port/实例名)',
172 173
      dataIndex: 'dbName',
      key: 'dbName',
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 186 187
    // {
    //   title: '密码',
    //   dataIndex: 'password',
    //   key: 'password',
    //   ellipsis: true,
    // },
188 189 190 191 192
    {
      title: '操作',
      dataIndex: 'options',
      key: 'options',
      render: (val, item) => [
193
        <Button size="small" type="primary" onClick={() => handleCon(val, item)}>
194
          测试连接
Maofei94's avatar
Maofei94 committed
195 196 197 198 199 200 201 202 203 204 205
        </Button>,
        <Button
          style={{
            margin: '0 10px',
            backgroundColor: '#fffbe6',
            color: '#faad14',
            borderColor: '#ffe58f',
          }}
          size="small"
          onClick={() => handleEdit(val, item)}
        >
206
          编辑
Maofei94's avatar
Maofei94 committed
207
        </Button>,
208 209 210 211 212 213 214
        <Popconfirm
          title={`是否删除连接${item.name}`}
          cancelText="取消"
          okText="确认"
          // placement="right"
          onConfirm={() => handleDel(val, item)}
        >
Maofei94's avatar
Maofei94 committed
215 216 217
          <Button size="small" danger>
            删除
          </Button>
218 219 220 221 222 223
        </Popconfirm>,
      ],
    },
  ];
  return (
    <>
224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239
      <div style={{ display: 'flex', justifyContent: 'space-between', marginBottom: '10px' }}>
        <div
          style={{ fontWeight: 'bold', fontSize: '16px', marginLeft: '30x', marginBottom: '10px' }}
        >
          Oracle数据库
        </div>
        <Button
          type="primary"
          onClick={() => {
            handleAdd();
          }}
        >
          添加连接
        </Button>
      </div>
      <Table
240 241 242 243 244
        rowKey="key"
        columns={columns}
        bordered
        loading={tableLoading}
        dataSource={dataList}
245
        scroll={{ x: 'max-content', y: '400px' }}
246 247 248 249 250 251 252 253 254 255 256 257
      />
      <AddModal
        visible={visible}
        onCancel={() => setVisible(false)}
        callBackSubmit={onSubmit}
        type={type}
        formObj={formObj}
      />
    </>
  );
};

258
export default OracleTable;