NBDXSY/LeaRun.Application/LeaRun.Application.Web/Areas/SystemManage/Views/DataBaseLink/Form.cshtml

@{
    ViewBag.Title = "库连接管理";
    Layout = "~/Views/Shared/_Form.cshtml";
}
<script>
    var keyValue = request('keyValue');
    $(function () {
        initControl();
    })
    //初始化控件
    function initControl() {
        //库类型
        var $dbtype = $("#DbType")
        $dbtype.ComboBox({
            url: "../../SystemManage/DataItemDetail/GetDataItemListJson",
            param: { EnCode: "DbType" },
            id: "ItemValue",
            text: "ItemName",
            height: "200px",
            description: "==请选择=="
        });
        $dbtype.bind("change", function () {
            var value = $(this).attr('data-value');
            $("#Version").ComboBox({
                url: "../../SystemManage/DataItemDetail/GetSubDataItemListJson",
                param: { EnCode: "DbVersion", ItemValue: value },
                id: "ItemValue",
                text: "ItemName",
                height: "200px",
                description: "==请选择=="
            });
        });
        //库版本
        $("#Version").ComboBox({
            description: "==请选择=="
        });
        //获取表单
        if (!!keyValue) {
            $.SetForm({
                url: "../../SystemManage/DataBaseLink/GetFormJson",
                param: { keyValue: keyValue },
                success: function (data) {
                    $("#form1").SetWebControls(data);
                    $('#DbType').trigger("change");
                    $("#Version").ComboBoxSetValue(data.Version);
                }
            });
        }
    }
    //测试连接
    function btn_TestConnection() {
        learun.saveForm({
            url: "../../SystemManage/DataBaseLink/TestConnection",
            param: { F_DatabaseLinkId: keyValue, F_DbType: $("#F_DbType").attr('data-value'), F_DbConnection: $("#F_DbConnection").val() },
            close: false
        });
    }
    //保存表单
    function AcceptClick() {
        if (!$('#form1').Validform()) {
            return false;
        }
        var postData = $("#form1").GetWebControls(keyValue);
        $.SaveForm({
            url: "../../SystemManage/DataBaseLink/SaveForm?keyValue=" + keyValue,
            param: postData,
            loading: "正在保存数据...",
            success: function () {
                $.currentIframe().$("#gridTable").trigger("reloadGrid");
            }
        })
    }
</script>
<div style="margin-top: 20px; margin-right: 30px;">
    <table class="form">
        <tr>
            <th class="formTitle">库类型<font face="宋体">*</font></th>
            <td class="formValue">
                <div id="DbType" type="select" class="ui-select" isvalid="yes" checkexpession="NotNull"></div>
            </td>
        </tr>
        <tr>
            <th class="formTitle">库版本<font face="宋体">*</font></th>
            <td class="formValue">
                <div id="Version" type="select" class="ui-select" isvalid="yes" checkexpession="NotNull"></div>
            </td>
        </tr>
        <tr>
            <th class="formTitle">库名称<font face="宋体">*</font></th>
            <td class="formValue">
                <input id="DBName" type="text" class="form-control" placeholder="请输入名称" isvalid="yes" checkexpession="NotNull" />
            </td>
        </tr>
        <tr>
            <th class="formTitle">库别名<font face="宋体">*</font></th>
            <td class="formValue">
                <input id="DBAlias" type="text" class="form-control" placeholder="请输入别名" isvalid="yes" checkexpession="NotNull" />
            </td>
        </tr>
        <tr>
            <th class="formTitle">连接地址<font face="宋体">*</font></th>
            <td class="formValue">
                <input id="DbConnection" type="text" class="form-control" style="float: left; width: 311px" isvalid="yes" checkexpession="NotNull" />
                @*<div class="control-button" title="点击测试连接" onclick="btn_TestConnection()">
                    测试连接
                </div>*@
            </td>
        </tr>
        <tr>
            <th class="formTitle">备注
            </th>
            <td class="formValue">
                <textarea id="Description" class="form-control" style="height: 70px;"></textarea>
            </td>
        </tr>
    </table>
</div>