modifyuser.aspx.cs

2007年华中科技大学数据库课程设计参考程序[图书销售系统]+报告

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Collections.Generic;
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 OnlineBookSell.BLLFactory;
using OnlineBookSell.Model;
using OnlineBookSell.IBLL;
using OnlineBookSell.DBUtility;

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

    private IUserBLL iuserbll = BLLFactory.getInstance().createUserBLL();

    private UserInfo user;

    protected void Page_Load(object sender, EventArgs e)
    {
        
        user = iuserbll.GetUserById(Convert.ToInt32(Request ["userid"]));
        
        if (!IsPostBack)
        {
            
            sn.Text = user.Serialnumber;
            username.Text = user.Username;
            if (user.Sex == true)
                sex.SelectedIndex = 1;
            pwd.Text = user.Pwd;
            

            SqlDataReader r = SQLHelper.ExecuteReader(SQLHelper .ConnectionStringLocalTransaction,CommandType.Text,"select * from usertype");
            while (r.Read())
            {
                usertype.Items.Add(new ListItem(r["usertype_name"].ToString(), r["usertype_id"].ToString()));
            }
            usertype.SelectedIndex = usertype.Items.IndexOf(usertype.Items.FindByValue(user.Usertype_id.ToString()));

            SqlDataReader r2 = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, "select * from UserStatus");
            while (r2.Read())
            {
                status.Items.Add(new ListItem(r2["userstatus"].ToString(), r2["id"].ToString()));
            }
            status.SelectedIndex = status.Items.IndexOf(status.Items.FindByValue(user.Userstatusid.ToString()));
            idcard.Text = user.Idcard;
            email.Text = user.Email;
            address.Text = user.Address;
            tel.Text = user.Tel;
            code.Text = user.Postalcode;
            jifen.Text = user.Integral.ToString ();
            yue.Text = user.Rmb.ToString("0.00");
            youxiaoqi.Text = user.Periodofvalidity.ToShortDateString();
            beizhu.Text = user.Description;

        }

        
    }
    //protected void Page_Unload(object sender, EventArgs e)
    //{
    //    if (!IsPostBack)
    //    {
           

    //    } usertype.SelectedIndex = 4;
    //}


    protected void Button1_Click(object sender, EventArgs e)
    {
        user.Address = address.Text.Trim();
        user.Description = beizhu.Text.Trim();
        user.Email = email.Text.Trim();
        user.Idcard = idcard.Text.Trim();
        user.Integral = Convert.ToInt32(jifen.Text.Trim());
        user.Periodofvalidity = Convert.ToDateTime(youxiaoqi.Text.Trim());
        user.Postalcode = code.Text.Trim();
        user.Pwd = pwd.Text.Trim();
        user.Rmb = Convert.ToSingle(yue.Text.Trim());
        user.Serialnumber = sn.Text.Trim();
        user.Sex = sex.SelectedItem.Text == "男" ? false : true;
        user.Tel = tel.Text.Trim();
        user.Username = username.Text.Trim();
        user.Userstatusid = 1;
        user.Usertype_id = Convert.ToInt32(usertype.SelectedValue);
        user.Userstatusid = Convert.ToInt32(status .SelectedValue);

        if (iuserbll.UpdateUser(user) != null)
        {
            System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.Button1, this.Button1.GetType(), "success", "alert('修改成功!');", true);
            
        }
        else
            System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.Button1, this.Button1.GetType(), "success", "alert('发生错误,请刷新页面重试!');", true);
    }
}