paiming.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class paiming : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack == false)
        {
            DataBase db = new DataBase();
            db.OpenDataBase();
            
            string str3 = "select name,zf=sum(YW_chengji+SX_chengji+YY_chengji),mc=identity(int,1,1) into paiming from chengji group by name order by sum(YW_chengji+SX_chengji+YY_chengji) desc ";
            string str2 = "drop table paiming";
            SqlCommand cmd = new SqlCommand(str2, db.CONN);
            cmd.ExecuteNonQuery();
            cmd.CommandText = str3;
            cmd.ExecuteNonQuery();
            string str1 = "select name,zf,mc from paiming";
            SqlDataAdapter da = new SqlDataAdapter(str1, db.CONN);
            DataSet ds = new DataSet();
            da.Fill(ds, "paiming");
            GridView1.DataSource = ds;
            GridView1.DataBind();
           


                db.CloseDataBase();
        }
        

    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        DataBase db = new DataBase();
        db.OpenDataBase();
        string str1 = "select name,zf,mc from paiming";
        SqlDataAdapter da = new SqlDataAdapter(str1, db.CONN);
        DataSet ds = new DataSet();
        da.Fill(ds, "paiming");
       
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataSource = ds;         //引用刚才建立的数据源
        GridView1.DataBind();
        db.CloseDataBase();

    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        int numCount = GridView1.Rows.Count;
        if (GridView1.PageIndex == GridView1.PageCount - 1)     //尾页
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                // 计算自动填充的行数