membersAdm/Default.aspx.cs

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

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

public partial class membersAdm_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["name"] != null)
            {
                //初始化
                chushi();
            }
        }
    }

    /// <summary>
    /// 初始化
    /// </summary>
    protected void chushi()
    {
        StringBuilder strSql = new StringBuilder();
        strSql.Append(@"select * from members where lname='" + Session["name"].ToString()+"' " );

        //根据编号得到相应的记录
        DataSet ds =SqlHelper.ExecuteforDataSet(strSql.ToString());
        if (ds.Tables[0].Rows.Count > 0)
        {
            Label1.Text = ds.Tables[0].Rows[0]["lname"].ToString();
            Label2.Text = ds.Tables[0].Rows[0]["mname"].ToString();
            Label3.Text = ds.Tables[0].Rows[0]["regtime"].ToString();
            Label4.Text = Request.UserHostAddress;

            object ob = SqlHelper.ExecuteScalar("select count(*) from orders where lname='" + Session["name"].ToString()+"' ");

            if (ob != null)
            {
                HyperLink1.Text = ob.ToString();
                if (ob.ToString() != "0")
                {
                    HyperLink1.NavigateUrl = "od.aspx";
                }
            }
        }
    }
}