123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235 |
- <!DOCTYPE html>
- <html xmlns="http://www.w3.org/1999/xhtml" ng-app="app">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no" />
- <title>工资1</title>
- <link href="../../AFrontEnd/css/animate.css" rel="stylesheet" />
- <link href="../../AFrontEnd/css/fontawesome/css/font-awesome.css" rel="stylesheet" />
- <link href="../../AFrontEnd/css/bootstrap.css" rel="stylesheet" />
- <link href="../../AFrontEnd/css/style.css" rel="stylesheet" />
- <script>document.write("<link href='../../AFrontEnd/css/special.css?time=" + new Date().getTime() + "' rel='stylesheet'>");</script>
- <link href="js/mintui.css" rel="stylesheet" />
- <link href="js/table.css" rel="stylesheet" />
- <style>
- .table-body-left::-webkit-scrollbar {
- width: 0;
- height: 0;
- }
- .Btn {
- float: left;
- min-width: 80px;
- height: 34px;
- overflow: hidden;
- white-space: nowrap;
- text-overflow: ellipsis;
- line-height: 18px;
- padding: 7px 0;
- margin: 0 10px;
- text-align: center;
- border: 1px solid blue;
- }
- .activeBtn {
- color:white;
- background:blue;
- }
- .activeBtn:hover {
- color: white;
- }
- </style>
- </head>
- <body>
- <div ng-controller="listCtrl as ctl" ng-cloak>
- <div class="loading" ng-if="ctl.loading">
- <div class="loading-msg">
- <h3>数据加载中,请等待</h3>
- <div class="spinner">
- <div class="bounce1"></div>
- <div class="bounce2"></div>
- <div class="bounce3"></div>
- </div>
- </div>
- </div>
- <div class="wrapper wrapper-content">
- <div class="row">
- <div class="col-md-12">
- <div class="ibox float-e-margins">
- <div class="ibox-content">
- <div class="row">
- <div class="sp-page">
- <a class="Btn activeBtn">工资1</a>
- <a class="Btn" href="list2.html">工资2</a>
- </div>
- <div class="col-md-12">
- <div class="sp-page-tab sp-pl-30">
- <span ng-class="{'pageTabActive':ctl.tablename=='SX_TFNZZGZB'}">在职</span>
- <a class="sp-pull-right sp-btn-gray sp-btn-radius" ng-click="ctl.getData()">
- <i class="fa fa-search sp-mr-5"></i>查 询
- </a>
- <a class="sp-pull-right sp-btn-gray sp-btn-radius" ng-click="ctl.btnDelete()">
- <i class="fa fa-trash sp-mr-5"></i>删 除
- </a>
- <a class="sp-pull-right sp-btn-gray sp-btn-radius" ng-click="ctl.printIn()">
- <i class="fa fa-sign-in sp-mr-5"></i>导 入
- </a>
- <a class="sp-pull-right sp-btn-gray sp-btn-radius" onclick="$(' #xlfile').trigger('click');">
- <i class="fa fa-book sp-mr-5"></i>浏 览
- </a>
- <a class="sp-pull-right sp-ml-5 sp-mr-5 sp-color-blue" style="line-height: 32px" download="导入模板-统发内在职.xlsx" href="moban1.xlsx"> 模板下载</a>
- <div class="sp-page-col sp-pull-right sp-ml-5" style="width:200px;height:32px;overflow:hidden">
- <input type="text" class="sp-input" readonly ng-model="ctl.uploadFile" placeholder="未选择任何文件" />
- <input type="file" name="xlfile" id="xlfile" />
- <input type="checkbox" style="display:none" name="useworker" checked>
- <input type="checkbox" style="display:none" name="userabs" checked>
- <p id="out" style="display:none;"></p>
- </div>
- <input type="text" class="sp-input sp-pull-right laydate-logo" style="width:200px" sp-laydate laytype="month" ng-model="ctl.date" ng-change="ctl.changeDate()" />
- </div>
- </div>
- <div class="sp-page table-head-left" style="width: 501px; overflow: hidden; position: relative; z-index: 1; ">
- <table class="sp-table">
- <thead>
- <tr>
- <th><div style="width:35px"><input type="checkbox" ng-model="ctl.checkedAll" ng-click="ctl.checkAll()" /></div></th>
- <th><div style="width:36px">序号</div></th>
- <th ng-repeat="item in ctl.thead_left"><div style="width: 88px" ng-bind="item.cname"></div></th>
- </tr>
- </thead>
- </table>
- </div>
- <div class="sp-page table-head-right" style="width: calc(100% - 516px); height: 34px; overflow: hidden; position: relative; z-index: 1; ">
- <table class="sp-table">
- <thead>
- <tr>
- <th ng-repeat="item in ctl.thead_right"><div style="min-width: 188px;height:22px" ng-bind="item.cname"></div></th>
- </tr>
- </thead>
- <tbody>
- <tr ng-repeat="item in ctl.list">
- <td ng-repeat="item1 in ctl.thead">
- <div>
- <div style="overflow:hidden;white-space:nowrap;text-overflow:ellipsis" ng-repeat="item2 in item[item1.PKID]" title="{{item2}}" ng-bind="item2"></div>
- </div>
- </td>
- </tr>
- </tbody>
- </table>
- </div>
- <div class="sp-page table-body-left sp-pb-5" style="width: 501px; margin-top: -34px; overflow: auto; " onscroll="scrollTableL()">
- <table class="sp-table">
- <thead>
- <tr>
- <th><div style="width:35px"></div></th>
- <th><div style="width:36px">序号</div></th>
- <th ng-repeat="item in ctl.thead_left"><div style="min-width: 88px" ng-bind="item.cname"></div></th>
- </tr>
- </thead>
- <tbody>
- <tr ng-repeat="item in ctl.list">
- <td><div style="width:29px"><input type="checkbox" ng-model="item.checked" ng-click="ctl.checkItem(item)" /></div></td>
- <td><div style="width:30px" ng-bind="$index+1"></div></td>
- <td ng-repeat="item1 in ctl.thead_left"><div style="width: 82px; height: 22px; overflow: hidden; white-space: nowrap; text-overflow: ellipsis" title="{{item[item1.code]}}" ng-bind="item[item1.code]"></div></td>
- </tr>
- </tbody>
- </table>
- </div>
- <div class="sp-page table-body-right sp-pb-5" style="width: calc(100% - 501px); margin-top: -34px; overflow: auto; " onscroll="scrollTableR()">
- <table class="sp-table">
- <thead>
- <tr>
- <th ng-repeat="item in ctl.thead_right"><div style="min-width: 188px" ng-bind="item.cname"></div></th>
- </tr>
- </thead>
- <tbody>
- <tr ng-repeat="item in ctl.list">
- <td ng-repeat="item1 in ctl.thead_right"><div style="height: 22px;" title="{{item[item1.code]}}" ng-bind="item[item1.code]"></div></td>
- </tr>
- </tbody>
- </table>
- </div>
- <div class="sp-table-tip ng-hide sp-pull-left" ng-show="ctl.noDataTip == 0">
- <i class="fa fa-exclamation-circle sp-mr-10"></i>您好,暂未查询到相关信息!
- </div>
- <!--<div class="sp-page sp-mt-10">
- <div style="position: relative; overflow: auto;">
- <table class="sp-table" id="printOut">
- <thead>
- <tr>
- <th width="50">序号</th>
- <th style="min-width:100px" ng-repeat="item in ctl.thead" ng-bind="item.cname"></th>
- </tr>
- </thead>
- <tbody>
- <tr ng-repeat="item in ctl.list">
- <td ng-bind="$index+1"></td>
- <td ng-repeat="item1 in ctl.thead"><span title="{{item[item1.code]}}" ng-bind="item[item1.code]"></span></td>
- </tr>
- </tbody>
- </table>
- </div>
- <div class="sp-table-tip ng-hide" ng-show="ctl.noDataTip == 0">
- <i class="fa fa-exclamation-circle sp-mr-10"></i>您好,暂未查询到相关信息!
- </div>
- </div>-->
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- <div class="sp-layer" id="importDivPart" style="width:1000px">
- <div class="sp-center-900">
- <div class="sp-page sp-mt-5">
- <div class="sp-lh-32 sp-page-col sp-span2">表名:</div>
- <div class="sp-lh-32 sp-page-col sp-span3" ng-bind="ctl.tablename"></div>
- </div>
- <div class="sp-page" id="table_excelHead" style="overflow-y: auto; max-height: 500px">
- <table class="sp-table">
- <thead>
- <tr>
- <th style="width:50%">数据库字段</th>
- <th style="width:50%">数据源字段</th>
- </tr>
- </thead>
- <tbody>
- <tr ng-repeat="item in ctl.thead">
- <td ng-bind="item.cname" data-code="{{item.code1}}" data-ckind="{{item.ckind}}"></td>
- <td>
- <select class="sp-select" ng-model="item.cname1">
- <option ng-repeat="item2 in ctl.excelHeadData" value="{{item2}}" ng-selected="item2==item.cname">{{item2}}</option>
- </select>
- </td>
- </tr>
- </tbody>
- </table>
- </div>
- <div class="sp-page sp-mt-30 sp-text-center">
- <button class="sp-btn-blue" id="btnTrueImportData" ng-click="ctl.btnTrueImportData()"><i class="fa fa-check"></i> <span>导入数据</span></button>
- </div>
- </div>
- </div>
- </div>
- <script src="../../AFrontEnd/js/jquery/jquery-2.1.4.min.js"></script>
- <script src="../../AFrontEnd/js/laydate/laydate.js"></script>
- <script src="../../AFrontEnd/js/angularjs/angular.js"></script>
- <script src="../../AFrontEnd/js/angularjs/dirPagination.js"></script>
- <script src="../../apiurljs.js"></script>
- <script src="../../js/sm4.js"></script>
- <!-- 导入excel -->
- <script src="js/jszip.js"></script>
- <script src="js/xlsx.js"></script>
- <!-- 导出excel -->
- <script src="js/vendor/jquery.jqprint-0.3.js"></script>
- <script src="js/vendor/shim.min.js"></script>
- <script src="js/vendor/jszip.js"></script>
- <script src="js/vendor/xlsx.full.js"></script>
- <script src="js/vendor/Blob.js"></script>
- <script src="js/vendor/FileSaver.js"></script>
- <script>document.write('<scri' + 'pt src="../../AFrontEnd/js/special/special.js?time=' + new Date().getTime() + '"></s' + 'cript>')</script>
- <script>document.write('<scri' + 'pt src="js/list1.js?time=' + new Date().getTime() + '"></s' + 'cript>')</script>
- <script src="../../AFrontEnd/js/special/spng.js"></script>
- <script src="../../AFrontEnd/js/special/spngvld.js"></script>
- </body>
- </html>
|