关单如果锁定数量=0，修改托盘库存状态

admin

23 小时以前 3d24d66c21c6ab1f2d3bddaf5e2838213cb99969

 Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs

@@ -2016,9 +2016,13 @@
                                string stockDetailSql = $@"select LockQty-{lessQty} as morelockQty from DataStockDetail where IsDel='0' and SkuNo='{d.SkuNo}' and LotNo='{d.LotNo}' and PalletNo='{dr["PalletNo"] + ""}'";
                                decimal morelockQty = Db.Ado.GetDecimal(stockDetailSql);

                                if (morelockQty >= 0)
                                if (morelockQty > 0)
                                {
                                    sqlList.Add($@"update DataStockDetail set LockQty=LockQty-{morelockQty} where IsDel='0' and SkuNo='{d.SkuNo}' and LotNo='{d.LotNo}' and PalletNo='{dr["PalletNo"] + ""}'");
                                    sqlList.Add($@"update DataStockDetail set LockQty=LockQty-{lessQty} where IsDel='0' and SkuNo='{d.SkuNo}' and LotNo='{d.LotNo}' and PalletNo='{dr["PalletNo"] + ""}'");
                                }
                                else if (morelockQty == 0)
                                {
                                    sqlList.Add($@"update DataStockDetail set LockQty=0,Status='0' where IsDel='0' and SkuNo='{d.SkuNo}' and LotNo='{d.LotNo}' and PalletNo='{dr["PalletNo"] + ""}'");
                                }
                            }

@@ -2043,7 +2047,7 @@

                            if (morelockQty >= 0)
                            {
                                sqlList.Add($@"update DataStock set LockQty=LockQty-{morelockQty} where IsDel='0' and SkuNo='{dr["SkuNo"] + ""}' and LotNo='{dr["LotNo"] + ""}'");
                                sqlList.Add($@"update DataStock set LockQty=LockQty-{lessQty} where IsDel='0' and SkuNo='{dr["SkuNo"] + ""}' and LotNo='{dr["LotNo"] + ""}'");
                            }
                        }
                    }