YLShipBuildLandMap/YLShipBuildLandMap.Web/wwwroot/app/main/systemsetting/execsql/index.html

<div class="header"></div>
<div class="body">
    <div class="dj-formtable">
        验证码：<input type="password" ng-model="vercode"/>
    </div>
    <div panel-title data-title="'select'"></div>
    <div class="dj-formtable">
        <table class="dj-table">
            <tr>
                <td>
                    <textarea name="selectSql" ng-model="selectSql" class="form-control" rows="5" />
                </td>
            </tr>
        </table>
        <div class="form_foot">
            <button type="submit"
                    class="btn btn-primary"
                    ng-click="execSelectSql()">
                执行select
            </button>
        </div>
    </div>
    <span style="color:red">{{selectMsg}}</span>
    <div class="table-responsive list-table-panel table-adapt">
        <table class="gt-table gt-table-bordered gt-table-evenodd table-text-clip">
            <thead>
                <tr>
                    <td style="height: 50px; border: 1px solid #eee;">序号</td>
                    <td ng-repeat="it in selectColumnList" style="border: 1px solid #eee;">
                        {{it}}
                    </td>
                </tr>
            </thead>
            <tbody>
                <tr ng-repeat="it in selectResult" fixed-table-header max-height="300">
                    <td>{{$index+1}}</td>
                    <td ng-repeat="colname in selectColumnList">
                        {{it[colname]}}
                    </td>
                </tr>
                <tr ng-if="selectResult.length==0" ng-repeat="it in [1]" fixed-table-header>
                    <td colspan="15" style="text-align:center">暂无数据</td>
                </tr>
            </tbody>
        </table>
    </div>
    <div panel-title data-title="'insert'"></div>
    <div class="dj-formtable">
        <table class="dj-table">
            <tr>
                <td>
                    <textarea name="insertSql" ng-model="insertSql" class="form-control" rows="5" />
                </td>
            </tr>
        </table>
        <div class="form_foot">
            <button type="submit"
                    class="btn btn-primary"
                    ng-click="execInsertSql()">
                执行insert
            </button>
        </div>
        <span style="color:red">{{insertMsg}}</span>
    </div>
    <div panel-title data-title="'update'"></div>
    <div class="dj-formtable">
        <table class="dj-table">
            <tr>
                <td>
                    <textarea name="updateSql" ng-model="updateSql" class="form-control" rows="5" />
                </td>
            </tr>
        </table>
        <div class="form_foot">
            <button type="submit"
                    class="btn btn-primary"
                    ng-click="execUpdateSql()">
                执行update
            </button>
        </div>
        <span style="color:red">{{updateMsg}}</span>
    </div>
    <div panel-title data-title="'delete'"></div>
    <div class="dj-formtable">
        <table class="dj-table">
            <tr>
                <td>
                    <textarea name="deleteSql" ng-model="deleteSql" class="form-control" rows="5" />
                </td>
            </tr>
        </table>
        <div class="form_foot">
            <button type="submit"
                    class="btn btn-primary"
                    ng-click="execDeleteSql()">
                执行delete
            </button>
        </div>
        <span style="color:red">{{deleteMsg}}</span>
    </div>
</div>
<style>
    body {
        overflow: auto !important;
    }

    textarea {
        font-size: 16px !important;
    }
</style>