| | |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="WorkCenter" id="WorkCenter"> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" style="display:none;" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px;display:none;">éç½®</button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px;">éç½®</button> |
| | | |
| | | |
| | | <div class="layui-inline"> |
| | |
| | | </div> |
| | | </div> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | <div id="page" style="margin-top:70px;"></div> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <!--<div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>䏿¨</button> |
| | |
| | | , laypage = layui.laypage |
| | | , laydate = layui.laydate |
| | | , soulTable = layui.soulTable |
| | | |
| | | |
| | | var Organization = sessionStorage["Organization"]; |
| | | |
| | | |
| | | var sWhere = ""; |
| | | var sWhere = ""; |
| | | var HModName = "Sc_ICMOBillList"; |
| | |
| | | var params = getUrlVars(); |
| | | var HDeptID = params[params[0]]; |
| | | var option = []; |
| | | var page = 1;//åé¡µæ°æ® |
| | | var size = 50; |
| | | |
| | | |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | var titleData = ["hmainid", "HEntryID", "ä½åºäºº", "ä½åºæ¥æ", "éå®è®¢åæ¥æ", "订åè·è¸ªå·", "HDeptID", "HMaterID", "hunitid", "hempid", "ä¸å¡å代ç ", "ä¸å¡å", "hcusid", "客æ·ä»£ç ", "客æ·", "HCenterID", "å·¥ä½ä¸å¿ä»£ç ", "å·¥ä½ä¸å¿", "hbomid", "BOMåç¼ç ", "HRoutingInterID", "å·¥èºè·¯çº¿ä»£ç ", "订åå
è£
夿³¨", "hsubid", "æºååå·", "æºå主å
ç ", "æºååå
ç ", "è¡å
³é人", "å
³éç±»å", "åæ®ç±»å", "计åè·è¸ªå·"];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | //var titleData = ["hmainid", "HEntryID", "ä½åºäºº", "ä½åºæ¥æ", "éå®è®¢åæ¥æ", "订åè·è¸ªå·", "HDeptID", "HMaterID", "hunitid", "hempid", "ä¸å¡å代ç ", "ä¸å¡å", "hcusid", "客æ·ä»£ç ", "客æ·", "HCenterID", "å·¥ä½ä¸å¿ä»£ç ", "å·¥ä½ä¸å¿", "hbomid", "BOMåç¼ç ", "HRoutingInterID", "å·¥èºè·¯çº¿ä»£ç ", "å·¥èºè·¯çº¿", "订åå
è£
夿³¨", "hsubid", "æºååå·", "æºå主å
ç ", "æºååå
ç ", "è¡å
³é人", "å
³éç±»å", "åæ®ç±»å", "计åè·è¸ªå·"];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | set_ClearQuery(); |
| | | |
| | | if (page != 1) { |
| | | $("#page a:eq(1)").get(0).click();//ç¹å»å页æ 第ä¸é¡µ |
| | | } else { |
| | | if ($("#HProject").val() == 0) { |
| | | get_FastQuery(2); |
| | | } else { |
| | | get_FastQuery(3); |
| | | } |
| | | } |
| | | |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½ |
| | | if ($("#HProject").val() == 0) { |
| | | get_FastQuery(2); |
| | | if (page != 1) { |
| | | $("#page a:eq(1)").get(0).click();//ç¹å»å页æ 第ä¸é¡µ |
| | | } else { |
| | | get_FastQuery(3); |
| | | if ($("#HProject").val() == 0) { |
| | | get_FastQuery(2); |
| | | } else { |
| | | get_FastQuery(3); |
| | | } |
| | | } |
| | | |
| | | }); |
| | | |
| | | //#region æ¥æé´é䏿å表çå¬ |
| | |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , height: 'full-80' |
| | | //, page: true |
| | | , cellMinWidth: 'auto' |
| | | , totalRow: true |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | //, limits: [50, 500, 5000, 20000] |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | |
| | | , { field: 'ç©æåç±»', title: 'ç©æåç±»', sort: true } |
| | | ]] |
| | | }; |
| | | |
| | | |
| | | optionPage = { |
| | | elem: 'page', //注æï¼è¿éç page æ¯ IDï¼ä¸ç¨å # å· |
| | | count: 10000, //æ°æ®æ»æ°ï¼ä»æå¡ç«¯å¾å° |
| | | limit: 50, |
| | | limits: [50, 500, 5000, 50000], |
| | | layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'], |
| | | jump: function (obj, first) { |
| | | //console.log(obj) |
| | | //objå
å«äºå½ååé¡µçææåæ°ï¼æ¯å¦ï¼ |
| | | //console.log(obj.curr); //å¾å°å½å页ï¼ä»¥ä¾¿åæå¡ç«¯è¯·æ±å¯¹åºé¡µçæ°æ®ã |
| | | //console.log(obj.limit); //å¾å°æ¯é¡µæ¾ç¤ºçæ¡æ° |
| | | |
| | | //馿¬¡ä¸æ§è¡ |
| | | if (!first) { |
| | | //do something |
| | | console.log(obj) |
| | | page = obj.curr; |
| | | size = obj.limit; |
| | | get_FastQuery(); |
| | | } |
| | | } |
| | | } |
| | | laypage.render(optionPage); |
| | | |
| | | |
| | | } |
| | | //#endregion çå¬ç½æ ¼è¡¨ä½äºä»¶ |
| | | table.on('tool(mainTable)', function (obj) { |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢-å页 |
| | | function get_DisplayPage(sWhere) { |
| | | var wait = layer.load();//é®ç½© |
| | | var ajaxLoad = layer.load(); |
| | | sWhere += " and HPRDORGID=" + sessionStorage["OrganizationID"] + " "; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/LEMS/MES_IF_ICMOBillList_Json_byPage', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "Organization": Organization, "page": page, "size": size }, |
| | | success: function (data1) { |
| | | option.limit = size;//æ¹åè¡¨æ ¼é¡µå¤§å° |
| | | if (data1.count != 0) { |
| | | optionPage.count = data1.count;//æ¹ååè¡¨æ°æ®æ»æ° |
| | | var data = []; |
| | | var col = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) { |
| | | //卿è·åå表ææåå |
| | | data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); |
| | | //è·åä¸éè¦æ¾ç¤ºçåï¼Hå¼å¤´çå䏿¾ç¤ºï¼ |
| | | var patrn = new RegExp(/^h/i); |
| | | if (patrn.test(data1.list[key].ColmCols)) { |
| | | titleData[key] = data1.list[key].ColmCols; |
| | | } |
| | | } |
| | | //å¨å表左边添å å¾éæ¡ |
| | | col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计è¡' }); |
| | | for (var i = 0; i < data.length; i++) { |
| | | // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') { |
| | | if ($.inArray(data[i].name, titleData) > -1) { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | | //int |
| | | case 'DateTime': |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 }); |
| | | break; |
| | | case 'long': |
| | | case 'Int32': |
| | | case 'Int64': |
| | | case 'double': |
| | | case 'Decimal': |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120, totalRow: true }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 }); |
| | | } |
| | | } |
| | | } |
| | | |
| | | //卿æ¾ç¤ºåå |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , totalRow: true |
| | | , cols: [col] |
| | | , data: data1.data |
| | | , height: 'full-120' |
| | | //, page: true |
| | | //, limits: [50, 500, 5000, 50000] |
| | | , limit: 500 |
| | | , cellMinWidth: 90 |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | } |
| | | ins = table.render(option); |
| | | |
| | | laypage.render(optionPage); |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | |
| | | //å·æ°æé®æ¾ç¤º |
| | | var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ |
| | | var HBillType = "3710"; |
| | | Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); |
| | | |
| | | if ($("#Comparator").val() == 0 && $("#ColContent").val() == "" && $("#Comparator1").val() == 0 && $("#ColContent1").val() == "" && $("#Comparator2").val() == 0 && $("#ColContent2").val() == "") { |
| | | ColFilter(); |
| | | } |
| | | |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | option.data = []; |
| | | table.render(option); |
| | | layer.close(ajaxLoad); |
| | | /*layer.alert(data1.code + data1.Message, { icon: 5 });*/ |
| | | } |
| | | }, error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | layer.close(wait); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery(number) { |
| | | var HDate = $("#HDate").val();;//å¼å§æ¥æ |
| | |
| | | //æ ¹æ®ç¨æ·è¿æ»¤ç¨æ·å
³è客æ·çè®°å½ |
| | | sWhere += getSWhereByHUser(); |
| | | |
| | | get_Display(sWhere); |
| | | //get_Display(sWhere); |
| | | |
| | | get_DisplayPage(sWhere); |
| | | |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | GetDataCols = ""; |
| | | } |
| | |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Xt_FastICScheme/Chooselist', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "user": sessionStorage["Czybm"], "HModuleName": HModuleName, "HInterID": 0, "Type": "Default" }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |