作业个人

计划：

    估计该项目所用时间：   6天

开发：

  需求分析：作为一名排球比赛的观众，我希望知道每场比赛的得分，以便掌握比赛的赛程。（精确到每局得分）

  计划文档：比赛结果的查询。

 

 

 

 

 

 

  

 

 

public partial class Form1 : Form
    {
        Action action = new Action();
        public Form1()
        {
            InitializeComponent();
        }
      
        int i = 1;
        private void btnH_Click(object sender, EventArgs e)
        {
            int H = Convert.ToInt32(txtH.Text);
            int L = Convert.ToInt32(txtL.Text);
            int H1 = Convert.ToInt32(txtH1.Text);
            int L1 = Convert.ToInt32(txtL1.Text);
            txtH.Text = (H+1).ToString();
           
            if (H >= 24 && (H - L) > 1)
            {
                txtH1.Text = (Convert.ToInt32(txtH1.Text) + 1).ToString();
                if ((H1 + L1) == 0)
                {
                    txtCount1.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text;
                }
                if ((H1 + L1) == 1)
                {
                    txtCount2.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text;
                }
                if ((H1 + L1) == 2)
                {
                    txtCount3.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text;
                }
                if ((H1 + L1) == 3)
                {
                    txtCount4.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text;
                }
                if ((H1 + L1) == 4)
                {
                    txtCount5.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text;
                }
                txtH.Text = "0";
                txtL.Text = "0";

                if (txtH1.Text == "3")
                {
                    MessageBox.Show("红方胜利");
                    Insert();
                    txtH.Text = "0";
                    txtH1.Text = "0";
                    txtL.Text = "0";
                    txtL1.Text = "0";
                    txtCount1.Clear();
                    txtCount2.Clear();
                    txtCount3.Clear();
                    txtCount4.Clear();
                    txtCount5.Clear();

                }
            }
            if (H1 + L1 > 3)
            {
                if (H >= 14 && (H - L) > 1)
                {
                    txtH1.Text = (Convert.ToInt32(txtH1.Text) + 1).ToString();

                    if ((H1 + L1) == 4)
                    {
                        txtCount5.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text + "\r\n";
                    }
                    txtH.Text = "0";
                    txtL.Text = "0";

                    if (txtH1.Text == "3")
                    {
                        MessageBox.Show("红方胜利");
                        Insert();
                        txtH.Text = "0";
                        txtH1.Text = "0";
                        txtL.Text = "0";
                        txtL1.Text = "0";
                        txtCount1.Clear();
                        txtCount2.Clear();
                        txtCount3.Clear();
                        txtCount4.Clear();
                        txtCount5.Clear();
                        i = 1;
                    }
                }
            }
        }

        private void btnL_Click(object sender, EventArgs e)
        {
            
            int H = Convert.ToInt32(txtH.Text);
            int L = Convert.ToInt32(txtL.Text);
            int H1 = Convert.ToInt32(txtH1.Text);
            int L1 = Convert.ToInt32(txtL1.Text);
            txtL.Text = (L+1).ToString();
            if (L>= 24&&(L-H )>1)
            {
                txtL1.Text = (Convert.ToInt32(txtL1.Text) + 1).ToString();
                if ((H1 + L1) == 0)
                {
                    txtCount1.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text;
                } if ((H1 + L1) == 1)
                {
                    txtCount2.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text;
                }
                if ((H1 + L1) == 2)
                {
                    txtCount3.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text;
                }
                if ((H1 + L1) == 3)
                {
                    txtCount4.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text;
                }
                if ((H1 + L1) == 4)
                {
                    txtCount5.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text;
                }
                txtH.Text = "0";
                txtL.Text = "0";

                if (txtL1.Text == "3")
                {
                    MessageBox.Show("蓝方胜利");
                    Insert();
                    txtH.Text = "0";
                    txtH1.Text = "0";
                    txtL.Text = "0";
                    txtL1.Text = "0";
                    txtCount1.Clear();
                    txtCount2.Clear();
                    txtCount3.Clear();
                    txtCount4.Clear();
                    txtCount5.Clear();
                }
            }
            if (H1 + L1 > 3)
            {
                if (L >= 14 && (L - H) > 1)
                {
                    txtL1.Text = (Convert.ToInt32(txtL1.Text) + 1).ToString();
                    if ((H1 + L1) == 4)
                    {
                        txtCount5.Text += "第" + (i++) + "局:" + txtH.Text + ":" + txtL.Text;
                    }
                    txtH.Text = "0";
                    txtL.Text = "0";

                    if (txtL1.Text == "3")
                    {
                        MessageBox.Show("蓝方胜利");
                        Insert();
                        txtH.Text = "0";
                        txtH1.Text = "0";
                        txtL.Text = "0";
                        txtL1.Text = "0";
                        txtCount1.Clear();
                        txtCount2.Clear();
                        txtCount3.Clear();
                        txtCount4.Clear();
                        txtCount5.Clear();
                        i = 1;
                    }
                }
            }
           
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Form2 f2 = new Form2();
            f2.Show();

        }
        public void Insert() 
        {
            Model M = new Model();
            M.IDA = textBox1.Text.Trim().ToString();
            M.IDB = textBox2.Text.Trim().ToString();
            M.ONE = txtCount1.Text.Trim().Substring(4, 4);
            M.TWO = txtCount2.Text.Trim().Substring(4, 4);
            M.THREE = txtCount3.Text.Trim().Substring(4, 4);
            if (txtCount4.Text == "")
            {
                M.FOUR = null;
            }
            else
            {
                M.FOUR = txtCount4.Text.Trim().Substring(4, 4);
            }
            if (txtCount5.Text == "")
            {
                M.FIVE = null;
            }
            else
            {
                M.FIVE = txtCount5.Text.Trim().Substring(4, 4);
            }

            M.SUM = txtH1.Text.ToString() + ":" + txtL1.Text.ToString();
            action.InsertPK(M);
        }
       
    }

public partial class Form2 : Form
    {
        Action action = new Action();
        public Form2()
        {
            InitializeComponent();
        }

        private void Form2_Load(object sender, EventArgs e)
        {
            dataGridView1.DataSource = action.DataGridViewLoad();
        }
    }

 public class Model
    {
       public string IDA { get; set; }
       public string IDB { get; set; }
       public string ONE { get; set; }
       public string TWO{ get; set; }
       public string THREE { get; set; }
       public string FOUR { get; set; }
       public string FIVE { get; set; }
       public string SUM { get; set; }

    }

 public class Action
    {
       public DataTable DataGridViewLoad()
       {
           string sql = "select * from ballgeren";
           //SqlConnection con = new SqlConnection("server=.;database=itcast;Integrated Security=ture;");
           DataTable dt = SqlHelper.ExecuteDataTable(sql);
           return dt;
       }
       public int InsertPK(Model M)
       {
           string sql = "insert into ballgeren values(@IDA,@IDB,@ONE,@TWO,@THREE,@FOUR,@FIVE,@SUM)";
           SqlParameter[] pms = { new SqlParameter("@IDA",M.IDA),
                                new SqlParameter("@IDB",M.IDB),
                                new SqlParameter("@ONE",M.ONE),
                                new SqlParameter("@TWO",M.TWO),
                                new SqlParameter("@THREE",M.THREE),
                                new SqlParameter("@FOUR",M.FOUR==null?DBNull.Value.ToString():M.FOUR),
                                new SqlParameter("@FIVE",M.FIVE==null?DBNull.Value.ToString():M.FIVE),
                                new SqlParameter("@SUM",M.SUM)};
           int count = SqlHelper.ExecuteNonQuery(sql, pms);
           return count;
       }
    }