| | |
| | | <Content Include="views\设å¤ç®¡ç\Sc_Add_MouldDotCheckBillList.html" /> |
| | | <Content Include="views\设å¤ç®¡ç\è®¾å¤æ¡£æ¡\Gy_EquipFileMainEdit.html" /> |
| | | <Content Include="views\设å¤ç®¡ç\è®¾å¤æ¡£æ¡\Gy_EquipFileMainList.html" /> |
| | | <Content Include="views\设å¤ç®¡ç\设å¤ç»´ä¿®æ´¾å·¥å\Sb_EquipRepairSendWorkBillList.html" /> |
| | | <Content Include="views\设å¤ç®¡ç\设å¤è§ç¨å\Sb_EquipDotCheckRuleEdit.html" /> |
| | | <Content Include="views\设å¤ç®¡ç\设å¤è§ç¨å\Sb_EquipDotCheckRuleList.html" /> |
| | | <Content Include="views\设å¤ç®¡ç\Sb_EquipMaintainBillList_MulEdit.html" /> |
| | |
| | | <dd><a lay-href="设å¤ç®¡ç/Sb_Add_EqpConkBookBillList.html">è®¾å¤æ
éç»è®°å</a></dd> |
| | | <dd><a lay-href="设å¤ç®¡ç/Sb_EqpConkBookBillList.html">è®¾å¤æ
éç»è®°åç»´æ¤</a></dd> |
| | | <dd><a lay-href="">设å¤ç»´ä¿®æ´¾å·¥ån</a></dd> |
| | | <dd><a lay-href="">设å¤ç»´ä¿®æ´¾å·¥åç»´æ¤n</a></dd> |
| | | <dd><a lay-href="设å¤ç®¡ç/设å¤ç»´ä¿®æ´¾å·¥å/Sb_EquipRepairSendWorkBillList.html">设å¤ç»´ä¿®æ´¾å·¥åç»´æ¤</a></dd> |
| | | <dd><a lay-href="设å¤ç®¡ç/Sb_Add_EqpMaintenanceBillList.html">设å¤ç»´ä¿®è®°å½å</a></dd> |
| | | <dd><a lay-href="设å¤ç®¡ç/Sb_EqpMaintenanceBillList.html">设å¤ç»´ä¿®è®°å½åç»´æ¤</a></dd> |
| | | <dd><a lay-href="设å¤ç®¡ç/Sb_Add_EqpRepairCheckBillList.html">设å¤ç»´ä¿®éªæ¶å</a></dd> |
| | |
| | | <label class="layui-form-label" style="width: 85px;">夿³¨</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="hidden" class="layui-input" name="HMaker" id="HMaker" lay-verify="HMaker" value=""> |
| | | <input type="hidden" class="layui-input" name="HUpDater" id="HUpDater" lay-verify="HUpDater" value=""> |
| | | <input type="text" class="layui-input" name="HRemark" id="HRemark" lay-verify="HRemark" placeholder="请è¾å
¥å
容" onmouseover="this.title=this.value"> |
| | | </div> |
| | | </div> |
| | |
| | | function set_ClearBill() { |
| | | //å¶å人 |
| | | $("#HMaker").val(sessionStorage["HUserName"]); |
| | | $("#HUpDater").val(sessionStorage["HUserName"]); |
| | | //åå§åæ¥æ |
| | | $("#HRepairBeginDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HRepairEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | } |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | |
| | | , { field: 'Hunitid', title: 'Hunitid', width: 200, hide: true } |
| | | //, { field: '计éåä½ä»£ç ', title: '计éåä½ä»£ç ', width: 125 } |
| | | //, { field: '计éåä½', title: '计éåä½', width: 125 } |
| | | , { field: 'HWHSonID', title: 'HWHSonID', width: 200, hide: true } |
| | | //, { field: 'åæä»åºä»£ç ', title: 'åæä»åºä»£ç ', width: 125 } |
| | | //, { field: 'åæä»åº', title: 'åæä»åº', width: 125 } |
| | | , { field: 'æ¶æä»åºID', title: 'æ¶æä»åºID', width: 200, hide: true } |
| | | , { field: 'æ¶æä»åºä»£ç ', title: 'æ¶æä»åºä»£ç ', width: 125 } |
| | | , { field: 'æ¶æä»åº', title: 'æ¶æä»åº', width: 125 } |
| | | , { field: 'HSPID', title: 'HSPID', width: 200, hide: true } |
| | | , { field: 'ä»ä½ä»£ç ', title: 'ä»ä½ä»£ç ', width: 125 } |
| | | , { field: 'ä»ä½', title: 'ä»ä½', width: 125 } |
| | |
| | | , { field: 'Hunitid', title: 'Hunitid', width: 200, hide: true } |
| | | //, { field: '计éåä½ä»£ç ', title: '计éåä½ä»£ç ', width: 125 } |
| | | //, { field: '计éåä½', title: '计éåä½', width: 125 } |
| | | , { field: 'HWHSonID', title: 'HWHSonID', width: 200, hide: true } |
| | | , { field: 'åæä»åºä»£ç ', title: 'åæä»åºä»£ç ', width: 125 } |
| | | , { field: 'åæä»åº', title: 'åæä»åº', width: 125 } |
| | | , { field: 'æ¶æä»åºID', title: 'æ¶æä»åºID', width: 200, hide: true } |
| | | , { field: 'æ¶æä»åºä»£ç ', title: 'æ¶æä»åºä»£ç ', width: 125 } |
| | | , { field: 'æ¶æä»åº', title: 'æ¶æä»åº', width: 125 } |
| | | , { field: 'HSPID', title: 'HSPID', width: 200, hide: true } |
| | | , { field: 'ä»ä½ä»£ç ', title: 'ä»ä½ä»£ç ', width: 125 } |
| | | , { field: 'ä»ä½', title: 'ä»ä½', width: 125 } |
| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¼å§æ¥æ</label> |
| | | <label class="layui-form-label">æ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HDate1" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | <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/zgqCustom/zgqCustom.js"></script> |
| | | <script> |
| | | var cols_arr = []; //åå¨è¡¨æ ¼å¤´çæ°ç» |
| | | var table = null; |
| | |
| | | var pageIndex = 1;//å½å页ç å¼ |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | | //åå§å表åæä»¶ |
| | | set_InitFrom(); |
| | | //åå§åçé¢ |
| | | set_ClearBill(sWhere); |
| | | //#endregion |
| | | |
| | | //#region åå§å表å |
| | | function set_InitFrom() { |
| | | laydate.render({ |
| | | elem: '#HDate' |
| | | }); |
| | | laydate.render({ |
| | | elem: '#HDate1' |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | | //åå§å表å |
| | | function set_InitFrom() { |
| | | laydate.render({ |
| | | elem: '#HDate' |
| | | }); |
| | | } |
| | | //åå§åçé¢ |
| | | function set_ClearBill(sWhere) { |
| | | resultTableHead = []; //æ¸
空表头åï¼é²æ¢é夿¸²æ |
| | | //åå§æ¥è¯¢ |
| | | //get_Display(sWhere); |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); |
| | | get_FastQuery(); |
| | | |
| | | get_Display(sWhere); |
| | | } |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(sWhere) { |
| | |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Sc_PackUnionBill/Get_PackUnionBillList', |
| | | type: "GET", |
| | | data: { "page": 1, "limit": 10 ,"sWhere": sWhere}, |
| | | data: { "sWhere": sWhere, "page": 1, "limit": 10 }, |
| | | datatype: "json", |
| | | success: function (data1) { |
| | | console.log(data1); |
| | |
| | | switch (data[i].Type) { |
| | | //int |
| | | case 'Int32': |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true,width: 100 }; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true }; |
| | | break; |
| | | //Decimal |
| | | case 'Decimal': |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true, width: 200 }; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true }; |
| | | break; |
| | | default: |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200}; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', sort: true }; |
| | | } |
| | | } |
| | | } |
| | | //å¡«å
è¡¨æ ¼æ°æ® |
| | | table.render({ |
| | | elem: '#mainTable', |
| | | toolbar: '#toolbarDemo', |
| | | url: GetWEBURL() + '/Sc_PackUnionBill/Get_PackUnionBillList', |
| | | toolbar: '#toolbarDemo', |
| | | title: 'ç»æåå表', |
| | | cols: cols_arr, //å¡«å
è¡¨æ ¼å¤´æ°æ®, |
| | | id: 'mainTable', //è¡¨æ ¼id |
| | |
| | | } |
| | | }); |
| | | } |
| | | //å é¤ |
| | | function set_DeleteBill() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | if (checkStatus.data.length === 1) { |
| | | var InterID = data[0].hmainid.toString(); |
| | | //é»è¾å 餿¹æ³ |
| | | layer.confirm("确认è¦å é¤åï¼å é¤åä¸è½æ¢å¤", { title: "å é¤ç¡®è®¤" }, function (index) { |
| | | var wait = layer.load(); |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Sc_PackUnionBill/set_DeleteBill", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | data: { "HInterID": InterID, "user": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () { |
| | | // å¾å°frameç´¢å¼ |
| | | var index = layer.getFrameIndex(window.name); |
| | | //å
³éå½åframe |
| | | layer.close(index); |
| | | //ä¿®æ¹ä¸ºååå·æ°çé¢ |
| | | window.location.reload(); |
| | | }); |
| | | |
| | | } else { |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | } |
| | | layer.close(wait); |
| | | }, error: function () { |
| | | layer.close(wait); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | }) |
| | | } |
| | | else { |
| | | layer.msg('è¯·éæ©ä¸è¡æ°æ®å é¤ï¼'); |
| | | } |
| | | } |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HDate = $("#HDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HDate1").val();//ç»ææ¥æ |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | var HDepartName = $("#HDepartName").val(); |
| | | var HMaterNumber = $("#HMaterNumber").val(); |
| | |
| | | var HMakerMan = $("#HMakerMan").val(); |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; |
| | | } |
| | | if (HDate1) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HDate1 + "'"; |
| | | } |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | |
| | | if (HMakerMan) { |
| | | sWhere += " and å¶å人 like '%" + HMakerMan + "%'"; |
| | | } |
| | | get_Display(sWhere); |
| | | set_ClearBill(sWhere); |
| | | sWhere = ""; |
| | | } |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBillNo").val(""); |
| | | $("#HDepartName").val(""); |
| | | $("#HMaterNumber").val(""); |
| | | $("#HMaterName").val(""); |
| | | $("#HMakerMan").val(""); |
| | | sWhere = " "; |
| | | get_FastQuery(); |
| | | sWhere = ""; |
| | | get_Display(sWhere); |
| | | } |
| | | //å·æ° |
| | | function set_Refresh() { |
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/layui/layui.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> |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | |
| | | <style type="text/css"> |
| | | input.layui-input.layui-unselect { |
| | | padding-right: 0; |
| | | } |
| | | </style> |
| | | </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 class="layui-collapse"> |
| | | <div class="layui-colla-item"> |
| | | <div class="layui-colla-title layui-inline"> |
| | | <div class="layui-inline"> |
| | | <span>æ´å¤</span> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¼å§æ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HBeginDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HEndDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">åæ®å·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <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> |
| | | <div class="layui-colla-content"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">é¨é¨</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æä»£ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="MaterialCode" id="MaterialCode" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <!--<hr />--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æåç§°</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="MaterialName" id="MaterialName" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è§æ ¼åå·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="SpecificationModel" id="SpecificationModel" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">æºååå·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HSourceBillNo" id="HSourceBillNo" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ä»åº</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="Warehouse" id="Warehouse" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¶å人</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="Hmaker" id="Hmaker" style="width:190px;"> |
| | | </div> |
| | | </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="btn-Add"><i class="layui-icon layui-icon-file-b"></i>æ°å¢</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></i>å é¤</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit"><i class="layui-icon layui-icon-radio"></i>å®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit"><i class="layui-icon layui-icon-circle"></i>åå®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view"><i class="layui-icon layui-icon-tips"></i>é¢è§</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>æå°</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | | <script> |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], 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 |
| | | //æ¥è¯¢æ¡ä»¶ |
| | | var sWhere = ""; |
| | | var option = []; |
| | | |
| | | //#endregion |
| | | |
| | | //#region åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | |
| | | // æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | //æ¸
ç©ºè¿æ»¤æ¡ä»¶ |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¤é¡µé¢ææçæ¹æ³ |
| | | // åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | //åå§åæ¥æ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | } |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , cellMinWidth: 90 |
| | | , cols: [[ |
| | | { type: 'checkbox', fixed: 'left' } |
| | | , { field: 'hmainid', title: 'hmainid', sort: true, hide: true } |
| | | , { field: 'æ¥æ', title: 'æ¥æ', width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'åæ®å·', title: 'åæ®å·', width: 200 } |
| | | , { field: 'åæ®ç±»å', title: 'åæ®ç±»å' } |
| | | , { field: 'é¨é¨ä»£ç ', title: 'é¨é¨ä»£ç ' } |
| | | , { field: 'ç»´ä¿®é¨é¨', title: 'ç»´ä¿®é¨é¨' } |
| | | , { field: '维修项ç®ä»£ç ', title: '维修项ç®ä»£ç ' } |
| | | , { field: '维修项ç®', title: '维修项ç®' } |
| | | , { field: 'é¢è®¡ç»´ä¿®å¼å§æ¥æ', title: 'é¢è®¡ç»´ä¿®å¼å§æ¥æ', width: 120, templet: "<div>{{d.ç»´ä¿®å¼å§æ¥æ ==null ?'':layui.util.toDateString(d.ç»´ä¿®å¼å§æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'é¢è®¡ç»´ä¿®ç»ææ¥æ', title: 'é¢è®¡ç»´ä¿®ç»ææ¥æ', width: 120, templet: "<div>{{d.ç»´ä¿®ç»ææ¥æ ==null ?'':layui.util.toDateString(d.ç»´ä¿®ç»ææ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'æ¶é´åä½', title: 'æ¶é´åä½' } |
| | | , { field: '计å维修工æ¶', title: '计å维修工æ¶' } |
| | | , { field: '维修人代ç ', title: '维修人代ç ' } |
| | | , { field: '维修人', title: '维修人' } |
| | | , { field: 'è´è´£äººä»£ç ', title: 'è´è´£äººä»£ç ' } |
| | | , { field: 'è´è´£äºº', title: 'è´è´£äºº' } |
| | | , { field: '表ä½ç»´ä¿®é¡¹ç®ä»£ç ', title: '表ä½ç»´ä¿®é¡¹ç®ä»£ç ' } |
| | | , { field: '表ä½ç»´ä¿®é¡¹ç®', title: '表ä½ç»´ä¿®é¡¹ç®' } |
| | | , { field: '表ä½è´è´£äººä»£ç ', title: '表ä½è´è´£äººä»£ç ' } |
| | | , { field: '表ä½è´è´£äºº', title: '表ä½è´è´£äºº' } |
| | | , { field: 'æè¦', title: 'æè¦' } |
| | | , { field: 'è¡¨å¤´å¤æ³¨', title: 'è¡¨å¤´å¤æ³¨' } |
| | | , { field: 'å
é¨åæ®å·', title: 'å
é¨åæ®å·' } |
| | | , { field: 'å¶å人', title: 'å¶å人', width: 125 } |
| | | , { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ', width: 120, templet: "<div>{{d.å¶åæ¥æ ==null ?'':layui.util.toDateString(d.å¶åæ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" } |
| | | , { field: 'å®¡æ ¸äºº', title: 'å®¡æ ¸äºº', width: 125 } |
| | | , { field: 'å®¡æ ¸æ¥æ', title: 'å®¡æ ¸æ¥æ', width: 120, templet: "<div>{{d.å®¡æ ¸æ¥æ ==null ?'':layui.util.toDateString(d.å®¡æ ¸æ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" } |
| | | , { field: 'ä¿®æ¹äºº', title: 'ä¿®æ¹äºº', width: 125 } |
| | | , { field: 'ä¿®æ¹æ¥æ', title: 'ä¿®æ¹æ¥æ', width: 200, templet: "<div>{{d.ä¿®æ¹æ¥æ ==null ?'':layui.util.toDateString(d.ä¿®æ¹æ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" } |
| | | , { field: 'å
³é人', title: 'å
³é人', width: 125 } |
| | | , { field: 'å
³éæ¥æ', title: 'å
³éæ¥æ', width: 120, templet: "<div>{{d.å
³éæ¥æ ==null ?'':layui.util.toDateString(d.å
³éæ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" } |
| | | , { field: 'å
³éç±»å', title: 'å
³éç±»å' } |
| | | , { field: 'ä½åºäºº', title: 'ä½åºäºº', width: 125 } |
| | | , { field: 'ä½åºæ¥æ', title: 'ä½åºæ¥æ', width: 120, templet: "<div>{{d.ä½åºæ¥æ ==null ?'':layui.util.toDateString(d.ä½åºæ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" } |
| | | ]] |
| | | }; |
| | | } |
| | | |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | function get_Display(sWhere) { |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Sb_EquipRepairSendWorkBill/GetEquipRepairSendWorkBillList', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | // å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HEndDate").val();//ç»ææ¥æ |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HDeptID = $("#HDeptID").val();//é¨é¨ |
| | | var MaterialCode = $("#MaterialCode").val();//ç©æä»£ç |
| | | var MaterialName = $("#MaterialName").val();//ç©æåç§° |
| | | var SpecificationModel = $("#SpecificationModel").val();//è§æ ¼åå· |
| | | var HSourceBillNo = $("#HSourceBillNo").val();//æºååå· |
| | | var Warehouse = $("#Warehouse").val();//ä»åº |
| | | var Hmaker = $("#Hmaker").val();//å¶å人 |
| | | |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; |
| | | } |
| | | if (HDate1) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HDate1 + "'"; |
| | | } |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | } |
| | | if (HDeptID) { |
| | | sWhere += " and ç»´ä¿®é¨é¨ like '%" + HDeptID + "%'"; |
| | | } |
| | | if (MaterialCode) { |
| | | sWhere += " and ç©æä»£ç like '%" + MaterialCode + "%'"; |
| | | } |
| | | if (MaterialName) { |
| | | sWhere += " and ç©æåç§° like '%" + MaterialName + "%'"; |
| | | } |
| | | if (SpecificationModel) { |
| | | sWhere += " and è§æ ¼åå· like '%" + SpecificationModel + "%'"; |
| | | } |
| | | if (HSourceBillNo) { |
| | | sWhere += " and æºååå· like '%" + HSourceBillNo + "%'"; |
| | | } |
| | | if (Warehouse) { |
| | | sWhere += " and åè´§ä»åº like '%" + Warehouse + "%'"; |
| | | } |
| | | if (Hmaker) { |
| | | sWhere += " and å¶å人 like '%" + Hmaker + "%'"; |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | |
| | | // éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBillNo").val("");//åæ®å· |
| | | $("#HDeptID").val("");//é¨é¨ |
| | | $("#MaterialCode").val("");//ç©æä»£ç |
| | | $("#MaterialName").val("");//ç©æåç§° |
| | | $("#SpecificationModel").val("");//è§æ ¼åå· |
| | | $("#HSourceBillNo").val("");//æºååå· |
| | | $("#Warehouse").val("");//ä»åº |
| | | $("#Hmaker").val("");//å¶å人 |
| | | |
| | | sWhere = ""; |
| | | } |
| | | |
| | | //#endregion |
| | | }); |
| | | </script> |
| | | </body> |
| | | </html> |