| | |
| | | <!DOCTYPE html> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>设å¤ä¿å
»è®¡ååå表</title> |
| | |
| | | <script src="../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | <script src="../../layuiadmin/PageTitle.js"></script> |
| | | <script src="../../layuiadmin/soulTable.slim.js"></script> |
| | | <script src="../../layuiadmin/HideButton_New.js"></script> |
| | | <script src="../../layuiadmin/SetColumn.js"></script> |
| | | <style type="text/css"> |
| | |
| | | } |
| | | </style> |
| | | </head> |
| | | |
| | | <body> |
| | | <div class="layui-fluid"> |
| | | <div class="layui-col-md12"> |
| | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">åæ®å·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HBillNo" id="HBillNo"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HBillNo" |
| | | id="HBillNo"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">æ¥æé´é</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" lay-filter="HInitTimeCycle" style="width:190px;"> |
| | | <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" |
| | | lay-filter="HInitTimeCycle" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¼å§æ¶é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input ForFilteringSchemes" name="BenginHCreateDate" id="BenginHCreateDate"> |
| | | <input type="date" class="layui-input ForFilteringSchemes" name="HBeginDate" |
| | | id="HBeginDate"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¶é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input ForFilteringSchemes" name="EndHCreateDate" id="EndHCreateDate"> |
| | | <input type="date" class="layui-input ForFilteringSchemes" name="HEndDate" |
| | | id="HEndDate"> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" 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">éç½®</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" style="margin-left:5px;"> |
| | | <div style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393" id="HFilterScheme_Now"></div> |
| | | <div style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393" |
| | | id="HFilterScheme_Now"></div> |
| | | </div> |
| | | <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> |
| | | <div class="layui-row" style="margin-top:5px"> |
| | | <div class="layui-row"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;"> |
| | | <select name="ColName" id="ColName" class="ForFilteringSchemes" |
| | | lay-filter="ColName" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;"> |
| | | <select name="Comparator" id="Comparator" class="ForFilteringSchemes" |
| | | lay-filter="Comparator" style="width:190px;"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <!--<option value="<="> |
| | | <=< /option> |
| | | <option value="<"> |
| | | << /option>--> |
| | | <option value="<>"> |
| | | <> |
| | | </option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" |
| | | name="ColContent" id="ColContent"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin-top:5px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName1" id="ColName1" lay-filter="ColName1" style="width:190px;"> |
| | | <select name="ColName1" id="ColName1" class="ForFilteringSchemes" |
| | | lay-filter="ColName1" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator1" id="Comparator1" lay-filter="Comparator1" style="width:190px;"> |
| | | <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" |
| | | lay-filter="Comparator1" style="width:190px;"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <!--<option value="<="> |
| | | <=< /option> |
| | | <option value="<"> |
| | | << /option>--> |
| | | <option value="<>"> |
| | | <> |
| | | </option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input" value="" name="ColContent1" id="ColContent1"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" |
| | | name="ColContent1" id="ColContent1"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin-top:5px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName2" id="ColName2" lay-filter="ColName2" style="width:190px;"> |
| | | <select name="ColName2" id="ColName2" class="ForFilteringSchemes" |
| | | lay-filter="ColName2" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator2" id="Comparator2" lay-filter="Comparator2" style="width:190px;"> |
| | | <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" |
| | | lay-filter="Comparator2" style="width:190px;"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <!--<option value="<="> |
| | | <=< /option> |
| | | <option value="<"> |
| | | << /option>--> |
| | | <option value="<>"> |
| | | <> |
| | | </option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input" value="" name="ColContent2" id="ColContent2"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" |
| | | name="ColContent2" id="ColContent2"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | | <div id="page" style="position: relative; bottom: 0;"></div> |
| | | <div class="layui-tab layui-tab-card"> |
| | | <ul class="layui-tab-title"> |
| | | <li class="layui-this">ä¿å
»é¡¹ä¿¡æ¯</li> |
| | |
| | | <div id="page" style="position: relative; bottom: 0;"></div> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container" id="toolbarDemo_ButtonSet"> |
| | | <div class="layui-btn-container" id="toolbarDemo_ButtonSet"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Export" id="btn_Export"><i class="layui-icon layui-icon-export"></i>导åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add" id="Add"><i class="layui-icon layui-icon-add-1"></i>æ°å¢</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Copy" id="set_Copy"><i class="layui-icon layui-icon-form"></i>å¤å¶</button> |
| | |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AbandonCheck" id="AbandonCheck"><i class="layui-icon layui-icon-form"></i>åå®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CloseBill" id="set_CloseBill"><i class="layui-icon layui-icon-form"></i>å
³é</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CancelCloseBill" id="set_CancelCloseBill"><i class="layui-icon layui-icon-form"></i>åå
³é</button> |
| | | <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button>--> |
| | | <!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>ä¿åæ¹æ¡</button> |
| | |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | | </div> |
| | | </script> |
| | | |
| | | <script type="text/html" id="xuhao"> |
| | | {{d.LAY_TABLE_INDEX+1}} |
| | | </script> |
| | | <script type="text/html" id="xuhao1"> |
| | | {{d.LAY_TABLE_INDEX+1}} |
| | | </script> |
| | | |
| | | </form> |
| | | </div> |
| | | </div> |
| | |
| | | base: '../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], function () { |
| | | }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate', 'soulTable'], function () { |
| | | //#region å
Œ
±åé |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | |
| | | , util = layui.util |
| | | , soulTable = layui.soulTable |
| | | //æ¥è¯¢æ¡ä»¶ |
| | | var IsAut = 0; |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var option1 = []; |
| | |
| | | var HBillType = "Sb_EquipMaintainPlanBillList"; |
| | | var set_HideButton_ID = "toolbarDemo_ButtonSet";//éè¦è®¾ç½®çæé®çç¶çº§èç¹çid |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | var titleData = ["åæ®ç±»å", "æè¦", "å
é¨åæ®å·"];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | var optionPage = []; |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | var page = 1;//åé¡µæ°æ® |
| | | var size = 50; |
| | | var set_HideButton_ID = "toolbarDemo_ButtonSet";//éè¦è®¾ç½®çæé®çç¶çº§èç¹çid |
| | | var HBillType = "3902"; |
| | | |
| | | //#region ã卿è·å模ååç§°ã |
| | | var HModuleType = "3902"; |
| | | //éè¿åæ®ç±»åï¼ä»æ°æ®åºå¨æè·ååæ®æ¨¡åå½å,å¼ç¨jsæä»¶ PageTitle.js |
| | | var HPageTitle = get_PageTitle(HModuleType) == "" ? document.title : get_PageTitle(HModuleType); |
| | | //#endregion |
| | | //#endregion |
| | | |
| | | //#region ãè¿æ»¤æ¹æ¡ã |
| | | |
| | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | //#region åå»è¿åæ°æ® |
| | | table.on('rowDouble(mainTable)', function (obj) { |
| | | var data = []; |
| | | data.push(obj.data); |
| | | var index = parent.layer.getFrameIndex(window.name); |
| | | //è¿åæ¹æ³ |
| | | parent.GetMaintainValue(data); |
| | | parent.layer.close(index); |
| | | |
| | | }); |
| | | |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | |
| | | set_Refresh(); |
| | | break; |
| | | //å设置 |
| | | case 'set_HideColumn': get_HideColumn(HModName, sessionStorage["HUserName"], option, optionPage, get_FastQuery); |
| | | case 'set_HideColumn': get_HideColumnNoPage(HModName, sessionStorage["HUserName"], option, get_FastQuery); |
| | | break; |
| | | //æé®è®¾ç½® |
| | | case 'set_HideButton': |
| | |
| | | }; |
| | | }); |
| | | |
| | | //è¡¨æ ¼èªå®ä¹äºä»¶çå¬ |
| | | table.on('tool(mainTable)', function (obj) { |
| | | let data = obj.data; |
| | | switch (obj.event) { |
| | | case "onHBillNumberClickHandler": onHBillNumberClickHandler(data); break; |
| | | } |
| | | }) |
| | | |
| | | table.on('row(mainTable)', function (obj) { |
| | | //éä¸è¡æ¹åé¢è² |
| | | var flag = !obj.tr.find(':checkbox:first').prop('checked'); |
| | |
| | | var datas = obj.data; //è·å¾å½åè¡æ°æ® |
| | | var linterid = datas.hmainid; |
| | | $.ajax({ |
| | | url: GetWEBURL() + 'Sb_EquipMaintainPlanBill/Sb_EquipMaintainPlanBillListProjectDetaiNew', |
| | | url: GetWEBURL() + '/Sb_EquipMaintainPlanBill/Sb_EquipMaintainPlanBillListProjectDetaiNew', |
| | | type: "GET", |
| | | data: { "HInterID": linterid }, |
| | | success: function (data1) { |
| | |
| | | get_FastQuery(); |
| | | } |
| | | }) |
| | | |
| | | //æ¥æé´é䏿å表çå¬ |
| | | form.on('select(HInitTimeCycle)', function (data) { |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | //è¥æ¥æé´éä¸ä¸º ä»»æé´éï¼åç¦ç¨å¼å§æ¥æä¸ç»ææ¥æçéæ© |
| | | if (HInitTimeCycle != -1) { |
| | | $('#BenginHCreateDate').prop('disabled', true); |
| | | $('#EndHCreateDate').prop('disabled', true); |
| | | $('#HBeginDate').prop('disabled', true); |
| | | $('#HEndDate').prop('disabled', true); |
| | | |
| | | $("#BenginHCreateDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#EndHCreateDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | |
| | | //æ§è¡æ¥è¯¢æ¹æ³ |
| | | get_FastQuery(); |
| | | } else { |
| | | $('#BenginHCreateDate').prop('disabled', false); |
| | | $('#EndHCreateDate').prop('disabled', false); |
| | | $('#HBeginDate').prop('disabled', false); |
| | | $('#HEndDate').prop('disabled', false); |
| | | } |
| | | }); |
| | | |
| | | //#endregion |
| | | |
| | | |
| | |
| | | //è¥æ¥æé´éä¸ä¸º ä»»æé´éï¼åç¦ç¨å¼å§æ¥æä¸ç»ææ¥æçéæ© |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | if (HInitTimeCycle != -1) { |
| | | $('#BenginHCreateDate').prop('disabled', true); |
| | | $('#EndHCreateDate').prop('disabled', true); |
| | | $('#HBeginDate').prop('disabled', true); |
| | | $('#HEndDate').prop('disabled', true); |
| | | } else { |
| | | $('#BenginHCreateDate').prop('disabled', false); |
| | | $('#EndHCreateDate').prop('disabled', false); |
| | | $('#HBeginDate').prop('disabled', false); |
| | | $('#HEndDate').prop('disabled', false); |
| | | } |
| | | $("#BenginHCreateDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#EndHCreateDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //åå§åè¡¨æ ¼(主表) |
| | | set_InitGrid(); |
| | | //åå§åè¡¨æ ¼(å表1) |
| | | set_InitGrid1(); |
| | | //åå§åè¡¨æ ¼(å表2) |
| | | set_InitGrid2(); |
| | | |
| | | //æ¥è¯¢ |
| | | get_FastQuery(); |
| | | //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ |
| | | get_DefaultModule(); |
| | | } |
| | |
| | | layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'], |
| | | jump: function (obj, first) { |
| | | |
| | | //馿¬¡ä¸æ§è¡ |
| | | if (!first) { |
| | | //do something |
| | | page = obj.curr; |
| | | size = obj.limit; |
| | | get_FastQuery(); |
| | | } |
| | | } |
| | | } |
| | | |
| | | 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) { |
| | | //馿¬¡ä¸æ§è¡ |
| | | if (!first) { |
| | | //do something |
| | |
| | | , { field: 'HMaterID', title: 'é
ä»¶ID', width: 200, hide: true } |
| | | , { field: 'HMaterNumber', title: 'é
件代ç ', width: 200 } |
| | | , { field: 'HMaterName', title: 'é
ä»¶åç§°', width: 200 } |
| | | , { field: 'HMaterSpec', title: 'è§æ ¼åå·', width: 200 ,hide: true} |
| | | , { field: 'HMaterSpec', title: 'è§æ ¼åå·', width: 200, hide: true } |
| | | , { field: 'HUnitID', title: 'åä½ID', width: 200, hide: true } |
| | | , { field: 'HUnitNumber', title: 'åä½ä»£ç ', width: 200 } |
| | | , { field: 'HUnitName', title: 'åä½åç§°', width: 200 } |
| | | , { field: 'HManagerID', title: 'è´è´£äººID', width: 200, hide: true} |
| | | , { field: 'HManagerID', title: 'è´è´£äººID', width: 200, hide: true } |
| | | , { field: 'HManagerNumber', title: 'è´è´£äººä»£ç ', width: 200 } |
| | | , { field: 'HManagerName', title: 'è´è´£äºº', width: 200 } |
| | | , { field: 'HQty', title: 'å®é
ç¨é', width: 200, totalRow: true } |
| | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery(table, option) { |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | $("#BenginHCreateDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#EndHCreateDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | var HBeginDate = $("#HBeginDate").val(); |
| | | var HEndDate = $("#HEndDate").val(); |
| | | //ä»»æåæ®µè¿æ»¤ |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | } |
| | | if (BenginHCreateDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + BenginHCreateDate + "'"; |
| | | if (HBeginDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HBeginDate + "'"; |
| | | } |
| | | if (EndHCreateDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + EndHCreateDate + "'"; |
| | | if (HEndDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HEndDate + "'"; |
| | | } |
| | | //get_Display(sWhere); |
| | | get_DisplayPage(sWhere); |
| | |
| | | function set_ClearQuery() { |
| | | $("#HBillNo").val("");//åæ®å· |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | $("#BenginHCreateDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#EndHCreateDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | } |
| | | } |
| | | DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option, titleData) |
| | | |
| | | ins = table.render(option); |
| | |
| | | } else { |
| | | layer.close(index); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | } |
| | | }, error: function () { |
| | | layer.close(index); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Sb_EquipMaintainPlanBill/GetEquipMaintainPlanBillListPage', |
| | | type: "GET", |
| | | async: false, |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "page": page, "size": size }, |
| | | success: function (data1) { |
| | | option.limit = size;//æ¹åè¡¨æ ¼é¡µå¤§å° |
| | |
| | | if ($.inArray(data[i].name, titleData) > -1) { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå |
| | | } else if (data[i].name == 'åæ®å·') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'åæ®å·' }); |
| | | col.push({ |
| | | field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, |
| | | templet: function (d) { |
| | | return '<span style="color: blue;" lay-unrow >' + d.åæ®å· + '</span>' |
| | | }, style: 'cursor: pointer;', event: 'onHBillNumberClickHandler' |
| | | }); |
| | | } |
| | | else { |
| | | switch (data[i].Type) { |
| | |
| | | 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 }); |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 140 }); |
| | | } |
| | | } |
| | | } |
| | |
| | | Display_HideButton(set_HideButton_ID, HBillType, HModName, sessionStorage["HUserName"]); |
| | | |
| | | layer.close(ajaxLoad); |
| | | if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { |
| | | if ($("#ColName option").length < 1) { |
| | | ColFilter(); |
| | | get_DefaultModule();//å è½½æ¹æ¡ |
| | | } |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | |
| | | function set_ShowBill() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | var quu = IsAut; |
| | | if (checkStatus.data.length === 1) { |
| | | var linterid = data[0].hmainid.toString(); |
| | | //if (AllowLoadData(sSubStr) != false) {//é空éªè¯ |
| | |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: '../设å¤ç®¡ç/Sb_EquipMaintainPlanBillEdit.html?OperationType=3&linterid=' + linterid + '&HSouceBillType=' |
| | | , content: '../设å¤ç®¡ç/Sb_EquipMaintainPlanBillEdit.html?OperationType=3&linterid=' + linterid + '&HSouceBillType=' + quu |
| | | , resize: false, |
| | | end: function () { |
| | | //å·æ°é¡µé¢, |
| | |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | get_FastQuery(); |
| | | IsAut = 1; |
| | | layer.msg(result.Message, { icon: 1 }); |
| | | layer.close(wait); |
| | | } else { |
| | |
| | | else { |
| | | layer.msg("è¯·éæ©ä¸æ¡æ°æ®!"); |
| | | } |
| | | } |
| | | } |
| | | |
| | | //é¢è§ |
| | | function get_ViewReport() { |
| | |
| | | function set_Refresh() { |
| | | $("#HBillNo").val("");//åæ®å· |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | $("#BenginHCreateDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#EndHCreateDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | |
| | | sWhere = ""; |
| | | $("#btnSearch").click(); |
| | | } |
| | | |
| | | |
| | | //#region åå§æ¥æé´é 䏿å表 |
| | | function setSelect_HInitTimeCycle() { |
| | | var valueList = [0, 1, 2, 3, 4, 5, 6, 29]; |
| | | var titleList = ["ä»å¤©", "è¿ä¸¤å¤©", "è¿ä¸å¤©", "è¿å天", "è¿äºå¤©", "è¿å
天", "è¿ä¸å¤©", "è¿30天"]; |
| | | |
| | | var HInitTimeCycle_ArrayList = '<option value="-1" selected="selected" >ä»»æé´é</option>'; |
| | | for (var i = 0; i < valueList.length; i++) { |
| | | HInitTimeCycle_ArrayList += '<option style="color:blue;" value="' + valueList[i] + '">' + titleList[i] + '</option>'; |
| | | } |
| | | |
| | | $("#HInitTimeCycle").empty(); |
| | | $("#HInitTimeCycle").append(HInitTimeCycle_ArrayList); |
| | | form.render('select'); |
| | | |
| | | $("#HInitTimeCycle").val("29"); |
| | | } |
| | | |
| | | //#region 导åºExecel |
| | | function btn_Export() { |
| | | option.data.forEach((item) => { |
| | | for (let itemobj in item) { |
| | | if (item[itemobj] == null) { |
| | | item[itemobj] = ""; |
| | | } |
| | | if (item[itemobj].length > 0) { // åè®¾åæ®µå为field |
| | | item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | } |
| | | } |
| | | }); |
| | | |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region åææ¾ç¤ºä¸ææ¡ |
| | | function ColFilter() { |
| | | var Organization = '<option value="0" selected="selected" ></option>'; |
| | |
| | | $("#ColName2").empty(); |
| | | $("#ColName2").append(Organization); |
| | | form.render('select'); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region åå§æ¥æé´é 䏿å表 |
| | | function setSelect_HInitTimeCycle() { |
| | | var valueList = [0, 1, 2, 3, 4, 5, 6, 29,180,365]; |
| | | var titleList = ["ä»å¤©", "è¿ä¸¤å¤©", "è¿ä¸å¤©", "è¿å天", "è¿äºå¤©", "è¿å
天", "è¿ä¸å¤©", "è¿30天", "è¿åå¹´", "è¿ä¸å¹´"]; |
| | | |
| | | var HInitTimeCycle_ArrayList = '<option value="-1" selected="selected" >ä»»æé´é</option>'; |
| | | for (var i = 0; i < valueList.length; i++) { |
| | | HInitTimeCycle_ArrayList += '<option style="color:blue;" value="' + valueList[i] + '">' + titleList[i] + '</option>'; |
| | | } |
| | | |
| | | $("#HInitTimeCycle").empty(); |
| | | $("#HInitTimeCycle").append(HInitTimeCycle_ArrayList); |
| | | form.render('select'); |
| | | |
| | | $("#HInitTimeCycle").val("29"); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·ååæ° |
| | | function getUrlVars() { |
| | | var vars = [], hash; |
| | | var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&'); |
| | | for (var i = 0; i < hashes.length; i++) { |
| | | hash = hashes[i].split('='); |
| | | vars.push(hash[0]); |
| | | vars[hash[0]] = hash[1]; |
| | | } |
| | | return vars; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region 夿æ¯ç´æ¥æå¼é¡µé¢è¿æ¯å
¶å®é¡µé¢éè¿éæ©æé®æå¼ï¼å¹¶æ¾ç¤ºç¸åºæ°æ® |
| | | function addSWhereByOpenType() { |
| | | //è·ååæ° |
| | | var params = getUrlVars(); |
| | | var openType = params[params[0]]; //ä»åæ°ä¸è·å æå¼æ¹å¼ 1ç´æ¥æå¼ 2å
¶å®é¡µé¢éè¿éæ©æé®æå¼ |
| | | var addSWhere = ""; |
| | | if (typeof (openType) != "undefined") { |
| | | addSWhere = " and isnull(å
³é人,'') = '' and å®¡æ ¸äºº != ''"; |
| | | } |
| | | return addSWhere; |
| | | } |
| | | //#endregion |
| | | |
| | |
| | | $("#" + data[i].è¿æ»¤å段ID).find("option[value='" + data[i].è¿æ»¤å¼ + "']").attr("selected", true); |
| | | } |
| | | } |
| | | |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | //è¥æ¥æé´éä¸ä¸º ä»»æé´éï¼åç¦ç¨å¼å§æ¥æä¸ç»ææ¥æçéæ© |
| | | if (HInitTimeCycle != -1) { |
| | | $('#HBeginDate').prop('disabled', true); |
| | | $('#HEndDate').prop('disabled', true); |
| | | |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | |
| | | |
| | | //æ§è¡æ¥è¯¢æ¹æ³ |
| | | get_FastQuery(); |
| | | } else { |
| | | $('#HBeginDate').prop('disabled', false); |
| | | $('#HEndDate').prop('disabled', false); |
| | | } |
| | | |
| | | //æ§è¡æ¥è¯¢æ¹æ³ |
| | | get_FastQuery() |
| | | form.render("select"); |
| | |
| | | // å³ä¸è§å
³éäºä»¶çé»è¾ |
| | | HIsClose_Manual = true; |
| | | } |
| | | , btn: ['确认', 'åæ¶'] |
| | | , btn1: function (index, laero) { |
| | | //æé®ä¸ çåè° |
| | | var iframeWindow = window["layui-layer-iframe" + index];//è·åå¼¹æ¡é¡µé¢ |
| | | var checkStatus = iframeWindow.layui.table.checkStatus("mainTable");//è·åéä¸çæ°æ® |
| | | |
| | | if (checkStatus.data.length !== 1) { |
| | | return layer.msg("è¯·éæ©ä¸æ¡æ°æ®"); |
| | | } |
| | | let hmainid = checkStatus.data[0].hmainid |
| | | let ajaxLoad = layer.load() |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Xt_FastICScheme/Chooselist', |
| | | type: "GET", |
| | | data: { "user": sessionStorage["Czybm"], "HModuleName": HModuleName, "HInterID": HInterID, "Type": "Select" }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | var data = data1.data; |
| | | //èµå¼è¿æ»¤æ¹æ¡åç§° |
| | | HDefaultFilter = data[0].æ¹æ¡åç§° |
| | | var HRemark = data[0].夿³¨ |
| | | //æ¾ç¤ºå½åçè¿æ»¤æ¹æ¡ |
| | | document.getElementById("HFilterScheme_Now").style.display = "block"; |
| | | document.getElementById('HFilterScheme_Now').innerHTML = "å½åè¿æ»¤æ¹æ¡ï¼" + HDefaultFilter + '<span style="font-size: 15px; font-weight: bold; color:#7b90fb"> ' + "(" + HRemark + ")" + '</span>'; |
| | | HInterID = data[0].hmainid |
| | | //æ ¹æ®éæ©çè¿æ»¤æ¹æ¡åå¡«æ°æ®å°åè¡¨è¿æ»¤æ¡ä»¶ |
| | | for (let i = 0; i < data.length; i++) { |
| | | $("#" + data[i].è¿æ»¤å段ID).val(data[i].è¿æ»¤å¼); |
| | | if (data[i].è¿æ»¤æ ç¾ç±»å == 'SELECT') { |
| | | $("#" + data[i].è¿æ»¤å段ID).find("option[value='" + data[i].è¿æ»¤å¼ + "']").attr("selected", true); |
| | | } |
| | | } |
| | | |
| | | layer.close(index);//å
³éå¼¹çª |
| | | |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | |
| | | } |
| | | , btn2: function () { |
| | | HIsClose_Manual = true; |
| | | } |
| | | , end: function () { |
| | | if (HIsClose_Manual != true) { |
| | | get_FastQuery() |
| | |
| | | } |
| | | |
| | | //#endregion |
| | | //#region èªå®ä¹äºä»¶æè· |
| | | function onHBillNumberClickHandler(data) { |
| | | var linterid = data.hmainid |
| | | //if (AllowLoadData(sSubStr) != false) {//é空éªè¯ |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['100%', '100%'] |
| | | , title: 'ç¼è¾' + HPageTitle |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: '../设å¤ç®¡ç/Sb_EquipMaintainPlanBillEdit.html?OperationType=3&linterid=' + linterid + '&HSouceBillType=' |
| | | , resize: false, |
| | | end: function () { |
| | | //å·æ°é¡µé¢, |
| | | location.reload(); |
| | | } |
| | | , cancel: function () { |
| | | //$(".layui-btn").removeClass("layui-btn-disabled"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | // å¤å¶ |
| | | function set_CopyBill() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | if (checkStatus.data.length === 1) { |
| | | var linterid = data[0].hmainid.toString(); |
| | | //if (AllowLoadData(sSubStr) != false) {//é空éªè¯ |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['100%', '100%'] |
| | | , title: 'å¤å¶' + HPageTitle |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: '../设å¤ç®¡ç/Sb_EquipMaintainPlanBillEdit.html?OperationType=2&linterid=' + linterid + '&HSouceBillType=' |
| | | , resize: false, |
| | | end: function () { |
| | | //å·æ°é¡µé¢, |
| | | location.reload(); |
| | | } |
| | | , cancel: function () { |
| | | //$(".layui-btn").removeClass("layui-btn-disabled"); |
| | | } |
| | | }) |
| | | |
| | | } else { |
| | | layer.msg('è¯·éæ©ä¸è¡æ°æ®å¤å¶ï¼'); |
| | | } |
| | | } |
| | | |
| | | |
| | | //#endregion |
| | | |
| | |
| | | </script> |
| | | |
| | | </body> |
| | | </html> |
| | | |
| | | </html> |