| WebTM/WebTM.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/index.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/仓存管理/条码报表/Kf_ICInventory_BarCode.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/仓存管理/条码报表/Kf_ICInventory_Mater.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/仓存管理/条码报表/Kf_MaterOutInReport.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebTM/WebTM.csproj
@@ -204,6 +204,9 @@ <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" /> WebTM/views/index.html
@@ -254,7 +254,9 @@ <dl class="layui-nav-child"> <dd><a lay-href="ä»å管ç/æ«ç å¼å¸¸è®°å½è¡¨/KF_PonderationBillList.html">æ«ç å¼å¸¸è®°å½æ¥è¯¢</a></dd> <dd><a lay-href="ä»å管ç/æ¡ç æ¥è¡¨/Kf_BarCodeOutInReport.html">æ¡ç åºå ¥åºè®°å½è¡¨</a></dd> <dd><a lay-href="ä»å管ç/æ¡ç åºå/KF_ICInventoryList_WMS.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> WebTM/views/²Ö´æ¹ÜÀí/ÌõÂ뱨±í/Kf_ICInventory_BarCode.html
New file @@ -0,0 +1,562 @@ <!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> WebTM/views/²Ö´æ¹ÜÀí/ÌõÂ뱨±í/Kf_ICInventory_Mater.html
New file @@ -0,0 +1,554 @@ <!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> WebTM/views/²Ö´æ¹ÜÀí/ÌõÂ뱨±í/Kf_MaterOutInReport.html
New file @@ -0,0 +1,627 @@ <!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>
