| New file |
| | |
| | | <!DOCTYPE html> |
| | | <html> |
| | | <head> |
| | | <meta charset="utf-8" /> |
| | | <title>å·¥èºè·¯çº¿æ°æ®å¯¼å
¥</title> |
| | | <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | <script src="../../../layuiadmin/layui/layui.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/json2.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/PubCustom.js"></script> |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid"> |
| | | <div class="layui-col-md12"> |
| | | <div class="layui-card" style="padding: 1px"> |
| | | <div class="layui-card-body" style="padding: 1px;"> |
| | | <form class="layui-form" action="" lay-filter="component-form-group"> |
| | | <div style="padding: 10px; "> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnSave" id="btnSave">导å
¥æ°æ®</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="Cancel" id="Cancel">éåº</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="UpLoad" id="UpLoad">æä»¶ä¸ä¼ </button> |
| | | </div> |
| | | <div class="layui-collapse"> |
| | | <div class="layui-colla-item"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ä¼è®¡å¹´</label> |
| | | <div class="layui-input-block" style="margin-left: 120px; width: 85px;"> |
| | | <select name="HYear" id="HYear" lay-verify="HYear"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ä¼è®¡æ</label> |
| | | <div class="layui-input-block" style="margin-left: 120px; width: 85px;"> |
| | | <select name="HPeriod" id="HPeriod" lay-verify="HPeriod"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">å·¥ä½ç°¿</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="WorkBookName" id="WorkBookName" value="Sheet1"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <div class="layui-input-block" style="margin-left: 10px;min-height:0px"> |
| | | <input type="checkbox" name="DataAppend" id="DataAppend" lay-skin="primary" lay-filter="DataAppend" title="追å "> |
| | | <input type="hidden" name="HOrgID" id="HOrgID" lay-verify="HOrgID"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>å é¤</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </body> |
| | | </html> |
| | | <script> |
| | | var treeCkData = { id: 0 }; |
| | | var TagId = ""; |
| | | var TagParentId = ""; |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','upload'], function () { |
| | | //#region å
¬ç¨åé |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | | , layer = layui.layer |
| | | , table = layui.table |
| | | , form = layui.form |
| | | , element = layui.element |
| | | , laypage = layui.laypage |
| | | , laydate = layui.laydate |
| | | , util = layui.util |
| | | , tree = layui.tree |
| | | , util = layui.util |
| | | , upload = layui.upload |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | |
| | | //æä»¶ä¸ä¼ |
| | | upload.render({ |
| | | elem: '#UpLoad', |
| | | url: GetWEBURL() + '/Gy_RoutingBill/Gy_RoutingBillimport', |
| | | contentType: 'application/json', |
| | | exts: 'xls|xlsx', //å
许ä¸ä¼ çç±»å |
| | | data: { |
| | | "WorkBookName": function () { |
| | | return $("#WorkBookName").val(); |
| | | }, |
| | | "HOrgID": function () { |
| | | return sessionStorage["OrganizationID"]; |
| | | } |
| | | }, |
| | | before: function (data) { |
| | | loadIndex = layer.load(2); |
| | | this.data = { |
| | | "WorkBookName": $("#WorkBookName").val(), |
| | | "HOrgID": sessionStorage["OrganizationID"] |
| | | |
| | | } |
| | | }, |
| | | done: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | layer.close(loadIndex); |
| | | } else { |
| | | layer.close(loadIndex); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | debugger |
| | | layer.alert('导å
¥åºç°å¼å¸¸', { icon: 2 }); |
| | | } |
| | | }); |
| | | |
| | | //éåº |
| | | form.on('submit(Cancel)', function () { |
| | | Pub_Close(2); |
| | | }) |
| | | |
| | | //导å
¥ ä¿åæ°æ® |
| | | form.on('submit(btnSave)', function (data) { |
| | | if (table.cache["mainTable"] != null) { |
| | | set_AddNew(data); |
| | | } |
| | | else { |
| | | layer.msg("æ æ°æ®,请å
导å
¥æ°æ®!"); |
| | | } |
| | | }) |
| | | //#endregion |
| | | |
| | | //#region æ¬é¡µé¢è¢«è°ç¨çæææ¹æ³ |
| | | |
| | | //ä¼è®¡å¹´ |
| | | function Year() { |
| | | var yyyy = new Date().getFullYear(); |
| | | var YearOption = ""; |
| | | for (var i = 0; i <= 10; i++) { |
| | | YearOption += '<option style="color:blue;" value="' + (yyyy - 5 + i) + '">' + (yyyy - 5 + i) + '</option>'; |
| | | } |
| | | $("#HYear").append(YearOption); |
| | | $("#HYear").val(yyyy) |
| | | form.render('select'); |
| | | } |
| | | |
| | | //ä¼è®¡æ |
| | | function Month() { |
| | | var MM = new Date().getMonth() + 1; |
| | | var MonthOption = ""; |
| | | for (var i = 1; i <= 12; i++) { |
| | | MonthOption += '<option style="color:blue;" value="' + i + '">' + i + '</option>'; |
| | | } |
| | | $("#HPeriod").append(MonthOption); |
| | | $("#HPeriod").val(MM) |
| | | form.render('select'); |
| | | } |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | Year(); |
| | | Month(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | } |
| | | //#endregion |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-120' |
| | | , page: true |
| | | , cellMinWidth: 90 |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , loading: false |
| | | , cols: [[ |
| | | { type: 'checkbox', fixed: 'left' } |
| | | , { field: '产å代ç ', title: '产å代ç ', width: 120 } |
| | | , { field: '产ååç§°', title: '产ååç§°', width: 120 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 120 } |
| | | , { field: 'åä½', title: 'åä½', width: 120 } |
| | | , { field: 'å·¥èºè·¯çº¿åç§°', title: 'å·¥èºè·¯çº¿åç§°', width: 120 } |
| | | , { field: 'ç©æåç±»', title: 'ç©æåç±»', width: 120 } |
| | | , { field: 'å·¥åºåºå·', title: 'å·¥åºåºå·', width: 120 } |
| | | , { field: 'å·¥åºä»£ç ', title: 'å·¥åºä»£ç ', width: 120 } |
| | | , { field: 'å·¥åº', title: 'å·¥åº', width: 120 } |
| | | , { field: 'å·¥ä½ä¸å¿ä»£ç ', title: 'å·¥ä½ä¸å¿ä»£ç ', width: 120 } |
| | | , { field: 'å·¥ä½ä¸å¿', title: 'å·¥ä½ä¸å¿', width: 120 } |
| | | , { field: 'æ¶é´åä½', title: 'æ¶é´åä½', width: 120 } |
| | | , { field: 'å å·¥æ°é', title: 'å å·¥æ°é', width: 120 } |
| | | , { field: 'ç产å®é¢', title: 'ç产å®é¢', width: 120 } |
| | | , { field: 'å·¥åºå·¥ä»·', title: 'å·¥åºå·¥ä»·', width: 120 } |
| | | , { field: 'ä¸åæ ¼åä»·', title: 'ä¸åæ ¼åä»·', width: 120 } |
| | | , { field: 'æ¥åºåä»·', title: 'æ¥åºåä»·', width: 120 } |
| | | , { field: 'æ¬éåºå®å¼å·¥å¤©æ°', title: 'æ¬éåºå®å¼å·¥å¤©æ°', width: 120 } |
| | | , { field: 'æ¬éå¼å·¥ä½é', title: 'æ¬éå¼å·¥ä½é', width: 120 } |
| | | , { field: 'ä¸éçå¾
天æ°', title: 'ä¸éçå¾
天æ°', width: 120 } |
| | | , { field: 'ä¸é循ç¯å¨æ', title: 'ä¸é循ç¯å¨æ', width: 120 } |
| | | , { field: 'èªå¨è½¬ç§»', title: 'èªå¨è½¬ç§»', width: 120 } |
| | | , { field: 'å¤åæ è®°', title: 'å¤åæ è®°', width: 120 } |
| | | , { field: 'ä¾åºå代ç ', title: 'ä¾åºå代ç ', width: 120 } |
| | | , { field: 'ä¾åºå', title: 'ä¾åºå', width: 120 } |
| | | , { field: 'å·¥èºåæ°', title: 'å·¥èºåæ°', width: 120 } |
| | | , { field: 'å¾çº¸ç¼å·', title: 'å¾çº¸ç¼å·', width: 120 } |
| | | , { field: 'æ¬å·¥åºç¡®è®¤è®°å½', title: 'æ¬å·¥åºç¡®è®¤è®°å½', width: 120 } |
| | | , { field: 'è¯ç', title: 'è¯ç', width: 120 } |
| | | , { field: '夿³¨', title: '夿³¨', width: 120 } |
| | | , { field: 'å¾å·çæ¬', title: 'å¾å·çæ¬', width: 120 } |
| | | , { field: 'æ»è£
å¾å·', title: 'æ»è£
å¾å·', width: 120 } |
| | | , { field: 'æè´¨', title: 'æè´¨', width: 120 } |
| | | , { field: 'æåç¼å·', title: 'æåç¼å·', width: 120 } |
| | | , { field: 'çæ¬', title: 'çæ¬', width: 120 } |
| | | , { field: '模å
·ç¼å·', title: '模å
·ç¼å·', width: 120 } |
| | | , { field: 'ç¨åºå·', title: 'ç¨åºå·', width: 120 } |
| | | ]] |
| | | }; |
| | | |
| | | //渲æé¡µé¢ |
| | | table.render(option); |
| | | } |
| | | |
| | | //导å
¥(ä¿å) |
| | | function set_AddNew(data) { |
| | | |
| | | var num = []; |
| | | for (var i = 0; i < table.cache["mainTable"].length; i++) { |
| | | if (table.cache["mainTable"][i] != "") { |
| | | table.cache["mainTable"][i].LAY_TABLE_INDEX = i; |
| | | num.push(table.cache["mainTable"][i]) |
| | | } |
| | | } |
| | | data.field.HOrgID = sessionStorage["OrganizationID"];//ç»ç» |
| | | var sMainStr = JSON.stringify(data.field); |
| | | var sSubStr = JSON.stringify(num); |
| | | var sMainSub = sMainStr + ';' + sSubStr + ';' + sessionStorage["HUserName"]; |
| | | var index = layer.load(); |
| | | |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + "/Gy_RoutingBill/Gy_RoutingBill_btnSave", |
| | | async: true, |
| | | data: { "sMainSub": sMainSub }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { |
| | | layer.close(index); |
| | | layer.msg(data.Message); |
| | | } |
| | | else { |
| | | layer.close(index); |
| | | layer.msg(data.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.close(index); |
| | | layer.msg("é误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //#endregion |
| | | //以䏿¯layui模å |
| | | }); |
| | | </script> |