|
|
@{ ViewBag.Title = "Index"; Layout = "~/Views/Shared/_Index.cshtml";}<script src="~/Content/js/datepicker/WdatePicker.js"></script><script> debugger;
var myDate = new Date; var year = myDate.getFullYear(); //获取当前年 var mon = myDate.getMonth() + 1 < 10 ? "0" + (myDate.getMonth() + 1) : myDate.getMonth() + 1; //获取当前月 var date = myDate.getDate() + 1 < 10 ? "0" + myDate.getDate() : myDate.getDate(); //获取当前日 var MtimeFrom = year + "-" + mon + "-" + date; var MtimeArrive = year + "-" + mon + "-" + date;
var _Clos = new Array(); $(function () {
SetCols(); gridList();
});
function Selchange() { document.getElementById("gridPanel").innerHTML = '<table id="gridList"></table> <div id="gridPager"></div>';//重置grid gridList();
}
function SetCols() { $.ajax({ url: "/Print/SelectColumnName?" + Math.random(), dataType: "json", async: false, success: function (data) { var cols = new Array(); var collast = { label: '物料编码', name: 'InvCode', width: 150, align: 'left' }; cols.push(collast); var collast = { label: '物料名称', name: 'InvName', width: 200, align: 'left' }; cols.push(collast); var collast = { label: '物料规格', name: 'InvStd', width: 200, align: 'left' }; cols.push(collast); var collast = { label: '旧料号', name: 'OldInvCode', width: 150, align: 'left' }; cols.push(collast); var collast = { label: '大类编码', name: 'ClassCode', width: 150, align: 'left' }; cols.push(collast); var collast = { label: '大类名称', name: 'ClassName', width: 150, align: 'left' }; cols.push(collast); var collast = { label: '单位', name: 'InvUnit', width: 150, align: 'left' }; cols.push(collast); var collast = { label: '仓库编码', name: 'WarehouseCode', width: 120, align: 'left' }; cols.push(collast); var collast = { label: '仓库名称', name: 'WarehouseName', width: 150, align: 'left' }; cols.push(collast); var collast = { label: '期初数量', name: 'QCQuantity', width: 120, align: 'left' }; cols.push(collast); var collast = { label: '收料数量', name: 'SQuantity', width: 150, align: 'left' }; cols.push(collast); var collast = { label: '发料数量', name: 'FQuantity', width: 150, align: 'left' }; cols.push(collast); var collast = { label: '库存数量', name: 'Quantity', width: 200, align: 'left' }; cols.push(collast); _Clos = cols; } }); }
function gridList() {
var Type = $("#selShow").val(); var $gridList = $("#gridList"); var queryJson = { StartDate: $("#txt_StartDate").val(), EndDate: $("#txt_EndDate").val(), InvCode: $("#txt_InvCode").val(), WHCode: $("#txt_WHCode").val(), InvName: $("#txt_InvName").val(), InvStd: $("#txt_InvStd").val(), } $gridList.dataGrid({ url: "/DHAY/ICSWareHouseLotInfoLog/GetList? " + Math.random(), postData: { queryJson: JSON.stringify(queryJson), Type: Type }, height: $(window).height() - 150, width: $(window).width() - 500, colModel: _Clos,
shrinkToFit: false,//宽度自适应 autowidth: true, gridComplete: function () { }, pager: "#gridPager", autoScroll: true, sortname: 'InvCode', sortorder: "desc", viewrecords: true, multiselect: true, subGrid: false, // (1)开启子表格支持 //subGridRowExpanded: function (subgrid_id, rowid) { // (2)子表格容器的id和需要展开子表格的行id，将传入此事件函数 // $("#gridList").jqGrid("setSelection", rowid, false); // bindSubGrid(subgrid_id, rowid) //}, //gridComplete: function () { // debugger; // var strIds = $("#gridList").jqGrid("getDataIDs"); //}
});
$("#btn_search").click(function () { var queryJson = { StartDate: $("#txt_StartDate").val(), EndDate: $("#txt_EndDate").val(), InvCode: $("#txt_InvCode").val(), WHCode: $("#txt_WHCode").val(), InvName: $("#txt_InvName").val(), InvStd: $("#txt_InvStd").val(), } $gridList.jqGrid('setGridParam', { postData: { queryJson: JSON.stringify(queryJson) }, }).trigger('reloadGrid'); });
}
function btn_ExportAll() { debugger; var queryData = "&StartDate=" + $("#txt_StartDate").val() + "&EndDate=" + $("#txt_EndDate").val() + "&InvCode=" + $("#txt_InvCode").val() + "&WHCode=" + $("#txt_WHCode").val() + "&InvName=" + $("#txt_InvName").val()+ "&InvStd=" + $("#txt_InvStd").val(); $.download("/DHAY/ICSWareHouseLotInfoLog/StatementExportAll" + "?" + Math.random(), queryData, 'post'); }
function fullscreen() { var docElm = document.documentElement; if (docElm.requestFullscreen) { docElm.requestFullscreen(); } else if (docElm.mozRequestFullScreen) { docElm.mozRequestFullScreen(); } else if (docElm.webkitRequestFullScreen) { docElm.webkitRequestFullScreen(); } else if (docElm.msRequestFullscreen) { docElm.msRequestFullscreen(); } $(window).bind('resize', function () { $("#gridList").setGridWidth($(window).width()); }).trigger('resize'); $(window).bind('resize', function () { $("#gridList").setGridHeight($(window).height()); }).trigger('resize'); }</script>
<div class="topPanel" style="height:60px;"> <div class="toolbar"> <div class="btn-group"> <a id="NF-Print" authorize="yes" style="margin-left:3px;" class="btn btn-primary" onclick="btnPrint()"><i class="fa fa-pencil-square-o"></i>打印</a> <a id="NF-ExportAll" authorize="yes" class="btn btn-primary dropdown-text" onclick="btn_ExportAll()"><i class="fa fa-download"></i>全部导出</a>
</div>
<script>$('.toolbar').authorizeButton()</script> </div> <div class="search"> <table> <tr> <td style="text-align:right;"><label class="lglabel" for="txt_InvCode"> 料品编码</label>：</td> <td> <div class="input-group"> <input id="txt_InvCode" type="text" class="form-control" style="width: 100px;"> </div> </td> <td style="text-align:right;"><label class="lglabel" for="txt_WHCode"> 仓库编码</label>：</td> <td> <div class="input-group"> <input id="txt_WHCode" type="text" class="form-control" style="width: 100px;"> </div> </td> <td style="text-align:right;"><label class="lglabel" for="txt_InvName"> 物料名称</label>：</td> <td> <div class="input-group"> <input id="txt_InvName" type="text" class="form-control" style="width: 100px;"> </div> </td> <td style="text-align:right;"><label class="lglabel" for="txt_InvStd"> 物料规格</label>：</td> <td> <div class="input-group"> <input id="txt_InvStd" type="text" class="form-control" style="width: 100px;"> </div> </td> <th class="formTitle"> 开始时间:</th> <td class="formValue"> <input type="text" name="txt_StartDate" id="txt_StartDate" class="form-control" style="width: 100px; height:22px" onclick="WdatePicker({ dateFmt: 'yyyy-MM-dd' })" placeholder="开始日期" /> </td> <th class="formTitle"> 结束时间:</th> <td class="formValue"> <input type="text" name="txt_EndDate" id="txt_EndDate" class="form-control" style="width: 100px; height: 22px " onclick="WdatePicker({ dateFmt: 'yyyy-MM-dd', minDate: txt_StartDate.value })" placeholder="结束日期" /> </td> <td> <span class="input-group-btn"> <button id="btn_search" type="button" class="btn btn-primary"><i class="fa fa-search"></i></button> </span> </td> </tr>
</table> </div></div><div class="gridPanel"> <table id="gridList"></table> <div id="gridPager"></div></div>
|
