首页 > 代码库 > 排球计分程序
排球计分程序
一,设计
估计这个任务需要两周的时间
二,开发
1,需求分析---》拆成任务,编写代码
作为一名现场记分员,我希望详细记录比赛现场比分增长情况,以便观众及运动员、教练员及时掌握比赛状况。
任务:1》作为现场记分员需要知道每场比赛每个队伍的计分情况;
2,生成设计文档
由排球用户故事的需求可知,这个程序用来统计各个队伍的比分与积分情况
3,设计复审 2个小时
4,代码规范 按照vs2010进行规范
5,具体设计
每一场比赛的每一局都会在哪个队进一个球之后加一分,
那一队先达到25分,哪个队获胜,五局三胜
6,(a)具体代码(编码) 三天
(b)界面设计(截屏)
编写代码
链接数据库配置文件
<configuration>
<connectionStrings>
<add name="connectionStr" connectionString="server=.;database=paiqiu;integrated security=true"/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0" />
</system.web>
</configuration>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace Lesson1DAL
{
class SqlHelper
{
private static readonly string constr = ConfigurationManager.ConnectionStrings["connectionStr"].ConnectionString;
//执行增删改,左边路线
public static int ExecutNonQuery(string sql, params SqlParameter[] pms)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(sql, con))
{
//判断是否传递了sql参数
if (pms != null)
{
//将参数添加到Parameters集合中
cmd.Parameters.AddRange(pms);
}
con.Open();
return cmd.ExecuteNonQuery();
}
}
}
//执行查询单个值,最左边路线
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 ExecuteReadr(string sql, params SqlParameter[] pms)
{
SqlConnection con = new SqlConnection(constr);
using (SqlCommand cmd = new SqlCommand(sql, con))
{
if (pms != null)
{
cmd.Parameters.AddRange(pms);
}
con.Open();
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
}
//执行返回一张表,右边路线
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;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
juci.Text=(int.Parse(juci.Text)+1).ToString();
txtA.Text = "0";
txtB.Text = "0";
}
private void label4_Click(object sender, EventArgs e)
{
if (int.Parse(txtA.Text) > int.Parse(txtB.Text))
{
bisai.Text = juci.Text + "局 " + "比赛得分: " + "A队" + ":" + "B队" + "=" + txtA.Text + ":" + txtB.Text + " " + "A队 " + "胜" + " B队";
}
else
{
bisai.Text =juci.Text + "局" + "比赛得分: " + "A队" + ":" + "B队" + "=" + txtA.Text + ":" + txtB.Text + " " + "A队 " + "败" + " B队";
}
if (int.Parse(txtA.Text) == int.Parse(txtB.Text))
{
bisai.Text = juci.Text + "局 " + "比赛得分: " + "A队" + ":" + "B队" + "=" + txtA.Text + ":" + txtB.Text + " " + "A队 " + "平局" + " B队";
}
}
private void label1_Click(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
if (int.Parse(txtA.Text) - 1 > 0)
{
txtA.Text = (int.Parse(txtA.Text) - 1).ToString();
}
}
private void button3_Click(object sender, EventArgs e)
{
if (int.Parse(txtA.Text) - 1 > 0)
{
txtB.Text = (int.Parse(txtB.Text) - 1).ToString();
}
}
private void btnA_Click(object sender, EventArgs e)
{
txtA.Text=(int.Parse(txtA.Text)+1).ToString();
btnA.Enabled = true;
}
private void bunB_Click(object sender, EventArgs e)
{
txtB.Text=(int.Parse(txtB.Text)+1).ToString();
bunB.Enabled = true;
}
private void bisai_TextChanged(object sender, EventArgs e)
{
}
}
private void texguojia1_TextChanged(object sender, EventArgs e)
{
button1.Text = txtguojia1.Text+"胜";
}
private void texguojia2_TextChanged(object sender, EventArgs e)
{
button2.Text = txtguojia2.Text+"胜";
}
总结:
不是太会,运行结果没有出来!
排球计分程序