public class userinfor2
{
public string wanbi = "";
public string jifen = "";
public string dian = "";
public string WanBi
{
get { return wanbi; } }
public string JiFen
{
get { return JiFen; } }
public string Dian
{
get { return Dian; } }
/// <summary>
/// 获取用户最账户信息
/// </summary>
public void seluser()
{
using (SqlConnection cn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
{
cn.Open();
string id = mdcode.MD5Decrypt2(HttpContext.Current.Request.Cookies["userclient"]["id"], mdcode.sKey2);// "";//用户id
SqlCommand cm = new SqlCommand("select top 1 * from u_uinfor where uId=" + id + "", cn);
SqlDataReader dr = cm.ExecuteReader();
while (dr.Read())
{
wanbi = dr["Uwan"].ToString();
jifen = dr["Upoints"].ToString();
dian = dr["Umoney"].ToString();
}
dr.Close();
cn.Close();
}
}
}
调用的地方
protected void Page_Load(object sender, EventArgs e)
{
use.userinform ue = new use.userinform(); ue.seluser();
this.lbjifen .Text = ue.JiFen;
this.lbwanbi.Text = ue.WanBi;
this.lbdian.Text = ue.Dian;
}
{
public string wanbi = "";
public string jifen = "";
public string dian = "";
public string WanBi
{
get { return wanbi; } }
public string JiFen
{
get { return JiFen; } }
public string Dian
{
get { return Dian; } }
/// <summary>
/// 获取用户最账户信息
/// </summary>
public void seluser()
{
using (SqlConnection cn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
{
cn.Open();
string id = mdcode.MD5Decrypt2(HttpContext.Current.Request.Cookies["userclient"]["id"], mdcode.sKey2);// "";//用户id
SqlCommand cm = new SqlCommand("select top 1 * from u_uinfor where uId=" + id + "", cn);
SqlDataReader dr = cm.ExecuteReader();
while (dr.Read())
{
wanbi = dr["Uwan"].ToString();
jifen = dr["Upoints"].ToString();
dian = dr["Umoney"].ToString();
}
dr.Close();
cn.Close();
}
}
}
调用的地方
protected void Page_Load(object sender, EventArgs e)
{
use.userinform ue = new use.userinform(); ue.seluser();
this.lbjifen .Text = ue.JiFen;
this.lbwanbi.Text = ue.WanBi;
this.lbdian.Text = ue.Dian;
}
public string WanBi
{
get { return wanbi; }
set{wanbi=value;}
}
或public string wanbi {get;set;}
但执行起来非常慢不说,直接导致w3wp进程崩溃,试n边都那样