Foreach 循环，直到 i == x

问：

我想在> x 后立即运行 foreach 循环 我在foreach之前尝试过i while loop Do 循环 但是，即使我相等，foreach 仍然运行 我不知道我应该如何运行它

我需要它运行 9999 次，然后做一些事情，然后从下一个 9999 开始，依此类推

我已经更新了整个代码 我需要在数据表中实现当时批处理大小为 9999 的所有行，然后运行 restsharp，然后转到下一个 9999

当数据表中的所有行都完成后，我需要转到sql查询并运行下一个查询，然后是新的数据表和相同的batchsize 9999

请帮忙

这是我的代码

        protected void run_Click1(object sender, ImageClickEventArgs e)
        {
            var body = "";
            string[] evenNums = new string[3];
            evenNums[0] = "2";
            evenNums[1] = "3";
            evenNums[2] = "4";
            var daytime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss", CultureInfo.GetCultureInfo("sv-SE"));
            var day = DateTime.Now.ToString("yyyyMMdd", CultureInfo.GetCultureInfo("sv-SE"));
            foreach (string Site in evenNums)
            {
                body = "{\"requestId\": \"144x25\",\"items\": [";


                using (SqlConnection con = new SqlConnection())
                {
                    string conn_str = ConfigurationManager.ConnectionStrings["SqlConnection1"].ConnectionString;
                    SqlConnection conn = new SqlConnection(conn_str);

                    string query = "SELECT [number],[surname],[forename],[emailAddress],[taxIdentifier] FROM[Customer]  WITH(NOLOCK) WHERE[CustomerID] IN(SELECT[CustomerID] FROM[Visit] WITH(NOLOCK) WHERE[GamingDate] Between convert(Date, DATEADD(DAY, -365, GETDATE())) AND convert(Date, getdate())) AND(EmailAddress IS NOT NULL) AND(ContactTypes & 1 = 1) AND(HomePropertyID = " + Site + ") /*  2= Malmö  3=Göteborg  4=Stockholm  */ AND(LEN(TaxIdentifier) = '12')";

                    SqlCommand comm = new SqlCommand(query, conn);

                    conn.Open();
                    comm.ExecuteNonQuery();
                    DataTable dt1 = new DataTable();

                    using (SqlDataAdapter adapter = new SqlDataAdapter(comm))
                    {
                        adapter.Fill(dt1);
                    }

                    string newFileName = "C:\\temp\\" + ort + "" + day + "FromNeon_Cleaned.csv";
                    string clientHeader = "number" + "," + "\"surname\"" + "," + "\"forename\"" + "," + "\"repsonseId\"" + "," + "\"responseTime\"" + Environment.NewLine;
                    File.WriteAllText(newFileName, clientHeader);


                    int batchSize = 2;
                    bool willBreak = false;

                    for (int i = 0; i < batchSize; i++)
                    {
                        for (int j = 0; j < dt1.Rows.Count; j++)
                        {
                            DataRow dtRow = dt1.Rows[j];

                            if (i == j)
                            {
                                break; // in there what you want as I understand
                               willBreak = true;
                            }

                            var number = dtRow.ItemArray[0];
                            var surname = dtRow.ItemArray[1];
                            var forename = dtRow.ItemArray[2];
                            var emailAddress = dtRow.ItemArray[3];
                            string taxidentifier = (string)dtRow.ItemArray[4];
                            //string taxidentifier = "2211221143";

                            if (Personnummer.Valid(taxidentifier))
                            {

                                body += "{\"itemId\": \"" + number + "\",\"subjectId\": \"" + taxidentifier + "\"},";

                            }

                            body = body.Remove(body.Length - 1);
                            body += "]}";
                        }
                        if (willBreak) break;
                    }



                    var url = "https://marketing.spelpaus.se/api/marketing-subjectid/mw41yZpBFC";
                    var client = new RestClient(url);
                    var request = new RestRequest(url, Method.Post);
                    request.AddHeader("authorization", "vGrpkoNEWHpMuQVrIKVGfsfx2l7SLbsSfQ7PbISjMyiK545ezHW5BzsfPgJq0HA6");
                    request.AddHeader("Content-Type", "application/json");

                    //var bodyy = JsonConvert.SerializeObject(body);
                    request.AddBody(body, "application/json");
                    RestResponse response = client.Execute(request);

                    if (response.StatusCode == HttpStatusCode.OK)

                    {
                        var obj = JsonConvert.DeserializeObject<dynamic>(response.Content);

                        var alloweditemsdata = (obj.allowedItemIds);
                        var responseId = (obj.responseId);

                        //var responseId1= Convert.ToInt32(responseId.value);
                        dt1.PrimaryKey = new DataColumn[] { dt1.Columns["number"] };


                        foreach (int alloweditem in alloweditemsdata)
                        {
                            DataRow Drw = dt1.Rows.Find(alloweditem);

                            var numberresult = Drw.ItemArray[0];
                            var surnameresult = Drw.ItemArray[1];
                            var forenameresult = Drw.ItemArray[2];
                            var emailAddressresult = Drw.ItemArray[3];
                            string taxidentifierresult = (string)Drw.ItemArray[4];


                            string clientDetails = " " + numberresult + ",\"" + surnameresult + "\",\"" + forenameresult + "\",\"" + emailAddressresult + "\",\"" + responseId + "\",\"" + daytime + "\"" + Environment.NewLine;

                            File.AppendAllText(newFileName, clientDetails, Encoding.Unicode);

                        }

                    }

                
                    
                }
            }
        }