c# 分配数量

7R903

如下代码，遇到一个问题卡住了，比如allpoQty 是45000时，tempOSQty 分别为3000，27000，15000，
tempOSItem.Gap.GetValueOrDefault();这里每次第一次循环都是3000，也就是45000-3000，而不是经过汇总的，比如首次是45000-3000；第二次是45000-3000-27000，第三次是45000-3000-27000-15000；
这一句感觉也有问题，会找到一些实际已经分了，但是IsAllocation还是false的数据
tempOSList = osList.Where(x => x.Code + x.Customer == strKey).Where(x => !x.IsAllocation)
                .ToList();

我的需求是，将allpo中的qty和date分配到os中，分配的数量不能大于os的qty，如果allpo分配后，os有剩余数，需要拆成多行；反过来也一样，如下图：

初始数据


分配后结果

[C#] 纯文本查看 复制代码

?

001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 056 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092 093 094 095 096 097 098 099 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150

using System; using System.Collections.Generic; using System.Data; using System.Linq;   class Program {     static void Main()     {         var osList = GetOS();         var allpoList = GetALLPO();           string strKey = string.Empty;         var tempOSList = new List<OSList>();                  foreach (var allpoItem in allpoList)         {             int allpoQty = allpoItem.Qty.GetValueOrDefault();               strKey = allpoItem.Code + allpoItem.Customer;               //查找那些未分完的             tempOSList = osList.Where(x => x.Code + x.Customer == strKey).Where(x => !x.IsAllocation)                 .ToList();               if (tempOSList.Count == 0 || allpoQty <= 0) continue; // 简化条件               osList.RemoveAll(x => x.Code + x.Customer == strKey && !x.IsAllocation);               var add = new List<OSList>();             foreach (var tempOSItem in tempOSList)             {                 int tempOSQty = tempOSItem.Qty.GetValueOrDefault() - tempOSItem.Gap.GetValueOrDefault();                   int currentQty = Math.Min(allpoQty, tempOSQty);                                       if (tempOSQty - currentQty == 0)                 {                     tempOSItem.IsAllocation = true;                 }                   if (tempOSItem.Remarks == "allocated")                 {                     var newadd = tempOSItem.Copy();                     newadd.Gap = currentQty;                     newadd.Date = allpoItem.Date;                     newadd.Remarks = "allocated";                     add.Add(newadd);                 }                 else                 {                     tempOSItem.Gap = currentQty;                     tempOSItem.Date = allpoItem.Date;                     tempOSItem.Remarks = "allocated";                     tempOSItem.AllocationSum += currentQty;                 }                   allpoQty -= currentQty;                   if (allpoQty <= 0)                 {                                          break;                 }               }             tempOSList.AddRange(add);             osList.AddRange(tempOSList);         }         Console.ReadKey();     }       public static List<OSList> GetOS()     {         var os = new List<OSList>         {            new OSList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=30000},            new OSList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=12000},            new OSList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=45000},            new OSList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=30000},            new OSList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=33000},            new OSList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=30000},            new OSList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=27000}           };                  return os;     }         public static List<ALLPOList> GetALLPO()     {         var allpo = new List<ALLPOList>         {            new ALLPOList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=45000,Date="2024/12/14"},            new ALLPOList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=27000,Date="2024/12/10"},            new ALLPOList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=30000,Date="2024/12/10"},            new ALLPOList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=45000,Date="2024/12/14"},            new ALLPOList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=30000,Date="2024/12/25"},            new ALLPOList{ To="248776",End="300348",Code="Q13FC1350000200",Customer="1010217255039",Qty=30000,Date="2024/12/21"}         };           return allpo;     }         public class OSList     {         public string To { get; set; }         public string End { get; set; }         public string Code { get; set; }         public string Customer { get; set; }         public int? Qty { get; set; }           public int? Gap { get; set; }           public string Date { get; set; }           public bool IsAllocation { get; set; }           public int? AllocationSum { get; set; }           public string Remarks { get; set; }         public OSList Copy()         {             return new OSList             {                 To = this.To,                 End = this.End,                 Code = this.Code,                 Customer = this.Customer,                 Qty = this.Qty ?? 0             };         }     }         public class ALLPOList     {         public string To { get; set; }         public string End { get; set; }         public string Code { get; set; }         public string Customer { get; set; }         public int? Qty { get; set; }           public string Date { get; set; }     } }