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

    }
    protected void add_Click(object sender, EventArgs e)
    {
        string sql = "insert into [adminuser](adminname,adminpwd,type,email) values('"+TextBox1.Text.Trim()+"','"+TextBox2.Text.Trim()+"','"+DropDownList1.SelectedValue.ToString()+"','"+TextBox3.Text.Trim()+"')";
        if (GenericDataAccess.ExecuteNonQuery(sql,Page) != 0)
        {
            admin id=new admin ();
            string adminid = id.ReInfo(TextBox1.Text, TextBox2.Text, Page).Rows[0]["adminid"].ToString();
            
            if (DropDownList1.SelectedIndex == 0)
            {

                string sqldrug = "insert into [drugstore](drugstorename,drugadminid) values('"+TextBox1.Text+"',"+Convert.ToInt32(adminid)+")";
                GenericDataAccess.ExecuteNonQuery(sqldrug, Page);

            }
            else if (DropDownList1.SelectedIndex == 1)
            {
                string sqlhos = "insert into [hospital](hosname,hosadminid)values('"+TextBox1.Text+"',"+Convert.ToInt32(adminid)+")";
                GenericDataAccess.ExecuteNonQuery(sqlhos, Page);
            }
            else if (DropDownList1.SelectedIndex == 2)
            {
                string sqldep = "insert into [department](dename,adminid)values('"+TextBox1.Text+"',"+Convert.ToInt32(adminid)+")";
                GenericDataAccess.ExecuteNonQuery(sqldep, Page);
            }
           
            Response.Write("<script language=javascript>alert('成功!')</script>");
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Session.Abandon();
        Response.Redirect("~/Default.aspx");
    }
}