moduserinfo.aspx.cs

图书销售系统源码

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;

public partial class UserCenter_ModUserInfo : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //绑定数据
            int userid = Convert.ToInt32(Session["UserID"].ToString());

            //读取数据库连接字符串
            string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
            //创建数据库连接
            SqlConnection myconn = new SqlConnection(settings);
            //打开数据库连接
            myconn.Open();

            SqlCommand mycmd = new SqlCommand("UserInfo", myconn);

            mycmd.CommandType = CommandType.StoredProcedure;

            //添加参数
            //用户编号
            SqlParameter paraUserID = new SqlParameter("@UserID", SqlDbType.Int);
            paraUserID.Value = userid;
            mycmd.Parameters.Add(paraUserID);
            //用户账号
            SqlParameter paraUserName = new SqlParameter("@UserName", SqlDbType.NVarChar, 12);
            paraUserName.Direction = ParameterDirection.Output;
            mycmd.Parameters.Add(paraUserName);
            //用户住址
            SqlParameter paraAddress = new SqlParameter("@Address", SqlDbType.NVarChar, 50);
            paraAddress.Direction = ParameterDirection.Output;
            mycmd.Parameters.Add(paraAddress);
            //用户真实姓名
            SqlParameter paraName = new SqlParameter("@Name", SqlDbType.NVarChar, 10);
            paraName.Direction = ParameterDirection.Output;
            mycmd.Parameters.Add(paraName);
            //电子邮件
            SqlParameter paraEmail = new SqlParameter("@Email", SqlDbType.NVarChar, 50);
            paraEmail.Direction = ParameterDirection.Output;
            mycmd.Parameters.Add(paraEmail);
            //身份证
            SqlParameter paraIDCardNo = new SqlParameter("@IDCardNumber", SqlDbType.NVarChar, 18);
            paraIDCardNo.Direction = ParameterDirection.Output;
            mycmd.Parameters.Add(paraIDCardNo);
            //电话号码
            SqlParameter paraTel = new SqlParameter("@TelephoneNumber", SqlDbType.NVarChar, 12);
            paraTel.Direction = ParameterDirection.Output;
            mycmd.Parameters.Add(paraTel);
            //邮政编码
            SqlParameter paraZip = new SqlParameter("@ZoneCode", SqlDbType.NVarChar, 10);
            paraZip.Direction = ParameterDirection.Output;
            mycmd.Parameters.Add(paraZip);
            //移动电话
            SqlParameter paraMobile = new SqlParameter("@MobilePhone", SqlDbType.NVarChar, 10);
            paraMobile.Direction = ParameterDirection.Output;
            mycmd.Parameters.Add(paraMobile);
            //OICQ
            SqlParameter paraoicq = new SqlParameter("@OICQ", SqlDbType.NVarChar, 20);
            paraoicq.Direction = ParameterDirection.Output;
            mycmd.Parameters.Add(paraoicq);
            //MSN
            SqlParameter paramsn = new SqlParameter("@MSN", SqlDbType.NVarChar, 50);
            paramsn.Direction = ParameterDirection.Output;
            mycmd.Parameters.Add(paramsn);
            //进行数据库操作
            mycmd.ExecuteNonQuery();
            //关闭数据库连接
            myconn.Close();

            lbl_user.Text = (string)paraUserName.Value;
            tbx_email.Text = (string)paraEmail.Value;
            tbx_IDCardNo.Text = (string)paraIDCardNo.Value;
            tbx_mobile.Text = (string)paraMobile.Value;
            tbx_address.Text = (string)paraAddress.Value;
            tbx_msn.Text = (string)paramsn.Value;
            tbx_oicq.Text = (string)paraoicq.Value;
            tbx_tel.Text = (string)paraTel.Value;
            tbx_zipcode.Text = (string)paraZip.Value;
            tbx_username.Text =(string) paraName.Value;
        }
    }
    protected void btn_mod_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            //绑定数据
            int userid =Convert.ToInt32( Session["UserID"].ToString());

            //读取数据库连接字符串
            string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
            //创建数据库连接
            SqlConnection myconn = new SqlConnection(settings);
            //打开数据库连接
            myconn.Open();

            SqlCommand mycmd = new SqlCommand("ModUserInfo", myconn);

            mycmd.CommandType = CommandType.StoredProcedure;

            //添加参数
            //用户编号
            SqlParameter paraUserID = new SqlParameter("@UserID", SqlDbType.Int);
            paraUserID.Value = userid;
            mycmd.Parameters.Add(paraUserID);

            //用户住址
            SqlParameter paraAddress = new SqlParameter("@Address", SqlDbType.NVarChar, 50);
            paraAddress.Value = tbx_address.Text;
            mycmd.Parameters.Add(paraAddress);

            //用户真实姓名
            SqlParameter paraName = new SqlParameter("@Name", SqlDbType.NVarChar, 10);
            paraName.Value = tbx_username.Text;
            mycmd.Parameters.Add(paraName);

            //电子邮件
            SqlParameter paraEmail = new SqlParameter("@Email", SqlDbType.NVarChar, 50);
            paraEmail.Value = tbx_email.Text;
            mycmd.Parameters.Add(paraEmail);

            //身份证
            SqlParameter paraIDCardNo = new SqlParameter("@IDCardNumber", SqlDbType.NVarChar, 18);
            paraIDCardNo.Value = tbx_IDCardNo.Text;
            mycmd.Parameters.Add(paraIDCardNo);

            //电话号码
            SqlParameter paraTel = new SqlParameter("@TelephoneNumber", SqlDbType.NVarChar, 12);
            paraTel.Value = tbx_tel.Text;
            mycmd.Parameters.Add(paraTel);

            //邮政编码
            SqlParameter paraZip = new SqlParameter("@ZoneCode", SqlDbType.NVarChar, 10);
            paraZip.Value = tbx_zipcode.Text;
            mycmd.Parameters.Add(paraZip);

            //移动电话
            SqlParameter paraMobile = new SqlParameter("@MobilePhone", SqlDbType.NVarChar, 10);
            paraMobile.Value = tbx_mobile.Text;
            mycmd.Parameters.Add(paraMobile);

            //OICQ
            SqlParameter paraoicq = new SqlParameter("@OICQ", SqlDbType.NVarChar, 20);
            paraoicq.Value = tbx_oicq.Text;
            mycmd.Parameters.Add(paraoicq);

            //MSN
            SqlParameter paramsn = new SqlParameter("@MSN", SqlDbType.NVarChar, 50);
            paramsn.Value = tbx_msn.Text;
            mycmd.Parameters.Add(paramsn);

            //进行数据库操作
            mycmd.ExecuteNonQuery();
            //关闭数据库连接
            myconn.Close();
            Response.Redirect("SuccessEdit.aspx");

        }
    }
}