| | |
| | | <div class="layui-inline"> |
| | | <button class="layui-btn layui-btn-sm layuiadmin-btn-list" lay-submit |
| | | lay-filter="LAY-app-contlist-search"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>搜索 |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn" ></i>搜索 |
| | | </button> |
| | | </div> |
| | | </div> |
| | |
| | | laypage = layui.laypage, |
| | | layer = layui.layer; |
| | | var h1 = GetTableHeight(); |
| | | |
| | | |
| | | var TotalColsArr = |
| | | [[ |
| | |
| | | <meta name="viewport" |
| | | content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0"> |
| | | <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all"> |
| | | <script> |
| | | // 这里是需要在页面渲染之前执行的代码 |
| | | document.addEventListener("DOMContentLoaded", function() { |
| | | |
| | | //获取table默认显示数 |
| | | pageCntFirst(); |
| | | }); |
| | | </script> |
| | | </head> |
| | | |
| | | <body> |
| | |
| | | where: param, |
| | | id: 'goods-list', |
| | | page: true, |
| | | limit: pageCnt, |
| | | limits: pageLimits, |
| | | even: true, |
| | | limit: pageCnt, |
| | | limits: pageLimits, |
| | | cellMinWidth: 80, //全局定义常规单元格的最小宽度,layui 2.2.1 新增 |
| | | cols: [ |
| | | [ |
| | |
| | | <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0"> |
| | | <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all"> |
| | | </head> |
| | | <body> |
| | | <body id="body"> |
| | | <div class="layui-fluid" style="padding-bottom: 0;"> |
| | | |
| | | <div class="layui-card"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" id="top"> |
| | | <div class="layui-form-item" style="margin-bottom: 0px;"> |
| | | |
| | | <div class="layui-inline zongdan" > |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | | <div id="center"></div> |
| | | |
| | | <div class="layui-card-body"> |
| | | |
| | |
| | | var $ = layui.$, |
| | | form = layui.form, |
| | | layer = layui.layer; |
| | | var h1 = GetTableHeight(); |
| | | var boxNo = getQueryString('BoxNo'); |
| | | if (!boxNo) |
| | | { |
| | |
| | | // 表单需要的变量 |
| | | var infoOptions = { |
| | | elem: '#LAY-app-content-list', |
| | | height: 'full-98', |
| | | height: h1, |
| | | id: 'LAY-app-content-list', |
| | | page: true, |
| | | limit: pageCnt, |
| | |
| | | <link rel="stylesheet" href="../../css/public.css" media="all"> |
| | | </head> |
| | | |
| | | <body> |
| | | <body id="body"> |
| | | |
| | | <div class="layui-fluid" style="padding-bottom: 0;"> |
| | | <div class="layui-card"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" id="top"> |
| | | <div class="layui-form-item"> |
| | | |
| | | <div class="layui-inline"> |
| | |
| | | <div class="layui-card-body"> |
| | | <div> |
| | | <div class="layui-tab layui-tab-brief" lay-filter="docDemoTabBrief"> |
| | | <ul class="layui-tab-title"> |
| | | <ul class="layui-tab-title" id="tab"> |
| | | <li class="layui-this">托盘信息</li> |
| | | <li>箱码信息</li> |
| | | </ul> |
| | | |
| | | <div id="center"></div> |
| | | |
| | | <div class="layui-tab-content"> |
| | | <div class="layui-tab-item layui-show"> |
| | | <div class="position-relative"><!-- class="position-relative" --><!-- 自定义表头加上 --> |
| | |
| | | layer = layui.layer, |
| | | laydate = layui.laydate; |
| | | var $ = layui.$; |
| | | var h1 = GetTableTabHeight(); |
| | | |
| | | // var h1 = GetTableTopHeight(); |
| | | // var h2 = GetTableBottomHeight(); |
| | | // laydate.render({ |
| | |
| | | elem: '#LAY-app-content-list', |
| | | url: IP + "/BllSo/GetExportAllotList", |
| | | method: 'POST', |
| | | height: 'full-210', |
| | | height: h1, |
| | | id: 'LAY-app-content-list', |
| | | where: param, |
| | | contentType: 'application/json', |
| | |
| | | elem: '#LAY-app-content-list2', |
| | | url: IP + "/BllSo/GetCompleteDetailList", |
| | | method: 'POST', |
| | | height: 'full-206', |
| | | height: h1, |
| | | id: 'LAY-app-content-list2', |
| | | where: param, |
| | | contentType: 'application/json', |
| | |
| | | }); |
| | | </script> |
| | | </head> |
| | | <body> |
| | | <body id="body"> |
| | | |
| | | <div class="layui-fluid"style="padding-bottom: 0;"> |
| | | <div class="layui-card"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC" id="top"> |
| | | <div class="layui-form-item"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 70px;">所属仓库</label> |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div id="center"></div> |
| | | <div class="layui-card-body"> |
| | | <table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table> |
| | | <script type="text/html" id="buttonTpl"> |
| | |
| | | laypage = layui.laypage, |
| | | layer = layui.layer; |
| | | var $ = layui.$; |
| | | var h1 = GetTableHeight(); |
| | | refreshTable("","","",""); |
| | | var tableIns; |
| | | |
| | |
| | | elem: '#LAY-app-content-list', |
| | | url: IP +"/Sys/GetStorageAreaList", |
| | | method: 'POST', |
| | | height: 'full-95', |
| | | height: h1, |
| | | id: 'LAY-app-content-list', |
| | | where: param, |
| | | contentType:'application/json', |
| | |
| | | }); |
| | | </script> |
| | | </head> |
| | | <body> |
| | | <body id="body"> |
| | | <div class="layui-card" style="padding-bottom: 0"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC" id="top"> |
| | | <div class="layui-form-item" > |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">异常号</label> |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div id="center"></div> |
| | | <div class="layui-card-body"> |
| | | <table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table> |
| | | <script type="text/html" id="table-content-list"> |
| | |
| | | form = layui.form, |
| | | laypage = layui.laypage, |
| | | layer = layui.layer; |
| | | |
| | | var h1 = GetTableHeight(); |
| | | refreshTable("", "", "", "","","",""); |
| | | var tableIns; |
| | | |
| | |
| | | } |
| | | var infoOptions = { |
| | | elem: '#LAY-app-content-list', |
| | | height: 'full-130', |
| | | height: h1, |
| | | id: 'LAY-app-content-list', |
| | | page: true, |
| | | limit: pageCnt, |
| | |
| | | |
| | | <head> |
| | | <meta charset="utf-8"> |
| | | <title>储位图例</title> |
| | | <title>平库图例</title> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" |
| | | content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0"> |
| | |
| | | }); |
| | | </script> |
| | | </head> |
| | | <body> |
| | | <body id="body"> |
| | | |
| | | <div class="layui-fluid" style="padding-bottom: 0;"> |
| | | <div class="layui-card"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC" id="top"> |
| | | <div class="layui-form-item"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 60px;">所属仓库</label> |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div id="center"></div> |
| | | <div class="layui-card-body"> |
| | | <table id="LAY-app-content-list" lay-filter="LAY-app-content-list" style="width: 100%;"></table> |
| | | <script type="text/html" id="table-content-list"> |
| | |
| | | layer = layui.layer, |
| | | $ = layui.$; |
| | | var houseid = 0; |
| | | var h1 = GetTableHeight(); |
| | | // 表单需要的变量 |
| | | var doing = true; |
| | | active = { |
| | |
| | | console.log(where); |
| | | var tableIns = table.render({ |
| | | elem: '#LAY-app-content-list', |
| | | height: 'full-135', |
| | | height: h1, |
| | | id: 'LAY-app-content-list', |
| | | url: IP + "/Sys/GetStorageLocatList", |
| | | method: 'post', |
| | |
| | | }); |
| | | </script> |
| | | </head> |
| | | <body> |
| | | <body id="body"> |
| | | <div class="layui-fluid" style="padding-bottom: 0;"> |
| | | <div class="layui-card"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC" id="top"> |
| | | <div class="layui-form-item"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 70px;">托盘条码:</label> |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div id="center"></div> |
| | | <div class="layui-card-body"> |
| | | <table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table> |
| | | |
| | |
| | | form = layui.form, |
| | | laypage = layui.laypage, |
| | | layer = layui.layer; |
| | | |
| | | var h1 = GetTableHeight(); |
| | | var isTrue= true; |
| | | |
| | | var where = { |
| | |
| | | } |
| | | var tableIns = table.render({ |
| | | elem: '#LAY-app-content-list', |
| | | height: 'full-95', |
| | | height: h1, |
| | | id: 'LAY-app-content-list', |
| | | url: IP + "/Sys/GetPalletsList", |
| | | method: 'post', |
| | |
| | | }); |
| | | </script> |
| | | </head> |
| | | <body> |
| | | <body id="body"> |
| | | |
| | | <div class="layui-fluid"style="padding-bottom: 0;"> |
| | | <div class="layui-card"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC" id="top"> |
| | | <div class="layui-form-item"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 70px;">所属仓库</label> |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div id="center"></div> |
| | | <div class="layui-card-body"> |
| | | <table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table> |
| | | <script type="text/html" id="buttonTpl"> |
| | |
| | | laypage = layui.laypage, |
| | | layer = layui.layer; |
| | | // var $ = layui.$; |
| | | var h1 = GetTableHeight(); |
| | | refreshTable("","","",""); |
| | | var tableIns; |
| | | |
| | |
| | | elem: '#LAY-app-content-list', |
| | | url: IP +"/Sys/GetStorageRoadwayList", |
| | | method: 'POST', |
| | | height: 'full-95', |
| | | height: h1, |
| | | id: 'LAY-app-content-list', |
| | | where: param, |
| | | contentType:'application/json', |
| | |
| | | }); |
| | | </script> |
| | | </head> |
| | | <body> |
| | | <body id="body"> |
| | | <div class="layui-fluid" style="padding-bottom: 0;"> |
| | | <div class="layui-card"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC"> |
| | | <div class="layui-form layui-card-header layuiadmin-card-header-auto" style="border-bottom:1px solid #CCC" id="top"> |
| | | <div class="layui-form-item"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 56px;">仓库编码</label> |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | | <div id="center"></div> |
| | | <div class="layui-card-body"> |
| | | <table id="LAY-app-content-list" lay-filter="LAY-app-content-list"></table> |
| | | <script type="text/html" id="table-content-list"> |
| | |
| | | form = layui.form, |
| | | laypage = layui.laypage, |
| | | layer = layui.layer; |
| | | var h1 = GetTableHeight(); |
| | | refreshTable("","",""); |
| | | var tableIns; |
| | | |
| | |
| | | elem: '#LAY-app-content-list', |
| | | url: IP +"/Sys/GetWarehouseList", |
| | | method: 'POST', |
| | | height: 'full-95', |
| | | height: h1, |
| | | id: 'LAY-app-content-list', |
| | | where: param, |
| | | contentType:'application/json', |
| | |
| | | /// <summary> |
| | | /// 查询库存明细(添加盘点明细时选择查询) |
| | | /// </summary> |
| | | public class GetStockDetailVm |
| | | public class GetStockDetailVm : IndexPage |
| | | { |
| | | public string HouseNo { get; set; } |
| | | public string RoadwayNo { get; set; } |
| | |
| | | } |
| | | |
| | | //获取库存明细信息(盘点选择明细数据源) |
| | | public List<StockDetailDto> GetCheckStockDetailList(string houseNo, string roadwayNo, string locateNo, string msg) |
| | | public List<StockDetailDto> GetCheckStockDetailList(string houseNo, string roadwayNo, string locateNo, string msg, int page, int limit, out int count) |
| | | { |
| | | try |
| | | { |
| | |
| | | .And(m => m.IsDel == "0" && m.SkuNo != "100099" && m.Status == "0") |
| | | .ToExpression();//注意 这一句 不能少 |
| | | |
| | | |
| | | var total = 0; |
| | | var list = Db.Queryable<DataStockDetail>().Where(item).GroupBy(m => new { m.SkuNo, m.SkuName, m.Standard, m.LotNo, m.LotText, m.SupplierLot, m.LocatNo, m.PalletNo }) |
| | | .Select(a => new StockDetailDto() |
| | | { |
| | |
| | | Qty = SqlFunc.AggregateSum(a.Qty), |
| | | LocatNo = a.LocatNo, |
| | | PalletNo = a.PalletNo |
| | | }).ToList(); |
| | | }).ToOffsetPage(page, limit, ref total); |
| | | count = total; |
| | | |
| | | return list; |
| | | } |
| | |
| | | /// <param name="locateNo">储位号</param> |
| | | /// <param name="msg">物料编码、名称、批次号</param> |
| | | /// <returns></returns> |
| | | List<StockDetailDto> GetCheckStockDetailList(string houseNo,string roadwayNo,string locateNo,string msg); |
| | | List<StockDetailDto> GetCheckStockDetailList(string houseNo,string roadwayNo,string locateNo,string msg, int page, int limit, out int count); |
| | | |
| | | /// <summary> |
| | | /// 获取编辑盘点单时信息 |
| | |
| | | { |
| | | try |
| | | { |
| | | var bolls = _stockCheckSvc.GetCheckStockDetailList(model.HouseNo, model.RoadwayNo, model.LocateNo, model.Msg); |
| | | var bolls = _stockCheckSvc.GetCheckStockDetailList(model.HouseNo, model.RoadwayNo, model.LocateNo, model.Msg, model.Page, model.Limit, out int count); |
| | | |
| | | return Ok(new { code = 0, count = bolls.Count, msg = "获取库存明细信息", data = bolls }); |
| | | return Ok(new { code = 0, count, msg = "获取库存明细信息", data = bolls }); |
| | | } |
| | | catch (Exception e) |
| | | { |