index.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 Index : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        this.UserName.Focus();
    }
    //public string clearStatus()
    //{
    //    string _DisUser;
    //    _DisUser = "<script language='javascript'>window.status='您已经成功退出系统！感谢您的使用！</script>";
    //    return _DisUser;
    //}
    public string getSessionInfo(string DispUser, string LoginTime)
    {
        string _DisUser;
        _DisUser = "<script language='javascript'>window.status='登陆用户:" + DispUser;
        _DisUser += "  登陆时间:" + LoginTime + "'</script>";
        return _DisUser;
    }
    protected void LoginBtn_Click(object sender, EventArgs e)
    {


        SqlConnection conn;
        SqlCommand cmd;
        SqlDataReader sDr;
        if (Page.IsValid)
        {
            conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connection"]);
            cmd = new SqlCommand("select * from userinfosheet where UserName='" + UserName.Text + "' and PassWord='" + UserPass.Text + "'", conn);
            conn.Open();
            sDr = cmd.ExecuteReader();
            if (sDr.Read())
            {
                //返回到先前所访问页面
                Session["CurrUser"] = sDr["Code"].ToString();
                Session["DispUser"] = sDr["UserDispName"].ToString();
                Session["LoginTime"] = System.DateTime.Now;
                //Page.RegisterStartupScript("", "<script>history.go(-1);</script>");
                if (Request.Params["handle"] != null)
                {  
                    //Page.RegisterClientScriptBlock("", getSessionInfo(Session["DispUser"].ToString(), Session["logintime"].ToString()));
                    Response.Write(getSessionInfo(Session["DispUser"].ToString(), Session["logintime"].ToString()));
                    Server.Transfer(Request.Params["handle"].ToString(),true);
                }
                else
                {
                    //退出系统代码
                    //Page.RegisterStartupScript("", clearStatus());
                    Response.Write(getSessionInfo(Session["DispUser"].ToString(), Session["logintime"].ToString()));
                   Server.Transfer("initmain.htm");
                }
            }
            else
                this.UserName.Focus();
        }

    }
}