Backup/XDF/Admin/StudentInput.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using BLL;

namespace XDF.Admin
{
    public partial class StudentInput : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string baseid = Session["UserID"].ToString().Substring(0, 4);
            LabelBaseID.Text = baseid;
        }

        protected void ButtonReturn_Click(object sender, EventArgs e)
        {
            Response.Redirect("~/Admin/AdminDefault.aspx");
        }
        private string getNumber(string baseID, string date)
        {
            string result = "";
            try
            {
                // 1. 创建连接
                SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

                // 2. 打开连接
                connection.Open();

                // 2.1 创建命令对象
                SqlCommand command = null;


                command = new SqlCommand("select count(StuID) from Student where LEFT(StuID,12)=@BaseID+@Date", connection);

                command.Parameters.AddWithValue("@BaseID", baseID);
                command.Parameters.AddWithValue("@Date", date);


                // 2.2 执行命令对象
                result = command.ExecuteScalar().ToString();

                // 3. 关闭连接
                connection.Close();
            }
            catch (Exception e)
            {
                ;
            }

            return result;
        }

        protected void ButtonInput_Click(object sender, EventArgs e)