程序修改

zhaowc

20 小时以前 35e3dae48db445e66c9614ee55dba062659e33d7

 Wms/WMS.BLL/DataServer/StockDetailServer.cs

@@ -38,7 +38,7 @@
        /// <param name="bitBoxMark">零箱标记</param>
        /// <param name="inspectStatus">质量状态</param>
        /// <returns></returns>
        public List<StockDetailDto> GetBindList(string wareHouseName, string areaName, string locatNo, string palletNo, string lotNo)
        public List<StockDetailDto> GetBindList(string wareHouseName, string areaName, string locatNo, string palletNo, string lotNo,string palletStatus)
        {
            string str = $@"select 
                                detail.*,
@@ -76,9 +76,24 @@
            {
                str += $" and detail.LotNo like  '%{lotNo}%'";
            }
            if (!string.IsNullOrEmpty(palletStatus))
            {
                str += $" and detail.PalletStatus like  '%{palletStatus}%'";
            }
            //排序
            str += " order by PalletNo";
            List<StockDetailDto> boxInforList = Db.Ado.SqlQuery<StockDetailDto>(str).ToList();
            foreach (var item in boxInforList)
            {
                if (item.LocatNo == "1004" || item.LocatNo == "1002")
                {
                    item.PalletStatus = "0";
                }
                if (item.LocatNo == "1001" || item.LocatNo == "1003")
                {
                    item.PalletStatus = "3";
                }
            }

            return boxInforList;
        }