同时写入两条数据到数据库方法

 

/// <summary>
    /// 保存
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void submit_Click(object sender, EventArgs e)
    {
       
        try
        {
            Session["fcid"] = Request.QueryString["fcid"];
            string fcid = Convert.ToString(Session["fcid"]);
            for (int i = 1; i < 3; i++)
            {
                if (i == 1)
                {
                    resultInfo resultOne = new resultInfo();
                    resultOne.FMatchName = this.TB_MatchName.Text;
                    resultOne.FCIDme = Convert.ToInt32(fcid);
                    resultOne.FCIDyou = int.Parse(this.UserHiddenField.Value.Trim());
                    resultOne.FTime = Convert.ToDateTime(this.TB_Time.Text);
                    resultOne.FVenue = this.TB_Venue.Text;
                    resultOne.FGrade = this.TB_Grade.Text;
                    resultOne.FFirstPeriod = Convert.ToInt32(this.firstme.Text);
                    resultOne.FTwoPeriod = Convert.ToInt32(this.secondme.Text);
                    resultOne.FThreePeriod = Convert.ToInt32(this.threeme.Text);
                    resultOne.FFourPeriod = Convert.ToInt32(this.fourme.Text);
                    if (this.fiveme.Text.Trim() != "")
                    {
                        resultOne.FOverTimeOne = Convert.ToInt32(this.fiveme.Text);
                        if (this.sixme.Text != "")
                        {
                            resultOne.FOverTimeTwo = Convert.ToInt32(this.sixme.Text);
                            if (this.sevenme.Text != "")
                            {
                                resultOne.FOverTimeThree = Convert.ToInt32(this.sevenme.Text);
                                if (this.eightme.Text != "")
                                {
                                    resultOne.FOverTimeFour = Convert.ToInt32(this.eightme.Text);
                                }
                                else resultOne.FOverTimeFour = 0;
                            }
                            else
                            {
                                resultOne.FOverTimeThree = 0;
                                resultOne.FOverTimeFour = 0;
                            }
                        }
                        else
                        {
                            resultOne.FOverTimeTwo = 0;
                            resultOne.FOverTimeThree = 0;
                            resultOne.FOverTimeFour = 0;
                        }
                    }
                    else
                    {
                        resultOne.FOverTimeOne = 0;
                        resultOne.FOverTimeTwo = 0;
                        resultOne.FOverTimeThree = 0;
                        resultOne.FOverTimeFour = 0;
                    }
                    resultOne.FTotalScore = Convert.ToInt32(this.totalme.Text.Trim());
                    resultOne.Add();
                }
                else
                {
                    resultInfo resultTwo = new resultInfo();
                    resultTwo.FMatchName = this.TB_MatchName.Text;
                    resultTwo.FCIDme = int.Parse(this.UserHiddenField.Value.Trim());
                    resultTwo.FCIDyou = Convert.ToInt32(fcid);
                    resultTwo.FTime = Convert.ToDateTime(this.TB_Time.Text);
                    resultTwo.FVenue = this.TB_Venue.Text;
                    resultTwo.FGrade = this.TB_Grade.Text;
                    resultTwo.FFirstPeriod = Convert.ToInt32(this.firstyou.Text);
                    resultTwo.FTwoPeriod = Convert.ToInt32(this.secondyou.Text);
                    resultTwo.FThreePeriod = Convert.ToInt32(this.threeyou.Text);
                    resultTwo.FFourPeriod = Convert.ToInt32(this.fouryou.Text);
                    if (this.fiveyou.Text.Trim() != "")
                    {
                        resultTwo.FOverTimeOne = Convert.ToInt32(this.fiveyou.Text);
                        if (this.sixyou.Text != "")
                        {
                            resultTwo.FOverTimeTwo = Convert.ToInt32(this.sixyou.Text);
                            if (this.sevenyou.Text != "")
                            {
                                resultTwo.FOverTimeThree = Convert.ToInt32(this.sevenyou.Text);
                                if (this.eightyou.Text != "")
                                {
                                    resultTwo.FOverTimeFour = Convert.ToInt32(this.eightyou.Text);
                                }
                                else resultTwo.FOverTimeFour = 0;
                            }
                            else
                            {
                                resultTwo.FOverTimeThree = 0;
                                resultTwo.FOverTimeFour = 0;
                            }
                        }
                        else
                        {
                            resultTwo.FOverTimeTwo = 0;
                            resultTwo.FOverTimeThree = 0;
                            resultTwo.FOverTimeFour = 0;
                        }
                    }
                    else
                    {
                        resultTwo.FOverTimeOne = 0;
                        resultTwo.FOverTimeTwo = 0;
                        resultTwo.FOverTimeThree = 0;
                        resultTwo.FOverTimeFour = 0;
                    }
                    resultTwo.FTotalScore = Convert.ToInt32(this.totalyou.Text);
                    resultTwo.Add();

                }

            }
            this.repBandToResult(fcid);
            ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "addPerResult", "alert('添加对手成功！');javascript:cancel();", true);
        }
        catch (Exception ex)
        {
            ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "faultMeg", "alert('" + ex.Message.Replace("\r", "").Replace("\n", "") + "');", true);
        }
    }