iflyket/web/html/vue/auto.js

$(document).ready(function(){
    databaseSelect();

    $("#iTableAdd").dialog({
        modal: true,
        autoOpen:false,
        closeable:false,
        bgiframe:true,
        height:400,
        width:800,
        closeOnEscape:false,
        draggable:false,
        resizable:false,
        title:"表信息",
        open:function (event, ui) {
            $(".ui-dialog-titlebar-close").hide();
        },
        buttons:{
            "执行":function () {
                if(!confirm("如果表存在则会清空数据  是否继续？")){
                    return;
                }
                $.ajax({
                    url:""+baseConfig.URL.autoCreateTable,
                    type:"POST",
                    data:$("#iTableAddForm").serialize(),
                    dataType:"json",
                    success:function (data) {
                        if (data.status == 'SUCCESS') {
                            alert("表数据已经更新");
                            $("#iTableAdd").dialog("close");
                            tableSelect
                        }else{
                            alert("执行失败！！");
                        }
                    },
                    complete:function (XHR, TS) {
                        // $('.ui-dialog-buttonpane').find('button:contains("保存添加信息")').removeAttr("disabled");
                    },
                    error:function (XMLHttpRequest, textStatus, errorThrown) {
                        alert(textStatus);
                    }
                });

            },
            "关闭":function () {
                $(this).dialog("close");
            }
        }
    })
});
function databaseSelect(){
    $("#database_select").html('');
    $.ajax({
        url:""+baseConfig.URL.autoInit,
        data:{},
        success:function (data) {
            if(data.status=="SUCCESS"){
                $.each(data.databaseList,function (index,item) {
                    $("#database_select").append('<option value="'+index+'">'+item.key+'</option>');
                });
            }
        }
    });
}
function isConnection(){
    $.ajax({
        url:""+baseConfig.URL.autoIsConnection,
        data:{"database":""+$("#database_select").val()},
        success:function (data) {
            if(data.status=="SUCCESS"){
                alert("测试连接成功");
                $("#columnTable").html('');
                tableSelect();
            }else {
                alert("测试连接失败");
            }
        }
    });
}
function tableSelect(){
    $("#table_select").html('');
    $.ajax({
        url:""+baseConfig.URL.autoTableList,
        data:{"database":""+$("#database_select").val()},
        success:function (data) {
            if(data.status=="SUCCESS"){
                $.each(data.list,function (index,item) {
                    $("#table_select").append('<option value="'+item.table_name+'">'+item.table_name+'</option>');
                });
            }
        }
    });
}
function showColumn(){
    $("#columnTable").html('');
    $.ajax({
        url:""+baseConfig.URL.autoColumnList,
        data:{"database":""+$("#database_select").val(),"tableName":""+$("#table_select").val()},
        success:function (data) {
            if(data.status=="SUCCESS"){
                $.each(data.list,function (index,item) {
                    $("#columnTable").append('<tr>' +
                        '<td>'+item.Field+'</td>' +
                        '<td>'+item.Type+'</td>' +
                        '<td>'+item.Null+'</td>' +
                        '<td>'+item.Key+'</td>' +
                        '</tr>');
                });
            }
        }
    });
}
function toAddTable() {
    $("#iTableAddName").val($("#table_select").val());
    $("#iTableColumnTable").html('');

    $.ajax({
        url:""+baseConfig.URL.autoColumnList,
        data:{"database":""+$("#database_select").val(),"tableName":""+$("#table_select").val()},
        success:function (data) {
            if(data.status=="SUCCESS"){
                $.each(data.list,function (index,item) {
                    // $("#iTableColumnTable").append('<tr>' +
                    //     '<td>'+item.Field+'</td>' +
                    //     '<td>'+item.Type+'</td>' +
                    //     '<td>'+item.Null+'</td>' +
                    //     '<td>'+item.Key+'</td>' +
                    //     '</tr>');
                    var isnull=false;
                    var iskey=false;
                    if(item.Null=="NO")isnull=true;
                    if(item.Key=="PRI")iskey=true;

                    toAddNewRow(item.Field,item.Type,isnull,iskey)
                });
                $("#iTableAdd").dialog("open");
            }
        }
    });
}
function  toAddNewRow(fieldName,fieldType,IsNull,IdKey) {
    var index=$("#iTableColumnTable tr").length;

    $("#iTableColumnTable").append('<tr>' +
        '<td>' +
        '<input name="columnName" value="'+fieldName+'"/>' +
        '<input name="columnId" type="hidden" value="'+index+'" />' +
        '</td>' +
        '<td>' +
        '<input name="columnType" value="'+fieldType+'"/>' +
        '</td>' +
        '<td>' +
        '<input name="columnNull" type="checkbox" value="'+index+'" class="regular-checkbox" id="checkbox_1_'+index+'"/>' +
        '<label for="checkbox_1_'+index+'"></label>' +
        '</td>' +
        '<td>' +
        '<input name="columnKey" type="checkbox" value="'+index+'" class="regular-checkbox"  id="checkbox_2_'+index+'"/>' +
        '<label for="checkbox_2_'+index+'"></label>' +
        '</td>' +
        '</tr>');

    if(IsNull){
        $("#checkbox_1_"+index).attr("checked","true");
    }
    if(IdKey){
        $("#checkbox_2_"+index).attr("checked","true");
    }
}
function createModel(){
    $.ajax({
        url:""+baseConfig.URL.autoCreateModel,
        data:{"database":""+$("#database_select").val()
            ,"modelName":""+$("#modelName").val()
            ,"tableName":""+$("#table_select").val()},
        success:function (data) {
            if(data.status=="SUCCESS"){
                alert("实体/控制类创建完成");
            }
        }
    });
}
function createText(){
    $.ajax({
        url:""+baseConfig.URL.autoCreateText,
        data:{"database":""+$("#database_select").val()
            ,"modelName":""+$("#modelName").val()
            ,"tableName":""+$("#table_select").val()},
        success:function (data) {
            if(data.status=="SUCCESS"){
                alert("配置信息创建完成");
            }
        }
    });
}
function createHtml(){
    $.ajax({
        url:""+baseConfig.URL.autoCreateHtml,
        data:{"database":""+$("#database_select").val()
            ,"tableName":""+$("#table_select").val()
            ,"modelName":""+$("#modelName").val()
        },
        success:function (data) {
            if(data.status=="SUCCESS"){
                alert("Html/Js创建完成");
            }
        }
    });
}
function autoCreate() {
    createModel();
    createText();
    createHtml();
}
function downloadFile(){
    $("#iTableForm").attr("action",baseConfig.URL.autoDownLoadZip);
    $('#iTableForm').submit();
}
function clearFile(){
    $.ajax({
        url:""+baseConfig.URL.autoClearFile,
        data:{},
        success:function (data) {
            if(data.status=="SUCCESS"){
                alert("完成");
            }
        }
    });
}