menzhen.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_menzhen : System.Web.UI.Page
{
    private string  id;
    private Double drugprice;
    private string perid;
    //private string perpsw;
    private string hosid;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["id"] == null)
            {
                if (Session["id"].ToString() == "")
                {
                    Response.Redirect("~/error.aspx");
                }
                else
                {
                  
                    Label3.Text = "";
                    Label2.Text = "10";
                    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();
                }
            }
            else
            {
                id =Request.QueryString["id"];
                string sql = "select * from adminuser where adminid=" + id;
                DataTable user = GenericDataAccess.ExecuteSelectCommand(sql, Page);

                Label1.Text = user.Rows[0]["adminname"].ToString();
 
            }
        }
    }
    protected void TextBox4_TextChanged(object sender, EventArgs e)
    {
        Double money =Convert.ToDouble( Label2.Text) * Convert.ToDouble(TextBox4.Text);
        Label3.Text = money.ToString();

    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string sql = "select drugprice from drug where drugname='" +DropDownList1.SelectedValue.ToString() + "'";
        DataTable price= GenericDataAccess.ExecuteSelectCommand(sql, Page);
        drugprice =Convert.ToDouble( price.Rows[0]["drugprice"]);
        Label2.Text = drugprice.ToString();
       
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Double money = Convert.ToDouble(Label2.Text) * Convert.ToDouble(TextBox4.Text);
        Label3.Text = money.ToString();
        if (checkconsumer(TextBox5.Text,TextBox2.Text))
        {
            string drugname = DropDownList1.SelectedValue.ToString();
           
            //hosid =Request.QueryString["id"];
            DateTime drugtime = DateTime.Today;
            double drugpermoney = Convert.ToDouble(Label2.Text);
            int drugnum = Convert.ToInt32(TextBox4.Text);
            double hosmoney;
            if (DropDownList2.SelectedValue == "普通门诊")
            { hosmoney = 2; }
            else
            { hosmoney = 10; }
            double totlemoney = hosmoney + drugpermoney * drugnum;
            perid = TextBox5.Text;
            bill b=new bill ();
            string a = Session["id"].ToString();
            hosid = b.adminidtohosid(Session["id"].ToString(),Page).Rows[0]["hosid"].ToString ();
            string sql = "insert into consume(personid,perhosid,trugtime,permoney,drugnum,drugname,totalmoney,permedmoney)values(" + perid + "," + hosid+ ",'" + drugtime + "'," + hosmoney + "," + drugnum + ",'" + drugname + "'," + totlemoney + "," + drugpermoney + ")";
            if (GenericDataAccess.ExecuteNonQuery(sql, Page) != 0)
            {

                Response.Write("<script language=javascript>alert('添加成功')</script>");
                TextBox5.Text = "";
                TextBox2.Text = "";

                DropDownList1.SelectedIndex = 0;
                TextBox4.Text = "0";
            }
            else
            {
                Response.Write("<script language=javascript>alert('添加失败')</script>");
            }

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

    protected bool checkconsumer(string id, string psd)
    {
        int sqlid = Convert.ToInt32(id);
        string sql = "select * from person where personid=" + sqlid + " and perpsw='" + psd + "'";
        DataTable a= GenericDataAccess.ExecuteSelectCommand(sql, Page);
        if (a.Rows.Count != 0) return true;
        else return false;
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("hospital.aspx");
    }
    //protected void TextBox5_TextChanged(object sender, EventArgs e)
    //{
    //    perid = TextBox5.Text;
        
    //}
    //protected void TextBox2_TextChanged(object sender, EventArgs e)
    //{
    //    perpsw = TextBox2.Text;
    //}
}