JC24WMS.git - Gitblit

			@@ -2,6 +2,8 @@
			using System.Collections.Generic;
			using System.Linq;
			using System.Text;
			using Model.ModelDto.DataDto;
			using SqlSugar;
			using WMS.Entity.Context;
			using WMS.Entity.DataEntity;
			using WMS.Entity.SysEntity;
			@@ -14,14 +16,12 @@
			/// 分配货物
			/// </summary>
			/// <param name="palletList">库存明细集合</param>
			/// <param name="goodCode">物料编码</param>
			/// <param name="lotNo">批次</param>
			/// <param name="needQty">需要分配的数量</param>
			/// <param name="fullPalletQty">满托数量</param>
			/// <param name="fullBoxQty">满箱数量</param>
			/// <param name="stockQtyDic">托出库物品数 key:库存托盘表的ID、val:托盘上的数量</param>
			/// <returns></returns>
			public int AllotPallets(List<DataStockDetail> palletList, int needQty, int fullPalletQty, int fullBoxQty, Dictionary<int, int> stockQtyDic)
			public decimal AllotPallets(List<DataStockDetail> palletList, decimal needQty, int fullPalletQty, int fullBoxQty, Dictionary<int, decimal> stockQtyDic)
			{
			//优先先进先出（快过期的先出）
			//优先零箱、零托（出完零箱出整箱）
			@@ -53,20 +53,17 @@
			}
			}
			#endregion
			var qty = 0; //分配的总数量
			var ztNum = needQty / fullPalletQty;//需要整托数
			decimal qty = 0; //分配的总数量
			var list = GetDataListOrderByDept(palletList);

			var zps = palletList.Where(s => s.Qty >= fullPalletQty).ToList();//整托
			var sps = palletList.Where(s => s.Qty < fullPalletQty).ToList();//散托(有可能是被锁定了数量的)

			if (allotSet == 0)//优先零箱（出完零箱出整箱）
			if (fullPalletQty == 0)//无包装物料分配
			{
			//已分配的托盘 key：库存明细ID，value：分配的数量
			var st = sps.OrderBy(s => s.ExpirationTime).ThenBy(s => s.Qty - s.LockQty - s.FrozenQty).ToList();//所有未使用的托盘（未被分配的）
			//散托
			var st = list.OrderBy(s => s.ExpirationTime).ThenBy(s => s.Qty - s.LockQty - s.FrozenQty).ToList();//所有未使用的托盘（未被分配的）
			//
			foreach (var s in st)
			{
			var detailQty = int.Parse((s.Qty - s.LockQty - s.FrozenQty).ToString());
			var detailQty = decimal.Parse((s.Qty - s.LockQty - s.FrozenQty).ToString());
			if (needQty - qty < detailQty)
			{
			var num = needQty - qty;
			@@ -82,109 +79,144 @@
			break;
			}
			}

			//不够//取整托
			if (qty < needQty)
			{
			var zt = zps.OrderBy(s => s.ExpirationTime).ToList();//所有未使用的托盘（未被分配的）
			foreach (var ss in zt)
			{
			var detailQty = int.Parse((ss.Qty - ss.LockQty - ss.FrozenQty).ToString());
			if (needQty - qty < detailQty)
			{
			var num = needQty - qty;
			qty += num;
			SaveDic(stockQtyDic, ss.Id, num);
			break;
			}
			qty += detailQty;
			SaveDic(stockQtyDic, ss.Id, detailQty);

			if (qty >= needQty)
			{
			break;
			}
			}


			}

			}
			else if (allotSet == 1)//优先整托（分配合适的整托数量）
			else
			{
			//先判断需要的数量
			//判断需要整托的数量是否大于0
			//是：先出整托，剩余的数量从托盘上数量最少的出、（如果找合适的数量、可能小数量很小概率会被分配到、有先进先出日期卡着）
			//否：数量从托盘上数量最少的出、（如果找合适的数量、可能小数量很小概率会被分配到、有先进先出日期卡着）
			//
			//取整托
			if (ztNum > 0)
			{
			var zt = zps.OrderBy(s => s.ExpirationTime).ToList();//所有未使用的托盘（未被分配的）
			foreach (var ss in zt)
			{
			var detailQty = int.Parse((ss.Qty - ss.LockQty - ss.FrozenQty).ToString());
			if (needQty - qty < detailQty)
			{
			break;
			}
			qty += detailQty;
			SaveDic(stockQtyDic, ss.Id, detailQty);
			if (qty >= needQty)
			{
			break;
			}
			}
			}
			//从整托和和散托中查找合适的(从数量少的先出往)
			if (qty < needQty)
			{
			var sIds = stockQtyDic.Select(s => s.Key).ToList();
			var zt = sps.Where(s => !sIds.Contains(s.Id)).OrderBy(s => s.ExpirationTime).ThenBy(m => m.Qty - m.LockQty - m.FrozenQty).ToList();//所有未使用（未被分配的）
			var ztNum = needQty / fullPalletQty;//需要整托数

			foreach (var ss in zt)


			var zps = list.Where(s => s.Qty >= fullPalletQty).ToList();//整托
			var sps = list.Where(s => s.Qty < fullPalletQty).ToList();//散托(有可能是被锁定了数量的)

			if (allotSet == 0)//优先零箱（出完零箱出整箱）
			{
			//已分配的托盘 key：库存明细ID，value：分配的数量
			var st = sps.OrderBy(s => s.ExpirationTime).ThenBy(s => s.Qty - s.LockQty - s.FrozenQty).ToList();//所有未使用的托盘（未被分配的）
			//散托
			foreach (var s in st)
			{
			var detailQty = int.Parse((ss.Qty - ss.LockQty - ss.FrozenQty).ToString());
			var detailQty = decimal.Parse((s.Qty - s.LockQty - s.FrozenQty).ToString());
			if (needQty - qty < detailQty)
			{
			var num = needQty - qty;
			qty += num;
			SaveDic(stockQtyDic, ss.Id, num);
			SaveDic(stockQtyDic, s.Id, num);
			break;
			}
			qty += detailQty;
			SaveDic(stockQtyDic, ss.Id, detailQty);
			if (qty >= needQty)
			{
			break;
			}
			}
			}
			//找完散托还不够再找整托
			if (qty < needQty)
			{
			var sIds = stockQtyDic.Select(s => s.Key).ToList();
			var zt = zps.Where(s => !sIds.Contains(s.Id)).OrderBy(s => s.ExpirationTime).ThenBy(m => m.Qty - m.LockQty - m.FrozenQty).ToList();//所有未使用（未被分配的）
			foreach (var ss in zt)
			{
			var detailQty = int.Parse((ss.Qty - ss.LockQty - ss.FrozenQty).ToString());
			if (needQty - qty < detailQty)
			{
			var num = needQty - qty;
			qty += num;
			SaveDic(stockQtyDic, ss.Id, num);
			break;
			}
			qty += detailQty;
			SaveDic(stockQtyDic, ss.Id, detailQty);
			if (qty >= needQty)
			{
			break;
			}
			}
			}

			qty += detailQty;
			SaveDic(stockQtyDic, s.Id, detailQty);
			if (qty >= needQty)
			{
			break;
			}
			}

			//不够//取整托
			if (qty < needQty)
			{
			var zt = zps.OrderBy(s => s.ExpirationTime).ToList();//所有未使用的托盘（未被分配的）
			foreach (var ss in zt)
			{
			var detailQty = decimal.Parse((ss.Qty - ss.LockQty - ss.FrozenQty).ToString());
			if (needQty - qty < detailQty)
			{
			var num = needQty - qty;
			qty += num;
			SaveDic(stockQtyDic, ss.Id, num);
			break;
			}
			qty += detailQty;
			SaveDic(stockQtyDic, ss.Id, detailQty);

			if (qty >= needQty)
			{
			break;
			}
			}


			}

			}
			else if (allotSet == 1)//优先整托（分配合适的整托数量）
			{
			//先判断需要的数量
			//判断需要整托的数量是否大于0
			//是：先出整托，剩余的数量从托盘上数量最少的出、（如果找合适的数量、可能小数量很小概率会被分配到、有先进先出日期卡着）
			//否：数量从托盘上数量最少的出、（如果找合适的数量、可能小数量很小概率会被分配到、有先进先出日期卡着）
			//
			//取整托
			if (ztNum > 0)
			{
			var zt = zps.OrderBy(s => s.ExpirationTime).ToList();//所有未使用的托盘（未被分配的）
			foreach (var ss in zt)
			{
			var detailQty = decimal.Parse((ss.Qty - ss.LockQty - ss.FrozenQty).ToString());
			if (needQty - qty < detailQty)
			{
			break;
			}
			qty += detailQty;
			SaveDic(stockQtyDic, ss.Id, detailQty);
			if (qty >= needQty)
			{
			break;
			}
			}
			}
			//从整托和和散托中查找合适的(从数量少的先出往)
			if (qty < needQty)
			{
			var sIds = stockQtyDic.Select(s => s.Key).ToList();
			var zt = sps.Where(s => !sIds.Contains(s.Id)).OrderBy(s => s.ExpirationTime).ThenBy(m => m.Qty - m.LockQty - m.FrozenQty).ToList();//所有未使用（未被分配的）

			foreach (var ss in zt)
			{
			var detailQty = decimal.Parse((ss.Qty - ss.LockQty - ss.FrozenQty).ToString());
			if (needQty - qty < detailQty)
			{
			var num = needQty - qty;
			qty += num;
			SaveDic(stockQtyDic, ss.Id, num);
			break;
			}
			qty += detailQty;
			SaveDic(stockQtyDic, ss.Id, detailQty);
			if (qty >= needQty)
			{
			break;
			}
			}
			}
			//找完散托还不够再找整托
			if (qty < needQty)
			{
			var sIds = stockQtyDic.Select(s => s.Key).ToList();
			var zt = zps.Where(s => !sIds.Contains(s.Id)).OrderBy(s => s.ExpirationTime).ThenBy(m => m.Qty - m.LockQty - m.FrozenQty).ToList();//所有未使用（未被分配的）
			foreach (var ss in zt)
			{
			var detailQty = decimal.Parse((ss.Qty - ss.LockQty - ss.FrozenQty).ToString());
			if (needQty - qty < detailQty)
			{
			var num = needQty - qty;
			qty += num;
			SaveDic(stockQtyDic, ss.Id, num);
			break;
			}
			qty += detailQty;
			SaveDic(stockQtyDic, ss.Id, detailQty);
			if (qty >= needQty)
			{
			break;
			}
			}
			}

			}
			}

			if (qty < needQty)
			{
			throw new Exception("库存数量不足");
			@@ -206,7 +238,7 @@
			/// <param name="dic"></param>
			/// <param name="key"></param>
			/// <param name="v"></param>
			private void SaveDic(Dictionary<int, int> dic, int key, int v)
			private void SaveDic(Dictionary<int, decimal> dic, int key, decimal v)
			{
			if (dic.ContainsKey(key))
			{
			@@ -220,6 +252,7 @@

			//--------------------------------------------------------------------------------------------------------------

			#region MyRegion

			///// <summary>
			///// 获得背包承重w，装货物o，从第k件向后考虑，得到的最大价值
			@@ -262,5 +295,132 @@
			// return a > b ? a : b;
			//}

			#endregion


			private List<StockDetailDto> GetDataListOrderByDept(List<DataStockDetail> palletList)
			{
			try
			{
			var Db = DataContext.Db;
			var data = new List<StockDetailDto>();

			var list = palletList.Select(m => new StockDetailDto()
			{
			Id = m.Id,
			LotNo = m.LotNo,
			LotText = m.LotText,
			SupplierLot = m.SupplierLot,
			OwnerNo = m.OwnerNo,
			OwnerName = m.OwnerName,
			SupplierNo = m.SupplierNo,
			SupplierName = m.SupplierName,
			SkuNo = m.SkuNo,
			SkuName = m.SkuName,
			Standard = m.Standard,
			Qty = m.Qty,
			LockQty = m.LockQty,
			FrozenQty = m.FrozenQty,
			InspectQty = m.InspectQty,
			ASNNo = m.ASNNo,
			ASNDetailNo = m.ASNDetailNo,
			WareHouseNo = m.WareHouseNo,
			RoadwayNo = m.RoadwayNo,
			AreaNo = m.AreaNo,
			LocatNo = m.LocatNo,
			PalletNo = m.PalletNo,
			PalletNo2 = m.PalletNo2,
			PalletNo3 = m.PalletNo3,
			CompleteTime = m.CompleteTime,
			ProductionTime = m.ProductionTime,
			ExpirationTime = m.ExpirationTime,
			Status = m.Status,
			InspectMark = m.InspectMark,
			BitPalletMark = m.BitPalletMark,
			InspectStatus = m.InspectStatus,
			InspectTime = m.InspectTime,
			PackagNo = m.PackagNo,
			IsBale = m.IsBale,
			IsBelt = m.IsBelt,
			Demo = m.Demo,

			}).ToList();
			//库外托盘
			var detail1 = list.Where(m => string.IsNullOrWhiteSpace(m.LocatNo)).ToList();
			//平库内托盘
			var detail2 = list.Where(m => m.WareHouseNo == "W02").ToList();
			//立库内托盘
			var detail3 = list.Where(m => m.WareHouseNo == "W01").ToList();

			foreach (var item in detail2)
			{
			var dept = item.LocatNo.Substring(5,2);

			item.Dept = int.Parse(dept);
			}
			foreach (var item in detail3)
			{
			var dept = item.LocatNo.Substring(6, 2);

			item.Dept = int.Parse(dept);
			}
			//平库
			var locate1 = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.WareHouseNo == "W02");
			var data2 = new List<StockDetailDto>();
			foreach (var liku in detail2.OrderBy(m => m.Dept).ToList())
			{
			if (data2.Contains(liku))
			{
			continue;
			}
			data2.Add(liku);
			var currentLocate = locate1.First(m => m.LocatNo == liku.LocatNo);
			var locateAfter = locate1.Where(m => m.AreaNo == currentLocate.AreaNo && m.Layer == currentLocate.Layer && m.Row == currentLocate.Row && int.Parse(m.Depth) < int.Parse(currentLocate.Depth)).OrderBy(m => m.Depth).ToList();
			foreach (var locat in locateAfter)
			{
			if (detail3.Any(m => m.LocatNo == locat.LocatNo))
			{
			data2.Add(detail3.First(m => m.LocatNo == locat.LocatNo));
			}

			}
			}

			//立库
			var locate2 = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.WareHouseNo == "W01");
			var data3 = new List<StockDetailDto>();
			foreach (var liku in detail3.OrderBy(m => m.Dept).ToList())
			{
			if (data3.Contains(liku))
			{
			continue;
			}
			data3.Add(liku);
			var currentLocate = locate2.First(m => m.LocatNo == liku.LocatNo);
			var locateAfter = locate2.Where(m => m.Column == currentLocate.Column && m.Layer == currentLocate.Layer && m.Row == currentLocate.Row && int.Parse(m.Depth) < int.Parse(currentLocate.Depth)).OrderBy(m => m.Depth).ToList();
			foreach (var locat in locateAfter)
			{
			if (detail3.Any(m=>m.LocatNo == locat.LocatNo))
			{
			data3.Add(detail3.First(m=>m.LocatNo == locat.LocatNo));
			}

			}
			}


			data.AddRange(detail1);
			data.AddRange(data2);
			data.AddRange(data3);

			return data;
			}
			catch (Exception e)
			{
			throw new Exception(e.Message);
			}
			}


			}
			}