ASP.NET体育赛事信息发布网站(9)

来源:xiaoniu168.com 作者:本站原创 添加时间:2011-11-05 点击数:21745

计算机毕业设计赛季技术统计功能介绍:

4.5 赛季技术统计页面
在赛季技术统计列表里点击统计或查看按钮,进入赛季技术统计页面,在该页面里通过选择球队信息和对手,点击统计按钮,则系统自动计算得分、二分球、三分球、罚球、篮板前、篮板后、扣篮、助攻和抢断,输入场数和胜/负信息,点击保存统计结构按钮,系统存储各项信息;点击返回,返回赛季技术统计列表页面。如图所示:
计算机毕业论文

以下是引用片段:

 if (Request.QueryString["zdid"] != null)
            {
                //显示当前手动的统计信息
                DataTable dt = new DataTable();
                dt = db.GetData("SELECT sum(赛程个人表.PTS) as PTS, sum(赛程个人表.[2Points]) as [2Points], sum(赛程个人表.[3Points]) as [3Points], sum(赛程个人表.[Free Throw]) as [Free Throw] , sum(赛程个人表.Lbq) as lbq, sum(赛程个人表.Lbh) as lbh, " +
                   "sum(赛程个人表.DK) as DK, sum(赛程个人表.ST) as St, sum(赛程个人表.[AS]) as [as] FROM 赛程个人表 INNER JOIN 赛程 ON 赛程个人表.Scid = 赛程.Scid " +
                   " where ((zdbh=" + Request.QueryString["zdid"] + " and kdbh =" + Request.QueryString["kdid"] + " ) or (zdbh=" + Request.QueryString["kdid"] + " and kdbh =" + Request.QueryString["zdid"] + ")) and qyid in (select qyid from 球员 where  qdid ="+ Request.QueryString["zdid"] +")");
                if (dt.Rows.Count > 0)
                {
                    DropDownList1.SelectedValue = Request.QueryString["zdid"];
                    DropDownList2.SelectedValue = Request.QueryString["kdid"];
                    TextBox16.Text = dt.Rows[0]["2Points"].ToString();
                    TextBox1.Text = dt.Rows[0]["3Points"].ToString();
                    TextBox3.Text = dt.Rows[0]["Free Throw"].ToString();
                    TextBox7.Text = dt.Rows[0]["Lbq"].ToString();
                    TextBox11.Text = dt.Rows[0]["Lbh"].ToString();
                    TextBox12.Text = dt.Rows[0]["DK"].ToString();
                    Textbox5.Text = dt.Rows[0]["ST"].ToString();
                    TextBox9.Text = dt.Rows[0]["PTS"].ToString();
                    TextBox4.Text = dt.Rows[0]["AS"].ToString();
                }
            }
        }

〖资料来源:计算机毕业论文 www.xiaoniu168.com

第10页为计算机毕业论文论坛功能介绍......

【联系方式】

【本站信誉】

用心做计算机毕业设计论文网