登录.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 登录 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (this.TextBox1.Text == "")
        {
            Response.Write("<script>alert(' 请输入用户名！');</script>");
        }
        else
        {
            string myConnStr = "data source=.;database=物资管理系统;trusted_connection=SSPI";
            SqlConnection Conn = new SqlConnection(myConnStr);
            Conn.Open();

            string mysql = "select 用户名 from 用户表 where 用户名='" + TextBox2.Text + "'";
            SqlCommand cm = new SqlCommand(mysql, Conn);
            //         Conn.Close();


            SqlDataReader dr = cm.ExecuteReader();
            if (dr.Read())
            {
                dr.Close();
                string password = Convert.ToString(TextBox1.Text);
                string mysql1 = "select  * from 用户表 where 用户名='" + TextBox2.Text + "'and 密码='" + password + "'";
                SqlCommand cm1 = new SqlCommand(mysql1, Conn);
                SqlDataReader dr1 = cm1.ExecuteReader();
                if (dr1.Read())
                {
                    string str = dr1["部门名称"].ToString();


                    if (str.Trim() == "技术科")
                    {
                        Response.Redirect("物资信息查询.aspx");
                    }
                    else if (str.Trim() == "材料科")
                    {
                        Response.Redirect("物资信息查询.aspx");

                    }
                    if (str.Trim() == "供应科")
                    {
                        Response.Redirect("入库信息管理.aspx");
                    }
                    if (str.Trim() == "保管室")
                    {
                        Response.Redirect("库存信息管理.aspx");

                    }
                    if (str.Trim() == "销售科")
                    {
                        Response.Redirect("物资出库.aspx");

                    }
                    dr1.Close();
                }
                else
                {
                    Response.Write("<script>alert(' 密码错误！');</script>");
                    dr1.Close();
                }
            }
            else
            {
                dr.Close();
                Response.Write("<script>alert(' 该用户不存在,请先注册！');</script>");
            }
            Conn.Close();
        }
    }

    //注册
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("注册.aspx");
    }

    //change password
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("修改密码.aspx");
    }


    //exit
    protected void Button3_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("1首页.aspx");
    }

    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("1首页.aspx");
    }
}