Merge branch 'master' into wxw
| | |
| | | </select> |
| | | </div> |
| | | |
| | | <label class="layui-form-label">客户名称</label> |
| | | <label class="layui-form-label" style="width: 70px;"><p id="CustomerNamep">客户名称</p></label> |
| | | <div class="layui-input-inline"> |
| | | <select name="CustomerName" id="CustomerName" lay-verify="" lay-search> |
| | | <option value=""></option> |
| | |
| | | }); |
| | | var arr = []; |
| | | var TypeValue=$("#Type").val(); |
| | | |
| | | var type0 = [3]; //客户 |
| | | var type1 = [1,5]; //供应商 |
| | | var type2 = [0,2,4,6]; //货主 |
| | | |
| | | // 加载下拉信息 |
| | | getCustomerList(); |
| | |
| | | var value = data.value; |
| | | if(value!=TypeValue){ |
| | | console.log(value); |
| | | getCustomerList(); |
| | | arr = []; |
| | | // 渲染Table |
| | | refreshTable(null); |
| | |
| | | |
| | | // 绑定下拉信息 |
| | | function getCustomerList() { |
| | | /* |
| | | 0:客户 |
| | | 退货入库 |
| | | 3 |
| | | 1:供应商 |
| | | 采购入库、其它入库 |
| | | 1、5 |
| | | 2:货主 |
| | | 成品入库、中间品入库、车间余料入库、代储入库 |
| | | 0、2、4、6 |
| | | */ |
| | | sendData(IP + "/Basis/GetCustomerSelect", {}, 'get', function (res) { |
| | | if (res.code == 0) { //成功 |
| | | $("#CustomerName").empty(); |
| | | $("#CustomerName").append('<option value =""></option>'); |
| | | for (var i = 0; i < res.data.length; i++) { |
| | | $("#CustomerName").append('<option value =' + res.data[i].CustomerNo + '>' + |
| | | res.data[i].CustomerName + '</option>'); |
| | | //判断单据类型 |
| | | if (type0[0] == $("#Type").val()) |
| | | { |
| | | /* |
| | | 0:客户 |
| | | 退货入库 |
| | | 3 |
| | | */ |
| | | if (res.data[i].Type == 0) |
| | | { |
| | | $("#CustomerNamep").html("客户选择"); |
| | | $("#CustomerName").append('<option value =' + res.data[i].CustomerNo + '>' + |
| | | res.data[i].CustomerName + '</option>'); |
| | | } |
| | | } |
| | | else if (type1[0] == $("#Type").val() || type1[1] == $("#Type").val()) |
| | | { |
| | | /* |
| | | 1:供应商 |
| | | 采购入库、其它入库 |
| | | 1、5 |
| | | */ |
| | | if (res.data[i].Type == 1) |
| | | { |
| | | $("#CustomerNamep").html("供应商选择"); |
| | | $("#CustomerName").append('<option value =' + res.data[i].CustomerNo + '>' + |
| | | res.data[i].CustomerName + '</option>'); |
| | | } |
| | | } |
| | | else if (type2[0] == $("#Type").val() || type2[1] == $("#Type").val() || type2[2] == $("#Type").val() || type2[3] == $("#Type").val()) |
| | | { |
| | | /* |
| | | 2:货主 |
| | | 成品入库、中间品入库、车间余料入库、代储入库 |
| | | 0、2、4、6 |
| | | */ |
| | | if (res.data[i].Type == 2) |
| | | { |
| | | $("#CustomerNamep").html("货主选择"); |
| | | $("#CustomerName").append('<option value =' + res.data[i].CustomerNo + '>' + |
| | | res.data[i].CustomerName + '</option>'); |
| | | } |
| | | } |
| | | } |
| | | form.render('select'); |
| | | } else { //不成功 |
| | |
| | | sendData(IP + "/Sys/GetWarehouseDic", {}, 'get', function(res) { |
| | | if (res.code == 0) { //成功 |
| | | for (var i = 0; i < res.data.length; i++) { |
| | | $("#WarehouseName").append('<option value =' + res.data[i].WareHouseNo + '>' + |
| | | $("#WarehouseName").append('<option value =' + res.data[i].WareHouseNo + '>' + res.data[i].WareHouseNo + '-' + |
| | | res.data[i].WareHouseName + '</option>'); |
| | | } |
| | | |
| | |
| | | sendData(IP + "/Sys/GetWarehouseDic", {}, 'get', function(res) { |
| | | if (res.code == 0) { //成功 |
| | | for (var i = 0; i < res.data.length; i++) { |
| | | $("#WareHouseNo").append('<option value =' + res.data[i].WareHouseNo + '>' + |
| | | $("#WareHouseNo").append('<option value =' + res.data[i].WareHouseNo + '>' + res.data[i].WareHouseNo + '-' + |
| | | res.data[i].WareHouseName + '</option>'); |
| | | } |
| | | form.render('select'); |
| | |
| | | $("#RoadwayNo").append('<option value =""></option>'); |
| | | if (res.code == 0) { //成功 |
| | | for (var i = 0; i < res.data.length; i++) { |
| | | $("#RoadwayNo").append('<option value =' + res.data[i].RoadwayNo + '>' + |
| | | $("#RoadwayNo").append('<option value =' + res.data[i].RoadwayNo + '>' + res.data[i].RoadwayNo + '-' + |
| | | res.data[i].RoadwayName + '</option>'); |
| | | } |
| | | form.render('select'); |
| | |
| | | $("#AreaNo").append('<option value =""></option>'); |
| | | if (res.code == 0) { //成功 |
| | | for (var i = 0; i < res.data.length; i++) { |
| | | $("#AreaNo").append('<option value =' + res.data[i].AreaNo + '>' + |
| | | $("#AreaNo").append('<option value =' + res.data[i].AreaNo + '>' + res.data[i].WareHouseNo + '-' + |
| | | res.data[i].AreaName + '</option>'); |
| | | } |
| | | form.render('select'); |
| | |
| | | if (res.code == 0) { //成功 |
| | | $("#RoadwayNo").empty(); |
| | | for (var i = 0; i < res.data.length; i++) { |
| | | $("#WareHouseNo").append('<option value =' + res.data[i].WareHouseNo + '>' + |
| | | $("#WareHouseNo").append('<option value =' + res.data[i].WareHouseNo + '>' + res.data[i].WareHouseNo + '-' + |
| | | res.data[i].WareHouseName + '</option>'); |
| | | } |
| | | $("select[name='WareHouseNo']").val(val); |
| | |
| | | if (res.code == 0) { //成功 |
| | | $("#AreaNo").empty(); |
| | | for (var i = 0; i < res.data.length; i++) { |
| | | $("#AreaNo").append('<option value =' + res.data[i].AreaNo + '>' + |
| | | $("#AreaNo").append('<option value =' + res.data[i].AreaNo + '>' + res.data[i].AreaNo + '-' + |
| | | res.data[i].AreaName + '</option>'); |
| | | } |
| | | $("select[name='AreaNo']").val(val); |
| | |
| | | if (res.code == 0) { //成功 |
| | | $("#RoadwayNo").empty(); |
| | | for (var i = 0; i < res.data.length; i++) { |
| | | $("#RoadwayNo").append('<option value =' + res.data[i].RoadwayNo + '>' + |
| | | $("#RoadwayNo").append('<option value =' + res.data[i].RoadwayNo + '>' + res.data[i].RoadwayNo + '-' + |
| | | res.data[i].RoadwayName + '</option>'); |
| | | } |
| | | $("select[name='RoadwayNo']").val(val); |
| | |
| | | for (var i = 0; i < res.data.length; i++) { |
| | | if (res.data[i].WareHouseNo == 'W01') |
| | | { |
| | | $("#WarehouseName").append('<option value =' + res.data[i].WareHouseNo + ' selected>' + |
| | | $("#WarehouseName").append('<option value =' + res.data[i].WareHouseNo + ' selected>' + res.data[i].WareHouseNo + '-' + |
| | | res.data[i].WareHouseName + '</option>'); |
| | | } |
| | | |
| | |
| | | continue; |
| | | } |
| | | |
| | | $("#WareHouseNo").append('<option value =' + res.data[i].WareHouseNo + '>' + |
| | | $("#WareHouseNo").append('<option value =' + res.data[i].WareHouseNo + '>' + res.data[i].WareHouseNo + '-' + |
| | | res.data[i].WareHouseName + '</option>'); |
| | | } |
| | | $("#WareHouseNo option[value='" + res.data[0].WareHouseNo + "']").attr("selected", "selected") |
| | |
| | | function getRoadway() { |
| | | $("#RoadwayNo").empty(); |
| | | synData(IP + "/Sys/GetRoadwayList", { WareHouseNo: $("#WareHouseNo").val() }, 'get', function (res) { |
| | | //console.log(res) |
| | | // console.log(res) |
| | | if (res.code == 0) { //成功 |
| | | |
| | | for (var i = 0; i < res.data.length; i++) { |
| | | $("#RoadwayNo").append('<option value =' + res.data[i].RoadwayNo + '>' + |
| | | $("#RoadwayNo").append('<option value =' + res.data[i].RoadwayNo + '>' + res.data[i].RoadwayNo + '-' + |
| | | res.data[i].RoadwayName + '</option>'); |
| | | } |
| | | $("#RoadwayNo option[value='" + res.data[0].RoadwayNo + "']").attr("selected", "selected") |
| | |
| | | public string CustomerName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 类型 0 销售客户/货主 1 供货商 |
| | | /// 类型 0 销售客户 1 供货商 2:货主 |
| | | /// </summary> |
| | | public int? Type { get; set; } |
| | | |
| | |
| | | /// Nullable:False |
| | | /// </summary> |
| | | public string RoadwayName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 所属仓库号 |
| | | /// Default: |
| | | /// Nullable:False |
| | | /// </summary> |
| | | public string WareHouseNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 所属仓库名称 |
| | | /// Default: |
| | |
| | | IsBelt = "0", |
| | | CreateUser = userId |
| | | }; |
| | | if (model.SkuQty > pNum) |
| | | { |
| | | throw new Exception($"绑定失败,{model.PalletNo}托盘绑定数量大于该物品托盘包装数量!"); |
| | | } |
| | | // 插入托盘绑定表 |
| | | bindId = Db.Insertable(bind).ExecuteReturnIdentity(); |
| | | } |
| | |
| | | { |
| | | bind.BitPalletMark = "0"; |
| | | } |
| | | if (bind.Qty > pNum) |
| | | { |
| | | throw new Exception($"绑定失败,{bind.PalletNo}托盘绑定数量大于该物品托盘包装数量!"); |
| | | } |
| | | Db.Updateable(bind).Where(m => m.Id == bindId).ExecuteCommand(); |
| | | |
| | | // 更改入库单明细已组数量 |
| | |
| | | //添加托盘记录表数据 |
| | | sqlStr += $"insert into LogPalletTrack values('{model.PalletNo}','{model.AsnNo}','组盘','0',getDate(),{userId},NULL,NULL);"; |
| | | Db.Ado.ExecuteCommand(sqlStr); |
| | | new OperationASNServer().AddLogOperationAsn("PDA模块", "托盘绑定1", model.AsnNo, "添加", $"添加了托盘码为:{model.PalletNo}、{msgStr}的组盘信息", userId); |
| | | new OperationASNServer().AddLogOperationAsn("PDA模块", "托盘绑定", model.AsnNo, "添加", $"添加了托盘码为:{model.PalletNo}、{msgStr}的组盘信息", userId); |
| | | |
| | | Db.CommitTran(); |
| | | } |
| | |
| | | { |
| | | try |
| | | { |
| | | string str = "select RoadwayNo,RoadwayName from SysStorageRoadway where IsDel = @isdel and WareHouseNo = @warehouseno"; |
| | | string str = "select RoadwayNo,RoadwayName,WareHouseNo from SysStorageRoadway where IsDel = @isdel and WareHouseNo = @warehouseno"; |
| | | |
| | | List<RoadwayDto> roadway = Db.Ado.SqlQuery<RoadwayDto>(str, new |
| | | { |