pay.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 BusinessSys_pay : System.Web.UI.Page
{
    string id = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["id"]==null)
        {
            Response.Redirect("~/error.aspx");
        }
        else
        {
            id = Session["id"].ToString();
            string sql = "select * from adminuser where adminid=" + id;
            DataTable user = GenericDataAccess.ExecuteSelectCommand(sql, Page);

            Label1.Text = user.Rows[0]["adminname"].ToString();
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string name = TextBox1.Text;
        string psw = TextBox2.Text;
        string sql = "select * from person where personname='"+name+"' and perpsw='"+psw+"'";
        DataTable per = GenericDataAccess.ExecuteSelectCommand(sql,Page);
        if (per.Rows.Count != 0)
        {
            Session["perid"] = per.Rows[0]["personid"];
            Session["pername"] = name;
            Session["perdepid"]=per.Rows[0]["departmentid"];
            Response.Redirect("paymenu.aspx");

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