var refreshGirdData; var bootstrap = function ($, learun) { "use strict"; var psuid = ""; var page = { init: function () { page.initGird(); page.bind(); }, bind: function () { $('#multiple_condition_query').lrMultipleQuery(function (queryJson) { // 调用后台查询 // queryJson 查询条件 queryJson["MatCode"] = $("#MatCode").val(); queryJson["MatName"] = $("#MatName").val(); queryJson["ContGrpBarCode"] = $("#ContGrpBarCode").val(); queryJson["Grade"] = $("#Grade").val(); queryJson["SKU"] = $("#SKU").val(); queryJson["DocNo"] = $("#DocNo").val(); queryJson["IsTorsChk"] = $("#IsTorsChk").lrselectGet(); queryJson["IsBlack"] = $("#IsBlack").lrselectGet(); page.search({ queryJson: JSON.stringify(queryJson) }); }, 250); // 查询 $('#btn_Search').on('click', function () { var keyword = $('#txt_Keyword').val(); page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) }); }); // 刷新 $('#lr_refresh').on('click', function () { location.reload(); }); $('#IsBlack').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); $('#IsTorsChk').lrselect({ url: top.$.rootUrl + '/SXManager/Enums/YesNoList', maxHeight: 60, allowSearch: false }); // 导出数据 $('#lr_exportnow').on('click', function () { var subsuid = ""; if (psuid == "") { psuid = $('#gridtable').attr('id'); } else if (psuid != "") { var t = $('#' + psuid).attr('id'); if (t == undefined) psuid = $('#gridtable').attr('id'); } var mainGridId = $('#gridtable').attr('id'); learun.layerForm({ id: "ExcelExportForm", title: '导出Excel数据', url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("导出出入库报表")), width: 500, height: 380, callBack: function (id) { return top[id].acceptClick(); }, btn: ['导出Excel', '关闭'] }); }); $('#lr_exportall').on('click', function () { //var where = $("#queryWhere").val(); var query = $('#multiple_condition_query').lrGetFormData(); query["EndTimeBegin"] = $("#EndTimeBegin").val(); query["EndTimeEnd"] = $("#EndTimeEnd").val(); query["GroupName"] = $("#GroupName").val(); query["keyword"] = $('#txt_Keyword').val(); var queryJson = JSON.stringify(query); learun.layerForm({ id: "ExcelExportForm", title: '导出Excel数据', // url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("库存")), url: top.$.rootUrl + '/Utility/ExcelExportColumn?gridId=' + $('#gridtable').attr('id') + '&subgridId=', width: 500, height: 380, callBack: function (id) { return top[id].acceptClick(function (data) { learun.download({ method: "POST", url: '/SXManager/Statisticsreport/ExportInOutReportExcel', param: { fileName: "导出出入库报表", queryJson: queryJson, exportField: JSON.stringify(data) } }); }); }, btn: ['导出Excel', '关闭'] }); }); }, // 初始化列表 initGird: function () { $('#gridtable').jfGrid({ url: top.$.rootUrl + '/SXManager/Statisticsreport/GetCurStockInfoList', headData: [ { label: "SKU编码", name: "SKU", width: 100, align: "left" }, { label: "物料描述", name: "MatName", width: 280, align: "left", }, { label: "订单号", name: "DocNo", width: 170, align: "left", }, { label: "机器组", name: "WbGroupCode", width: 80, align: "left", }, { label: "批次", name: "BatchNo", width: 80, align: "left", }, { label: "绕向(R/L)", name: "NoBCount", width: 120, align: "left" , formatter: function (cellvalue) { return '' + cellvalue[0] + '/' + cellvalue[1] + '' } }, { label: "黑盘数量(R/L)", name: "BCount", width: 120, align: "left", formatter: function (cellvalue) { return '' + cellvalue[0] + '/' + cellvalue[1] + '' } }, { label: "质量等级", name: "Grade", width: 80, align: "left", }, { label: "已装箱数", name: "FinCount", width: 80, align: "left", }, { label: "未装箱数", name: "NoFinCount", width: 80, align: "left", }, ], rows: 200, mainId: 'SKU', footerrow: true, isPage: true, reloadSelected: true, autowWidth: true, sidx: 'SKU', sord: 'asc', onRenderComplete: function () { var datas = $('#gridtable').jfGridGet("rowdatas"); for (var i = 0; i < datas.length; i++) { if ((datas[i].NoBCount[0] != '0R' && datas[i].BCount[0] == '0R') || (datas[i].NoBCount[1] != '0L' && datas[i].BCount[1] == '0L')) { $('.jfgrid-data-cell[rowindex=' + i + ']').addClass("SelectBG"); } } } }); page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) }); }, search: function (param) { $('#gridtable').jfGridSet('reload', param); } }; refreshGirdData = function () { $('#gridtable').jfGridSet('reload'); }; page.init(); }