login.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;

public partial class ConsumptionSys_login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (DropDownList1.SelectedValue == "医院管理员")
        {
            string name = TextBox1.Text;
            string psw = TextBox2.Text;
            string sql = "select * from adminuser where adminname='" + name + "'and adminpwd='" + psw + "'";
            DataTable user = GenericDataAccess.ExecuteSelectCommand(sql, Page);
            if (user.Rows.Count != 0)
            {
                string userid = user.Rows[0]["adminid"].ToString();
                string url = "menzhen.aspx?id=" + userid;
                Response.Redirect(url);

            }
            else
            {
                Response.Write("<script language=javascript>alert('用户名或密码错~')</script>");
            }
        }
        else if (DropDownList1.SelectedValue == "药店管理员")
        {
            string name = TextBox1.Text;
            string psw = TextBox2.Text;
            string sql = "select * from adminuser where adminname='" + name + "'and adminpwd='" + psw + "'";
            DataTable user = GenericDataAccess.ExecuteSelectCommand(sql, Page);
            if (user.Rows.Count != 0)
            {
                string userid = user.Rows[0]["adminid"].ToString();
                string url = "yaodian.aspx?id="+userid;
                Response.Redirect(url);

            }
            else
            {
                Response.Write("<script language=javascript>alert('用户名或密码错~')</script>");
            }
        }
    }
}