| | |
| | | <LastUsedBuildConfiguration>Debug</LastUsedBuildConfiguration> |
| | | <LastUsedPlatform>Any CPU</LastUsedPlatform> |
| | | <PublishProvider>FileSystem</PublishProvider> |
| | | <PublishUrl>D:\ç½ç«åå¸\æºäºMESWMS\LAYUI</PublishUrl> |
| | | <PublishUrl>E:\ç½ç«åå¸\LAYUI</PublishUrl> |
| | | <WebPublishMethod>FileSystem</WebPublishMethod> |
| | | <SiteUrlToLaunchAfterPublish /> |
| | | </PropertyGroup> |
| | |
| | | <Content Include="views\WMSæ«ç 模å\ç产管ç\çäº§ç»æå\Sc_PackUnionBill_PDA.html" /> |
| | | <Content Include="views\WMSæ«ç 模å\çäº§è°æ¨\è°æ¨æ¢æ\Kf_MoveStockBill_HuanTuo_PDA.html" /> |
| | | <Content Include="views\WMSæ«ç 模å\çäº§è°æ¨\è°æ¨æ¢æ\Kf_MoveStockBillList_HuanTuo_PDA.html" /> |
| | | <Content Include="views\ä»å管ç\æ¡ç æ¥è¡¨\Kf_MaterOutInReport.html" /> |
| | | <Content Include="views\ä»å管ç\æ¡ç æ¥è¡¨\Kf_ICInventory_Mater.html" /> |
| | | <Content Include="views\ä»å管ç\æ¡ç æ¥è¡¨\Kf_ICInventory_BarCode.html" /> |
| | | <Content Include="views\ä»å管ç\æ¡ç æ¥è¡¨\Kf_BarCodeOutInReport.html" /> |
| | | <Content Include="views\人äºç®¡ç\å
¥èç³è¯·\HR_EmpEngageRequestBill.html" /> |
| | | <Content Include="views\人äºç®¡ç\å
¥èç³è¯·\HR_EmpEngageRequestBillList.html" /> |
| | | <Content Include="views\人äºç®¡ç\离èç³è¯·\HR_EmpDimissionBill.html" /> |
| | |
| | | <?xml version="1.0" encoding="utf-8"?> |
| | | <Project ToolsVersion="12.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
| | | <PropertyGroup> |
| | | <NameOfLastUsedPublishProfile>D:\ç½ç«åå¸\å端代ç \MES-WEB-TM\MESWMS-LayUI\WebTM\Properties\PublishProfiles\JFTM.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\GITä»åº\MESWMS-LayUI\WebTM\Properties\PublishProfiles\JFTM.pubxml</NameOfLastUsedPublishProfile> |
| | | <ProjectView>ProjectFiles</ProjectView> |
| | | <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> |
| | | <UseIISExpress>true</UseIISExpress> |
| | |
| | | //var WEBURL = "http://192.168.16.80:8011/"; //åå
¬å®¤æå¡å¨ |
| | | //var WEBURL = "http://localhost:8081/SWEAPI/"; //chæ¬å°*/ |
| | | //var WEBURL = "http://61.164.86.218:8099/ABAPI/"; |
| | | //var WEBURL = "http://localhost/API/"; //颿忬å°é
ç½® |
| | | var WEBURL = "http://localhost/API/"; //颿忬å°é
ç½® |
| | | //var WEBURL = "http://localhost/WEBAPI/"; //é¢å®¶å°å¼æºæ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/lubao"; //颿忬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/LuBaoAPI/"; //æ¨ä¹æ¬å°é
ç½® |
| | | var WEBURL = "http://localhost:8082/API/"; //æè´ºæ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/API/"; //æè´ºæ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8082/LuBaoAPI/"; //ä½ææ°æ¬å°é
ç½® |
| | | //var WEBURL = "http://localhost:8088/ARAPI/"; //ä½ææ°æ¬å°é
ç½®(å®ç) |
| | | //var WEBURL = "http://10.1.4.155/API/"; //æ±ä¸°å®¢æ·NEW |
| | |
| | | //var WEBURL = "http://192.168.80.90:9090/API/"; //å®çæå¡å¨ |
| | | //var WEBURL = "http://192.168.16.53:8081/API/"; //é¾å±±æ±½é
|
| | | //var WEBURL = "http://122.227.158.218:8090/API/"; //é¾å±±æ±½é
å¤ç½ |
| | | //var WEBURL = "http://192.168.0.244:8082/API/"; //å¸
å¨å
ç½ |
| | | //var WEBURL = "http://192.168.0.244:8082/API/"; //å¸
å¨å
ç½ |
| | | return WEBURL |
| | | } |
| | | |
| | |
| | | <!DOCTYPE html> |
| | | <html> |
| | | <head> |
| | | < |
| | | <meta charset="utf-8"> |
| | | <title>æ§å¶å°ä¸»é¡µä¸</title> |
| | | <meta name="renderer" content="webkit"> |
| | |
| | | <a>ä»åºæ¥è¡¨</a> |
| | | <dl class="layui-nav-child"> |
| | | <dd><a lay-href="ä»å管ç/æ«ç å¼å¸¸è®°å½è¡¨/KF_PonderationBillList.html">æ«ç å¼å¸¸è®°å½æ¥è¯¢</a></dd> |
| | | <dd><a lay-href="ä»å管ç/æ¡ç åºå
¥åºè®°å½è¡¨/Kf_ICStockBillSubList.html">æ¡ç åºå
¥åºè®°å½è¡¨</a></dd> |
| | | <dd><a lay-href="ä»å管ç/æ¡ç åºå/KF_ICInventoryList_WMS.html">æ¡ç åºåæ¥è¯¢</a></dd> |
| | | <dd><a lay-href="ä»å管ç/æ¡ç æ¥è¡¨/Kf_BarCodeOutInReport.html">æ¡ç åºå
¥åºè®°å½è¡¨</a></dd> |
| | | <dd><a lay-href="ä»å管ç/æ¡ç æ¥è¡¨/Kf_ICInventory_BarCode.html">æ¡ç åºåæ¥è¯¢æ¥è¡¨</a></dd> |
| | | <dd><a lay-href="ä»å管ç/æ¡ç æ¥è¡¨/Kf_MaterOutInReport.html">WMSç©æåºå
¥åºè®°å½è¡¨</a></dd> |
| | | <dd><a lay-href="ä»å管ç/æ¡ç æ¥è¡¨/Kf_ICInventory_Mater.html">WMSç©æåºåæ¥è¯¢æ¥è¡¨</a></dd> |
| | | <dd><a lay-href="ä»å管ç/æ¡ç åºå/KF_PonderationBillMain_Temp.html">æ¡ç åºå
¥åºç¼åå表</a></dd> |
| | | <dd><a lay-href="ä»å管ç/æ¡ç åºå
¥åºè®°å½è¡¨/KF_PonderationBillList_Query.html">æ«ç è®°å½ç¼åæ¥è¡¨</a></dd> |
| | | </dl> |
| | |
| | | <dd><a lay-href="计å管ç/å·¥èºè·¯çº¿/Gy_RoutingBillList.html">å·¥èºè·¯çº¿ç»´æ¤</a></dd> |
| | | <dd><a lay-href="计å管ç/å·¥èºè·¯çº¿/Gy_RoutingBillListQuery.html">å·¥èºè·¯çº¿æ¥è¯¢</a></dd> |
| | | <dd><a lay-href="计å管ç/å·¥èºè·¯çº¿/Gy_RoutingBill.html">å·¥èºè·¯çº¿</a></dd> |
| | | <dd><a lay-href="计å管ç/å·¥èºè·¯çº¿/Gy_RoutingBillList_His.html">å·¥èºè·¯çº¿åå²è®°å½</a></dd> |
| | | <dd><a lay-href="计å管ç/å·¥èºè·¯çº¿/Gy_RoutingBillimport.html">å·¥èºè·¯çº¿æ°æ®å¯¼å
¥</a></dd> |
| | | </dl> |
| | | </dd> |
New file |
| | |
| | | <!DOCTYPE html> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>æ¡ç åºå
¥åºè®°å½</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> |
| | | <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/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 src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/HideButton.js"></script> |
| | | <style> |
| | | .layui-form-select .layui-input { |
| | | padding-right: 15px; |
| | | cursor: pointer; |
| | | } |
| | | </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" style="width: 85px;">åæ®ç±»å</label> |
| | | <div class="layui-input-block" style="margin-left: 120px; width: 185px;"> |
| | | <select name="HBillType" id="HBillType" lay-verify="HBillType"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </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: 185px;"> |
| | | <select name="HStockOrgID" id="HStockOrgID" lay-verify="HStockOrgID"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <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-row"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HMater" id="HMater" 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="HBatchNo" id="HBatchNo" 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="HBarCode" id="HBarCode" 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> |
| | | </div> |
| | | <div class="layui-row" style="margin-top:5px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ä»åº</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HWHName" id="HWHName" 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="HSPName" id="HSPName" 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="HMaker" id="HMaker" style="width:190px;"> |
| | | </div> |
| | | </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_Export" id="Export"><i class="layui-icon layui-icon-export"></i>导åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Query" id="Query"><i class="layui-icon layui-icon-search"></i>æ¥è¯¢</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Cell" id="Cell"><i class="layui-icon layui-icon-slider"></i>ä¿åå宽</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-RefreshCell" id="RefreshCell"><i class="layui-icon layui-icon-cols"></i>é»è®¤å宽</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <script> |
| | | //#region æå 注é |
| | | //#endregion |
| | | 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 |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | var columns = ""; |
| | | var HModName = "Kf_BarCodeOutInReport"; |
| | | var titleData = []; //ä¸éè¦æ¾ç¤ºçåæ®µ |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //è·åå¼å§æ¥æãç»ææ¥æ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //è·åç»ç» |
| | | Organ(); |
| | | //è·ååæ®ç±»å |
| | | BillType(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·åç»ç» |
| | | function Organ() { |
| | | //è·åç»å½é¡µç»ç»å |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Web/GetOrganizations", |
| | | async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ± |
| | | success: function (result) { |
| | | var Organization = ""; |
| | | Organization += '<option style="color:blue;" value="å
¨é¨">å
¨é¨</option>'; |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | Organization += '<option style="color:blue;" value="' + data[i].Name + '">' + data[i].Name + '</option>'; |
| | | } |
| | | $("#HStockOrgID").append(Organization); |
| | | $("#HStockOrgID").val(sessionStorage["Organization"]) |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·ååæ®ç±»å |
| | | function BillType() { |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/WEBSController/GetBarCodeReport_BillType_Json", |
| | | async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ± |
| | | success: function (result) { |
| | | var HBillType = ""; |
| | | HBillType += '<option style="color:blue;" value="å
¨é¨">å
¨é¨</option>'; |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HBillType += '<option style="color:blue;" value="' + data[i].HBillTypeName + '">' + data[i].HBillTypeName + '</option>'; |
| | | } |
| | | $("#HBillType").append(HBillType); |
| | | $("#HBillType").val("å
¨é¨") |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#region åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , page: true |
| | | , totalRow: true |
| | | , height: 'full-50' |
| | | , cellMinWidth: 90 |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | }; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·åå宽 |
| | | function getColumnsWidth() { |
| | | var result = []; |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | //è·åå宽 |
| | | $.ajax({ |
| | | type: "Get", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidthList', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "colNum": colNum, "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.code == 1) { |
| | | result = data1.data; |
| | | } |
| | | else if (data1.code == -1) { |
| | | |
| | | } |
| | | else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | return result; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¾ç¤ºåæ°æ® |
| | | function DisPlay_HideColumn() { |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', |
| | | async: false, |
| | | data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.data.length != 0) { |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option.cols[0].length - 2; i++) { |
| | | if (dataCol[i]) { |
| | | var dataCols = dataCol[i].split('|'); |
| | | } |
| | | //éèå |
| | | if (dataCols[1] == 1) { |
| | | option.cols[0][i + 1]["hide"] = true; |
| | | } |
| | | ////设置å宽 |
| | | //if (dataCols[3] > 0) { |
| | | // option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | //} |
| | | //设置å
容åä½å¤§å° |
| | | if (data1.data[0].HFontSize != 0) { |
| | | option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; |
| | | } else { |
| | | option.cols[0][i + 1]["style"] = "font-size:100%"; |
| | | } |
| | | //æ¾ç¤ºå |
| | | if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { |
| | | option.cols[0][i + 1]["hide"] = false; |
| | | } |
| | | //å使å¨ä½ç½®(å·¦ å±
ä¸ å³) |
| | | switch (dataCols[2]) { |
| | | case "L": |
| | | option.cols[0][i + 1]["align"] = "left"; |
| | | break; |
| | | case "M": |
| | | option.cols[0][i + 1]["align"] = "center"; |
| | | break; |
| | | case "R": |
| | | option.cols[0][i + 1]["align"] = "right"; |
| | | break; |
| | | } |
| | | } |
| | | |
| | | //åæ¶å»ç»å |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | if (option.cols[0][i]["fixed"] != null) { |
| | | option.cols[0][i]["fixed"] = null; |
| | | } |
| | | else { |
| | | break; |
| | | } |
| | | } |
| | | //å»ç»å |
| | | if (data1.data[0].HFixCols != 0) { |
| | | for (var i = 0; i < data1.data[0].HFixCols; i++) { |
| | | if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { |
| | | data1.data[0].HFixCols += 1; |
| | | } |
| | | option.cols[0][i + 1]["fixed"] = "left"; |
| | | } |
| | | } |
| | | table.render(option); |
| | | } else { |
| | | table.render(option); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³ |
| | | |
| | | //#region å·¥å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //å¯¼åºæé® |
| | | case 'btn_Export': get_Export(); |
| | | break; |
| | | //æ¥è¯¢æé® |
| | | case 'btn_Query': get_Display(); |
| | | break; |
| | | //éåºæé® |
| | | case 'btn_Exit': Pub_Close(2); |
| | | break; |
| | | //ä¿åå宽æé® |
| | | case 'btn-Cell': set_SaveGridColWidth(); |
| | | break; |
| | | //é»è®¤å宽æé® |
| | | case 'btn-RefreshCell': set_DefaultGridColWidth(); |
| | | break; |
| | | //å设置 |
| | | case 'btn_HideColumn': get_HideColumn(); |
| | | break; |
| | | }; |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region 导åºExecel |
| | | function get_Export() { |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢ |
| | | function get_Display() { |
| | | var HBeginDate = $("#HBeginDate").val(); //å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val(); //ç»ææ¥æ |
| | | var HBillType = $("#HBillType").val(); //åæ®ç±»å |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | var HBarCode = $("#HBarCode").val(); //æ¡ç ç¼å· |
| | | var HMater = $("#HMater").val(); //ç©æ |
| | | var HBatchNo = $("#HBatchNo").val(); //æ¹å· |
| | | var HWHName = $("#HWHName").val(); //ä»åº |
| | | var HSPName = $("#HSPName").val(); //ä»ä½ |
| | | var HSourceBillNo = $("#HSourceBillNo").val(); //æºååå· |
| | | var HMaker = $("#HMaker").val(); //å¶å人 |
| | | var HStockOrgName = $("#HStockOrgID").val(); //ç»ç» |
| | | |
| | | sWhere = "'" + HBeginDate + "','" + HEndDate + "','" + HBillType + "','" + HBillNo + "','" + HBarCode + "','" + HMater + "','" + HBatchNo + "','" + HWHName + "','" + HSPName + "','" + HSourceBillNo + "','" + HMaker + "','" + HStockOrgName + "'"; |
| | | |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + '/WEBSController/GetKf_BarCodeOutInReport_Json', |
| | | async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ± |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | 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 ($.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; |
| | | default: |
| | | if (data[i].name == 'æ°é') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true }); |
| | | } else { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true }); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | columns = col; |
| | | |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | option.cols = [columns]; |
| | | option.data = data1.data; |
| | | option.totalRow = true; |
| | | table.render(option); |
| | | ins = table.render(option); |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | DisPlay_HideColumn(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | //æ¸
ç©ºè¿æ»¤æ¡ä»¶ |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | 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")); //ç»ææ¥æ |
| | | $("#HBillType").val("å
¨é¨"); //åæ®ç±»å |
| | | $("#HMater").val(""); //ç©æ |
| | | $("#HBatchNo").val(""); //æ¹å· |
| | | $("#HBarCode").val(""); //æ¡ç ç¼å· |
| | | $("#HBillNo").val(""); //åæ®å· |
| | | $("#HWHName").val(""); //ä»åº |
| | | $("#HSPName").val(""); //ä»ä½ |
| | | $("#HSourceBillNo").val(""); //æºååå· |
| | | $("#HMaker").val(""); //å¶å人 |
| | | $("#HStockOrgID").val(sessionStorage["Organization"]) //ç»ç» |
| | | form.render('select'); |
| | | } |
| | | |
| | | //#endregion |
| | | |
| | | //#region ä¿åå宽 |
| | | function set_SaveGridColWidth() { |
| | | var arr = []; |
| | | // åæ° |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | for (var i = 0; i <= colNum; i++) { |
| | | var colName = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).text(); |
| | | var colWidth = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).width(); |
| | | if (colName != "" && colName != null) { |
| | | arr.push(colWidth == -1 ? 200 : colWidth); |
| | | } |
| | | } |
| | | arr.unshift(40); //é¦ä½è¿½å |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidth', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "myMap": JSON.stringify(arr), "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | //layer.alert(data1.Message, { icon: 1 }); |
| | | } else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | //location.reload(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region é»è®¤å宽 |
| | | function set_DefaultGridColWidth() { |
| | | var arr = []; |
| | | // åæ° |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | for (var i = 0; i <= colNum; i++) { |
| | | var colName = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).text(); |
| | | if (colName != "" && colName != null) { |
| | | arr.push(200); //é»è®¤å®½åº¦200 |
| | | } |
| | | } |
| | | arr.unshift(40); //é¦ä½è¿½å |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidth', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "myMap": JSON.stringify(arr), "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | |
| | | } else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | location.reload(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éèå设置" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | //æ´æ°è¡¨æ ¼ç¼åçæ°æ® |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | </script> |
| | | |
| | | </body> |
| | | </html> |
New file |
| | |
| | | <!DOCTYPE html> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>æ¡ç åºåæ¥è¯¢æ¥è¡¨</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> |
| | | <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/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 src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/HideButton.js"></script> |
| | | <style> |
| | | .layui-form-select .layui-input { |
| | | padding-right: 15px; |
| | | cursor: pointer; |
| | | } |
| | | </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="text" class="layui-input" name="HBarCode" id="HBarCode" 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="HMater" id="HMater" 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="HBatchNo" id="HBatchNo" style="width:190px;"> |
| | | </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: 185px;"> |
| | | <select name="HStockOrgID" id="HStockOrgID" lay-verify="HStockOrgID"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <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-row"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¾
å©å±æ§</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HAuxProp" id="HAuxProp" 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="HWHName" id="HWHName" 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="HSPName" id="HSPName" style="width:190px;"> |
| | | </div> |
| | | </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_Export" id="Export"><i class="layui-icon layui-icon-export"></i>导åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Query" id="Query"><i class="layui-icon layui-icon-search"></i>æ¥è¯¢</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Cell" id="Cell"><i class="layui-icon layui-icon-slider"></i>ä¿åå宽</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-RefreshCell" id="RefreshCell"><i class="layui-icon layui-icon-cols"></i>é»è®¤å宽</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <script> |
| | | //#region æå 注é |
| | | //#endregion |
| | | 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 |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | var columns = ""; |
| | | var HModName = "Kf_ICInventory_BarCode"; |
| | | var titleData = []; //ä¸éè¦æ¾ç¤ºçåæ®µ |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //è·åç»ç» |
| | | Organ(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·åç»ç» |
| | | function Organ() { |
| | | //è·åç»å½é¡µç»ç»å |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Web/GetOrganizations", |
| | | async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ± |
| | | success: function (result) { |
| | | var Organization = ""; |
| | | Organization += '<option style="color:blue;" value="å
¨é¨">å
¨é¨</option>'; |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | Organization += '<option style="color:blue;" value="' + data[i].Name + '">' + data[i].Name + '</option>'; |
| | | } |
| | | $("#HStockOrgID").append(Organization); |
| | | $("#HStockOrgID").val(sessionStorage["Organization"]) |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#region åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , page: true |
| | | , totalRow: true |
| | | , height: 'full-50' |
| | | , cellMinWidth: 90 |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | }; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·åå宽 |
| | | function getColumnsWidth() { |
| | | var result = []; |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | //è·åå宽 |
| | | $.ajax({ |
| | | type: "Get", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidthList', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "colNum": colNum, "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.code == 1) { |
| | | result = data1.data; |
| | | } |
| | | else if (data1.code == -1) { |
| | | |
| | | } |
| | | else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | return result; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¾ç¤ºåæ°æ® |
| | | function DisPlay_HideColumn() { |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', |
| | | async: false, |
| | | data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.data.length != 0) { |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option.cols[0].length - 2; i++) { |
| | | if (dataCol[i]) { |
| | | var dataCols = dataCol[i].split('|'); |
| | | } |
| | | //éèå |
| | | if (dataCols[1] == 1) { |
| | | option.cols[0][i + 1]["hide"] = true; |
| | | } |
| | | ////设置å宽 |
| | | //if (dataCols[3] > 0) { |
| | | // option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | //} |
| | | //设置å
容åä½å¤§å° |
| | | if (data1.data[0].HFontSize != 0) { |
| | | option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; |
| | | } else { |
| | | option.cols[0][i + 1]["style"] = "font-size:100%"; |
| | | } |
| | | //æ¾ç¤ºå |
| | | if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { |
| | | option.cols[0][i + 1]["hide"] = false; |
| | | } |
| | | //å使å¨ä½ç½®(å·¦ å±
ä¸ å³) |
| | | switch (dataCols[2]) { |
| | | case "L": |
| | | option.cols[0][i + 1]["align"] = "left"; |
| | | break; |
| | | case "M": |
| | | option.cols[0][i + 1]["align"] = "center"; |
| | | break; |
| | | case "R": |
| | | option.cols[0][i + 1]["align"] = "right"; |
| | | break; |
| | | } |
| | | } |
| | | |
| | | //åæ¶å»ç»å |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | if (option.cols[0][i]["fixed"] != null) { |
| | | option.cols[0][i]["fixed"] = null; |
| | | } |
| | | else { |
| | | break; |
| | | } |
| | | } |
| | | //å»ç»å |
| | | if (data1.data[0].HFixCols != 0) { |
| | | for (var i = 0; i < data1.data[0].HFixCols; i++) { |
| | | if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { |
| | | data1.data[0].HFixCols += 1; |
| | | } |
| | | option.cols[0][i + 1]["fixed"] = "left"; |
| | | } |
| | | } |
| | | table.render(option); |
| | | } else { |
| | | table.render(option); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³ |
| | | |
| | | //#region å·¥å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //å¯¼åºæé® |
| | | case 'btn_Export': get_Export(); |
| | | break; |
| | | //æ¥è¯¢æé® |
| | | case 'btn_Query': get_Display(); |
| | | break; |
| | | //éåºæé® |
| | | case 'btn_Exit': Pub_Close(2); |
| | | break; |
| | | //ä¿åå宽æé® |
| | | case 'btn-Cell': set_SaveGridColWidth(); |
| | | break; |
| | | //é»è®¤å宽æé® |
| | | case 'btn-RefreshCell': set_DefaultGridColWidth(); |
| | | break; |
| | | //å设置 |
| | | case 'btn_HideColumn': get_HideColumn(); |
| | | break; |
| | | }; |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region 导åºExecel |
| | | function get_Export() { |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢ |
| | | function get_Display() { |
| | | var HBarCode = $("#HBarCode").val(); //æ¡ç ç¼å· |
| | | var HMater = $("#HMater").val(); //ç©æ |
| | | var HAuxProp = $("#HAuxProp").val(); //è¾
å©å±æ§ |
| | | var HBatchNo = $("#HBatchNo").val(); //æ¹å· |
| | | var HWHName = $("#HWHName").val(); //ä»åº |
| | | var HSPName = $("#HSPName").val(); //ä»ä½ |
| | | var HStockOrgName = $("#HStockOrgID").val(); //ç»ç» |
| | | |
| | | sWhere = "'" + HBarCode + "','" + HMater + "','" + HAuxProp + "','" + HBatchNo + "','" + HWHName + "','" + HSPName + "','" + HStockOrgName + "'"; |
| | | |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + '/WEBSController/GetKf_BarCodeICInventoryReport_Json', |
| | | async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ± |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | 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 ($.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; |
| | | default: |
| | | if (data[i].name == 'æ°é') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true }); |
| | | } else { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true }); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | columns = col; |
| | | |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | option.cols = [columns]; |
| | | option.data = data1.data; |
| | | option.totalRow = true; |
| | | table.render(option); |
| | | ins = table.render(option); |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | DisPlay_HideColumn(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | //æ¸
ç©ºè¿æ»¤æ¡ä»¶ |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HBarCode").val(""); //æ¡ç ç¼å· |
| | | $("#HMater").val(""); //ç©æ |
| | | $("#HAuxProp").val(""); //è¾
å©å±æ§ |
| | | $("#HBatchNo").val(""); //æ¹å· |
| | | $("#HWHName").val(""); //ä»åº |
| | | $("#HSPName").val(""); //ä»ä½ |
| | | $("#HStockOrgID").val(sessionStorage["Organization"]) //ç»ç» |
| | | form.render('select'); |
| | | } |
| | | |
| | | //#endregion |
| | | |
| | | //#region ä¿åå宽 |
| | | function set_SaveGridColWidth() { |
| | | var arr = []; |
| | | // åæ° |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | for (var i = 0; i <= colNum; i++) { |
| | | var colName = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).text(); |
| | | var colWidth = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).width(); |
| | | if (colName != "" && colName != null) { |
| | | arr.push(colWidth == -1 ? 200 : colWidth); |
| | | } |
| | | } |
| | | arr.unshift(40); //é¦ä½è¿½å |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidth', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "myMap": JSON.stringify(arr), "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | //layer.alert(data1.Message, { icon: 1 }); |
| | | } else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | //location.reload(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region é»è®¤å宽 |
| | | function set_DefaultGridColWidth() { |
| | | var arr = []; |
| | | // åæ° |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | for (var i = 0; i <= colNum; i++) { |
| | | var colName = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).text(); |
| | | if (colName != "" && colName != null) { |
| | | arr.push(200); //é»è®¤å®½åº¦200 |
| | | } |
| | | } |
| | | arr.unshift(40); //é¦ä½è¿½å |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidth', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "myMap": JSON.stringify(arr), "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | |
| | | } else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | location.reload(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éèå设置" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | //æ´æ°è¡¨æ ¼ç¼åçæ°æ® |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | </script> |
| | | |
| | | </body> |
| | | </html> |
New file |
| | |
| | | <!DOCTYPE html> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>WMSç©æåºåæ¥è¯¢æ¥è¡¨</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> |
| | | <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/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 src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/HideButton.js"></script> |
| | | <style> |
| | | .layui-form-select .layui-input { |
| | | padding-right: 15px; |
| | | cursor: pointer; |
| | | } |
| | | </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="text" class="layui-input" name="HMater" id="HMater" 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="HBatchNo" id="HBatchNo" 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="HWHName" id="HWHName" style="width:190px;"> |
| | | </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: 185px;"> |
| | | <select name="HStockOrgID" id="HStockOrgID" lay-verify="HStockOrgID"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <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-row"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¾
å©å±æ§</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HAuxProp" id="HAuxProp" 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="HSPName" id="HSPName" style="width:190px;"> |
| | | </div> |
| | | </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_Export" id="Export"><i class="layui-icon layui-icon-export"></i>导åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Query" id="Query"><i class="layui-icon layui-icon-search"></i>æ¥è¯¢</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Cell" id="Cell"><i class="layui-icon layui-icon-slider"></i>ä¿åå宽</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-RefreshCell" id="RefreshCell"><i class="layui-icon layui-icon-cols"></i>é»è®¤å宽</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <script> |
| | | //#region æå 注é |
| | | //#endregion |
| | | 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 |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | var columns = ""; |
| | | var HModName = "Kf_ICInventory_Mater"; |
| | | var titleData = []; //ä¸éè¦æ¾ç¤ºçåæ®µ |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //è·åç»ç» |
| | | Organ(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·åç»ç» |
| | | function Organ() { |
| | | //è·åç»å½é¡µç»ç»å |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Web/GetOrganizations", |
| | | async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ± |
| | | success: function (result) { |
| | | var Organization = ""; |
| | | Organization += '<option style="color:blue;" value="å
¨é¨">å
¨é¨</option>'; |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | Organization += '<option style="color:blue;" value="' + data[i].Name + '">' + data[i].Name + '</option>'; |
| | | } |
| | | $("#HStockOrgID").append(Organization); |
| | | $("#HStockOrgID").val(sessionStorage["Organization"]) |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#region åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , page: true |
| | | , totalRow: true |
| | | , height: 'full-50' |
| | | , cellMinWidth: 90 |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | }; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·åå宽 |
| | | function getColumnsWidth() { |
| | | var result = []; |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | //è·åå宽 |
| | | $.ajax({ |
| | | type: "Get", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidthList', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "colNum": colNum, "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.code == 1) { |
| | | result = data1.data; |
| | | } |
| | | else if (data1.code == -1) { |
| | | |
| | | } |
| | | else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | return result; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¾ç¤ºåæ°æ® |
| | | function DisPlay_HideColumn() { |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', |
| | | async: false, |
| | | data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.data.length != 0) { |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option.cols[0].length - 2; i++) { |
| | | if (dataCol[i]) { |
| | | var dataCols = dataCol[i].split('|'); |
| | | } |
| | | //éèå |
| | | if (dataCols[1] == 1) { |
| | | option.cols[0][i + 1]["hide"] = true; |
| | | } |
| | | ////设置å宽 |
| | | //if (dataCols[3] > 0) { |
| | | // option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | //} |
| | | //设置å
容åä½å¤§å° |
| | | if (data1.data[0].HFontSize != 0) { |
| | | option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; |
| | | } else { |
| | | option.cols[0][i + 1]["style"] = "font-size:100%"; |
| | | } |
| | | //æ¾ç¤ºå |
| | | if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { |
| | | option.cols[0][i + 1]["hide"] = false; |
| | | } |
| | | //å使å¨ä½ç½®(å·¦ å±
ä¸ å³) |
| | | switch (dataCols[2]) { |
| | | case "L": |
| | | option.cols[0][i + 1]["align"] = "left"; |
| | | break; |
| | | case "M": |
| | | option.cols[0][i + 1]["align"] = "center"; |
| | | break; |
| | | case "R": |
| | | option.cols[0][i + 1]["align"] = "right"; |
| | | break; |
| | | } |
| | | } |
| | | |
| | | //åæ¶å»ç»å |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | if (option.cols[0][i]["fixed"] != null) { |
| | | option.cols[0][i]["fixed"] = null; |
| | | } |
| | | else { |
| | | break; |
| | | } |
| | | } |
| | | //å»ç»å |
| | | if (data1.data[0].HFixCols != 0) { |
| | | for (var i = 0; i < data1.data[0].HFixCols; i++) { |
| | | if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { |
| | | data1.data[0].HFixCols += 1; |
| | | } |
| | | option.cols[0][i + 1]["fixed"] = "left"; |
| | | } |
| | | } |
| | | table.render(option); |
| | | } else { |
| | | table.render(option); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³ |
| | | |
| | | //#region å·¥å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //å¯¼åºæé® |
| | | case 'btn_Export': get_Export(); |
| | | break; |
| | | //æ¥è¯¢æé® |
| | | case 'btn_Query': get_Display(); |
| | | break; |
| | | //éåºæé® |
| | | case 'btn_Exit': Pub_Close(2); |
| | | break; |
| | | //ä¿åå宽æé® |
| | | case 'btn-Cell': set_SaveGridColWidth(); |
| | | break; |
| | | //é»è®¤å宽æé® |
| | | case 'btn-RefreshCell': set_DefaultGridColWidth(); |
| | | break; |
| | | //å设置 |
| | | case 'btn_HideColumn': get_HideColumn(); |
| | | break; |
| | | }; |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region 导åºExecel |
| | | function get_Export() { |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢ |
| | | function get_Display() { |
| | | var HMater = $("#HMater").val(); //ç©æ |
| | | var HAuxProp = $("#HAuxProp").val(); //è¾
å©å±æ§ |
| | | var HBatchNo = $("#HBatchNo").val(); //æ¹å· |
| | | var HWHName = $("#HWHName").val(); //ä»åº |
| | | var HSPName = $("#HSPName").val(); //ä»ä½ |
| | | var HStockOrgName = $("#HStockOrgID").val(); //ç»ç» |
| | | |
| | | sWhere = "'" + HMater + "','" + HAuxProp + "','" + HBatchNo + "','" + HWHName + "','" + HSPName + "','" + HStockOrgName + "'"; |
| | | |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + '/WEBSController/GetKf_MaterICInventoryReport_Json', |
| | | async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ± |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | 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 ($.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; |
| | | default: |
| | | if (data[i].name == 'æ°é') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true }); |
| | | } else { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true }); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | columns = col; |
| | | |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | option.cols = [columns]; |
| | | option.data = data1.data; |
| | | option.totalRow = true; |
| | | table.render(option); |
| | | ins = table.render(option); |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | DisPlay_HideColumn(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | //æ¸
ç©ºè¿æ»¤æ¡ä»¶ |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HMater").val(""); //ç©æ |
| | | $("#HAuxProp").val(""); //è¾
å©å±æ§ |
| | | $("#HBatchNo").val(""); //æ¹å· |
| | | $("#HWHName").val(""); //ä»åº |
| | | $("#HSPName").val(""); //ä»ä½ |
| | | $("#HStockOrgID").val(sessionStorage["Organization"]) //ç»ç» |
| | | form.render('select'); |
| | | } |
| | | |
| | | //#endregion |
| | | |
| | | //#region ä¿åå宽 |
| | | function set_SaveGridColWidth() { |
| | | var arr = []; |
| | | // åæ° |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | for (var i = 0; i <= colNum; i++) { |
| | | var colName = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).text(); |
| | | var colWidth = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).width(); |
| | | if (colName != "" && colName != null) { |
| | | arr.push(colWidth == -1 ? 200 : colWidth); |
| | | } |
| | | } |
| | | arr.unshift(40); //é¦ä½è¿½å |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidth', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "myMap": JSON.stringify(arr), "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | //layer.alert(data1.Message, { icon: 1 }); |
| | | } else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | //location.reload(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region é»è®¤å宽 |
| | | function set_DefaultGridColWidth() { |
| | | var arr = []; |
| | | // åæ° |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | for (var i = 0; i <= colNum; i++) { |
| | | var colName = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).text(); |
| | | if (colName != "" && colName != null) { |
| | | arr.push(200); //é»è®¤å®½åº¦200 |
| | | } |
| | | } |
| | | arr.unshift(40); //é¦ä½è¿½å |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidth', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "myMap": JSON.stringify(arr), "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | |
| | | } else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | location.reload(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éèå设置" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | //æ´æ°è¡¨æ ¼ç¼åçæ°æ® |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | </script> |
| | | |
| | | </body> |
| | | </html> |
New file |
| | |
| | | <!DOCTYPE html> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>WMSç©æåºå
¥åºè®°å½</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> |
| | | <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/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 src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/HideButton.js"></script> |
| | | <style> |
| | | .layui-form-select .layui-input { |
| | | padding-right: 15px; |
| | | cursor: pointer; |
| | | } |
| | | </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" style="width: 85px;">åæ®ç±»å</label> |
| | | <div class="layui-input-block" style="margin-left: 120px; width: 185px;"> |
| | | <select name="HBillType" id="HBillType" lay-verify="HBillType"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </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: 185px;"> |
| | | <select name="HStockOrgID" id="HStockOrgID" lay-verify="HStockOrgID"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <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-row"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HMater" id="HMater" 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="HBatchNo" id="HBatchNo" 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> |
| | | </div> |
| | | <div class="layui-row" style="margin-top:5px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ä»åº</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HWHName" id="HWHName" 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="HSPName" id="HSPName" 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="HMaker" id="HMaker" style="width:190px;"> |
| | | </div> |
| | | </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_Export" id="Export"><i class="layui-icon layui-icon-export"></i>导åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Query" id="Query"><i class="layui-icon layui-icon-search"></i>æ¥è¯¢</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Cell" id="Cell"><i class="layui-icon layui-icon-slider"></i>ä¿åå宽</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-RefreshCell" id="RefreshCell"><i class="layui-icon layui-icon-cols"></i>é»è®¤å宽</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <script> |
| | | //#region æå 注é |
| | | //#endregion |
| | | 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 |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | var columns = ""; |
| | | var HModName = "Kf_MaterOutInReport"; |
| | | var titleData = []; //ä¸éè¦æ¾ç¤ºçåæ®µ |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | //#region åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //è·åå¼å§æ¥æãç»ææ¥æ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //è·åç»ç» |
| | | Organ(); |
| | | //è·ååæ®ç±»å |
| | | BillType(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·åç»ç» |
| | | function Organ() { |
| | | //è·åç»å½é¡µç»ç»å |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Web/GetOrganizations", |
| | | async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ± |
| | | success: function (result) { |
| | | var Organization = ""; |
| | | Organization += '<option style="color:blue;" value="å
¨é¨">å
¨é¨</option>'; |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | Organization += '<option style="color:blue;" value="' + data[i].Name + '">' + data[i].Name + '</option>'; |
| | | } |
| | | $("#HStockOrgID").append(Organization); |
| | | $("#HStockOrgID").val(sessionStorage["Organization"]) |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·ååæ®ç±»å |
| | | function BillType() { |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/WEBSController/GetBarCodeReport_BillType_Json", |
| | | async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ± |
| | | success: function (result) { |
| | | var HBillType = ""; |
| | | HBillType += '<option style="color:blue;" value="å
¨é¨">å
¨é¨</option>'; |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HBillType += '<option style="color:blue;" value="' + data[i].HBillTypeName + '">' + data[i].HBillTypeName + '</option>'; |
| | | } |
| | | $("#HBillType").append(HBillType); |
| | | $("#HBillType").val("å
¨é¨") |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#region åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , page: true |
| | | , totalRow: true |
| | | , height: 'full-50' |
| | | , cellMinWidth: 90 |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | }; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·åå宽 |
| | | function getColumnsWidth() { |
| | | var result = []; |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | //è·åå宽 |
| | | $.ajax({ |
| | | type: "Get", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidthList', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "colNum": colNum, "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.code == 1) { |
| | | result = data1.data; |
| | | } |
| | | else if (data1.code == -1) { |
| | | |
| | | } |
| | | else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | return result; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¾ç¤ºåæ°æ® |
| | | function DisPlay_HideColumn() { |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', |
| | | async: false, |
| | | data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.data.length != 0) { |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | |
| | | for (var i = 0; i < option.cols[0].length - 2; i++) { |
| | | if (dataCol[i]) { |
| | | var dataCols = dataCol[i].split('|'); |
| | | } |
| | | //éèå |
| | | if (dataCols[1] == 1) { |
| | | option.cols[0][i + 1]["hide"] = true; |
| | | } |
| | | ////设置å宽 |
| | | //if (dataCols[3] > 0) { |
| | | // option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | //} |
| | | //设置å
容åä½å¤§å° |
| | | if (data1.data[0].HFontSize != 0) { |
| | | option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; |
| | | } else { |
| | | option.cols[0][i + 1]["style"] = "font-size:100%"; |
| | | } |
| | | //æ¾ç¤ºå |
| | | if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { |
| | | option.cols[0][i + 1]["hide"] = false; |
| | | } |
| | | //å使å¨ä½ç½®(å·¦ å±
ä¸ å³) |
| | | switch (dataCols[2]) { |
| | | case "L": |
| | | option.cols[0][i + 1]["align"] = "left"; |
| | | break; |
| | | case "M": |
| | | option.cols[0][i + 1]["align"] = "center"; |
| | | break; |
| | | case "R": |
| | | option.cols[0][i + 1]["align"] = "right"; |
| | | break; |
| | | } |
| | | } |
| | | |
| | | //åæ¶å»ç»å |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | if (option.cols[0][i]["fixed"] != null) { |
| | | option.cols[0][i]["fixed"] = null; |
| | | } |
| | | else { |
| | | break; |
| | | } |
| | | } |
| | | //å»ç»å |
| | | if (data1.data[0].HFixCols != 0) { |
| | | for (var i = 0; i < data1.data[0].HFixCols; i++) { |
| | | if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { |
| | | data1.data[0].HFixCols += 1; |
| | | } |
| | | option.cols[0][i + 1]["fixed"] = "left"; |
| | | } |
| | | } |
| | | table.render(option); |
| | | } else { |
| | | table.render(option); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³ |
| | | |
| | | //#region å·¥å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //å¯¼åºæé® |
| | | case 'btn_Export': get_Export(); |
| | | break; |
| | | //æ¥è¯¢æé® |
| | | case 'btn_Query': get_Display(); |
| | | break; |
| | | //éåºæé® |
| | | case 'btn_Exit': Pub_Close(2); |
| | | break; |
| | | //ä¿åå宽æé® |
| | | case 'btn-Cell': set_SaveGridColWidth(); |
| | | break; |
| | | //é»è®¤å宽æé® |
| | | case 'btn-RefreshCell': set_DefaultGridColWidth(); |
| | | break; |
| | | //å设置 |
| | | case 'btn_HideColumn': get_HideColumn(); |
| | | break; |
| | | }; |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region 导åºExecel |
| | | function get_Export() { |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢ |
| | | function get_Display() { |
| | | var HBeginDate = $("#HBeginDate").val(); //å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val(); //ç»ææ¥æ |
| | | var HBillType = $("#HBillType").val(); //åæ®ç±»å |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | var HMater = $("#HMater").val(); //ç©æ |
| | | var HBatchNo = $("#HBatchNo").val(); //æ¹å· |
| | | var HWHName = $("#HWHName").val(); //ä»åº |
| | | var HSPName = $("#HSPName").val(); //ä»ä½ |
| | | var HSourceBillNo = $("#HSourceBillNo").val(); //æºååå· |
| | | var HMaker = $("#HMaker").val(); //å¶å人 |
| | | var HStockOrgName = $("#HStockOrgID").val(); //ç»ç» |
| | | |
| | | sWhere = "'" + HBeginDate + "','" + HEndDate + "','" + HBillType + "','" + HBillNo + "','" + HMater + "','" + HBatchNo + "','" + HWHName + "','" + HSPName + "','" + HSourceBillNo + "','" + HMaker + "','" + HStockOrgName + "'"; |
| | | |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + '/WEBSController/GetKf_MaterOutInReport_Json', |
| | | async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ± |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | 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 ($.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; |
| | | default: |
| | | if (data[i].name == 'æ°é') { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true }); |
| | | } else { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true }); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | columns = col; |
| | | |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | option.cols = [columns]; |
| | | option.data = data1.data; |
| | | option.totalRow = true; |
| | | table.render(option); |
| | | ins = table.render(option); |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, |
| | | error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | DisPlay_HideColumn(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | //æ¸
ç©ºè¿æ»¤æ¡ä»¶ |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | 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")); //ç»ææ¥æ |
| | | $("#HBillType").val("å
¨é¨"); //åæ®ç±»å |
| | | $("#HMater").val(""); //ç©æ |
| | | $("#HBatchNo").val(""); //æ¹å· |
| | | $("#HBillNo").val(""); //åæ®å· |
| | | $("#HWHName").val(""); //ä»åº |
| | | $("#HSPName").val(""); //ä»ä½ |
| | | $("#HSourceBillNo").val(""); //æºååå· |
| | | $("#HMaker").val(""); //å¶å人 |
| | | $("#HStockOrgID").val(sessionStorage["Organization"]) //ç»ç» |
| | | form.render('select'); |
| | | } |
| | | |
| | | //#endregion |
| | | |
| | | //#region ä¿åå宽 |
| | | function set_SaveGridColWidth() { |
| | | var arr = []; |
| | | // åæ° |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | for (var i = 0; i <= colNum; i++) { |
| | | var colName = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).text(); |
| | | var colWidth = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).width(); |
| | | if (colName != "" && colName != null) { |
| | | arr.push(colWidth == -1 ? 200 : colWidth); |
| | | } |
| | | } |
| | | arr.unshift(40); //é¦ä½è¿½å |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidth', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "myMap": JSON.stringify(arr), "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | //layer.alert(data1.Message, { icon: 1 }); |
| | | } else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | //location.reload(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region é»è®¤å宽 |
| | | function set_DefaultGridColWidth() { |
| | | var arr = []; |
| | | // åæ° |
| | | var colNum = $(".layui-table-header").find("tr").eq(0).find("th").length; |
| | | for (var i = 0; i <= colNum; i++) { |
| | | var colName = $(".layui-table-header").find("tr").eq(0).find("th").eq(i).text(); |
| | | if (colName != "" && colName != null) { |
| | | arr.push(200); //é»è®¤å®½åº¦200 |
| | | } |
| | | } |
| | | arr.unshift(40); //é¦ä½è¿½å |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + '/tb_CellWidth/GetMouldScrapInHouseCellWidth', |
| | | async: false, |
| | | dataType: "json", |
| | | data: { "myMap": JSON.stringify(arr), "Name": HModName }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | |
| | | } else { |
| | | layer.alert(data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function (e) { |
| | | layer.alert(e.Message, { icon: 5 }); |
| | | } |
| | | }); |
| | | //设置èµå¼å宽 |
| | | var colWidth = getColumnsWidth(); |
| | | if (colWidth == "" || colWidth == []) { |
| | | |
| | | } |
| | | else { |
| | | $.each(columns, function (x, m) { |
| | | m["width"] = colWidth[x]; |
| | | }); |
| | | } |
| | | location.reload(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region éèå设置 |
| | | function get_HideColumn() { |
| | | var colName = ""; |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | colName += option.cols[0][i]["title"] + ","; |
| | | } |
| | | |
| | | colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç |
| | | layer.open({ |
| | | type: 2 |
| | | , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ |
| | | , title: "éèå设置" //æ é¢ |
| | | , closeBtn: 1 //çªä½å³ä¸è§å
³é ç æ ·å¼ |
| | | , shift: 2 //å¼¹åºå¨ç» |
| | | , area: ["50%", "90%"] //çªä½å¤§å° |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , content: ['../../åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"] |
| | | , btn: ["ç¡®å®", "åæ¶"] |
| | | , btn1: function (index, laero) { |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | //æ´æ°è¡¨æ ¼ç¼åçæ°æ® |
| | | layer.close(index);//å
³éå¼¹çª |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | </script> |
| | | |
| | | </body> |
| | | </html> |
| | |
| | | </button> |
| | | </div> |
| | | </div> |
| | | |
| | | |
| | | <div class="layui-inline" style="width: 51%;"> |
| | | <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">客æ·</label> |
| | | <div class="layui-input-block" style="margin-left: 77px;"> |
| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-row"> |
| | | <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="HCusMaterName" lay-verify="HCusMaterName" id="HCusMaterName" style="display: inline-block;" > |
| | | </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="HCusModel" lay-verify="HCusModel" id="HCusModel" style="display: inline-block;"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row"> |
| | | <div class="layui-inline" style="width: 56%;"> |
| | | <label class="layui-form-label" style="width: 85px;">ç½å¯è¦æ±</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | | <!--å
¶ä»ä¿¡æ¯--> |
| | | <div class="layui-tab-item"> |
| | |
| | | , "HWidth": d.data[0].HWidth |
| | | , "HWeight": d.data[0].HWeight |
| | | , "HColorRemark": d.data[0].æè²è¦æ± |
| | | , "HCusMaterName": d.data[0].客æ·ç©æåç§° |
| | | , "HCusModel": d.data[0].客æ·è§æ ¼åå· |
| | | //å
¶ä»ä¿¡æ¯ |
| | | , "hmakers": OperationType == 2 ? "" : d.data[0].å¶å人 |
| | | , "hmakedate": OperationType == 2 ? "" : d.data[0].å¶åæ¥æ == null ? "" : Format(new Date(d.data[0].å¶åæ¥æ), "yyyy-MM-dd") |
| | |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnCompleteSetAnalysis" id="btnCompleteSetAnalysis">é½å¥åæ</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnTLYS" id="btnTLYS">ææè¿ç®</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnICMOBill" id="btnICMOBill">ç产订åéå</button> |
| | | <button class="layui-btn layui-btn-normal" style="margin-left: 0px" type="button" lay-submit="" lay-filter="btnReady" id="btnReady">åå¤</button> |
| | | </div> |
| | | <div class="layui-collapse"> |
| | | <div class="layui-colla-item"> |
| | |
| | | </select> |
| | | </div> |
| | | </div> |
| | | |
| | | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">ç产车é´</label> |
| | | <div class="layui-input-block" style="margin-left: 77px;"> |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div id="test"></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_BatchFill"><i class="layui-icon layui-icon-file-b"></i>æ¹éå¡«å
</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-CopyLine"><i class="layui-icon layui-icon-form"></i>å¤å¶è¡</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>å é¤è¡</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_MoverUp"><i class="layui-icon layui-icon-delete"></i>ä¸ç§»</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_MoverDown"><i class="layui-icon layui-icon-delete"></i>ä¸ç§»</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Priority"><i class="layui-icon layui-icon-delete"></i>ä¼å
级</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | </div> |
| | | </script> |
| | |
| | | return; |
| | | } |
| | | if (!isNaN(parseInt(obj.data[Format(yyyy + '/' + MM + '/' + (dd + i), 'yyyy-MM-dd')]))) { |
| | | dateHQty += parseInt(obj.data[Format(yyyy + '/' + MM + '/' + (dd + i), 'yyyy-MM-dd')]); |
| | | dateHQty += parseInt(obj.data[Format(yyyy + '/' + MM + '/' + (dd + i), 'yyyy-MM-dd')]) ; |
| | | } |
| | | } |
| | | for (var i = 1; i < dd; i++) { |
| | |
| | | dateHQty += parseInt(obj.data[Format(yyyy + '/' + (MM + 1) + '/' + i, 'yyyy-MM-dd')]); |
| | | } |
| | | } |
| | | |
| | | if (dateHQty > (parseInt(obj.data["è®¡åæ°é"]))) { |
| | | obj.update({ |
| | | "æ¥è®¡åæ°éæ»é": dateHQty |
| | | }); |
| | | return layer.msg("æäº§æ°é大äºè®¢åæ°é!") |
| | | } |
| | | |
| | | //ä¿®æ¹æ°æ® |
| | | obj.update({ |
| | | "æ¥è®¡åæ°éæ»é": dateHQty |
| | |
| | | //åå»è¡¨æ ¼äºä»¶ |
| | | table.on('rowDouble(mainTable)', function (obj) { |
| | | btnrowDouble(obj.data); |
| | | }) |
| | | |
| | | var objData = ""; |
| | | //ç¹å»è¡é䏿°æ® |
| | | table.on('row(mainTable)', function (obj) { |
| | | |
| | | if (objData != "" && objData.tr.find(':checkbox:first').prop('checked') != obj.tr.find(':checkbox:first').prop('checked')) { |
| | | objData.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡é䏿 ·å¼ |
| | | objData.tr.find(':checkbox:first').prop('checked', false);//åæ¶å¤éæ¡é䏿 ·å¼ |
| | | layui.each(table.cache.mainTable, function (i, l) { |
| | | if (objData.tr.index() == l.LAY_TABLE_INDEX) { |
| | | l.LAY_CHECKED = false; |
| | | } |
| | | }); |
| | | } |
| | | |
| | | var flag = !obj.tr.find(':checkbox:first').prop('checked'); |
| | | obj.tr.find(':checkbox').prop('checked', flag); |
| | | if (flag) { |
| | | obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //设置å¤éæ¡é䏿 ·å¼ |
| | | } else { |
| | | obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡é䏿 ·å¼ |
| | | obj.tr.find(':checkbox:first').prop('checked', false);//åæ¶å¤éæ¡é䏿 ·å¼ |
| | | } |
| | | //mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æID䏿£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤é䏿ªé䏿 ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è² |
| | | layui.each(table.cache.mainTable, function (i, l) { |
| | | if (obj.tr.index() == l.LAY_TABLE_INDEX) { |
| | | l.LAY_CHECKED = flag; |
| | | } |
| | | }); |
| | | |
| | | |
| | | objData = obj; |
| | | }) |
| | | |
| | | //头工å
·æ äºä»¶ |
| | |
| | | //å é¤è¡ |
| | | case 'set_DeleteBill': |
| | | set_DeleteBill(); |
| | | break; |
| | | //ä¸ç§» |
| | | case 'set_MoverUp': |
| | | set_MoverUp(data); |
| | | break; |
| | | //ä¸ç§» |
| | | case 'set_MoverDown': |
| | | set_MoverDown(data); |
| | | break; |
| | | //ä¼å
级 |
| | | case 'set_Priority': |
| | | set_Priority(); |
| | | break; |
| | | } |
| | | }); |
| | |
| | | form.on('submit(btnICMOBill)', function (data) { |
| | | get_btnICMOBill(); |
| | | }) |
| | | |
| | | //åå¤ |
| | | form.on('submit(btnReady)', function (data) { |
| | | get_btnReady(); |
| | | }) |
| | | |
| | | |
| | | |
| | | //è¡å
äºä»¶ |
| | | table.on('tool(mainTable)', function (obj) { |
| | |
| | | columns.push({ field: '产线å
¥åºæ°é', title: '产线å
¥åºæ°é', width: 150 }); |
| | | columns.push({ field: 'æªææ°é', title: '坿æ°é', width: 150 }); |
| | | columns.push({ field: '订åç级', title: '订åç级', width: 150 }); |
| | | columns.push({ field: 'äº¤è´§æ¥æ', title: 'äº¤è´§æ¥æ', width: 150, templet: "<div>{{d.äº¤è´§æ¥æ =='' ?'':layui.util.toDateString(d.äº¤è´§æ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>"}); |
| | | columns.push({ field: '订å交货æ', title: '订å交货æ', width: 150, templet: "<div>{{d.订å交货æ =='1900-01-01' ?'':layui.util.toDateString(d.订å交货æ, 'yyyy-MM-dd')}}</div>" }); |
| | | columns.push({ field: '订åéæ±æ°é', title: '订åéæ±æ°é', width: 150 }); |
| | | columns.push({ field: 'å¼å·¥ä½é', title: 'å¼å·¥ä½é', width: 150 }); |
| | | columns.push({ field: 'å°æ¶äº§è½', title: 'å°æ¶äº§è½', width: 150 }); |
| | | columns.push({ field: 'çäº§å¨æ', title: 'çäº§å¨æ', width: 150 }); |
| | | columns.push({ field: 'æè¿å¼å·¥æ¥æ', title: 'æè¿å¼å·¥æ¥æ', width: 150, templet: "<div>{{d.æè¿å¼å·¥æ¥æ =='' ?'':layui.util.toDateString(d.æè¿å¼å·¥æ¥æ, 'yyyy-MM-dd')}}</div>" }); |
| | | columns.push({ field: 'æè¿å®å·¥æ¥æ', title: 'æè¿å®å·¥æ¥æ', width: 150, templet: "<div>{{d.æè¿å®å·¥æ¥æ =='' ?'':layui.util.toDateString(d.æè¿å®å·¥æ¥æ, 'yyyy-MM-dd')}}</div>"}); |
| | | columns.push({ field: 'æºå主å
ç ', title: 'æºå主å
ç ', width: 150 }); |
| | | columns.push({ field: 'æºååå
ç ', title: 'æºååå
ç ', width: 150 }); |
| | | columns.push({ field: 'hmainid', title: 'æ¥è®¡åå·¥å主ç ', width: 150 }); |
| | |
| | | }) |
| | | } |
| | | |
| | | //åå¤ |
| | | function get_btnReady() { |
| | | var data = table.cache["mainTable"]; |
| | | var HICOMNum = []; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HICOMNum.push(data[i]["HICMOInterID"] + ";" + data[i]["HICMOEntryID"]); |
| | | } |
| | | $('#test').html(` |
| | | <div class="layui-progress" lay-filter="demo-filter-progress"> |
| | | <div class="layui-progress-bar" lay-percent="40%"></div> |
| | | </div> |
| | | `); |
| | | // 渲æè¿åº¦æ¡ç»ä»¶ |
| | | element.render('progress', 'demo-filter-progress'); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/ReadyData', |
| | | type: "GET", |
| | | data: { "HICOMNum": HICOMNum.toString() }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | for (var i = 0; i < data1.data.length; i++) { |
| | | for (var j = 0; j < option.data.length; j++) { |
| | | if (data1.data[i]["HICMOInterID"] == option.data[j]["HICMOInterID"] && data1.data[i]["HICMOEntryID"] == option.data[j]["HICMOEntryID"]) { |
| | | option.data[j]["å°æ¶äº§è½"] = data1.data[i]["å°æ¶äº§è½"]; |
| | | option.data[j]["çäº§å¨æ"] = data1.data[i]["çäº§å¨æ"]; |
| | | option.data[j]["å¼å·¥ä½é"] = data1.data[i]["å¼å·¥ä½é"]; |
| | | option.data[j]["æè¿å¼å·¥æ¥æ"] = data1.data[i]["æè¿å¼å·¥æ¥æ"]; |
| | | option.data[j]["æè¿å®å·¥æ¥æ"] = data1.data[i]["æè¿å®å·¥æ¥æ"]; |
| | | option.data[j]["订åéæ±æ°é"] = data1.data[i]["订åéæ±æ°é"]; |
| | | option.data[j]["订å交货æ"] = data1.data[i]["订å交货æ"] < "2020-01-01 0:00:00" ? "1900-01-01" : data1.data[i]["订å交货æ"]; |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | |
| | | for (var i = 0; i < option.data.length - 1; i++) { |
| | | for (var j = 0; j < option.data.length - i - 1; j++) { |
| | | var tables = []; |
| | | //设置任å¡åä¼å
æåºï¼å¹¶è®¾ç½®ä¼å
(æè¿å®å·¥æ¥æ+订å交货æ) å°è£
|
| | | if (option.data[j]["æè¿å®å·¥æ¥æ"] > option.data[j + 1]["æè¿å®å·¥æ¥æ"]) { |
| | | |
| | | tables.push(option.data[j + 1]); |
| | | option.data[j + 1] = option.data[j]; |
| | | option.data[j] = tables[0]; |
| | | |
| | | } else if (option.data[j]["æè¿å®å·¥æ¥æ"] == option.data[j + 1]["æè¿å®å·¥æ¥æ"]) { |
| | | if (option.data[j]["订å交货æ"] > option.data[j + 1]["订å交货æ"]) { |
| | | |
| | | tables.push(option.data[j + 1]); |
| | | option.data[j + 1] = option.data[j]; |
| | | option.data[j] = tables[0]; |
| | | |
| | | } else if (option.data[j]["订å交货æ"] == option.data[j + 1]["订å交货æ"]) { |
| | | if (option.data[j]["订åéæ±æ°"] < option.data[j + 1]["订åéæ±æ°"]) { |
| | | |
| | | tables.push(option.data[j + 1]); |
| | | option.data[j + 1] = option.data[j]; |
| | | option.data[j] = tables[0]; |
| | | |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | $('#test').html('') |
| | | |
| | | table.render(option); |
| | | |
| | | } else { |
| | | //layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //ä¸ç§» |
| | | function DownTable(data ,i) { |
| | | |
| | | } |
| | | |
| | | //æ¥è¯¢ç产订å |
| | | function SelectICMOBill(hmainid) { |
| | | var ajaxLoad = layer.load(); |
| | |
| | | } |
| | | } |
| | | |
| | | //ä¸ç§» |
| | | function set_MoverUp(data) { |
| | | if (data.length != 1) { |
| | | layer.msg("è¯·éæ©ä¸è¡æ°æ®ï¼"); |
| | | } else if (option.data[0]["ç产订åå·"] == data[0]["ç产订åå·"]) { |
| | | layer.msg("é¦è¡æ°æ®æ æ³ç§»å¨ï¼"); |
| | | } else { |
| | | var tables = []; |
| | | for (var i = 0; i < option.data.length; i++) { |
| | | if (option.data[i]["ç产订åå·"] == data[0]["ç产订åå·"]) { |
| | | tables.push(option.data[i - 1]); |
| | | data[0].LAY_CHECKED = true; |
| | | option.data[i - 1] = data[0]; |
| | | option.data[i] = tables[0]; |
| | | table.render(option); |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | //ä¸ç§» |
| | | function set_MoverDown(data) { |
| | | if (data.length != 1) { |
| | | layer.msg("è¯·éæ©ä¸è¡æ°æ®ï¼"); |
| | | } else if (option.data[option.data.length - 1]["ç产订åå·"] == data[0]["ç产订åå·"]) { |
| | | layer.msg("æ«è¡æ°æ®æ æ³ç§»å¨ï¼"); |
| | | } else { |
| | | var tables = []; |
| | | for (var i = 0; i < option.data.length; i++) { |
| | | if (option.data[i]["ç产订åå·"] == data[0]["ç产订åå·"]) { |
| | | tables.push(option.data[i + 1]); |
| | | data[0].LAY_CHECKED = true; |
| | | option.data[i + 1] = data[0]; |
| | | option.data[i] = tables[0]; |
| | | table.render(option); |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | //ä¼å
级 |
| | | function set_Priority() { |
| | | var data = table.cache["mainTable"]; |
| | | for (var i = 0; i < data.length; i++) { |
| | | data[i]["ä¼å
级"] = (i + 1); |
| | | } |
| | | option.data = data; |
| | | table.render(option); |
| | | } |
| | | |
| | | //ä¿å |
| | | function set_AddNew(data) { |
| | | |
| | |
| | | <label class="layui-form-label">对åºERPç©æ<label style="color:red"> * </label></label> |
| | | <div class="layui-input-inline"> |
| | | <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber" style="float:left;width:150px;"> |
| | | <input type="hidden" class="layui-input" name="HMaterID" id="HMaterID" style="float:left;width:150px;"> |
| | | <input type="hidden" class="layui-input" name="HMaterID" id="HMaterID" value="0" style="float:left;width:150px;"> |
| | | <button type="button" lay-submit="" class="layui-btn" lay-filter="HMaterList" style="width:40px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i> |
| | | </button> |
| | |
| | | layer.msg("设å¤è§æ ¼ä¸è½ä¸ºç©ºï¼", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return Result = false; |
| | | } |
| | | if ($("#HMaterID").val() == '' || $("#HMaterID").val() == null) { |
| | | layer.msg("è¯·éæ©å¯¹åºERPç©æï¼", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return Result = false; |
| | | } |
| | | //å¯è´ä¸éè¦ |
| | | //if ($("#HMaterID").val() == '' || $("#HMaterID").val() == null) { |
| | | // layer.msg("è¯·éæ©å¯¹åºERPç©æï¼", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | // return Result = false; |
| | | //} |
| | | if ($("#HEquipFileTypeID").val() == '' || $("#HEquipFileTypeID").val() == null) { |
| | | layer.msg("è¯·éæ©è®¾å¤åç±»ï¼", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | return Result = false; |
| | |
| | | <input type="hidden" class="layui-input" name="HCusID" id="HCusID"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3 layui-inline"> |
| | | <label class="layui-form-label"> ææè§æ ¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input type="text" class="layui-input" name="HMaterModel" id="HMaterModel" style="float: left;"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row"> |
| | | <div class="layui-col-xs6 layui-inline"> |
| | |
| | | </button> |
| | | </div> |
| | | </div> |
| | | <div class="layui-col-xs3 layui-inline"> |
| | | <label class="layui-form-label"> ææè§æ ¼</label> |
| | | <div class="layui-input-inline"> |
| | | <input type="text" class="layui-input" name="HMaterModel" id="HMaterModel" style="float: left;"> |
| | | </div> |
| | | </div> |
| | | |
| | | |
| | | <div class="layui-col-xs3 layui-inline"> |
| | | <label class="layui-form-label">æ¥è®¡åå·¥åéåå·</label> |
| | |
| | | $("#HEmpID").val(data1.data[0].HEmpID); |
| | | //$("#HAuxUnitName").val(data1.data[0].HAuxUnitName); |
| | | //$("#HAuxUnit").val(data1.data[0].HAuxUnit); |
| | | // $("#HMaterModel").val(data1.data[0].HMaterModel); |
| | | $("#HMaterModel").val(data1.data[0].è§æ ¼åå·); |
| | | |
| | | $.ajax({ |
| | | type: "get", |
| | |
| | | <html> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>ç产å
¥åºæ¥è¡¨</title> |
| | | <title>ç产æ¥è®°æ¥è¡¨</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> |
| | |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | | //åå»è¡¨æ ¼äºä»¶ |
| | | table.on('rowDouble(mainTable)', function (obj) { |
| | | btnrowDouble(obj.data); |
| | | }) |
| | | |
| | | //åå»è¡¨æ ¼äºä»¶ |
| | | table.on('rowDouble(mainTable1)', function (obj) { |
| | | btnrowDouble(obj.data); |
| | | }) |
| | | |
| | | |
| | | //#endregion |
| | | |
| | |
| | | sWhere = ""; |
| | | } |
| | | |
| | | //åå»è·³è½¬ç产å
¥åºæ¥è¡¨ |
| | | function btnrowDouble(obj) { |
| | | |
| | | var HProcExchBillNo = obj["å·¥èºåå·"]; |
| | | var HBeginDate = $("#HBeginDate").val();//ä¸è¾¾æ¥æ å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val();//ç»ææ¥æ |
| | | |
| | | if (HProcExchBillNo == "" || HProcExchBillNo == null) { |
| | | return layer.alert("æ ç产å
¥åºæç»,æ æ³æ¥ç!", { icon: 5 }); |
| | | } |
| | | |
| | | layer.open({ |
| | | type: 2 //ç±»å |
| | | , skin: 'layui-layer-rim'//å ä¸è¾¹æ¡ |
| | | , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º |
| | | , area: ['90%', '90%']//å¤§å° |
| | | , title: 'ç产å
¥åºæ¥è¡¨'//æ é¢ |
| | | , shift: 2//å¼¹åºå¨ç» |
| | | , content: ['../../车é´ç®¡ç/æ¥è¡¨åæ/sc_ICOMRKReport.html?OperationType=1&HProcExchBillNo=' + HProcExchBillNo + '&HBeginDate="' + HBeginDate + '"&HEndDate="' + HEndDate+'"', 'yes'] |
| | | }) |
| | | } |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | //åå§åæ¶é´ |
| | |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var HModName = "sc_ICOMRKReport"; |
| | | var HProcExchBillNo = ""; |
| | | var HBeginDate_u = ""; |
| | | var HEndDate_u = ""; |
| | | |
| | | //#endregion |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | | |
| | | var params = getUrlVars(); |
| | | var OperationType = params[params[0]]; |
| | | |
| | | //夿æ¯å¦æåæ°ä¼ é |
| | | if (!isNaN(OperationType)) { |
| | | HProcExchBillNo = params[params[1]]; |
| | | HBeginDate_u = params[params[2]]; |
| | | HEndDate_u = params[params[3]]; |
| | | } |
| | | |
| | | |
| | | //#region åå§åçé¢ |
| | | |
| | | |
| | | set_ClearBill(); |
| | | |
| | | //#endregion |
| | |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | var HProductName = $("#HProductName").val();//产ååç§° |
| | | var HProductModel = $("#HProductModel").val();//产åè§æ ¼ |
| | | |
| | | if (HProcExchBillNo != "") { |
| | | sWhere += " and æµè½¬å¡å· ='" + HProcExchBillNo + "'"; |
| | | HBeginDate = HBeginDate_u; |
| | | HEndDate = HEndDate_u; |
| | | } |
| | | |
| | | if (HBeginDate != "" && HEndDate != "") { |
| | | sWhere += " and æ¥æ between '" + HBeginDate + "' and '" + HEndDate + "' "; |
| | |
| | | }) |
| | | } |
| | | |
| | | //è·ååæ° |
| | | 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 |
| | | }); |
| | | </script> |
| | |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Close"><i class="layui-icon layui-icon-form"></i>å
³é订å</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-AddHRemark"><i class="layui-icon layui-icon-form"></i>æ·»å 夿³¨</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèå设置</button> |
| | | </div> |
| | | </script> |
| | |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | switch (obj.event) { |
| | | //éåº |
| | | case 'btn-exit': Pub_Close(2); |
| | | case 'btn-exit': Pub_Close(2); |
| | | break; |
| | | //å
³é订å |
| | | case 'btn-Close': btn_Close(obj); |
| | | break; |
| | | //éèå设置 |
| | | case 'HideColumn': |
| | | get_HideColumn(); |
| | | break; |
| | | //æ·»å 夿³¨ |
| | | case 'btn-AddHRemark': |
| | | btn_AddHRemark(); |
| | | break; |
| | | }; |
| | | }); |
| | |
| | | sWhere = ""; |
| | | } |
| | | |
| | | //å
³é订å |
| | | function btn_Close(obj) { |
| | | var checkStatus = table.checkStatus(obj.config.id); |
| | | var HICOMBillNoNum = []; |
| | | for (var i = 0; i < checkStatus.data.length; i++) { |
| | | HICOMBillNoNum.push(checkStatus.data[i]["ç产订åå·"]) |
| | | } |
| | | var sMainSub = HICOMBillNoNum.toString() + ";" + sessionStorage["HUserName"]; |
| | | $.ajax({ |
| | | url: GetWEBURL() + "/LEMS/sc_ICOMReportClose", |
| | | type: "POST", |
| | | async: false, |
| | | data: { "sMainSub": sMainSub }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | layer.msg(data1.Message); |
| | | get_FastQuery(); |
| | | } else { |
| | | layer.msg(data1.Message); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.msg('é误' + err, { |
| | | icon: 5, |
| | | time: 20000 |
| | | }); |
| | | } |
| | | }) |
| | | |
| | | } |
| | | |
| | | function btn_AddHRemark() { |
| | | var checkStatus = table.checkStatus('mainTable'); |
| | | if (checkStatus.data.length != 1) { |
| | | layer.msg("è¯·éæ©ä¸æ¡æ°æ®!"); |
| | | } else { |
| | | layer.prompt({ title: 'æ·»å 夿³¨', formType: 2 }, function (text, index) { |
| | | |
| | | var sMainSub = checkStatus.data[0]["ç产订åå·"]+ ";"+text + ";" + sessionStorage["HUserName"]; |
| | | $.ajax({ |
| | | url: GetWEBURL() + "/LEMS/sc_ICOMReportAddHRemark", |
| | | type: "POST", |
| | | async: false, |
| | | data: { "sMainSub": sMainSub }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | get_FastQuery(); |
| | | layer.close(index); |
| | | layer.msg(data1.Message); |
| | | } else { |
| | | layer.msg(data1.Message); |
| | | } |
| | | }, |
| | | error: function (err) { |
| | | layer.msg('é误' + err, { |
| | | icon: 5, |
| | | time: 20000 |
| | | }); |
| | | } |
| | | }) |
| | | |
| | | }); |
| | | } |
| | | } |
| | | |
| | | //éèå设置 |
| | | function get_HideColumn() { |
| | |
| | | //åå»è·³è½¬å®¢æ·è®¢åæç»æ¥è¡¨ |
| | | function btnrowDouble(obj) { |
| | | |
| | | HICMOBillNo = obj["ç产订åå·"]; |
| | | var HICMOBillNo = obj["ç产订åå·"]; |
| | | |
| | | if (HICMOBillNo == "" || HICMOBillNo == null) { |
| | | return layer.alert("æ å·¥èºæç»,æ æ³æ¥ç!", { icon: 5 }); |