check.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;
using System.Data.OleDb;
using System.Data.SqlClient;

public partial class Check : System.Web.UI.Page
{
    static string strAdminName = ""; 
    static string strHighMark = "";

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Admin"].ToString().Equals("pass"))
        {
            strAdminName = Session["UserName"].ToString();
            Response.Write("welcome,dear " + strAdminName);
            btnBack.Visible = true;
           txtCheckDate.Text = System.DateTime.Now.ToString();
           txtAdminName.Text = strAdminName;  
        }     
    }
    protected void btnRegist_Click(object sender, EventArgs e)
    {
        GridView1.Visible = true;
        double dMark = 0.0;
        double dHighMark = 0.0;
        Random ra = new Random();
        int iRandom = ra.Next(1000000);
        dMark = double.Parse(txtMark.Text);
        OleDbConnection conn = new OleDbConnection();
        string connStr = "Provider =Microsoft.Jet.OLEDB.4.0;Data Source = " + Server.MapPath("App_Data/Nurse.mdb");
        conn.ConnectionString = connStr;
        string strSql = "insert into Grade values('"+ iRandom.ToString()+ "','" + txtNurseName.Text + "','"
             + ddlItems.SelectedValue + "','" + ddlDetails.SelectedValue + "','"
             + System.DateTime.Now.ToString() + "'," + double.Parse(txtMark.Text) + ");";
        string strSql1 = "select GradeID,NurName,RecordDate,Grade from Grade;";
        conn.Open();
        OleDbCommand intComm = new OleDbCommand(strSql, conn);
        OleDbCommand selComm = new OleDbCommand(strSql1, conn);
        intComm.ExecuteNonQuery();
        lblResult.Text = "操作成功";
        OleDbDataAdapter da = new OleDbDataAdapter();
        da.SelectCommand = selComm;
        DataSet ds = new DataSet();
        da.Fill(ds, "Grade");
        GridView1.DataSource = ds.Tables["Grade"].DefaultView;
        GridView1.DataBind();     
        conn.Close();
    }
    protected void btnCancel_Click(object sender, EventArgs e)
    {
        txtCheckDate.Text = System.DateTime.Now.ToString();
        ddlDepart.SelectedValue = "请选择：";
        txtNurseName.Text = "";
        txtAdminName.Text = strAdminName;      
    }
    protected void btnBack_Click(object sender, EventArgs e)
    {
        Session["UserName"] = strAdminName;
        Server.Transfer("AdminLogin.aspx");
    }
    protected void btnOut_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default.aspx?");
    }
}