一、计划

          这个程序需要四天。

 二、开发

      1、需求分析:

       用户故事:作为一个教练,我希望了解每一场队友和对方的比赛加分和扣分细节,以及所有队员每一场的得分与排行情况,以便于更好的对队员做出战术安排。(满意条件:精确到每一局的结果比分)。

                      从分析用例故事可以知道完成此程序需要这四项任务:1.选择队伍 2.查看本队比赛情况(外加本场本队的对方情况)3.查询比赛记录 4.链接数据库

      2.设计文档:

       赛制分析:

      以奥运会赛制为例:预选赛、小组赛、淘汰赛(四分之一)、半决赛、决赛。预选赛:选出十二支队伍小组赛:单循环赛制,选出以积分排名每组前4,进行八强淘汰,A、B两队A1vsB4,A4vsB1,剩余抽签配对。半决赛:A1/B4胜方VS  A2/B2(B3)胜方;A4vsB1胜方VS  A2/B3(B2)胜方。小组赛排名第6的并列第11名,第5的并列第9名,淘汰赛负方并列第5,。小组赛排名由总分决定。若平局。按获胜次数决定,按输赢比率决定,按得分比率决定,按最后一场获胜代表队排名靠前。

      积分规则

      若为3:0或3:1,胜者得3分,负者不得分。若为3:2,胜者2分,负者1分。

中国队名单

主攻:2号朱婷、9号张常宁、12号惠若琪(队长)、10号刘晓彤

副攻:1号袁心玥、17号颜妮、11号徐云丽

接应:6号龚翔宇、3号杨方旭

二传:7号魏秋月、16号丁霞

自由人:15号林莉

 

塞尔维亚队名单

二传:10号奥杰年诺维奇(Ognjenović),兹维科维奇(Živković);

接应:布拉克塞维奇(Brakočević),19号博斯科维奇(Bošković);

主攻:9号米哈伊洛维奇(Mihajlović),尼克里奇(Nikolić),6号马列舍维奇(Malešević),布萨(Buša);

副攻:16号拉西奇(Rašić),维利科维奇(Veljković),15号斯塔瓦诺维奇(Stevanović);

自由人:17号波波维奇(Popović)。

      3.设计复审:

       由寝室的室友进行复查,提出建议。

      4.代码规范:

       根据Visual Studio 2010规范去写。

      5.具体设计:

      我制定的积分规则如下:

                              1、计分方式:比赛结果为3:0、3:1时,胜队积3分,负队积0分;比赛结果为3:2时,胜队积3分,负队积2分;积分高者排名在前。

                              2、当积分相等时,决定名次顺序为:①谁的胜场多;②每局比分的差距

           活动图:

 

          6.具体编码:(以下为代码)

      private void lblIndex_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)//跳转到查询页面
        {
            this.Close();
            historySelect a = new historySelect();
            a.Show();
        }

        private void begin_Click(object sender, EventArgs e)//比赛开始并且检测是否为空
        {
            if (textName.Text.Trim() == "" || Ateam.Text.Trim() == "" || Bteam.Text.Trim() == "")
            {
                MessageBox.Show("比赛名、队伍名均不能为空");
            }
            else
            {
                writeHistory1 w = new writeHistory1();
                w.bisai(textName.Text);
                w.TeamA(Ateam.Text);
                w.TeamB(Bteam.Text);
                w.Show();
                this.Close();
            }
            
        }

        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)//退出
        {
           Application.Exit();
        }

 

 计分界面:

int sA, sB;
        StringBuilder sb = new StringBuilder();
       
        public string bisai(string str)//获取比赛名控件值
        {
            return name.Text = str;
        }
        public void TeamA(string str)//获取甲方队伍名 
        {
            teamA.Text = str;
        }
        public void TeamB(string str)//获取乙方队伍名 
        {
            teamB.Text = str;
        }
        public void insert(string win) //记录插入
        {
            string sql = "insert into paiqiu(game,teamA,teamB,one,two,three,four,five,win,qiangqing) values(@game,@teamA,@teameB,@one,@two,@three,@four,@five,@win,@qiangqing)";
            SqlParameter[] sp = {
                                        new SqlParameter("@game",name.Text),
                                        new SqlParameter("@teamA",teamA.Text),
                                        new SqlParameter("@teameB",teamB.Text),
                                        new SqlParameter("@one",one),
                                        new SqlParameter("@two",two),
                                        new SqlParameter("@three",three),
                                        new SqlParameter("@four",four==null?DBNull.Value:(object)four),
                                        new SqlParameter("@five",five==null?DBNull.Value:(object)five),
                                        new SqlParameter("@win",win),
                                        new SqlParameter("@qiangqing",sb.ToString())
                                    };
            SqlHelper.ExecuteNonQuery(sql, sp);
        }
        public void insertPM( string team,int score,int chang,int ju) //排名插入
        {
            string sql = "insert into paiming values(@game,@team,@score,@chang,@ju)";
            SqlParameter[] sp = {
                                    new SqlParameter("@game",name.Text),
                                    new SqlParameter("@team",team),
                                    new SqlParameter("@score",score),
                                    new SqlParameter("@chang",chang),
                                    new SqlParameter("@ju",ju)    
                                    };
            SqlHelper.ExecuteNonQuery(sql, sp);
        }
        public void update(string team, int score, int chang, int ju) 
        {
            string sql = "update paiming set score=@score,chang=@chang,ju=@ju where dname=@team";
            SqlParameter[] sp = {
                                    new SqlParameter("@score",score),
                                    new SqlParameter("@chang",chang),
                                    new SqlParameter("@ju",ju),
                                    new SqlParameter("@team",team)
                                };
            SqlHelper.ExecuteNonQuery(sql, sp);
        }
        public void select(string team,int score,int chang,int ju) 
        {
            string sql = "select * from paiming where sname='"+name.Text.ToString()+"' and dname='"+team+"'";
            SqlDataReader reader=SqlHelper.ExecuteReader(sql);
            if (reader.HasRows) 
            {
                while (reader.Read())
                {
                    int score0 = Convert.ToInt32(reader[2]) + score;
                    int chang0 = Convert.ToInt32(reader[3]) + chang;
                    int ju0 = Convert.ToInt32(reader[4]) + ju;
                    update(team, score0, chang0, ju0);
                }
            }
            else
            {
                insertPM(team, score, chang, ju);
            }
        }
        string one=null, two=null, three=null, four=null, five=null;

        private void A_Click(object sender, EventArgs e)//甲方加分
        {
            int a=int.Parse(scoreA.Text) + 1;
            int b = int.Parse(scoreB.Text);
            sb.AppendFormat("{0}:{1}={2}:{3}\r\n", teamA.Text, teamB.Text, a, b);
            
            int i=Convert.ToInt32( lblNum.Text.Substring(1, 1));
            int sa = Convert.ToInt32(lblA.Text);
            scoreA.Text = a.ToString();
            if (i < 5)
            {
                if (a >= 25 && a - b >= 2)
                {
                    string str = string.Format("本局甲方:{0}胜", teamA.Text);
                    MessageBox.Show(str);
                    scoreA.Text = "0";
                    scoreB.Text = "0";
                    sa++; i++;
                    lblA.Text = (sa).ToString();
                    lblNum.Text = "第" + i + "局";
                    sb.AppendFormat("第{0}局  {1}:{2}={3}:{4}  本局{5}胜\r\n", i - 1, teamA.Text, teamB.Text, a, b, teamA.Text);
                    switch(i-1)
                    {
                        case 1:one=string.Format("{0}:{1}",a,b); break;
                        case 2:two=string.Format("{0}:{1}",a,b); break;
                        case 3:three=string.Format("{0}:{1}",a,b); break;
                        case 4:four=string.Format("{0}:{1}",a,b); break;
                    }
                }
            }
            else 
            {
                if(a>=15&&a-b>=2)
                {
                    sb.AppendFormat("第{0}局  {1}:{2}={3}:{4}  本局{5}胜\r\n", i - 1, teamA.Text, teamB.Text, a, b, teamA.Text);
                    string str = string.Format("本局甲方:{0}胜", teamA.Text);
                    MessageBox.Show(str);
                    sa++;
                    lblA.Text = (sa).ToString();
                    five=string.Format("{0}:{1}",a,b);
                }
            }
            if (sa == 3) {
                sb.AppendFormat("本场比赛甲方:{0}胜\r\n比赛结束",teamA.Text);
                string str=string.Format("本场比赛{0}胜",teamA.Text);
                win.Text = str;
                win.Visible = true;
                A.Visible = false;
                B.Visible = false;
                insert(teamA.Text);
                if (lblB.Text == "2") { sA = 2; sB = 1; }
                else { sA = 3; sB = 0; }
                select(teamA.Text.ToString(),sA,1,sa);
                select(teamB.Text.ToString(), sB, 0, Convert.ToInt32(lblB.Text));
            }
            textBox1.Text = sb.ToString();
        }
        
        private void B_Click(object sender, EventArgs e)//乙方加分
        {
            int a = int.Parse(scoreB.Text) + 1;
            int b = int.Parse(scoreA.Text);
            sb.AppendFormat("{0}:{1}={2}:{3}\r\n", teamA.Text, teamB.Text, b, a);
            
            int i = Convert.ToInt32(lblNum.Text.Substring(1, 1));
            int sa = Convert.ToInt32(lblB.Text);
            scoreB.Text =a.ToString();
            if (i < 5)
            {
                if (a >= 25 && a - b >= 2)
                {
                    string str = string.Format("本局乙方:{0}胜",teamB.Text);
                    MessageBox.Show(str);
                    scoreA.Text = "0";
                    scoreB.Text = "0";
                    sa++; i++;
                    lblB.Text = (sa).ToString();
                    lblNum.Text = "第" + i + "局";
                    sb.AppendFormat("第{0}局  {1}:{2}={3}:{4}  本局{5}胜\r\n", i - 1, teamA.Text, teamB.Text, b, a, teamB.Text);
                    switch (i - 1)
                    {
                        case 1: one = string.Format("{0}:{1}", b, a); break;
                        case 2: two = string.Format("{0}:{1}", b, a); break;
                        case 3: three = string.Format("{0}:{1}", b, a); break;
                        case 4: four = string.Format("{0}:{1}", b, a); break;
                    }
                }
            }
            else
            {
                if (a >= 15 && a - b >= 2)
                {
                    sb.AppendFormat("第{0}局  {1}:{2}={3}:{4}  本局{5}胜\r\n", i-1,teamA.Text,teamB.Text ,b, a,teamB.Text);
                    string str = string.Format("本局乙方:{0}胜", teamB.Text);
                    MessageBox.Show(str);
                    sa++;
                    lblB.Text = (sa).ToString();
                    five = string.Format("{0}:{1}", b, a);
                }
            }
            if (sa == 3) {
                sb.AppendFormat("本场比赛乙方:{0}胜\r\n比赛结束", teamB.Text);
                string str = string.Format("本场比赛{0}胜", teamB.Text);
                win.Text = str;
                win.Visible = true;
                A.Visible = false;
                B.Visible = false;
                insert(teamB.Text);
                if (lblA.Text == "2") { sB = 2; sA = 1; }
                else { sB = 3; sA = 0; }
                select(teamB.Text.ToString(), sB, 1, sa);
                select(teamA.Text.ToString(), sA, 0, Convert.ToInt32(lblA.Text));
            }
            textBox1.Text = sb.ToString();
        }

        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)//记录显示
        {
            if (textBox1.Visible == false)
            {
                textBox1.Visible = true;
            }
            else 
            {
                textBox1.Visible = false;
            }
        }

        private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)//比赛重置
        {
            this.Close();
            writeHistory0 a = new writeHistory0();
            a.Show();
          
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            sb.AppendFormat("比赛名称:{0}\r\n甲方:{1}  乙方:{2}\r\n",name.Text, teamA.Text, teamB.Text);
            textBox1.Text = sb.ToString();
        }

        private void lblIndex_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)//跳转到查询
        {
            this.Close();
            historySelect a = new historySelect();
            a.Show();
        }

        private void linkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)//退出
        {
            Application.Exit();
        }
      

        private void btn1_Click(object sender, EventArgs e)//甲方减分
        {
            int a = int.Parse(scoreA.Text);
            int b = int.Parse(scoreB.Text);
            if (a > 0)
            {
                a--;
                scoreA.Text = a.ToString();
                sb.AppendFormat("比赛受到争议:甲方减分\r\n{0}:{1}={2}:{3}\r\n", teamA.Text, teamB.Text, a, b);
                textBox1.Text = sb.ToString();
            }
            else 
            {
                MessageBox.Show("操作失败");
            }
        }

        private void btn2_Click(object sender, EventArgs e)//乙方减分
        {
            int a = int.Parse(scoreA.Text);
            int b = int.Parse(scoreB.Text);
            if (b > 0)
            {
                b--;
                scoreB.Text = b.ToString();
                sb.AppendFormat("比赛受到争议:乙方减分\r\n{0}:{1}={2}:{3}\r\n", teamA.Text, teamB.Text, a, b);
                textBox1.Text = sb.ToString();
            }
            else
            {
                MessageBox.Show("操作失败");
            }
        }

比赛记录查询:

private void cmbLoad()
        {
            cmbName.Items.Clear();

            string sql = "select game from paiqiu";
            SqlDataReader reader = SqlHelper.ExecuteReader(sql);
            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    cmbName.Items.Add(reader[0]);
                }
            }
            reader.Close();
        }
        private void dgvLoad()
        {
            string sql = "select * from paiqiu";
            dgvGame.DataSource = SqlHelper.ExecuteDataTable(sql);
        }
        private void Form2_Load(object sender, EventArgs e)
        {
            cmbLoad();
            dgvLoad();
            
        }

        private void select_Click(object sender, EventArgs e)//单个查询
        {
            StringBuilder sql = new StringBuilder("select * from paiqiu where 1=1");
            if (!string.IsNullOrEmpty(cmbName.Text))
            {
                sql.Append(" and game like '%" + cmbName.Text + "%'");
            }
            SqlDataReader reader= SqlHelper.ExecuteReader(sql.ToString());
            if (reader.HasRows)
            {
                dgvGame.DataSource = SqlHelper.ExecuteDataTable(sql.ToString());
            }
            else 
            {
                MessageBox.Show("没有查询到比赛记录!");
            }
        }

        private void lblWrite_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)//跳转计分页面
        {
            this.Close();
            writeHistory0 a = new writeHistory0();
            a.Show();
        }

        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
             Application.Exit();
        }

        private void dgvGame_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            int x = e.ColumnIndex;
            int y = e.RowIndex;
            if(x==0&&y!=-1)
            {
                child ch = new child();
                ch.xq(dgvGame.CurrentRow.Cells[11].Value.ToString());
                ch.Show();
            }
          

        }

        private void button1_Click(object sender, EventArgs e)
        {
            selectPM sp = new selectPM();
            sp.Show();
        }

比赛排名查询:

 private void selectPM_Load(object sender, EventArgs e)
        {
            string sql = "select * from paiming";
            dgvPM.DataSource = SqlHelper.ExecuteDataTable(sql);
            for (int i =1 ; i < dgvPM.Rows.Count+1 ; i++)
            {
                dgvPM.Rows[i-1].Cells["ranking"].Value = i;
            }
        }

        private void dgvPM_Sorted(object sender, EventArgs e)
        {
            for (int i = 1; i < dgvPM.Rows.Count + 1; i++)
            {
                dgvPM.Rows[i - 1].Cells["ranking"].Value = i;
            }
        }

   运行截图:

          7.代码复审:

          由寝室室友进行复审,查漏补缺。

           8.测试:测试三次(通过)

三、报告

          1.测试报告:

          2.计算工作量:实际工作时间为4天零8个小时。

          3.事后总结与过程改进计划:

           排球积分程序完成后我发现了自己有很多不足的地方,首先对于一开始的目标不明确,不知如何下手,出发点不清而浪费了好多时间;其次在设计过程中尤其是代码编写的过程中遇到了不小的问题,很多老师讲过的都不太会,这点以后必须要改进,有些重要地方需要做下笔记;最后对于这个积分程序还有很多的不足,可以说是个半成品,这如果是在公司里做项目是绝对不允许的,随后两天我会把这个程序再完善下,期间出现的bug还没来的及修改。总体来说这是我第一次做这个工程,共勉吧!