SysManage/TongJiList.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class SysManage_TongJiList : System.Web.UI.Page
{
    protected string xueqiid = "3";
    protected string xueqiname = "2013年上学期";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!string.IsNullOrEmpty(Request.QueryString["xueqiid"]))
            xueqiid = Request.QueryString["xueqiid"];

        if (!string.IsNullOrEmpty(Request.QueryString["xueqiname"]))
            xueqiname = Request.QueryString["xueqiname"];

        if (!IsPostBack)
        {
            DB.Bind_Dropdownlist("select * from XueQi order by xueqiid desc", ddlXueQi, "xueqiid", "xueqiname");
            ddlXueQi.SelectedValue = xueqiid;
            Get_Data();
        }
    }

    /// <summary>
    /// 绑定数据
    /// </summary>
    void Get_Data()
    {
        string sql = "select jiaoshiid,jiaoshiname";
        sql += " ,(select top 1 sum(fenshu+fenshu2+fenshu3+fenshu4) from PingFen where JiaoShiId=JiaoShi.JiaoShiId and XueQiId=" + xueqiid + ") as PingZongFen";
        sql += " ,(select top 1 (fenshu+fenshu2+fenshu3+fenshu4)/4 from PingFen where JiaoShiId=JiaoShi.JiaoShiId and XueQiId=" + xueqiid + ") as PingJunFen";
        sql += " ,(select top 1 sum(fenshu+fenshu2+fenshu3+fenshu4+fenshu5+fenshu6) from TeShu where JiaoShiId=JiaoShi.JiaoShiId and XueQiId=" + xueqiid + ") as TeZongFen";
        sql += " ,(select top 1 (fenshu+fenshu2+fenshu3+fenshu4+fenshu5+fenshu6)/6 from TeShu where JiaoShiId=JiaoShi.JiaoShiId and XueQiId=" + xueqiid + ") as TeJunFen";
        sql += " from JiaoShi";

        this.rptList.DataSource = DB.getDataTable(sql);
        this.rptList.DataBind();
    }

    protected void ddlXueQi_SelectedIndexChanged(object sender, EventArgs e)
    {
        Response.Redirect("tongjilist.aspx?xueqiid=" + ddlXueQi.SelectedValue + "&xueqiname=" + Server.UrlEncode(ddlXueQi.SelectedItem.Text));
    }


}