YHJIAOF.aspx.cs

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

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

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;

public partial class YHJIAOF : System.Web.UI.Page
{
    SQLHelper sqlHelper = new SQLHelper();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.bind();
            if (this.GridView1.Rows.Count < 1)
            {
                this.Label1.Text = "还没有缴费记录！";

            }
            else
            {
                string sql = "select sum(FJE) as zje from feiyong where  Uid='" + Session["name"].ToString() + "'";
                DataSet dt = new DataSet();
                dt = sqlHelper.ExecuteDataSet(sql);
                if (dt.Tables[0].Rows.Count > 0)
                {
                    this.Label2.Text = dt.Tables[0].Rows[0]["zje"].ToString();
                }
            }
        }
    }
    public void bind()
    {
        GridView1.DataSource = sqlHelper.ExecuteDataSet(
            "select * from feiyong where  Uid='" + Session["name"].ToString() + "'").Tables[0].DefaultView;
        GridView1.DataKeyNames = new string[] { "id" };
        GridView1.DataBind();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        this.bind();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        try
        {
            //string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
            //sqlHelper.ExecuteNonQuery("delete from Users where id=" + id);
            //this.bind();
        }
        catch
        { }
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)