userinfo.aspx.cs

本程序基于 asp.net 2.0 +sql server 2

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;
using lalablog;
public partial class tongxue_userinfo : System.Web.UI.Page
{
    int userid;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["userid"] != null)
        {
            this.userid = Convert.ToInt32(Session["userid"].ToString());
        }
        else
            Response.Redirect("userLogin.aspx?url=" + Server.HtmlEncode(Request.RawUrl));

        //如果在数据库中已存在用户信息则加载，如果没有存在则等待用户输入后保存
        if (!IsPostBack)
            getUserInfo();
    }

    private bool istongxue()
    {
        string sql = "select tid from tongxue where tid=" + this.userid;
        openDb o1 = new openDb(sql);
        string result = o1.getValue();
        if (result == "-1")
            return false;
        else
            return true;
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        //处理信息输入事件
        //生成tongxue表中的记录，id为 users表中的userid
        string realname = Server.HtmlEncode(tbRealName.Text);
        string bureau = Server.HtmlEncode(tbBureau.Text);
        string handset = Server.HtmlEncode(tbHandset.Text);
        string tele = Server.HtmlEncode(tbTele.Text);
        string qq = Server.HtmlEncode(tbQq.Text);
        string msn = Server.HtmlEncode(tbMsn.Text);

        string sql;
        //如果tongxue表中没有此用户，是insert语句，有这个用户，是update语句
        if (istongxue())
            {
            sql = "update tongxue set realname='" + realname + "',bureau='" + bureau+"'";
            sql += ",handset='" + handset + "',tele='" + tele + "'";
            sql += ",qq='" + qq + "',msn='" + msn + "'";
            sql += " where tid=" + this.userid;
            }
        else
            {
            sql = " insert into tongxue(tid,realname,bureau,handset,tele,qq,msn)";
        sql += " values(" + this.userid + ",'" + realname + "','" + bureau;
        sql += "','" + handset + "','" + tele + "','" + qq + "','" + msn + "')";
            }
        openDb o1 = new openDb(sql);
        string result = o1.update();

        myfunc m1 = new myfunc(result);
        Response.Write(m1.JavaMsg("index.aspx"));
    }

    private void getUserInfo()
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();

        string sql = "select * from tongxue where tid=" + this.userid;
        SqlCommand cm = new SqlCommand(sql, cn);

        SqlDataReader dr = cm.ExecuteReader();

        if (dr.Read())
        {
            tbRealName.Text = dr["realname"].ToString();
            tbBureau.Text = dr["bureau"].ToString();
            tbHandset.Text = dr["handset"].ToString();
            tbTele.Text = dr["tele"].ToString();
            tbQq.Text = dr["qq"].ToString();
            tbMsn.Text = dr["msn"].ToString();
        }
    
    }
}