studentxz.aspx.cs

小型物理试验管理系统Management system for small-scale physical experiments

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.SqlClient;

public partial class StudentXZ : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Label1.Text = Session["uid"]+"";
        GridViewBind();
    }

    private void GridViewBind()
    {
        string myConnectionString = "server=localhost;uid=sa;pwd=;database = WXJ;";
        SqlConnection myConnection = new SqlConnection();
        myConnection.ConnectionString = myConnectionString;
        string cmdString = "select enumber,ename,edate,eaddress,echarger,total,selected from shiyan";
        SqlDataAdapter myAdapter = new SqlDataAdapter(cmdString, myConnection);
        myConnection.Open();
        DataSet mySet = new DataSet();
        myAdapter.Fill(mySet);
        myGridView.DataSource = mySet;
        myGridView.DataBind();
        myConnection.Close();
    }

    protected void myGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
     
    }
    protected void myGridView_RowEditing(object sender, GridViewEditEventArgs e)
    {
      
    }
    protected void myGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        
    }
    protected void PageCut_Click(object sender, EventArgs e)
    {
        int row = myGridView.SelectedIndex;
        string g1 = myGridView.Rows[row].Cells[0].Text;//实验号
        string g2 = myGridView.Rows[row].Cells[1].Text;//实验名称
        string g3 = myGridView.Rows[row].Cells[2].Text;//实验时间
        string g4 = myGridView.Rows[row].Cells[3].Text;//实验地点
        string g5 = myGridView.Rows[row].Cells[4].Text;//实验教师
        string g6 = myGridView.Rows[row].Cells[5].Text;//总人数
        int i = Convert.ToInt32(g6);
        string g7 = myGridView.Rows[row].Cells[6].Text;//已选人数
        int ii = Convert.ToInt32(g7);        
        string date = System.DateTime.Now.ToString();//选课时间
        string datetime = date.Substring(0, 18);
        string number = Convert.ToString(Session["number"]);

        if (ii < i)
        {
            ii++;
            SqlConnection myconnection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            DBConnection conn = new DBConnection();
            string sql = "select * from xuanke where snumber='" + number + "'and enumber='" + g1 + "'";

            SqlDataReader recm = conn.ExecuteReader(sql);
            if (recm.Read())
            {
                Label2.Text = "您已选择该实验！";
            }
            else
            {
                recm.Close();
                string sqlstr = "insert into xuanke values('" + number + "','" + g1 + "','" + g2 + "','" + g3 + "','" + g4 + "','" + g5 + "','" + datetime + "','" + 0 + "','" + i + "','" + ii + "')";
                SqlDataReader rs = conn.ExecuteReader(sqlstr);
                rs.Close();
                sql = "update shiyan set selected='" + ii + "'where enumber ='" + g1 + "'";
                SqlDataReader rs1 = conn.ExecuteReader(sql);
                rs1.Close();
                sql = "update xuanke set selected='" + ii + "'where enumber ='" + g1 + "'";
                SqlDataReader rs2 = conn.ExecuteReader(sql);
                Label2.Text = "选课成功！";
            }
        }
        else 
        {
            Label2.Text="该实验已达人数上限！请选择其他实验！";
        }

        
        /*string commandArg = ((LinkButton)sender).CommandArgument;
        switch (commandArg)
        {
            case "First":
                myGridView.PageIndex = 0;
                break;
            case "Prev":
                myGridView.PageIndex = (int)Math.Max(0, myGridView.PageIndex - 1);
                break;
            case "Next":
                myGridView.PageIndex = (int)Math.Min(myGridView.PageCount - 1, myGridView.PageIndex + 1);
                break;
            case "Last":
                myGridView.PageIndex = myGridView.PageCount - 1;
                break;
        }*/
        GridViewBind();
    }
    protected void myGridView_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        
    }
}