排球比赛记分员

完成这个项目需要一周

1.作为一名现场记分员，我希望详细记录比赛现场比赛情况，以便观众及时掌握比赛情况。

2.需求分析：根据用户需求可知我们此次程序需要做到每次分数变化的时候都要记录。当记分元操作之后就要形成记录。

3.生成设计文档：

由排球比赛用户故事的需求分析可知，此程序是用来记录现场比分情况。

计划复审

目前在进行中

代码规范

根据Visual Studio 2010规范去写。

计划复审

目前在进行中

public static object ExecuteScalar(string sql, params SqlParameter[] pms)
        {
            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlCommand cmd = new SqlCommand(sql, con))
                {
                    if (pms != null)
                    {
                        cmd.Parameters.AddRange(pms);
                    }
                    con.Open();
                    return cmd.ExecuteScalar();
                }
            }
        }

        public static SqlDataReader ExecuteReader(string sql, params SqlParameter[] pms)
        {
            SqlConnection con = new SqlConnection(constr);
            using (SqlCommand cmd = new SqlCommand(sql, con))
            {
                if (pms != null)
                {
                    cmd.Parameters.AddRange(pms);
                }

                try
                {
                    con.Open();
                    return cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);

                }
                catch (Exception)
                {
                    con.Close();
                    con.Dispose();
                    throw;
            }

}

        public static DataTable ExecuteDataTable(string sql, params SqlParameter[] pms)
        {
            DataTable dt = new DataTable();
            using (SqlDataAdapter adapter = new SqlDataAdapter(sql, constr))
            {
                if (pms != null)
                {
                    adapter.SelectCommand.Parameters.AddRange(pms);
                }
                adapter.Fill(dt);
            }
            return dt;
        }
    }
}

namespace Model
{
    public class Teams
    {
        public int ID { get; set; }
        public string TName { get; set; }
        public int WinCount { get; set; }
        public string FCount { get; set; }
        public string JiFen { get; set; }
        public string WinJuCount { get; set; }
        public string FJuCount { get; set; }
        public string _3to0 { get; set; }
        public string _3to1 { get; set; }
        public string _3to2 { get; set; }
        public string _2to3 { get; set; }
        public string _1to3 { get; set; }
        public string _0to3 { get; set; }
    }
}

namespace Model
{
    public class SingleBall
    {
        public int BallNum { get; set; }
        public string GetTeam { get; set; }
        public int WinTeamScore { get; set; }
        public int LoseTeamScore { get; set; }
        public int GetMemberNum { get; set; }
        public string HowGet { get; set; }
        public int LoseMemberNum { get; set; }
    }
}

public class GameNotes
    {
        public int ID { get; set; }
        public string NameA { get; set; }
        public string NameB { get; set; }
        public DateTime Data { get; set; }
        public string R1 { get; set; }
        public string R2 { get; set; }
        public string R3 { get; set; }
        public string R4 { get; set; }
        public string R5 { get; set; }
        public string Place { get; set; }

}

public class Members
    {
        public int ID { get; set; }
        public string MName { get; set; }
        public string TName { get; set; }
        public string Number { get; set; }
        public string Position { get; set; }
        public string Weight { get; set; }
        public string Height { get; set; }
        public int Age { get; set; }
        public string NickName { get; set; }
        public string Strength { get;set; }
    }

}

namespace DAL
{
    public class SingleBallDAL
    {

        public int InsertBallInfo(SingleBall sb)
        {
            string sql = "insert into SingleBall values"+
                "(@BallNum,@GetTeam,@WinTeamScore,@LoseTeamScore,@GetMemberNum,@HowGet,@LoseMemberNum)";
            SqlParameter[] pms = {
                                        new SqlParameter("@BallNum",sb.BallNum),
                                        new SqlParameter("@GetTeam",sb.GetTeam),
                                        new SqlParameter("@WinTeamScore",sb.WinTeamScore),
                                        new SqlParameter("@LoseTeamScore",sb.LoseTeamScore),
                                        new SqlParameter("@GetMemberNum",sb.GetMemberNum),
                                        new SqlParameter("@HowGet",sb.HowGet),
                                        new SqlParameter("@LoseMemberNum",sb.LoseMemberNum),
                                     };
            return SqlHelper.ExecuteNonQuery(sql, pms);
        }
    }
}

namespace VolleyballDal
{
   public class volleyDal
    {
       public DataTable SelectScore(string team)
       {
           string sql = "select * from VolleybalScore where Teams like '%"+team+"%'";
           DataTable dt = SqlHelper.ExecuteDataTable(sql);
           return dt;
       }
       public bool SelectScoreCount(string team)
       {
           string sql = "select count(*) from VolleybalScore where Teams like '%" + team + "%'";
           int count = (int)SqlHelper.ExecuteScalar(sql);
           return count>0;

       }

    }
}

namespace VolleyballBll
{
    public class volleyBll
    {
        private volleyDal dal = new volleyDal();
        public DataTable SelectScore(string team)
        {
            return dal.SelectScore(team);
        }
        public bool SelectScoreCount(string team)
        {
            return dal.SelectScoreCount(team);

}
}
}