addperson.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_addPerson : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string name = "";
            if (Session["name"].ToString() != "")
            {
                name = Session["name"].ToString();
                Label1.Text = name;

            }
            else
            {
                Response.Redirect("~/error.aspx");
            }
        }


    }
    protected void BtnAdd_Click(object sender, EventArgs e)
    {
        int id;
        
        string departmentname = Label1.Text;
        string sql1="select * from department where dename='"+departmentname+"'";
        id=Convert.ToInt32( GenericDataAccess.ExecuteSelectCommand(sql1,Page).Rows[0]["depid"].ToString());
        string sex;
        if (DDLGender.SelectedValue == "female")
        {
            sex = "女";
        }
        else
        {
            sex = "男";

        }
        string pername = TBName.Text;
        string psw = TextBox1.Text;
        string sql = "insert into person (personname,perpsw,departmentid,personsex)values('"+pername+"','"+psw+"',"+id+",'"+sex+"')";
        if( GenericDataAccess.ExecuteNonQuery(sql,Page)!=0)
        {
            Response.Write("<script language=javascript>alert('插入成功')</script>");
            TBName.Text = "";
            TextBox1.Text = "";

        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("~/BusinessSys/depedit.aspx");
    }
}