Foreach inside Foreach C#

Question

将值保存到foreach内部，但内部foreach将基于外部foreach。我只想保存这两个数据，但内部foreach将基于外部foreach的Model2.SRL的值。

string[] _stpr = {"\r\n"};
string[] _slr = Model1.SRL.Split(_stpr, RemoveEmptyEntities);
string[] _chs = Model1.CHS.Split(_stpr, RemoveEmptyEntities);
foreach(string _s in _slr)
{
   Model2.SRL = _s; // Test Value : SRL-1 // TotalCount = 5
   Model2.DTL = "Detail";
   Model2.CHS = string.empty;

   functionToSave(ref transaction);
   foreach(string _c in _chs)
   {
      Model2.SRL = _s; // will base on value from outer loop
      Model2.CHS = _c; // Test Value : CHS-1
      functionToSave(ref transaction);
   }
}
commit();

执行此操作时，如果有多个项，则内部foreach的最后一个值将是数据库中的所有列。

Output Result:                          
SRL = SRL-1,    CHS = CHS-1,            
SRL = SRL-2,    CHS = CHS-1,            
SRL = SRL-3,    CHS = CHS-1,            
SRL = SRL-4,    CHS = CHS-1,            
SRL = SRL-5,    CHS = CHS-1,            
Expected Result:
SRL = SRL-1,   CHS = CHS-1
SRL = SRL-2,   CHS = CHS-2
SRL = SRL-3,   CHS = CHS-3
SRL = SRL-4,   CHS = CHS-4
SRL = SRL-5,   CHS = CHS-5

Answer 1

您非常关注机制，而不是依赖框架来为您做苦差事。

这看起来是Zip的一个很好的用例。假设您在下面的代码上有一个using System.Linq;指令：

string[] _stpr = {"\r\n"};
string[] _slr = Model1.SRL.Split(_stpr, RemoveEmptyEntities);
string[] _chs = Model1.CHS.Split(_stpr, RemoveEmptyEntities);
int _counter = 0;
foreach(var _s in _slr.Zip(_chs, (first,second) => new { first, second })
{
   Model2.SRL = _s.first;
   Model2.DTL = "Detail";
   Model2.CHS = _s.second;
}
commit();

您也许能够进一步改进这一点。例如，你似乎有一个单独的Model2实例，它在每次循环中都会被重用。我希望是这样的：

_slr.Zip(_chs, (first,second) => new WhateverModel2Is
    { SRL = first, CHS = second, DTL = "Detail" })

并在每次循环中处理这些实例。

Answer 2

找到答案了。我只是添加了每行的增量计数器，因为它是一个数组。

string[] _stpr = {"\r\n"};
string[] _slr = Model1.SRL.Split(_stpr, RemoveEmptyEntities);
string[] _chs = Model1.CHS.Split(_stpr, RemoveEmptyEntities);
int _counter = 0;
foreach(string _s in _slr)
{
   Model2.SRL = _s; // Test Value : SRL-1 // TotalCount = 5
   Model2.DTL = "Detail";
   Model2.CHS = _chs[_counter];
   _counter++;
}
commit();